Data Transfer Workbench (DTW) Error

[Former Member]

Dear All

There is one major issue I keep on facing now days,

It is about DTW.

Here is the scenario:

After filling all data in CSV comma delimited, i try to import.

On the run simulation step, it gives me an error saying data is to long for a particular field.

When I check on the error file, I find out actually data were moved but if I check on my csv sheets, I realise  templates are well filled.

Now, for me to solve this, I have to select all filled data, and move it accordingly to the error file, even tho I can clearly see that data are not in their respective field.

And templates are uploaded.

It is easy to solve, but it is hard to explain to a customer.

Is there any way to solve this?

Best Regards,
Cedric Kayitare

[Former Member]

Hi Cedric,

I encountered this kind of error a lot. I resolve this by saving it as tab delimited file. Now, with your question how to explain to your client, suggest them to save it as tab delimited instead of csv.

Regards,

Mahj

[Former Member]

Hi Cedric,
Do you have any hidden columns in csv? if yes,remove it.

Another thing, If you are okay with the Tab delimited format then try it and check if you still get the same result.

Regards,
Darius

[former_member186712]

Hi Cedric,

What are you trying to import?

Regards,

Augusto

[Former Member]

Hi Augusto,

I'm trying to import Journal Entry.

Best Regards