Zotero Import Plugin

[Jim Safley]

The alpha version of the Zotero Import plugin is ready for testing.
Just give it the feed URL of a Zotero user or group library and it
turns all the Zotero items into Omeka items, mapping their metadata
(including notes) to Dublin Core and to the new, comprehensive Zotero
element set. If you provide a private key, the plugin will also import
private libraries and attached files (including web snapshots). Check
it out and tell us what you think:

https://addons.omeka.org/svn/plugins/ZoteroImport/tags/1.2-1.0alpha/

Best,
Jim

[Patrick Murray-John]

Jim,

Alas, I got this:

*Fatal error*: Uncaught exception 'Zend_Db_Statement_Mysqli_Exception'
with message 'Mysqli prepare error: Unknown column 'p.started' in 'field
list'' in
/var/www/html/workspace/omeka/application/libraries/Zend/Db/Statement/Mysqli.php:84
Stack trace: #0
/var/www/html/workspace/omeka/application/libraries/Zend/Db/Statement.php(110):
Zend_Db_Statement_Mysqli->_prepare('SELECT `z`.*, `...') #1
/var/www/html/workspace/omeka/application/libraries/Zend/Db/Adapter/Mysqli.php(381):
Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), 'SELECT
`z`.*, `...') #2
/var/www/html/workspace/omeka/application/libraries/Zend/Db/Adapter/Abstract.php(467):
Zend_Db_Adapter_Mysqli->prepare('SELECT `z`.*, `...') #3 [internal
function]: Zend_Db_Adapter_Abstract->query(Object(Omeka_Db_Select),
Array) #4
/var/www/html/workspace/omeka/application/libraries/Omeka/Db.php(70):
call_user_func_array(Array, Array) #5 [internal function]:
Omeka_Db->__call('query', Array) #6
/var/www/html/workspace/omeka/application/libraries/Omeka/Db/Table.php(401)
in
*/var/www/html/workspace/omeka/application/libraries/Zend/Db/Statement/Mysqli.php*
on line *84*

Just a guess, but maybe it's due to this in ZoteroImportImportTable ?

$select->join(array('c' => $db->Collection), 'c.id =
z.collection_id', array('name'))
->join(array('p' => $db->Process), 'p.id = z.process_id',
array('pid', 'status', 'started', 'stopped'));

Patrick

[Jim Safley]

Thanks for reminding me, Patrick. This plugin will only work with
Omeka 1.2. I suspect that you're using an earlier version, which does
not have the processes.started column. Let me know if this is not the
case.

Jim

[Patrick Murray-John]

Jim,

That's exactly right -- I was testing on Omeka 1.1.

So if I can ask, since I'm working on the FeedImporter plugin, and have
been working off of Omeka 1.1, does the change mean I should keep new
things in mind?

I'm not doing anything that looks directly at the processes table, so
I'm thinking that whenever I start off a background process, Omeka of
whatever version (1.1 or 1.2) will know what to do. But if there's
anything I should keep in mind that's non-obvious, that'd be great to know.

I'll take some time tomorrow and dig around into what looks different in
that table. (I have a 1.1 and a 1.2 instance going on)

Happily, it sounds at first glance (if you'll excuse the synesthesia)
that it might make some view info I'd hoped for easier to dig up and
present! Yay!

Thanks!
Patrick

[Jim Safley]

All plugins developed for 1.1 should work for 1.2, as we try very hard
to maintain backwards compatibility. As you see, we added a "stopped"
status and the started and stopped timestamps to the processes table.
We also added logging capability to the process. You can log a
message/error by sending it through ProcessAbstract::_log(). This
appends the message to a new log file, application/logs/processes.log.

Jim

On Mon, Apr 12, 2010 at 8:09 PM, Patrick Murray-John <pgos...@umw.edu> wrote:
> Jim,
>

[Patrick Murray-John]

Jim,

Sounds good...fabulous, akshully!

I'll try to get my code up to speed.

Patrick