Vendor 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
Contact
ContactNotes
AlertNotes
WebAddress
AccountNumber
Phone1
Phone2
Phone3
Phone4
Phone5
EmailAddress
PostAddress
PostCity
PostRegion
PostCountry
PostCode
Address
City
Region
Country
AddressPostal
Latitude
Longitude

JSON file format¶

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

[
    {
        "Name": "Abbott Group",
        "Active": true,
        "Notes": "Reverse-engineered tertiary analyzer",
        "Wiki": null,
        "Tags": [
            "green",
            "shipper",
            "zone7"
        ],
        "Contact": "Madisyn Swift",
        "ContactNotes": "Dylan Little",
        "AlertNotes": null,
        "WebAddress": "http://example.name",
        "AccountNumber": "80939916",
        "Phone1": "1-954-587-1815 x68654",
        "Phone2": "1-987-686-7749 x88377",
        "Phone3": "(404) 852-9105 x0113",
        "Phone4": null,
        "Phone5": null,
        "EmailAddress": "Verna.Toy@example.net",
        "PostAddress": null,
        "PostCity": null,
        "PostRegion": null,
        "PostCountry": null,
        "PostCode": null,
        "Address": "62774 Stracke Canyon",
        "City": "Predovicfurt",
        "Region": "Wyoming",
        "Country": "American Samoa",
        "Latitude": 45.031800,
        "Longitude": 162.748800
    },
    {
        "Name": "Balistreri, Terry and Wintheiser",
        "Active": true,
        "Notes": "Reverse-engineered upward-trending help-desk",
        "Wiki": null,
        "Tags": [
            "contractor",
            "indigo",
            "xanthic",
            "zone5"
        ],
        "Contact": "Eugenia Nicolas",
        "ContactNotes": "Claudie Schowalter",
        "AlertNotes": null,
        "WebAddress": "https://example.net",
        "AccountNumber": "92034811",
        "Phone1": "1-448-854-6536 x01928",
        "Phone2": "837.349.5867",
        "Phone3": "208.603.8905 x11661",
        "Phone4": null,
        "Phone5": null,
        "EmailAddress": "Kitty40@example.com",
        "PostAddress": null,
        "PostCity": null,
        "PostRegion": null,
        "PostCountry": null,
        "PostCode": null,
        "Address": "9562 Leuschke Curve",
        "City": "Lake Elyse",
        "Region": "Wisconsin",
        "Country": "Honduras",
        "Latitude": -37.742000,
        "Longitude": 30.400100
    },
    {
        "Name": "Bernhard Group",
        "Active": true,
        "Notes": "Sharable executive local area network",
        "Wiki": null,
        "Tags": [
            "factory",
            "gold"
        ],
        "Contact": "Evalyn Cremin",
        "ContactNotes": "Reid Krajcik",
        "AlertNotes": null,
        "WebAddress": "http://example.com",
        "AccountNumber": "71971967",
        "Phone1": "260.368.5741",
        "Phone2": "1-508-923-4635",
        "Phone3": "(756) 896-6012 x731",
        "Phone4": null,
        "Phone5": null,
        "EmailAddress": "Rowena_Wilderman69@example.org",
        "PostAddress": null,
        "PostCity": null,
        "PostRegion": null,
        "PostCountry": null,
        "PostCode": null,
        "Address": "05524 Johns Courts",
        "City": "Cruickshankbury",
        "Region": "Maine",
        "Country": "Cocos (Keeling) Islands",
        "Latitude": -28.537600,
        "Longitude": -170.722300
    }
]

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,Contact,ContactNotes,AlertNotes,WebAddress,AccountNumber,Phone1,Phone2,Phone3,Phone4,Phone5,EmailAddress,PostAddress,PostCity,PostRegion,PostCountry,PostCode,Address,City,Region,Country,Latitude,Longitude
Abbott Group,true,Reverse-engineered tertiary analyzer,,"green,shipper,zone7",Madisyn Swift,Dylan Little,,http://example.name,80939916,1-954-587-1815 x68654,1-987-686-7749 x88377,(404) 852-9105 x0113,,,Verna.Toy@example.net,,,,,,62774 Stracke Canyon,Predovicfurt,Wyoming,American Samoa,45.0318,162.7488
"Balistreri, Terry and Wintheiser",true,Reverse-engineered upward-trending help-desk,,"contractor,indigo,xanthic,zone5",Eugenia Nicolas,Claudie Schowalter,,https://example.net,92034811,1-448-854-6536 x01928,837.349.5867,208.603.8905 x11661,,,Kitty40@example.com,,,,,,9562 Leuschke Curve,Lake Elyse,Wisconsin,Honduras,-37.742,30.4001
Bernhard Group,true,Sharable executive local area network,,"factory,gold",Evalyn Cremin,Reid Krajcik,,http://example.com,71971967,260.368.5741,1-508-923-4635,(756) 896-6012 x731,,,Rowena_Wilderman69@example.org,,,,,,05524 Johns Courts,Cruickshankbury,Maine,Cocos (Keeling) Islands,-28.5376,-170.7223