bn529

I am getting a error message trying to load BN529. The error message is CSV Hdr Read Error: FLD Name C-0-M-P-A-N-Y NOT FOUND. It looks like it is trying to find the header record. One the jobdef I said header was on. But I am getting this message of each of the header columns.

files_for_dEPM-655 - Series How to Publish Data from dEPM - Part 1.zip

Find more posts tagged with

Infor Lawson Human Resources Group - Discussion

Comments

mstephens

I received several errors trying to load the ACAOFRCSV file via BN529 as well and finally figured out some of the "quirks" through trial and error. I have found that the headers have to be in the exact same format as the file layout. For example, if you have COMPANY in all caps in your header field, the file will not process. It has to be "Company". Additionally, I have seen this error several times "Invalid Character value for cast specification" which means your date format is most likely incorrect. The BN529 will only allow m/dd/yyyy as date format. Attaching a file layout I used to successfully load offers via BN529.

[Updated on 1/5/2016 8:58 AM]

unknown

Thanks so much for the spreadsheet. I am also getting the cast errors. I changed the jobdef to mm/dd/ccyy. But still will not run what was created by the BN729. Can you tell me what else you did. thanks so much

unknown

When using date format mm/dd/yyyy make sure in the CSV file you input full date including leading zeroes, i.e. 04/01/2015, instead of 4/1/2015. The date fields can be formatted as TEXT and saved. But if you reopen the CSV file and make changes, before saving you'll need to reformat the date column as TEXT with the full date again, i.e. 04/01/2015. Partial date, i.e. 4/1/2015 won't be able to process. CSV drops the leading zeroes. Hope that helps.

Copyright © 2025 Infor. All rights reserved.