Developer forum

Forum » Integration » Creating groups when importing products

Creating groups when importing products

E-mail notifications
Imar Spaanjaars Dynamicweb Employee
Imar Spaanjaars
Reply
Posted on 28/05/2017 01:31:56

Hi there,

I am importing products using a CsvProvider as the source and the EcomProvider as the target. My CSV looks as follows:

PID,Name,Groups
1,P1,G1
2,P2,G1
3,P3,G2

When I run a job against this file, no groups are created. I tried quoting the group names (as described in the documentation) like this:

PID,Name,Groups
1,P1,"G1"
2,P2,"G1"
3,P3,"G2"

but that didn't help either. At some point during my experimentation, I did get groups, but no unique values. With the example above, I ended up with three groups, and G1 was listed twice.

Given this sample CSV, how would I import this so I end up with three products and two groups? Any advice?

Thanks,

Imar

 


Replies

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Posted on 29/05/2017 09:01:59
Reply
This post has been marked as an answer

Hi Imar,
this is a bug in the EcomProvider which was introduced in 1.0.3-1.0.17 packages. I'll fix it asap, TFS# 33910.
As a workaround you could try to downgrade the EcomProvider package to 1.0.2.
If you are not using DW9 or using some other package version let me know.
Regards, Dmitrij

Votes for this answer: 1
 
Kristian Kirkholt Dynamicweb Employee
Kristian Kirkholt
Posted on 31/05/2017 10:28:03
Reply

Hi Imar

The problem TFS#33910 "Fix import data using EcomProvider as a destination" has now been fixed in Package "Dynamicweb.DataIntegration.Providers.EcomProvider" version 1.0.18

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

Also the correction are included i release 9.2.14
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

 
Imar Spaanjaars Dynamicweb Employee
Imar Spaanjaars
Posted on 31/05/2017 10:50:27
Reply

Excellent. Thanks guys, I'll try this out.

 
Imar Spaanjaars Dynamicweb Employee
Imar Spaanjaars
Posted on 31/05/2017 20:14:00
Reply

Just tested it and it worked great. Thanks! I thought I was losing my mind when I realized how difficult it was to import such a simple file. requiring way too many steps. Now with the fix in place, it behaves like you would expect: point to file. set up the mapping and run it.

Thanks!

 

You must be logged in to post in the forum