Error on importdb

Sort:
You are not authorized to post a reply.
Author
Messages
JonA
Veteran Member
Posts: 1162
Veteran Member

    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: 468
    Veteran Member
      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: 1162
      Veteran Member

        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: 468
        Veteran Member
          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
            It’s getting E_COST from averagE_COST, the first field with the underscore.
            Raghu is correct, underscores are not valid in field names
            You are not authorized to post a reply.