Import a relational table

1. Navigate to Data > Import New and import your database file as follows.
   1. Provide a unique name.
   2. Choose a location (Private or Shared).
   3. Select Relational Table from the drop down menu.
   4. Restricted Database is selected, and is the only option for a relational table.
   5. Choose to Upload a file from local hard drive or Select a file from Stored Files, and click Browse to locate the file you want to use (CSV, PSV, or TSV files are supported).
   6. Click Next.
2. Check the box next to First row contains field names.

   Make sure your file has field names in the first row as you will not be able to create field names later.

3. Optional: select Date Field Formatting.
4. Click Next.
5. Select the field type for each table field from the drop-down.
6. Click Next.
7. (Optional) Click Edit Unique Identifiers to make changes to unique identifier(s) for your table.

   The value in the field (or combination of fields) chosen as the unique identifier(s) must be unique for each row in the table.

8. Click Next.
9. Select Submit Job.

Next, associate the table to your Acoustic Campaign database.

Update a relational table

1. Have your CSV, TSV, or PSV file with the updated records available for upload.
2. Log in to Acoustic Campaign and go to Data > Import Update.
3. Change the Choose Import Update Type selector to Relational Table.
4. Click Select Table to select the relational table that you want to update.
5. Select the radio button to indicate if you are Adding Only, Updating Only, Adding and Updating, or Replacing records.
6. Choose the correct file type: CSV, TSV or PSV.
7. Locate the file that you are uploading and click Next.
8. Check the box next to First row contains field names if the first row in the file contains field names.
9. Choose how your dates appear on the imported file.
10. Click Next.
11. Ensure that each field from the file is mapped to the correct relational table field.
12. Click Next.
13. Click Next again.
14. Submit.