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: Desktop Technical Support Page: 1  Previous   Next
How can I export my collection details to a Excel Spreadsheet?
Author Message
DVD Profiler Unlimited Registrantcujodog
cujodog
Registered: March 15, 2007
Posts: 59
Posted:
PM this userEmail this userView this user's DVD collectionDirect link to this postReply with quote
I would like to export my collection to an Excel Spreadsheet and then save it to a flash drive.

Can this be done? 
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
I just noticed  that there remains only the XML export method but you can use this to export to excel.

Just use File->Export Profile Database and choose name and location and run it. Then import the XML file into excel et voila.
Greetz,
Marc Castermans

DVD Profiler Unlimited Registrantcharleybaak
Registered: March 17, 2007
Posts: 28
Posted:
PM this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Do you get the same result as you did with CSV-file in the old program?
Life's like a movie, write your own ending.
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
Quoting charleybaak:
Quote:
Do you get the same result as you did with CSV-file in the old program?


The result is the same but the importing in excel is a little more work.
Greetz,
Marc Castermans

DVD Profiler Unlimited RegistrantStar ContributorMithi
Sushi Annihilator
Registered: March 13, 2007
Reputation: Superior Rating
Germany Posts: 2,217
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Quoting cujodog:
Quote:
I would like to export my collection to an Excel Spreadsheet

As shown in the thread RIP CSV Export, it is rather easy to make a nice CSV from the XML. The CVS would be importable to Excel.
No idea how to import it directly, my age-old Excel (Office 2000) doesn't know anything of it, newer versions might be smarter.

But why not making a nice HTML or a simple TXT for carrying around on USB? Wouldn't need an installed spreadsheet-program.

cya, Mithi
Mithi's little XSLT tinkering - the power of XML --- DVD-Profiler Mini-Wiki
DVD Profiler Unlimited Registrantcujodog
cujodog
Registered: March 15, 2007
Posts: 59
Posted:
PM this userEmail this userView this user's DVD collectionDirect link to this postReply with quote
Quoting MarcCastermans:
Quote:
I just noticed  that there remains only the XML export method but you can use this to export to excel.

Just use File->Export Profile Database and choose name and location and run it. Then import the XML file into excel et voila.


How do you import the XML file into Excel?
DVD Profiler Desktop and Mobile RegistrantStar Contributorajm
dvd-aholic
Registered: March 13, 2007
United Kingdom Posts: 525
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
File->Open

Home of the phpDVDProfiler forums
DVD Profiler Desktop and Mobile RegistrantStar ContributorBad Father
Registered: July 23, 2001
Registered: March 13, 2007
Posts: 4,596
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Quoting ajm:
Quote:
File->Open


derrrrrrrr  
My WebGenDVD online Collection
DVD Profiler Unlimited Registrantjerryel
If I could only remember.
Registered: March 22, 2007
United States Posts: 24
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Quoting 8ballMax:
Quote:
Quoting ajm:
Quote:
File->Open


derrrrrrrr  


I have Excel 2003 and none of the DVDP versions make an XML file that will open.
It always says there is an error in the file and refuses to open.
The CVC export does work though but it's a mess to resize all the columns.

Maybe that's why the member asked, ""how" did you open the file?"
-Jerry in NW Florida
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
When you open the XML file in excel 2003 (File->Open), excel asks what to do. Choose the bottom option. In Dutch this is "het taakvenster van de xml gegevensbron gebruiken". In English must be something like "use the taskwindow from the xlm datasource".
Now you get a window on the leftside with all the XML fields available.
Drag and drop the fields you want on your spreadsheet and finaly choose Import from the taskbar.

It's not so perfect though. I'm looking for a better way.
Greetz,
Marc Castermans

DVD Profiler Unlimited Registrantjasonwoerner
Registered: March 14, 2007
Posts: 2
Posted:
PM this userDirect link to this postReply with quote
Just want to point out how much I miss the plain text export. Simply pulling a list of titles only and smacking them into a spreadsheet.

Excel 2004 for Mac OS X declares that the XML file isn't properly formatted. So I'm out of luck. Looking for an XML utility for Mac OS X that'll allow me to get past this.
DVD Profiler Unlimited RegistrantStar ContributorMithi
Sushi Annihilator
Registered: March 13, 2007
Reputation: Superior Rating
Germany Posts: 2,217
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Quoting jasonwoerner:
Quote:
Excel 2004 for Mac OS X declares that the XML file isn't properly formatted. So I'm out of luck. Looking for an XML utility for Mac OS X that'll allow me to get past this.

Well, Saxon-B is a Java-XSLT-Processor, so it should run under Mac OS too.
But there is a Plugin for DVD Profiler that brings back the CSV-Export.

cya, Mithi
Mithi's little XSLT tinkering - the power of XML --- DVD-Profiler Mini-Wiki
    Invelos Forums->DVD Profiler: Desktop Technical Support Page: 1  Previous   Next