Skip to content

# Head office 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
- WebAddress
- TechNotes
- AccountNumber
- ContractExpires
- Phone1
- Phone2
- Phone3
- Phone4
- Phone5
- EmailAddress
- PostAddress
- PostCity
- PostRegion
- PostCountry
- PostCode
- Address
- City
- Region
- Country
- AddressPostal
- Latitude
- Longitude

## Linked object fields

The following linked objects are supported for importing / update:

- Contract via "ContractViz" field which must contain the name of an existing Contract. If the Contract is specified then the ContractExpires field can be used to set the expiry date of the Contract. If ContractExpires is omitted then it is set to the import date and time minus 1 minute so that it won't take effect until it's been set to a future date.

## JSON file format

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

    [
        {
            "Name": "Goodwin LLC",
            "Active": true,
            "Notes": "Triple-buffered mission-critical website",
            "Wiki": null,
            "Tags": [
                "jade",
                "zone5",
                "zone7"
            ],
            "WebAddress": "http://example.info",
            "AccountNumber": "32906249",
            "ContractViz": "Bronze",
            "ContractExpires": "2023-02-01T08:00:00Z",
            "Phone1": "1-629-420-0186",
            "Phone2": "1-807-405-5544 x2470",
            "Phone3": "352-364-6323 x45752",
            "Phone4": null,
            "Phone5": null,
            "EmailAddress": "Heloise_Farrell61@example.com",
            "PostAddress": "865 Tracey Views",
            "PostCity": "New Mathew",
            "PostRegion": "Louisiana",
            "PostCountry": "Jordan",
            "PostCode": "74354-4982",
            "Address": "3400 Tyree Keys",
            "City": "New Mathew",
            "Region": "Louisiana",
            "Country": "Jordan",
            "Latitude": -56.030700,
            "Longitude": 169.844400
        },
        {
            "Name": "Bahringer - Stark",
            "Active": true,
            "Notes": "Enhanced reciprocal matrix",
            "Wiki": null,
            "Tags": [
                "green",
                "red",
                "zone8"
            ],
            "WebAddress": "http://example.name",
            "AccountNumber": "71115129",
            "ContractViz": null,
            "ContractExpires": null,
            "Phone1": "530.785.2024 x019",
            "Phone2": "418-629-2283 x34011",
            "Phone3": "347.447.3645",
            "Phone4": null,
            "Phone5": null,
            "EmailAddress": "Alysa.Mertz@example.org",
            "PostAddress": "0511 Deckow Stream",
            "PostCity": "Lake Cotyhaven",
            "PostRegion": "Nevada",
            "PostCountry": "Comoros",
            "PostCode": "41680",
            "Address": "2438 Sibyl Neck",
            "City": "Lake Cotyhaven",
            "Region": "Nevada",
            "Country": "Comoros",
            "Latitude": -51.706500,
            "Longitude": -22.044300
        },
        {
            "Name": "Beer, Armstrong and Wiegand",
            "Active": true,
            "Notes": "Compatible clear-thinking concept",
            "Wiki": null,
            "Tags": [
                "zone3",
                "zone9"
            ],
            "WebAddress": "https://example.org",
            "AccountNumber": "95120864",
            "ContractViz": null,
            "ContractExpires": null,
            "Phone1": "986-530-1111",
            "Phone2": "1-695-482-1199 x321",
            "Phone3": "653-466-6627 x117",
            "Phone4": null,
            "Phone5": null,
            "EmailAddress": "Elisa41@example.org",
            "PostAddress": "15461 Deangelo Tunnel",
            "PostCity": "Kuvalisland",
            "PostRegion": "Florida",
            "PostCountry": "Sri Lanka",
            "PostCode": "15255-8577",
            "Address": "4695 Sandra Tunnel",
            "City": "Kuvalisland",
            "Region": "Florida",
            "Country": "Sri Lanka",
            "Latitude": -19.439100,
            "Longitude": -112.588800
        }
    ]

## 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,WebAddress,AccountNumber,ContractViz,ContractExpires,Phone1,Phone2,Phone3,Phone4,Phone5,EmailAddress,PostAddress,PostCity,PostRegion,PostCountry,PostCode,Address,City,Region,Country,Latitude,Longitude
    Goodwin LLC,true,Triple-buffered mission-critical website,,"jade,zone5,zone7",http://example.info,32906249,Bronze,2023-02-01T08:00:00Z,1-629-420-0186,1-807-405-5544 x2470,352-364-6323 x45752,,,Heloise_Farrell61@example.com,865 Tracey Views,New Mathew,Louisiana,Jordan,74354-4982,3400 Tyree Keys,New Mathew,Louisiana,Jordan,-56.0307,169.8444
    Bahringer - Stark,true,Enhanced reciprocal matrix,,"green,red,zone8",http://example.name,71115129,,,530.785.2024 x019,418-629-2283 x34011,347.447.3645,,,Alysa.Mertz@example.org,0511 Deckow Stream,Lake Cotyhaven,Nevada,Comoros,41680,2438 Sibyl Neck,Lake Cotyhaven,Nevada,Comoros,-51.7065,-22.0443
    "Beer, Armstrong and Wiegand",true,Compatible clear-thinking concept,,"zone3,zone9",https://example.org,95120864,,,986-530-1111,1-695-482-1199 x321,653-466-6627 x117,,,Elisa41@example.org,15461 Deangelo Tunnel,Kuvalisland,Florida,Sri Lanka,15255-8577,4695 Sandra Tunnel,Kuvalisland,Florida,Sri Lanka,-19.4391,-112.5888