| IVS Forums->DVD Profiler: Reports Discussion |
Page:
1  Previous Next
|
 Word (Locked) |
|
|
|
|
|
| Author |
Message |
olemla2
| Registered: November 8, 2002 | | Posts: 2 |
| | Posted: | | | | Is it possible to import reports into Word?
So from there on you can sort and manage your collection? |
| WetRon
Moin-Moin
| Registered: August 29, 2002 | | Posts: 859 |
| | Posted: | | | | Sort???? Word????
if you want sorting, I would export your collect to csv file and then use Excel..
As for printing to Word.
I know that there is a Microsoft virtual printer (I don't use it). It is the same thing as cutepdf, foxit pdf, or Adobe pdf writer except it creates rtf (I think) files and not PDFs.
You could open that in Word..... | | | | "Experience is something you don't get until just after you need it." |
| olemla2
| Registered: November 8, 2002 | | Posts: 2 |
| | Posted: | | | | Thank's a lot WetRon!
You are right, in Excel it is much easier to import and sort... |
| anderdea
| Registered: January 20, 2007 | | Posts: 11 |
| | Posted: | | | | I'm curious, how would you take the static report data and export it into Excel?
Also from the other posts I've read, (I'm new to "DVD Profiler" but not to database development) I would prefer to export the whole data base to excel but it doesn't appear to be easily accomplished. |
| TomGaines
| Registered: September 24, 2001 | | Posts: 2,332 |
| | Posted: | | | | You cannot import the report data in Excel. But you could import the Profiler's csv-export file. The whole database on the otherhand (or as close as you can get) is available in the XML-Export file.
You then can use other tools to import or transform the XML file.
For example my tool Cast & Crew Viewer will import it into an Access database. | | | 
Cast & Crew Editor v1.5.0 / TV Cast and Crew Data | | | | Last edited: by TomGaines |
| anderdea
| Registered: January 20, 2007 | | Posts: 11 |
| | Posted: | | | | | Last Night with very little difficulty, I was able to export my database into excel as a .csv file. I was however, disappointed when I checked in excel and the UPC field wasn't part of the data. I then rechecked the fields exported form DVD Profiler and found that it wasn't part of the standard export selection. |
| TomGaines
| Registered: September 24, 2001 | | Posts: 2,332 |
| | Posted: | | | | Yes, because of this I proposed to export to XML. There this info is available.
Then you can import for example in my C&C Viewer. If you then still want to have a csv file with UPC, you select in the Viewer Tools->SQL Queries and send the query
SELECT * FROM Profiles
Then you save the result into a text file. Then you can import it into Excel (just enter a | as field divider). | | |
Cast & Crew Editor v1.5.0 / TV Cast and Crew Data |
| anderdea
| Registered: January 20, 2007 | | Posts: 11 |
| | Posted: | | | | Thanks, Tom.
I'll give it a try at my next opportunity. |
|
|
| IVS Forums->DVD Profiler: Reports Discussion |
Page:
1 Previous Next
|
|
|
