1 Date : 8th October, 2009
2 Created by : Harshad Modi(hmo) and Yogesh(ysa)
3 --------------------------------------------------------------------------------------
5 **** Specification of Survay module in OpenERP ****
9 ======================================================================================
10 > Design own survey form
11 > Desing own Questionaries
15 Design own survey form:
16 ---------------------------------------------------------------
17 Allow to make multiple own survey pages with multiple questions with different question type.
19 Note : After finish first Phase of Development, Allow to design page template to specify customize theme for bgcolor, bgimage, font style, font color
23 -------------------------------------------------------
24 Questinaries should has :
25 * can specify question text
26 * can make Answer sheet
28 * Survey Admin can able to design answer option like:
29 - Mutiple Choice with one answer
30 - Mutilpe Choice with multiple answer
34 ---------------------------------------------------------
35 Survey Admin can able to :
37 - Send a survey invitation to others peple by mail
38 - Allow to set max limit of Response
39 - Survey Admin can able to close survey
42 ----------------------------------------------------------
43 - Show Result with all Survey pages with total responses, responce count and calculate avarage response.
52 OpenERP model Design :
53 ====================================================================
55 -------------------------------------------
57 pages_ids - one2many(survey_page)
62 status (draft, open, close, cancel)
63 resposible - many2one (res.user)
66 -------------------------------------------------------------------
68 page_template_id - many2one( survey_page_template)
69 survey_id - many2one(survey)
70 question_ids - one2many(survey_question)
75 --------------------------------------------------------------
76 page_id - many2one(survey_page)
78 answer_choice_ids - one2many(survey_answer)
79 response_ids - one2many(survey_response)
85 --------------------------------------------------------------------------
86 question_id - many2one(survey_question)
91 --------------------------------------------------------------------
95 response_by - many2one(res.users)
96 question_id - many2one(survey_question)
97 response_type ( from manual, link, mail)
98 response_answer_ids - one2many(survey_response_answer)
100 survey_response_answer:
101 --------------------------------------------------------------------
102 response_id - many2one(survey_response)
103 question_id - many2one(survey_answer)
108 ==================================================
116 see survey_page.png file
118 Survey Question View:
120 see survey_qyestion.png file
122 Survey Response View :
124 see survey_response.png file
128 OpenERP Report Design :
129 ===================================================
131 Design postgres view to display statistical information of response per question, response per user, etc..
132 More detail will be provided later.
135 OpenERP Menu Design :
136 =====================================================
146 > All Survey Responses
147 > New Survey Response
149 > Response per Survey
150 > Response per Survey Page
151 > Response per Question
155 ===============================================
156 http://www.surveymonkey.com/