Difference between revisions of "Field: RPQ End Date"

From Catglobe Wiki
Jump to: navigation, search
(jrfconvert import)
 
 
(One intermediate revision by the same user not shown)
Line 1: Line 1:
[[Category:HelpBooks]]
+
[[Category:Import module]]

+
{{Help_Files_Import_module}}
  
 
==Field: RPQ_End_Date==
 
==Field: RPQ_End_Date==

Latest revision as of 09:34, 14 December 2011



Field: RPQ_End_Date

Field: RPQ_End_Date

Type

Datetime

General Description

The end date of a questionnaire answer sheet (resource project questionnaire) is normally the date and time that a user finished filling in a questionnaire.

Import Group

Import Data (by selecting a questionnaire)

Business Rules

  • Questionnaire end date must follow the format of general date time; namely: “yyyy-mm-dd hh:mm:ss”
  • Importing questionnaire start date is compulsory if you specify ‘completed = true’ in questionnaire completed ‘column’.
  • Questionnaire end date must not be greater than current date
  • 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

  • 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: ‘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 end 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 end date mentioned. Error type: ERROR (the import job will not be allowed to be executed).

Notes

  • See questionnaire start date for more information.
  • Please investigate the file on import wizard to learn more on importing questionnaires data.