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->General: General Discussion Page: 1  Previous   Next
Excel
Author Message
DVD Profiler Unlimited Registrantjjom
Registered: February 20, 2011
Portugal Posts: 72
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Is there any way to export the collection to an excel file?
DVD Profiler Unlimited RegistrantStar ContributorGSyren
Profiling since 2001
Registered: March 14, 2007
Reputation: Highest Rating
Sweden Posts: 3,698
Posted:
PM this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Yes, you can do it with ProfilerQuery, but how practical it will be depends a little on just what you want to export.

If you were to try to export every field including cast and crew, that would become an awful lot of data in every single row. That would hardly be useful. If it's just a few selected fields, then it would be easy.

Take a look at ProfilerQuery, read the help file, and if you have any questions I'll be happy to answer them.
Hint: File -> Open result in spreadsheet in the menu is what you should concentrate on.
My freeware tools for DVD Profiler users.
Gunnar
 Last edited: by GSyren
DVD Profiler Unlimited Registrantjjom
Registered: February 20, 2011
Portugal Posts: 72
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Excel was to contain name, collection number and UPC
Thanks
DVD Profiler Unlimited RegistrantStar ContributorCyclograph
Binome (since 2001)
Registered: March 13, 2007
United States Posts: 249
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
For very basic data export to Excel and others, there used to be a very easy to use plugin called "CSV Export" which allowed exporting just user selected data fields. It unfortunately appears to be gone from the downloads section tho...
If someone still has a installer copy, IIRC tho quite old (ca 2009) it still worked with the current program.

Archive of original site, but DL link is dead:
CSV Export 1.4
DVD Profiler Unlimited Registrantnuoyaxin
prev. known as ya_shin
Registered: March 13, 2007
Taiwan, Province of China Posts: 3,410
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Quoting Cyclograph:
Quote:
For very basic data export to Excel and others, there used to be a very easy to use plugin called "CSV Export" which allowed exporting just user selected data fields. It unfortunately appears to be gone from the downloads section tho...
If someone still has a installer copy, IIRC tho quite old (ca 2009) it still worked with the current program.

Archive of original site, but DL link is dead:
CSV Export 1.4

I found one of Mark's posts, as he has the link in his signature. Here you go:

http://doena-soft.de/MarkHarrison/CSVExport.htm
Achim [Ya-Shin//Nuo]
Registered: May 29, 2000 (at InterVocative)
DVD Profiler Desktop and Mobile Registrantmediadogg
Aim high. Ride the wind.
Registered: March 18, 2007
Reputation: Highest Rating
United States Posts: 5,480
Posted:
PM this userVisit this user's homepageDirect link to this postReply with quote
One downside of the CSV format is the difficulty in handling multi-value fields, such as Genre or hierarchical fields, such as Disks. Mark Harrison had a clever but unique way of handling these fields, and he also had two options: column-wise and row-wise.

Just be aware, and take a careful look at the output before you try to load and parse the files. My plugin BulkEdit was designed to load Mark's CSV format directly and at one time I attempted to stay in step with his updates. I invite you to try it if you think it will help you (like importing CSV formatted profiles), and if you do find a bug, I will do my best to fix it promptly.

XML is a more natural and robust way to handle export / import of Profiler data.
Thanks for your support.
Free Plugins available here.
Advanced plugins available here.
Hey, new product!!! BDPFrog.
 Last edited: by mediadogg
    Invelos Forums->General: General Discussion Page: 1  Previous   Next