How to create a CSV file ?

Business Central/NAV Developers Forum
1

Suppose i have a requirement that a CSV file need to be created and some records will be exported to it at specified location without getting it opened.?How can we do that ?

2

Hi Vimal,

You can use DataPorts to create CSV files.

3

Hi Erik,

Dataports won’t be working in NAV7(Release 2012). So i have to make a report.

Cheers,

Vimal

4

for exporting data to excel you can use data migration tools in nav

Administration Menu->Application Setup->Company Setup->Data Migration

Migration → migration fields tick "include " fields

functions >> export to excel

5

If you really want to use a report, you could use a “File” variable, but make sure your not putting it on the server.

OnPreDataItem()
IF NOT FILE.EXISTS() THEN
FILE.ERASE();

fileExport.CREATE();
fileExport.TEXTMODE := TRUE;
fileExport.WRITEMODE := TRUE;

OnAfterGetRecord()
fileExport.WRITE(STRSUBSTNO(’%1;%2;%3;%4;…",
);

OnPostDataItem()
fileExport.CLOSE;