Excel Import - When To Use Reference

0
Hi – I have parent rows already existing in entity A. I’m using the Excel import from the app store to import child records into separate entity B … Do I need to use “Reference” when mapping key columns in the Excel import, or can I just use “Attribute”? When I use “Attribute” my child records import OK. When I use “Reference” for my key columns, the key columns come over as blank. Is there a way just to use “Attribute” and link the child records somewhere in the app, e.g., XPath in the form that displays? If so, how would that XPath look like?
asked
2 answers
0

You use ‘Reference’ if you want the imported column to be stored in an entity that is associated with your main entity, instead of in your main entity. Or as the AppstoreApp’s documentation phrases it:

Reference to import objects

Sometimes you want each imported object to have a reference to one existing object. For example, you want each object to reference the FileObject it was created from. Set this field to the reference you want to fill this way. When you call the import Java action the selected reference will be set with the object which you can provide as a parameter in the action.

XPath is not used here. ExcelImporter will check for the referenced object by key:

answered
0

I’ve found “Reference” only to work if the main entity doesn’t have the row populated. Is this by design?

answered