That is often the easiest way. Excel also comes with recordable macros and its own scripting language, VBA.
Good luck! On Wed, Mar 23, 2016 at 9:01 AM, henri claude moungui <henrimoun...@yahoo.fr > wrote: > Hi. > Thank you Ant, Knut, Jason and Aaron for the tips. I'm sure the > discussions we are having will make us continue to improve the DHIS2 > platform, particularly for datawarehouse implementations. > I was also looking for Kettle and Talend for this purpose. Finally, I > found DHIS2 very comfortable for Export and Import as it is possible to do > this step by step (you choose which metadata you want to export/import). > Now I see the way is how to TRANSFORM the Excel databases to fit with the > exported file. For now, I intend to do this manually... > > Thank you. > > > > > > > Le Mardi 22 mars 2016 7h58, Aaron Gladders <agladd...@2paths.com> a écrit > : > > > Hi - we did some work using Talend based on client desires. We found it > to be an incredible pain in the butt. Although our group are typically > senior software developers or technical architects we had to pull in vendor > consultants to get training on how to use it and ultimately dumped it. > Beware the marketing - they all promote self-service but I suspect you'll > either be bringing in their trainers, hiring their consultants or finding > your own software developers to actually get the job done. > > Aaron > > > On Tue, Mar 22, 2016 at 12:04 AM, Knut Staring <knu...@gmail.com> wrote: > > Good point, Ant. > > Here is a link to that conversation, with many interesting points: > https://lists.launchpad.net/dhis2-users/msg09234.html > > Knut > > On Tue, Mar 22, 2016 at 6:23 AM, Ant Snyman <a...@hisp.org> wrote: > > Hi Henri, > I read on this forum that someone was attempting to use Kettle (Pentaho > Data Integration). I don't know whether they succeeded. > Regards > Ant Snyman > > On 21 March 2016 at 18:21, 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 > > > > > -- > > *Ant Snyman* > *Cell: 0824910449* > *Landline: 028 2713242* > > Health Information Systems Program - SA > > *This message and any attachments are subject to a disclaimer published at > http://www.hisp.org/policies.html#comms_disclaimer > <http://www.hisp.org/policies.html#comms_disclaimer>. Please read the > disclaimer before opening any attachment or taking any other action in > terms of this electronic transmission. If you cannot access the > disclaimer, kindly send an email to disclai...@hisp.org > <disclai...@hisp.org> and a copy will be provided to you. By replying to > this e-mail or opening any attachment you agree to be bound by the > provisions of the disclaimer.* > > > > > -- > 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 > > > > > -- > Aaron Gladders, 2Paths > http://www.2paths.com/ > > _______________________________________________ > 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
