search

INDIGO-Initiative / database-app

MIT License
2 stars 1 forks source link

Can we include name of location and country code in the pipeline list? #150

Open Juliana211 opened 2 years ago

Juliana211 commented 2 years ago

Hi! I was wondering if we could include two more columns in our pipeline csv general file. I would include the variable "Location" and "Country code", as we did for our Impact Bond Dataset. Thanks!

odscjames commented 2 years ago

This is /app/pipeline and click "Download List" - /app/pipeline_download

I think the Project one only includes the Country Code column , not "Location" - am I missing something here?

Asking to clarify exactly which columns to add to the the pipeline one.

Juliana211 commented 2 years ago

In the pipeline spreadsheet, delivery locations tab, we have a variable called 'Name' and another one called 'Country', where we have the country codes. I'd like to add both columns to the file that we download when we click on "Download List" - /app/pipeline_download.

I know the Impact Bond Dataset spreadsheet has only the Country column. This is because all impact bond projects have at least one country code. Some pipeline projects don't have country codes, because they only know that they want to work in 'Sub-Saharan Africa', for instance. That is why I think that both columns will be useful in this case.

odscjames commented 2 years ago

Confirmed in call: if there are 2 delivery locations:

They will both be comma separated in different cells:

Name Country
London, Washington GB, US