Author |
Message |
Registered: July 26, 2011 | Posts: 25 |
| Posted: | | | | 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 |
|
Registered: May 19, 2007 | Reputation: | Posts: 6,730 |
| Posted: | | | | 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 |
|
Registered: July 26, 2011 | Posts: 25 |
| Posted: | | | | 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. |
|
Registered: May 19, 2007 | Reputation: | Posts: 6,730 |
| Posted: | | | | 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 |
|
Registered: July 26, 2011 | Posts: 25 |
| Posted: | | | | 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? |
|
Registered: March 14, 2007 | Reputation: | Posts: 950 |
| Posted: | | | | 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 |
|
Registered: July 26, 2011 | Posts: 25 |
| Posted: | | | | 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. |
|
Registered: March 18, 2007 | Reputation: | Posts: 6,461 |
| Posted: | | | | 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 |
|
Registered: July 26, 2011 | Posts: 25 |
| Posted: | | | | This does sound like what I'm trying to do. Please tell me the step-by-step procedure. Thanks! |
|
Registered: March 18, 2007 | Reputation: | Posts: 6,461 |
| Posted: | | | | 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 |
|
Registered: July 26, 2011 | Posts: 25 |
| Posted: | | | | 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! |
|
Registered: March 18, 2007 | Reputation: | Posts: 6,461 |
| Posted: | | | | 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. |
|
Registered: July 26, 2011 | Posts: 25 |
| Posted: | | | | You can also add a custom genre such as "set" or have a no genre designation. | | | Last edited: by Rydog23 |
|
Registered: March 29, 2007 | Reputation: | Posts: 4,479 |
| Posted: | | | | 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 |
|
Registered: March 13, 2007 | Reputation: | Posts: 1,439 |
| Posted: | | | | ..... | | | Registered: February 10, 2002 | | | Last edited: by greyghost |
|
Registered: March 13, 2007 | Reputation: | Posts: 13,202 |
| Posted: | | | | 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 |
|