You’re offline. This is a read only version of the page.
Announcements
Hi All,
we developed a class that uses the sysexcelapplication that uses a custom batch job to import excel to AX through the batchjob,,however the batch job does not run except we run the bathprocessing in he organization administration, but I have keep the batch processing running all time and keeps the session in order to keep the batchjob running.
my question is how I can use the sys excel application in e batch job where it runs like any other job .
below is a screen shot of the batch processing that needs to be kept running in order to keep the batch job running.
Thank you,
Before you start implementing the whole thing by yourself with a .NET library unfamiliar to you (which is expensive and not without risks), are you sure that your requirement can't be achieved by the standard feature that exists in AX for exactly this purpose?
What's the problem that you can't resolve with DIXF? Maybe we can help you to solve it, so you won't have to design, implement, test and maintain a custom solution.
Yes, as I said, it's possible to use can either data management (DIXF) or another library for working with Excel files, such as EPPlus.
Regarding DIXF, look at Automated Data Entity Import Using DIXF in Dynamics AX, for instance.
Thank you Martin,
the file type is in excel format as per the client requirements , is there any way we can write a code for this batch without having to open a client session and run the batch processing from organization administration ?
and can we use data management to import the file through batch job with recurrence ?
Thank you,
No, I can't use SysExcelApplication in a server batch, because this class can only run on client.
Can't you use data management to import the file? It's be the best approach, if it's possible in your case.
If you have to write use your own batch, consider using a different library (e.g. EPPlus) or avoiding Excel completely (e.g. using XML or CSV instead).
Thank you Nikolaos for your response, all bath configurations are setup, all batches are working fine except for this custom one, i forgot to mention that i had to change in the batch tasks to run in client mode except server mode other wise it doesn't work.
so i have to set it to client mode then run the batch processing in the organization administration in order to make it run.
Thank you,
Is this the only batch job that doesn't work as expected?
Please check your batch server setup in System administration - Setup - System - Server configuration.
1) Do you have at least one AOS where "Is batch server" is checked?
2) In Batch server schedule, do you have some value in Maximum batch threads, and do you have some time window specified? Time window should be 00:00:00 - 23:59:59 if you want to have batches enabled for this server around the clock
Then check System administration -Setup - Batch group and verify that all batch groups are associated to at least one batch server.
#1
André Arnaud de Cal...
293,442
Super User 2025 Season 1
#2
Martin Dráb
232,582
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
Share
Report
All responses (
Answers (
