Question

Import Scenario on attributes without overriding existing data. 

  • 12 March 2021
  • 8 replies
  • 1296 views
S
Rank
Userlevel 4
Badge +1

Hello 

 

I'm attempting to create a single import scenario on InventoryItem attributes to update any item attributes without overriding the existing data. 

 

When running an import scenario with item InventoryItem attributes, if a field is empty on the import source sheet, then on import, it will override the data in the destination in that field and make it blank. 

 

I tested in the mapping sections using ISNULL([WILDLIFE],[Answers.Value]) in the Source field/Value, and had success. The issue I face is attributes that are checkboxes. The date gets imported as "False". I tried various IIF statements, with and without converting the data to different data types, and still no success. 

Schneur Perl

8 replies

Irina
Rank
Userlevel 7
Badge +8

Hello @schneur96, you can try to set Target Restrictions as a w/a.

Could you please share your scenario or provide a screenshot for mapping?

Best regards, Irina
S
Rank
Userlevel 4
Badge +1

I tried testing with source restrictions and target restrictions on the import scenario. To my understanding, this function will not work for this need. 

I left my last If statements in source felid.

ENDOFLIFE and ROSHCOMP are fields that are checkboxes. 

  

Schneur Perl
Yuri Karpenko
Rank
Userlevel 7
Badge +6

For the last 2 attributes, try this:

=IIF([ENDOFLIFE]=FALSE,False,IIF([ENDOFLIFE]=1,True,False))

 

Please note that FALSE is misspelled in your screenshot.  Also, I would use False and True vs 0 and 1 (not sure if it makes a lot of difference though).  Finally, if all lines in your data provider have either FALSE or TRUE in the ENDOFLIFE field, I would simplify the statement like this:

=IIF([ENDOFLIFE]=FALSE, False, True)

Yuri Karpenko | DM me if you need help building e-Commerce for your business or connecting it to Acumatica ERP
Irina
Rank
Userlevel 7
Badge +8

Thank you @yurik05!

Exactly, boolean values in import scenarios should be spelled in this way: False or True.

Best regards, Irina
S
Rank
Userlevel 4
Badge +1

Thanks for all the help; I'm still following short. 

I tested using the suggestion made, and it turns the fields into FALSE, which I don't want. 

From what I have tested on boolean attributes, Acumatica always sets the data as 0 as default. I'm looking to preserve all boolean be either 0 or 1. 

When running an import scenario, if my data on the source sheet is blank for boolean, it turns the data in Acumatica to FLASE, and this is what I'm trying to avoid.

The goal is to have a single import scenario to import any attribute without affecting the existing data in Acumatica. We would fill out only the items and fields to the attributes we are uploading. The fields we leave blank on the import sheet should not override existing data. This has worked well with ISNULL and other data types.

 

Here's the last test I did.
=IIF([DIMMABLE]=FALSE,[Answers.Value],IIF([DIMMABLE]=1,True,IIF([DIMMABLE]=0,FALSE,[Answers.Value])))
The data switches back and forth. If the data in acumatica is 0 and my import sheet is blank, the data turns into FALSE. If we rerun the import on the same data, it goes from FALSE to 0. 

 

 

 

Schneur Perl
jwright
Rank
Userlevel 3
Badge

@schneur96 were you able to figure this out?

Chris Hackett
Rank
Userlevel 7
Badge

Hi @schneur96  were you able to find a solution? Thank you!

Chris ~ Let us know how we're doing: https://forms.office.com/r/xmJUdZ1QE5 - A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.
S
Rank
Userlevel 4
Badge +1

Hi

I will do my best to gather this information and follow up. I dont think I found a direct formula solution to the issues, but learned other important aspects about item attributes.  

Schneur Perl

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