ACTION-97 (was: ACTION-89)

Note: this also completes - in essence - a proposed process for ACTION-97 "Define a process to get from spreadsheets to spec."

My proposed simple process for now is:

1. Fill all the fields in the spreadsheets following the template and column order from the "BaseOntology" tab.
2. Run: 
	python dpvcg-extract.py 'BaseOntology' > BaseOntology.html
	python dpvcg-extract.py 'TechnicalOrganisationalMeasure' > TechnicalOrganisationalMeasure.html
	python dpvcg-extract.py 'PersonalDataCategory' > PersonalDataCategory.html
	python dpvcg-extract.py 'Processing' > Processing.html
	python dpvcg-extract.py 'Purpose' > Purpose.html
	python dpvcg-extract.py 'RecipientsDataControllersDataSubjects' > RecipientsDataControllersDataSubjects.html
	python dpvcg-extract.py 'LegalBasis' > LegalBasis.html
	python dpvcg-extract.py 'Consent' > Consent.html

	(note that for now this really only works well for the base ontology, you need to cleanly fix your spreadsheets to follow the example in order to produce reasonable outputs...)

3. In the raw document, at
        https://docs.google.com/document/d/1Z3Eb5rZjrdWcE5u5o0CYzA_LPyGaTqmg84ecGve_ZLA/
    I have for the moment added placeholders, where the respective HTML should be added, just putting lines such as
	#import  BaseOntology.html

    into the gdoc (Please do not remove these'#import' lines for now!)

4. replacing these imports and importing the html files generated in step 2 can be done with a combination of tidy and some other scripts, but the result isn't yet very clean, so I would like to put this process up for discussion... for the moment, I attach a manual import where I replaced BasOntology.html.

For the moment, though, I think this is good enough to work for everybody, if you:
 * complete the explanations of the terms in the spreadsheet
 * add explaining text in the gdoc.

best regards,
Axel

--
Prof. Dr. Axel Polleres
Institute for Information Business, WU Vienna
url: http://www.polleres.net/  twitter: @AxelPolleres

> On 22.04.2019, at 14:21, Axel Polleres <axel.polleres@wu.ac.at> wrote:
> 
> Hi all,
> 
> As per ACTION-89 I did a pass over the BaseOntology on 
> https://docs.google.com/spreadsheets/d/13d1eRXZZBCw84vYGoCJeMU08rzkkzadDzxY3n2iOi8k/edit#gid=0
> 
> Additionally, I wrote a python script that extracts html out of the google spewadsheet, which can serve as a basis for the spec.
> Attached the script (dpvcg-extract.py) and the html it generated (BaseOntology.html).
> 
> If you want to run/use this, you need to enable the spreadsheets API in google spreasheets
> and install google-api-python-client, cf.  [1]
> 
> 
> <BaseOntology.html><dpvcg-extract.py>
> 
> 1. https://developers.google.com/sheets/api/quickstart/python
> 
> 
> --
> Prof. Dr. Axel Polleres
> Institute for Information Business, WU Vienna
> url: http://www.polleres.net/  twitter: @AxelPolleres
>