ER Export with Comma Separated Values (CSV) file

(0) Share

Report

Posted on by Pedro-Rodriguez

272

Hi,

I need to create a ER Model/Format (Similar to Intrastat/Sales List) to do an export that will generate data in a CSV (Comma separated) file.

The sample with Intrastat generates XML but it would be great to have some documentation, sample or blog entry that shows how a CSV file can be generated with ER. If anyone knows about a good documentation to do this task it would be nice to have it here instead of losing a lot of time with trial an error.

Basically what I will do is to generate the data in a intermediary table and generate the CSV from this table, so the data model will be very simple.

Thanks

Pedro

I have the same question (0)

All responses (4)

Answers (1)

Ankit Life 681 on at

Like (0)

Report
Copy link

Link copied!

Hi Pedro-Rodriguez,

As per my understanding in Standard ER, CSV format is not available. You could try to create and generate the file in Excel and then save the excel file into CSV.

Regards,

Ankit Arora

Was this reply helpful? Yes No
Pedro-Rodriguez 272 on at

Like (1)

Report
Copy link

Link copied!

Maybe not by default but with some extra work should be possible to put the commas in there. Probably at the beginning with columns of the same width should be enough. I think that looking how the EU Sales List Format is done will be sufficient.

Was this reply helpful? Yes No
Verified answer

nunomaia 25 Moderator on at

Like (0)

Report
Copy link

Link copied!

Take a look on EU SALES LIST (SE ) if is similar what you need

Was this reply helpful? Yes No
Suggested answer

Pedro-Rodriguez 272 on at

Like (0)

Report
Copy link

Link copied!

Thanks. I already solved it looking at the EU Sales List (DE). Anyway I will look also at it now.

Was this reply helpful? Yes No