Quoting Mark Harrison:

Quote:
So, if you're still using it, what changes would you like to see?

I use it mainly to get a list giving last watched by each user (that also needs to treat information with excel). The program allows only to sort by last watched by any user. For example if my grand daughter watched "Cendrillon" in december 2014, there is no way to sort by last watched by me (for example june 2013)

I also use rating information to collect box office data (number of spectators in my country). From time to time I verify completeness with a csv export.

Some of the fields exported (like audio tracks for example) has multiple values for a single profile.  I've not used it in years, but I thought there was already a way to collapse those into a single row.  If you can find it, let me know and I'll go checkout the plugin.

Quoting Mark Harrison:

Quote:
Some of the fields exported (like audio tracks for example) has multiple values for a single profile.  I've not used it in years, but I thought there was already a way to collapse those into a single row.  If you can find it, let me know and I'll go checkout the plugin.

Ummm, I thought I just answered that. I don't have it loaded at the moment, but I know that my Bulkedit imports the single row version.

Quoting mediadogg:

Quote:
Quoting Mark Harrison:

Quote:
Some of the fields exported (like audio tracks for example) has multiple values for a single profile.  I've not used it in years, but I thought there was already a way to collapse those into a single row.  If you can find it, let me know and I'll go checkout the plugin.

Ummm, I thought I just answered that. I don't have it loaded at the moment, but I know that my Bulkedit imports the single row version.

Well, it seems you did!  Thanks.

I fired up the plugin and I'm not sure I see the problem.  I have fields for All Watched Users and All Watched Dates.  Those two go hand in hand.  They can be listed in a single row as User 1, User 2, etc.  Or split across multiple rows.

I also have a field called Last Watched User and Last Watched Date.  That's just the data for the most recent person who watched.

I'm not sure what else would be needed here.  You'll need to explain better because I'm not sure what you're requesting.

Quoting kd5:

Quote:
For me, Database Query is a WEALTH of information.  Being able to sort my collection via various criteria adds considerable functionality to DVD Profiler.  Database Query is the only plugin I really have any desire to use now, I tried a few others but the glossy finish wore thin in such a relatively short period of time that when I rebuilt my computer, Database Query was the only plugin I wanted to reinstall.  Thankfully the old version works well with Windows 7 (for some reason it didn't like the same collection of software on Windows XP.....go figure). 

The only things I can think of that might be nice is to keep the old version available in case the new version has unforseeable quirks with my new setup (or other's computers). 

Other ideas might be:  Once DbQ is up and has scanned the Collection, it would be nice to be able to scroll down with my mouse, with the current version I can't scroll, except to grab the scroll bar and move it like that.  Also, it might be nice, once DbQ has delivered its results, to be able to bring DVD Profiler back into the forefront to look at some detail or other, right now DbQ takes the forefront and won't give it up, so you have to close it to look something up in DVDP then bring DbQ back up from scratch.  Admittedly, the results are still there when you bring it back up but if I could bring DVDP back to the front, I wouldn't even have to close DbQ.  Not saying any of this is any kind of a deal-breaker...

Other than that, the data DbQ delivers is valuable to me, I like it!

Wow, I can't believe I posted this in entirely the wrong thread.  I feel like a dumbass...

Quoting surfeur51:

Quote:
Quoting Mark Harrison:

Quote:
I'm not sure what else would be needed here.  You'll need to explain better because I'm not sure what you're requesting.

With the plugin, that is what you get with "All Watched Users" and "All Watched Dates" (I added the colors  ):

The colors look sharp!

So you're saying you want to be able to filter the profiles you export based on the user?  So you could pick User G and just see the profiles User G has watched?  And only see User G's data in the watched information?  Or do you want all profiles, but skip all other watched data except for User G?

So in your example, I say I want User G.  Would I just get Master & Commander back?  Or would I get the full list, but with only User G's watched information and no one else's?  The first option seems to make the most sense to me.

So now the biggest question is, why add this to CSVExport?  This seems like a far better fit for Database Query.  And if you really need the data in a spreadsheet for whatever reason, you can cut & paste the results from Database Query into a spreadsheet.  Right-click on the results, click Select All Rows, right-click and select Copy, then paste into a spreadsheet.

Anyway, I'm already rather fond of the idea and will probably add it to Database Query tomorrow.  I'm kind of surprised it's not already there to be honest.  Seems like a perfect query to have.  I've looked three times now.  Can't believe I've missed that one.

So again, why does CSVExport need that functionality?