Import of coordinates fails in v2.27(DHIS2)

Kristiyan_Panayotov · 16 August 2017 08:22

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:

···

Kristiyan Panayotov | Data analyst, http://www.logicaloutcomes.net/

kristiyan@logicaloutcomes.net
| Sofia +359 889 318 878 | Skype ID: kr.panayotov

Gijsbert_OOMS · 17 August 2017 10:31

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 , 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”.

GIJSBERT OOMS

EXPERT D4D - Digitalisation for Development

BELGIAN DEVELOPMENT AGENCY

RUE HAUTE 147

1000 BRUSSELS

T +32 (0)2 505 18 44

F +32 (0)2 502 98 62

M +32 (0)477 300 770

WWW.BTCCTB.ORG

Save paper! Think before you print

···

Van: Kristiyan Panayotov Kristiyan@logicaloutcomes.net

Aan: “dhis2-devs@lists.launchpad.net” dhis2-devs@lists.launchpad.net, “dhis2-users@lists.launchpad.net” dhis2-users@lists.launchpad.net

Cc: Solomon Kununga Solomon@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.org@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:

POINT

[36.035858,31.871833]

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@logicaloutcomes.net

Sofia +359 889 318 878 | Skype ID: kr.panayotov

`_______________________________________________

Mailing list: [https://launchpad.net/~dhis2-users`](https://launchpad.net/~dhis2-users)`

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : [https://launchpad.net/~dhis2-users`](https://launchpad.net/~dhis2-users)`

More help : [https://help.launchpad.net/ListHelp`](https://help.launchpad.net/ListHelp)`

`

Jesus_Solano-Roman · 17 August 2017 11:41

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@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 , 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”.

GIJSBERT OOMS

EXPERT D4D - Digitalisation for Development

BELGIAN DEVELOPMENT AGENCY

RUE HAUTE 147

1000 BRUSSELS

T +32 (0)2 505 18 44

F +32 (0)2 502 98 62

M +32 (0)477 300 770

WWW.BTCCTB.ORG

Save paper! Think before you print

Van: Kristiyan Panayotov Kristiyan@logicaloutcomes.net

Aan: “dhis2-devs@lists.launchpad.net” dhis2-devs@lists.launchpad.net, “dhis2-users@lists.launchpad.net” dhis2-users@lists.launchpad.net

Cc: Solomon Kununga Solomon@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.org@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:

POINT

[36.035858,31.871833]

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@logicaloutcomes.net

Sofia +359 889 318 878 | Skype ID: kr.panayotov

`_______________________________________________

Mailing list: [https://launchpad.net/~dhis2-users`](https://launchpad.net/~dhis2-users)`

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : [https://launchpad.net/~dhis2-users`](https://launchpad.net/~dhis2-users)`

More help : [https://help.launchpad.net/ListHelp`](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

Kristiyan_Panayotov · 21 August 2017 09:12

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

···

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@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 , 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”.

GIJSBERT OOMS

EXPERT D4D - Digitalisation for Development

BELGIAN DEVELOPMENT AGENCY

RUE HAUTE 147

1000 BRUSSELS

T +32 (0)2 505 18 44

F +32 (0)2 502 98 62

M +32 (0)477 300 770

WWW.BTCCTB.ORG

Save paper! Think before you print

Van: Kristiyan Panayotov Kristiyan@logicaloutcomes.net

Aan: “dhis2-devs@lists.launchpad.net” <dhis2-devs@lists.launchpad.net >, “dhis2-users@lists.launchpad.net” dhis2-users@lists.launchpad.net

Cc: Solomon Kununga Solomon@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.org@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:

POINT

[36.035858,31.871833]

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@logicaloutcomes.net | Sofia +359 889 318 878 | 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

Terence_Scott · 21 August 2017 09:17

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

···

On Mon, Aug 21, 2017 at 11:12 AM, Kristiyan Panayotov Kristiyan@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:asolano@broadinstitute.org]

Sent: 17 August 2017 14:42

To: Gijsbert OOMS gijsbert.ooms@btcctb.org; Kristiyan Panayotov Kristiyan@logicaloutcomes.net

Cc: Solomon Kununga Solomon@logicaloutcomes.net; dhis2-devs@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.ooms@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 , 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”.

GIJSBERT OOMS

EXPERT D4D - Digitalisation for Development

BELGIAN DEVELOPMENT AGENCY

RUE HAUTE 147

1000 BRUSSELS

T +32 (0)2 505 18 44

F +32 (0)2 502 98 62

M +32 (0)477 300 770

WWW.BTCCTB.ORG

Save paper! Think before you print

Van: Kristiyan Panayotov Kristiyan@logicaloutcomes.net

Aan: “dhis2-devs@lists.launchpad.net” <dhis2-devs@lists.launchpad.net >, “dhis2-users@lists.launchpad.net” dhis2-users@lists.launchpad.net

Cc: Solomon Kununga Solomon@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.org@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:

POINT

[36.035858,31.871833]

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@logicaloutcomes.net | Sofia +359 889 318 878 | 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

Terence Scott

Global Alliance for Rabies Control (GARC)

Pan-African Rabies Control Network (PARACON) Steering Committee

terence.scott@rabiesalliance.org

https://paracon.rabiesalliance.org

Skype: tpscott1987

World Rabies Day is onSeptember 28th 2017

Take action: you can register your World Rabies Day event, nominate someone for the WRD Awards and find out more here

Don’t forget to tweet us using #worldrabiesday

Kristiyan_Panayotov · 21 August 2017 09:36

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

···

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@rabiesalliance.org

https://paracon.rabiesalliance.org

Skype: tpscott1987

World Rabies Day is onSeptember 28th 2017

Take action: you can register your World Rabies Day event, nominate someone for the WRD Awards and find out more here

Don’t forget to tweet us using #worldrabiesday

On Mon, Aug 21, 2017 at 11:12 AM, Kristiyan Panayotov Kristiyan@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:asolano@broadinstitute.org]

Sent: 17 August 2017 14:42

To: Gijsbert OOMS gijsbert.ooms@btcctb.org; Kristiyan Panayotov Kristiyan@logicaloutcomes.net

Cc: Solomon Kununga Solomon@logicaloutcomes.net; dhis2-devs@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.ooms@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 , 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

F +32 (0)2 502 98 62

M +32 (0)477 300 770

WWW.BTCCTB.ORG

Save paper! Think before you print

Van: Kristiyan Panayotov Kristiyan@logicaloutcomes.net

Aan: “dhis2-devs@lists.launchpad.net” <dhis2-devs@lists.launchpad.net >, “dhis2-users@lists.launchpad.net” dhis2-users@lists.launchpad.net

Cc: Solomon Kununga Solomon@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.org@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:

POINT

[36.035858,31.871833]

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@logicaloutcomes.net | Sofia +359 889 318 878 | 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

Knut_Staring · 21 August 2017 09:40

Hi Kristiyan,

This ought to be fixed, but making an Excel file is relatively straightforward with a normal spreadsheet tool like Excel. It is just text when it comes to it. You copy each “XML wrapper” for the coordinates and merge them in one line, then copy the whole thing to a text editor like notepad.

Knut

···

On Mon, Aug 21, 2017 at 11:12 AM, Kristiyan Panayotov Kristiyan@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:asolano@broadinstitute.org]

Sent: 17 August 2017 14:42

To: Gijsbert OOMS gijsbert.ooms@btcctb.org; Kristiyan Panayotov Kristiyan@logicaloutcomes.net

Cc: Solomon Kununga Solomon@logicaloutcomes.net; dhis2-devs@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.ooms@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 , 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”.

GIJSBERT OOMS

EXPERT D4D - Digitalisation for Development

BELGIAN DEVELOPMENT AGENCY

RUE HAUTE 147

1000 BRUSSELS

T +32 (0)2 505 18 44

F +32 (0)2 502 98 62

M +32 (0)477 300 770

WWW.BTCCTB.ORG

Save paper! Think before you print

Van: Kristiyan Panayotov Kristiyan@logicaloutcomes.net

Aan: “dhis2-devs@lists.launchpad.net” <dhis2-devs@lists.launchpad.net >, “dhis2-users@lists.launchpad.net” dhis2-users@lists.launchpad.net

Cc: Solomon Kununga Solomon@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.org@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:

POINT

[36.035858,31.871833]

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@logicaloutcomes.net | Sofia +359 889 318 878 | 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

–

Knut Staring

Dept. of Informatics, University of Oslo

Norway: +4791880522

Skype: knutstar

http://dhis2.org

nghianguyentran · 21 August 2017 09:49

Hi Kristiyan,

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

csvOrgUnit.csv (242 Bytes)

···

On Mon, Aug 21, 2017 at 4:36 PM, Kristiyan Panayotov Kristiyan@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.scott@rabiesalliance.org]

Sent: 21 August 2017 12:17

To: Kristiyan Panayotov Kristiyan@logicaloutcomes.net

Cc: Jesus Solano-Roman asolano@broadinstitute.org; Gijsbert OOMS gijsbert.ooms@btcctb.org; dhis2-users@lists.launchpad.net; Solomon Kununga Solomon@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.scott@rabiesalliance.org

https://paracon.rabiesalliance.org

Skype: tpscott1987

World Rabies Day is onSeptember 28th 2017

Take action: you can register your World Rabies Day event, nominate someone for the WRD Awards and find out more here

Don’t forget to tweet us using #worldrabiesday

On Mon, Aug 21, 2017 at 11:12 AM, Kristiyan Panayotov Kristiyan@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:asolano@broadinstitute.org]

Sent: 17 August 2017 14:42

To: Gijsbert OOMS gijsbert.ooms@btcctb.org; Kristiyan Panayotov Kristiyan@logicaloutcomes.net

Cc: Solomon Kununga Solomon@logicaloutcomes.net; dhis2-devs@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.ooms@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 , 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

F +32 (0)2 502 98 62

M +32 (0)477 300 770

WWW.BTCCTB.ORG

Save paper! Think before you print

Van: Kristiyan Panayotov Kristiyan@logicaloutcomes.net

Aan: “dhis2-devs@lists.launchpad.net” <dhis2-devs@lists.launchpad.net >, “dhis2-users@lists.launchpad.net” dhis2-users@lists.launchpad.net

Cc: Solomon Kununga Solomon@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.org@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:

POINT

[36.035858,31.871833]

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@logicaloutcomes.net | Sofia +359 889 318 878 | 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

–

Name: Nguyễn Trần Nghĩa.
Tel: 0903721500

Jesus_Solano-Roman · 21 August 2017 12:29

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 4:36 PM, Kristiyan Panayotov Kristiyan@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.scott@rabiesalliance.org]

