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