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.

All responses (8)

Answers (1)

Verified answer

nmaenpaa 101,158 Moderator on at

Like (0)

Report

RE: Excel import in AX2012

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.
Community Member on at

Like (0)

Report

RE: Excel import in AX2012

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.
Community Member on at

Like (0)

Report

RE: Excel import in AX2012

Hi Ludwig,

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

nmaenpaa 101,158 Moderator on at

Like (0)

Report

RE: Excel import in AX2012

Open the CSV in Notepad. Most likely you have empty lines in the end of the file. Remove them and try to import again.
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Excel import in AX2012

Hi mahiims18,

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

Can you share details about your job?

Many thanks,

Ludwig
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Excel import in AX2012

Hi mahiims18,

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

Can you share details about your job?

Many thanks,

Ludwig
Community Member on at

Like (0)

Report
RE: Excel import in AX2012

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
Gunjan Bhattachayya 35,421 on at

Like (0)

Report

RE: Excel import in AX2012

Hi mahiims18,

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