Developer forum

Forum » Integration » Import activity and product group sorting

Import activity and product group sorting

E-mail notifications
Lars Larsen
Reply
Posted on 27/05/2015 16:17:58

Hi,
I have an import activity that imports products and product groups and want the sortorder of product groups (set in the backend) to be maintained after an import. Therefore I removed the field GroupRelationsSorting (table EcomGroupRelations) from the job/source/Schema/table - node EcomGroupRelations to avoid the field from being imported. But this doesn't seem to work. Do I have to remove more fields from the source schema?


Replies

 
Dmitriy Benyuk
Posted on 28/05/2015 13:33:03
Reply

Hi Lars,
What provider are you using Dynamicweb or Ecom as a destination? Also could you check if you have removed the column mapping for the EcomGroupRelations table column GroupRelationsSorting in DataIntgeration module -> Click your job -> check table and column mapping ?

Regards, Dmitrij

 
Lars Larsen
Posted on 28/05/2015 13:59:52
Reply

Hi Dmitrij

I am using the Dynamicweb provider as destination. I can't check the mapping in the DataIntegration module because the job is set to do mapping automatically at runtime. Therefore I have edited the job xml file to delete the column GroupRelationsSorting.

 
Dmitriy Benyuk
Posted on 28/05/2015 14:44:20
Reply
This post has been marked as an answer

Hi Lars,
the problem is that even if you remove the GroupRelationsSorting column from the job xml file, when the job with automatic mapping is started it reads the original schema from the source and destination (so it reads all tables with column from the database when the Dynamicweb Provider is used) and if the table+column with same names are matched they are included into the mapping automatically. Could you remove this GroupRelationsSorting column from your Source file/database which is used for reading the values from?

Regards, Dmitrij

Votes for this answer: 1
 
Lars Larsen
Posted on 28/05/2015 15:45:53
Reply

Hi Dmitrij

Thanks, that did the trick :-)

 

You must be logged in to post in the forum