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]>> 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]> > 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 > -- Fabio D'Ovidio Geospatial solutions INOVA s.r.l. Web : http://www.inovaos.it Tel.: 081 197 57 600 mail: [EMAIL PROTECTED] _______________________________________________ Dhis-users mailing list [email protected] http://www.hisp.info/mailman/listinfo/dhis-users
