Developer forum

Forum » Integration » Exclude rows from update

Exclude rows from update

E-mail notifications
Adrian Ursu Dynamicweb Employee
Adrian Ursu
Reply
Posted on 31/01/2017 19:32:48

Hi Guys,

I have a data integration job that basically adds Items and pages based on a RSS feed.

I have defined the NewdID as a unique key.

Some of the News might be manually edited after they have been generated and the XML feed might still feature the edited news in the xml on the next run.

Is there any way I can exclude the edited news items from being updated?\I was thinking a property (checkbox) that is set to true if the news has edited.

Any other ideea is welcomed.

Thanks,
Adrian 


Replies

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Posted on 01/02/2017 13:12:48
Reply

Hi Adrian,

you can write the TableScript class and in the
ProcessInputRow(Mapping mapping, Dictionary<string, object> row)
method you could find the existing "News" object by "NewdID" and check if it was edited then assign the needed values to the reference source row which is passed into this method. Then the data should be updated with the latest values.
Regards, Dmitrij

 
Adrian Ursu Dynamicweb Employee
Adrian Ursu
Posted on 02/02/2017 13:52:13
Reply

Hi Dmitrij,

Thank you for your suggestion. I will give it a try.

I have one more question. Considering we will develop this table scripting, will it be compatible with DW9 later on? Is there anything changed on DW9 from this perspective?

Thank you,
Adrian

 

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Posted on 02/02/2017 14:14:52
Reply

Hi Adrian,
it is supported in DW9. But there might be a problem with namespaces, since a lot of them were changed in DW9, so you might need to recompile your code to work with DW9 Api.
Regards, Dmitrij

 

You must be logged in to post in the forum