Skip to main content
Solved

Import scenario of Customer Contracts with 11 attributes

  • September 10, 2021
  • 6 replies
  • 471 views
A
Freshman I
Forum|alt.badge.img

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. 

Best answer by Yuri Karpenko

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

Andre Aysen

    6 replies

    M
    Jr Varsity III
    Forum|alt.badge.img
    • MRoszkowski15
    • Jr Varsity III
    • September 10, 2021

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

    A
    Freshman I
    Forum|alt.badge.img
    • andre89
    • Author
    • Freshman I
    • September 10, 2021

    above data provider and below import scenario

    duplicate data

     

    Andre Aysen
    M
    Jr Varsity III
    Forum|alt.badge.img
    • MRoszkowski15
    • Jr Varsity III
    • September 10, 2021

     

      A
      Freshman I
      Forum|alt.badge.img
      • andre89
      • Author
      • Freshman I
      • September 10, 2021

      Great ! I will give it a go and revert

      Andre Aysen
      A
      Freshman I
      Forum|alt.badge.img
      • andre89
      • Author
      • Freshman I
      • September 10, 2021

      Hi 

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

      Andre Aysen
      Yuri Karpenko
      Captain II
      Forum|alt.badge.img+6
      • Yuri Karpenko
      • Captain II
      • Answer
      • February 9, 2022

      @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
        Terms & ConditionsCookie settingsAccessibility statement
        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