Skip to Content

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.

SBOAdmin.JPGDTWAdmin.JPG

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.

    Step7a.JPGStep7b.JPG

  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.

    Batcha.JPG

  7. Go to save this file, give it a name and put the extension .bat at the end of it.

    Batchb.JPG

  8. You should have 3 files now as noted below.

    Files.JPG

  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.

    TaskScheda.JPG
  13. Choose a trigger and click Next

    TaskSchedb.JPG
  14. Then choose Start a Program and click Next. Click the Browse button and choose the .bat file we made earlier and click Next.

    TaskSchedc.JPG

  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.

    TaskSchedd.JPG

  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

To report this post you need to login first.

6 Comments

You must be Logged on to comment or reply to a post.

  1. S R N Gupta Thatikonda

    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.

    (0) 
  2. Nagarajan K

    Hi Nick,

     

    Thank you for your detailed scheduling of DTW.

     

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

     

    Best Regards,

    Nagarajan

    (0) 

Leave a Reply