| Author |
Message |
| Registered: May 26, 2007 | Reputation:  |  Posts: 599 |
| | Posted: | | | | Quoting Rifter: Quote:
I have a small request, though, based on using it. When I pick a title out of the list to edit -- which works fine -- when it goes back to the list it rewinds to the beginning instead of coming back at the point it jumped into edit mode at. If you've got a bunch of changes to make, in a large list, that wastes an enormous amount of time scrolling to the next title in the list.
Agree on this |
|
 | Muckl | | That's my common name. |
| Registered: April 9, 2009 | Reputation:  |  Posts: 858 |
| |
| Registered: March 13, 2007 |  Posts: 646 |
| | Posted: | | | | Greetings Mark,
When I installed your latest update I noticed something. I now have 2 instances of DQ in the plug-ins list. I suspect it is because I choose to install it in my folder dedicated to DVDP 3.6 and the previous version of DQ is installed in DVDP 3.5 folder. Any chance you could include a clean/unstall previous DQ functionality when installing an DQ update, in your next update?
How do I get rid of the older version of DQ in the plug-ins list? Anyone know? Much appreciated! |
|
| Registered: March 13, 2007 | | Posts: 646 |
| | Posted: | | | | I was trying to capture profiles with 1 disc having "Main Feature" in description but without Disc ID. How do you do it using DQ?
Found the neat query to find missmatch in length (parent vs children). Realy cool! But, how do I retain the result listing? If I save a flaglist, it will not take the comparison result/profile with it. Perhaps I should say: How do you guys use this result list? Edit each profile one by one while in DQ or is there another usage I don't see now?
Extreem longshot:
Is it possible using DQ (future), to write our own SQL statements? |
|
| Registered: March 18, 2007 | Reputation:  | | Posts: 6,463 |
| | Posted: | | | | FYI, BulkEdit is open for changes to "Collection/Flagged ..." entries in support of editing tasks.
Right now, I have:
Flag Between
Flag Children.
So if there is another handy one needed, let me know. I have no intention here of overlapping DBQ functions, just to add anything that might be needed in the midst of a bulk editing session. | | | Thanks for your support.
Free Plugins available here.
Advanced plugins available here.
Hey, new product!!! BDPFrog. |
|
| Registered: October 4, 2008 | | Posts: 27 |
| | Posted: | | | | I get an error message when I try to run a DB Query.
"Database Qwery can't read profile: ."
How can I possibly figure out which profile it's having issues with? |
|
| Blair | | Resistance is Futile! |
| Registered: October 30, 2008 | | Posts: 1,249 |
| | Posted: | | | | Do a database repair.
I had this same problem for multiple profiles a few days ago (first time using the plugin for a while) and a repair fixed everything. | | | If at first you don't succeed, skydiving isn't for you.
He who MUST get the last word in on a pointless, endless argument doesn't win. It makes him the bigger jerk. |
|
| Registered: October 4, 2008 | | Posts: 27 |
| | Posted: | | | | I just ran a repair and it didn't make any difference.  |
|
| Registered: March 14, 2007 |  Posts: 2,337 |
| | Posted: | | | | I just noticed that this plugin doesn't understand Russia and Romania as a CoO. |
|
| Blair | | Resistance is Futile! |
| Registered: October 30, 2008 | | Posts: 1,249 |
| | Posted: | | | | Mark,
Since it would be much more likely to see this included with DBQ than for Ken to add it to DVDP, I decided to ask you first about a small feature request.
"Personal Information -> Review Movie -> Count profiles by movie review"
How about under that -- not including "0 bars" into the equation as that is likely to mean "no rating" -- a calculated mean average of a person's collection?
((X DVDs * 1.0) + (Y * 1.5) + (Z * 2.0) (...etc...)) divided by combined total of DVDs rated 1.0 to 5.0
The result rounded to, maybe, the nearest one-thousandth's place.
A useless stat, but nonetheless something of which I liked the idea even before finding Profiler. | | | If at first you don't succeed, skydiving isn't for you.
He who MUST get the last word in on a pointless, endless argument doesn't win. It makes him the bigger jerk. | | | | Last edited: by Blair |
|
| Registered: May 26, 2007 | | Reputation: | | Posts: 2,879 |
| | Posted: | | | | I've had DbQ installed for quite some time and love it.
However, I noted something the other day. I ran a query to find all profiles with Country of Origin left blank. When I did this, it brought up not only the blank profiles, but also some of the profiles with newer countries listed - Columbia, Peru & Chile. Even going in and changing it to blank and then changing it back to that country did not unlist it as "blank".
Also, when running it to count profiles by country of origin it does not list these three.
Just thought you ought to know. | | | If more of us valued food and cheer and song above hoarded gold, it would be a merrier world.
-- Thorin Oakenshield |
|
| Registered: March 13, 2007 | | Reputation: | | Posts: 3,321 |
| | Posted: | | | | I'll try to find some time to look into this soon. | | | Get the CSVExport and Database Query plug-ins here.
Create fake parent profiles to organize your collection. |
|
| Registered: March 14, 2007 | | Reputation: | | Posts: 4,681 |
| | Posted: | | | | I think I have found a bug.
I added collection number to the result columns and tried to sort by collection number. Result:
System.NullReferenceException: Object reference not set to an instance of an object.
at Hare.DatabaseQuery.QueryControl.dataGridView1_SortCompare(Object sender, DataGridViewSortCompareEventArgs e)
at System.Windows.Forms.DataGridView.OnSortCompare(DataGridViewSortCompareEventArgs e)
at System.Windows.Forms.DataGridView.OnSortCompare(DataGridViewColumn dataGridViewSortedColumn, Object value1, Object value2, Int32 rowIndex1, Int32 rowIndex2, Int32& sortResult)
at System.Windows.Forms.DataGridViewRowCollection.RowComparer.CompareObjects(Object value1, Object value2, Int32 rowIndex1, Int32 rowIndex2)
at System.Windows.Forms.DataGridViewRowCollection.RowArrayList.CustomQuickSort(Int32 left, Int32 right)
at System.Windows.Forms.DataGridViewRowCollection.RowArrayList.CustomSort(RowComparer rowComparer)
at System.Windows.Forms.DataGridViewRowCollection.Sort(IComparer customComparer, Boolean ascending)
at System.Windows.Forms.DataGridView.SortInternal(IComparer comparer, DataGridViewColumn dataGridViewColumn, ListSortDirection direction)
at System.Windows.Forms.DataGridView.Sort(DataGridViewColumn dataGridViewColumn, ListSortDirection direction)
at System.Windows.Forms.DataGridView.OnColumnHeaderMouseClick(DataGridViewCellMouseEventArgs e)
at System.Windows.Forms.DataGridView.OnMouseClick(MouseEventArgs e)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.DataGridView.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
Possibly because there were titles without a collection number in the result. | | | My freeware tools for DVD Profiler users.
Gunnar |
|
| Registered: March 13, 2007 | | Reputation: | | Posts: 3,321 |
| | Posted: | | | | Quoting GSyren: Quote:
I think I have found a bug. I think you have too!  Thanks. It will be fixed in the next release. | | | Get the CSVExport and Database Query plug-ins here.
Create fake parent profiles to organize your collection. |
|
| Registered: March 14, 2007 | | Reputation: | | Posts: 4,681 |
| |
| Registered: March 13, 2007 | | Reputation: | | Posts: 3,321 |
| | Posted: | | | | That's a tougher question to answer.  | | | Get the CSVExport and Database Query plug-ins here.
Create fake parent profiles to organize your collection. |
|