Ticket #178 (closed enhancement: fixed)
Excel package importer
| Reported by: | dread | Owned by: | rgrp |
|---|---|---|---|
| Priority: | critical | Milestone: | v0.11 |
| Component: | ckan | Keywords: | |
| Cc: | Repository: | ||
| Theme: |
Description
/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: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.
Outstanding:
- 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
First batch of changes for this in cset:b5ef888e44b6. Works in basic way.