Prev
Next
Forums Supply Chain Management Lawson S3 Supply Chain

Error on importdb

 4 Replies
 0 Subscribed to this topic
 38 Subscribed to this forum
Sort:
Author
Messages
JonA
Veteran Member
Posts: 1163
Veteran Member
9/14/2019 7:09 PM

    Trying to importdb to ITEMLOC and getting this error.

     

    importdb -afu test10 itemloc ITEMLOC.csv

    ' Does Not ExistE-COST

    Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
    Ragu Raghavan
    Veteran Member
    Posts: 475
    Veteran Member
    9/14/2019 7:27 PM
      It seems to be erroring out on a column named E-COST. Do have have such a column on the file ITEMLOC.csv?
      JonA
      Veteran Member
      Posts: 1163
      Veteran Member
      9/14/2019 7:39 PM

        No I don't.  This is the first few lines of the file.

         

        COMPANY,LOCATION,ITEM,AVERAGE_COST,LAST_REC_COST,LAST_ISS_COST
        10,WBR,92013,387.301,387.301,387.301
        10,WBR,119791,334.7,334.7,334.7
        10,WBR,10312,321.52,321.52,321.52
        10,WBR,22596,298.35,298.35,298.35
        10,WBR,93785,297.91,297.91,297.91
        10,WBR,119836,217.55,217.55,217.55
        10,WBR,119965,211.58,211.58,211.58
        10,WBR,62936,200,200,200
        10,WBR,86180,194.48,194.48,194.48

        Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
        Ragu Raghavan
        Veteran Member
        Posts: 475
        Veteran Member
        9/14/2019 7:52 PM
          I do not think underscores are allowed. try changing AVERAGE_COST to AVERAGE-COST and replacing all other undercores by hyphens
          Kwane McNeal
          Veteran Member
          Posts: 479
          Veteran Member
          9/14/2019 10:16 PM
            It’s getting E_COST from averagE_COST, the first field with the underscore.
            Raghu is correct, underscores are not valid in field names