Data integration: groups import issue

Martijn van Tongeren

Posted on 22/06/2016 11:53:19

Hi,

I have a problem with import groups with data integration. (DW version 8.8.1.5)

My source is: SQL Provider with views Destination is Ecom Provider. I mapped my source to EcomGroups. The groups are imported in the database but not attached to the Shop. I saw table EcomShopGroupRelation is empty (I configured the destination settings, so set the shop and the default language).

Can the Ecom Provider handle this?

Replies

Morten Snedker

Posted on 22/06/2016 12:30:01

This post has been marked as an answer

Hi Martijn,

When importing groups using Ecom Provider, you should make sure to add a mapping to destination column "Shops". As stated in the documentation:

This field should contain a list of ShopIDs or ShopNames, in which the current group should be updated/created. This should be in the following format: "Shop1","Shop2","Shop3". If the list contains only one shop, the value should still be enclosed in quotation marks. If one ore more values in the list are not found in the EcomShops table, new shops are created, named for these values.

Applying the mapping as instructed should cause for rows to be added to table EcomShopGroupRelation, which again should make them appear below the shop in backend.

Hope the above is helpful.

Best regards
Morten Snedker

Votes for this answer: 1

Martijn van Tongeren

Posted on 22/06/2016 12:45:32

Thanks, i already try this bij adding the shop id and i also tried to add the shop name but without succes :(

Morten Snedker

Posted on 22/06/2016 13:13:31

This post has been marked as an answer

If you have a setup where mapping "Shops" is set in the import job, AND you have a public URL we can access - then I'll take a brief look at it.

Best regards
Morten Snedker

Votes for this answer: 1

Morten Snedker

Posted on 22/06/2016 13:29:43

Hi again Martijn,

Please check out this video: http://screencast.com/t/AQMhXWhR49q.

Showing my source (table Test in database Test). Using SQL Provider for source, using Ecom Provider for destination. Please also notice my 'test' table, having the shop value in quotation marks, like: "SHOP1".

Other than that you'll see the process of job setup, till data appearing in proper places in database. The video didn't show, but group appeared just fine in backend.

Let me know if it helps.

Best regards
Morten Snedker

Martijn van Tongeren

Posted on 23/06/2016 08:42:26

Ok great, i put it on: http://inthenk.test1.innovadis.com/Admin/

BTW i am unable to view the screencast: We're sorry, but this content cannot be displayed right now. It might be that the owner needs to give you permission to view it.

Martijn van Tongeren

Posted on 27/06/2016 13:17:34

Hi Morton,

Do you have time this week to look at this issue, that will be great :)

Br, Martijn

Nicolai Høeg Pedersen

Posted on 27/06/2016 13:53:04

Morten is Off on vacation sitting on a bitch (read beach) drinking colorful drinks and relaxing with sunglasses.

But I'll ask Dmitrij to take a look at this.

BR Nicolai

Martijn van Tongeren

Posted on 27/06/2016 16:10:09

whaha, ok great!

Dmitriy Benyuk

Posted on 29/06/2016 16:36:45

Hi Martijn,
the problem is with "prepend" statements for the columns. The "prepend"/"append" values are processed after searching existing data which can be a problem here.
Could you try to setup the job without them?
Also as a workaround I was adding the Dynamicweb provider job on your test site, but it didn't succeded as there is some groups duplication for the languages, and Dynamicweb provider can not handler that.
Regards, Dmitrij

Martijn van Tongeren

Posted on 08/07/2016 14:41:48

Hi Dmitrij,

Unfortunately that doesnt work i removed all the prepend still the table EcomShopGroupRelation is empty. Could you please take a look at this this?

BR Martijn

Dmitriy Benyuk

Posted on 08/07/2016 17:42:04

Hi Martin,
I was trying to reproduce with XML provider as a source and Ecom as destination and it worked fine. Could you set your jobs one for exporting data from DW view provider to XML file, and then
another job to import from XML to Ecom?
Regards, Dmitrij

Martijn van Tongeren

Posted on 11/07/2016 15:40:53

Hi Dmitrij,

Yes thats works, but this is a workaround, do you know why it's not working if i directly import from a database view to ecom?

Br, Martijn

Dmitriy Benyuk

Posted on 14/07/2016 17:10:53

Hi Martijn,
It looks like a bug, but I wasn't able to reproduce it locally with SQL Views provider -> Ecom. From the test site it looks like you are using the same SQL server to get data from and to import to, maybe that can be a reason, but I am not sure.
Regards, Dmitrij

You must be logged in to post in the forum

Developer forum

Data integration: groups import issue

Replies