dhis2-devs team mailing list archive
-
dhis2-devs team
-
Mailing list archive
-
Message #39334
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 "
References