FW: Error during import

Sorry, here's the files

Export_2007-01-01_2010-12-31_Ghana_Pediatric_Epidemiology.zip (156 KB)

stdout_20101114.log (7.22 KB)

···

-----Original Message-----
From: r.friedman@mindspring.com [mailto:r.friedman@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

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) <rdf4@cdc.gov> wrote:

Sorry, here's the files

-----Original Message-----
From: r.friedman@mindspring.com [mailto:r.friedman@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