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/