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?
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
···
Brian O’Donnell, MPAff
Health Informatics Officer | Global Health Corps Fellow bodonnell@akros.com | (+26) 097 6187 316
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.
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?
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
Brian O’Donnell, MPAff
Health Informatics Officer | Global Health Corps Fellow bodonnell@akros.com | (+26) 097 6187 316