| Registered: July 8, 2007 | | Posts: 4 |
| | Posted: | | | | hello i have 244 Dvds in my database when i try and add any new dvds to my database the new dvds get added with the collection #142 and not the next number 245 246 247 and so on all new dvd have the same collection #142
WHAT HAVE I DONE WRONG |
|
| Registered: March 13, 2007 | Reputation:  |  Posts: 1,946 |
| | Posted: | | | | Looks like some sort of database corruption.
You can try a database repair:
Tools --> Options --> Utilities --> Repair DVD Profiler Database.
If you have cast and crew headshots, do a custom repair and either deselect "remove unused", or select Preserve cast/crew with images. | | | View my collection at http://www.chriskepolis.be/home/dvd.htm
Chris |
|
| Registered: March 14, 2007 | | Posts: 3,830 |
| | Posted: | | | | check your settings in Reassigning Collection Numbers from the DVD Profiler help: Quote:
Reassigning Collection Numbers
Collection Numbers are normally assigned when the DVD is added to your owned collection. However, you may wish to reorganize your collection numbers after they're assigned. The Reassign Collection Numbers feature is a flexible way to renumber part or all of your collection automatically.
To reassign collection numbers, select Collection->Reassign Collection Numbers. DVD Profiler will display the Reassign Collection Numbers dialog box.
Select Reassign all collection numbers to assign numbers to your entire collection, including profiles which already have an assigned collection number.
Select Partial reassignment to maintain existing collection numbers where appropriate. Eliminate gaps will renumber titles to fill gaps in the collection numbers. Eliminate duplicates will renumber profiles to prevent duplicate collection numbers. Assign numbers where blank will assign collection numbers to profiles which don't currently have a collection number assigned.
The Order by section lets you select the order in which to assign collection numbers. Note that numbers are assigned only to the appropriate profiles, as determined by your selected settings.
The Do not renumber section lets you protect ranges of collection numbers based on their current value. Regardless of other options selected, numbers before/after the selected entries will not be affected.
Note: Collection numbers are assigned to your Owned collection only.
if none of these did help, export your database in XML and look at it with Excel check for invalid dates. could be another bad data in one field, can't recollect what it was, perhaps some ohter user remembers the context, finding error in the local database and exporting it in XML and checking that field??? 8ballMax: sugestion | | | | Sources for one or more of the changes and/or additions were not submitted. Please include the sources for your changes in the contribution notes, especially for cast and crew additions. | | | | Last edited: by ? |
|
| Registered: July 8, 2007 | | Posts: 4 |
| | Posted: | | | | thank you so much Reassigning Collection Numbers did the trick did not know you could do that
Thanks again |
|
| Registered: March 14, 2007 | | Posts: 3,830 |
| | Posted: | | | | Great your problem is solved  No problem, welcome to this forum (or assylum as some may refer to this place)  | | | | Sources for one or more of the changes and/or additions were not submitted. Please include the sources for your changes in the contribution notes, especially for cast and crew additions. | | | | Last edited: by ? |
|