Skip to main content

Auxiliary Data Files Export Format

  • Updated

Project coordinators can upload auxiliary data files to collect participant data from sources outside of MyDataHelps surveys. These files are included in the data export.

Individual auxiliary data files are included in the export, with the participant identifier prepended to the file name. For example:

/AuxiliaryData/11111/uploadtest.xlsx
/AuxiliaryData/11111/uploadtest.csv
/AuxiliaryData/22222/uploadtest.csv

There is also a summary file containing metadata about all of the included auxiliary data files.

AuxiliaryData_[startdate]-[enddate].csv

Table of Contents

Data Fields

Field Description
AuxiliaryDataKey A unique, auto-generated key for the auxiliary data file.
ParticipantIdentifier The identifier of the associated participant. Can be used to cross reference with Participants.
ParticipantID The stable, automatically generated, internal system identifier for this participant. Universally unique identifier (UUID).
FileName The auxiliary data file name.
UploadDate The timestamp for when the file was uploaded to MyDataHelps Designer, in ISO 8601 format. It is always in UTC.
UploadedBy The name of the person who uploaded the file.
ObservationDate The timestamp for the observation date entered in MyDataHelps Designer, in ISO 8601 format.

Sample CSV Export

AuxiliaryDataKey,ParticipantIdentifier,FileName,UploadDate,UploadedBy,ObservationDate
8163cb07-0220-e911-bf75-b0104117332b,11111,uploadtest.xlsx,2019-01-24T18:01:11Z,"Administrator, Careevolution",2018-11-01T00:00:00-04:00
0fe95efb-0120-e911-bf75-b0104117332b,11111,uploadtest.csv,2019-01-24T18:00:57Z,"Administrator, Careevolution",2019-01-01T00:00:00-05:00
c4020bc5-ed1f-e911-bf75-b0104117332b,22222,uploadtest.csv,2019-01-24T15:36:09Z,"Administrator, Careevolution",2019-01-24T10:35:56-05:00

Sample JSON Export

{
	"AuxiliaryDataKey" : "8163cb07-0220-e911-bf75-b0104117332b",
	"ParticipantIdentifier" : "11111",
	"FileName" : "uploadtest.xlsx",
	"UploadDate" : "2019-01-24T18:01:11Z",
	"UploadedBy" : "Administrator, Careevolution",
	"ObservationDate" : "2018-11-01T00:00:00-04:00"
}{
	"AuxiliaryDataKey" : "0fe95efb-0120-e911-bf75-b0104117332b",
	"ParticipantIdentifier" : "11111",
	"FileName" : "uploadtest.csv",
	"UploadDate" : "2019-01-24T18:00:57Z",
	"UploadedBy" : "Administrator, Careevolution",
	"ObservationDate" : "2019-01-01T00:00:00-05:00"
}{
	"AuxiliaryDataKey" : "c4020bc5-ed1f-e911-bf75-b0104117332b",
	"ParticipantIdentifier" : "22222",
	"FileName" : "uploadtest.csv",
	"UploadDate" : "2019-01-24T15:36:09Z",
	"UploadedBy" : "Administrator, Careevolution",
	"ObservationDate" : "2019-01-24T10:35:56-05:00"
}

Was this article helpful?