dhis2-devs team mailing list archive

[Paulo Grácio <pgracio@xxxxxxxxxxxxxxxxxxxx>]

Hi Knut,

 

What we are trying to achieve with this is a solution for manually import of data collected using legacy systems that only export data to excel.  We can implement an adapter that translates data from excel to SDMX-HD or DXF2, but this is one more step in the process and another software to give maintenance/support.

 

I was also digging around the new App Framework, suggestion from Pascal Brandt that attended your training session in Uganda. If possible , we would like to do a test drive of this new App and see if it can fit our requirements.

 

Kind regards,

Paulo Grácio

 

From: Knut Staring [mailto:knutst@xxxxxxxxx] 
Sent: quarta-feira, 31 de Julho de 2013 19:09
To: Paulo Grácio; Namrata Nehete
Cc: DHIS 2 developers
Subject: Re: [Dhis2-devs] Interoperability question

 

Hi Paulo,

 

Unfortunately, I think the experts on this particular feature are on holiday right at this moment, but hopefully you will get some help soon.

 

I just wanted to ask if this is a one time import or something that will happen regularly. The reason I'm asking is that there is work well under way right now to develop a module (using the new App framework) for importing data from Excel. It is still a bit rough (and thus not released yet), but it could possibly be of interest to you to experiment a bit with it.

 

Knut

 

On Wed, Jul 31, 2013 at 7:03 PM, Paulo Grácio <pgracio@xxxxxxxxxxxxxxxxxxxx> wrote:

Hi all,

 

We are wondering about the best form to import in DHIS2 data from legacy applications.

 

In chapter “26.4. Transforming data - a Java route” of the User Manual we see that there is a way to do this integration using Java routes, but we are having some difficulties in implementing a proof of concept.

 

In our PoC scenario we have a XLS file sent by an external application (DataValues.xls in attach). Our idea is to create a Java route in order to import all data values that exist in that file.

 

Following the tutorial “Customer 3: Excel via e-mail” presented in the Apache Camel page -  <http://camel.apache.org/tutorial-business-partners.html> http://camel.apache.org/tutorial-business-partners.html - we have been able to transform the XLS file in a list of DataValue objects. 

 

Basically, we only had to create a XLSDataIn route and a ExcelConverterBean (files in attach). The XLSDataIn takes an InputStream of an XLS file and calls the ExcelConverterBean. The ExcelConverterBean iterates through the file, and for each data value row, creates a new DataValue object and adds that object to a list of DataValue objects.

 

Now we are having some issues because we don’t know the best way to insert these data values in DHIS2.

 

The questions we are having are:

1.       The approach that we have used to implement our PoC is the correct one? I mean, XLS -> List<DataValue> -> import is correct or we should use XLS -> CSV -> import?

2.       How should we proceed, after the XLS file has been processed by the ExcelConverterBean?

 

 

Thanks for your support,

 <mailto:*%20your-email%20*> Paulo Grácio
Technical Manager
Skype: paulojrgracio

 <http://www.criticalsoftware.co.uk/> Critical Software Mozambique
Dependable Technologies for Critical Systems

Critical Software Mozambique is a subsidiary of  <http://cmmiinstitute.com/> Critical Software, a CMMI® Level 5 rated Company
CMMI® is registered in the USPTO by  <http://www.cmu.edu/> CMU

Rua Pereira Marinho, 179
Bairro de Sommerchield
Maputo
Moçambique
Phone: (+258) 214 951 45
Fax: (+258) 214 951 46

DISCLAIMER: This message is confidential and may contain privileged information. It is for use only by the people or entities to whom it is addressed. If you are not an intended recipient, you should not disclose, distribute, copy, print, rely on or otherwise make use of this message. If an addressing or transmission error has misdirected it to you we would be grateful if you would please notify the sender by return, before deleting it from your system.

 

 


_______________________________________________
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





 

-- 

Knut Staring

Dept. of Informatics, University of Oslo

+4791880522

http://dhis2.org