Some users are listed twice in the "Shared" dropdown.
The duplicate user's name is followed by a hexidecimal number.

Issue by mahmoodkhan
Wednesday Apr 15, 2015 at 18:45 GMT
Originally opened as https://github.com/mercycorps/tola/issues/6

A user should be able to choose a subset of column from a particular Silo to be exported. This functionality should be implemented in a way that is reusable for the various export end points.

[email protected] http://tola.work/helpdesk/view/?ticket=tt-314&[email protected] The "source" link on the home pages is broken. Please remove the link

The Source form should show field only applicable for that source.
Change Edit Data menu item to "Your Tables"
Remove the List of Sources View

Issue by glind
Tuesday Sep 29, 2015 at 21:37 GMT
Originally opened as https://github.com/mercycorps/tola/issues/56

Users have a hard time finding there data sources and silos we need to refine this so there is one way to get to all.

[email protected] http://tola.work/helpdesk/view/?ticket=tt-248&[email protected] If a user shares a table from the "Table Name" link/silo_edit page nothing seems to happen and doesn't actually give permission to the table.

Currently the test scripts are not passing. We probably need to come up with a procedure to update these scripts as part of our development process.

error when importing the attached CSV data set, but table still imports

[email protected] http://tola.work/helpdesk/view/?ticket=tt-244&[email protected] User's should be able to sort their tables on the "Your Data Tables" page.

Sort by:
Table Name
Description
Table Source

And/OR add and make sortable:
Table Date/Created/Updated

This should also help in fetching data from that source automatically in that it would only append new data and not all data.

Rename Browser Tab label from TolaData to TolaTables

When a user maps fields for "table 1" and "table 2" in the merge process, the system should store the mapping and then be able to reuse it when a user tries to update data in the merged table.

Issue by glind
Tuesday Oct 13, 2015 at 13:03 GMT
Originally opened as https://github.com/mercycorps/tola/issues/64

[email protected] We need the ability to replace values in a column of data. Example: Column "City Name" has the value "Prtlnd" in it and we need to replace all the instances of "Prtlnd" with "Portland". So Find and replace like functionality.

I've been getting confused when I have multiple tables open at the same time which one I'm looking at as I click between. Can you add a name title for each table on the "View Table Data" page?

Issue by glind
Friday Sep 04, 2015 at 19:04 GMT
Originally opened as https://github.com/mercycorps/tola/issues/49

Each silo should have a link to a dashboard that would then generate a map with any location based data (contains lat long columns) and a simple table view with pagination. Maybe se the highcharts api for table and map (or leaflet for map).

[email protected] http://tola.work/helpdesk/view/?ticket=tt-306&[email protected] using tables.toladata.io

If you can set an auto-pull in TolaTables from GoogleSheets it would add a lot of flexibility. Auto-pulling from Ona is a highly useful feature for new and running quantitative surveys sending data from ODK. But survey data could be synthesized with secondary, historic, or quantified qualitative data in GoogleSheets, and data from old projects or any other static datasets living in Excel files on program staff computers (the majority of datasets) could by put into GoogleSheets. If TolaTables were able to auto-pull from these GoogleSheets, then a much wider range of field team members would be able to organize, clean, and process their data for utility in Tola.

Send Project Agreements to Tola Activity through the API

Update the green edit button to describe that the user can VIEW and/or Edit their data table.
https://tola-tables-demo.mercycorps.org/silos

[email protected] http://tola.work/helpdesk/view/?ticket=ta-239&[email protected] Currently on the Program Dashboard you can only see the status of all Project Agreements. You can't see which PAs have a Project Completion form. It would be helpful if there was some kind of visual to show both the status of the PA and the status of the PC from the program dashboard. This would help indicate with PAs also have a PC started and the status.

Feedback from cohort 2 they would like to see if AUTO pull is turned on or off in Table source on "Your Tables" page.

"Share" as "Excel" should exports as EXCEL and change existing to "Share" as "CSV" as exporting to CSV

Auto Fetch should work when a user selects multiple columns as "Unique Together"

[email protected] http://tola.work/helpdesk/view/?ticket=ta-175&[email protected] At the bottom of the PAF there is the option to upload documentation/ project files. It would be helpful if one could also choose from documentation that has already been uploaded, so there's not a duplication of documents in Tola Workflow.

[email protected] http://configure-django-sites.com/helpdesk/view/?ticket=ta-175&[email protected] At the bottom of the PAF there is the option to upload documentation/ project files. It would be helpful if one could also choose from documentation that has already been uploaded, so there's not a duplication of documents in Tola Workflow.

If a user merges two tables and creates a bad map, they receive a 500 error on submit, but the system still creates the table. The error should be more detailed for the user.

Then if the user then tries to load that table on their "My Tables" page they receive a
"There is not data in Table with id = ##"

Bad merge attempts, or empty tables, should not create links on the users "My Tables" page

Issue by glind
Tuesday Oct 13, 2015 at 13:09 GMT
Originally opened as https://github.com/mercycorps/tola/issues/65

[email protected] Users should be able to select what columns they want to import from a CSV or Data feed before creating the new table. We need a screen that show s a list of columns and pre-checked checkboxes that allows the user to uncheck boxes for columns they don't want to import.

Issue by glind
Tuesday Sep 29, 2015 at 22:14 GMT
Originally opened as https://github.com/mercycorps/tola/issues/59

