[ic] export.import on upgrade

[David_e at charter.net]

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