InterviewerSyncUploadPackage table
The InterviewerSyncUploadPackage table records when the remote device uploads package data to the server.
Fields
Id
Data type: int
The unique identifier, assigned by the SQL Server, for this table (used for the project upload).
SessionId
Data type: int
Foreign key to the IntervewerSyncSessions table.
PackageId
Data type: nvarchar(200)
Name of the package (GUID generated by the client).
Type
Data type: nvarchar(200)
ProjectData, LogData, or RespondentFiles.
Project
Data type: nvarchar(200)
The project to which the package will be uploaded.
InterviewerId
Data type: nvarchar(200)
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.
RequestTime
Data type: datetime
The time that the server received the Put() call, where the client notifies the server of the files it will upload (in UTC).
UploadStartTime
Data type: datetime
The time that the OpenUploadPackage method is called (in UTC).
UploadEndTime
Data type: datetime
The time when the end of the upload stream is reached during the OpenUploadPackage call (in UTC).
FileCount
Data type: int
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)
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