How can I import a new relational table from a file?

Follow these steps to create a new relational table by importing files that you already created. Files must be in CSV, TSV or PSV format and can be uploaded from your hard drive or stored files.

About this task

There are two ways to create a relational table in Acoustic Campaign.

  • Importing a CSV, TSV, or PSV file; or
  • Through the API.

This procedure explains how to create a relational table by importing a file.

Procedure

  1. Navigate to Data > Import > New.
  2. In the Name field, give your relational table a name.
  3. From the Choose Import New Type menu select the Relational Table option.
  4. To upload an existing file stored on your computer, choose the Upload file from local hard drive option and click Browse.
  5. Map fields from your file to the fields in your Acoustic Campaign database.

    Make sure that you select the appropriate field types and unique identifier.

  6. Click Submit to run the import data job.

What to do next

Next, associate the table to your Acoustic Campaign database.