Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • Instructions are given in the top left. Do not change any of the headings, instructions, or form IDs, or add or remove any rows at the top of the file.

  • You must start your data entry on the colored row, which is row 13.

  • The fields in the dark orange must be completed.

  • The fields in yellow are optional.

  • The boxes in white should be skipped. These will be filled in by Gruntify automatically

  • Capture Date must be a valid date in the format: yyyy-mm-ddThh:mm:sszzz. Make sure your date string does not have any spaces and that the timezone starts with a “+” or “-”
    Examples:
    “2019-01-09T15:01:00+00:00” is 9 January 2019, 3:01 pm GMT
    “2021-12-19T012:00:00-04:00” is 19 December, 12 noon pm in New York

  • Status values are: Submitted, Accepted, Rejected.

  • Drop-down values must appear exactly as they are in the form definition.

  • Toggle or on/off values should have the uppercase “TRUE” to indicate on. Use “FALSE” for off.Signature files and media files are not supported directly using the Request Bulk Import. Speak to your Gruntify contact for help if this is required as it requires customized support

  • Media files can be added through media URLs separated by semi-colons (;).

Info

The Excel file should have at most 100,000 records. Larger record (row) sizes may lead to adverse performance outcomes.

...