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
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
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.
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.