The importing tool allows uploading Excel spreadsheets and CSV files to QuickBPM apps. This way you can quickly populate your apps with a large amount of data.
Only the users included in the Administrators group can upload data to QuickBPM apps.
To start importing, follow these steps:
1. Create an app that will store the data.
To ensure that data is imported correctly, add fields to the app form that will store this data. Suppose you want to upload customer database to QuickBPM. Customer data is stored in xlsx table in the following columns: company name, phone, email address, contact person, and bank details. In order to complete the import, first, create a relevant app and add to its form fields of the appropriate type: string (to add the name), phone number, email, full name, text. More information about the types of fields in QuickBPM can be found in this article.
2. Generate app template.
A template is used to align an uploaded file with the importing requirements.
To download a template, click the gear icon next to the name of the app, then select Data - Import. In the pop-up, choose the type of the template - xlsx or csv - depending on which file you plan to import.
3. Bring the imported file in accordance with the template.
A template contains a table with columns that match app fields. In each column, there is an example of data it may contain.
You can copy the name of the columns to the imported file or fill out the template with your data.
4. Upload the file populated with data to QuickBPM.
Once you completed all the above steps, the data can be imported into the system. To do this, click on the gear icon to the right of the app name, then select Data - Import. In the window that opens, upload the imported file.
What to keep in mind when importing data
When importing, existing app items are not updated.
If you export data from an existing app, make changes to it, and then upload it to the system again, the existing app items will not be updated. In this case, new app items will be added that will contain the edited data.
Importing multiple values
If you want to import multiple values to one QuickBPM filed, use a comma (,) as a separator.
firstname.lastname@example.org, email@example.com - allows you to add two email addresses to one field.
This works for the following types of fields: number, category, phone, email address, link, user, app.
The format of the loaded data must match the type of field. Otherwise, you will see a warning indicating the row and column in which the incorrect entry was found.
Correct the entry and continue importing.