web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) Limiting the .csv file...

Microsoft Dynamics AX (Archived)

Limiting the .csv file rows count

(0) Share

Report

Report

Posted on by Community Member

Hello Everyone.

I want to write the table records into csv("export.csv") files.

Each csv file should has only 200 rows total and next 200 rows (201 to 400) should be written into a next csv("export2.csv") file.

-

I used this code to output the .csv file but this code writes all records in single .csv file.

fileExportCsv.writeExp(vatOutLine);

Please advice how to get the required result.

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

Vilmos Kintera 46,149 on at

Like (1)

Report
Copy link

Link copied!

I prefer to use System.IO.StreamWriter from .Net instead of AsciiIo and CommaIo, you could find examples using Google/Bing.

After that, all you need to do is change your code to write the information per line, count how many did you write, then once you reach 200 in your counter, close the file and open a new one.

Was this reply helpful? Yes No
Mea_ 60,286 on at

Like (1)

Report
Copy link

Link copied!

Hi Htoo Ko Ko,

writeExp accepts container so obviously you have code somewhere to populate this container with data. You can put 200 lines into container and call fileExportCsv.writeExp(vatOutLine); then put next and so on...

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1

#2

Alexey Lekanov 2

#2

Henrik Nordlöf 2 User Group Leader

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans