• Search Forums
    Advanced Search Topics Posts
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 Send Private Message
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 Send Private Message
Posts: 477
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 Send Private Message
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 Send Private Message
Posts: 477
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 Send Private Message
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