Sent: 21 August 2017 12:17

To: Kristiyan Panayotov Kristiyan@logicaloutcomes.net

Cc: Jesus Solano-Roman asolano@broadinstitute.org; Gijsbert OOMS gijsbert.ooms@btcctb.org; dhis2-users@lists.launchpad.net; Solomon Kununga Solomon@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.scott@rabiesalliance.org

https://paracon.rabiesalliance.org

Skype: tpscott1987

World Rabies Day is onSeptember 28th 2017

Take action: you can register your World Rabies Day event, nominate someone for the WRD Awards and find out more here

Don’t forget to tweet us using #worldrabiesday

On Mon, Aug 21, 2017 at 11:12 AM, Kristiyan Panayotov Kristiyan@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:asolano@broadinstitute.org]

Sent: 17 August 2017 14:42

To: Gijsbert OOMS gijsbert.ooms@btcctb.org; Kristiyan Panayotov Kristiyan@logicaloutcomes.net

Cc: Solomon Kununga Solomon@logicaloutcomes.net; dhis2-devs@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.ooms@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 , 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

F +32 (0)2 502 98 62

M +32 (0)477 300 770

WWW.BTCCTB.ORG

Save paper! Think before you print

Van: Kristiyan Panayotov Kristiyan@logicaloutcomes.net

