Hi,
Whenever a report is needed for bulk data import, for example creating CRM cases,
it is very difficult to create such a report using a process with an array configuration.
another issue regarding the Simple/Custom button.
the Simple settings, allows for easy fields selection, but does not include the full path of the field in the model.
this leads to mapping problems when a field appearing more than once in the Excel file, for example firstName X2 instead of personalDetails.fullName and partnerDeatils.firstName.
in the Custom settings we can manually name the field with the full path, but this interferes with Array fields [*].
To overcome this issue i need start with simple, select the required fields for import, then switch to Custom for the mapping stage excluding the array fields, then switching back to Simple and hoping the mapping is saved.
in conclusion I would like the simple settings to save the full path of the fields.
and would also like to add a special setting for Arrays, because arrays can stretch from 1 item to the max items defined, the columns of the report also change, which ruin the mapping at the receiving program.
Comments
4 comments