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
Database schema
Author Message
DVD Profiler Unlimited Registrantmjkdvdpro
Registered: October 24, 2007
Posts: 1
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
How can I get the database schema for the profiler database? I would like to make some batch-type changes and none of the plugins I have tried work too well.

Here's the original problem: I have about 700 movies, and would like to edit the 'disc location' for several subsets of the collection.  What would be ideal would be selecting multiple titles (not allowed) and doing a common field edit like iTunes (bulk-edit plugin does not work). 

Another solution would be a more complete scripting language, or the ability to import single records from an XML file. 

If you could import single records from XML, you could edit the XML, delete the record, and re-import with the new data. Time-consuming but it would work.
DVD Profiler Desktop and Mobile RegistrantStar ContributorDJ Doena
Registered: May 1, 2002
Registered: March 14, 2007
Reputation: Highest Rating
Germany Posts: 6,744
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
There's no direct access to the database, it's password-protected.

But there's a plugin called BulkEdit which might help you.
Karsten
DVD Collectors Online

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
Quoting mjkdvdpro:
Quote:
(bulk-edit plugin does not work). 

Did you report the problem in the BulkEdit thread? Perhaps I missed it, or if I already deemed it something I can't handle, my apologies. The original purpose of BulkEdit was for editing Location and Slot, so if you can't do that - it would get my attention.

My recommended scenario has always been: (1) Use Database Query to search for, select and flag the subset you want to work on, (2) Load Flagged into BulkEdit, (3) Make your changes, (4) Save Validated Changes.

Some folks have been successful with this. I'm sorry that it hasn't worked for you. You are welcome to go ahead and write a bunch of scripts if you prefer to do it yourself, but I would also apprecaite it if you could describe the problem in the BulkEdit thread (if you haven't already - as I said, maybe I missed it.)  (Edit: thanks for the reassurance FredLooks - hoping that the 3.6 upgrade improves speed).
Thanks for your support.
Free Plugins available here.
Advanced plugins available here.
Hey, new product!!! BDPFrog.
 Last edited: by mediadogg
DVD Profiler Unlimited RegistrantFredLooks
phpDVDProfilerDude D5/7/2
Registered: March 13, 2007
Canada Posts: 350
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Quoting mjkdvdpro:
Quote:
What would be ideal would be selecting multiple titles (not allowed) and doing a common field edit like iTunes (bulk-edit plugin does not work).


I just recently updated my 3000+ profiles, changing the location and slot fields in clumps of about 60 profiles per go, using BulkEdit. It takes a while to write out the changed data (a feature of the API it is using, I think) but it worked just fine for me.
-fred
DVD Profiler Desktop and Mobile RegistrantStar ContributorDJ Doena
Registered: May 1, 2002
Registered: March 14, 2007
Reputation: Highest Rating
Germany Posts: 6,744
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Quoting mjkdvdpro:
Quote:
(bulk-edit plugin does not work)


Sorry I overlooked that part. 
Karsten
DVD Collectors Online

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
Quoting mjkdvdpro:
Quote:
If you could import single records from XML, you could edit the XML, delete the record, and re-import with the new data. Time-consuming but it would work.

Just for the record  , you can do this as well as CSV import with BulkEdit. If you need something before the feature is added to DVD Profiler, you could give the plugin a try.
Thanks for your support.
Free Plugins available here.
Advanced plugins available here.
Hey, new product!!! BDPFrog.
 Last edited: by mediadogg
    Invelos Forums->DVD Profiler: Desktop Technical Support Page: 1  Previous   Next