Creating an Excel import
When you have created your data items and have added properties to them, you can import data using the Excel import functionality.
First make sure that the data item allows users to import data.
Go to Design and then Data.
Click on the data item for which you want to enable user import.
Click on the pencil in the upper righthand corner:
Check the box that allows users to import:
Click edit to save or cancel if there was nothing to change.
Create a user flow so users can import data.
Go to Design and then User flows.
Choose import and delete or only import:
Choose whether you want to allow duplicate items or not:
Publish the design.
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 Excel file 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.
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.
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.
- Triggre will not update or delete.