Hi all DHIS2,
Do you know how to convert Excel tracker list to xml and to json that enable import into DHIS2 system?
thank you
CHANNARA
Hi all DHIS2,
Do you know how to convert Excel tracker list to xml and to json that enable import into DHIS2 system?
thank you
CHANNARA
Dear Channara,
The simplest way is to map this excel to a temp table in postgres, then use postgres json functionality to format the data from the temp table to a json format directly.
You may need a function to update each event with a uid for tracking so that you don’t send duplicates.
Alex
On Tue, Sep 1, 2015 at 1:02 PM, channara rin rin.channara@gmail.com wrote:
Hi all DHIS2,
Do you know how to convert Excel tracker list to xml and to json that enable import into DHIS2 system?
thank you
CHANNARA
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
–
Alex Tumwesigye
Technical Advisor - DHIS2 (Consultant),
Ministry of Health/AFENET
Kampala
Uganda
IT Consultant - BarefootPower Uganda Ltd, SmartSolar, Kenya
IT Specialist (Servers, Networks and Security, Health Information Systems - DHIS2 ) & Solar Consultant
+256 774149 775, + 256 759 800161
"I don’t want to be anything other than what I have been - one tree hill "
Dear Channara,
Please avoid posting ANY information about individual people on this list.
Knut
On Tue, Sep 1, 2015 at 12:02 PM, channara rin rin.channara@gmail.com wrote:
Hi all DHIS2,
Do you know how to convert Excel tracker list to xml and to json that enable import into DHIS2 system?
thank you
CHANNARA
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
Hi Channara,
Good to know this is fake data.
Anyway, did you have a look here at the docs?
I think you would need quite a few scripts for this. You would need to properly encode and escape the Khmer text to UTF-8, format the DOB properly (it does not look standard), and then map each of the fields to an attribute to enroll the tracked entity into a program (to create a tracked entity instance). Likely, the other fields such as the community and village, would need to be part of an option set, so you would need to be sure that the option exists and that the code is transmitted as part of the payload.
Another approach might be direct injection into the database, but you would still need to properly map all of the fields, and I suspect that it would be easier to use the API for this.
I do not think there is any one tool which would do this, but likely would would need to code something yourself using some scripting language (VBA, Python and R come to mind).
Regards,
Jason
On Tue, Sep 1, 2015 at 12:02 PM, channara rin rin.channara@gmail.com wrote:
Hi all DHIS2,
Do you know how to convert Excel tracker list to xml and to json that enable import into DHIS2 system?
thank you
CHANNARA
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
–
Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049