When setting up the Excel sheet, make sure that the name of the sheet in the Excel file matches the name of the data item in Triggre. To be clear: the name of the Excelfile is not important, the name of the sheet is what matters.
Name the tabs in your Excel sheet after the data items in your design:
Put the property names in the first row of the sheet:
If you’re going to import using ‘do not allow duplicates’, you must tell Triggre which property identifies the item, so it knows which property it has to check.
Add “[ID]” to that property name in the sheet (Product code[ID]). You can only define one column as an identifier:
If you’re going to import using ‘Allow duplicates’, there should be no [ID]-property in the sheet.
You can import more than one data item using only one Excel file. Every sheet in the file refers to a data item:
Tip: You cannot combine the import of the type ‘Allow duplicates’ and ‘Do not allow duplicates’ in one Excel file.
4. Import data
With the Excel sheet properly set up, you can start the import.
Go to your application and select the Excel import user flow in the menu.
Select the Excel file from your computer or cloud storage.
Check the delete checkbox if you want to delete data. To add data leave the field unchecked.
Triggre will upload the file and check the content. If everything is ok, it will process the data. If it finds one or more errors, it will tell you about it and it will not process any data.
5. Additional info
When deleting data using the Excel import:
If one or more rows in the sheet have no match in the application, Triggre gives you an error message and it terminates the flow.
If the sheet has no [ID]-property, Triggre gives you an error message and it terminates the flow.
If no errors are found, Triggre will delete the matching items.
Triggre will not update or create items.
When adding data using the Excel import, without allowing duplicates:
Triggre will update matching items.
Triggre will create items that don’t exist in the application yet.
When adding data using the Excel import, allowing duplicates:
Triggre will create all items that are in the sheet, even if they already exist in the application.