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: Plugins Page: 1 2 3 ...13  Previous   Next
New Plugin: CSVExport
Author Message
DVD Profiler Unlimited RegistrantMark Harrison
I like IMDB
Registered: March 13, 2007
Reputation: Great Rating
United States Posts: 3,275
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
I know a lot of people have been asking for the CSV Export feature to be returned, so here it is finally.

You can get a copy from the Downloads area on this site or here.

Simply run the Setup.exe program inside then startup Profiler.  You should now see a new option listed under the Tools menu called "Export Profile Database to CSV".  This pretty much works just like the old export function with a few new goodies added.

If you have any issues with it, let me know in this thread and I'll try to address them.  But I've been using it for about 2-3 months now without any issues.  I've also gone to great lengths to have the output match exactly what we had with 2.4.  So if you were using the old files with another application, you shouldn't have any issues with the new files.

Update: July 11, 2008

Version 1.4 is available

Added Ireland, Philippines and Estonia to Country of Origin.

Version 1.3 is available

Added new fields to export
  - Localities

Version 1.2 is available

Added new fields to export
  - Notes
  - Last Watched - Date
  - Last Watched - User
  - Times Watched
  - All Watched - Dates
  - All Watched - Users

Renamed "Profile ID" to "UPC".

Fixed problem with profiles not being exported with certain combinations of output fields

Fixed problem with Data Alignment getting stuck on Multiple Rows and not outputting data

Update: July 14, 2007

Version  1.1 is available.  It contains the following changes:

Added new fields to export
  - Composer #1 & Composer #2
  - Description - Side A & Description Side B
  - Disc ID - Side A & Disc ID - Side B
  - Dual Layered - Side A & Dual Layered - Side B
  - Label - Side A & Label - Side B
  - Location & Slot
  - Overview
Fixed problem with quotes in the Title field
Get the CSVExport and Database Query plug-ins here.
Create fake parent profiles to organize your collection.
 Last edited: by Mark Harrison
DVD Profiler Desktop and Mobile RegistrantMarcCastermans
Registered: March 15, 2007
Posts: 116
Posted:
PM this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Super Mark, thx for the effort.
Greetz,
Marc Castermans

DVD Profiler Unlimited RegistrantStar ContributorMithi
Sushi Annihilator
Registered: March 13, 2007
Reputation: High Rating
Germany Posts: 2,097
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Looking good so far.
The next version should include additional field, like Slot and Location.

cya, Mithi
Mithi's little XSLT tinkering - the power of XML          Store and find Alternative Covers
The DVD Profiler Wiki - DVDProKB:Community - recent additions: 'Workaround for "Paste and Append Crew"-problem' and 'Making mass changes'
DVD Profiler Unlimited RegistrantMark Harrison
I like IMDB
Registered: March 13, 2007
Reputation: Great Rating
United States Posts: 3,275
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Mithi,

I think the reason I left out fileds like slot and location is that it's a many to one relationship.  That is a single profile can have multiple slots and locations.  That's not to say it can't be done of course.  It's more a matter of finding the best way to do it.  Since I had no need for it, I thought I'd leave it out of version 1.

With that said, do you have any suggestions on how best to implement this?  Should duplicate rows be written for each slot/location?  Should it output some predefined amount similar to how it handles Directors (like 2.4, only the first two directors for a profile are listed)?  Not knowing the needs for this data, I can't really determine the best solution without additional input.
Get the CSVExport and Database Query plug-ins here.
Create fake parent profiles to organize your collection.
DVD Profiler Desktop and Mobile RegistrantStar ContributorGadgeteer
Registered: March 13, 2007
United Kingdom Posts: 519
Posted:
PM this userEmail this userView this user's DVD collectionDirect link to this postReply with quote
Great stuff Mark. It works a treat.

