http://localhost/ticket/270 <p> There is code to create packages by in-process (ckan/lib/importer) and via HTTP (ckanclient/loaders/base). There is also code to read different kinds of package source (Google Spreadsheets spreadsheet, other spreadsheet). </p> <p> Propose to refactor all this to have template method in base command class (subclasses may implement command line interface, graphical user interface, or Web interface), where the template method calls on aggregated strategy objects for: reading raw spreadsheet data from spreadsheet application; for inferring CKAN package entities from the raw spreadsheet data; and for writing package entities to CKAN service. </p> <p> Spreadsheet readers to be factored to allow for variations of spreadsheet application. </p> <p> Raw data inferrers to allow for variations in spreadsheet cell structure. </p> <p> CKAN writer strategies to allow for either CKAN client or direct linking. </p> <p> Actual cases then supported by specifying existing strategies (or defining new ones) in a script that invokes the command class. </p> en-us http://assets.okfn.org/p/ckan/img/ckan_logo_shortname.png http://localhost/ticket/270 Trac 0.12.3 johnbywater Mon, 15 Mar 2010 16:51:18 GMT http://localhost/ticket/270#comment:1 http://localhost/ticket/270#comment:1 <ul> <li><strong>description</strong> modified (<a href="/ticket/270?action=diff&amp;version=1">diff</a>) </li> </ul> Ticket johnbywater Mon, 15 Mar 2010 16:51:42 GMT http://localhost/ticket/270#comment:2 http://localhost/ticket/270#comment:2 <ul> <li><strong>description</strong> modified (<a href="/ticket/270?action=diff&amp;version=2">diff</a>) </li> </ul> Ticket dread <d.t.read@…> Wed, 24 Nov 2010 11:04:00 GMT http://localhost/ticket/270#comment:3 http://localhost/ticket/270#comment:3 <ul> <li><strong>status</strong> changed from <em>new</em> to <em>closed</em> </li> <li><strong>resolution</strong> set to <em>fixed</em> </li> </ul> <p> Nearly everything mentioned here has been achieved with the <a class="missing wiki">SpreadsheetData?</a>, <a class="missing wiki">DataRecords?</a>&lt;-<a class="missing wiki">SpreadsheetDataRecords?</a>, <a class="missing wiki">PackageImporter?</a>&lt;-<a class="missing wiki">SpreadsheetPackageImporter?</a> design. New imports can take advantage of this. </p> Ticket