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 < kristi...@logicaloutcomes.net> 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.sc...@rabiesalliance.org] > *Sent:* 21 August 2017 12:17 > *To:* Kristiyan Panayotov <kristi...@logicaloutcomes.net> > *Cc:* Jesus Solano-Roman <asol...@broadinstitute.org>; Gijsbert OOMS < > gijsbert.o...@btcctb.org>; dhis2-users@lists.launchpad.net; Solomon > Kununga <solo...@logicaloutcomes.net>; dhis2-d...@lists.launchpad.net > *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.sc...@rabiesalliance.org > > 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 < > kristi...@logicaloutcomes.net> 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:asol...@broadinstitute.org] > *Sent:* 17 August 2017 14:42 > *To:* Gijsbert OOMS <gijsbert.o...@btcctb.org>; Kristiyan Panayotov < > kristi...@logicaloutcomes.net> > *Cc:* Solomon Kununga <solo...@logicaloutcomes.net>; > dhis2-d...@lists.launchpad.net; dhis2-users@lists.launchpad.net > *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.o...@btcctb.org> > 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 <kristi...@logicaloutcomes.net> > Aan: "dhis2-d...@lists.launchpad.net" <dhis2-devs@lists.launchpad. > net>, "dhis2-users@lists.launchpad.net" <dhis2-users@lists.launchpad.net> > Cc: Solomon Kununga <solo...@logicaloutcomes.net> > 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....@lists.launchpad.net> > ------------------------------ > > > > > 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/ > kristi...@logicaloutcomes.net <http://kristi...@logicaloutcomes.net%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@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-users > More help : https://help.launchpad.net/ListHelp > > _______________________________________________ > 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 > > > _______________________________________________ > 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 > > > > _______________________________________________ > 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 > > -- ---------------------------------------- Name: Nguyễn Trần Nghĩa. Tel: 0903721500
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]",,,,,
_______________________________________________ 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