Importing data from other system - cvs files

[Former Member]

hi

What is the best way to import 3 cvs files from other accounting system

The 3 files contains data about customers and few more custom fields that I need to create in Business one

(more information about the cusomter)

I need to import the files every day

Thank you

[Former Member · Accepted solution]

Hello Ofer,

DTW (Data Transfer Workbench) would be a good choice. It is free and included in SAP Business One installtion package(Under the folder ...\Packages\Data Transfer Workbench). Please install it, and check out the help file for detail information.

Hope this helps,

Nick

[Former Member · Accepted solution]

Thank you very much

[Former Member · Accepted solution]

Hello,

You can have more information about Data Transfer Workbench in the DTW help file and also in the DI API help file which is very usefull to create the csv/txt templates.

HTH,

Thibault

[Former Member]

Hi Ofer,

I read you need to do this import every day. With the DTW you have to do this manually(?).

Another (however expensive) option is to use iBOLT from <a href="http://www.magicsoftware.com">Magic Software</a>.

We also have a customer wich get's every day a few .csv files by email. iBOLT does get the .csv from the mailbox, does some preperation and imports the data into SBO. No user interaction required.

Kind regards,

Rowdy