Skip to main content

Hi all. I am trying to develop a data provider that allows for import/export of Customer Contracts with 11 attributes. Somehow when testing it the first attribute repeats itself 11 times in the export. Is the “design” of the Excel data provider incorrect. 

Could you share a screen shot of your data provider and your import scenario?


above data provider and below import scenario

duplicate data

 


 


Great ! I will give it a go and revert


Hi 

  • MRoszkowski15 still getting same results. Changed Import scenario and ran export scenario as per import.


@andre89 , the reason you’re getting 11 lines is because you have 11 attributes. Some entities allow for mapping of attributes in a single line (stock or non-stock items, for instance). But customer contracts don’t have that. Your best bet is to design you import / export in a way that if you have multiple attributes, you will have a separate line for each of those attributes. In your Data Provider, you would have all the data in each line, and only attribute ID and attribute value would be different from line to line. In the mapping, it would look something like this:

P.S. Attribute ID and Attribute Value should be the names of actual columns you have in your data provider.


Reply