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 <pgra...@criticalsoftware.com>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 - 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,**** > > *Paulo Grácio <*%20your-email%20*>* > *Technical Manager* > Skype: paulojrgracio**** > > *Critical Software Mozambique* <http://www.criticalsoftware.co.uk/> > *Dependable Technologies for Critical Systems***** > > Critical Software Mozambique is a subsidiary of Critical Software, a > CMMI® Level 5 rated Company <http://cmmiinstitute.com/> > CMMI® is registered in the USPTO by CMU <http://www.cmu.edu/>**** > > 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@lists.launchpad.net > 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
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp