Re: [VuFind-Tech] importing user favorites and lsits

[Demian K. <dem...@vi...>]

I'm not aware of anyone having done this before, but it shouldn't be too difficult to achieve.

You'll need to make sure all of your users are populated in the user table first.

Then you can create the lists in the user_list table.

You need to make sure that all of the record IDs are represented in the resource table (you can leave title/author/year blank and use VuFind's upgrade script to populate them later; source should be set to 'VuFind').

Then you create the lists by linking the id from the user_list table with the user's ID and the id from the resource table in the user_resource table.

Probably not a hideously difficult task.... let me know if you run into any complications or still have questions about the table structure.

- Demian

From: David Bietila [mailto:dbi...@uc...]
Sent: Monday, April 14, 2014 3:11 PM
To: vuf...@li...
Subject: [VuFind-Tech] importing user favorites and lsits

Hello,

We are currently approaching our launch of VuFind, and will be retiring our previous catalogs. We are interested in identifying a means of migrating user Favorites and Lists from our previous catalogs.

Assuming that we can export the user saved records and lists from the previous catalogs, has anyone developed a means of importing this data into VuFind? Is there documentation detailing the table and field names where this information would reside under VuFind?

I believe that we will be able to export our data in the form of:



PatronID

                ListName (repeatable)

                                RecordID (repeatable)



I expect that the patron and record IDs will be stable across our systems.



Thanks,

David

David Bietila
Web Program Director
Digital Library Development Center
The University of Chicago Library
773-702-0201