← Back to team overview

dhis2-devs team mailing list archive

Re: [Dhis2-users] Betr: Import of coordinates fails in v2.27(DHIS2)

 

Hi Kristiyan,

Can you try this CSV format, its work ok with me in 2.27.

On Mon, Aug 21, 2017 at 4:36 PM, Kristiyan Panayotov <
Kristiyan@xxxxxxxxxxxxxxxxxxx> wrote:

> Thank you Terence. I voted, but not sure that it is the case. Import works
> for my build, regarding data elements, org units, etc. Only some features
> such as coordinates are giving problems.
>
>
>
> Kris
>
>
>
> *From:* Terence Scott [mailto:terence.scott@xxxxxxxxxxxxxxxxxx]
> *Sent:* 21 August 2017 12:17
> *To:* Kristiyan Panayotov <Kristiyan@xxxxxxxxxxxxxxxxxxx>
> *Cc:* Jesus Solano-Roman <asolano@xxxxxxxxxxxxxxxxxx>; Gijsbert OOMS <
> gijsbert.ooms@xxxxxxxxxx>; dhis2-users@xxxxxxxxxxxxxxxxxxx; Solomon
> Kununga <Solomon@xxxxxxxxxxxxxxxxxxx>; dhis2-devs@xxxxxxxxxxxxxxxxxxx
> *Subject:* Re: [Dhis2-users] Betr: Import of coordinates fails in
> v2.27(DHIS2)
>
>
>
> Hi Kristiyan
>
>
>
> I have experienced the same problems with import using the import tool.
> The UI has a bug and the issue is currently open in Jira. Please vote for
> the issue so that it can be prioritised and the bug can be fixed.
>
>
>
> The Jira issue can be found here: https://jira.dhis2.org/browse/DHIS2-2069
>
>
>
> If you are not on Jira, it takes a few seconds to register an account and
> then vote for the issue.
>
>
>
> I hope this helps.
>
>
>
> Kind regards,
>
> Terence
>
>
> Terence Scott
>
>
>
> Global Alliance for Rabies Control (GARC)
>
> Pan-African Rabies Control Network (PARACON) Steering Committee
>
> terence.scott@xxxxxxxxxxxxxxxxxx
>
> https://paracon.rabiesalliance.org
>
> Skype: tpscott1987
>
>
>
> [image: Image removed by sender.]
>
> *World Rabies Day *is on* September 28th 2017*
>
>
>
> [image: Image removed by sender.]
>
>
>
> Take action: you can register your World Rabies Day event, nominate
> someone for the WRD Awards and find out more here
> <https://rabiesalliance.org/world-rabies-day/>
>
> Don't forget to tweet us using #worldrabiesday
>
>
>
>
>
> On Mon, Aug 21, 2017 at 11:12 AM, Kristiyan Panayotov <
> Kristiyan@xxxxxxxxxxxxxxxxxxx> wrote:
>
> Hello all,
>
>
> Thanks for taking time to answer my question.
>
>
>
> I tried changing column names and did not get an error. Although, I still
> do not see the coordinates in the GIS app. DHIS2 is telling me that there
> are “No coordinates”. This works fine with manual entry of latitude and
> longitude but Not through a csv import.
>
>
>
> Jesus Solano-Roman – I will be happy to support you for a ticket on JIRA.
> Building a XML file is not an option as I have over 2000 units (points) for
> my OrgUnits.
>
>
>
> Kind Regards,
>
> Kris
>
>
>
> *From:* Jesus Solano-Roman [mailto:asolano@xxxxxxxxxxxxxxxxxx]
> *Sent:* 17 August 2017 14:42
> *To:* Gijsbert OOMS <gijsbert.ooms@xxxxxxxxxx>; Kristiyan Panayotov <
> Kristiyan@xxxxxxxxxxxxxxxxxxx>
> *Cc:* Solomon Kununga <Solomon@xxxxxxxxxxxxxxxxxxx>;
> dhis2-devs@xxxxxxxxxxxxxxxxxxx; dhis2-users@xxxxxxxxxxxxxxxxxxx
> *Subject:* Re: [Dhis2-users] Betr: Import of coordinates fails in
> v2.27(DHIS2)
>
>
>
> Hello all.
>
>
>
> I have yet to submit an issue regarding this. In my case it was impossible
> to upload coordinates in CSV for event data. I tried with header, without
> header, using square brackets for the coordinates, using quotation marks,
> etc.
>
>
>
> If you have a comma without quotation marks the parser will think the
> second value belongs to the next column. If you have quotation marks it
> will not interpret the value as type coordinate and the import will fail.
>
>
>
> The only way I got around the problem was to import the data using XML.
>
>
>
> It would be nice to know if you can't make it work. That way I'd have more
> confidence submitting a ticket on JIRA.
>
>
>
>
>
>
>
> On Thu, Aug 17, 2017 at 6:32 AM Gijsbert OOMS <gijsbert.ooms@xxxxxxxxxx>
> wrote:
>
> Hi Kristiyan,
>
>
> Would it be possible that you have one extra column somewhere (maybe a
> double comma) ?
>
> The way I understood csv-imports, DHIS2 doesn't read the column names in
> your csv but just counts the colums (see list of colums here
> <https://docs.dhis2.org/2.26/en/developer/html/webapi_csv_metadata_import.html>,
> Table 1.17). Coordinates should be in column nr 12, url should be in nr 13.
> From the log, it seems that DHIS2 thinks that you try to import a url. This
> probably means that your coordinates are in column nr 13 or "M", while they
> should be in column nr 12 or "N".
>
>
> *Error! Filename not specified.*
>
> *GIJSBERT OOMS*
> EXPERT D4D - Digitalisation for Development
>
> BELGIAN DEVELOPMENT AGENCY
> RUE HAUTE 147
> 1000 BRUSSELS
> T +32 (0)2 505 18 44 <+32%202%20505%2018%2044>
> F +32 (0)2 502 98 62 <+32%202%20502%2098%2062>
> M +32 (0)477 300 770
> WWW.BTCCTB.ORG <http://www.btcctb.org/>
>
> *Save paper! Think before you print*
>
>
>
> Van:        Kristiyan Panayotov <Kristiyan@xxxxxxxxxxxxxxxxxxx>
> Aan:        "dhis2-devs@xxxxxxxxxxxxxxxxxxx" <dhis2-devs@lists.launchpad.
> net>, "dhis2-users@xxxxxxxxxxxxxxxxxxx" <dhis2-users@xxxxxxxxxxxxxxxxxxx>
> Cc:        Solomon Kununga <Solomon@xxxxxxxxxxxxxxxxxxx>
> Datum:        16/08/2017 10:23
> Onderwerp:        [Dhis2-users] Import of coordinates fails in
> v2.27(DHIS2)
> Verzonden door:        "Dhis2-users" <dhis2-users-bounces+gijsbert.ooms=
> btcctb.org@xxxxxxxxxxxxxxxxxxx>
> ------------------------------
>
>
>
>
> Dear all,
>
> My case is regarding the following: *DHIS->Import->CSV->Organizational
> Units->Coordinates.* I am not sure whether this is a bug or not well
> described in the documentation but import of coordinates does not work
> properly DHIS2 v.2.27.
>
> I have tried numerous combinations of arranging the latitude and longitude
> in my .CSV file and none of that worked when import in DHIS2. My feature
> type is “POINT”. This is the "Conflict" I get:
>
> ~
> Main Type           Error Type           Description
> OrganisationUnit              String    Property `url` requires a valid
> URL, was given `[36.035858,31.871833]`.
> ~
> Combinations were made with: dots, commas, space, most type of brackets,
> rotating latitude and longitude, etc.
>
>
> When I entered coordinates manually in DHIS2 for a single OrgUnit and I
> could successfully view that POINT on a map. This is what I get from a XML
> export of Organization Units regarding manually input of coordinates:
>
> <featureType>POINT</featureType>
> <coordinates>[36.035858,31.871833]</coordinates>
>
> Your help will be very appreciated as I need to enter approximately 2000
> Point coordinates for Organizational Units.
>
> Kind Regards,
> Kristiyan Panayotov
>
>
>
>
>
> Kristiyan Panayotov | Data analyst, http://www.logicaloutcomes.net/
> kristiyan@xxxxxxxxxxxxxxxxxxx <http://kristiyan@xxxxxxxxxxxxxxxxxxx%20> |
> Sofia +359 889 318 878 <+359%2088%20931%208878> | Skype ID: kr.panayotov
>  _______________________________________________
> 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
>
> _______________________________________________
> 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
>
>
> _______________________________________________
> 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
>
>
>
> _______________________________________________
> 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
>
>


-- 
----------------------------------------
Name: Nguyễn Trần Nghĩa.
Tel: 0903721500

JPEG image

JPEG image

name,uid,code,parent,shortName,description,openingDate,closedDate,comment,featureType,coordinates,url,contactPerson,address,email,phoneNumber
BMAL BPCC0004,,BPCC0004,YuQRtpLP10I,BMAL BPCC0004,,2017-04-04,,,POINT,"[106.796325,11.957054]",,,,,

Follow ups

References