Post reply

Warning: this topic has not been posted in for at least 120 days.
Unless you're sure you want to reply, please consider starting a new topic.

Note: this post will not display until it's been approved by a moderator.

Name:
Email:
Subject:
Message icon:
Attach:
(Clear Attachment)
(more attachments)
Allowed file types: gif, jpg, png, txt, tpl, lng, ini, pvd, psf, ini, cfg, csv, zip, xml, pas, 7z
Restrictions: 4 per post, maximum total size 1024KB, maximum individual size 1024KB
Note that any files attached will not be displayed until approved by a moderator.
Verification:
Type the letters shown in the picture
Listen to the letters / Request another image

Type the letters shown in the picture:
How many words are in this question?:

shortcuts: hit alt+s to submit/post or alt+p to preview


Topic Summary

Posted 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.
Posted 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.
anything