Error in importing CSV file with XMLport NAV2015

jsl_dk

I am trying to import some order lines with XML-port

It works fine if I choose to user <TAB> as fieldseparator.

But when I try to use <;> as fieldseparator and <"> as Fielddelimeter ("ord123";"1234567";"Item1";"3") I get the following error
The Element was expected by the value Min Occurs: Once

Juha

Try to clear what you have in fielddelimiter and fieldseparator and let NAV set them to the default values <"> and <,>.
It looks like your fielddelimiter is shown in bold in your video. Bold means changed and NAV will look for '<,>' and '<">' (3 characters) when looking for fieldseparator and delimiter
/Juha

jsl_dk

Thanks
I found the problem.
When i removed the <> and just enterede " and ; it works ?!

postsaurav

The Error Min Occurs: Once is does not seems due to The Delimiter.
The Error Occurs When Suppose you want to Import Like 3 Fields= Field1,Field2,Field3

And the File that you are importing having Records like -
1,2,3
1,,3
1,,2
1,2,4

If you go the XmlPort Nodes you can specify Min Occurrence to Zero, that means if its not there even then it will import records.

jsl_dk

Thank for your answer
I have tryed to make a video of the problem :-)

http://www.screencast.com/users/JoergenSkakLund/folders/Snagit/media/ef1de324-7126-43f5-aa16-63565e1fe963

Juha

Try to clear what you have in fielddelimiter and fieldseparator and let NAV set them to the default values <"> and <,>.
It looks like your fielddelimiter is shown in bold in your video. Bold means changed and NAV will look for '<,>' and '<">' (3 characters) when looking for fieldseparator and delimiter
/Juha

jsl_dk

Thanks
I found the problem.
When i removed the <> and just enterede " and ; it works ?!