Importing Org Units with custom attributes via CSV

Hi all,

Im updating some village coordinates via CSV. To keep a record of this update, Ive created a new OU attribute for “geo source”. This attribute is an option set of values.

Where do I place this new attribute in the CSV file for upload?

I have been following the column order outlined here: http://dhis2.github.io/dhis2-docs/2.22/en/developer/html/dhis2_developer_manual_full.html#d4967e995

Of course, the import ignores the top row, so when I add the name or code of the “source” attribute to the right of “coordinates”, it does not update.

Theres likely a way to do this via API, but Im trying to create an excel template so non-technical people can regularly check village coordinates against an updated list, and directly upload a CSV themselves. If its not possible, I’ll just overwrite the existing “comment” or “description” fields with “geo source” values.

for reference Im using version 2.21

Thanks all,

Brian

···

Akros
Brian O’Donnell, MPAff
Health Informatics Officer | Global Health Corps Fellow
bodonnell@akros.com | (+26) 097 6187 316

Hi Brian,

Unfortunately we do not support custom attributes as part of the CSV metadata import.

This will be a useful feature so it’s something we could consider. It will require a change in the way we deal with CSV - currently we do not parse the column headers and rely on the column order (in fact there is no official CSV spec and so headers are not mandatory).

I have written a blueprint here. We cannot guarantee a version for delivery at this point though.

https://blueprints.launchpad.net/dhis2/+spec/csv-custom-metadata-attributes

Custom attributes are supported for JSON and XML so you could write some sort of script/tool that transforms it into those formats as a work-around.

best regards,

Lars

···

On Thu, Jun 9, 2016 at 4:17 PM, Brian O’Donnell bodonnell@akros.com wrote:

Hi all,

Im updating some village coordinates via CSV. To keep a record of this update, Ive created a new OU attribute for “geo source”. This attribute is an option set of values.

Where do I place this new attribute in the CSV file for upload?

I have been following the column order outlined here: http://dhis2.github.io/dhis2-docs/2.22/en/developer/html/dhis2_developer_manual_full.html#d4967e995

Of course, the import ignores the top row, so when I add the name or code of the “source” attribute to the right of “coordinates”, it does not update.

Theres likely a way to do this via API, but Im trying to create an excel template so non-technical people can regularly check village coordinates against an updated list, and directly upload a CSV themselves. If its not possible, I’ll just overwrite the existing “comment” or “description” fields with “geo source” values.

for reference Im using version 2.21

Thanks all,

Brian

Akros
Brian O’Donnell, MPAff
Health Informatics Officer | Global Health Corps Fellow
bodonnell@akros.com | (+26) 097 6187 316


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

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

lars@dhis2.org

http://www.dhis2.org