How to configure a scheduled data import with DTW (Data Transfer Workbench)

[Former Member]

Hi everyone,

In this document I will be explaining how to configure a scheduled data import with DTW (Data Transfer Workbench).

This was configured on a Windows 7 SP1 64-bit machine, running SAP Business One 32-bit Version 9.0 PL09 HF1 and Microsoft SQL Server 2012.
All software was on a single computer.

Prerequisites:

1. You have installed SAP Business One.
2. You have installed DTW.
3. You have administrative access to your computer.
4. You have set the SAP Business One .exe to run as administrator.
5. You have set the DTW .exe to run as administrator.
6. You have successfully used DTW before and are proficient in it.
7. Task Scheduler is available on your computer.

Steps:

1. Prepare an data import file or database (ODBC) as you normally would.
2. Open up DTW and login.
3. Follow the normal steps you would take to import the file.
4. Once you get to Step 7, click the Save button. Choose a directory and a file name, making sure the directory AND file name contain no spaces. It will NOT work if there are spaces. Click Save.
   
   
   
   
5. You can cancel out of the Step 7 DTW screen, log off and then close DTW.
6. Next is to make a batch file.
   Open up Notepad and enter in the three things.
   
   The file directory to the DTW .EXE (Mine is C:\Program Files (x86)\SAP\Data Transfer Workbench\DTW.exe)
   As this file directory has spaces in it (EG: Program Files (x86)) it MUST be encapsulated in double quotes.
   So it should look something like this "C:\Program Files (x86)\SAP\Data Transfer Workbench\DTW.exe"
   
   An -s which indicates that there is a source file expected.
   
   And finally the file directory of the source file which in my case is C:\Users\Public\Documents\DTWScheduledRun\ItemDescriptionUpdate.xml
   This directory must NOT have spaces in it.
   It should look something like this C:\Users\Public\Documents\DTWScheduledRun\ItemDescriptionUpdate.xml
   
   Also, when entering this into the Notepad, make sure you enter it all on the same line.
   So don't press enter, type it in as one long sentence.
   
   
   
   
7. Go to save this file, give it a name and put the extension .bat at the end of it.
   
   
   
   
8. You should have 3 files now as noted below.
   
   
   
   
9. Now it is time to setup the task in Task Scheduler.
10. Go to Start Menu, All Programs, Accessories, System Tools and click on Task Scheduler.
11. Once this opens, click on the menu name Action and choose Create Basic Task.
12. Give it a name and description and click Next.
    
    
    
    
13. Choose a trigger and click Next
    
    
    
    
14. Then choose Start a Program and click Next. Click the Browse button and choose the .bat file we made earlier and click Next.
    
    
    
15. Review the information and select the checkbox for Open the Properties dialog for this task when I click Finish and then click Finish.
16. In the properties windows, select the radio icon next to Run whether user is logged on or not and the checkbox next to Run with highest privileges.
    
    
    
    
17. Click OK and enter in your credentials. Click OK again.

This should be it!

Note, I have included my working files I made for reference.

Please give any feedback.

Kind Regards,

Nick Lakasas

[Former Member]

HI Nick

Thank you for your documentation. I have gone through it and it is very useful for my current  implementation. Actually i thought giving training to End user how to import data through DTW instead this will help the client a lot.

Regards

Srinivas.

[Former Member]

No problem Srinivas, happy it is of use to you.

Kind Regards,

Nick Lakasas

[Former Member]

Hi,

Even I think its very useful.

Thanks

Chandan Lal

[Former Member]

Thanks for the kind words Chandan.

Kind Regards,

Nick Lakasas

[kothandaraman_nagarajan]

Hi Nick,

Thank you for your detailed scheduling of DTW.

Can we schedule all templates? Is there is any limitation?

Best Regards,

Nagarajan

[Former Member]

Thanks Nagarajan,

Quite ok.

I am not aware of any limitations using this method.

Kind Regards,

Nick Lakasas

[former_member186712]

Nice and very detailed.

Thank you

[former_member10430]

Thank your for delighting us with such a guide.

I just have one question: How am I suppposed to check if the import went successful or not? Is there any status in the cmd window?

Thnak you

[josedvm]

Hi Haitem.

 

You can check that using the Log Manager of DTW. Here you have a sample of a run with a mix of updates and failures.

 

 

[matteo_gervasoni]

Thanks for the guide. 

We have Windows scheduled tasks that run DTWs at night. After the update these automatic DTWs do not work anymore because recent SAP versions require an external authentication framework.

To fix this issue the DTW structure must be saved using the new one.