Errors in user-supplied files for preloading

March 9, 2018

Survey Solutions allows preloading assignments with data, including answers to questions inside rosters and nested rosters.

It is the user’s responsibility to supply valid input files for this process. The user-supplied files will be validated to match the questionnaire template that is being preloaded. Survey Solutions can detect a number of inconsistencies and common problems and will indicate them during preloading. 

Each detected error is having a code listed in the table below. Additional checks may be added in the future. 

When an error is detected in the preloading file, Survey Solutions may reject such input data fully or partially. If Survey Solutions rejects the preloading file completely, and you can’t localize the problem (in which interview it occurs) it is a good idea to try to break down the preloading file into smaller portions to identify, in which specific interview the problem is present.

Many of the messages below are accompanied by various identifying information, such as a line number in the file, values of identifying questions, variable names, roster indices or other supplementary information that helps localizing the problem.

It is a good practice to establish a reproducible process of creating assignments (preloading data files) by writing scripts/programs that can be adjusted and re-run to obtain the desired preloading file. Survey Solutions users commonly use various statistical packages, such as Stata, SPSS, R as well as queries to databases to extract the necessary information in exactly the format expected at input by Survey Solutions. This practice allows adjustments be done to those scripts whenever the format of input data for Survey Solutions changes, or if the sample file needs to be replicated for troubleshooting purposes.
 

Code Message Description/Comment
PL0001
Questionnaire is missing in HQ
Rare. Questionnaire that you are trying to preload has been deleted by the server administrator.

Contact the server administrator.
PL0002
N/A
If you see this error contact the support team.
PL0003
Column cannot be mapped to any question in the questionnaire.
In the file being uploaded a column name (variable) is specified, which is not present in the questionnaire.

Check column names for typos, check variables are in appropriate levels (files).
PL0004
File cannot be mapped to any roster in the questionnaire.
The archive being uploaded contains a file that Survey Solutions doesn't know what to do with it.

Check how the files are named against the template downloadable from Survey Solutions HQ.
PL0005
N/A
If you see this error contact the support team.
PL0006
Duplicate Id values found.
Check the ids for duplicates and renumber or correct the typos.
PL0007
One or more parent Id column is missing.
For every element of roster files id columns linking it to higher levels must be present and non-missing.

Check the id columns in the roster files and fill them out with appropriate ids. For example, for every person in the household roster there must be a household id specified where this person resides.
PL0008
Roster record does not have a parent.
A record in the roster file refers to non-existent record in the parent file (orphan record).

Check for relationships between the files. For every detailed record the parent record must exist.
PL0009
Roster Id is inconsistent with roster size.
Either the number of elements in the roster or their numeration is inconsistent with the trigger question.

See recommendations here.
PL0010
Linked questions cannot be preloaded.
Remove the values from the columns corresponding to linked questions.
PL0011
General error occurred.
Inspect the records you are preloading against the questionnaire designed. Survey Solutions reported that it can't preload the records with the values it received from the user, but no additional information is available.
PL0012
Question found in the uploaded file(s) that does not exist in the questionnaire
Check column names against the template that can be downloaded from the Survey Solutions HQ for this questionnaire.
PL0013
Provided value is null or empty
Value that was expected to be not empty is found to be empty in the preloading file.

Replace the blank values with appropriate non-missing values.
PL0014
Provided question value not allowed.
Replace the erroneous value with a permitted one. For example, in categorical questions, make sure the category exists among the categories specified for this question in the questionnaire.
PL0015
Type of question is not correct.
Check that the value being uploaded corresponds to the question type. Such as string vs numeric content.
PL0016
Invalid Date or Time value entered in the date question.
Check the format of the date/time values you are preloading.
PL0017
Invalid GPS value.
Check the GPS coordinates for validity. Express coordinates in degrees and decimals, such as 51.50, not in degrees and minutes, seconds, not 51°30'00".
PL0018
Only integer values are allowed.
You are trying to put a non-integer value to a question or variable that only accepts integer answers.

Replace with integer values.
PL0019
Only real values are allowed.
Non-numeric value found for categorical question.
PL0022
Roster size question cannot have negative values.
Replace with non-negative values.
PL0023
Picture question cannot be preloaded.
Remove the values from the columns corresponding to picture questions.
PL0024
Preloading data were not found
 
PL0025
Responsible field was not provided for 1 or more observations
If the _responsible column is present in the preloading data, it must be all populated without any blanks.

