dhis2-users team mailing list archive

[Knut Staring <knutst@xxxxxxxxx>]

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@xxxxxxx> wrote:
> Sorry, here's the files
>
> -----Original Message-----
> From: r.friedman@xxxxxxxxxxxxxx [mailto:r.friedman@xxxxxxxxxxxxxx]
> 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@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>



-- 
Cheers,
Knut Staring