Skip to content

Pyar Openlex GSoC 2021 Final Summary Rodriguez Juan

Rodriguez Juan edited this page Aug 23, 2021 · 2 revisions

GSoC 2021 Final Summary

Proposed goals

  • Email integration and billing to the system. Issue #12
  • Develop a trial version in the browser as a tutorial. Issue #17
  • Import and export massive data to make it compatible with other systems such as lexdoctor. Issue #10
  • Prepare it for the management of work groups, assignment of roles, responsibilities, tasks, administration. Issue #11

Achieved goals

Week 1 and 2 Issue #10

  • Relate between tables movimiento and agenda, update dashboard/view. PR #30
  • Problem loading tables using csv (Investigation). Issue #10
  • Export data from Movimiento table. PR #36
  • Download zip separated folders. PR #41
  • Have a login feature to make easy the tests. commit on PR #41
  • Role admin upload. PR #40
  • Fix issue 47 in calendar view PR #48
  • Fix 44 agenda expediente PR #57

Week 5 and 6 Issue #12

  • Added reminder by integrating email PR #59
  • Error al colocar servidor de mail inválido al Recuperar Contraseña (Ready to be fixed) Issue #46

Week 7 and 8 Issue #17

  • Trial version on internet PR #61

Week 9 Issue #11

Week 10 Tests

  • Tests add login fixture and asserts PR #66
  • Tests othertables PR #67
  • Optimization code PR #65

Brief description of the results

  • Email integration and billing to the system.

To start an email integration to the project, the option of a reminder for the agendas was added, which optionally will be activated to receive email alerts according to the selected options. This functionality was added in the section cron/check_email.py to be activated with the Web2py cron.

Suggestion for future improvements

  • Development of a template for the alert message.
  • Develop a trial version in the browser as a tutorial.

For the online test version, it has been enabled in the project in openlex.pythonanywhere, for this, changes were made in the creation of the test databases, a test user was created facilitating its access in the description of the main page and they were loaded data predefined to the same.

Suggestion for future improvements

  • Add a captcha at the beginning for your login so that in this way avoid bot attacks to the website

  • Import and export massive data to make it compatible with other systems such as lexdoctor.

Studying the system to make it compatible, it has been found that the private app is a closed system which does not have an open source API to make it compatible with other systems, for this reason we have focused on making sure that the application itself can export and import the tables in the different formats, to achieve this has been worked on:

  1. Verify the correct operation of the integrated export and import functions.
  2. Develop a function to download the files and writings of the motion table in a massive and organized way in a zip file format.
  • Prepare it for the management of work groups, assignment of roles, responsibilities, tasks, administration.

It was possible to enable a section where the administrator could manage the groups and users could see the files that are shared between users of the same group, to achieve this objective a series of steps have been carried out that are worth listing them: The administrator section was enabled.

  1. Thinking of those users who are not from the IT area, the administrator permission is now assigned by default to the first user of the localhost system.
  2. The administrator can manage, create and delete the groups allowing with these group work.
  3. Users can view the files of members of the same group.
  4. The administrator can load data in tables () whose load function is only enabled with this role.

Suggestion for future improvements

  • Complete an option to view the changes in the files of a group, title of the file, date of modification, user who modifies it and group to which it belongs. Incomplete development

Summary Work Done

Git log table:

