File upload issues

Hi Pete,

I've struck a couple of issues with uploading CSV data into OpenQM (v3.0-8 Windows) using AccuTerm 7.1a SP2 (7.1.1012) on Windows 7 / 64 Home Premium.

The import data uses comma separators, and has a header row that matches the dictionary names of the receiving file.

Using the file transfer wizard, everything goes fine EXCEPT that the header row is imported into the receiving file. I ticked the 'User header row' option on the way through, so I wouldn't expect this to happen.

Using FTD directly from the command line, I get the message:

Transfer status: Attribute defining item 'ROW,QUARTER,COUNTRY,DESCRIPTION,QTY,FOB' not on file

Looking through the code for FTD, this looks as the variable ALST is not set when you answer Y to the 'Use header record' prompt.

Any thoughts?

Thanks,

Brian Speirs

Hi Pete,

You were quite right. Changing the delimiter to Comma made everything work just fine - including the fact that the header row was not imported when running FTD directly.

So, that brings us back to the first issue - why is the header row being imported when the import is run via the wizard?

Thanks,

Brian

Hi Brian -

This looks like a bug in the wizard. When you specify that the first line is a header, and you match dictionary names to columns, somehow the header line is treated as data. If you select "include all columns" instead, then the header line contents are matched with dictionary names and the header line is not treated as data. I'll add this to my "need to fix" list.

Thanks,

Pete