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->General: General Discussion Page: 1 2  Previous   Next
Is there a way to insert a collection number?
Author Message
DVD Profiler Unlimited RegistrantRydog23
Registered: July 26, 2011
Posts: 25
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Let's say I have 500 DVD's. Each of them are numbered in DVD Profiler with Collection #'s 1-500. Then I get a new DVD and would like to make it #250 because it belongs next to #249. I then want the DVD's #250-500 to shift down one number. Is this possible?
 Last edited: by Rydog23
DVD Profiler Unlimited RegistrantStar ContributorLewis_Prothero
Strength Through Unity
Registered: May 19, 2007
Reputation: Superior Rating
Germany Posts: 6,730
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
The options for automatic collection numbers are:
- Title
- Release date
- Purchase Date

If one of those fits your sorting then the answer is "Yes" (Menu: Collection -> Renumber...)

If none fits your preferences I'm afraid you'd have to do it manually.
It all seems so stupid, it makes me want to give up!
But why should I give up, when it all seems so stupid?


Registrant since 05/22/2003
DVD Profiler Unlimited RegistrantRydog23
Registered: July 26, 2011
Posts: 25
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
I would like to sort by genre, then alphabetical. For instance, I would like to group all the horror movies together alphabetically, all the sci-fi together alphabetically, etc. This is the way I have my physical collection organized as well. The only problem with DVD Profiler is that the profiles automatically assign more than one genre to most DVD's.
DVD Profiler Unlimited RegistrantStar ContributorLewis_Prothero
Strength Through Unity
Registered: May 19, 2007
Reputation: Superior Rating
Germany Posts: 6,730
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Genres can be edited in the profile editor (opens by Double-Click onto a profile) in the "General"-tab

