Welcome to the Invelos forums. Please read the forum rules before posting.

Read access to our public forums is open to everyone. To post messages, a free registration is required.

If you have an Invelos account, sign in to post.

    Invelos Forums->DVD Profiler: Desktop Technical Support Page: 1  Previous   Next
Birth Year Clean up
Author Message
DVD Profiler Desktop and Mobile RegistrantStar ContributorGadgeteer
Registered: March 13, 2007
United Kingdom Posts: 519
Posted:
PM this userEmail this userView this user's DVD collectionDirect link to this postReply with quote
Other than manually scrolling through the list, is there any way to search for cast or crew that have a YoB.

I've still got a load from when I imported the headshot database and I wanted to do a clean up.
Stuart
DVD Profiler Unlimited RegistrantStar Contributornorthbloke
Registered: March 15, 2007
Reputation: High Rating
United Kingdom Posts: 5,459
Posted:
PM this userDirect link to this postReply with quote
I don't know if this will work or not, as I'm at work so can't try it, but would it be possible to create a report that displays title, actor, by. Then you could run the report and just quicky scan through the pages to see them?
DVD Profiler Unlimited RegistrantStar Contributorhayley taylor
Past Contributor
Registered: March 14, 2007
Reputation: High Rating
United Kingdom Posts: 1,022
Posted:
PM this userVisit this user's homepageDirect link to this postReply with quote
I never found a better way Stuart, and had to manually scroll through the lists as well 
DVD Profiler Desktop and Mobile RegistrantStar ContributorGadgeteer
Registered: March 13, 2007
United Kingdom Posts: 519
Posted:
PM this userEmail this userView this user's DVD collectionDirect link to this postReply with quote
Quoting richierich:
Quote:
I never found a better way Stuart, and had to manually scroll through the lists as well 


That's what I was dreading 

I wonder if there's a way that Goodguy's Name-Variants plug-in could be employed.
Stuart
 Last edited: by Gadgeteer
DVD Profiler Desktop and Mobile RegistrantStar ContributorGadgeteer
Registered: March 13, 2007
United Kingdom Posts: 519
Posted:
PM this userEmail this userView this user's DVD collectionDirect link to this postReply with quote
I've discovered a much easier way to find them.

Just export to a xml file (select cast and crew only)
Then open in Excel (I selected to open as read-only excel sheet) and sort the columns by birth year column.

This works in Excel 2007, I can't vouch for older versions

Edit: I re-opened, this time as An XML Table and it's much easier to sort and filter. 
Stuart
 Last edited: by Gadgeteer
DVD Profiler Unlimited RegistrantStar ContributorTomGaines
Registered Sept. 24, 2001
Registered: March 13, 2007
Reputation: High Rating
Germany Posts: 2,005
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
I made my cleanup using my CCViewer as a reference.
The SQL statement I used I made available online ("List CastCrew with BirthYear")


DVD Profiler Unlimited RegistrantStar Contributorsnarbo
Registered: March 13, 2007
United Kingdom Posts: 1,242
Posted:
PM this userDirect link to this postReply with quote
Quoting Gadgeteer:
Quote:
I've discovered a much easier way to find them.

Just export to a xml file (select cast and crew only)
Then open in Excel (I selected to open as read-only excel sheet) and sort the columns by birth year column.

This works in Excel 2007, I can't vouch for older versions

Edit: I re-opened, this time as An XML Table and it's much easier to sort and filter. 



I can confirm this also works with Excel 2003.

Steve
    Invelos Forums->DVD Profiler: Desktop Technical Support Page: 1  Previous   Next