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... 7 8 9 10 11 ...13  Previous   Next
New Plugin: CSVExport
Author Message
DVD Profiler Desktop and Mobile Registrantmediadogg
Aim high. Ride the wind.
Registered: March 18, 2007
Reputation: Highest Rating
United States Posts: 5,282
Posted:
PM this userVisit this user's homepageDirect link to this postReply with quote
Quoting DJ Doena:
Quote:
... Maybe the other developer can give you a pointer...

Surely you jest (as the lol shows ...) 

I bow in awe to you guys. I was just trying to get the user to save the data in case Mark didn't see this post right away. Thankfully he did.
Thanks for your support.
Free Plugins available here.
Advanced plugins available here.
Hey, new product!!! BDPFrog.
DVD Profiler Unlimited RegistrantMark Harrison
I like IMDB
Registered: March 13, 2007
Reputation: Great Rating
United States Posts: 3,321
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Quoting DJ Doena:
Quote:
NullReferenceExceptions should always be debugged by two people. Maybe the other developer can give you a pointer...


   

Gotta love geek humor.
Get the CSVExport and Database Query plug-ins here.
Create fake parent profiles to organize your collection.
DVD Profiler Unlimited Registrantvjvl51
Registered: September 8, 2010
Canada Posts: 13
Posted:
PM this userDirect link to this postReply with quote
First, thanks for all the work you have put in this plugin. 

I recently downloaded and installed it.  Works fine as long as I exported all flagged profiles but if I try to export owned, all I get is the titles of the columns.  I'm using Win 7 Home Premium 64 bit with DVD Profiler 3.7 (Version 3.7.2 Build 1444).  I have ran the database repair.  I am only exporting - collection number, media type, title, sort title, location & slot.  I do not have any custom profiles.

My work around is to flag all owned and then export.
DVD Profiler Unlimited RegistrantMark Harrison
I like IMDB
Registered: March 13, 2007
Reputation: Great Rating
United States Posts: 3,321
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Thanks for that.  I'll look into it.
Get the CSVExport and Database Query plug-ins here.
Create fake parent profiles to organize your collection.
DVD Profiler Unlimited RegistrantMorpheusUK
Registered: February 12, 2008
Posts: 11
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Quoting Draxen:
Quote:
Quoting Mark Harrison:
Quote:
Also, another user requested through email that I add cast.  Anyone else interested in this?  Any thoughts on how it should be implemented?  It could be all cast separated by commas in a single field, a limited number of cast separated by commas in a single field or something like the first X cast members exported in separate fields.  Or something else entirely that I've not thought of.  Of course a lot will depend on how slow this makes the plug-in and how much interest there is in it.


Ok, it's almost a year from your posting, but I only just noticed it... 

I for one really would like to have the option of including cast in the exported file. Most ideal for my needs would be the method bolded above. Typically 10-15 first names would be enough for my use, but of course it would be ideal, if the user could change the number him-/herself in the settings, if needed.


Firstly thanks for your efforts. I've just started using the plugin as a workaround to the Android situation along with Memento and so far so good. I would also like to see a cast option but I would probably have gone with a simple First name + last name for the first 10 or so in the same manner as the directors etc. although a '/' or other field delimited list embedded within a CSV field would also work e.g.

Cast #1: Clint Eastwood
Cast #2: Sigourney Weaver

or

Cast: Clint Eastwood/Sigourney Weaver

The reason I haven't gone with a comma as the delimiter is that it complicates processing the resultant CSV file and makes reading it manually more complicated as well.
 Last edited: by MorpheusUK
DVD Profiler Unlimited RegistrantStar ContributorMithi
Sushi Annihilator
Registered: March 13, 2007
Reputation: Great Rating
Germany Posts: 2,147
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
I sense a disturbance in the force ... did someone mention the words "Android" and "workaround"? 

Quoting MorpheusUK:
Quote:
Firstly thanks for your efforts. I've just started using the plugin as a workaround to the Android situation along with Memento and so far so good.

Would you share your template for Memento? I fiddled around with it a bit but was to impatient to get it working.
Quote:
I would also like to see a cast option[...]
Cast #1: Clint Eastwood
Cast #2: Sigourney Weaver

or

Cast: Clint Eastwood/Sigourney Weaver

If you send me a version of the textfile you want to have I'm sure I could cook something up with XSLT. And don't worry there is a very nice GUI to transfrom XML with XSLT it wouldn't be more complicated than the CSV-Export.

