Skip to content

Task group 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
  • Items

JSON file format

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

[
    {
        "Name": "Aerostat monitor standard refurb",
        "Active": true,
        "Notes": "Alias maxime deserunt corrupti voluptatem a voluptatem eligendi.",
        "Items": [
            {
                "Sequence": 1,
                "Task": "Power down unit"
            },
            {
                "Sequence": 2,
                "Task": "Open seals"
            },
            {
                "Sequence": 3,
                "Task": "Replace central core"
            },
            {
                "Sequence": 4,
                "Task": "Test point B and verify +.25"
            },
            {
                "Sequence": 5,
                "Task": "Replace seals"
            },
            {
                "Sequence": 6,
                "Task": "Confirm power up"
            }
        ]
    },
    {
        "Name": "Clean and inspect Class 7C",
        "Active": true,
        "Notes": "Facilis omnis dolor tempora dolores suscipit maxime ut et eum aperiam dolor.",
        "Items": [
            {
                "Sequence": 1,
                "Task": "Open unit"
            },
            {
                "Sequence": 2,
                "Task": "Test tinclavic seals"
            },
            {
                "Task": "Inspect triple-bonded polysium for cracks"
            },
            {
                "Sequence": 4,
                "Task": "Verify thickness of zybanium shield"
            },
            {
                "Sequence": 5,
                "Task": "Close unit"
            },
            {
                "Sequence": 6,
                "Task": "Clean unit and confirm power up"
            }
        ]
    }
]

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 Tasks for this Task group has a special format we've adopted:

The Items column must be:

  • surrounded in double "quotes"
  • contain the Tasks separated by commas
  • each Task text must not have a comma or a quotation mark in it or the csv will not be valid
  • Sequence numbers are not importable from csv but will be automatically assigned in the order presented so the first item will be sequence 1, second sequence 2 etc
Name,Active,Notes,Items
Aerostat monitor standard refurb,true,Alias maxime deserunt corrupti voluptatem a voluptatem eligendi.,"Power down unit, Open seals, Replace central core, Test point B and verify +.25"
Clean and inspect Class 7C,true,Facilis omnis dolor tempora dolores suscipit maxime ut et eum aperiam dolor.,"Open unit, Test tinclavic seals, Inspect triple-bonded polysium for cracks, Verify thickness of zybanium shield,Close unit, Clean unit and confirm power up"