Dataports - Importing data

viriato

1. Question
When importing some data into a customer is there another way besides doing it manually for each field to validate the data?

2. Question
If I want to add on record and just fill in the fields that I am importing and fill up all the other fields with defaults values, how would you recommend to do it?

Big Thanks.

matttrax

1. No, you have to validate each field.

2. Either do a Customer.INIT in the OnBeforeImportRecord trigger. Or assign values field by field in the OnAfterImportRecord trigger.

kine

ad 1) What does it mean "manually"? You mean "by code"? Do not forget that there is hidden field inthe Dataport Fields form with name "CallFieldValidate" and if you check it, it will validate the field for you...

viriato

Thanks guys. With saying manually I ment by code.

kine

In case of using CallFieldValidate the validation will be in order of the fields, and this can be sometime problem, when the validation is clearing some fields, which were imported before the validated field. It is why I rather use the code than using this way...

DenSter

If I need to do anything other than straight importing new records I always like to import into variables and handle field population by C/AL code. Create a variable for each field, and enter them In the dataport fields window. In the OnAfterImportRecord trigger you can then write code to put the values into the database.

viriato

Sounds like importing into variables is the safest way and gives you the best flexibility. Thanks again.