Import from Excel

You are here:

You can either create a new record or edit an already existing record using the Import from Excel feature. This can be done in two ways:

  1. Create a new record using the data from the imported Excel file: Press the Import from Excel button on the Data page menu.
  2. Update an existing record with the data from the imported Excel file: Press the Import from Excel button under the Actions column next to that record. Note that this will replace any saved data bby adding a new version of the record (the previous version can still be accessed from Record History) with those from the uploaded file. This also means that saved records can be replaced with null values if no data was entered into those named ranges in the uploaded Excel file. If a control has “Allow Null Values” disabled, a default value will be populated instead (e.g. false for bool or 0 for numbers).

Possibly the easiest way to use this feature is by using either the underlying workbook, or a trimmed down version of it as the template.

On the Import data from Excel file menu, the application that the import process will apply to is shown under the Name of the Application field. When using the import button next to a record for updating it, the ID of the database record will be shown in the Record ID field (when adding a new record using this feature, the Record ID field will not be available).

The Data File field accepts only a single *.xlsx file. When the file upload is complete, press Import from Excel to continue. If the named ranges in the uploaded workbook match those in the target application’s underlying Excel file, the value of the imported file’s named ranges will be used to generate a new record or update the selected record.

For one-to-many tables, the table named range must match the naming of the table named range in the target Excel file. If the table named range in the Excel file does not match the size of the table named range associated with the application, the system will attempt to fit the data into the table format wherever possible, inserting from top-left to bottom-right, until it runs out of space in the sizing of the target named range. For example, if the transaction has the named range as 5×5 and the Excel file’s table is 6×10, the system will attempt to import the first 5 columns and first 5 rows, skipping the header as necessary.