We're updating the issue view to help you get more done. 

Create a way to skip one field in a container if multiple other fields in the same container do not have any data to be imported

Description

Example in this record, under physical characteristics screen, dimensions container. There should only be one container but since I have Frame as a constant in the mapping it creates a new container with Frame the only value in the container.
I'd like to be able to skip the constant / skip import of that field if all the other fields in the container don't have data imported to them.
http://amherst.whirl-i-gig.com/index.php/editor/objects/ObjectEditor/Edit/Screen43/object_id/6784
IDNO is 1196.1182
Data source is attached.
Mapping here:
https://docs.google.com/spreadsheets/d/1Gkn7bSVWWmlgdfPQplYWjYZW2IDPN3OSwHVav_8s-3w/edit#gid=0

Activity

Show:
Seth
July 24, 2020, 4:16 PM

I have added six new mapping options to support this:

skipWhenEmpty, skipGroupWhenEmpty, skipRowWhenEmpty, skipWhenAllEmpty, skipGroupWhenAllEmpty and skipRowWhenAllEmpty

All six take a list of placeholder values. skipWhenEmpty and friends will skip a mapping/group/row if ANY of the placeholder values in the list is empty. skipWhenAllEmpty and friends will skip a mapping/group/row only if ALL of the placeholder values in the list are empty.

For your issue adding this option to any of the mappings in the “dimensions1” group will cause the entire container to be skipped if all of the values are empty:

{"skipGroupWhenAllEmpty": ["^36", "^37", "^38","^39"]}

Seth
July 24, 2020, 4:16 PM

A revised mapping is attached.

Note that these changes are only on the Amherst test instance and not in Git yet.

Assignee

Seth

Reporter

Lauren Sorensen

Labels

None

Priority

Major
Configure