Convert Excel to xml and to json

Hi all DHIS2,
Do you know how to convert Excel tracker list to xml and to json that enable import into DHIS2 system?

image

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

image

···

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

image

···

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

http://dhis2.org

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

image

···

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