Skip to content

# Part assembly 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
- Items
- Quantity

## Linked object fields

The following linked objects are importable / updateable:

- Part via "PartNameViz" field which must contain the name of an existing Part

## JSON file format

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

    [
        {
            "Name": "Primary 7242",
            "Active": true,
            "Notes": "Corrupti et animi non soluta.",
            "Wiki": null,
            "Tags": [
                "orange",
                "silver",
                "zone3",
                "zone5"
            ],
            "Items": [
                {
                    "PartNameViz": "097091",
                    "Quantity": 1.00000
                },
                {
                    "PartNameViz": "874579",
                    "Quantity": 3.00000
                },
                {
                    "PartNameViz": "375486",
                    "Quantity": 1.00000
                },
                {
                    "PartNameViz": "983612",
                    "Quantity": 15.00000
                },
                {
                    "PartNameViz": "198660",
                    "Quantity": 1.00000
                }
            ]
        },
        {
            "Name": "Lower Arm 5369",
            "Active": true,
            "Notes": "Voluptatum et molestiae magnam at iste similique iusto modi ea.",
            "Wiki": null,
            "Tags": [
                "orange",
                "zebra",
                "zone1"
            ],
            "Items": [
                {
                    "PartNameViz": "734629",
                    "Quantity": 1.00000
                },
                {
                    "PartNameViz": "048902",
                    "Quantity": 1.00000
                }
            ]
        },
        {
            "Name": "Board 9995",
            "Active": true,
            "Notes": "Iure eius ut id consequatur omnis aut ut.",
            "Wiki": null,
            "Tags": [
                "gold",
                "mauve",
                "violet",
                "zone8"
            ],
            "Items": [
                {
                    "PartNameViz": "335219",
                    "Quantity": 1.00000
                },
                {
                    "PartNameViz": "048902",
                    "Quantity": 1.00000
                },
                {
                    "PartNameViz": "417318",
                    "Quantity": 1.00000
                }
            ]
        }
    ]

## CSV file format

The first row of the .csv file must contain column headers that match the field names listed above.

CSV doesn't cleanly map on to structured elements with sub collections well so the Items column here which contains the part and quantity items for this assembly has a special format we've adopted:

The Items column must be:

- surrounded in double "quotes"
- contain the parts and their quantities in pairs separated by commas
- each pair must be split by the pipe character |
- each pair must contain the part name of an existing part in AyaNova as the first part of the pair
- each pair must contain the quantity of that part as the second part of the pair

    Name,Active,Notes,Wiki,Tags,Items
    Primary 7242,true,Corrupti et animi non soluta.,,"orange,silver,zone3,zone5","097091|1.00000,874579|3.00000,375486|1.00000,983612|15.00000"
    Lower Arm 5369,true,Voluptatum et molestiae magnam at iste similique iusto modi ea.,,"orange,zebra,zone1","734629|1.00000,048902|1.00000"
    Board 9995,true,Iure eius ut id consequatur omnis aut ut.,,"gold,mauve,violet,zone8","335219|1.00000,048902|1.00000,417318|1.00000"