Skip to content

# Unit model 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
- UPC
- LifeTimeWarranty
- IntroducedDate
- Discontinued
- DiscontinuedDate
- WarrantyLength
- WarrantyTerms"

## Linked object fields

The following linked objects are supported for import / update:

- Unit model Vendor via "VendorViz" field which must contain the name of an existing Vendor

## JSON file format

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

    [
        {
            "Name": "Silverado Kids - 394697",
            "Active": true,
            "Notes": "Quia neque dolorem quis cum sit dolores omnis dolores ex.",
            "Wiki": null,
            "Tags": [
                "quince",
                "silver",
                "violet",
                "yellow",
                "zone9"
            ],
            "VendorViz": "Ruecker - Jakubowski",
            "UPC": "2626181040130",
            "LifeTimeWarranty": false,
            "IntroducedDate": "2017-10-26T17:06:35.479433Z",
            "Discontinued": false,
            "DiscontinuedDate": null,
            "WarrantyLength": 36,
            "WarrantyTerms": "Service only"
        },
        {
            "Name": "Sentra Electronics - 598797",
            "Active": true,
            "Notes": "Incidunt officiis minus vero distinctio quasi.",
            "Wiki": null,
            "Tags": [
                "brown",
                "mauve",
                "white",
                "zone2",
                "zone7"
            ],
            "VendorViz": "Senger, Schinner and Zieme",
            "UPC": "3036454614095",
            "LifeTimeWarranty": false,
            "IntroducedDate": "2018-12-28T21:40:59.003417Z",
            "Discontinued": false,
            "DiscontinuedDate": null,
            "WarrantyLength": 24,
            "WarrantyTerms": "Service only"
        },
        {
            "Name": "Ranchero Garden - 625229",
            "Active": true,
            "Notes": "Ipsum ea nam exercitationem ea perspiciatis.",
            "Wiki": null,
            "Tags": [
                "brown",
                "gold",
                "mauve",
                "purple",
                "zone8"
            ],
            "VendorViz": "Pfeffer - Dicki",
            "UPC": "0805820409756",
            "LifeTimeWarranty": false,
            "IntroducedDate": "2018-06-01T17:29:48.427245Z",
            "Discontinued": false,
            "DiscontinuedDate": null,
            "WarrantyLength": 1,
            "WarrantyTerms": "Parts only"
        }
    ]

## 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,VendorViz,UPC,LifeTimeWarranty,IntroducedDate,Discontinued,DiscontinuedDate,WarrantyLength,WarrantyTerms
    Silverado Kids - 394697,true,Quia neque dolorem quis cum sit dolores omnis dolores ex.,,"quince,silver,violet,yellow,zone9",Ruecker - Jakubowski,2626181040130,false,2017-10-26T17:06:35.479433Z,false,,36,Service only
    Sentra Electronics - 598797,true,Incidunt officiis minus vero distinctio quasi.,,"brown,mauve,white,zone2,zone7","Senger, Schinner and Zieme",3036454614095,false,2018-12-28T21:40:59.003417Z,false,,24,Service only
    Ranchero Garden - 625229,true,Ipsum ea nam exercitationem ea perspiciatis.,,"brown,gold,mauve,purple,zone8",Pfeffer - Dicki,0805820409756,false,2018-06-01T17:29:48.427245Z,false,,1,Parts only