Re: [Dhis2-users] ETL process with DHIS2

2016-03-24 Thread henri claude moungui
Thank you Uwe for sharing your experience. Better late than never  I agree with you. It is effectively the graphical data-flow on ETL that is missing on DHIS2... Regards. Henri   Le Jeudi 24 mars 2016 9h18, Uwe Wahser a écrit : HI Henri, sorry for for chipping in late, I am on vaccati

Re: [Dhis2-users] ETL process with DHIS2

2016-03-24 Thread Uwe Wahser
HI Henri, sorry for for chipping in late, I am on vaccation. We are using kettle for extracting data into DHIS2 as a prototype for a datawarehouse in a corporate setting. A few of Aarons points on Talend apply for kettle as well. Things can get tricky, but that is partly because of the nature of d

Re: [Dhis2-users] ETL process with DHIS2

2016-03-23 Thread Knut Staring
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 wrote: > Hi. > Thank you Ant, Knut, Jason and Aaron for the tips. I'm sure the > discussions we are having will make us c

Re: [Dhis2-users] ETL process with DHIS2

2016-03-23 Thread henri claude moungui
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

Re: [Dhis2-users] ETL process with DHIS2

2016-03-21 Thread Aaron Gladders
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

Re: [Dhis2-users] ETL process with DHIS2

2016-03-21 Thread Knut Staring
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 wrote: > Hi Henri, > I read on this forum that someone was attempting to use Kettle (Pentaho > Data Integra

Re: [Dhis2-users] ETL process with DHIS2

2016-03-21 Thread Ant Snyman
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 wrote: > Thank you Knut. > > Henri > > > > > > Le Lundi 21 mars 2016 15h25, Knut Staring a

Re: [Dhis2-users] ETL process with DHIS2

2016-03-21 Thread Jason Pickering
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 technica

Re: [Dhis2-users] ETL process with DHIS2

2016-03-21 Thread henri claude moungui
Thank you Knut. Henri    Le Lundi 21 mars 2016 15h25, Knut Staring 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 me

Re: [Dhis2-users] ETL process with DHIS2

2016-03-21 Thread Knut Staring
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/de

[Dhis2-users] ETL process with DHIS2

2016-03-21 Thread henri claude moungui
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://launch