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: Layouts and Reports Page: 1  Previous   Next
How do I export my collection to Excel?
Author Message
DVD Profiler Unlimited RegistrantAjhendry
Registered: January 17, 2016
Posts: 2
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
I am trying to open the collection file in excel but it locks up.  Is there something I am missing?
DVD Profiler Unlimited RegistrantStar Contributorbbbbb
on steroids
Registered: March 14, 2007
Posts: 5,734
Posted:
PM this userDirect link to this postReply with quote
Don't confuse while the film is playing with when the film is played. [Ken Cole, DVD Profiler Architect]
 Last edited: by bbbbb
DVD Profiler Unlimited RegistrantAjhendry
Registered: January 17, 2016
Posts: 2
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
I am not being neither......I genuinely am trying to figure out how to do this.  Everytime I download the list from profiler and then try to open the download it locks up and will not open.  I am not familiar with all of this and really would like some help.
DVD Profiler Unlimited RegistrantStar Contributorsurfeur51
Since July 3, 2003
Registered: March 29, 2007
Reputation: Great Rating
France Posts: 4,439
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
If you want to have profiler data in Excel, the best is to use Mark Harrison's plugin CSV Export. You can choose the fields you want, and get a collection.csv file that can be opened without problem with Excel.
 Last edited: by surfeur51
DVD Profiler Unlimited RegistrantStar ContributorMithi
Sushi Annihilator
Registered: March 13, 2007
Reputation: High Rating
Germany Posts: 2,109
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Quoting Ajhendry:
Quote:
I am trying to open the collection file in excel but it locks up.  Is there something I am missing?

The Collection.xml? You can open that one in a text-editor, but you'll see that this doesn't help much either. 
To work with the XML you'd need a XSLT-file to bring it in something useful to you. See my signature.

If you only need certain fields in a csv that you can open in Excel the CSV Plugin surfeur51 mentioned is the way to go.
Thread: New Plugin: CSVExport and Download
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'
    Invelos Forums->DVD Profiler: Layouts and Reports Page: 1  Previous   Next