Skip to content

# Project 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
- DateStarted
- DateCompleted
- AccountNumber

## Linked object fields

The following linked objects are supported for import / update:

- Project overseer User via "ProjectOverseerViz" field which must contain the name of an existing User

## JSON file format

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

    [
        {
            "Name": "Gold Run",
            "Active": true,
            "Notes": "Tempora quisquam ea aut mollitia.",
            "Wiki": null,
            "Tags": [
                "mauve",
                "zone6"
            ],
            "DateStarted": "2022-07-06T10:06:57.201288Z",
            "DateCompleted": "2022-08-25T10:06:57.201288Z",
            "ProjectOverseerViz": "Montana Carter",
            "AccountNumber": "76034866"
        },
        {
            "Name": "White Lake",
            "Active": true,
            "Notes": "Rerum eveniet unde reiciendis necessitatibus dolor in odit excepturi quia autem beatae.",
            "Wiki": null,
            "Tags": [
                "zone6"
            ],
            "DateStarted": "2023-03-20T21:53:44.38693Z",
            "DateCompleted": "2023-03-25T21:53:44.38693Z",
            "ProjectOverseerViz": "Aliya Yost",
            "AccountNumber": "78874840"
        },
        {
            "Name": "Plum Extensions",
            "Active": true,
            "Notes": "Earum odit earum ut voluptas neque culpa similique aut unde dolore provident.",
            "Wiki": null,
            "Tags": [
                "blue",
                "quince",
                "zone5"
            ],
            "DateStarted": "2022-05-21T15:11:46.31198Z",
            "DateCompleted": "2022-06-19T15:11:46.31198Z",
            "ProjectOverseerViz": "Zelma Schamberger",
            "AccountNumber": "17408291"
        }
    ]

## 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,DateStarted,DateCompleted,ProjectOverseerViz,AccountNumber
    Gold Run,true,Tempora quisquam ea aut mollitia.,,"mauve,zone6",2022-07-06T10:06:57.201288Z,2022-08-25T10:06:57.201288Z,Montana Carter,76034866
    White Lake,true,Rerum eveniet unde reiciendis necessitatibus dolor in odit excepturi quia autem beatae.,,zone6,2023-03-20T21:53:44.38693Z,2023-03-25T21:53:44.38693Z,Aliya Yost,78874840
    Plum Extensions,true,Earum odit earum ut voluptas neque culpa similique aut unde dolore provident.,,"blue,quince,zone5",2022-05-21T15:11:46.31198Z,2022-06-19T15:11:46.31198Z,Zelma Schamberger,17408291