cancel
Showing results for 
Search instead for 
Did you mean: 

DTW - multiple lines in a field

paul_feeney
Employee
Employee
0 Kudos
1,221

If you want to import/update fields via DTW to include multiple lines, here's the way to do it.

1. Open the DTW Template in Microsoft Excel

2. Enter a new line in the cells using ALT+ENTER

3. Save the file as a Text (Tab delimited) (*.txt) file.

You will then be able to import this file in DTW.

When there multiple lines in the cell, Excel will enclose the content of the cell within double-quote characters when saving as a .txt file. If you do not want double-quotes in the field in SAP Business One, you could open the .txt file in notepad and delete these characters before doing the import.

View Entire Topic
Former Member
0 Kudos

Hi,

I've tried this but it's not working, any ideas?

Br

Anders

paul_feeney
Employee
Employee
0 Kudos

Hi Anders,

Let me know what version of SAP Business One and DTW you are using. And are you using Excel to update the templates?

Thanks,

Paul