Data Import/Export Admin Page

Data Import/Export Admin Page

Data Import/Export

This feature can be used to easily access and manipulate data in a specified K-Rise table. The Download tab can be used to export data and the Upload tab can be used to import data.

Data Export

The Download tab allows admins to view the contents of the chosen table ten records at a time. This can be used as a quick look at specific table data or data can be exported to CSV by using the icon in the bottom left corner.

Data Import

The Upload tab allows admins to download a CSV template of a specified K-Rise table. This is often used for initial set up of a site to import new users. Each choice in the list section is a column in the chosen table. Specific columns can be chosen by utilizing the corresponding checkboxes on the left. The downloaded template will only have columns that have been selected.

If a column is a primary key, you will not be able to deselect it.

With the downloaded CSV template, records can be entered and submitted to be imported into the specified table. There is no validation for any of these fields, so the data that is entered will be inserted into the corresponding column. You will get a truncation error if the record is larger than the column it is being entered into.

PRC-10000634 Batch Job: Upload Entity:

The entity upload utilizes PRC-10000634 Batch Job: Upload Entity. This process uses the K-Rise table [EP_Entity_Upload] to store and later retrieve the file path for the saved upload template to be used in the batch job.