Skip to content

# Service 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": "On-site service rate",
            "Active": true,
            "Notes": "Ullam et aliquid reiciendis iure voluptatem minus doloremque doloribus ipsum ut.",
            "Wiki": null,
            "Tags": [
                "blue",
                "brown",
                "mauve",
                "quince",
                "zone6"
            ],
            "AccountNumber": "55753867",
            "Cost": 25.410000000000000000,
            "Charge": 39.390000000000000000,
            "Unit": "hour",
            "ContractOnly": false
        },
        {
            "Name": "Shop rate",
            "Active": true,
            "Notes": "Possimus maiores reprehenderit aut tempora in eos dolor.",
            "Wiki": null,
            "Tags": [
                "blue",
                "green",
                "silver",
                "zone0"
            ],
            "AccountNumber": "71071010",
            "Cost": 12.490000000000000000,
            "Charge": 19.360000000000000000,
            "Unit": "hour",
            "ContractOnly": true
        },
        {
            "Name": "Day rate",
            "Active": true,
            "Notes": "Dolores quo et ipsum ut.",
            "Wiki": null,
            "Tags": [
                "silver"
            ],
            "AccountNumber": "50669139",
            "Cost": 300.000000000000000000,
            "Charge": 500.000000000000000000,
            "Unit": "day",
            "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
    On-site service rate,true,Ullam et aliquid reiciendis iure voluptatem minus doloremque doloribus ipsum ut.,,"blue,brown,mauve,quince,zone6",55753867,25.41,39.39,hour,false
    Shop rate,true,Possimus maiores reprehenderit aut tempora in eos dolor.,,"blue,green,silver,zone0",71071010,12.49,19.36,hour,true
    Day rate,true,Dolores quo et ipsum ut.,,silver,50669139,300,500,day,false