| Author |
Message |
| Registered: June 22, 2007 |  Posts: 85 |
| | Posted: | | | | Anyone know how I can change the export xml file? When I attempt to open the file in Excel (or LibreOffice Calc) I get the message "The data could not be loaded completely because the maximum number of rows per sheet was exceeded." My collection is large, but the problem is that when it opens (when it did before), there are at least ten or twelve rows for each record (all duplicates).
Any thoughts?
Gene
http://www.invelos.com/dvdcollection.aspx/GeneinOrlando | | | | Last edited: by GeneinOrlando |
|
| Registered: March 13, 2007 | Reputation:  | | Posts: 3,321 |
| | Posted: | | | | There's a plugin called CSVExport that will export your collection in a format compatible with Excel or the spreadsheet of your choice. Try using that instead. You can find it under the Downloads menu up top under the Plugins section. | | | Get the CSVExport and Database Query plug-ins here.
Create fake parent profiles to organize your collection. | | | | Last edited: by Mark Harrison |
|
| Registered: March 13, 2007 | Reputation:  |  Posts: 2,217 |
| | Posted: | | | | Quoting GeneinOrlando: Quote:
Anyone know how I can change the export xml file? I do!  (see signature) But the CSVExport-Plugin Mark already mentioned would be my first recommendation too. XML isn't any spreadsheet, but a plain-text document format to exchange data, which is readable for humans and programs. Excel and other claim to be able to handle those, but as you noticed this is not quite the case, at least without an XSLT (a transformation-file) | | | | Mithi's little XSLT tinkering - the power of XML --- DVD-Profiler Mini-Wiki |
|
| Registered: June 22, 2007 | | Posts: 85 |
| | Posted: | | | | I had always been able to open the xml file before in Excel and it always worked, after I deleted all the duplicate records. Problem is just recent.
I'll try the CVS download.
Thanks
Gene
The only plugin I could find was a bulk editor that mentioned cvs files .... is this the one? | | | | Last edited: by GeneinOrlando |
|
| Registered: March 13, 2007 | Reputation:  | | Posts: 13,202 |
| | Posted: | | | | The CVSExport plugin is in Mark's signature. | | | No dictator, no invader can hold an imprisoned population by force of arms forever.
There is no greater power in the universe than the need for freedom.
Against this power, governments and tyrants and armies cannot stand.
The Centauri learned this lesson once.
We will teach it to them again.
Though it take a thousand years, we will be free.
- Citizen G'Kar |
|
| Registered: March 13, 2007 | | Reputation: | | Posts: 3,321 |
| |
| Registered: June 22, 2007 | | Posts: 85 |
| | Posted: | | | | Thanks .... got it to work today. Just preparing to print .... 440 pages or so!
Gene |
|
| Registered: March 14, 2007 | | Reputation: |  Posts: 4,680 |
| |
| Registered: June 22, 2007 | | Posts: 85 |
| | Posted: | | | | Thank you, but, the CSV export is the one I needed. Much cleaner than the xml export. Printed ou collection last night .... 458 pages (small type)  Gene |
|
| Registered: March 14, 2007 | | Reputation: | | Posts: 4,680 |
| | Posted: | | | | Fair enough. But just so you know, ProfilerQuery can also produce as csv file. And it does much more than that. Take it for a spin if you haven't already. You can find out a lot about your collection ... | | | My freeware tools for DVD Profiler users.
Gunnar |
|