Import Action not working

[kklosson]

I have an import function for end users that employs the IMPORT action:

IMPORT [object] FROM [file] WITH VALIDATION

This has worked fine for years and I have not altered anything since instituting it. It gets used but I am unsure how often but I recently got a report that it was claiming the header column did not match the attribute name:

Screenshot_8.png (11.72 KiB) Viewed 20099 times

I checked and it's fine. When I moved a different column to the first column, I got the same error on that column. This validates it is reading the correct file.

Here's the file...

Screenshot_9.png (4.33 KiB) Viewed 20099 times

No starting or trailing spaces. It's perfect.

Can anyone validate it's working for you?
Can support confirm this action is working on your own test applications?

[PointsWell]

What does the CSV file look like when opened in a text editor? Excel hides many sins.

[kklosson]

Good on you!
You got me thinking. The doc looked fine in a text editor. However, I saved it as TXT using ANSI (usually cleans our the boogers). renamed it to .csv. Then it worked.

Good job and many thanks!

[PointsWell]

If that is the case then check the text encoding of the database and the csv file (and if it was extracted from a database then the encoding of the source database)

[kklosson]

This file is from a customer who got it from some other unknown source. I'm just happy to close the case with a lesson learned.