Designing XMLPort to export csv

Shaggs

I'm having trouble getting an xmlport to export as csv. I'm able to run the xmlport (with outstreams/instreams, etc), but they always give me xml structure.

I have tried running the standard xmlport 5050 - Export Contact (Unmodified). This keeps giving me xml structured output, even though the format is set to Variable Text.

Can anyone give me any tips here? Is this a bug? Should it be giving me a csv file?

I'm running 2009, SP1 (6.00.29626).

Thanks.

kriki

[Topic moved from 'NAV Three Tier' forum to 'NAV/Navision Classic Client' forum]

rsaritzky

I know this is an old thread, but I was searching for the same answer so I thought I'd post what I discovered so future readers can be helped.

If you run an XMLPort from the Classic Client, you'll always get XML output - unless you manually create the output line in CSV format by concatenating the fields and commas yourself.

If you run the same XMLPort from RTC, you WILL get a CSV file. You do have to add the XMLPort "run" from a page or codeunit.

amazan

rsaritzky wrote:

I know this is an old thread, but I was searching for the same answer so I thought I'd post what I discovered so future readers can be helped.

If you run an XMLPort from the Classic Client, you'll always get XML output - unless you manually create the output line in CSV format by concatenating the fields and commas yourself.

If you run the same XMLPort from RTC, you WILL get a CSV file. You do have to add the XMLPort "run" from a page or codeunit.

I was searching someone who explain this behavior because I didn't understand what's going on..
Thanks a lot, Ron.

Nabuco

Hi,
If you want a CSV outputfile in 2009 - use dataport, this will do the trick.