[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
NULL.
This would not fix the problem if the fields are out of line. The data
imported would just be garbage.
David
> 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
HTH,
David
--
David Christensen
End Point Corporation
david at endpoint.com
785-727-1171
More information about the interchange-users
mailing list