Enterprise Resource Planning Blogs by Members
Gain new perspectives and knowledge about enterprise resource planning in blog posts from community members. Share your own comments and ERP insights today!
Showing results for 
Search instead for 
Did you mean: 
Former Member

Data Transfer Workbench (D.T.W) is a platform where you can upload bulk data into the database of the SAP Business One.

A some things one should keep in mind is that the database is correct; and the user id as well as password to the database is correct.

Usually we can find the templates under the folder named Data Migration among SAP Business One Software Folder in Programs list.

Even though one could not find the required template or if the required template is user defined templates, you could generate them form the Data Transfer Workbench itself.

Steps for generating Data Transfer Workbench Templates

Step 1:

Login to D.T.W software using required user id and password.

After logging in you can see  "Templates" at top of the toolbar

Click on it.

A drop down will appear showing the following

Step 2:

Select 'Customize Template, Generate UDO Template, Generate UDF Template" as per your requisition.

UDO Templates:User Defined Templates-  the templates for the user defined tables that have been created in the database.

UDF Templates: Standard Templates, which is standard in SAP Business One.

Customize Template- This option gives you to customize a template as per your choice.

Step 3:

Below "Browse" button is provided for the location where you want to save the templates which is being generated.

After selecting the appropriate location, click on "Generate Templates" to generate.

Generation of Template may take a couple of minutes.

Thus the required template is generated.

Labels in this area