Import Data

When you have a lot of external data to input at once, it might be easier to organise it in a spreadsheet or use a script. In those cases, you can import the resulting CSV or JSON directly into FrontierNav.

Before trying to import anything, use Edit Data Tables to make sure you have created all the Entity Types and Properties that you plan to import.

Choose a file and you will be presented with a form.

The default import form

First select the Entity Type to import into. After that, select the criteria to match an Entity to a row in your file. Finally, set the matched Entity's properties to columns in that row.

If a row does not match any entity, by default it will be ignored. You can choose to create an Entity instead. However, if doing so, you need to set a unique Name property. The import will fail if there is no Name.

You can do the same when setting Relationships, where you do not need a Name, but a target Entity must match. If you want to create the target Entity too, you must match a unique Name otherwise it will be ignored.

Importing a CSV that creates new rows for any unmatched names.

Supported File Formats

CSV

CSVs are a file format that most spreadsheet software can export to so check your "Save As..." or "Export" options and choose "CSV". You MUST have column headings.

Name,Price
Potion,20
Sword,500

JSON

If you're using scripts, you can export to an array of JSON objects.

[
  {
    "name": "Potion",
    "price": 20 
  },
  {
    "name": "Sword",
    "price": 500
  }
]