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
Recommendations for removing child profiles from my database
Author Message
DVD Profiler Unlimited Registranttjenkins99
Registered: February 9, 2008
Posts: 113
Posted:
PM this userVisit this user's homepageDirect link to this postReply with quote
I have a lot of TV Series in my collection and have no need for the "child" profiles. Instead of manually deleting them one by one, does anyone have any suggestions how this could be done in a global manner - or maybe using one of the plugins?

Thanks.
DVD Profiler Desktop and Mobile RegistrantStar ContributorDJ Doena
Registered: May 1, 2002
Registered: March 14, 2007
Reputation: Highest Rating
Germany Posts: 6,747
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Use the space bar to flag all the child profiles.

Then select Collection -> Flagged -> Remove
Karsten
DVD Collectors Online

DVD Profiler Unlimited RegistrantStar ContributorMithi
Sushi Annihilator
Registered: March 13, 2007
Reputation: Superior Rating
Germany Posts: 2,217
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Quoting tjenkins99:
Quote:
I have a lot of TV Series in my collection and have no need for the "child" profiles. Instead of manually deleting them one by one, does anyone have any suggestions how this could be done in a global manner - or maybe using one of the plugins?

Unless you have some distinguishing characteristic to them, I don't see a way.

For me it would be quite easy because all those children are counted "0" and have no Collection number. So filtering on Genre 'Television' an Collection-Number 'None' would be a good start.

You could un-nest[1] your child-profiles, filter for television and then sort by running-time, that should make the flagging with space-bar a lot easier.

cya, Mithi

[1] Un-check "Collection -> Nest Box Sets". If you don't have this options see this posting

PS Whatever you do, make a full backup first, in case you delete more than you wanted!
Mithi's little XSLT tinkering - the power of XML --- DVD-Profiler Mini-Wiki
DVD Profiler Unlimited RegistrantStar ContributorMithi
Sushi Annihilator
Registered: March 13, 2007
Reputation: Superior Rating
Germany Posts: 2,217
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Played around with Database Query, that should do the trick.


Just filter (the funnel-icon) out only the Child Profiles and after that go to 'General Information', search for all the titles that have genre 'Television', 'Run Query' and 'Safe Flag Set'.
Now simply load this flag set in DVD Profiler, give it a thorough check to see if any movies in box sets where were also marked and afterwards delete the flagged.

ACHTUNG: Should you have Complete TV-Series that are structured "Set - Season- Disc" the seasons will be also marked, so be sure to unflag them if you choose to keep them.
Mithi's little XSLT tinkering - the power of XML --- DVD-Profiler Mini-Wiki
 Last edited: by Mithi
DVD Profiler Unlimited Registranttjenkins99
Registered: February 9, 2008
Posts: 113
Posted:
PM this userVisit this user's homepageDirect link to this postReply with quote
Thanks for all the suggestions. I am going to try the Database Query method. I will let you know how it goes.
DVD Profiler Unlimited Registranttjenkins99
Registered: February 9, 2008
Posts: 113
Posted:
PM this userVisit this user's homepageDirect link to this postReply with quote
I used the Database Query exactly as you had suggested and I reduced my collection from 2069 to 1310. This value more accurately represents the actual number of movies and tv shows in my collection. Thanks again for your advice.
DVD Profiler Unlimited RegistrantStar ContributorKulju
Registered: March 14, 2007
Finland Posts: 2,337
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Quoting tjenkins99:
Quote:
I used the Database Query exactly as you had suggested and I reduced my collection from 2069 to 1310. This value more accurately represents the actual number of movies and tv shows in my collection. Thanks again for your advice.

If that was your goal why didn't you just set the count as value to 0?
DVD Profiler Unlimited Registranttjenkins99
Registered: February 9, 2008
Posts: 113
Posted:
PM this userVisit this user's homepageDirect link to this postReply with quote
Setting the count value to zero doesn't remove the extraneous entries from my database. I have no need for the information provided in the children profiles - I can obtain all the info I need from the "parent" record. Plus the removal reduces the file sizes of my overall database.
DVD Profiler Unlimited RegistrantOzzie
Registered: August 31, 2007
Posts: 95
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
That worked
Ozzie's Home Theater
    Invelos Forums->DVD Profiler: Desktop Technical Support Page: 1  Previous   Next