Commit Date Summary Stats
75fca2b 2021-08-16 Tests othertables 4 files changed, 77 insertions(+)
0a0d060 2021-08-16 Fix test, forget change and controller 3 files changed, 12 insertions(+), 2 deletions(-)
595d168 2021-08-14 Suggested changes 1 file changed, 1 insertion(+), 1 deletion(-)
31859b7 2021-08-14 Add comment 1 file changed, 1 insertion(+), 1 deletion(-)
d1e1a53 2021-08-14 Add config and optimice code 2 files changed, 7 insertions(+), 4 deletions(-)
8b698f0 2021-08-14 fix test 1 file changed, 1 insertion(+), 1 deletion(-)
d0b41f0 2021-08-09 tests add login fixture and asserts 9 files changed, 35 insertions(+), 384 deletions(-)
2469569 2021-08-09 replace datetime with request.now 1 file changed, 3 insertions(+), 5 deletions(-)
567f40b 2021-08-09 Optimization code delete link agenda 2 files changed, 2 insertions(+), 8 deletions(-)
aa187ef 2021-08-09 suggested changes 4 files changed, 28 insertions(+), 18 deletions(-)
9586f8f 2021-08-08 clean comments 1 file changed, 12 deletions(-)
ae6e32d 2021-08-08 control of changes in the expedients 2 files changed, 54 insertions(+), 1 deletion(-)
0b5c4f4 2021-08-04 fix issue in test agenda with date 2 files changed, 1 insertion(+), 28 deletions(-)
b05cbe2 2021-08-04 tests update 1 file changed, 2 insertions(+), 3 deletions(-)
8204319 2021-08-04 group manager 4 files changed, 65 insertions(+)
545c441 2021-08-04 Auto Assign role admin 1 file changed, 9 insertions(+), 1 deletion(-)
f1059be 2021-07-29 Test version 3 files changed, 14 insertions(+), 4 deletions(-)
0ed8d1c 2021-07-25 Suggested changes and rename files by issue 44 3 files changed, 30 insertions(+), 3 deletions(-)
b532c13 2021-07-21 test for the agenda view attribute 1 file changed, 26 insertions(+)
ab4bd55 2021-07-21 Added reminder by integrating email 3 files changed, 47 insertions(+), 1 deletion(-)
0579c24 2021-07-17 tests 1 file changed, 27 insertions(+)
df7c7bc 2021-07-16 Add message error in Agenda.expediente_id field 2 files changed, 10 insertions(+), 1 deletion(-)
6f8b026 2021-07-16 Add tests 1 file changed, 39 insertions(+)
71281fa 2021-07-16 Merge branch 'master' into fix-47-calendar
ee69565 2021-07-12 Merge branch 'fix-10-separatedfolders' of https://github.com/Juerodriguez/OpenLex into fix-10-separatedfolders
61b2b50 2021-07-12 Add last suggest in comments 1 file changed, 12 insertions(+), 10 deletions(-)
70785fb 2021-07-12 Add suggest flake8 1 file changed, 4 insertions(+), 4 deletions(-)
48da55d 2021-07-12 Add fixture login in tests 4 files changed, 29 insertions(+), 42 deletions(-)
f3f913f 2021-07-11 add suggestion 1 file changed, 26 insertions(+), 31 deletions(-)
153c741 2021-07-11 fix temporal pdf 1 file changed, 9 insertions(+), 3 deletions(-)
9ccef39 2021-07-10 import pytest 1 file changed, 3 insertions(+)
2c14d47 2021-07-10 test_skip_download 1 file changed, 3 insertions(+), 2 deletions(-)
8715a98 2021-07-10 tests 2 files changed, 26 insertions(+), 17 deletions(-)
d9e6a3d 2021-07-09 Fix issue 47 in calendar view 1 file changed, 1 insertion(+)
4086d4f 2021-07-08 Requeriments 2 files changed, 3 insertions(+), 4 deletions(-)
e77a663 2021-07-07 add movement writings 1 file changed, 32 insertions(+), 9 deletions(-)
f8f4c49 2021-07-02 Urgent task relate with expediente in dashboard view 1 file changed, 5 insertions(+), 2 deletions(-)
a656ed8 2021-07-02 Hidden link agenda 1 file changed, 7 insertions(+)
6252047 2021-07-01 Download zip separated folders 1 file changed, 44 insertions(+), 4 deletions(-)
aad2f09 2021-06-30 Import csv to role admin tables 5 files changed, 34 insertions(+), 4 deletions(-)
aa8a4a2 2021-06-30 Role admin uplaod 5 files changed, 29 insertions(+), 1 deletion(-)
ee92f59 2021-06-25 Suggested changes and commit 1 file changed, 15 insertions(+), 15 deletions(-)
e5c2d85 2021-06-25 git pull upstream master git push origin masterMerge branch 'master' of https://github.com/Juerodriguez/OpenLex into fix-10-exportfiles
060e3b0 2021-06-24 Test upload data, Download zip and change format video to mp4 2 files changed, 37 insertions(+), 11 deletions(-)
db001f4 2021-06-23 Revision con flask8 1 file changed, 10 insertions(+), 13 deletions(-)
de9c85a 2021-06-18 Merge branch 'fix-10-exportfiles' of https://github.com/Juerodriguez/OpenLex
511c980 2021-06-18 avances 1 file changed, 8 insertions(+), 8 deletions(-)
4291f0e 2021-06-16 Export data from movimiento table relate to a field id from the expediente table 1 file changed, 28 insertions(+)
e9834f8 2021-06-14 Relate between tables movimiento and agenda, update dashboard/view 2 files changed, 4 insertions(+), 1 deletion(-)
4e1f706 2021-04-12 Modulo para filtrado de csv en tablas con una variable 4 files changed, 733 insertions(+)