···
On 1 February 2016 at 12:52, Nhan Cao nhancv@yeskone.com wrote:
Dear A Chuong,
If you through my source, I have provide auto basic authorization and can be resued this for auto call api or support ui for input anytime by edit ui yourself (like this: http://yeskone.com/Phplibrary/view/mbasic_au.html), it just example about connector, so I make it as fast as possible to show for every one see about how connector working and easy imagine. I had said : “Depend on design so connector is friendly or not.” in previous email.
With https://tableau.github.io/webdataconnector/Examples/jsonConnector.html only works if paste direct Json response from api calling. If you paste api url, it doesn’t work. It work with algorithm:
(In source, line 143)
// Given an object:
// - finds the longest array in the object
// - flattens each element in that array so it is a single object with many properties
// If there is no array that is a descendent of the original object, this wraps
// the input in a single element array.
I can be work with almost all json response with that algorithm, but just for demo connector, it doesn’t match with concrete requirement.
<Screen Shot 2016-02-01 at 6.07.28 PM.png>
<Screen Shot 2016-02-01 at 6.07.51 PM.png>
Yours sincerely,
Nhan Cao
nhancv@yeskone.com
On Feb 1, 2016, at 5:53 PM, Thái Chương thaichuong159@gmail.com wrote:
Hello Nhan,
I read through your connector source.
Since you hard code for basic authentication, If you can modify to provide fields for url, username and password like the following sample connector, it will become a proper connector.
https://tableau.github.io/webdataconnector/Examples/jsonConnector.html
I tried returned DHIS2 json data with this connector. It works.
R
On Mon, Feb 1, 2016 at 12:45 AM, Nhan Cao nhancv@yeskone.com wrote:
Dear all,
I have just follow this topic and have some opinion. I also see the Rodolfo’s video, at 40s you paste direct api from dhis2, I think it’s wrong event if data response match with tableau format. We need an connector (like adapter) like diagram below.
Dhis2 had provided web api to access resource. So, we just make connector sets, which is bridge of two platform (dhis2 and tableau). Depend on design so connector is friendly or not.
About tableau format: http://onlinehelp.tableau.com/current/api/wdc/en-us/WDC/wdc_ref.htm
I have made an example connector (it get an api from dhis2 and convert to tableau format)
- Usage: Run tableau program → More server… → Web data connector → Paste url above and Enter → Press “Get example” button
My english is not very good, sorry if I make someone misunderstand.
Yours sincerely,
Nhan Cao
nhancv@yeskone.com
On Jan 30, 2016, at 4:07 PM, Rodolfo Melia rmelia@knowming.com wrote:
We are probably going to develop one connector to test this. I will write back.
On Saturday, 30 January 2016, Morten Olav Hansen mortenoh@gmail.com wrote:
–
Rodolfo Meliá
*Principal | *rmelia@knowming.com
Skype: rod.melia | +44 777 576 4090 | +1 708 872 7636
www.knowming.com
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
–
THAI Chuong
YM/Skype : thaichuong159
Phone: (+84) 918776134
The ideal situation will be that any report_table in DHIS is ready to be consumed by tableau. Currently, tableau sees the data returned by the DHIS report_tables (see 40s video), but cannot complete the connection.
Yeah, as far as I know… this is something being worked on, but Lars will have to give the details… I don’t think you will see tableau compatible data coming out of DHIS 2, but rather a specialised connector from their side.
The link that you sent, if I understand correctly, will allow to develop individual connections for specific report tables. So if an organization wants to connect 10 tables representing 10 data collections, we need to create 10 connectors - am I correct?
Well, yes… it would require a XHR request for every data source you want to pull in, but that’s the case anyways… even with a specialised connector. The only way to remedy something like that would be to bundle multiple resource tables together.
–
Morten
Ideally we want that the api can return data formatted is such a way that Tableau can consume it - imagine something like this:
R
On 28 January 2016 at 05:14, Morten Olav Hansen mortenoh@gmail.com wrote:
HI Rodolfo
Did you have a look at the example JSON connector?
https://github.com/tableau/webdataconnector/blob/gh-pages/Examples/jsonConnector.html
It seems pretty simple to connect to any kind of JSON source… as long as you understand the data you are pulling in (analytics, etc) it should be a simple task to then map it to headers, columns etc…
–
Morten
On Wed, Jan 27, 2016 at 11:24 PM, Rodolfo Melia rmelia@knowming.com wrote:
Somehow, some organizations have used and want to continue using Tableau. I understand 2.23 will offer a new vizualization engine. That will be interesting, i will help taking them in that direccion.
On Wednesday, 27 January 2016, Morten Olav Hansen mortenoh@gmail.com wrote:
It would also be interesting to know why they want to connect to Tableau, I thought our philosophy would point us to a more open source direction? Tableau is a hyper commercial company? no?
While just a prototype, we in HISP Vietnam are also creating dashboards:
http://dhis2.io (esc, or click hamburger to see menu)
Tableau wanting to connect to us, should be seen both as a success… and something to be wary about (if you care about code, and you have seen the output from a Tableau dashboard, you know how shitty it is)
–
Rodolfo Meliá
*Principal | *rmelia@knowming.com
Skype: rod.melia | +44 777 576 4090 | +1 708 872 7636
www.knowming.com
–
Morten
On Wed, Jan 27, 2016 at 10:21 PM, Knut Staring knutst@gmail.com wrote:
Copying this to Sundeep also, since HISP India is also interested in this linkage, as are the WHO SEARO, WPRO and PAHO regional offices.
On Wed, Jan 27, 2016 at 4:17 PM, Morten Olav Hansen mortenoh@gmail.com wrote:
Ok, Lars will know more about that… I know they have reached out to us… Not sure if they will do the work or us, but I don’t think the amount of work would be much… at least our analytical json should be easy to read, I have already make connectors for the dashboards I have been creating for Lao and Indoensia
–
Knut Staring
Dept. of Informatics, University of Oslo
Norway: +4791880522
Skype: knutstar
http://dhis2.org
–
Morten
On Wed, Jan 27, 2016 at 10:14 PM, Rodolfo Melia rmelia@knowming.com wrote:
only for the connector…
On 27 January 2016 at 15:10, Morten Olav Hansen mortenoh@gmail.com wrote:
Sure, are they planning to release an open source version then?
–
Morten
On Wed, Jan 27, 2016 at 10:05 PM, Juan Manuel Alcantara Acosta jmalcantara1@gmail.com wrote:
Nicola recently told me someone form Tableau will be attending the symposium. That could be a good opportunity to talk to them.
JM
El 27/01/2016, a las 9:02 a.m., Rodolfo Melia rmelia@knowming.com escribió:
Hi Knut - that’s interesting. Look forward to hear more about that conversation with the Tableau foundation.
I think that somehow we need DHIS to expose the data in a XML/Json following Tableau conventions.
Rodolfo Meliá
*Principal | *rmelia@knowming.com
Skype: rod.melia | +44 777 576 4090 | +1 708 872 7636
www.knowming.com
On 27 January 2016 at 14:18, Knut Staring knutst@gmail.com wrote:
Hi Rodolfo,
There was an email recently about direct contact with the Tableau Foundation, who seem interested in working with us directly.
I think Lars will probably follow up on this when he is back from leave.
Knut
On Wed, Jan 27, 2016 at 2:45 PM, Morten Olav Hansen mortenoh@gmail.com wrote:
Hi Rodolfo
I don’t know anything about Tableau, but maybe you would have better luck importing CSV data? its a bit more manageable than JSON (which can have any format)
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
Knut Staring
Dept. of Informatics, University of Oslo
Norway: +4791880522
Skype: knutstar
http://dhis2.org
–
–
Morten
On Wed, Jan 27, 2016 at 6:31 PM, Rodolfo Melia rmelia@knowming.com wrote:
Hi everyone - the latest version of Tableau (9.1) has a new ‘web connector’ that allows to read html/ json sources. As you can see from the image below, I have successfully got to the point of DHIS returning data to Tableau, but I cannot get to the final step to start doing the charts in tableau.
Have anyone successfully connected DHIS to tableau using the new web connector in 9.X?
I have the impression that there is the need to modify the json that DHIS returns, based on Tableau specs. Have anyone tried to do that?
R
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp