CSV File Formats

Each CSV file contains records in one of two formats: Information Items, or Connections. All lines in a CSV file must be of a single Information Type or Connection Type. You can upload the files in the “Data” area of the Metadata Connect application.

Information Items File Format:

  • Each line consists of Details for an individual Item separated by commas and terminated by a “Return’ or “Enter” symbol (internally \n).
    • Each Detail must be pre-defined in the definition of the Information Type in the database.
    • Details may be in any order and not all Details of an Item need be included, but each record must have the same Details in the same order.
    • We recommend putting the Detail named Key first (highlighted below).
  • Example: A file of Information Items of type Book might look like this:

    Book1, Ethics For Villains, A. Moriarty, 2024, 312-1-53-874309-5
    Book2, Detecting Villains, S. Holmes, 2025, 312-1-84-603281-4
    Book3, Villainous Detectives, A. Moriarty, 2026, 312-1-53-8825536
    Book4, Detaining Villains, S. Holmes, 2027, 312-1-84-614853

Connections File Format:

  • Each line consists of a Connection Type, the Key of an Ancestor Item and the Key of a Descendant Item separated by commas and terminated by a “Return’ or “Enter” symbol (internally \n).
    • Each Connection Type must be pre-defined in the database.
    • Pre-defined Connection Type Item-Item is used for Ascendant and Descendant navigation.
  • Example: A file of Connections might look like this:
    Item-Item, Book1, Book3
    Item-Item, Book2, Book3
    Item-Item, Book2, Book4