cya, Mithi
Mithi's little XSLT tinkering - the power of XML
DVD Profiler Unlimited RegistrantClove1036
Registered: October 31, 2011
Posts: 1
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
maybe Ive just missed something but, a "cast 1 - cast 2 type field would be awsome... such as MorpheusUK mentioned... Any plans to add this?
DVD Profiler Desktop and Mobile Registrantmediadogg
Aim high. Ride the wind.
Registered: March 18, 2007
Reputation: Highest Rating
United States Posts: 5,282
Posted:
PM this userVisit this user's homepageDirect link to this postReply with quote
Do you mind copy / paste from an HTML window?

You can set up such a window ("HTML Section") to give you a cast list in about 2 minutes. Then just copy / paste into a text file.
Thanks for your support.
Free Plugins available here.
Advanced plugins available here.
Hey, new product!!! BDPFrog.
 Last edited: by mediadogg
DVD Profiler Unlimited RegistrantMorpheusUK
Registered: February 12, 2008
Posts: 11
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Quoting Mithi:
Quote:
I sense a disturbance in the force ... did someone mention the words "Android" and "workaround"? 

Quoting MorpheusUK:
Quote:
Firstly thanks for your efforts. I've just started using the plugin as a workaround to the Android situation along with Memento and so far so good.

Would you share your template for Memento? I fiddled around with it a bit but was to impatient to get it working.
Quote:
I would also like to see a cast option[...]
Cast #1: Clint Eastwood
Cast #2: Sigourney Weaver

or

Cast: Clint Eastwood/Sigourney Weaver

If you send me a version of the textfile you want to have I'm sure I could cook something up with XSLT. And don't worry there is a very nice GUI to transfrom XML with XSLT it wouldn't be more complicated than the CSV-Export.

cya, Mithi


Hi Mithi,

Sorry I haven't logged in here for quite a while and hadn't subscribed to this topic so missed your reply. I'm guessing you have probably done your memento database setup by now but just in case let me know and I will see if I can get it to you. (I can't see any obvious means to upload it as an attachment to this post) but be warned it was pretty basic.

I did think of knocking up a quick Java program to do a transform on the XML at the time but TBH I just couldn't motivate myself to do so for something which was ultimately a nice to be able to do.

Morpheus

*Edit*
Just discovered the new Android program so I'm guessing that this is now a moot point regarding the memento template. I've just tried it with my SGS2 with ICS. I've had a few issues with apps force closing since the ICS upgrade the middle of last week and this seems to also. I'm beginning to wish I had held off a bit longer before upgrading from Gingerbread.
 Last edited: by MorpheusUK
DVD Profiler Unlimited Registrantdtsig
Just asking questions man
Registered: August 17, 2009
United States Posts: 339
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Mark, i have a problem.

I just downloaded and installed the CSVEport plugin.  Everything worked great until I went from the 2.4 format to the Customer Format and asked for all fields.

Now i seem to be getting some 'merging' of profiles.

For example, the profile for '10' imports into openOffice with data from 'Absolute Power'.

Not only is 'Absolute Power' at the end of data for '10' but the data for '10' seems to be 'jumbled'.  For example under Sort Title it shows

10",£"

In looking at the raw data i see something like

"","10"","£","13.99",

Note the extra quote.  The movie does have the title of "10" (with the double quotes)

If you want I could send you the csv file to examine.

So i am trying to work out what the issue is .. is it the format of the csv?  is it that the data lines are too long?  Not sure yet.

Do you have any ideas?

I am not sure why this started after moving to the 'all' columns export but I just ran it again with the 2.4 format and it appears to have worked correctly

Here is what it looks like where it really starts failing ..



Note that '"10"' and 'Absolute Power' are the only ones that appear to have an issue so i doubt it is a length problem.

Let me know what you think
thanks
DSig
 Last edited: by dtsig
DVD Profiler Unlimited RegistrantMark Harrison
I like IMDB
Registered: March 13, 2007
Reputation: Great Rating
United States Posts: 3,321
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
It's the double quotes.  And it will be fixed when I update this for 3.8.1.
Get the CSVExport and Database Query plug-ins here.
Create fake parent profiles to organize your collection.
DVD Profiler Unlimited Registrantdtsig
Just asking questions man
Registered: August 17, 2009
United States Posts: 339
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Quoting Mark Harrison:
Quote:
It's the double quotes.  And it will be fixed when I update this for 3.8.1.

Do you know the time table for that?

