Prev
Next
Forums S3 Systems Administration

importdb converting csv empty field to 0

Sort:
You are not authorized to post a reply.
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.

      You are not authorized to post a reply.