InterviewerSyncUploadPackage table
The InterviewerSyncUploadPackage table records when the remote device uploads package data to the server.
Fields
Id
The unique identifier, assigned by the SQL Server, for this table (used for the project upload).
Data type: int
SessionId
Foreign key to the IntervewerSyncSessions table.
Data type: int
PackageId
Name of the package (GUID generated by the client).
Data type: nvarchar(200)
Type
ProjectData, LogData, or RespondentFiles.
Data type: nvarchar(200)
Project
The project to which the package will be uploaded.
Data type: nvarchar(200)
InterviewerId
The interviewer ID that uploads the package data. This will be NULL in the case of an auto-synchronization that uploads data for all interviewers on the device.
Data type: nvarchar(200)
RequestTime
The time that the server received the Put() call, where the client notifies the server of the files it will upload (in UTC).
Data type: datetime
UploadStartTime
The time that the OpenUploadPackage method is called (in UTC).
Data type: datetime
UploadEndTime
The time when the end of the upload stream is reached during the OpenUploadPackage call (in UTC).
Data type: datetime
FileCount
Data is uploaded as three separate packages:
Project data - the number of cache + sample + quota files (ProjectData)
Log data - log files (LogData)
Respondent files - such as images and recordings (RespondentFiles)
Data type: int
Notes
Multiple database entries are written with the value of the FileCount that is dependent on the Type field, which indicates the type of data that is being uploaded.
The Id, SessionId, PackageId, Type, Project, InterviewerId, RequestTime, and FileCount fields are populated when the Put() request occurs. The Project field is NULL when Type="LogData".
The UploadStartTime and UploadEndTime fields are populated at the end of the OpenUploadPackage call. Both of these fields are left as NULL when OpenUploadPackage is not called. This information is recorded in order to calculate the length of time that a particular device takes to upload project data, log data, or respondent files (respectively).
Similar to the InterviewerSyncDownloadProject table, this table is indexed on the SessionId and Project fields.
See also