Automatic Report Generation from CKAN Contents

[p-a-s-c-a-l]

Export datasets from CKAN on the command line with ckanapi and use carbone.io to generate documents out of Data Package JSON.

Example: Dump Resource Summer days (SD) as Data Package:

ckanapi dump datasets "summer-days-sd" -r https://ckan.myclimateservice.eu/ \
--datapackages=./dump_directory/

See also clarity-h2020/ckan#16

Related Tasks:

• Create Dataset Template
• Create ckanapi export statements
• Support For Markdown

[p-a-s-c-a-l]

Hello “{d.firstname} {d.lastname}”!

[p-a-s-c-a-l]

Hello {d.firstname} {d.lastname} !

[p-a-s-c-a-l]

Hm, #1 (comment) probably caused by bookmark xml tags. 🙄

[p-a-s-c-a-l]

{d.firstname}

<w:r w:rsidRPr="002E7781">
	<w:rPr>
		<w:rFonts w:asciiTheme="minorHAnsi" w:hAnsiTheme="minorHAnsi"/>
		<w:sz w:val="22"/>
	</w:rPr>
	<w:t>d.firstname</w:t>
</w:r>

-> carbone

[p-a-s-c-a-l]

Array Manipulation does not work:

{d.tags:arrayMap("; ",|,name)}

CLARITY";"Climate Indicators";"EURO-CORDEX";"WP3";"open-data";"output-data

[p-a-s-c-a-l]

{d.tags:arrayMap(; ,|,name)}

CLARITY;Climate Indicators;EURO-CORDEX;WP3;open-data;output-data

It seems that no quotes nor commas are supported in (ODT) templates. 😞

[p-a-s-c-a-l]

"tags": [{
            "display_name": "CLARITY",
            "id": "fdb805ad-2f49-4cf5-b498-01a7d7afdd14",
            "name": "CLARITY",
            "state": "active",
            "vocabulary_id": null
        }, { ...

None of these works:

{d.tags:arrayMap(“, “ ,| ,display_name)}
{d.tags:arrayMap(`, ` ,| ,display_name)}
{d.tags:arrayMap(", " ,| ,display_name)}

“CLARITY““Climate Indicators““EURO-CORDEX““WP3““open-data““output-data
`CLARITYClimate IndicatorsEURO-CORDEX``WP3``open-data``output-data
"CLARITY""Climate Indicators""EURO-CORDEX""WP3""open-data""output-data

[p-a-s-c-a-l]

As workaround use {d.tags:arrayMap(;,|,display_name)}:

CLARITY;Climate Indicators;EURO-CORDEX;WP3;open-data;output-data

[p-a-s-c-a-l]

It seems that there are more general problems with quotes and spaces: carboneio/carbone#59 (comment)

    • {d.test:ifEmpty(“some other sentence”)}
    • {d.test:ifEmpty(very strange)}
    • {d.test:ifEmpty(very, strange )}
    • {d.test:ifEmpty( very, strange )}
    • {d.test:ifEmpty(very; strange)}
    • {d.test:ifEmpty(\n  1    2   3)}
    • {d.test:ifEmpty(;       123 4)}
    • {d.test:ifEmpty(;   \n    123 4 X)}

[p-a-s-c-a-l]

ENV VAR substitution does not work:

CLARTIY H2020 Data Management Plan v${GITHUB_REF} generated by ${GITHUB_ACTOR} from CLARITY CKAN Build #${GITHUB_RUN_NUMBER} triggered by ${GITHUB_SHA}

That's the the typical variables mess in YAML: ${{ github.ref }} vs ${GITHUB_REF} : github-context vs env-context. WTF?

Now, how to get the output on an ENV var?

• ${{ ENV_VAR }}
• ${ENV_VAR}
• $ENV_VAR
• ${{ env.VAR }}
• ???

[p-a-s-c-a-l]

According to using environment variables we can use e.g. $GITHUB_REF . But in reality this leads to:

Your workflow file was invalid: The workflow is not valid. .github/workflows/release.yml (Line: 71, Col: 15): Unrecognized named-value: 'GITHUB_REF'. Located at position 1 within expression: GITHUB_REF

[p-a-s-c-a-l]

done