Developer forum

Forum » Development » Importing empty values through the Data Integration Module

Importing empty values through the Data Integration Module

E-mail notifications
Ben Doorn
Reply
Posted on 18/04/2017 11:26:00

Hi,

How do I import empty values through the Data Integration Module. Currently when my source provider delivers an empty string value. after the import run the current data in the destination (itemtype provider) will remain, instead of being cleared. Is this behaviour by design?

Kind regards,

Ben


Replies

 
Jonas Krarup Dam
Posted on 19/04/2017 12:27:57
Reply

Hi Ben,

I'm not sure what you mean - If you're using the DynamicwebProvider, the data that you are inputting should always be written to the databasen. that means that if you are inputting "", the field should be cleared, and if you are importing NULL, the field should be set to null.

If you are running an import with the table and column mappings set correctly, and the import isn't setting the value to "", you are seeing behaviour I have never seen, and I'd like more information: which source provider and which destination provider? what does your input data look like? 

If you can link to a site where the import is set up, and where I can see the problem, that would make it much easier to figure out what's going on.

 

/Jonas

 
Ben Doorn
Posted on 01/05/2017 15:08:50
Reply

Hi Jonas,

That was indeed what I expected to happen.

We use our own source provider and the Dynamicweb Item type provider. We only saw this behavior on a production site, I have not yet setup a test server with the same datasource. I will set it up later this week so we can test.

Kind regards,

Ben

 
Hans Ravnsfjall
Hans Ravnsfjall
Posted on 31/07/2017 14:41:56
Reply

I have the exact same problem. Have you found a fix for this problem yet?

 
Morten Bengtson Dynamicweb Employee
Morten Bengtson
Posted on 01/08/2017 16:07:23
Reply

Hi,

We have taken a closer look at the Item provider in Data Integration and it does indeed look like we have a problem here.

It has been registered as a bug - TFS# 36769

Best regards,
Morten

 
Kristian Kirkholt Dynamicweb Employee
Kristian Kirkholt
Posted on 20/09/2017 15:28:27
Reply

Hi Ben and Hans

The problem TFS#36769 "ItemProvider ignores empty values when updating existing items" has now been fixed in Package "Dynamicweb.DataIntegration.Providers.ItemProvider" version 1.0.7

You are able to find this update in the backend Package update section.

Also the correction are part of the 9.3+ releases 

You are able to find this build in the download section:

http://doc.dynamicweb.com/releases-and-downloads/releases

Please contact Dynamicweb Support if you need any additional help regarding this.

Kind Regards
Dynamicweb Support
Kristian Kirkholt

 
Ben Doorn
Posted on 10/11/2017 12:59:28
Reply

Hi Kristian,

Is this issue also fixed in DW 8?

Krdgs,

Ben

 
Nicolai Pedersen
Posted on 10/11/2017 13:01:39
Reply

It seems to be in 9.3 only as it supposedly is related to DW 9 Item service.

BR Nicolai

 

You must be logged in to post in the forum