Invelos Forums->DVD Profiler: Desktop Technical Support |
Page:
1  Previous Next
|
|
Listing to excel? |
|
|
|
|
|
| Author |
Message |
| Registered: March 18, 2007 | | Posts: 15 |
| | Posted: | | | | I'm in the process of 'booking' my DVD's into albums. I need to get a listing of titles into excel so I can sort them by Album location.
Anyone know how I can to that from profiler? I have about 950 titles, and don't want to type them in.
Thanks
Randy |
| | Registered: March 14, 2007 |  Posts: 1,339 |
| | Posted: | | | | I am not an expert at this... but i know the way to do this is under File -> Export Profile Database this allows you to export your collection to an xml document, which excel can read... once you get there, you would have to figure out how to manipulate the data yourself... at least till someone else jumps in to help you out  I would also point out that if you go to a title in your collection, you can right click and choose personalize, this gives you a option to add Location and Slot to your data... instead of creating the excel doc you can simply put Album 1, Album 2, etc in this slot, it will keep track of the data you wish, right inside dvd profiler... you can then use sort by location to order them, and print reports | | | | -JoN | | | | Last edited: by ruineddaydreams |
| | Registered: March 13, 2007 | Reputation:  |  Posts: 3,436 |
| | Posted: | | | | There is an "Export to CSV" plugin. The output of that is probably easier to import into Excel than an XML. | | | Achim [諾亞信； Ya-Shin//Nuo], a German in Taiwan.
Registered: May 29, 2000 (at InterVocative) |
| | Registered: March 18, 2007 | | Posts: 15 |
| | Posted: | | | | Looked through plugins on this website, and didn't see an "export to csv" - any idea where I might find it?
Tried the regular xml export, but it gave me almost 12000 rows in excel 2007.
Many thanks for suggestions. |
| | Registered: March 18, 2007 | | Posts: 15 |
| | Posted: | | | | Oops, never mind; found the plugin in the old area (the forum). |
| | Registered: March 14, 2007 | Reputation:  |  Posts: 17,804 |
| | Posted: | | | | Quoting randy_m: Quote:
Looked through plugins on this website, and didn't see an "export to csv" - any idea where I might find it?
HERE!  | | | | Thorsten |
| | Registered: January 28, 2008 |  Posts: 1 |
| | Posted: | | | | Quoting randy_m: Quote:
Tried the regular xml export, but it gave me almost 12000 rows in excel 2007.
In Excel 2003 and above, use the XML Source task pane to create an XML Map for your collection source. This will allow you to pick and choose from all of the exported fields in your XML file, and filter the 12000 rows down to just the info that you're looking to track in the excel workbook. For example, if you only include the Title field in your XML map, you'll just get a list of your movie titles. http://office.microsoft.com/en-us/excel/HA011019641033.aspx The above link at Microsoft's website may help to explain it better. | | | | Last edited: by notesguy |
| | Registered: March 13, 2007 | | Reputation: | | Posts: 2,372 |
| | Posted: | | | | Quoting notesguy: Quote:
Quoting randy_m:
Quote:
Tried the regular xml export, but it gave me almost 12000 rows in excel 2007.
In Excel 2003 and above, use the XML Source task pane to create an XML Map for your collection source.
This will allow you to pick and choose from all of the exported fields in your XML file, and filter the 12000 rows down to just the info that you're looking to track in the excel workbook.
For example, if you only include the Title field in your XML map, you'll just get a list of your movie titles.
http://office.microsoft.com/en-us/excel/HA011019641033.aspx
The above link at Microsoft's website may help to explain it better. Very nice 1st post.  Welcome to the forums  |
|
|
|
Invelos Forums->DVD Profiler: Desktop Technical Support |
Page:
1 Previous Next
|
|
|