Overview
Import a CSV file to create data tables that you can use in forms within Mirata.
1. Prepare Your CSV File
Format the Data
Start by organizing your data in a spreadsheet program. Ensure each column has a clear title, such as "State", "Code", or "Population".
Add a "key" column with unique identifiers. This key column ensures each row has a unique identifier, which is essential for updating or deleting records later.
Save the file as a comma-delimited CSV file.
2. Upload the CSV File in the Admin Tool
Access the Admin Tool
Go to the Admin Tool tab
Click Data Tables
Click Add Data Table in the top right.
Click IMPORT
Select your prepared CSV file.
You can change the name and description of your table. Do not change the table type or storage type.
Click SAVE
Go to the SCHEMA tab
Click the pencil icon and:
Change the data types of any columns, if necessary. In this example, we will change the Population column to a decimal.
Uncheck the required checkmark if a value is not required in that column for every record in the table
Once we have the schema completed, we will next upload the records.
Go to the RECORDS tab
Click the UPLOAD CSV icon
Click SELECT FILE
Select your CSV file
The “key” column from your CSV file should automatically be selected in the Key Field Name dropdown, but, if it’s not, select “key” from the list
Click GENERATE DATA TABLE RECORDS
Depending on the size of the file, it could upload instantly or take a few minutes.