Skip to content

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