| Author |
Message |
| Registered: March 15, 2007 | | Posts: 59 |
| | Posted: | | | | I would like to export my collection to an Excel Spreadsheet and then save it to a flash drive. Can this be done?  |
|
| Registered: March 15, 2007 | | Posts: 116 |
| | Posted: | | | | 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
 |
|
| Registered: March 17, 2007 | | Posts: 28 |
| | Posted: | | | | 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. |
|
| Registered: March 15, 2007 | | Posts: 116 |
| | Posted: | | | | 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
|
|
| Registered: March 13, 2007 | Reputation:  |  Posts: 2,217 |
| | Posted: | | | | 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 |
|
| Registered: March 15, 2007 | | Posts: 59 |
| | Posted: | | | | 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? |
|
| Registered: March 13, 2007 |  Posts: 525 |
| |
| Registered: March 13, 2007 | | Posts: 4,596 |
| | Posted: | | | | Quoting ajm: Quote:
File->Open derrrrrrrr   | | | | My WebGenDVD online Collection |
|
| Registered: March 22, 2007 |  Posts: 24 |
| | Posted: | | | | 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 |
|
| Registered: March 15, 2007 | | Posts: 116 |
| | Posted: | | | | 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
|
|
| Registered: March 14, 2007 | | Posts: 2 |
| | Posted: | | | | 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. |
|
| Registered: March 13, 2007 | | Reputation: | | Posts: 2,217 |
| | Posted: | | | | 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 |
|