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 Feature Requests Page: 1  Previous   Next
Printing/Exporting a User's History
Author Message
DVD Profiler Desktop and Mobile RegistrantPerrdom
Dom
Registered: April 6, 2007
Canada Posts: 5
Posted:
PM this userEmail this userDirect link to this postReply with quote
It would be really useful if there was a way to print or even export a user's History.

Dom
DVD Profiler Desktop and Mobile RegistrantStar ContributorBad Father
Registered: July 23, 2001
Registered: March 13, 2007
Posts: 4,596
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
History? As in...???
My WebGenDVD online Collection
DVD Profiler Desktop and Mobile Registrantkahless
TaH pagh taHbe'!
Registered: March 14, 2007
Reputation: Highest Rating
Germany Posts: 17,804
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Sorry for being curious, but what shall be the sense of this? 
Thorsten
DVD Profiler Unlimited RegistrantStar ContributorWinston Smith
Don't be discommodious
Registered: March 13, 2007
United States Posts: 21,610
Posted:
PM this userEmail this userView this user's DVD collectionDirect link to this postReply with quote


Skip
ASSUME NOTHING!!!!!!
CBE, MBE, MoA and proud of it.
Outta here

Billy Video
DVD Profiler Unlimited RegistrantStar ContributorTomGaines
Registered Sept. 24, 2001
Registered: March 13, 2007
Reputation: High Rating
Germany Posts: 2,005
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
One way would be to use my Cinematic Collection Viewer program.
First export your collection as XML in DVD Profiler.
Then import your collection in CCViewer: File->Import->DVD Profiler Collection

After that you can run SQL queries: Tools->SQL Queries.

The following probably would do for your request:

select title, eventtimestamp, eventtype from profiles p inner join events e on p.profileid = e.profileid where userid='$username$' order by 2;
$username$="Select userid from users"

The result you can save to file, copy to clipboard or directly print it.


DVD Profiler Unlimited RegistrantAstrakan
Registered: Feb 12, 2000
Registered: March 28, 2007
Reputation: High Rating
Canada Posts: 1,299
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Quoting 8ballMax:
Quote:
History? As in...???

I'm assuming as in the history available in the History tab in the user listing.

It's the only kind of user history I know of.

KM
Tags, tags, bo bags, banana fana fo fags, mi my mo mags, TAGS!
Dolly's not alone. You can also clone profiles.
You've got questions? You've got answers? Take the DVD Profiler Wiki for a spin.
 Last edited: by Astrakan
DVD Profiler Desktop and Mobile RegistrantPerrdom
Dom
Registered: April 6, 2007
Canada Posts: 5
Posted:
PM this userEmail this userDirect link to this postReply with quote
Quoting Astrakan:
Quote:
Quoting 8ballMax:
Quote:
History? As in...???

I'm assuming as in the history available in the History tab in the user listing.

It's the only kind of user history I know of.

KM


Exactly. My wife wanted to bring a few movies with her to her friend's place. She wanted a list of which movies she had already loaned her. By looking at the list, she was able to figure it out, but I could see where printing a list could be useful.
DVD Profiler Desktop and Mobile RegistrantStar ContributorBad Father
Registered: July 23, 2001
Registered: March 13, 2007
Posts: 4,596
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Ahhh...gotcha derrrrrrrrr.
My WebGenDVD online Collection
DVD Profiler Desktop and Mobile RegistrantPerrdom
Dom
Registered: April 6, 2007
Canada Posts: 5
Posted:
PM this userEmail this userDirect link to this postReply with quote
Quoting TomGaines:
Quote:
One way would be to use my Cinematic Collection Viewer program.
First export your collection as XML in DVD Profiler.
Then import your collection in CCViewer: File->Import->DVD Profiler Collection

After that you can run SQL queries: Tools->SQL Queries.

The following probably would do for your request:

select title, eventtimestamp, eventtype from profiles p inner join events e on p.profileid = e.profileid where userid='$username$' order by 2;
$username$="Select userid from users"


The result you can save to file, copy to clipboard or directly print it.


That works perfectly. I was able to imprt it into excel and format it to my hearts content.
My wife is happy again 

Thanks
Dom
 Last edited: by Perrdom
    Invelos Forums->DVD Profiler: Desktop Feature Requests Page: 1  Previous   Next