Subject:Incorrect data<->column mapping in converter Author:David Tellander Date:26 May 2005 09:42 AM
Hi!
I'm trying to create a Convert to XML converter. The file I want to convert is a CSV generated from MS Excel. A lot of cells in the file contain no data. The structure looks something like this:
I.e the data<->column mapping is incorrect, it is always the first columns that are used even if the data are in other columns. This happens only when I open a file, in the preview pane of the convert to XML editor it looks like it should.
Subject:Incorrect data<->column mapping in converter Author:Tony Lavinio Date:26 May 2005 08:30 PM
Alas, you are correct, there is a bug.
Internally, the engine is looking at the wrong variable. Instead of
looking at the setting for 'collapse consecutive separators' it is
looking at 'double delimiters to escape'.
In the short-term, if you don't care about that second setting, changing
it to 'false' will fix your problem.
In the longer term, a patch release should be available shortly.