<?xml version="1.0"?>
<rss xmlns:dc="http://purl.org/dc/elements/1.1/" version="2.0">
  <channel>
    <title>CKAN: Ticket #178: Excel package importer</title>
    <link>http://localhost/ticket/178</link>
    <description>&lt;p&gt;
/tool
New 'tools' section of the WUI with 'Excel package import' page.
&lt;/p&gt;
&lt;p&gt;
/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&amp;amp;paste.
&lt;/p&gt;
&lt;p&gt;
/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.
&lt;/p&gt;
&lt;p&gt;
File format:
&lt;/p&gt;
&lt;p&gt;
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:
&lt;/p&gt;
&lt;ul&gt;&lt;li&gt;license - name of license
&lt;/li&gt;&lt;li&gt;tags - space separated
&lt;/li&gt;&lt;li&gt;groups - space separated
&lt;/li&gt;&lt;li&gt;anything - for extra key-values
&lt;/li&gt;&lt;/ul&gt;&lt;p&gt;
When importing, values are bound into the package fieldset, validated and displayed for the preview and synced to complete.
&lt;/p&gt;
&lt;p&gt;
User has to log in to use importer. Auth is checked for putting into groups.
&lt;/p&gt;
</description>
    <language>en-us</language>
    <image>
      <title>CKAN</title>
      <url>http://assets.okfn.org/p/ckan/img/ckan_logo_shortname.png</url>
      <link>http://localhost/ticket/178</link>
    </image>
    <generator>Trac 0.12.3</generator>
    <item>
      
        <dc:creator>dread</dc:creator>

      <pubDate>Thu, 05 Nov 2009 16:42:29 GMT</pubDate>
      <title></title>
      <link>http://localhost/ticket/178#comment:1</link>
      <guid isPermaLink="false">http://localhost/ticket/178#comment:1</guid>
      <description>
        &lt;p&gt;
First batch of changes for this in cset:b5ef888e44b6. Works in basic way.
&lt;/p&gt;
      </description>
      <category>Ticket</category>
    </item><item>
      
        <dc:creator>dread</dc:creator>

      <pubDate>Fri, 06 Nov 2009 16:05:44 GMT</pubDate>
      <title>status, type changed; resolution set</title>
      <link>http://localhost/ticket/178#comment:2</link>
      <guid isPermaLink="false">http://localhost/ticket/178#comment:2</guid>
      <description>
          &lt;ul&gt;
            &lt;li&gt;&lt;strong&gt;status&lt;/strong&gt;
                changed from &lt;em&gt;new&lt;/em&gt; to &lt;em&gt;closed&lt;/em&gt;
            &lt;/li&gt;
            &lt;li&gt;&lt;strong&gt;type&lt;/strong&gt;
                changed from &lt;em&gt;defect&lt;/em&gt; to &lt;em&gt;enhancement&lt;/em&gt;
            &lt;/li&gt;
            &lt;li&gt;&lt;strong&gt;resolution&lt;/strong&gt;
                set to &lt;em&gt;fixed&lt;/em&gt;
            &lt;/li&gt;
          &lt;/ul&gt;
        &lt;p&gt;
Second batch of changes in cset:7d524a92d602.
&lt;/p&gt;
&lt;p&gt;
Status: You can import new packages with all package properties using Excel or CSV format.
&lt;/p&gt;
&lt;p&gt;
Outstanding:
&lt;/p&gt;
&lt;ul&gt;&lt;li&gt;Validation is displayed poorly.
&lt;/li&gt;&lt;li&gt;Overwriting existing packages is warned about, but doesn't work.
&lt;/li&gt;&lt;li&gt;Can't add packages to group yet.
&lt;/li&gt;&lt;li&gt;Functional tests are only working for the basic case.
&lt;/li&gt;&lt;li&gt;Need to centralise package rendering for package controller.
&lt;/li&gt;&lt;/ul&gt;&lt;p&gt;
Time spent:
13hrs
&lt;/p&gt;
      </description>
      <category>Ticket</category>
    </item><item>
      
        <dc:creator>dread</dc:creator>

      <pubDate>Fri, 06 Nov 2009 16:06:36 GMT</pubDate>
      <title></title>
      <link>http://localhost/ticket/178#comment:3</link>
      <guid isPermaLink="false">http://localhost/ticket/178#comment:3</guid>
      <description>
        &lt;p&gt;
Expect 1d to finish outstanding features.
&lt;/p&gt;
      </description>
      <category>Ticket</category>
    </item><item>
      
        <dc:creator>dread</dc:creator>

      <pubDate>Fri, 06 Nov 2009 16:07:48 GMT</pubDate>
      <title></title>
      <link>http://localhost/ticket/178#comment:4</link>
      <guid isPermaLink="false">http://localhost/ticket/178#comment:4</guid>
      <description>
        &lt;p&gt;
Time spent (correction): 20h
&lt;/p&gt;
      </description>
      <category>Ticket</category>
    </item><item>
      
        <dc:creator>rgrp</dc:creator>

      <pubDate>Thu, 04 Feb 2010 17:45:58 GMT</pubDate>
      <title>milestone set</title>
      <link>http://localhost/ticket/178#comment:5</link>
      <guid isPermaLink="false">http://localhost/ticket/178#comment:5</guid>
      <description>
          &lt;ul&gt;
            &lt;li&gt;&lt;strong&gt;milestone&lt;/strong&gt;
                set to &lt;em&gt;v0.11&lt;/em&gt;
            &lt;/li&gt;
          &lt;/ul&gt;
      </description>
      <category>Ticket</category>
    </item>
 </channel>
</rss>