Personal Video Database

English => Support => Topic started by: leogets on April 24, 2010, 06:08:41 pm

Title: Transferring selected data from one database to another
Post by: leogets on April 24, 2010, 06:08:41 pm

If I have a newer database of movies. Is there any way to extract and apply the Seen and Not Seen state for movies in an older database to the newer database of movies? If a movie cannot be found in the older database, can it be marked automatically in the newer database as Not Seen?

Thanks for any help.

Title: Re: any way to import just Seen and Not Seen Remarks made from a backup
Post by: rick.ca on April 24, 2010, 06:46:03 pm

Export a list of movies from both databases (Title, Year and URL—to ensure proper matching—plus Viewed and ViewDate) to Excel. Set Viewed/ViewDate in the new list to that in the old, and if there's no match, set them off/null (the date is optional—I'm assuming you might want it too). Re-import the revised list to update the new database.

I've skipped the details of how to import, export and lookup values in Excel. If you're interested in doing this, search for other posts on those topics, and ask whatever specific questions you may have.