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