Create a spreadsheet template for all of IATI

[Bjwebb]

In an ideal world this should be part of flatten-tool's create-template command, but we're going to start off with a separate script for first iteration.

[Bjwebb]

On a branch we can now run this command python cove_iati/lib/iati_utils.py generate_template.

This doesn't generate a spreadsheet yet, but rather just a list of possible headings on the commandline: https://gist.github.com/Bjwebb/4f3ca03c0699212160045672f3e64345

However, I think for IATI we're talking about hand curating spreadsheets, rather than full auto generating them. So maybe this list of possible headings fulfils our need of something to copy/paste from. @stevieflow what do you think?

[stevieflow]

Thanks @Bjwebb

I can certainly curate some templates from this - any chance to output the list into columns?!

I guess this does also relate to the /0/ issue (is there an issue for that) - but cant now recall if we planned to address that initially?

[Bjwebb]

@stevieflow is this what you want? https://gist.github.com/Bjwebb/4f3ca03c0699212160045672f3e64345#file-1_spreadsheet-csv

/0/ issue is OpenDataServices/flatten-tool#147. My hope is in the short term we'll avoid the problem by you copy/pasting these generated headings, which will work correctly (either on the activities sheets or separate ones).

[stevieflow]

@Bjwebb re: https://gist.github.com/Bjwebb/4f3ca03c0699212160045672f3e64345#file-1_spreadsheet-csv thanks

[Bjwebb]

I've updated the gist to have multilingual support - https://gist.github.com/Bjwebb/4f3ca03c0699212160045672f3e64345

[robredpath]

@Bjwebb this is done, right? Can this be closed?

[Bjwebb]

The code for this is on an unmerged branch, and the GitHub gist with the template is only linked from this issues. Possibly something for #814

[Bjwebb]

Here's some new gists for 2.03:

Single lang: https://gist.github.com/bc4ee70fd771b4605138d0bf84fcecd8
Multi lang: https://gist.github.com/c7bc54bd7d22c64d1dbcd1c19262aff2

[stevieflow]

Excellent, thanks @Bjwebb / cc/ @rory09

[Bjwebb]

Re-opening this as it represents unmerged work.