We have a module applying list subset, and while trying to import list items that are not located within the subset using CSV, the system did not show any error message (ignore instead of failed), while another module was able to show item not located within the subset.
I have checked the import action mapping, if the item is not located within the subset, item will not be mapped and not ignored (map automatic by name). We were wondering if anyone have encountered the same issue and have understanding with the system behavior on reporting an unmapped item.
I have tested this with several scenario myself, still couldn't find the root cause:
Scenario1
Module: List Subset A, List Subset B, List C, Time Dimension (month), Line Item (Value)
Import CSV Mapping: Column A: List Subset A
Column B: List Subset B
Column Header: Time
Ask each time when import for List C
Import into Fixed Line Item
Some lines in the CSV are not included in Subset A or Subset B.
Outcome:No error message, items not located in the subset are ignored.
Scenario 2
Module: List Subset A, List Subset B, List C, Line Item (Boolean)
Import CSV Mapping: Column A: List Subset A
Column B: List Subset B
Column Header: Line Item (Boolean)
Ask each time when import for List C
Some lines of the CSV are not included in Subset A or Subset B.
Outcome: See screenshot below
Scenario 3
Same setting as scenario 1, but import user does NOT have Selective Access to certain List item in list A/B.
Outcome: no warning, number successfully imported into the module.
While we reached out to support, we were thinking if anyone within the community happens to have some insight with the system behavior. Our client relies on the error message for better management of their subset and selective access, so this somehow becomes a road blocker for their user access governance.
Appreciate for any inputs on this matter, thanks!