Aan: “dhis2-devs@lists.launchpad.net” <dhis2-devs@lists.launchpad.net >, “dhis2-users@lists.launchpad.net” dhis2-users@lists.launchpad.net

Cc: Solomon Kununga Solomon@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.org@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:

POINT

[36.035858,31.871833]

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@logicaloutcomes.net | Sofia +359 889 318 878 | 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

–

Name: Nguyễn Trần Nghĩa.
Tel: 0903721500

Kristiyan_Panayotov · 21 August 2017 13:04

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.

···

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 nghianguyentran92@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 Kristiyan@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.scott@rabiesalliance.org]

Sent: 21 August 2017 12:17

To: Kristiyan Panayotov Kristiyan@logicaloutcomes.net

Cc: Jesus Solano-Roman <asolano@broadinstitute.org >; Gijsbert OOMS gijsbert.ooms@btcctb.org; dhis2-users@lists.launchpad.net ; Solomon Kununga Solomon@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.scott@rabiesalliance.org

https://paracon.rabiesalliance.org

Skype: tpscott1987

World Rabies Day is onSeptember 28th 2017

Take action: you can register your World Rabies Day event, nominate someone for the WRD Awards and find out more here

Don’t forget to tweet us using #worldrabiesday

On Mon, Aug 21, 2017 at 11:12 AM, Kristiyan Panayotov Kristiyan@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:asolano@broadinstitute.org]

