XMLPort doesn't recognize carriage return characters

JGV

Hi, developers:

I'm working in a XMLPort in BC version 20. This XMLPort has next properties:

Direction = Import;
TextEncoding = UTF8;
Format = VariableText;
FieldDelimiter = '<none>';
FieldSeparator = '<TAB>';
UseRequestPage = false;


At the end of each line of .txt file there are LR and CR characters. However, when object is executed, all file is read in one line beacause carriage return characters aren't recognized.

Please, do you know if there are something wrong about XMLport in BC version 20? I worked in a similar XMLPort before in version 16 and it's working correctly.

Thank you

vaprog

I beieve FieldDelimiter should be '<None>', not '<none>'

The property that is really important here is

RecordSeparator

.
Please make sure it is '<NewLine>'. If it is not set, it should default to that value. You may, however try to set it explicitely.

I do not have access to a BC version 20 System right now, so I can't crosscheck.

Please also make sure your import file has proper NewLine sequeces, ie, 0x0d, 0x0a (<CR>,<LF>) sequences. (not inverted). Also make sure there is not a mix of Unix, Mac, and Windows EndOfLine sequences.

And finally make sure the file is valid UTF8.

vaprog

I beieve FieldDelimiter should be '<None>', not '<none>'

The property that is really important here is

RecordSeparator

.
Please make sure it is '<NewLine>'. If it is not set, it should default to that value. You may, however try to set it explicitely.

I do not have access to a BC version 20 System right now, so I can't crosscheck.

Please also make sure your import file has proper NewLine sequeces, ie, 0x0d, 0x0a (<CR>,<LF>) sequences. (not inverted). Also make sure there is not a mix of Unix, Mac, and Windows EndOfLine sequences.

And finally make sure the file is valid UTF8.

JGV

Hi, vaprog:

You are right, it was about FieldDelimiter property as you said.

Thank you