I have asked Ese (off list) to send me a copy of the generated gml
file to check.
Bob
(Posting this in a new thread)
···
On 5 July 2012 16:22, Jan Henrik Øverland <janhenrik.overland@gmail.com> wrote:
Hi Ese,
there are a couple of other possible error causes in the gml as well, like
orgunit duplicates and names that are too long for the shortname column in
the database. The server log will probably give you a hint, so please have a
look if you have access to it.
On Thu, Jul 5, 2012 at 4:42 PM, Ese Egerega <ese@cis.com.ng> wrote:
I am wondering if anyone can be of help...I am having issues with the GIS
module.
I downloaded a shape file for my country and converted one of the
extracted files (NGA_adm2.shp) to GML using ogr2gui.
I further changed the "NAME_2" tag as directed. Finally, I made sure that
the names in my gml file have exactly the same names as the org unit names
in DHIS.
The problem is that nothing happens when I import the GML file to DHIS.
All the elements show "none"
On Fri, Jun 29, 2012 at 12:20 AM, Ese Egerega <ese@cis.com.ng> wrote:
Hi Bob,
Thanks a lot. I was having a similar problem with datamart but it was
fixed once I generated tables.
Ese
On Wed, Jun 27, 2012 at 4:04 PM, Bob Jolliffe <bobjolliffe@gmail.com> >>> wrote:
Hi Kabango
This is an odd error but I believe it is probably caused because you
are missing resource tables on the dhis server side. On dhis server
go to:
data administration -> resource tables -> select all -> generate tables
and try again.
Regards
Bob
On 27 June 2012 15:32, Kabango Malewezi <kmalewezi@jhpiego.net> wrote:
> Dear Users
>
>
>
> I'm new to DHIS and I have a problem.
>
>
>
> After I run datamart, login, and download Metadata I cannot update
> Aggregate data. Enclosed is the log file.
>
>
>
>
>
> Kabango Malewezi | Database Specialist
>
> SSDI Services
>
> 2nd Floor, Pamodzi House, City Center, P.O Box 1091, Lilongwe, Malawi
> Tel: +265 (01) 776 412/3/4 | fax: +265 (01) 776 410 | Mobile: +265 (0)
> 88 4 245 431
>
> kmalewezi@jhpiego.net <mailto:kmalewezi@jhpiego.net > |
> www.jhpiego.org<http://www.jhpiego.org/>
>
> Skype: kabango.malewezi | Twitter: kabangoM
>
> _______________________________________________
> Mailing list: DHIS 2 Users in Launchpad
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : DHIS 2 Users in Launchpad
> More help : ListHelp - Launchpad Help
>
There are a few things wrong with this file
(i) on line 43 you have:
<ogr:Shape_Leng>10.94<ogr:Shape_Leng>
which should be
<ogr:Shape_Leng>10.94</ogr:Shape_Leng>
(ii) then in each of the featuremembers you have the Name element
apearing twice, eg
<ogr:ID_0>164</ogr:ID_0>
<ogr:ISO>NGA</ogr:ISO>
<ogr:Name>Nigeria</ogr:Name>
<ogr:ID_1>2017</ogr:ID_1>
<ogr:Name>Adamawa</ogr:Name>
Its hard for me to understand how these strange errors have come
about, but dhis2 cannot import this. (it gets a duplicate Name
constraint violation as Nigeria is everywhere).
Having said that, these are not at all the same errors I saw from your
attached log file. So I am not convinced that the gml file you sent
me is actually the one you were trying to import. Is there some
chance of a mixup here?
Bob
···
On 6 July 2012 10:24, Ese Egerega <ese@cis.com.ng> wrote:
Sorry for the delay in responding Bob. I have attached a copy of the
generated gml file as well as the log
On Thu, Jul 5, 2012 at 4:43 PM, Bob Jolliffe <bobjolliffe@gmail.com> wrote:
I have asked Ese (off list) to send me a copy of the generated gml
file to check.
Bob
(Posting this in a new thread)
On 5 July 2012 16:22, Jan Henrik Øverland <janhenrik.overland@gmail.com> >> wrote:
> Hi Ese,
>
> there are a couple of other possible error causes in the gml as well,
> like
> orgunit duplicates and names that are too long for the shortname column
> in
> the database. The server log will probably give you a hint, so please
> have a
> look if you have access to it.
>
> On Thu, Jul 5, 2012 at 4:42 PM, Ese Egerega <ese@cis.com.ng> wrote:
>>
>> I am wondering if anyone can be of help...I am having issues with the
>> GIS
>> module.
>>
>> I downloaded a shape file for my country and converted one of the
>> extracted files (NGA_adm2.shp) to GML using ogr2gui.
>>
>> I further changed the "NAME_2" tag as directed. Finally, I made sure
>> that
>> the names in my gml file have exactly the same names as the org unit
>> names
>> in DHIS.
>>
>> The problem is that nothing happens when I import the GML file to DHIS.
>> All the elements show "none"
>>
>> On Fri, Jun 29, 2012 at 12:20 AM, Ese Egerega <ese@cis.com.ng> wrote:
>>>
>>> Hi Bob,
>>>
>>> Thanks a lot. I was having a similar problem with datamart but it was
>>> fixed once I generated tables.
>>>
>>> Ese
>>>
>>>
>>> On Wed, Jun 27, 2012 at 4:04 PM, Bob Jolliffe <bobjolliffe@gmail.com> >> >>> wrote:
>>>>
>>>> Hi Kabango
>>>>
>>>> This is an odd error but I believe it is probably caused because you
>>>> are missing resource tables on the dhis server side. On dhis server
>>>> go to:
>>>>
>>>> data administration -> resource tables -> select all -> generate
>>>> tables
>>>>
>>>> and try again.
>>>>
>>>> Regards
>>>> Bob
>>>>
>>>> On 27 June 2012 15:32, Kabango Malewezi <kmalewezi@jhpiego.net> >> >>>> wrote:
>>>> > Dear Users
>>>> >
>>>> >
>>>> >
>>>> > I'm new to DHIS and I have a problem.
>>>> >
>>>> >
>>>> >
>>>> > After I run datamart, login, and download Metadata I cannot update
>>>> > Aggregate data. Enclosed is the log file.
>>>> >
>>>> >
>>>> >
>>>> >
>>>> >
>>>> > Kabango Malewezi | Database Specialist
>>>> >
>>>> > SSDI Services
>>>> >
>>>> > 2nd Floor, Pamodzi House, City Center, P.O Box 1091, Lilongwe,
>>>> > Malawi
>>>> > Tel: +265 (01) 776 412/3/4 | fax: +265 (01) 776 410 | Mobile: +265
>>>> > (0)
>>>> > 88 4 245 431
>>>> >
>>>> > kmalewezi@jhpiego.net <mailto:kmalewezi@jhpiego.net > |
>>>> > www.jhpiego.org<http://www.jhpiego.org/>
>>>> >
>>>> > Skype: kabango.malewezi | Twitter: kabangoM
>>>> >
>>>> > _______________________________________________
>>>> > Mailing list: DHIS 2 Users in Launchpad
>>>> > Post to : dhis2-users@lists.launchpad.net
>>>> > Unsubscribe : DHIS 2 Users in Launchpad
>>>> > More help : ListHelp - Launchpad Help
>>>> >
>>>>
>>>> _______________________________________________
>>>> Mailing list: DHIS 2 Users in Launchpad
>>>> Post to : dhis2-users@lists.launchpad.net
>>>> Unsubscribe : DHIS 2 Users in Launchpad
>>>> More help : ListHelp - Launchpad Help
>>>
>>>
>>
>>
>> _______________________________________________
>> Mailing list: DHIS 2 Users in Launchpad
>> Post to : dhis2-users@lists.launchpad.net
>> Unsubscribe : DHIS 2 Users in Launchpad
>> More help : ListHelp - Launchpad Help
>>
>
Am glad to inform you that my gml file is now working The email from Bob made all the difference. I corrected the line (43) that had error. I also removed the Name tag from Nigeria. See sample below:
That is good to hear Ese. Though now you need to figure out how you ended up with the invalid gml in the first place. I think the ogr tool is usually fairly reliable but perhaps Jan or Knut might have better insights than I on this. OTOH you might no longer care now you have imported your shapefiles
Am glad to inform you that my gml file is now working The email from Bob made all the difference. I corrected the line (43) that had error. I also removed the Name tag from Nigeria. See sample below:
The email from Bob made all the difference. I corrected the line (43) that had error. I also removed the Name tag from Nigeria. See sample below: