Prev
Next
Forums Infor / Lawson Platforms S3 Systems Administration

importdb converting csv empty field to 0

 1 Replies
 0 Subscribed to this topic
 27 Subscribed to this forum
Sort:
Author
Messages
des123
Advanced Member
Posts: 24
Advanced Member
6/8/2012 6:21 PM
    In our test environment, when we upload a CSV file into a Lawson tables (OIINVOICE and OIINVCLINE) the importdb utility is converting empty fields to 0 value fields.  We could use BL98 to update the invoices but there too many to handle for this and this does not happen in our production environment.

    Does anyone know why importdb does this and how to prevent it?

    Thanks
    J Haveman
    New Member
    Posts: 3
    New Member
    3/15/2018 10:34 PM

      Certain fields cannot be null.  If numeric fields are attempting an empty load, imdbb will insert a zero instead.