Developer forum

Forum » Development » Urgent! IMPORT Error

Urgent! IMPORT Error

E-mail notifications

Reply
Posted on 20/10/2008 17:25:06

Hi, I've just spent 4 hours looking for errors in my xslt and xml documents, but I cant find any...

 

Everytime I try to import I get this error: Product destination XML or SQL error: Error converting data type nvarchar to float.

I've been around everything I can think of...

 

I have another pipeline with almost the same xslt, which works fine...

 

Any ideas??


Replies

 
Posted on 20/10/2008 17:28:20
Reply

Could be a price, weight, volume, stock level. Take a look at the EcomProducts an see what fields are of type double. Check the values you attempt to insert in these fields. You might want to set up SQL Profiler to see the exact statement that is executed against the SQL server.

 
Posted on 20/10/2008 17:34:27
Reply
Sorensen wrote:

Could be a price, weight, volume, stock level. Take a look at the EcomProducts an see what fields are of type double. Check the values you attempt to insert in these fields. You might want to set up SQL Profiler to see the exact statement that is executed against the SQL server.

:-D, as you were typing this very fast and accurate reply I stumbled across this article: http://documentation.dynamicweb.dk/Import/Export-28558.aspx

Which let me in the exact same direction.

I had one freaking product with a price field containing ",-".

 

Sorry to disturb you with a stupid on like this! But now it's in the forum, should anyone green like me search for the error description again :-D

 

 
Posted on 20/10/2008 21:36:37
Reply

Ah, classic:) Glad you sorted it out.

 

You must be logged in to post in the forum