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
Run report to produce UPC listing in a text file
Author Message
DVD Profiler Unlimited Registranttjenkins99
Registered: February 9, 2008
Posts: 113
Posted:
PM this userVisit this user's homepageDirect link to this postReply with quote
I am also a member on blu-ray.com and would like to add my dvd collection. To do this on blu-ray.com you need to "enter a series of UPCs/EANs separated by either space, comma or line-break" on one of their screens.
I was wondering if anyone knows how to run a report against the dvdprofiler database that would write a list of my upc fields into a .txt file. I could then copy/paste the UPcodes and import them into my profile on blu-ray.com.

Thanks.
DVD Profiler Unlimited RegistrantStar ContributorMithi
Sushi Annihilator
Registered: March 13, 2007
Reputation: Superior Rating
Germany Posts: 2,217
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Quoting tjenkins99:
Quote:
To do this on blu-ray.com you need to "enter a series of UPCs/EANs separated by either space, comma or line-break" on one of their screens.

I don't think there is an easy way to do that with report, but there are (at least) two alternatives I can think of using plugins:

1) CSVExport
allows you to export chosen fields to a text-file

2) Trading Poster TG
if the majority of your profiles is of the US-locality you can use TPTG to copy the Profile_ID (which is the UPC for US-locality) directly into the clipboard and from there paste them onto blu-ray.com.
For all the other profiles you would need to delete the Locality, but especially for adding a few new profies that still would be faster than CVSExport I think.
Mithi's little XSLT tinkering - the power of XML --- DVD-Profiler Mini-Wiki
DVD Profiler Desktop and Mobile Registrantmediadogg
Aim high. Ride the wind.
Registered: March 18, 2007
Reputation: Highest Rating
United States Posts: 6,463
Posted:
PM this userVisit this user's homepageDirect link to this postReply with quote
There is an even faster way for the US locality. Just flag the profiles you want and save the flag set. This creates a text file (with extension .lst) consisting of the upcs, one per line in the file.
Thanks for your support.
Free Plugins available here.
Advanced plugins available here.
Hey, new product!!! BDPFrog.
DVD Profiler Unlimited Registranttjenkins99
Registered: February 9, 2008
Posts: 113
Posted:
PM this userVisit this user's homepageDirect link to this postReply with quote
Thanks very much for your recommendations - both excellent suggestions.
I tried all three methods and "flagging the profiles/saving the flagged list" and Trading Poster TG produced the results I needed:

025192167782
025192199882

CSVExport left a hyphen in the UPC value:
025192-167782
025192-199882

Thanks again.
    Invelos Forums->DVD Profiler: Desktop Technical Support Page: 1  Previous   Next