"Which target items to clear prior to import?" doesn't work as i expect
Hi Guys!
I would like to clear all data from my module before a new data import is done. This is important for my process as there is not always data for all combinations. But I'm not having any success with it.
I created a module to exemplify my error:
"TEST01 Clear Data" has data for all combinations (1 a 10)
My import has data for combinations (1 a 5)
In "which target items to clear prior to import?" i select "All Items", my expectation was that all data would be deleted before importing
But after charging, the data is not erased.
Result:
My expectation was that the data for items 6 to 10 would be deleted.
Best Answer
-
Within the import action you need to update the tab called "SS_Counting_1000", see highlighted tab below. This is the list that is applied to the module, if you wish for ALL list items to be cleared even if they are not present in the import source then you select "All items" under the question "Which target items to clear prior to import".
The setting you updated pertains to line items, so if for example the target modules contained multiple line items they would all be impacted by the import even if there is no source item in the file. In other words, you updated the wrong section of the import configuration to achieve your stated objective.
1
Answers
-
@Guilhermecord10 - if you wish to clear the data across all list items you will need to setup the action to clear "All Items". Check the tab titled "SS_Counting_1000", that is the list dimension where you need to define the clear all behavior.
Sharing a resource that may help to explain the difference in the setup options:
0 -
I don't understand, Tiffany.
Where should I make this "All Items" mark?
Result:
My expected result after charging:
0 -
Wow!
It worked, i hadn't understood that i needed to mark the dimension. Thank you very much!1