The Import module allows you to upload data into an Application via a .csv file.
In order to use the Import module, you must first be part of a role that has been granted the Import module entitlement. If you do not have this entitlement, then you will not be able to bulk import data into LogicGate. Refer to the Module Entitlement for Roles article to learn how to get Import entitlement.
Data can be imported via .csv files to pre-populate Applications with existing data.
1) Navigate to the Import module by selecting the Work tab and then Import.
2) Define which fields will be imported by creating an import layout. Under the Layout drop down, click the create a new one option.
3) Then select the Workflow you will be importing data into and give the Layout a name (so that it can be saved for future use). Then click Create.
4) You can now begin to add fields you wish to import into the layout. The listing of fields will pre-populate as you begin to type. Once a field is selected, click the '+' icon to add it into the layout view at the bottom. Continue this process until the desired fields have been added to the Layout.
5) Once your fields have been added, you can drag and drop the fields to arrange them in the order you would like to upload.
6) Select the Destination Step to determine where the objects will go in the workflow after they are created. Once selected, you can download a template .csv file to use to populate your data.
7) Finally, click browse to select the .csv file which contains your data to begin the upload process -- or simply drag and drop your file into the upload area.
8) If any data cannot be uploaded, a system message will inform you where the upload process stopped. Rows that do not have errors will import successfully, rows with errors will be skipped.
Importing Tips and Tricks
- We recommend saving files as CSV UTF-8 (Comma delimited) (.csv). If you have special characters there could be encoding issues, so this file type helps to avoid those issues.
- You can only import 100 records from a single file at a time. To get around this, you might need to split up a single CSV file into multiple files for import. If a file you import has more than 100 records, then any records after the first 100 will be ignored.
- Upon copying an Application, the data itself will not be copied. As such, you will need to use the above method to import any data that is necessary for a copied and/or imported Application. You may want to also see how to export data from LogicGate.
- There are some field type restrictions to importing data in this manner. Certain fields such as Attachments or Multi-Select will not be available to import. If you have data containing these field types, please speak with your customer success manager to discuss options with them, as there are easy ways to accomplish this as well.
Common Importing Issues
I'm seeing empty rows being imported into LogicGate. How do I prevent this?
- Make sure to delete any empty rows or fields in your .csv file before importing. If there are empty rows, this will import empty records into LogicGate. If there are empty fields, this will trigger an error in your import.
- Sometimes there may be empty rows and fields that you can't see. The best way to prevent empty rows and fields is to highlight everything outside of your data range in Excel and then delete it.
I'm getting error messages when I try to import. What am I doing wrong?
Generally speaking when you get an import error message it is due to the data format.
- Make sure the Date Fields are formatted correctly. Refer to Guidelines For Importing Dates for instructions.
- Fields with discrete options such as Select fields need to match exactly to a predefined record in the system, including spaces. If you have a risk select in LogicGate with "Low", "Medium" and "High", if you try to load a value that is "High " from the CSV it will error.
- Once you have reformatted your csv file, DO NOT reopen the file in Excel. This may trigger Excel to automatically do some additional reformatting and mess up your original format. Instead, upload the file directly into LogicGate. If you do want to reopen your file to check, use a text editor like Notepad++.