Sent: 17 August 2017 14:42

To: Gijsbert OOMS <gijsbert.ooms@btcctb.org >; Kristiyan Panayotov Kristiyan@logicaloutcomes.net

Cc: Solomon Kununga Solomon@logicaloutcomes.net; dhis2-devs@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.ooms@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 , 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

F +32 (0)2 502 98 62

M +32 (0)477 300 770

WWW.BTCCTB.ORG

Save paper! Think before you print

Van: Kristiyan Panayotov Kristiyan@logicaloutcomes.net

Aan: "dhis2-devs@lists.launchpad.net " dhis2-devs@lists.launchpad.net, "dhis2-users@lists.launchpad.net " dhis2-users@lists.launchpad.net

Cc: Solomon Kununga Solomon@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.org@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:

POINT

[36.035858,31.871833]

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@logicaloutcomes.net | Sofia +359 889 318 878 | 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

–

Name: Nguyễn Trần Nghĩa.

Tel: 0903721500

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

Jesus_Solano-Roman · 21 August 2017 13:07

Oh I see. Good to know for the future!

Thanks all.

···

On Mon, Aug 21, 2017 at 9:04 AM Kristiyan Panayotov Kristiyan@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:asolano@broadinstitute.org]

Sent: 21 August 2017 15:30

To: Kristiyan Panayotov Kristiyan@logicaloutcomes.net; Nghia Nguyen nghianguyentran92@gmail.com

Cc: Solomon Kununga Solomon@logicaloutcomes.net; dhis2-devs@lists.launchpad.net; dhis2-users@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 nghianguyentran92@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 Kristiyan@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.scott@rabiesalliance.org]

Sent: 21 August 2017 12:17

To: Kristiyan Panayotov Kristiyan@logicaloutcomes.net

Cc: Jesus Solano-Roman <asolano@broadinstitute.org >; Gijsbert OOMS gijsbert.ooms@btcctb.org; dhis2-users@lists.launchpad.net ; Solomon Kununga Solomon@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.scott@rabiesalliance.org

https://paracon.rabiesalliance.org

Skype: tpscott1987

World Rabies Day is onSeptember 28th 2017

Take action: you can register your World Rabies Day event, nominate someone for the WRD Awards and find out more here

Don’t forget to tweet us using #worldrabiesday

On Mon, Aug 21, 2017 at 11:12 AM, Kristiyan Panayotov Kristiyan@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:asolano@broadinstitute.org]

Sent: 17 August 2017 14:42

To: Gijsbert OOMS <gijsbert.ooms@btcctb.org >; Kristiyan Panayotov Kristiyan@logicaloutcomes.net

Cc: Solomon Kununga Solomon@logicaloutcomes.net; dhis2-devs@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.ooms@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 , 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

F +32 (0)2 502 98 62

M +32 (0)477 300 770

WWW.BTCCTB.ORG

Save paper! Think before you print

Van: Kristiyan Panayotov Kristiyan@logicaloutcomes.net

Aan: "dhis2-devs@lists.launchpad.net " dhis2-devs@lists.launchpad.net, "dhis2-users@lists.launchpad.net " dhis2-users@lists.launchpad.net

Cc: Solomon Kununga Solomon@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.org@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:

POINT

[36.035858,31.871833]

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@logicaloutcomes.net | Sofia +359 889 318 878 | 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

–

Name: Nguyễn Trần Nghĩa.

Tel: 0903721500

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