Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Implement an action to export all data #89

Open
joausaga opened this issue Dec 10, 2020 · 5 comments
Open

Implement an action to export all data #89

joausaga opened this issue Dec 10, 2020 · 5 comments
Assignees
@orpuig
Labels
enhancement New feature or request medium-priority
Projects
Experiment Platform

Comments

@joausaga
Copy link
Contributor

An action should be implemented in the view of users to export all data of the experiment
@joausaga joausaga added enhancement New feature or request medium-priority labels Dec 10, 2020
@joausaga joausaga added this to ToDo in Experiment Platform Dec 10, 2020
@orpuig orpuig moved this from ToDo to In Progress in Experiment Platform Dec 11, 2020
orpuig added a commit that referenced this issue Dec 11, 2020
@orpuig
Add export action for all user/answers. Solves #89
984ab1d
@orpuig orpuig moved this from In Progress to In Testing in Experiment Platform Dec 11, 2020
@joausaga
Copy link
Contributor Author

Rename columns to the text of question/option instead of the current codes

@joausaga joausaga moved this from In Testing to In Progress in Experiment Platform Dec 11, 2020
@joausaga
Copy link
Contributor Author

Tried to use the action in the server and because of the amount of data that need to be processed, it gets stuck. Queries should be optimized at maximum to speed-up the process of exporting all of the data

@orpuig
Copy link
Contributor

orpuig commented Dec 14, 2020

Source for optimization ideas: https://blog.luap.info/tips-to-optimize-django-sql-queries.html

orpuig added a commit that referenced this issue Dec 14, 2020
@orpuig
Db usage optimization. Partly solves #89
a0c6a9c
@orpuig orpuig moved this from In Progress to In Testing in Experiment Platform Dec 14, 2020
@orpuig
Copy link
Contributor

orpuig commented Dec 14, 2020

Might be useful for further optimization: https://docs.python.org/3/library/collections.html#collections.defaultdict

@joausaga joausaga moved this from In Testing to In Progress in Experiment Platform Dec 15, 2020
@joausaga
Copy link
Contributor Author

To close this issue columns should be renamed having a more informative name. The name of question/option can be used or even better a shorter name derived from the question/option.

orpuig added a commit that referenced this issue Dec 16, 2020
@orpuig
Change column name in export file. Solves #89
26f999b
@orpuig orpuig moved this from In Progress to In Testing in Experiment Platform Dec 16, 2020
orpuig added a commit that referenced this issue Dec 17, 2020
@orpuig
Add missed change in previous commit. #Solves #89
b61fd0b
orpuig added a commit that referenced this issue Dec 17, 2020
@orpuig
Add control in case question desc es not in db. #Related #89
0c4ee63
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@orpuig orpuig

Labels
enhancement New feature or request medium-priority
Projects
Experiment Platform
In Testing
Milestone
No milestone
Development

No branches or pull requests
2 participants
@joausaga @orpuig