forked from WFPVAM/GRASPReporting
-
Notifications
You must be signed in to change notification settings - Fork 0
/
GRASPReporting-OfficialChangelog.txt
123 lines (81 loc) · 4.57 KB
/
GRASPReporting-OfficialChangelog.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
Version 1.1.3
________________
under development
New features
* Review Restore: it’s possible to restore an entire review cycle based on review data filter, by reviewer or by response status.
* Review Process: 2 steps review workflow
* Response View: it’s possible to filter by sender number
Improvements
* Reports: it’s possible to filter the any reports by response status
* Reports: speed optimization up to 7x in generating the reports
* Reports: both value and percentage are shown on the pie charts
* Reports: calculated fields can be used to generate charts
* Response View: Response Status is shown in the responses table.
* Calculated Fields: when a field associated to a survey is selected, a dropdown with values is shown.
Fixes
* Data Edit: bug on empty values for numerical fields
* Data Edit: bug on repeatable fields visualization.
* Form View: is not shown anymore field name for empty values
* Form View: bug on repeatable fields visualization.
* Duplicated Search: fixed bug on duplicated record view page
Database Changes:
In order to properly upgrade GRASP Reporting, the following database schema changes must be done:
1. Add table RolesToResponseStatus
2. Add record to Roles
3. Add record FormResponseStatus
4. Add fields to ReportFields
5.
6. Add view FormFieldResponseReviews
7. Add view ResponseRepeatableReviews
The following web.config key must be created under appSettings section:
<add key="FileResponseFolder" value=" physicalPathToYourWebApplication \responsefiles” />
-> replace physicalPathToYourWebApplication with the local physical path of your web application.
Create in the root of your web application the folder “responsefiles” with the following subfolders: “incoming”, “error” and “processed”.
________________
Version 1.1.2
________________
Released on 30 October 2014
Author: Marco Giorgi ([email protected])
New features
* Server-side calculated fields: now it’s possible to add calculated fields to the forms specifying a mathematical formula using the existing form fields.
* Indexes: indexes are used to search and discover duplicated records based on a combination of one or more fields that are expected to be unique.
* User Permission: the web application has now a complete redesigned security check to deny access to resources based on user roles. Users can now be associated to view or edit only form responses that contains a specific value in a specific field.
* Custom Filter: it’s possible to define custom advanced filter on view and export data function.
* Data Edit: it’s possible to edit form responses using the same interface of web data entry.
* Data Review Workflow: responses can be reviewed and any status change is recorded in the response history.
Improvements
All the heavy tasks have been refactored to support multiprocessor/multicore support to improve calculation speed and more use of RAM memory to reduce access to database.
This changes guarantee an optimal load scalability.
Fixes
Response value field has been expanded from 255 to 4000 chars in order to avoid exceptions in data entry.
If the input is longer than 4000 chars, it will be truncated.
Database Schema Changes:
In order to properly upgrade GRASP Reporting the following database schema changes must be done:
1. Added table FormFieldExt
2. Added table FormFieldExtDependencies
3. Added table FormResponseReviews
4. Added table FormResponseStatus
5. Added table Indexes
6. Added table IndexFields
7. Added table IndexHASHes
8. Added table ResponseValueExt
9. Added table ResponseValueReviews
10. Added table UserFilters
11. Added table UserToFormResponses
12. Added table UserToResponseStatus
13. Added field to User_Credential [UserResponseFilter] [nvarchar](max)
14. Changed type ResponseValue.value to nvarchar(4000)
15. Added field to ResponseValue [nvalue] [float] NULL
16. Added field to ResponseValue [dvalue] [datetime] NULL
17. Added field to FormResponse [ResponseStatusID] [int] NOT NULL
18. Modified View FormFieldExport
19. Modified View FormFieldResponses
20. Modified View ResponseDetails
21. Modified View ResponseRepeatable
22. Modified View SurveyListAPI
23. Add records to table Roles
24. Add records to table FormResponseStatus
These scripts are for GRASP Database never updated from the release of May 2014.
If some of the tables or fields listed above have been already added to the Database you will receive an error or warning when the script is launched. In this case you must proceed with a manual update.
The above scripts will not erase any data in your database.
SQL scripts can be found in the folder SQLDbScripts