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: Plugins Page: 1  Previous   Next
Bulk Edit Question
Author Message
DVD Profiler Unlimited RegistrantJordbrett
Registered: March 26, 2011
Posts: 4
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
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
DVD Profiler Unlimited RegistrantStar Contributorgreyghost
Registered: March 13, 2007
Reputation: Highest Rating
United States Posts: 1,437
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
In the program itself, clear one purchase date, copy the DVD, flag all profiles,  paste purchase date.
Registered: February 10, 2002
DVD Profiler Unlimited RegistrantJordbrett
Registered: March 26, 2011
Posts: 4
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
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.
DVD Profiler Desktop and Mobile Registrantmediadogg
Aim high. Ride the wind.
Registered: March 18, 2007
Reputation: Highest Rating
United States Posts: 6,461
Posted:
PM this userVisit this user's homepageDirect link to this postReply with quote
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
DVD Profiler Unlimited RegistrantJordbrett
Registered: March 26, 2011
Posts: 4
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
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).
DVD Profiler Unlimited Registrantmichaelzrork
Film Geek
Registered: September 30, 2008
Posts: 81
Posted:
PM this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Any chance there is a solution to this that instead of changing them all to blank changes them all to "use release date"?
DVD Profiler Desktop and Mobile Registrantmediadogg
Aim high. Ride the wind.
Registered: March 18, 2007
Reputation: Highest Rating
United States Posts: 6,461
Posted:
PM this userVisit this user's homepageDirect link to this postReply with 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 your support.
Free Plugins available here.
Advanced plugins available here.
Hey, new product!!! BDPFrog.
DVD Profiler Desktop and Mobile Registrantmediadogg
Aim high. Ride the wind.
Registered: March 18, 2007
Reputation: Highest Rating
United States Posts: 6,461
Posted:
PM this userVisit this user's homepageDirect link to this postReply with quote
Any news?
Thanks for your support.
Free Plugins available here.
Advanced plugins available here.
Hey, new product!!! BDPFrog.
DVD Profiler Unlimited Registrantmichaelzrork
Film Geek
Registered: September 30, 2008
Posts: 81
Posted:
PM this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
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.
    Invelos Forums->DVD Profiler: Plugins Page: 1  Previous   Next