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).