RE Slot/Location, I think each slot/location should have it's own column and, if possible, make it user definable how many you want exported.
Stuart
DVD Profiler Unlimited RegistrantStar ContributorMithi
Sushi Annihilator
Registered: March 13, 2007
Reputation: High Rating
Germany Posts: 2,097
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Quoting Mark Harrison:
Quote:
With that said, do you have any suggestions on how best to implement this?  Should duplicate rows be written for each slot/location?  Should it output some predefined amount similar to how it handles Directors (like 2.4, only the first two directors for a profile are listed)?  Not knowing the needs for this data, I can't really determine the best solution without additional input.

Good questions, but I don't really need it anyways, being Mr. XSLT
I would suggest "first entry only"
Anyone who needs that should/would/could work with childprofiles anyways, I think.

cya, Mithi
Mithi's little XSLT tinkering - the power of XML          Store and find Alternative Covers
The DVD Profiler Wiki - DVDProKB:Community - recent additions: 'Workaround for "Paste and Append Crew"-problem' and 'Making mass changes'
DVD Profiler Unlimited RegistrantMark Harrison
I like IMDB
Registered: March 13, 2007
Reputation: Great Rating
United States Posts: 3,275
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
I was wondering why you had so much interest since you were the one showing everyone how to do it with XML.

Anyway, I think when I get around to it, I'll probably opt for a new column for each slot/location.  The first one would be easy to add I'd think.  I could do 2 or 3, but you do have to draw the line somewhere.

The bigger question is if someone actually wants this data?  I don't see the point in adding features no one will use.
Get the CSVExport and Database Query plug-ins here.
Create fake parent profiles to organize your collection.
DVD Profiler Unlimited RegistrantJackKnight
Hello
Registered: March 13, 2007
United States Posts: 86
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
I tried running it a couple of times and I keep getting  The dotNet framework version 2.0 is not installed. Please install and try again
I tried that and I keep getting the same response...
The artist formerly known as TylerDurden_73
DVD Profiler Unlimited Registrantnuoyaxin
prev. known as ya_shin
Registered: March 13, 2007
Taiwan, Province of China Posts: 3,330
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Quoting JackKnight:
Quote:
I tried running it a couple of times and I keep getting  The dotNet framework version 2.0 is not installed. Please install and try again
I tried that and I keep getting the same response...

