User-Defined and Connected Data Sources can be edited in a variety of ways.
For small Data Sources or those which rarely need to be manually changed or edited, you can edit directly in the web portal. Simply click in a cell to edit/overwrite the data which is already there.
Note, Data Sources with less than 100 rows and 50 columns can be edited directly in the web portal.
For larger Data Sources you can upload either an Excel or CSV file or by making changes to your source if using a data source Connector.
Regardless of the editing method, our platform currently supports a single data source having a maximum of 50 columns and 50,000 rows.
How To
General Rules
There are two general rules which apply to all data sources and should be followed regardless of the method you use to edit/update your data.
- The first column must contain unique values since this will be used as the key/identifier for the row.
- The other columns ideally need to contain data for use in screen types.
Update or Add a Data Source
- Manual cell data row/column additions and edits.
- Import an Excel/CSV file to create or update row/column data.
- Pull data into the platform from an external system using a Data Source Connector (configurable on the data source’s Settings page).
Importing requires an Excel (.XLSX) or Comma Separated Values (.CSV) file which MUST be in the required format.
- The first row of your file is assumed to be the data source headers and the rest are just rows.
- The file must contain at least one row (excluding the header row) and two columns.
- The first column in all rows must be populated with unique values.
A template of the required format can be obtained by clicking the “Import” button and the download link provided prior to importing a file.
Once your data source is populated/updated, be sure to SAVE any changes made.
Export a Data Source
Similarly to importing data from an Excel or CSV file, you can also export data in an Excel document to edit it in your own spreadsheet software.
- Click on the EXPORT button on the top-right corner and on the Export Data Source Rows to File pop-up window.
Optionally, select Anonymize Personal Data. If enabled, data from columns marked as Personal Data will be converted to a non-human-readable format to aid privacy. - After a few seconds the Your Download Is Ready link will display on the left next to the Notifications menu area.
- If you miss the pop-up, simply click the Notifications menu option where you can view all platform exports for download and click the “Download File” link provided for each export.