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: Contribution Discussion Page: 1  Previous   Next
Title & UPC Issues
Author Message
DVD Profiler Unlimited RegistrantDrumrBoy
Registered: January 11, 2008
Canada Posts: 11
Posted:
PM this userEmail this userView this user's DVD collectionDirect link to this postReply with quote
Hope you can help. I've put my DVDs in alphabetical order by title (you can see my online profile here http://www.invelos.com/dvdcollection.aspx/DrumrBoy). Why would "1408" be before everything, and shouldn't "50 First Dates", "8 Mile" and "8MM" be before titles such as "300" and "3:10 to Yuma"? How do I fix this so that the titles are in proper numerical order? Should I change the sort titles to 1, 2, 3, etc.?

On the subject of titles, what is the recommended filing order for titles that contain a person's name, ex. "Criss Angel: Mindfreak": The Complete Season One", or "Robin Williams: Live on Broadway". Do I arrange them by show title, ie "Mindfreak" / "Live on Broadway", or by last name? Is one way preferred over the other?

Finally, I have a number of movies with slip covers, and have found that on a few titles the UPC number on some of the slip cover is different than the UPC on the keep case/back cover. Which number should I be using?

Thanks for any help or advice you can give.

DrumrBoy...a.k.a. John
DVD Profiler Unlimited RegistrantStar Contributorapltm
Registered: May 11, 2007
Netherlands Posts: 249
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Hi John,

On sorting titles I can at least tell you what the "problem" is. The titles are sorted on characters, not on numbers. Therefore you get 50 behind 300 (because of the space after 50).

The way I have solved this is to assign collection numbers in such a way that the sorting is the way I like it, in my case I look at how the number would be spelled, so e.g. 2001 A Space Odyssey comes somewhere behind the letter T.

As far as sorting on names is concerned, I make sure that my collection is sorted on surname (e.g. James Bond is somewhere after B) or on the name as a whole with certain series of movies (e.g. Die Hard, Monty Python, etc.)

As far as I'm concerned the filing order is a personal preference and will not be the same for everybody.

Hope this helps.
DVD Profiler Unlimited RegistrantStar Contributornorthbloke
Registered: March 15, 2007
Reputation: High Rating
United Kingdom Posts: 5,459
Posted:
PM this userDirect link to this postReply with quote
Quoting DrumrBoy:
Quote:
Hope you can help. I've put my DVDs in alphabetical order by title (you can see my online profile here http://www.invelos.com/dvdcollection.aspx/DrumrBoy). Why would "1408" be before everything, and shouldn't "50 First Dates", "8 Mile" and "8MM" be before titles such as "300" and "3:10 to Yuma"? How do I fix this so that the titles are in proper numerical order? Should I change the sort titles to 1, 2, 3, etc.?

On the subject of titles, what is the recommended filing order for titles that contain a person's name, ex. "Criss Angel: Mindfreak": The Complete Season One", or "Robin Williams: Live on Broadway". Do I arrange them by show title, ie "Mindfreak" / "Live on Broadway", or by last name? Is one way preferred over the other?

These two are related, and as apltm says, it's related to characters in the sort title field. However, the sort title is purely local, so you can adjust it however you like to get the result you want. For example, in the examples you state, it looks at the first characters and sees 3, 5 and 8 and puts them in order before even looking at the next character.
With respect to names in the titles: for the title field (for the online database), use what's on the cover. For the sort title, use whatever you want to get it where you want it in your collection. Again, it's a local only field so do what you like.

Quote:
Finally, I have a number of movies with slip covers, and have found that on a few titles the UPC number on some of the slip cover is different than the UPC on the keep case/back cover. Which number should I be using?


Use the UPC from the outer cover. The inner UPC is used when that title is issued without the slip cover (usually a short while later). If you're adding to your database and the outer UPC isn't recognised, try the inner one - that might have been submitted. Simply download that one and change it to match your DVD. You can even change the UPC and submit it as a new profile.
 Last edited: by northbloke
DVD Profiler Unlimited RegistrantStar ContributorBroven
I am Jack's cold sweat.
Registered: May 9, 2007
United States Posts: 254
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Quoting DrumrBoy:
Quote:
Hope you can help. I've put my DVDs in alphabetical order by title (you can see my online profile here http://www.invelos.com/dvdcollection.aspx/DrumrBoy). Why would "1408" be before everything, and shouldn't "50 First Dates", "8 Mile" and "8MM" be before titles such as "300" and "3:10 to Yuma"? How do I fix this so that the titles are in proper numerical order? Should I change the sort titles to 1, 2, 3, etc.?


For titles that begin with a number I've added leading zero's to get them to sort properly.  For example, I would change the sort titles of the dvd's you mentioned to 1408, 0050 First Dates, 0008 Mile, 0003:10 to Yuma, etc.  I don't have any dvd's with more than 4 numbers at the beginning so this works for me.  If you have something with more than four you would have to add more zero's.
"I can picture in my mind a world without war, a world without hate. And I can picture us attacking that world because they'd never expect it." - Jack Handey
DVD Profiler Unlimited RegistrantStar ContributorGSyren
Profiling since 2001
Registered: March 14, 2007
Reputation: Highest Rating
Sweden Posts: 4,672
Posted:
PM this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Quoting apltm:
Quote:
On sorting titles I can at least tell you what the "problem" is. The titles are sorted on characters, not on numbers. Therefore you get 50 behind 300 (because of the space after 50).

Just to set the record straight, it's not "because of the space after 50", but because "3" is less then "5". It's a character by character comparison.
My freeware tools for DVD Profiler users.
Gunnar
DVD Profiler Unlimited RegistrantStar Contributorapltm
Registered: May 11, 2007
Netherlands Posts: 249
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Quoting GSyren:
Quote:
Quoting apltm:
Quote:
On sorting titles I can at least tell you what the "problem" is. The titles are sorted on characters, not on numbers. Therefore you get 50 behind 300 (because of the space after 50).

Just to set the record straight, it's not "because of the space after 50", but because "3" is less then "5". It's a character by character comparison.


You're asolutely right
That's what you get writing about one example and thinking about another....
DVD Profiler Unlimited RegistrantDrumrBoy
Registered: January 11, 2008
Canada Posts: 11
Posted:
PM this userEmail this userView this user's DVD collectionDirect link to this postReply with quote
Thanks for your help guys. I added the leading 0's and now the titles are in the order I wanted them to be in. Thanks for the rapid responses!
DVD Profiler Unlimited RegistrantStar ContributorGSyren
Profiling since 2001
Registered: March 14, 2007
Reputation: Highest Rating
Sweden Posts: 4,672
Posted:
PM this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Quoting apltm:
Quote:
You're asolutely right
That's what you get writing about one example and thinking about another....


Yeah, you were thinking about comparing "50" and "500" in which case the space after 50 would be the character that determined the sort order. However, since space sorts before "0", they would actually be sorted in correct order (50 before 500).

But you already knew that, right?
My freeware tools for DVD Profiler users.
Gunnar
    Invelos Forums->DVD Profiler: Contribution Discussion Page: 1  Previous   Next