Running a CSV import from script (N/task) I'm gett...
# suitescripts
Shawn Talbert
09/26/2022, 9:38 PMRunning a CSV import from script (N/task) I'm getting date format errors that don't seem to make sense to me. Anyone seen something like this before? when doing
csvTask.submit()FAILED_TO_SUBMIT_JOB_REQUEST_1Failed to submit job request: Date field not in your preferred date format for field "Date" : 57 You have entered an Invalid Field Value 09/21/2022 for the following field: trandate : 4 You have entered an Invalid Field Value 09/22/2022 for the following field: trandate : 53.k
karlenigma
09/26/2022, 9:59 PMWhat is the date format for the user/company preference? That normally would be the cause.
s
Shawn Talbert
09/26/2022, 10:02 PMM/D/YYYY, I also reset it to MM/DD/YYYY - same error
Shawn Talbert
09/26/2022, 10:02 PMalso, same file, when imported using the UI rather than N/task, works 😞
Shawn Talbert
09/26/2022, 10:03 PMI suspect it's something to do with the fact that the script runs as the
-System-k
karlenigma
09/26/2022, 10:03 PMYep it will be and would use the company preference not the user preference
karlenigma
09/26/2022, 10:03 PMI suspect anyway.
s
Shawn Talbert
09/26/2022, 10:04 PMRight, so the formats I mentioned above are the company pref setting. Anyone know what the numbers after the colon indicate in the error message? like
57Shawn Talbert
09/26/2022, 10:05 PMand thanks for noodling this with me @karlenigma
k
karlenigma
09/26/2022, 10:06 PMThe field type does seem odd
karlenigma
09/26/2022, 10:07 PMThis is the type of error that would have my throwing my laptop! 😂
s
Shawn Talbert
09/26/2022, 10:07 PMI don't know if I've ever ran CSV imports from script this way, but it's an existing solution I'm trying to diagnose.
Shawn Talbert
09/26/2022, 10:08 PMthat error message feels more like a CSV-import-specific wording than typical SuiteScript
k
karlenigma
09/26/2022, 10:08 PMYeah nor me.
d
dbarnett
09/27/2022, 12:56 PMidk if helps at all, but just saw this pg entry matched some of the verbiage: https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/section_4570011199.html
maybe the number is the matching internalid, formid, or CSV row# etc. - all just random guesses off the top of my head 😂
maybe better luck posting in csvimports channel as well
s
Shawn Talbert
09/27/2022, 2:48 PMThanks @dbarnett, didn't know such a channel existed. I think I narrowed this down to a date format discrepancy. I searched quite a bit the only thing I could find is the
-System--System-b
battk
09/27/2022, 2:51 PMredo the trandate mapping using a user that uses the company's date format
battk
09/27/2022, 2:51 PMmake sure the csv file matches
battk
09/27/2022, 2:51 PMdo not use excel
battk
09/27/2022, 2:52 PMor any other spreadsheet program to confirm the file format in the csv
s
Shawn Talbert
09/27/2022, 2:56 PM@battk Are you suggesting the date format is dictated by the user [date preferences setting] that created the mapping?
Shawn Talbert
09/27/2022, 3:03 PMthe only clue I found is the top level sub is set to DD/MM/YYYY whereas the company is MM/DD/YYYY. It appears the CSV import is forcing DD/MM/YYYY format when invoked via N/task.
k
karlenigma
09/27/2022, 3:04 PMThat is what I was alluding to the other day. Maybe I should have been clearer 😂
s
Shawn Talbert
09/27/2022, 3:18 PMwhich part are you referring to @karlenigma? 🙂
b
battk
09/27/2022, 3:22 PMit shouldnt be unless it was hardcoded
battk
09/27/2022, 3:22 PMredo it anyways
battk
09/27/2022, 3:27 PMits also really weird to have the top level subsidiary have a different date format to the company's general preferences
battk
09/27/2022, 3:27 PMthey are supposed to be the same data behind the scenes
s
Shawn Talbert
09/28/2022, 4:05 AMIn this case the top level sub is in a country with a different format.... my guess is the top level sub is used for reporting for some folks but the bulk of the business is recorded against the child sub
10 Views