Hi Henri, As Knut says, there is no "automatic" way of doing this, mostly because your Excel files are likely completely custom. Thus, you will need to transform your Excel files into something which DHIS2 can understand, possibly using CSV to import data.
I have developed a somewhat more technical example of how this can be accomplished with the R programming language, although regardless of you what use, the steps are basically the same. You can find that here <http://rpubs.com/jason_p_pickering/139589>. Regards, Jason On Mon, Mar 21, 2016 at 5:21 PM, henri claude moungui <henrimoun...@yahoo.fr > wrote: > Thank you Knut. > > Henri > > > > > > Le Lundi 21 mars 2016 15h25, Knut Staring <knu...@gmail.com> a écrit : > > > Hi Henri, > > There is no specific 3rd party software that you have to use, people use > many different tools. Perhaps most commonly, people use scripts in Python > or R or similar to load data. You can import both metadata and data in CSV > format, for example. > > http://dhis2.github.io/dhis2-docs/2.21/en/developer/html/ch01s10.html > http://dhis2.github.io/dhis2-docs/2.21/en/user/html/ch21.html > > Knut > > On Mon, Mar 21, 2016 at 3:15 PM, henri claude moungui < > henrimoun...@yahoo.fr> wrote: > > Hi to all. > I want to test the ETL process with DHIS2. Is there an automated way to do > this? is there a recommended tiers soft to use for this? my operational DB > to use are excel files. > Thank you in advance. > > Henri Moungui > > > > > _______________________________________________ > Mailing list: https://launchpad.net/~dhis2-users > Post to : dhis2-users@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-users > More help : https://help.launchpad.net/ListHelp > > > > > -- > Knut Staring > Dept. of Informatics, University of Oslo > Norway: +4791880522 > Skype: knutstar > http://dhis2.org > > > > _______________________________________________ > Mailing list: https://launchpad.net/~dhis2-users > Post to : dhis2-users@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-users > More help : https://help.launchpad.net/ListHelp > > -- Jason P. Pickering email: jason.p.picker...@gmail.com tel:+46764147049
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
