Skip to content

Travel rate import / update specifications

Names of fields listed here are the exact case and spelling required to be recognized by AyaNova for importing / updating.

Any field in the import file that is not listed on this page will be removed before sending to the server for import.

Required fields

  • Name

Key field used to match to existing records

  • Name

Fields directly importable / updateable

  • Name (import only)
  • Active
  • Notes
  • Wiki
  • Tags
  • AccountNumber
  • Cost
  • Charge
  • Unit
  • ContractOnly

JSON file format

The .json file must contain an array of one or more objects.

[
    {
        "Name": "Indigo BB",
        "Active": true,
        "Notes": "Eligendi ipsum totam odit omnis eius et at.",
        "Wiki": null,
        "Tags": [
            "brown",
            "green",
            "orange",
            "zone7",
            "zone9"
        ],
        "AccountNumber": "68876012",
        "Cost": 8.470000000000000000,
        "Charge": 16.940000000000000000,
        "Unit": "km",
        "ContractOnly": false
    },
    {
        "Name": "Cyan TT",
        "Active": true,
        "Notes": "Enim quis adipisci eum ea molestias aut porro.",
        "Wiki": null,
        "Tags": [
            "indigo",
            "yellow"
        ],
        "AccountNumber": "80516729",
        "Cost": 9.390000000000000000,
        "Charge": 18.780000000000000000,
        "Unit": "hours",
        "ContractOnly": false
    },
    {
        "Name": "Teal AW",
        "Active": true,
        "Notes": "Rem aperiam non qui illum doloremque iusto eos enim inventore.",
        "Wiki": null,
        "Tags": [
            "white",
            "yellow",
            "zebra"
        ],
        "AccountNumber": "83302044",
        "Cost": 3.170000000000000000,
        "Charge": 6.340000000000000000,
        "Unit": "miles",
        "ContractOnly": false
    }
]

CSV file format

The first row of the .csv file must contain column headers that match the field names listed above.

Name,Active,Notes,Wiki,Tags,AccountNumber,Cost,Charge,Unit,ContractOnly
Indigo BB,true,Eligendi ipsum totam odit omnis eius et at.,,"brown,green,orange,zone7,zone9",68876012,8.47,16.94,km,false
Cyan TT,true,Enim quis adipisci eum ea molestias aut porro.,,"indigo,yellow",80516729,9.39,18.78,hours,false
Teal AW,true,Rem aperiam non qui illum doloremque iusto eos enim inventore.,,"white,yellow,zebra",83302044,3.17,6.34,miles,false