Author |
Message |
Registered: March 26, 2011 | Posts: 4 |
| Posted: | | | | Hi, I am really sorry if this has been answered before but I tried searching the forums for a while and couldn't find an answer to this and with my luck of course the search feature was down. Either way....
Is it possible to edit an entire row (purchase price/purchase date) I much prefer my iphone app showing the release date rather than purchase date (since I just added everything a week ago). I've tried using bulk edit but when I clear the column the date changes to 1/1/1900 which then shows up in DVD Profiler. I can manually delete that in DVD Profiler and it will stay blank but obviously I'd rather not have to do each blu-ray manually. Is there some value I can put for bulk edit to keep a tab blank?
Thanks |
|
Registered: March 13, 2007 | Reputation: | Posts: 1,441 |
| Posted: | | | | In the program itself, clear one purchase date, copy the DVD, flag all profiles, paste purchase date. | | | Registered: February 10, 2002 |
|
Registered: March 26, 2011 | Posts: 4 |
| Posted: | | | | When you say paste purchase date there's nothing to paste as I would like it to be completely blank. I'm not 100% sure if I am doing what you suggested though. I select all deleted the date in one but then I don't know what you mean by paste purchase date. Even in bulkedit a deleted date shows up as 1/1/1900 which then shows up in dvd profiler when I save the edit. |
|
Registered: March 18, 2007 | Reputation: | Posts: 6,463 |
| Posted: | | | | I agree with greyghost that you don't need BulkEdit for this one (aside from the fact that it doesn't do what you want ) (1) Pick any profile and clear out the purchase date (2) DVD \ Copy (3) Flag the profiles you want to clear out the purchase date (4) Collection \ Flagged \Paste (5) Checkmark the purchase date field, and checkmark the conformation boxes (6) Click OK | | | Thanks for your support. Free Plugins available here. Advanced plugins available here. Hey, new product!!! BDPFrog. | | | Last edited: by mediadogg |
|
Registered: March 26, 2011 | Posts: 4 |
| Posted: | | | | thank you greyghost for the idea and mediadogg for the detailed instructions. I wasted a LOT of time trying to figure this out and it was so simple! Thanks mediadogg for making all the awesome plugins that help make dvd profiler great software (even if I am just learning how to use them). |
|
Registered: September 30, 2008 | Posts: 81 |
| Posted: | | | | Any chance there is a solution to this that instead of changing them all to blank changes them all to "use release date"? |
|
Registered: March 18, 2007 | Reputation: | Posts: 6,463 |
| Posted: | | | | Quoting michaelzrork: Quote: Any chance there is a solution to this that instead of changing them all to blank changes them all to "use release date"? Ok, now you are in BE territory: (1) Backup your database ( In fact best technique is to open a clean DB for the editing, restore a backup into it. Leave your original alone and do the editing in the new DB.) (2) Flag the profiles you want to change (3) Tools \ BulkEdit (4) Checkmark "Purchase Date" and "Release Date" (5) Load Flagged (6) MultiCopy - Column Copy Tool, select From column, To column, row numbers, select "overwrite" and Click Copy Column to Column. This will be instant. Click "Finished". (7) File \ Save Validated Changes (8) File \ Exit Recommendation: run a DB Repair before doing any additional edits. This will make sure that records get happy, just in case. After you are comfortable that the DB is OK, you can start using it as the new master. I tested this on a block of 166 profiles, and it took about 3 minutes start to finish (not including the DB Repair). | | | Thanks for your support. Free Plugins available here. Advanced plugins available here. Hey, new product!!! BDPFrog. |
|
Registered: March 18, 2007 | Reputation: | Posts: 6,463 |
| Posted: | | | | Any news? | | | Thanks for your support. Free Plugins available here. Advanced plugins available here. Hey, new product!!! BDPFrog. |
|
Registered: September 30, 2008 | Posts: 81 |
| Posted: | | | | Quoting mediadogg: Quote: Quoting michaelzrork:
Quote: Any chance there is a solution to this that instead of changing them all to blank changes them all to "use release date"? Ok, now you are in BE territory:
(1) Backup your database ( In fact best technique is to open a clean DB for the editing, restore a backup into it. Leave your original alone and do the editing in the new DB.) (2) Flag the profiles you want to change (3) Tools \ BulkEdit (4) Checkmark "Purchase Date" and "Release Date" (5) Load Flagged (6) MultiCopy - Column Copy Tool, select From column, To column, row numbers, select "overwrite" and Click Copy Column to Column. This will be instant. Click "Finished". (7) File \ Save Validated Changes (8) File \ Exit
Recommendation: run a DB Repair before doing any additional edits. This will make sure that records get happy, just in case.
After you are comfortable that the DB is OK, you can start using it as the new master. I tested this on a block of 166 profiles, and it took about 3 minutes start to finish (not including the DB Repair). Thanks for that. I'll have to give it a try someday. |
|