web

You’re offline. This is a read only version of the page.

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) Dynamics Ax 4 schedule...

Microsoft Dynamics AX (Archived)

Dynamics Ax 4 scheduled csv batch import

(0) Share

Report

Report

Posted on by Fabrizio

30

Hi,

My company needs to import data in scheduled fashion from csv files.

Before customizing Dynamics 4 we would like to see if it possible to use what Dynamics already offers us to do so.

We noticed that creating a "definition group" there are three ways to set up import batches:
Standard, Excel, Custom

"Custom" would be perfect for our needs. Unfortunately we cannot find a way to schedule it.

Does exist such way? Is there any viable alternative?

Thank you! Fabrizio

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Community Member on at

Like (0)

Report

Re: Dynamics Ax 4 scheduled csv batch import

Hello,
To my knowledge, the custom import would work for importing a csv file. You would enter a "," for the field seperator. The custom option also gives you areas to write some logic to convert or set import criteria (conversion and import criteria tabs). However, the custom import still needs to be ran on a manual basis.
I would suggest writing a class that extends RunBaseBatch. In this class you should read in your data from a csv file and update / insert records into your table(s) accordingly. Then you schedule the class to run whenever needed. There are a bunch of examples online that will show you how to read in data from a file.
Hope this helps.
Regards.

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1

Martin Tocauer 4

#2

Alexey Lekanov 2

#2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans