Need help using LEI Administrator for data export

HCL Domino Domino Forum
1

I am trying to do export from lotus notes base to oracle table.I have problem with converting data during the process. I have lotus data field which is type date, and field in oracle table that is of type text.

When using this formula in connection document for data transformation i am getting error:

Error: Field type mismatch: ‘Planirani početak’ Source Connector field is type Datetime, Target Connector field is type Text,

formula that i use for data transformation:

FIELD PlanPoc := @If(PlanPoc = “”; “(no data)”;@text(PlanPoc));

—PlanPoc is field in lotus notes document, that is of date/time type

2

Subject: Need help using LEI Administrator for data export

Try

FIELD PlanPoc := @If(@text(PlanPoc) = “”; “(no data)”;@text(PlanPoc));