Export Customers as a CSV file using Codeunit or Report

Jacob1227

Hi All,

I want to export customers as a CSV file using Jobqueue.

Can you please provide me a piece of advice, whether i am creating code unit or report to run a jobqueue.

If it's possible through codeunit or report, please suggest me some piece of code to export a CSV file.

Thanks in advance,
Jacob.A

TallyHo

Did you even search the forum?
https://forum.mibuso.com/discussion/65967/export-to-csv-via-report-nav2015

TallyHo

I hate to say.. 😁
Tomorrow you'll have an example. If no one beats me to it.

TallyHo

Did you even search the forum?
https://forum.mibuso.com/discussion/65967/export-to-csv-via-report-nav2015

Sachin_

Hello @Jacob1227 ,

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

OnPreDataItem()
IF NOT FILE.EXISTS(<Your FileName>) THEN
FILE.ERASE(<Your FileName>);

fileExport.CREATE(<Your FileName>);
fileExport.TEXTMODE := TRUE;
fileExport.WRITEMODE := TRUE;

OnAfterGetRecord()
fileExport.WRITE(STRSUBSTNO('%1;%2;%3;%4;..",
<Your Values>);

OnPostDataItem()
fileExport.CLOSE;

TallyHo

Remove file only when it exists.

Miklos_Hollender

And you gonna do things like add quotation marks and escape already existing quotation marks? In a more modern version like 17 or 18, one can use the CSV Buffer table. Unfortunately I have a similar problem in NAV2015, so I will probably backmigrate half of the functionality of the CSV Buffer...

Jacob1227

Thanks tally sachin and Miklos.

TallyHo wrote: »

Did you even search the forum?
https://forum.mibuso.com/discussion/65967/export-to-csv-via-report-nav2015

Tally,I have done it.Can you please tell me how to include a header?

TallyHo

Do you want to include a header in a csv file?

Jacob1227

Yes Tally.

TallyHo

OnPreDataItem()
IF FILE.EXISTS(<Your FileName>) THEN
FILE.ERASE(<Your FileName>);

fileExport.CREATE(<Your FileName>);
fileExport.TEXTMODE := TRUE;
fileExport.WRITEMODE := TRUE;
fileExport.WRITE(STRSUBSTNO('%1;%2;%3;%4;..",
<Your Header Values>);

OnAfterGetRecord()
fileExport.WRITE(STRSUBSTNO('%1;%2;%3;%4;..",
DELCHR(<Your Values>),'=',STRSUBSTNO('";');

OnPostDataItem()
fileExport.CLOSE;

Jacob1227

Hi Tally,

I have tried with your code but not able to include a header.

please look at my code and suggest me the changes.

TallyHo

Please post all lines of code as text, I Will correct them

Jacob1227

Hey Tally,
I got it .It works well now.Header also included.Thank u once again.