Currently a silo without data allows you to click the edit button then shows you a message that the silo does not have data (doesn't work on Safari though). It would be better if the edit button was disabled and a message displayed letting the user know they should add or import data.

Similar to how Tola-Activity does this in the dashboard workflow:
https://www.dropbox.com/s/dg3lmz8mpbznqlk/Screenshot%202015-09-29%2015.13.48.png?dl=0

The "Source" link on the home pages is broken .

Page not found (404)
Request Method: GET
Request URL: https://tola-tables.mercycorps.org/read/home/

None

Merging data sets with Arabic data set does not merge correctly

Closed

Add a prompt to name the merge table, when the user uses the merge function.

Issue by dborchers
Monday Jan 11, 2016 at 16:50 GMT
Originally opened as https://github.com/mercycorps/tola/pull/75

Tola Tables

Share, Load, Edit and Display data from various mobile data collection platforms.

The Read app is intended for use with FormHub or Ona data collection platform. You should be able
to add an additional app using Read as a template to import data or create new "reads"
from other data sources. You only need to import the new app, add the new read templates
and update the base template to include your new app as sub-navigation to the main read.

Feed: A new JSON or XML feed of one or more aggregated data sources

Read: A data source to load data into the system from

Silo: A data store that can combine one or more Feeds (Data sources)

Display: Where data is viewed and edited

Install virtualenv

$ pip install virtualenv

Create Virtualenv

$ virtualenv ENV

• Where ENV is a directory to place the new virtual environment. You can name it as wanted. It contains the Python executable files, and a copy of the pip library

Activate Virtualenv

$ source bin/activate

Fix probable mysql path issue (for mac)

$ export PATH=$PATH:/usr/local/mysql/bin

• or whatever path you have to your installed mysql_config file in the bin folder of mysql

$ pip install -r requirements.txt

Set up DB

$ python manage.py syncdb

Run App

If your using more then one settings file change manage.py to point to local or dev file first

$ python manage.py runserver 0.0.0.0:8000

GOOGLE API
$ sudo pip install --upgrade google-api-python-client

• 0’s let it run on any local address i.e. localhost,127.0.0.1 etc.

dborchers included the following code: https://github.com/mercycorps/tola/pull/75/commits

[email protected] http://example.com/helpdesk/view/?ticket=priority-1&[email protected] fads asdf 23234r 234 asdf 1234

If a user edits a column name, saves it and then edits it again and clicks saves, there is an error if the page or table is not reloaded first.

Request Method: POST
Request URL: https://tola-tables-demo.mercycorps.org/edit_columns/4/
Django Version: 1.8.2
Exception Type: WriteError
Exception Value:
An empty update path is not valid.
Exception Location: /usr/local/lib/python2.7/site-packages/pymongo/helpers.py in _check_write_command_response, line 261

When I click on the delete table button (under my "Your Tables" link) , nothing happens, but I can enter the delete silo url directly in my browser to delete the table example url:
https://tola-tables-demo.mercycorps.org/silo_delete/30

When a user opts to turn on Auto-Pull for Table, they should be alerted that they need to set a Unique column or the auto-pull will not work

French and Arabic characters in CSV files cause an error on import. See CSV files attached in Tola.Work.

Merging tables creates a table with a typo in the title: "mergeing of # and #"

The typo should be fixed or the users should be given the ability to name the merged table, before it is created.

[email protected] http://tola.work/helpdesk/view/?ticket=tt-237&[email protected] If you view the "Data Source" PAGE for a TT that already has a current CSV file attached to it and click SAVE the "Get External Data ...or Create New Table" page loads, instead of the "Your Data Tables"

Issue by mahmoodkhan
Friday Nov 06, 2015 at 00:51 GMT
Originally opened as https://github.com/mercycorps/tola/issues/71

Issue by glind
Friday Jul 17, 2015 at 19:08 GMT
Originally opened as https://github.com/mercycorps/tola/issues/34

Jupyterhub provides a multiuser service for hosting iPython notebooks that also work with R and other languages. This might be the easiest way to integrate Tola silos with iPython.

https://github.com/jupyter/jupyterhub

Feedback from cohort 2 was "What is a unique column?"
They suggested adding text explaining what it is/does

This should include vitrualenv set up to isolate libraries

Issue by glind
Friday Sep 04, 2015 at 19:05 GMT
Originally opened as https://github.com/mercycorps/tola/issues/50

Allow the user to select columns from there silo to use in a set of charts to then be displayed on the silo dashboard.

This problem is visible on all of our drop down items in responsive tables since the upgrade to bootstrap 3.3 with the new design and can fixed by not using responsive. Other fixes are detailed below and bootstrap response.

http://stackoverflow.com/questions/26018756/bootstrap-button-drop-down-inside-responsive-table-not-visible-because-of-scroll

twbs/bootstrap#7160

twbs/bootstrap#11037

It looks like there are several hack solutions for css we can do, might be nice to come up with one solution for all. Either way it doesn't look like the bootstrap team wants to tackle this issue any time soon.

[email protected] http://configure-django-sites.com/helpdesk/view/?ticket=ta-175&[email protected] At the bottom of the PAF there is the option to upload documentation/ project files. It would be helpful if one could also choose from documentation that has already been uploaded, so there's not a duplication of documents in Tola Workflow.

Issue by glind
Tuesday Nov 03, 2015 at 08:59 GMT
Originally opened as https://github.com/mercycorps/tola/issues/68

[email protected] We were able to import two tables from Ona that have repeats (repeats creates two sheets in the workbook) and merge the two tables. We could view, edit the first sheet. When tried to "SHARE" and create new Google Sheet, it created the google sheet but with no data. Wondering if this has something to do with the repeats why it didn't export?

Issue by glind
Thursday Nov 19, 2015 at 00:15 GMT
Originally opened as https://github.com/mercycorps/tola/issues/74

[email protected] The Help Links on Tola Data/Tables should link to Tola.Work
https://tola-data.mercycorps.org/faq --> http://tola.work/faq

https://tola-data.mercycorps.org/contact --> http://tola.work/contact

https://tola-data.mercycorps.org/documentation --> http://tola.work/documentation