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