|
|
|
Field: RPQ_Start_Date
|
|
Type
|
Datetime
|
|
General Description
|
The start date of a questionnaire answer sheet (resource project questionnaire) is normally the starting date and time that a user started filling in a questionnaire.
|
|
Import Group
|
Import Data (by selecting a questionnaire)
|
|
Business Rules
|
- Questionnaire start date must follow the format of general date time; namely: “yyyy-mm-dd hh:mm:ss”
- Importing questionnaire start date is compulsory if you want to import any data to a the questionnaire answer sheet. I.e. whenever there is any mapping to a question in a questionnaire (when you try to import data to questionnaire), the system will check if questionnaire start date is also mapped.
- Questionnaire start date must not be greater than current date
- Questionnaire start date must not be empty if you specify questionnaire end date in the mapping. Questionnaire start date must also be less than questionnaire end date in this case.
- Questionnaire start date must not be empty if you specify ‘Completed = true’ for questionnaire completed. See more in the ‘Questionnaire completed’ help file.
- To update this field for existing users, you must select a User_Id column in step 1 of the import wizard and also map to the specific questionnaire answer sheet that you want to update.
- If you choose option 1 in step 2 of the import wizard, any existing questionnaire start dates will be overwritten with the new start date
- If you choose option 2 in step 2 of the import wizard, all existing questionnaire will be deleted so the start date will always be that of a new answer sheet
- If you choose option 3 in step 2 of the import wizard, the exact answer sheet to which you mapped will get overwritten with the specified start date Validation
|
|
Validation
|
- Error message is shown if you try to import wrong format of date time. Error type: ERROR (the import job will not be allowed to be executed).
- Validation error: ‘Start date must not be empty in case you want to import Data’ will be shown if you try to import Data without specifying the Questionnaire start date. Error type: ERROR and you can not finish the Import job with Import Data.
- Validation error: ‘Questionnaire Start Date must not be greater than current date’ will be shown if you try to import start date that is bigger than current date. Error type: ERROR (the import job will not be allowed to be executed).
- Validation error: ‘Questionnaire Start Date must not be empty in case you specify Questionnaire end date’ will be shown if you try to import end date without start date. Error type: ERROR (the import job will not be allowed to be executed).
- Validation error: ‘Questionnaire Start Date must not be greater than Questionnaire End Date’ will be shown if you try to import to start date a value that is bigger than end date. Error type: ERROR (the import job will not be allowed to be executed).
- Validation error: ‘Questionnaire start date must not be empty in case you specify a questionnaire answer as completed’ will be shown if you try to import completed value to Questionnaire without start date mentioned. Error type: ERROR (the import job will not be allowed to be executed).
|
|
Notes
|
- Please investigate the file on import wizard to learn more on importing questionnaires data.
|
