Single quote issue in COA using DTW

[Former Member]

Hi

I am using DTW to import Chat of accounts in to the test Database.

i just fill 2 rows, 1 for title account and 2nd for active account.

the "fatheraccountkey" is automatically converted in to exponential form even i had put single quote. pls help

Regards,

Ankit

[Former Member · Accepted solution]

dear Rakesh Pati,

I searched 888905 in SAP Notes but not able to find.

could u pls provide the link or path for the same.

[Former Member · Accepted solution]

Hi Ankit,

The note has no solution info regarding your issue. What you can do is:

1. Enter a single quote first following the number. It should be displayed as text and left aligned. If not, you need to edit the cell to add a single quote in front of the number.

2. Save the file as TXT (Tab Delimited) type. This format is the best for DTW use.

3. Before DTW, always open the text file by notebook to check. You can correct any format within notebook in case nothing works by handling within excel.

Thanks,

Gordon

[Former Member]

suda,

i had tried that also.

i make the changes in xls and later i save the file as CSV and used for DTW.

result is same. "error 65171"

[Former Member]

Dear Ankit,

Please follow all the steps as per the SAP note : 888905.

If still you have the same issue, please provide us the details information

about the data that you have entered in the template.

Regards,

Rakesh Pati

SAP Business One Forum Team

[Former Member]

hi suda,

i had already done that, but when i reopen the saved file it again displayed in Exponential form.

i had already mail you the same query with screen shots.

ankit

[former_member583013]

Always maintain the template as xls and make any changes to the xls file and do not reopen the Tab / CSV file

[former_member583013]

Ankit,

In your excel template, please add a exclamation before the parent number and Excel will then treat it as a char

Example: '40000000000

Please also look at this Wiki e-book

https://wiki.sdn.sap.com/wiki/display/B1/SAPBusinessOne...ToGo-10.DataTransfer+Workbench