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