[Legacy] Auxiliary Data Files Export Format

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

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