Ticket #178 (closed enhancement: fixed)

Opened 4 years ago

Last modified 4 years ago

Excel package importer

Reported by: dread Owned by: rgrp
Priority: critical Milestone: v0.11
Component: ckan Keywords:
Cc: Repository:


/tool New 'tools' section of the WUI with 'Excel package import' page.

/tool/import Import page allows you to upload a file. The format of the required Excel file is described here. List of licenses provided for copy&paste.

/tool/import/preview When you upload it, it gives you a simple preview of the file, offering import. Text as per Package Preview. 'import button' for completing process.

File format:

First row to have a cell value of 'name' or 'title' in it is the Title Row. It contains the field names, as per package. It includes:

  • license - name of license
  • tags - space separated
  • groups - space separated
  • anything - for extra key-values

When importing, values are bound into the package fieldset, validated and displayed for the preview and synced to complete.

User has to log in to use importer. Auth is checked for putting into groups.

Change History

comment:1 Changed 4 years ago by dread

First batch of changes for this in cset:b5ef888e44b6. Works in basic way.

comment:2 Changed 4 years ago by dread

  • Status changed from new to closed
  • Type changed from defect to enhancement
  • Resolution set to fixed

Second batch of changes in cset:7d524a92d602.

Status: You can import new packages with all package properties using Excel or CSV format.


  • Validation is displayed poorly.
  • Overwriting existing packages is warned about, but doesn't work.
  • Can't add packages to group yet.
  • Functional tests are only working for the basic case.
  • Need to centralise package rendering for package controller.

Time spent: 13hrs

comment:3 Changed 4 years ago by dread

Expect 1d to finish outstanding features.

comment:4 Changed 4 years ago by dread

Time spent (correction): 20h

comment:5 Changed 4 years ago by rgrp

  • Milestone set to v0.11
Note: See TracTickets for help on using tickets.