Author Topic: Transferring selected data from one database to another  (Read 3806 times)

0 Members and 1 Guest are viewing this topic.

Offline leogets

  • User
  • ***
  • Posts: 74
    • View Profile
Transferring selected data from one database to another
« 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.
« Last Edit: November 22, 2010, 09:39:09 pm by rick.ca »

Offline rick.ca

  • Global Moderator
  • *****
  • Posts: 3241
  • "I'm willing to shoot you!"
    • View Profile
Re: any way to import just Seen and Not Seen Remarks made from a backup
« Reply #1 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.

 

anything