This script uses PHPExcel to generate a spreadsheet that can then be completed by publishers before uploading into the ckanext-dgu inventory tool.
By providing the name of a publisher, a secondary sheet will be added with a flat list of all sub departments, and this used as validation on the 'Owner' column.
You may require the PHP postgres driver, you can install this on ubuntu with:
sudo apt-get install php5-pgsql
Your apache config should (in the appropriate site config file) contain something like:
Alias /inventory/template /var/www/inventory-template
<Directory /var/www/inventory-template>
FileETag MTime Size
Options FollowSymLinks MultiViews
AllowOverride All
Order allow,deny
allow from all
SetEnv CKAN_CONFIG_FILE /path_to_ckan.ini
</Directory>
Installation requires that the apache configuration use SetEnv to specify the CKAN_CONFIG_FILE environment variable to point to a CKAN .ini file which contains the database settings.
The file generated by this tool has 4 columns, 'Title', 'Description', 'Owner' and 'Date to be published'. The first three columns are required and the publish date is entirely optional (as it may not apply to some items).