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 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.
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
If you're using scripts, you can export to an array of JSON objects.
[
{
"name": "Potion",
"price": 20
},
{
"name": "Sword",
"price": 500
}
]
Last modified 9mo ago