Create Tabular Data Formats for Importing Literature References

Tabular Data Format records define custom data mappings for importing literature references from database files, allowing users to flexibly import literature data from a variety of sources beyond the standard supported formats (such as RIS and JAPIC ZIP). Similar to the Safety intake use case, each Tabular Data Format contains Import Field Mappings that specify how Vault maps data from columns in the imported file to fields on the Literature Article or Literature Author object.

Vault supports custom data mapping for importing the following file formats:

  • CSV
  • TXT
  • ZIP (containing CSV or TXT) files

We recommend you create a unique Tabular Data Format for each unique file format from a literature database from which you plan to import Literature Articles. This allows users to select the appropriate Tabular Data Format based on the source of the import file.

Prerequisite

To use this feature, you must enable Importing Literature References from Databases.

Create a Tabular Data Format

To create a Tabular Data Format:

  1. Navigate to Business Admin > Objects > Tabular Data Formats.
  2. Select Create.
  3. Populate the applicable fields, then select Save:
    • Format: Enter a name.
    • Tabular Data Format Type: Select Literature Article to import Literature Article or Literature Author data.
    • Country: Select the relevant Country.
    • Encoding: Select an encoding type.

Next, create Import Field Mappings for the Tabular Data Format to define how Vault maps data from columns in your imported files to fields within any Literature Articles and Literature Authors Vault creates during the import process.

Create an Import Field Mapping

To create an Import Field Mapping:

  1. Navigate to Business Admin > Objects > Tabular Data Formats > [Tabular Data Format].
  2. Expand the Field Mapping section, then select Create.
  3. Populate the applicable fields, then select Save:
    • Tabular Data Format: Vault populates the initiating Tabular Data Format.
    • Source Column Header: Enter the exact name of the column header in the CSV file.
    • Target Object Name: Enter the name of the Vault object to which the target field belongs:
      • To import Literature Article data, enter literature_article__v
      • To import Literature Author data, enter literature_article_author__v
    • Target Field Name: Enter the name of the Vault object field to which Vault should map data in this column, using the format field_name__v.