Automatic numbering by Genre is not possible and I'm afraid that with your sorting-preferences you'd have to constantly renumber manually.
As a workaround you may want to take Custom Collection Categories (Menu: Collection -> Edit Categories) into consideration. Here you could enter categories by genre with each category having its own numbering (which then, of course, wouldn't interfere with the numbering in the other categories).
It all seems so stupid, it makes me want to give up!
But why should I give up, when it all seems so stupid?


Registrant since 05/22/2003
 Last edited: by Lewis_Prothero
DVD Profiler Unlimited RegistrantRydog23
Registered: July 26, 2011
Posts: 25
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
So, if I made custom Collections, would I still be able to view all "owned" dvd's under the Owned tab? If so, how would they be listed?
DVD Profiler Unlimited RegistrantStar ContributorLJG
Registered: March 14, 2007
Reputation: High Rating
United States Posts: 950
Posted:
PM this userEmail this userView this user's DVD collectionDirect link to this postReply with quote
You would be able to view all of them under all. The way they'd be listed would depend on how you're filtering them: title, purchase date, UPC, genre...there are quite a few ways to view it. I want to say that if you're filtering by genre, it takes the top genre, so if you think a movie is only sci-fi but it's listed as animation first, you'd either have to change the order or delete animation.
Lori
DVD Profiler Unlimited RegistrantRydog23
Registered: July 26, 2011
Posts: 25
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
So, if custom Collections are displayed under All, then how would you distinguish the ones you own vs the ones on your Wish List? I have no sort preference for my Wish List, because well, I don't own them.
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
Quoting Rydog23:
Quote:
I would like to sort by genre, then alphabetical. For instance, I would like to group all the horror movies together alphabetically, all the sci-fi together alphabetically, etc. This is the way I have my physical collection organized as well. The only problem with DVD Profiler is that the profiles automatically assign more than one genre to most DVD's.

I think you can do this with Sort Title, which is protected from being overwritten by Invelos download.

Forget about collection numbers and just prefix the Sort Title with the one genre you prefer. I think that will do what you want. Anybody see issues with that approach?

And if you decide to do it that way, BulkEdit has a way, for example, to take Genre1 and prefix it to the title and copy it to Sort Title, as a bulk operation to get started. So you could have something like "Drama: Movie Title" in the Sort Title field. I can give you step by step instructions if you want to use this method.
Thanks for your support.
Free Plugins available here.
Advanced plugins available here.
Hey, new product!!! BDPFrog.
 Last edited: by mediadogg
DVD Profiler Unlimited RegistrantRydog23
Registered: July 26, 2011
Posts: 25
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
This does sound like what I'm trying to do. Please tell me the step-by-step procedure. Thanks!
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
Quoting Rydog23:
Quote:
This does sound like what I'm trying to do. Please tell me the step-by-step procedure. Thanks!

First of all, of course make sure to have your database backed up iin case something goes wrong. And I would suggest to experiment with just a few profiles first to get the hang of using BulkEdit.

Now my suggestion assumes that, at least initially, one of the genre fields has the genre that you want to use (say, Genre1). Otherwise, you will have to make it so.

(1) Install the plugin BulkEdit (you can always uninstall it later if you don't want to keep it loaded)
(2) Flag the set of profiles you want to work on. BulkEdit can also load whole collections, but as I said, start small.
(3) Tools > BulkEdit > Spreadsheet Edit Profile Data
(4) Checkbox the Genre, Sort Title and Title fields. Then Load > Flagged Profiles
(5) Make sure the cursor is somewhere in the Sort Title Column
(6) Select MultiCopy. In Tool1, select Overwrite Target, set start and end row, select From Title, To Sort Title and then click "Copy Column to Column".

--- At this point, you now have set the Sort Title to be the same as Title. There may be another way to do within DVDP. If so, it doesn't matter how you do this to start with -----

(7) Now in Tool4, put Regex Look For (.*), check Math, Select CSharp, select Out To Target,
and put the following in the big Replace With box (pay attention to case and type carefully):

return RowData("Genre1") + ": " + "$1";

(8) Click All. Now all the Sort Title fields look like: "Genre1: Title"   
(9) Check the result and see if it looks like you want it to. If not, click Finished to get out of MultiCopy, and just Load Flagged again to get a fresh copy of the data and start over. Nothing has been saved to the database yet.
(10) If step (8) went OK, then click Finished to get out of MultiCopy, then click File > Save Validated Changes.

Done. Exit BulkEdit. Your profiles should now have the updated Sort Titles. I always recommend run a database repair and then make a new backup (also keep the old one).

I highly recommend that you first verify that the solution works by manually setting up Sort Title in a few profiles to see if my assertion was correct. If so, make whatever adjustments to the instructions I gave you, and go ahead with the bulk update.

Keep us posted.
Thanks for your support.
Free Plugins available here.
Advanced plugins available here.
Hey, new product!!! BDPFrog.
 Last edited: by mediadogg
DVD Profiler Unlimited RegistrantRydog23
Registered: July 26, 2011
Posts: 25
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Thanks for the help. I wish I realized this earlier, but all I have to do is go to the Sort menu and select Genre>Ascending. This sorts all first genres alphabetically (Action, Adventure, etc.) and then sorts the movies within the genre alphabetically. Any genre I disagree with I can modify. Many thanks again to you all!
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
Quoting Rydog23:
Quote:
Thanks for the help. I wish I realized this earlier, but all I have to do is go to the Sort menu and select Genre>Ascending. This sorts all first genres alphabetically (Action, Adventure, etc.) and then sorts the movies within the genre alphabetically. Any genre I disagree with I can modify. Many thanks again to you all!

Ha! Well that is certainly the better way! 
Thanks for your support.
Free Plugins available here.
Advanced plugins available here.
Hey, new product!!! BDPFrog.
DVD Profiler Unlimited RegistrantRydog23
Registered: July 26, 2011
Posts: 25
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
You can also add a custom genre such as "set" or have a no genre designation.
 Last edited: by Rydog23
DVD Profiler Unlimited RegistrantStar Contributorsurfeur51
Since July 3, 2003
Registered: March 29, 2007
Reputation: Great Rating
France Posts: 4,479
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Quoting Rydog23:
Quote:
Let's say I have 500 DVD's. Each of them are numbered in DVD Profiler with Collection #'s 1-500. Then I get a new DVD and would like to make it #250 because it belongs next to #249. I then want the DVD's #250-500 to shift down one number. Is this possible?
I think you can do it automatically.
1/ make a backup of your database if the result is not what you want
2/create new dvd as number 250 -> you have two "250"
3/menu collection/reassign collection number/eliminate duplicates

4/ verify if 250 and 251 are in the order you wish
5/restore your database if problem
Images from movies
 Last edited: by surfeur51
DVD Profiler Unlimited RegistrantStar Contributorgreyghost
Registered: March 13, 2007
Reputation: Highest Rating
United States Posts: 1,441
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
.....
Registered: February 10, 2002
 Last edited: by greyghost
DVD Profiler Desktop and Mobile RegistrantStar ContributorTheMadMartian
Alien with an attitude
Registered: March 13, 2007
Reputation: Highest Rating
United States Posts: 13,203
Posted:
PM this userEmail this userView this user's DVD collectionDirect link to this postReply with quote
Quoting surfeur51:
Quote:
Quoting Rydog23:
Quote:
Let's say I have 500 DVD's. Each of them are numbered in DVD Profiler with Collection #'s 1-500. Then I get a new DVD and would like to make it #250 because it belongs next to #249. I then want the DVD's #250-500 to shift down one number. Is this possible?
I think you can do it automatically.
1/ make a backup of your database if the result is not what you want
2/create new dvd as number 250 -> you have two "250"
3/menu collection/reassign collection number/eliminate duplicates

I am pretty sure he would still have to pick an 'Order by' option and none of the options is what he wants.
No dictator, no invader can hold an imprisoned population by force of arms forever.
There is no greater power in the universe than the need for freedom.
Against this power, governments and tyrants and armies cannot stand.
The Centauri learned this lesson once.
We will teach it to them again.
Though it take a thousand years, we will be free.
- Citizen G'Kar
    Invelos Forums->General: General Discussion Page: 1 2  Previous   Next