Solved

Import scenario of Customer Contracts with 11 attributes

  • 10 September 2021
  • 6 replies
  • 405 views
A
Rank
Userlevel 1
Badge

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. 

icon

Best answer by Yuri Karpenko 9 February 2022, 10:45

View original
Andre Aysen

6 replies

M
Rank
Userlevel 3
Badge

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

A
Rank
Userlevel 1
Badge

above data provider and below import scenario

duplicate data

 

Andre Aysen
M
Rank
Userlevel 3
Badge

 

A
Rank
Userlevel 1
Badge

Great ! I will give it a go and revert

Andre Aysen
A
Rank
Userlevel 1
Badge

Hi 

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

Andre Aysen
Yuri Karpenko
Rank
Userlevel 7
Badge +6

@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.

Yuri Karpenko | DM me if you need help building e-Commerce for your business or connecting it to Acumatica ERP

Reply


Terms & ConditionsCookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved