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