Check _responsible column for blanks (missings) and fill out with appropriate account names.
PL0026
Responsible does not exist for 1 or more observations
Name specified as responsible person (recepient of the assignment) does not exist.

Check _responsible column for typos. Make sure all of the accounts mentioned are already created in the HQ and have either a supervisor or interviewer role.
PL0027
Responsible is a locked user for 1 or more observations
Assignments can't be made to the users locked out from the system.

Check that the responsible users are not locked. Either unlock the user or assign to a different user.
PL0028
User is not Supervisor or Interviewer for 1 or more observations
Preloading file contains a login name of a person who is neither a supervisor nor an interviewer, and hence may not receive an assignment.

Check the names and roles of the account names mentioned in the _responsible column. Revise so that everyone is either a supervisor or an interviewer.
PL0029
Answer to roster size question cannot be greater than NN.
You are trying to preload a very large value not supported by Survey Solutions.

Reduce the value.
PL0030
GPS questions require separate columns for Latitude and Longitude
In early versions of Survey Solutions GPS question data was exported into a single string column with internal formatting. This is no longer the case in new versions, and each component occupies it's own column.

Separate latitude from longitude.
PL0030
GPS question requires Latitude and Longitude to be set.
Make sure both latitude and longitude are specified for GPS questions.
PL0031
Two or more columns have the same name.
There should be no two columns with identical names in any file, downloaded from or uploaded to Survey Solutions.

Check column names for typos. For columns that correspond to lists, make sure the indices are present in column titles, for example, member__0, member__1, etc.
PL0032
Latitude must be greater than -90° and less than 90°.
Check that the values of latitude in the preloading file are all within the -90, 90 range. 

If your coordinates come from some other projection you may need to convert (reproject) to degrees.
PL0033
Longitude must be greater than -180° and less than 180°.
Check that the values of longitude in the preloading file are all within the -180, 180 range. 

If your coordinates come from some other projection you may need to convert (reproject) to degrees.
PL0034
Invalid decimal separator. The "," symbol is not allowed in numeric answers. Please use "." instead.
Always use a dot in fractional numeric values, even if a comma (or another character) is used in your country or in your current OS settings as a decimal delimiter.

Reformat the values in the preloading file to use a dot as a decimal delimiter.
PL0035
Only integer values are allowed.
Preloading file contains a fractional (non-integer) value, where only integers were expected based on the questionnaire template.

Replace fractional with integer values.
PL0036
Quantity should be greater than or equal to -1.
In assignments, the requested quantity must be an integer value, and may be 0 or a positive value, or a -1 for infinite number of interviews. Other negative values are not permitted.

Revise the requested quantities of interviews in the assignments.
PL0037
Column cannot be mapped to non identifying question
Check the variable names in the first row of each file against the template that can be downloaded from Survey Solutions HQ.
PL0038
Area question cannot be preloaded.
Remove the values from the columns corresponding to area questions.
PL0039
Audio question cannot be preloaded.
Remove the values from the columns corresponding to audio questions.
PL0040
File with questionnaire level data is missing.
Survey Solutions can't find in the zip-archive being uploaded the file named the same as the questionnaire.

Check the names of the files in the zip archive being uploaded. One file must have the same name as the questionnaire. Note that Survey Solutions refines the name of the questionnaire removing any special characters, punctuation, non-latin and accented characters from the filename (and does not expect any of them in the files being preloaded). To see what name the questionnaire should have, download the template file offered at the sample preloading step.
PL0041
Answer to multiple choice question cannot contain more than NN answers.
Preloading file contains more answers than permitted by the maximum answers NN set in the questionnaire template.

Reduce the number of answers in the preloading file or revise the questionnaire template in the Designer.
PL0042
Id column doesn't have any value.
Provide a valid value for all ids.
PL0047 Required column variable__name is missing The file protected__variables.tab does not contain the required column variable__name.

Make sure that this file is a text file and contains a single column with the name variable__name. Mind the double underscores in the name of this column.
PL0048 Protected variable is not found in provided questionnaire The file protected__variables.tab specified a variable name that doesn't exist in the questionnaire template.

Check the names of the variables versus the names in the questionnaire Designer. For text list and multi-select categorical questions only the root name must be specified, e.g. hhmembers, not hhmembers__2.
PL0049 Variable has type that does not support protection The file protected__variables.tab mentions a variable name corresponding to a question not supported by protection. Error message mentions the first of such invalid variables.

Check the file for typos in variable names.

Check the types of the variable mentioned in the error message. It must be one of the permitted for protection.