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)

Mea_ 60,284 on at

Like (1)

Report

RE: Limiting the .csv file rows count

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
Verified answer

Vilmos Kintera 46,149 on at

Like (1)

Report

RE: Limiting the .csv file rows count

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

Helpful resources

News and Announcements

Dynamics 365 Community Calls Return

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Responsible AI policies for the Community

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1

Syed Haris Shah 9

#2

Mea_ 4

#3

KP-31070522-0 3

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans