Oh I see. Good to know for the future! Thanks all.
On Mon, Aug 21, 2017 at 9:04 AM Kristiyan Panayotov < kristi...@logicaloutcomes.net> wrote: > Hi all, > > > > The CSV that Nghia provided worked – Thanks a lot! > > > > Jesus – try that CSV. It seems the issue was on my end - I used wrong > column name: “Feature Type” instead of “featureType”. Sorry for confusion > > > > I now have minor issues such as - DHIS2 not displaying orgnit labels > (crashing) but that might be because I have nearly 3000 units most of which > have coordinates/ Will work around that before reporting it. > > > > *From:* Jesus Solano-Roman [mailto:asol...@broadinstitute.org] > *Sent:* 21 August 2017 15:30 > *To:* Kristiyan Panayotov <kristi...@logicaloutcomes.net>; Nghia Nguyen < > nghianguyentra...@gmail.com> > > > *Cc:* Solomon Kununga <solo...@logicaloutcomes.net>; > dhis2-devs@lists.launchpad.net; dhis2-us...@lists.launchpad.net > *Subject:* Re: [Dhis2-users] Betr: Import of coordinates fails in > v2.27(DHIS2) > > Hi again Kristiyan. > > > > I also agree with you that this isn't a UI issue because my import failed > using both the UI and the terminal (cURL) command to upload. > > > > Nghia has provided a CSV file. I see that it has square brackets for the > coordinates. I'm pretty sure I tried this before and it failed, but could > you give it a try? > > > > If it fails I'll create the JIRA issue and post the link here. > > > > If the import fails and you're using the UI, in the import summary after > you import you should see an error that says something like: value not > coordinate. > > > > In the meantime, what would be the problem with an XML file? Would it be > too large? Is every entry 2000 columns? > > > > Good luck! > > > > On Mon, Aug 21, 2017 at 5:50 AM Nghia Nguyen <nghianguyentra...@gmail.com> > wrote: > > 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-us...@lists.launchpad.net; Solomon > Kununga <solo...@logicaloutcomes.net>; dhis2-devs@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-devs@lists.launchpad.net; dhis2-us...@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-devs@lists.launchpad.net" < > dhis2-devs@lists.launchpad.net>, "dhis2-us...@lists.launchpad.net" < > dhis2-us...@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-us...@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-us...@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-us...@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-us...@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 > > [image: Image removed by sender.] > > _______________________________________________ > Mailing list: https://launchpad.net/~dhis2-users > Post to : dhis2-us...@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-users > More help : https://help.launchpad.net/ListHelp > >
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
