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->DVD Profiler: Desktop Technical Support Page: 1  Previous   Next
how to export a simple numbered listing of a collection
Author Message
DVD Profiler Unlimited RegistrantChazcdc54
Registered: March 19, 2007
United States Posts: 302
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
I have 355 titles that I plan on selling soon and set up in a separate collection tab.  I see that I can print a report but I was looking to find a way to export a simple numbered listing of titles as a .pdf, .csv or some other readily usable file that a perspective buyer could review.  I'm surprised there is no such feature in DVD Pro.  Does anyone have a suggestion here?  Maybe, another useful plug in?
DVD Profiler Desktop and Mobile RegistrantStar ContributorDJ Doena
Registered: May 1, 2002
Registered: March 14, 2007
Reputation: Highest Rating
Germany Posts: 6,744
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Youn can create a report and then print them.

You'll find Reports in the Tools menu. You can "print" to PDF with tools such as CutePDF
Karsten
DVD Collectors Online

DVD Profiler Desktop and Mobile RegistrantStar Contributoreommen
DVD nerd
Registered: March 13, 2007
Reputation: High Rating
Netherlands Posts: 485
Posted:
PM this userEmail this userView this user's DVD collectionDirect link to this postReply with quote
To extend DJ Doena's suggestion: once you've selected Tools -> Reports, the Reports window shows a "Invelos simple Listing" form. In that window, by using the Options -> Select/Sort "As filtered/sorted in the collection listing" (meaning what you see on screen in the main application,  you have to prepare that beforehand of course) to tailor the list to your wishes, using the collection numbering for your list. DVDprofiler sends it directly to a printer, but there are various ways to print to pdf (free tools like CutePDF, PDF24, etc).

If this way of creating your list doesn't work for you, there are alternatives: best way IMHO is to install the DVDprofiler addin Database Query from Mark Harrison.

You can find its download location here (this link can be found on the Downloads -> Plugins page on this website). Download that Database Query plugin. Install it, run DVDprofiler, start the Query tool from the Tools menu (Tools -> Database Query...) and load the data (without cast/crew info).

In that Query tool select "Other" (the last item on the left side), then select Field=ProfileID and Query='List by profile ID'. Run it, then all profiles are listed with only Title, Production year, Media type ans ProfileID (=EAN=UPC). You can trim the columns by right clicking on any column title then click or unclick what you (do not) want to see.

Select the whole list (click the first profile, then goto the last and shift-click it) and copy (the lefmost small icon below the title bar). The list is now on the clipboard.

Open your favourite spreadsheet program (like Excel or LibreOffice) and paste -- these programs are best suited to column editing. Add your own numbering if the Query tool didn't present what you wanted.
This should provide you with the list you wanted with minimal extra fields. You may want to format the profileID column as text.
Export to PDF to your liking. Both Excel and LibreOffice have this as a built-in feature.
Eric

If it is important, say it. Otherwise, let silence speak.
 Last edited: by eommen
DVD Profiler Desktop and Mobile Registrantmediadogg
Aim high. Ride the wind.
Registered: March 18, 2007
Reputation: Highest Rating
United States Posts: 6,461
Posted:
PM this userVisit this user's homepageDirect link to this postReply with quote
There are also:

- CSV Export Plugin
- ProfilerQuery Tool
- DVDProfileLoop Plugin
- File>Export Profile Database, followed by processing the XML with XSLT or MS Excel
- Print to MS XPS Document Writer and use the XPS Viewer to copy/paste a text file
Thanks for your support.
Free Plugins available here.
Advanced plugins available here.
Hey, new product!!! BDPFrog.
    Invelos Forums->DVD Profiler: Desktop Technical Support Page: 1  Previous   Next