Finance | Project Operations, Human Resources, ...

How to import Multiple Excel from a specific folder in ax 2012

(0) Share

Report

Posted on by Axbeginerss

i have to import a data from multiple excel from a shared folder in ax 2012 using runbasebatch .

I have the same question (0)

All responses (11)

Answers (0)

Suggested answer

nmaenpaa 101,162 Moderator on at

Like (0)

Report

I recommend using DIXF (Data Import Export Framework), it supports importing multiple files from a folder and you don't need to write any code.

Was this reply helpful? Yes No
Mav on at

Like (0)

Report

DIXIF wont work if you are trying to upload multiple sheets of an excelworkbook into same custom entity.

Something similar is already being discussed here at this thread .

Thanks

Mav

Was this reply helpful? Yes No
Axbeginerss 25 on at

Like (0)

Report

Thanks for reply Nikolaos Mäenpää

but the requirment is to read multiple excels from a shared folder and update in Ax Tables using Runbase batch.

Was this reply helpful? Yes No
nmaenpaa 101,162 Moderator on at

Like (0)

Report

Ok, so I assume you got some business requirement from your customer, and then decided that RunBaseBatch is the best/only way to solve this requirement. Correct?

Just to make sure we can assist you in best possible way, could you share the business requirement?

Often development a customization should be considered only if non-development options were not feasible in fulfilling the business requirement.

Was this reply helpful? Yes No
Axbeginerss 25 on at

Like (0)

Report

Client will get the data from a thirdparty and they will save those files in a shared folder .they will give us the path to access the folder.they ask us to create a batch job to read multiple excel s and once the excel is read it should move to another folder.

Was this reply helpful? Yes No
nmaenpaa 101,162 Moderator on at

Like (0)

Report

Ok, sounds that you could do that with DIXF.

Not sure if moving the file to another location is possible. But for that you could have some simple script that copies files from the source folder to DIXF folder AND "processed" folder.

Was this reply helpful? Yes No
Suggested answer

Martin Dráb 237,965 Most Valuable Professional on at

Like (1)

Report

It's supported out of the box - you can set "Completed directory" in DIXF setup. See Recurring batch job import in AX 2012 R3 for details.

Was this reply helpful? Yes No
Axbeginerss 25 on at

Like (0)

Report

container createListOfFiles()

{

System.Array files;

int fileCount;

int i;

str nextFile;

container listOfFiles;

new InteropPermission(InteropKind::ClrInterop).assert();

info(strfmt('Search in: %1 %2', @"C:\ReadFromExcel", '*.xlxs'));

listOfFiles = connull();

//actIx = 0;

files = System.IO.Directory::GetFiles( @"C:\ReadFromExcel", '*.xlxs');

if (files)

{

fileCount = files.get_Length();

info(strFmt('Number of files in directory: %1', fileCount));

for(i=0; i < fileCount; i++)

{

nextFile = files.GetValue(i);

listOfFiles += nextFile;

}

}

CodeAccessPermission::revertAssert();

info(strFmt('Files count: %1', conlen(listOfFiles)));

return listOfFiles;

}

here--- fileCount = files.get_Length(); is giving me zero even though there are 6 xlxs files in the folder.

Was this reply helpful? Yes No
Martin Dráb 237,965 Most Valuable Professional on at

Like (0)

Report

Remember that the best code is the one that you don't have to write, test, debug, document, maintain...

First of all, check if your code runs on the same machine where you have the files. You may have files in client and running code on AOS.

Was this reply helpful? Yes No
Axbeginerss 25 on at

Like (0)

Report

can i get code to loop a folder and get the name of excel file ??

Was this reply helpful? Yes No