| Author |
Message |
| Registered: May 20, 2007 |  Posts: 2 |
| | Posted: | | | | Is it possible to export to .xls or .csv from dvd profiler ? Or anything else than .xml since i don't have a clue on how to use the xml file to get my dvd titles to exel for example.. |
|
| Registered: March 13, 2007 |  Posts: 813 |
| |
| Registered: March 13, 2007 | Reputation:  |  Posts: 5,493 |
| | Posted: | | | | You know I have tried to use this program in the past,, and it works great for downloading the plugin and then installing , then following the only instructions which is: To install this plugin, just extract and run Setup.exe. After starting up DVDProfiler, you should find a new menu option on the Tools menu called "Export Profile Database to CSV". So I have the csv saved to my C drive and it is over 7.1 MB in size.. Then I then follow the said instructions .., : After starting up DVDProfiler, you should find a new menu option on the Tools menu called "Export Profile Database to CSV". But then what?? this is what I get as in example below.. What is that I'm not doing right?? I should point out too, that in the old intervocative base this csv always opened perfectly for me in a spreadsheet for xml .   " /] | | | In the 60's, People took Acid to make the world Weird. Now the World is weird and People take Prozac to make it Normal.
Terry | | | | Last edited: by widescreenforever |
|
| Registered: March 22, 2007 |  Posts: 95 |
| | Posted: | | | | This looks from your screenshots like you are trying to open an .XML not a .CSV file.
When you try to export the db to csv do you get the following windows?
In DVDP:
Tools | Export Profile Database to CSV
Acceptable Use Policy Window: Accept
The Export Profile Database Window is nearly identical to the old export window from 2.x only with more options.
Select what you want to export and the name\location of the file and click export.
If you went through all this, and the file is in the location on your second screenshot, you may have accidentally exported the csv to collection.xml. Try renaming it from collection.xml to collection.csv. | | | Juoquim
Kansas City Flying Disc Club - Disc Golf's KC Home
addicted2dvd's TV Ep Guides
DVDP Resource Centre
My Collection
DVD collector's Dream!!! | | | | Last edited: by Juoquim |
|
| Registered: March 13, 2007 | Reputation:  | | Posts: 3,321 |
| | Posted: | | | | You appears to be importing an XML into Excel. My plugin creates a csv file, not an xml file. If you ran my plugin, you should pay attention to where the file was written. That's where you should find the csv file. | | | Get the CSVExport and Database Query plug-ins here.
Create fake parent profiles to organize your collection. |
|
| Registered: March 13, 2007 | | Reputation: | | Posts: 5,493 |
| | Posted: | | | | I thought .xls was excel?? anyway.., When I open up the .csv file it looks like this:  ............but what I was wanting to do as the other csv here to me I don't know what to do with it. ( as you can tell I'm not totlally computer illerate.. LOL ) Now the following I was able to create using Invocative back a few years back.. ..............I was looking for something like this:  | | | In the 60's, People took Acid to make the world Weird. Now the World is weird and People take Prozac to make it Normal.
Terry | | | | Last edited: by widescreenforever |
|
| Registered: March 13, 2007 | | Reputation: | | Posts: 3,321 |
| | Posted: | | | | Quoting widescreenforever: Quote:
I thought .xls was excel?? It is. .xls is the default output from Excel. .csv is Comma Separated Values. It's a text file that can be read by Excel, but it's not Excel's native format. You can open a .csv file in Notepad and you should see a bunch of data sepatated with commas. One line for each row in Excel. What your screenshot is showing is .xml. That's obvious from the "<Actor FirstName=..." text. I don't know what you're doing wrong, but you're not opening the open from the CSV Export plugin. You're opening the output from DVD Profiler's Export option which only outputs XML. You need to run the Export to CSV option from DVD Profile and pay close attention to where it's writing it's output file. You should see a .csv file there. Sorry I can't be more helpful at the moment. My wife had surgery yesterday and I'm sitting in a hospital room. But hopefully that's enough to get you going in the right direction. | | | Get the CSVExport and Database Query plug-ins here.
Create fake parent profiles to organize your collection. | | | | Last edited: by Mark Harrison |
|
| Registered: May 20, 2007 | | Posts: 2 |
| | Posted: | | | | Thanks for the tip, i got .csv out just fine with the plugin. It doesn't seem to understand scandinavian characters but that's not a major problem, it's easy to mass change those manually.
---
You seem to take the export from the wrong menu, if you take File --> Export Profile Database... you get .xml file that exel does not understand.
But when you take Tools --> Export Profile Database to CSV... you get an .csv file that you can import to exel. |
|
| Registered: March 13, 2007 | | Reputation: | | Posts: 5,493 |
| | Posted: | | | | ah much better.. !! Ok Time to admit what an Idiot I am.. I was using the File/export Data base.. Instead of Tools/Export Profile Data base.. Shows what happens when you read something to quick and omit the word Tools/ Where's that .gif showing me being kicked in the ass ??  Oh and BTW Mark I hope your wife comes thru in flying colors with her operation.. Thanks for taking the time to address me when you are in the waiting room ..  | | | In the 60's, People took Acid to make the world Weird. Now the World is weird and People take Prozac to make it Normal.
Terry | | | | Last edited: by widescreenforever |
|
| Registered: March 13, 2007 | | Reputation: | | Posts: 3,321 |
| | Posted: | | | | Not a problem. The surgery went quite well. She just doesn't deal well with pain.  Anyway, I'm glad you got it figured out. | | | Get the CSVExport and Database Query plug-ins here.
Create fake parent profiles to organize your collection. |
|