Hello, sorry for the misunderstanding, it was my fault. I read the mail too fast! Anyway I resolved using kettle. The problem now is that I am not able to display my new data.
Sorry for my continuos questions but I'm studing the documentation and at the same time I need your help on ML to set up a demo on my server. Thank u again! -- Fabio D'Ovidio Geospatial solutions INOVA s.r.l. Web : http://www.inovaos.it Tel.: 081 197 57 600 mail: [EMAIL PROTECTED] Ola Hodne Titlestad ha scritto: > I was just saying that we need this functionality, not that it was > already implemented. So at the moment the only way to add orgunits is > one by one through the GUI or by inserting directly into the database > (and manually take care of the source table). > > On Wed, Oct 29, 2008 at 11:47 AM, Fabio D'Ovidio > <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>> wrote: > > Hello. > I created with kettle an XLS file like this: > organisationunitid geocode name shortname parentid > 14775 1 PIEMONTE PIEMONTE 14775 > 14776 2 VALLE D'AOSTA VALLE D AOSTA 14776 > 14777 3 LOMBARDIA LOMBARDIA 14777 > 14778 4 TRENTINO-ALTO ADIGE TRENTINO-ALTO ADIGE 14778 > 14779 5 VENETO VENETO 14779 > 14780 6 FRIULI VENEZIA GIULIA FRIULI VENEZIA GIULIA 14780 > 14781 7 LIGURIA LIGURIA 14781 > 14782 8 EMILIA-ROMAGNA EMILIA-ROMAGNA 14782 > 14783 9 TOSCANA TOSCANA 14783 > 14784 10 UMBRIA UMBRIA 14784 > 14785 11 MARCHE MARCHE 14785 > 14786 12 LAZIO LAZIO 14786 > 14787 13 ABRUZZO ABRUZZO 14787 > 14788 14 MOLISE MOLISE 14788 > 14789 15 CAMPANIA CAMPANIA 14789 > 14790 16 PUGLIA PUGLIA 14790 > 14791 17 BASILICATA BASILICATA 14791 > 14792 18 CALABRIA CALABRIA 14792 > 14793 19 SICILIA SICILIA 14793 > 14794 20 SARDEGNA SARDEGNA 14794 > > I try to import from dhis GUI but it doesn't work. > In the log file the error is: > 29-ott-2008 9.21.51 org.apache.catalina.startup.Catalina start > INFO: Server startup in 102580 ms > * ERROR 09:38:42,359 Content-Type not allowed: upload > "upload_41f21e5d_11d47c12f3a__8000_00000001.tmp" > application/vnd.ms-excel (FileUploadInterceptor.java [http-8180-1]) > * WARN 09:38:51,890 Item is a file upload of 0 size, ignoring > (JakartaMultiPartRequest.java [http-8180-1]) > * ERROR 09:39:12,843 Content-Type not allowed: upload > "upload_41f21e5d_11d47c12f3a__8000_00000011.tmp" > application/vnd.ms-excel (FileUploadInterceptor.java [http-8180-1]) > * ERROR 09:40:51,781 Content-Type not allowed: upload > "upload_41f21e5d_11d47c12f3a__8000_00000016.tmp" > application/vnd.ms-excel (FileUploadInterceptor.java [http-8180-1]) > > Ola Hodne Titlestad ha scritto: > > Hi, > > > > I related comment is that we need to have some kind of batch > insert of > > new orgunits available from the orgunit gui. > > E.g import from an excel file on a pre-defined format could > work, and > > has been used successfully in DHIS 1. This will save the admins > huge > > amounts of time when setting up new orgunit hierarchies. > > > > The format could e.g be: > > > > parentname name shortname code geocode > > > > Then the java code will take care of the relationship to source and > > input validation etc. > > > > Ola > > ----------- > > > > > > On Tue, Oct 28, 2008 at 6:21 PM, Lars Helge Øverland > > <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > <mailto:[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>>> wrote: > > > > > > > > > > > > Must I operate before on source table and insert sourceID ? > > > > > > Sorry didn't catch that. Yes, in the java code Source is a > > superclass for OrganisationUnit. So each entry in the > > organisationunittable must have a corresponding entry (id) > in the > > source table. > > > > > > > > _______________________________________________ > > Dhis-users mailing list > > [email protected] <mailto:[email protected]> > <mailto:[email protected] <mailto:[email protected]>> > > http://www.hisp.info/mailman/listinfo/dhis-users > > > > > > > > > > -- > > best regards, > > Ola Hodne Titlestad > > HISP > > University of Oslo > > > ------------------------------------------------------------------------ > > > > _______________________________________________ > > Dhis-users mailing list > > [email protected] <mailto:[email protected]> > > http://www.hisp.info/mailman/listinfo/dhis-users > > > > -- > Fabio D'Ovidio > Geospatial solutions > > INOVA s.r.l. > Web : http://www.inovaos.it > Tel.: 081 197 57 600 > mail: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > > _______________________________________________ > Dhis-users mailing list > [email protected] <mailto:[email protected]> > http://www.hisp.info/mailman/listinfo/dhis-users > > > > > -- > best regards, > Ola Hodne Titlestad > HISP > University of Oslo > ------------------------------------------------------------------------ > > _______________________________________________ > Dhis-users mailing list > [email protected] > http://www.hisp.info/mailman/listinfo/dhis-users > _______________________________________________ Dhis-users mailing list [email protected] http://www.hisp.info/mailman/listinfo/dhis-users