You have to update your, well, .NET Framework to 2.0 (or 3.0)... You can download it from Microsoft.
Achim [Ya-Shin//Nuo]
DVD Profiler Unlimited RegistrantMark Harrison
I like IMDB
Registered: March 13, 2007
Reputation: Great Rating
United States Posts: 3,275
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Did you install .NET 2.0?  For the average user, this would be found here.

If you need a 64-bit version, you can find the links here under the ".NET Framework Version 2.0 Redistributable Package" section.

You can also run Windows Update if you're on XP or Vista and it should detect if you need to install 2.0.
Get the CSVExport and Database Query plug-ins here.
Create fake parent profiles to organize your collection.
 Last edited: by Mark Harrison
DVD Profiler Unlimited RegistrantStar ContributorMithi
Sushi Annihilator
Registered: March 13, 2007
Reputation: High Rating
Germany Posts: 2,097
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Quoting Mark Harrison:
Quote:
The bigger question is if someone actually wants this data?  I don't see the point in adding features no one will use.

Well, at least this guy needs it. And maybe other with a DVD-Changer?

cya, Mithi
Mithi's little XSLT tinkering - the power of XML          Store and find Alternative Covers
The DVD Profiler Wiki - DVDProKB:Community - recent additions: 'Workaround for "Paste and Append Crew"-problem' and 'Making mass changes'
DVD Profiler Unlimited RegistrantGinwen
Registered: March 13, 2007
Posts: 3
Posted:
PM this userDirect link to this postReply with quote
Thanks. Works great. I can finally totally move over to the new version.
 Last edited: by Ginwen
DVD Profiler Desktop and Mobile Registrantb00bie
Registered: 12/16/2001
Registered: April 17, 2007
United States Posts: 187
Posted:
PM this userEmail this userView this user's DVD collectionDirect link to this postReply with quote
Hi

I also would like a slot location on CSV, for my application I have a unique slot/location for each DVD so a single instance would be fine for me. Thanks.


Tom
Tom

IOS Ver. 2.1.4
iPad Mini Retina 64GB Wi-Fi iOS 8.1.1 no JB
iPad Air 64GB Wi-Fi iOS 8.1.1 TaiG 1.1 JB
DVD Profiler Unlimited RegistrantMark Harrison
I like IMDB
Registered: March 13, 2007
Reputation: Great Rating
United States Posts: 3,275
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Quoting b00bie:
Quote:
I also would like a slot location on CSV, for my application I have a unique slot/location for each DVD so a single instance would be fine for me. Thanks.


I'm glad to hear that others are finding this useful.  But I do want to discuss the location/slot data a little more.

So let me use an example here.  I have The Lord of the Rings: Return of the King Extended Edition.  That's a single profile.  It has 4 discs.  Discs 1 & 2 are the movie, discs 3 & 4 are the bonus material.

At this point when I do a CSV export, I get one row for that profile.  The problem is that profile has 4 different location/slot values potentially since it has 4 discs associated with the profile.

So again I say, how do you handle that?

Option 1 would be to repeat each row for each unique location/slot.

So the CSV might look like:

Title,Location,Slot
Lord of the Rings, Location1, Slot1
Lord of the Rings, Location2, Slot2
Lord of the Rings, Location3, Slot3
Lord of the Rings, Location4, Slot4

Option 2 would be to handle this like it does with director.  It could either list the location/slot for the first disc in the profile and ignore the rest or list the first x number.  And then what should x be?  For TV sets, this could get much worse.  I have a TV set (Nowhere Man) that has 9 discs.  Should x = 9 then?  If I had a disc changer, I'd certainly load all 9 profiles, but where do you stop?  What if something has more than 9 discs associated with it?

Anyway, that CSV might look like:

Title,Location 1, Slot 1, Location 2, Slot 2, Location 3, Slot 3
Lord of the Rings, Location1, Slot1, Location2, Slot2, Location3, Slot3

What's the best solution here?  Since I have no need for that information, I honestly don't know.  I'm replying on those who need that data to tell me what they need.  Once we know the right direction to go, it should be an easy matter to make the change.  But I need to know which direction to go first.
Get the CSVExport and Database Query plug-ins here.
Create fake parent profiles to organize your collection.
DVD Profiler Desktop and Mobile Registrantb00bie
Registered: 12/16/2001
Registered: April 17, 2007
United States Posts: 187
Posted:
PM this userEmail this userView this user's DVD collectionDirect link to this postReply with quote
Hi

Well I misstated myself in my first mail so let me go into more detail, I have about 2000 DVD's stored in Sony changers and accessed by Escient equipment, using the report feature of DVD profiler I can generate a list of all my DVD's with a location/slot for each disc, what I can't do is manipulate it in that format. I would like to generate a list sorted by location and disc rather than title, since some things have many discs (Danger Man Set-18) I guess x would have to equal a pretty high number in order to extract all the data. Worse yet I have titles that have an entry for each disc in the set like Danger Man, there are 18 individual entrys each including the disc number in my database but for my movies that contain multiple discs I just have entries in the location/slot area like Lord of the Rings has only one DVD entry which contains four locations for the discs. I hope that helps, sorry for being a PITA. If ther is anything I can do to help I will be happy to do so.


Tom
Tom

IOS Ver. 2.1.4
iPad Mini Retina 64GB Wi-Fi iOS 8.1.1 no JB
iPad Air 64GB Wi-Fi iOS 8.1.1 TaiG 1.1 JB
 Last edited: by b00bie
DVD Profiler Desktop and Mobile RegistrantWastlNRW
Registered: March 26, 2007
Germany Posts: 18
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Hi Mark,

thanks for that plugin. It is great and does everything I want and need (possibly at this time)
Maybe in the future will be a facility in DVDP that needs an extension.

Thanks again.
Kind Regards
Heinz
    Invelos Forums->DVD Profiler: Plugins Page: 1 2 3 ...13  Previous   Next