Breaking news from around the world
Get the Bing + MSN extension
Choose your path Increase your proficiency with the Dynamics 365 applications that you already use and learn more about the apps that interest you. Up your game with a learning path tailored to today's Dynamics 365 masterminds and designed to prepare you for industry-recognized Microsoft certifications.
Visit Microsoft Learn
2019 release wave 2 Discover the latest updates and new features to Dynamics 365 planned through March 2020
Release overview guides and videos Release Plan | View virtual launch event
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Talent TechTalks | Upcoming TechTalks
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.
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.
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.
Then perhaps the issue is in your custom class. Would you mind sharing the source code of that batch class?
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 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 Nikolaos, yes i will share the code tomorrow after i connect , as currently i dont have access.
Thanks a lot.
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, may you please share code sample (if you have one ) using EPPLUS Library for excel import ?
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.
Thanks a lot Martin, the team has used the EPPLUS library and it is working perfect.
Business Applications communities