dhis2-devs team mailing list archive

[Jason Pickering <jason.p.pickering@xxxxxxxxx>]

Hi Channara,

Good to know this is fake data.

Anyway, did you have a look here at the docs
<https://www.dhis2.org/doc/snapshot/en/developer/html/ch01s40.html>?

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@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
>
>


-- 
Jason P. Pickering
email: jason.p.pickering@xxxxxxxxx
tel:+46764147049