Dataports importing data

viriato

When using a dataport to import data, is it possible to mix data fields that are actually a field in the table and a "variable" field that will be manipulated before being inserted in the table.

Thanks and a nice weekend to all.

DaveT

Hi,

Yes with dataport you can write update code for other fields/table and/or manipulation.

If you give a better explanation we can point you in the right direction.

kine

It is just on you into what the data will be read into. There can be variable or field as you wish...

DenSter

Each dataport field has validation triggers as well that you can use, say to format a date in a certain way, or to ensure that an incoming string doesn't exceed the field's length. Open the dataport in design, open the dataport fields list, put the cursor on one of the fields and hit F9. You'll see an OnAfterFormatField trigger (before it is written to the export file) and an OnBeforeEvaluateField (before the value is entered into the field).

viriato

Thanks for the recommendations.

What I am doing is exporting data from the customers table, most fields are the same but there's a couple of fields that need to be "manipulated" before inserting into the new customer database table.


Thanks.