[ic] export.import on upgrade

David_e at charter.net David_e at charter.net
Tue Dec 6 18:42:27 UTC 2016

Might not be a good thing to define the user ID or the order number as a 

This would not fix the problem if the fields are out of line. The data 
imported would just be garbage.


> On Dec 5, 2016, at 2:28 PM, David_e at charter.net wrote:
> The main problem is that we are getting a null field error in the customer 
> id field on line 2 of the import. The field has correct data so I am 
> assuming that there is some extra data in the old export that is causing a 
> shift. I see that the file format has changed.

Do you have the exact error message?  It may be helpful to define the 
PREFER_NULL attribute in that field’s data declaration; i.e.:

Database my_table_name PREFER_NULL field_name


David Christensen
End Point Corporation
david at endpoint.com

More information about the interchange-users mailing list