Mailing List Archive

> On Dec 5, 2016, at 2:28 PM, David_e@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@endpoint.com
785-727-1171




_______________________________________________
interchange-users mailing list
interchange-users@icdevgroup.org
http://www.icdevgroup.org/mailman/listinfo/interchange-users

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@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@endpoint.com
785-727-1171







_______________________________________________
interchange-users mailing list
interchange-users@icdevgroup.org
http://www.icdevgroup.org/mailman/listinfo/interchange-users