Cg huyphong at 08:34, 14 December 2011

2011-12-14T08:34:57Z

← Older revision		Revision as of 08:34, 14 December 2011
Line 1:		Line 1:
	[[Category:Import module]]		[[Category:Import module]]
			{{Help_Files_Import_module}}

	==Field: RPQ_Start_Date==		==Field: RPQ_Start_Date==

Cg huyphong at 03:56, 26 April 2011

2011-04-26T03:56:02Z

← Older revision		Revision as of 03:56, 26 April 2011
Line 1:		Line 1:
	[[Category:~~HelpBooks~~]]		[[Category:Import module]]

Catglobe: jrfconvert import

2011-03-07T08:51:20Z

jrfconvert import

New page

[[Category:HelpBooks]]

==Field: RPQ_Start_Date==

{| class="tableintopic" style="border-collapse: collapse" width="1189" cellpadding="2"
| width="168" |
| width="1020" |
|- align="left" valign="top"
| style="border: 1px solid #010101" colspan="2" width="1189" |
==Field: RPQ_Start_Date==
|- align="left" valign="top"
| style="border: 1px solid #010101" width="168" |
Type
| style="border: 1px solid #010101" width="1021" |
Datetime
|- align="left" valign="top"
| style="border: 1px solid #010101" width="168" |
General Description
| style="border: 1px solid #010101" width="1021" |
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.
|- align="left" valign="top"
| style="border: 1px solid #010101" width="168" |
Import Group
| style="border: 1px solid #010101" width="1021" |
Import Data (by selecting a questionnaire)
|- align="left" valign="top"
| style="border: 1px solid #010101" width="168" |
Business Rules
| style="border: 1px solid #010101" width="1021" |
* 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
|- align="left" valign="top"
| style="border: 1px solid #010101" width="168" |
Validation
| style="border: 1px solid #010101" width="1021" |
* 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).
|- align="left" valign="top"
| style="border: 1px solid #010101" width="168" |
Notes
| style="border: 1px solid #010101" width="1021" |
* Please investigate the file on import wizard to learn more on importing questionnaires data.
__NOTOC__

Field: RPQ Start Date - Revision history

Cg huyphong at 08:34, 14 December 2011

Cg huyphong at 03:56, 26 April 2011

Catglobe: jrfconvert import