Finance | Project Operations, Human Resources, ...

How to skip header of each csv file while inserting data into ax table from a local folder

(0) Share

Report

Posted on by community

141

I am referring this code

community.dynamics.com/.../ax-2012-reading-files-from-directory-through-x

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

nmaenpaa 101,160 Moderator on at

Like (0)

Report

The code that you refer to reads all lines starting from the first line (while this.readLine()).

So all you need to do is to not call processRow in the first iteration of that while loop for each file.

Was this reply helpful? Yes No
Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report

another thing you can make code to start reading from row 2 instead of 1. I can understand you have headers on top row of the file.

Was this reply helpful? Yes No
community 141 on at

Like (0)

Report

I tried many ways but it still copy the header for next file.

Was this reply helpful? Yes No
community 141 on at

Like (0)

Report

i tried but nothing happened

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,160 Moderator on at

Like (0)

Report
We could try to spot what's wrong with your code, but you forgot to share it..

Anyway, let's take the code from the blog and demostrate. I added new variable currentRowInFile to handle the requirement of skipping the first row of each file:

private void readFilesFromDirtecory() { SetEnumerator sE; int row = 1; filePath = @"C:\Temp\FilesToRead"; this.getFiles(); sE = fileSet.getEnumerator(); while (sE.moveNext()) // loop through all files { int currentRowInFile = 1; filename = sE.current(); this.openFile(); while(this.readLine()) // loop through all lines from current file { if (currentRowInFile > 1) { this.processRow(row, lineCon); } currentRowInFile ; row ; } } }

Is it now clear? If not, please share your code so that we can help with it.

Was this reply helpful? Yes No
André Arnaud de Cal... 301,053 Super User 2025 Season 2 on at

Like (0)

Report

Hi Marian,

What exact product are you using? You shared a blog related to AX2012, but posted the question in the Dynamics 365 forum.

Was this reply helpful? Yes No