← Back to team overview

dhis2-devs team mailing list archive

Re: Convert Excel to xml and to json

 

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@xxxxxxxxx> wrote:

> Hi all DHIS2,
> Do you know how to convert Excel tracker list to xml and to json that
> enable import into DHIS2 system?
>
> [image: Inline image 1]
>
> thank you
> CHANNARA
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> 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 "

PNG image


References