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
Flag All Child Profiles?
Author Message
DVD Profiler Unlimited Registrantseanbob
Registered: June 13, 2007
United States Posts: 24
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Is there any way to Flag All Child Profiles or Flag All Parent Profiles in DVD Profiler? I'd like to save myself the time of flagging each one individually, if possible.

Thanks!
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 seanbob:
Quote:
Is there any way to Flag All Child Profiles or Flag All Parent Profiles in DVD Profiler?

In DVD Profiler, unfortunately not.

But there is a relatively easy way utilizing the XML-Export:
- under File -> Export Profile Database make a single-file export and place on the desktop (or any other place you are comfortable with)
- save this file as "child.xsl" to the same directory

Now you can either follow the instruction found in my signature and download and use Saxon-HE, or if this is a one-time-job:
- open the collection in an editor (e.g. WordPad)
- add <?xml-stylesheet type="text/xsl" href="child.xsl"?> at the second line and save it. (let the editor open, you will need it soon)
- open your webbrowser and via File - Open open the collection.xml. You should now see a list of numbers.
- press Ctrl&A to mark everything, right-click and choose Copy
- switch to your editor, open a new document and right-click Paste

Scrap this, just download http://doena-soft.de/dvdprofiler/3.6.0/XsltTransform.zip and extract the 2 included files anywhere you want (no installation needed) and run it, the GUI is pretty much self-explaining.

- save it as e.g. child.lst to C:\Users\$your_username\Documents\DVD Profiler\Flags
- in DVD Profiler go to Collection -> Flags -> Load Set and et voila all childs are marked.

The XSL also contains the code for finding Parents, just commented out with <!--  -->, but be aware that this doesn't work so well if you, like me, don't have child-profiles for all Box-Sets.

cya, Mithi
Mithi's little XSLT tinkering - the power of XML --- DVD-Profiler Mini-Wiki
 Last edited: by Mithi
DVD Profiler Unlimited RegistrantMuckl
That's my common name.
Registered: April 9, 2009
Reputation: Great Rating
Germany Posts: 858
Posted:
PM this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
I prefer using tags for that. That way I can filter the desired profiles anytime. Because the downside of Mithi's method is that a flag set is static, so it has to be updated everytime you download new box set profiles.

You can use Mithi's suggestion for creating an initial flag set, though. Follow the instructions above, then add a tag for child profiles via "Tools" --> "Edit Tags..." and now set all tags at once by choosing "Collection" --> "Flagged" --> "Set Tags...". And everytime you add a new box set you just have to check the appropiate tags for the children.



An alternative to the XML/XSLT stuff for creating such an initial flag set is Mark's great Database Query plugin. Install it, run it via "Tools" --> "Database Query" and click "Begin" (AFAIK you have to check "Load cast/crew data ..." the first time you run the plugin, afterwards only if you want to perform queries on cast/crew data).

The first step to create a flag set is to choose the little filter icon in the top toolbar and make your choices. E.g. if you want to filter for all child profiles in your entire database, deselect "Standard profiles" and "Box set profiles" (the checkboxes have to be white), tick "And" after "Selection" and finally click "OK".
Second step is to perform a query. I couldn't find a way to simply list all profiles, but a workaround is to search for a genre that isn't attached to a single profile in your collection. Create a dummy genre ("Tools" --> "Edit Custom Genres..."), then go to the Database Query window, choose "General Information", now choose "Genres" as "Field" and as parameters choose "Doesn't contain" and "<NAME-OF-DUMMY-GENRE>", hit the button "Run Query" and when the profiles are listed click the button "Save Flag Set".

Looks much more complicated than it actually is, I just wanted to provide as detailed instructions as possible. 
 
1.0.1, iPhone 3GS, iOS 4.1.0

Trivia v0.3.1
My HSDB v5 additions, HTML windows and other stuff
 Last edited: by Muckl
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
Creating a flag set should also be possible with my CCViewer. Import the Profiler collection.xml. Call Tools->SQL Queries... and execute the following SQL query:
select right(profileid, len(profileid)-4) from profiles where profileid in (Select childid from boxset)

Save the result into a file via "Save Result".


DVD Profiler Unlimited Registrantseanbob
Registered: June 13, 2007
United States Posts: 24
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
This has been a long time coming, but...

Thanks for all the help on this topic! I'll give it a shot later tonight!
DVD Profiler Desktop and Mobile Registrantmediadogg
Aim high. Ride the wind.
Registered: March 18, 2007
Reputation: Highest Rating
United States Posts: 6,463
Posted:
PM this userVisit this user's homepageDirect link to this postReply with quote
For users of BulkEdit, this will be in the next release as a companion to Flag Between. I'm sure both functions will eventually make it into DVDP - they are both so useful.
Thanks for your support.
Free Plugins available here.
Advanced plugins available here.
Hey, new product!!! BDPFrog.
DVD Profiler Desktop and Mobile Registrantmediadogg
Aim high. Ride the wind.
Registered: March 18, 2007
Reputation: Highest Rating
United States Posts: 6,463
Posted:
PM this userVisit this user's homepageDirect link to this postReply with quote
BulkEdit V2.15 now has "Collection/Flags/Flag Children".
Thanks for your support.
Free Plugins available here.
Advanced plugins available here.
Hey, new product!!! BDPFrog.
    Invelos Forums->DVD Profiler: Desktop Technical Support Page: 1  Previous   Next