I have a weird problem.

I run a fairly simple IMPORT TABLE script:

IMPORT TABLE "WebOrderPreliminary"
 FROM "Test-Nov27.csv"
 IN STORE "Imports"
 FORMAT DELIMITED
 ENCODING AUTO
 DELIMITER CHAR #9
 QUOTE CHAR '"'
 DATE FORMAT 'yyyy-mm-dd'
 TIME FORMAT 'hh:mm:ss n' AM LITERAL 'AM' PM LITERAL 'PM'
 DECIMAL CHAR '.'
 BOOLEAN TRUE LITERAL 'True' FALSE LITERAL 'False'
 USE HEADERS

Using the attached CSV file.

The import is to a table which has column-names that duplicate the names of the header-row of the CSV file.

The importation occurs perfectly, except that the FIRST COLUMN (order_id) is not imported. In the "WebOrdersPreliminary" table, the order_id is NULL.

If I re-order the data in the CSV file so that the "order_date" is the first piece of data in the CSV file "order_date" then shows NULL in the table.

So I am losing the first column of data whatever I do.

I have done countless IMPORT TABLE processes in the past without this happening before.

Can anyone give me any ideas?!

Adam


I generally start by suspecting the data. In the file you supplied in my hex editor it starts with hex ef bb bf () - doesn't look right

Roy Lambert

Dear Roy

Thanks for this, really helpful.

I have never got into things like hex editors. I probably need to.

The output is coming from a web-service I don't have much control over.

I guess I may have to try to parse the file in Delphi ...

Adam


Just bunging the three characters into DDG I get this link https://en.wikipedia.org/wiki/Byte_order_mark it may be possible for you to tell the producing program to not include it. If not you should only have to bother about the first three characters so easy enough to strip. It may even be as simple as changing teh ENCODING to force unicode.

Roy Lambert

Adam


If you really want to do it all in Delphi its not to difficult - you could use my nlhStrTable to give you a starter for 10 - should be in the binaries.

Roy Lambert