 |
|
|
|
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->General: General Discussion |
Page:
1  Previous Next
|
|
Excel |
|
|
|
|
|
| Author |
Message |
| Registered: February 20, 2011 |  Posts: 84 |
| | Posted: October 29, 2019 2:05 PM | | | | Is there any way to export the collection to an excel file? |
| | Registered: March 14, 2007 | Reputation:  |  Posts: 4,785 |
| | Posted: October 29, 2019 3:20 PM | | | | Yes, you can do it with ProfilerQuery, but how practical it will be depends a little on just what you want to export. If you were to try to export every field including cast and crew, that would become an awful lot of data in every single row. That would hardly be useful. If it's just a few selected fields, then it would be easy. Take a look at ProfilerQuery, read the help file, and if you have any questions I'll be happy to answer them. Hint: File -> Open result in spreadsheet in the menu is what you should concentrate on. | | | My freeware tools for DVD Profiler users.
Gunnar | | | | Last edited: October 29, 2019 3:25 PM by GSyren |
| | Registered: February 20, 2011 | | Posts: 84 |
| | Posted: October 31, 2019 9:11 AM | | | | Excel was to contain name, collection number and UPC
Thanks |
| | Registered: March 13, 2007 |  Posts: 252 |
| | Posted: October 31, 2019 11:38 PM | | | | For very basic data export to Excel and others, there used to be a very easy to use plugin called "CSV Export" which allowed exporting just user selected data fields. It unfortunately appears to be gone from the downloads section tho... If someone still has a installer copy, IIRC tho quite old (ca 2009) it still worked with the current program. Archive of original site, but DL link is dead: CSV Export 1.4 |
| | Registered: March 13, 2007 | Reputation:  |  Posts: 3,440 |
| | Posted: November 6, 2019 7:55 AM | | | | Quoting Cyclograph: Quote:
For very basic data export to Excel and others, there used to be a very easy to use plugin called "CSV Export" which allowed exporting just user selected data fields. It unfortunately appears to be gone from the downloads section tho...
If someone still has a installer copy, IIRC tho quite old (ca 2009) it still worked with the current program.
Archive of original site, but DL link is dead:
CSV Export 1.4 I found one of Mark's posts, as he has the link in his signature. Here you go: http://doena-soft.de/MarkHarrison/CSVExport.htm | | | Achim [諾亞信； Ya-Shin//Nuo], a German in Taiwan.
Registered: May 29, 2000 (at InterVocative) |
| | Registered: March 18, 2007 | | Reputation: | | Posts: 6,504 |
| | Posted: November 10, 2019 3:59 PM | | | | One downside of the CSV format is the difficulty in handling multi-value fields, such as Genre or hierarchical fields, such as Disks. Mark Harrison had a clever but unique way of handling these fields, and he also had two options: column-wise and row-wise.
Just be aware, and take a careful look at the output before you try to load and parse the files. My plugin BulkEdit was designed to load Mark's CSV format directly and at one time I attempted to stay in step with his updates. I invite you to try it if you think it will help you (like importing CSV formatted profiles), and if you do find a bug, I will do my best to fix it promptly.
XML is a more natural and robust way to handle export / import of Profiler data. | | | Thanks for your support.
Free Plugins available here.
Advanced plugins available here.
Hey, new product!!! BDPFrog. | | | | Last edited: November 10, 2019 4:04 PM by mediadogg |
|
|
|
Invelos Forums->General: General Discussion |
Page:
1 Previous Next
|
|
|
|
|
|
|
|
|
|
 |