Yes, I agree with Markus,
Excel is good tool to do deep formula to calculate in data elements. And
offline too.
Markus Bekken markus.bek...@gmail.com wrote:
Thanks Bob,
1. I have not established a preference here - your point on using CSV is a
good one. CSV will probably be easier to
Thanks Bob,
1. I have not established a preference here - your point on using CSV is a good
one. CSV will probably be easier to deserialize in most cases. JSON or XML on
the other hand, will probably be a little more robust to changes in the WebAPI
output.
2. I like it. Excel is a good tool
Agree very much with Bob's point 2 - most of the existing legacy data in
the world is either on paper or in Excel. And if it is in some other
format, people will typically use Excel to rearrange it into DHIS2 format
(CSV or JSON or XML)
On Tue, Jun 23, 2015 at 1:40 PM, Bob Jolliffe
Hi all DHIS2 developer,
Do you know can i use Microsoft Excel to get json data from DHIS2 web API?
thank you
channara
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe :
Hi Markus
Thanks for this information. That's a really useful snippet for
anyone to get started who might want to do this. I have a quick
question and a comment/suggestion:
1. I can see from the link that you can indeed parse/serialize json
from VBA - I guess it would have been surprising if
You can't use excel to get json data from dhis2 web api. At least not directly.
You could possibly write an excel macro to get the data through the
web api (I am really not sure - it is far too many years since i wrote
an excel macro), but you are still left with the problem of consuming
what
Hi Channara and Bob
I have been using macros to POST and PUT data to the API, and GET requests
should work just as well.
I added your question and put my macro code here:
https://webapps.stackexchange.com/questions/79521/can-i-use-excel-to-get-json-from-the-dhis-api/79522#79522
7 matches
Mail list logo