Developer forum

Forum » Integration » DataIntegration, Excel provider and DynamicwebProvider

DataIntegration, Excel provider and DynamicwebProvider

E-mail notifications
Adrian Ursu Dynamicweb Employee
Adrian Ursu
Reply
Posted on 10/03/2023 10:48:28

Hi guys,

I am trying to import an excel file into ProductCategoryFieldTranslations.
As you probably know, this table stores the field options in a field called FieldTranslationFieldOptions where Dynamicweb expects to find a valid XML content.

My customer has filled the Excel file correctly, but upon importing, all quotes are gone.
I am using Excel Provider as source and DynamicwebProvider as destination.

My source file has this string:  

<Options><Option Name="Hight, Type A" Value="A" Default="" /><Option Name="Medium, Type B" Value="B" Default="" /><Option Name="Low, Type C" Value="C" Default="" /></Options>

But in Dynamicweb it ends up like this:

<Options><Option Name=Hight, Type A Value=A Default= /><Option Name=Medium, Type B Value=B Default= /><Option Name=Low, Type C Value=C Default= /></Options>

What should I do to prevent the removal of the quotes when importing?

Thank you,

Adrian

 

 


Replies

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Posted on 10/03/2023 21:43:53
Reply

Hi Adrian,
the quotes are removed by the Excel source provider as it was causing other bugs previously. However it will not remove them if the column type in Excel is of numeric type, such as:
typeof(decimal), typeof(byte), typeof(sbyte), typeof(short), typeof(ushort), typeof(int), typeof(long), typeof(double), typeof(float)
So as a workaround can you try  to change the column type being a number in Excel and see if it helps?
BR, Dmitrij

 
Adrian Ursu Dynamicweb Employee
Adrian Ursu
Posted on 11/03/2023 11:10:02
Reply

Hi Dmitrij,

Thank you very much for the response. I understand the reasons behind this behavior but it seems that it limits our ability to import data.

I am not sure if I can set a olumn of that size as an number without (probably) triggering a whole new list of validations.

Will there be any change in the future to support importing content containing quotes? I know that we are importing very often ProductCategoryField Definitions and that involves conmtent with quotes. Not to mention other scenarios where we might still need quotes. Maybe a setting on the mapping of the fields? Or ar provider level (destination)?

Thank you,
Adrian

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Posted on 13/03/2023 11:29:33
Reply

Hi Adrian,
this is a bug and will be fixed in #12532 soon (already in QA). So the quotes will no longer be removed.
BR, Dmitrij 

 
Adrian Ursu Dynamicweb Employee
Adrian Ursu
Posted on 13/03/2023 11:59:44
Reply

Thank you!

Adrian

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Posted on 20/03/2023 08:39:59
Reply

Hi Adrian,
this is now fixed in the ExcelProvider 4.0.17.
BR, Dmitrij

 
Adrian Ursu Dynamicweb Employee
Adrian Ursu
Posted on 20/03/2023 09:55:38
Reply

Thank you very much, Dmitrij

Adrian

 
Kristian Kirkholt Dynamicweb Employee
Kristian Kirkholt
Posted on 21/03/2023 13:54:09
Reply

Hi Adrian

Correction is now also part of release 9.15.4

Kind Regards
Care Support
Kristian Kirkholt

 
Adrian Ursu Dynamicweb Employee
Adrian Ursu
Posted on 21/03/2023 14:09:46
Reply

Thank you, Kristian

Adrian

 

You must be logged in to post in the forum