Hi Roger, Your problem was caused by the following orgunit, which had a blank name. This caused a database SQL constraint to be violated. I hope we can add information to the log messages to provide more useful feedback when imports go wrong, and have added a bug to that effect here: https://bugs.launchpad.net/dhis2/+bug/675527
<organisationUnit> <id>1118</id> <uuid>3595e8be-ecbe-11df-8b88-f683add72e62</uuid> <name></name> <shortName></shortName> <code>019999</code> <openingDate></openingDate> <closedDate></closedDate> <active>true</active> <comment></comment> <geoCode></geoCode> <feature type=""> </feature> <lastUpdated>2010-11-10</lastUpdated> </organisationUnit> The unnamed orgunit is also the parent of this orgunit: <organisationUnit> <id>1795</id> <uuid>5a3bc580-ecbe-11df-8b88-f683add72e62</uuid> <name>Ashanti RHD</name> <shortName>Ashanti RHD</shortName> <code>0199999999</code> <openingDate></openingDate> <closedDate></closedDate> <active>true</active> <comment></comment> <geoCode>Atonsu-Agogo</geoCode> <feature type=""> </feature> <lastUpdated>2010-11-10</lastUpdated> </organisationUnit> On Sun, Nov 14, 2010 at 1:14 PM, Friedman, Roger (CDC/CGH/DGHA) (CTR) <r...@cdc.gov> wrote: > Sorry, here's the files > > -----Original Message----- > From: r.fried...@mindspring.com [mailto:r.fried...@mindspring.com] > Sent: Sunday, November 14, 2010 4:59 AM > To: DHIS Lists > Cc: Friedman, Roger (CDC/CGH/DGHA) (CTR) > Subject: Error during import > > I exported the attached file. On importing it into an empty database, it > errored out ("see log") while loading org units. Could somebody take a look > at this when they have a chance? Using 2.0.5-beta and MySQL. > Thanks, Roger > > _______________________________________________ > Mailing list: https://launchpad.net/~dhis2-users > Post to : dhis2-users@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-users > More help : https://help.launchpad.net/ListHelp > > -- Cheers, Knut Staring _______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp