How to read unread CSV files from network path value of which is stored in parameter table.

(0) Share

Report

Posted on by Mav

Hi folks,

I have a parameter table which let the user decide the network path which the AX batch job would continue to scan & read unread CSV files from.

My psedo code looks like this.

select firtsonly myParamTable;

Filepath filepath = @myparamtable.filepath

// What to do next so as to configure this batch job to read unread CSV files from above network path.

Pls share code /psuedocode

Thanks

Mav

I have the same question (0)

All responses (2)

Answers (0)

Mea_ 60,284 on at

Like (0)

Report

Here is a sample code to read all files from a directory https://community.dynamics.com/365/financeandoperations/b/faisalfareedaxlibrary/posts/ax-2012-reading-files-from-directory-through-x

now you can either store list of files you have already processed in a table and skip files you dont need or you can move files to a different folder after you process them, so you won't read them again.

Was this reply helpful? Yes No
WillWU 22,363 on at

Like (0)

Report

Hi Mav,

Where did you store your CSV files?

If the files are on the server, please see:aspcodder.blogspot.com/.../how-to-read-csv-file-from-server-and.html

You could also have a look at the old thread about run the batch job:community.dynamics.com/.../import-file-on-network-in-batch-job

Was this reply helpful? Yes No

Join the conversation

Community site session details

How to read unread CSV files from network path value of which is stored in parameter table.

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

How to read unread CSV files from network path value of which is stored in parameter table.

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates