Excel import in AX2012

(0) Share

Report

Posted on by Community Member

Hi,

During Excel import Empty lines from .csv file is reading.

For example in my case I have only 5 records in .csv but after running my x++ job it is processing 15 records i.e. 10 empty lines along with my 5 records. How to avoid these empty lines.

I have the same question (0)

All responses (8)

Answers (1)

Gunjan Bhattachayya 35,423 on at

Like (0)

Report

Hi mahiims18,

Could you please share the code you are using in the job?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
container roles,readCon; counter icount,inserted; int recCount =0,fvalid=0; delete_from maCustUpdate; csvFile = new CommaIO(filename, 'r'); try { if (csvFile) { readCon = csvFile.read(); while (csvFile.status() == IO_Status::OK) { readCon = csvFile.read(); fvalid ; if(readCon) { icount ;

This was part of my code, I have almost 200 lines.

While reading the line number 10 is reading 10 lines at a time even though I have 5 records in my .csv file

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi mahiims18,

What data do you try to import from a .csv file?

Can you share details about your job?

Many thanks,

Ludwig

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi mahiims18,

What data do you try to import from a .csv file?

Can you share details about your job?

Many thanks,

Ludwig

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,160 Moderator on at

Like (0)

Report

Open the CSV in Notepad. Most likely you have empty lines in the end of the file. Remove them and try to import again.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Ludwig,

from .csv file I have customer addresses to be updated.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Nikolaos

when I can clear the content of empty lines in csv file it is working fine for me but I am wondering why my code is reading empty lines some times.

Was this reply helpful? Yes No
Verified answer

nmaenpaa 101,160 Moderator on at

Like (0)

Report

I assume it always reads empty lines if the file has empty lines.

You can check if the line has contents before writing anything to the database.

Was this reply helpful? Yes No