DTW Templates - Template not being created.

[nadav_caridi2]

Dear Experts ,

I'm trying to update a UDT (Master Data) using DTW.

I tried to create a template by going to the Tepmlates in DTW  -> Customize Template ( Ctl+ M) -> select my UDT object -> right click on the object and create template from this structure. DTW reports that the template was created successfully but no template was created.

also when trying to update without the DTW template using A CSV file I'm getting the following :

no     Status                Key            Reason

1       Create Failed -      13          Cannot add rows to a MasterData type UserTable U_Test_Header

2     Updated Successfully 13     13U_Test_Header

Thanks in advance for  any help in this matter.

NC.

[kothandaraman_nagarajan · Accepted solution]

Hi,

Please check,

How to create a template for a User-Defined Table in Data Transfer Workbench? - Business One - SCN W...

Hope helpful.

Thanks & Regards,

Nagarajan

[nadav_caridi2]

Thank you !

[Former Member]

Hi

You can create your own template using excel.

just set the first row as the field you want to import.

it is very impotent to write the full field name include the U_ in capital letters

good luck

shachar

[nadav_caridi2]

Thanks for the reply.

as I've mentioned when I try and create my own template I'm encountering the following result : 

no     Status                Key            Reason

1       Create Failed -      13          Cannot add rows to a MasterData type UserTable U_Test_Header

2     Updated Successfully 13     13U_Test_Header