Skip to content
Contact us
  • There are no suggestions because the search field is empty.

[Legacy] Auxiliary Data Files Export Format

Uploading Auxiliary Data Files is a legacy feature. See Uploaded Files Export Format for currently recommended methods of uploading and exporting participant files.

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

 

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"
}