Developer forum

Forum » Integration » How to receive and import CSV data using Data Integration ERP Batch?

How to receive and import CSV data using Data Integration ERP Batch?

Allan Iversen
Reply

Hi! I got a question regarding importing large amounts of data eg. customer price information using the Data Integration ERP Batch setup. 

Is it possible to use the Data Integration ERP batch for importing CSV data provided by the Dynamicweb connector service for this? - or should I consider delivering the data in another way?

Allan


Replies

 
Jonas Krarup Dam
Reply

Hi Allan,

It is possible, but it requires a bit of coding.

If you want to use scheduled tasks and the data integration module for pulling the data into the database, I recommend creating a custom scheduled task. The template for doing this is included in our Visual Studio templates. This templates is basically the sourcecode for the "import data with custom xml request" addin. the only change you have to make, is to make sure it works when the data integration activity that is refered can have a CSVProvider as destination, and to make sure that the CSV file is save to the right place in the file archive.

If you only want to use the DynamicwebConnector for transferring data, but you want to handle everything after on your own, you can just use the ErpServiceCaller.GetDataFromRequestString() method with the right endpoint, secret and an xml request that you agree with your ERP provider to use, and the result will just be a string that you can parse or save as you see fit.

/Jonas

 
Allan Iversen
Reply

Hi Jonas,

Thank for your answer. I will have a look at it.

Allan

 

You must be logged in to post in the forum