Thanks
DSig
DVD Profiler Unlimited RegistrantMark Harrison
I like IMDB
Registered: March 13, 2007
Reputation: Great Rating
United States Posts: 3,321
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
I don't.  Started on it a couple weeks ago and didn't get far.  It's just a matter of finding time.
Get the CSVExport and Database Query plug-ins here.
Create fake parent profiles to organize your collection.
DVD Profiler Unlimited Registrantdtsig
Just asking questions man
Registered: August 17, 2009
United States Posts: 339
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
A couple other questions and a request:

1) is it possible to get the output in 'sorted' order.  It appears to come out every which way.  Not sorted as on the screen, not sorted in Title order or collection number.

2) i added LOCATION to the output and it put out a location for every disk.  For example one of my collections has 12 discs.  The Title outputed was only the main title but there are 12 columns with info in each location.  Could this be optionally changed to only show the location for the specific "profile" ?

3) Could you add a xls format for output.  I now the plugin is called CSVExport .. just hoping.

Thanks alot for the great work

DSig
DVD Profiler Unlimited RegistrantMark Harrison
I like IMDB
Registered: March 13, 2007
Reputation: Great Rating
United States Posts: 3,321
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Quoting dtsig:
Quote:
1) is it possible to get the output in 'sorted' order.  It appears to come out every which way.  Not sorted as on the screen, not sorted in Title order or collection number.


You say how you don't want it sorted, but I fail to see how you DO want it sorted.

Additionally, this is for importing into a spreadsheet program.  Personally, I use Excel.  I don't know what others use.  Regardless, Excel, and probably most other spreadsheet programs kind of excel at sorting data.  I fail to see the purpose of sorting it myself.  Not that it's difficult mind you, I just fail to see the point.  Output what you want, open in Excel or your spreadsheet program of choice, then sort on whatever column you desire.

Quote:

2) i added LOCATION to the output and it put out a location for every disk.  For example one of my collections has 12 discs.  The Title outputed was only the main title but there are 12 columns with info in each location.  Could this be optionally changed to only show the location for the specific "profile" ?


Sorry, I don't understand.  You're going to have to explain this one better.

Quote:

3) Could you add a xls format for output.  I now the plugin is called CSVExport .. just hoping.


Again, what's the point?  Either file will open in Excel.  You can then Save As to any format you desire.  The whole purpose of CSV is that it's compatible with a wide range of applications on a wide range of platforms.  Saving it as an XLS file is possible.  But again, what's the point?  It would look exactly the same as the CSV version, so I'm not sure what the advantage is.
Get the CSVExport and Database Query plug-ins here.
Create fake parent profiles to organize your collection.
DVD Profiler Desktop and Mobile Registrantmediadogg
Aim high. Ride the wind.
Registered: March 18, 2007
Reputation: Highest Rating
United States Posts: 5,282
Posted:
PM this userVisit this user's homepageDirect link to this postReply with quote
Quoting dtsig:
Quote:
A couple other questions and a request:

1) is it possible to get the output in 'sorted' order.  It appears to come out every which way.  Not sorted as on the screen, not sorted in Title order or collection number.

2) i added LOCATION to the output and it put out a location for every disk.  For example one of my collections has 12 discs.  The Title outputed was only the main title but there are 12 columns with info in each location.  Could this be optionally changed to only show the location for the specific "profile" ?

3) Could you add a xls format for output.  I now the plugin is called CSVExport .. just hoping.

Thanks alot for the great work

DSig

I hope Mark doesn't mind me adding a bit to the response. I have a vested interest in this important plugin, and I try to make mine stay compatible with it.

(1) agree totally with Mark's answer, although if he decided to do it, wouldn't affect my stuff

(2) I think you misunderstand the concept of "Location". Location is a disc-level property. There is a unique location for each disc. There is no profile-level location, unless you use a tag for that purpose. To see how this works, edit a profile that has more than one disc, and you will see that each disc in Personal Info section has a separate Location, Slot, DiscID, Label and Description.
If you only want the Location for disc 1, you could just delete the other columns from the spreadsheet before doing whatever it is you want to do.

(3) Same here. DVDP already has XML output (I assume you meant XML, not XSL). Just load that into Excel and delete whatever columns or rows you don't want. (BTW if you did mean XSL, Excel will create that for you also).
Thanks for your support.
Free Plugins available here.
Advanced plugins available here.
Hey, new product!!! BDPFrog.
    Invelos Forums->DVD Profiler: Plugins Page: 1... 7 8 9 10 11 ...13  Previous   Next