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: Desktop Technical Support Page: 1  Previous   Next
Need someone who is really smart and can help me out.
Author Message
DVD Profiler Unlimited RegistrantStar Contributorwidescreenforever
Under A Double DoubleW
Registered: March 13, 2007
Reputation: High Rating
Canada Posts: 5,491
Posted:
PM this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Okay I am changing location of over 240 of my titles from ''one room'' to another totally differant area and would like to reflect this in the area of location and slot.
I have manaually over the years typed in basement for these titles.. Well I am moving them to a new location and need to know how I can do this one swift edit rather than flagging and manually editing each slot with new Location ..
Really appreciate if someone here o nthe boards who is technically astute and can guide me in doing this in a few seconds rather than all day typing ..

Thanks   
In the 60's, People took Acid to make the world Weird. Now the World is weird and People take Prozac to make it Normal.

Terry
 Last edited: by widescreenforever
DVD Profiler Unlimited RegistrantStar ContributorAce_of_Sevens
Registered: December 10, 2007
Reputation: High Rating
Posts: 3,004
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Are you putting basement in the notes field now?
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
Mediadoggs "BulkEdit" seems to be capable of this.
Probably best to contact him directly for further info on how to do it.


EDIT: The easiest way would probably be to rename the new location. ... 
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 RegistrantStar Contributorwidescreenforever
Under A Double DoubleW
Registered: March 13, 2007
Reputation: High Rating
Canada Posts: 5,491
Posted:
PM this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Quoting Ace_of_Sevens:
Quote:
Are you putting basement in the notes field now?


Not in Notes  But in Location/ slot
In the 60's, People took Acid to make the world Weird. Now the World is weird and People take Prozac to make it Normal.

Terry
 Last edited: by widescreenforever
DVD Profiler Unlimited RegistrantStar Contributorwidescreenforever
Under A Double DoubleW
Registered: March 13, 2007
Reputation: High Rating
Canada Posts: 5,491
Posted:
PM this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Quoting Silence_of_Lambs:
Quote:
Mediadoggs "BulkEdit" seems to be capable of this.
Probably best to contact him directly for further info on how to do it.


EDIT: The easiest way would probably be to rename the new location. ... 


Or just don't move them.... either ... 

I don't see location in the notes from Bulk edit:

The following fields are imported:
- ProfileID
- Collection type (e.g Owned, Wishlist ...)
- Title
- Sort Title
- Original Title
- Collection Number
- BoxSet Contents
- Purchase Price
- Purchase Currency
- Purchase Date
- Purchase Place (see notes below)
- Notes
- Review
- Discs (including Location and Slot)
- Events
- Tags
- Locks
In the 60's, People took Acid to make the world Weird. Now the World is weird and People take Prozac to make it Normal.

Terry
DVD Profiler Unlimited RegistrantStar ContributorMithi
Sushi Annihilator
Registered: March 13, 2007
Reputation: Superior Rating
Germany Posts: 2,217
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Quoting widescreenforever:
Quote:
I don't see location in the notes from Bulk edit:

- Discs (including Location and Slot)

I highlighted the interesting part for you 

Make a backup of your collection and install BulkEdit:

As you can't filter on location: right-click on the title-column in the collection-list, choose "view columns" and there "Disc Location". Now click on that column-header to sort by "Disc Location". Afterwards all your "Basements" should be one below the other. Now flag the first and the last profiler and go: Collection -> Flags - > Flag between (a new command brought to you by BulkEdit)
The whole thing of course only works if all "Basements" should be changed, otherwise you have to filter them somehow beforehand or do the flagging manually which might get a bit boring on 240 profiles.
If you did the latter it might be prudent to save the flag-set, Collection - > Flags -> Save set

Now open Bulkedit, Tools -> BulkEdit and choose "Disc Information", "Location" and "Title" and what else seem of value to see and Load -> Flagged Profiles. Click on the first Location field, click Multi-Copy and in "Tool 2" type "Basement" in the one field and "$whaterveryournewlocationisnamed" in the other, "find and replace all" and afterwards finished. Now just Files -> Save calidated changes and BE will really write the changes to your database.

cya, Mithi
Mithi's little XSLT tinkering - the power of XML --- DVD-Profiler Mini-Wiki
DVD Profiler Unlimited RegistrantStar Contributorwidescreenforever
Under A Double DoubleW
Registered: March 13, 2007
Reputation: High Rating
Canada Posts: 5,491
Posted:
PM this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Thanks Mithi

got bulk edit loaded and for two days now (experimenting) It won't change any location titles ..
I even decided after a few dozen attempts to just load one title only in..
I flag it.. then load(flagged entries)  it, then multicopy which takes me to the next page that has 4 areas of Tools :  Prepend to target /Append to target / Overwrite to target..

I've tried all three but I'd imagine that overwrite is the one I need.  then the drop down box start row /end row  for my selected flags is selected. From box is next-, it is empty unless I choose location to location.. (?).  Tool 2 - look for / replace with  is selected...  Tool 3  and Tool 4 both the same as Tool 1  in looks..  then there is first found in cell and all found in cell along with exact match .,,
and the  finally the master button FINISHED .. which when clicked instantly finishes ,(?) . then I go to validate saves ., and all looks /changes have not happened.  I've tried this tool on both windows XP  and Windows 7 both results  I  won't say disappointing.., I'll just say  It didn't work for me.. 
In the 60's, People took Acid to make the world Weird. Now the World is weird and People take Prozac to make it Normal.

Terry
 Last edited: by widescreenforever
DVD Profiler Desktop and Mobile RegistrantStar ContributorBad Father
Registered: July 23, 2001
Registered: March 13, 2007
Posts: 4,596
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Quoting widescreenforever:
Quote:
Thanks Mithi

got bulk edit loaded and for two days now (experimenting) It won't change any location titles ..
I even decided after a few dozen attempts to just load one title only in..
I flag it.. then load(flagged entries)  it, then multicopy which takes me to the next page that has 4 areas of Tools :  Prepend to target /Append to target / Overwrite to target..

I've tried all three but I'd imagine that overwrite is the one I need.  then the drop down box start row /end row  for my selected flags is selected. From box is next-, it is empty unless I choose location to location.. (?).  Tool 2 - look for / replace with  is selected...  Tool 3  and Tool 4 both the same as Tool 1  in looks..  then there is first found in cell and all found in cell along with exact match .,,
and the  finally the master button FINISHED .. which when clicked instantly finishes ,(?) . then I go to validate saves ., and all looks /changes have not happened.  I've tried this tool on both windows XP  and Windows 7 both results  I  won't say disappointing.., I'll just say  It didn't work for me.. 


Odd . I followed Jim's instructions above and it worked flawlessly for me. First I "Personalized" 10 titles by adding "Basement" to the Location field. I flagged those 10 titles. I started BulkEdit. I checked off "Disc Information", "Location" and "Title". I "Load"ed Flagged Profiles. I selected "Basement" in the first Location field. I then Clicked on Multi-Copy and in Tool 2 I typed "Basement" in Look For and "Bedroom" in Replace With and clicked on Find and Replace All then clicked on Finish. After File>Save Validated Changes all 10 Profile's Location changed from "Basement" to "Bedroom".

BTW, I'm running Windows Vista Home Premium 64bit.
My WebGenDVD online Collection
 Last edited: by Bad Father
DVD Profiler Unlimited RegistrantStar Contributorwidescreenforever
Under A Double DoubleW
Registered: March 13, 2007
Reputation: High Rating
Canada Posts: 5,491
Posted:
PM this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Quoting 8ballMax:
Quote:
Quoting widescreenforever:
Quote:
Thanks Mithi

(


Odd . I followed Jim's instructions above and it worked flawlessly for me. First I "Personalized" 10 titles by adding "Basement" to the Location field. I flagged those 10 titles. I started BulkEdit. I checked off "Disc Information", "Location" and "Title". I "Load"ed Flagged Profiles. I selected "Basement" in the first Location field. I then Clicked on Multi-Copy and in Tool 2 I typed "Basement" in Look For and "Bedroom" in Replace With and clicked on Find and Replace All then clicked on Finish. After File>Save Validated Changes all 10 Profile's Location changed from "Basement" to "Bedroom".

BTW, I'm running Windows Vista Home Premium 64bit.


this stage right here FIND and replace ALL .. 'I m getting "Target Column is \read Only"  .....
so I'm using that button only the Finsished button,.. btw what about the other three buttons two radio buttons and one box button.. did you have the first selected or,,,?/
In the 60's, People took Acid to make the world Weird. Now the World is weird and People take Prozac to make it Normal.

Terry
DVD Profiler Desktop and Mobile RegistrantStar ContributorBad Father
Registered: July 23, 2001
Registered: March 13, 2007
Posts: 4,596
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Quoting widescreenforever:
Quote:
Quoting 8ballMax:
Quote:
Quoting widescreenforever:
Quote:
Thanks Mithi

(


Odd . I followed Jim's instructions above and it worked flawlessly for me. First I "Personalized" 10 titles by adding "Basement" to the Location field. I flagged those 10 titles. I started BulkEdit. I checked off "Disc Information", "Location" and "Title". I "Load"ed Flagged Profiles. I selected "Basement" in the first Location field. I then Clicked on Multi-Copy and in Tool 2 I typed "Basement" in Look For and "Bedroom" in Replace With and clicked on Find and Replace All then clicked on Finish. After File>Save Validated Changes all 10 Profile's Location changed from "Basement" to "Bedroom".

BTW, I'm running Windows Vista Home Premium 64bit.


this stage right here FIND and replace ALL .. 'I m getting "Target Column is \read Only"  .....
so I'm using that button only the Finsished button,.. btw what about the other three buttons two radio buttons and one box button.. did you have the first selected or,,,?/


The first radio button "1st found in Cell" was selected.

If the target cell is "read only", sounds like you may have a "permissions" issue?
My WebGenDVD online Collection
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
Quoting 8ballMax:
Quote:
If the target cell is "read only", sounds like you may have a "permissions" issue?


Possibly accessing the database from a client?
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 Desktop and Mobile RegistrantStar ContributorBad Father
Registered: July 23, 2001
Registered: March 13, 2007
Posts: 4,596
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Here are the step-by-step procedures I took for Bulk changing the Location (with Pics):

FLAG YOUR PROFILES


RUN BULKEDIT


CHECK YOUR FIELDS TO DISPLAY


LOAD FLAGGED PROFILES


OVERWRITE SHEET DATA (I just choose YES)


FLAGGED PROFILES ARE NOW LOADED...Select the First Location Field (First occurrence of "Basement" is selected)


SELECT MULYI-COPY (USE TOOL 2)


IN Look For: TYPE Basement and IN Replace With: Type in your new Location. NEXT CLICK ON Find and Replace All. "Basement" is now changed to "Bedroom" in BulkEdit


CLICK ON Finish


NEXT FILE>Save Validated Changes


FLAGGED PROFILES IN DVDP NOW SHOW NEW LOCATION
My WebGenDVD online Collection
DVD Profiler Unlimited RegistrantStar Contributorwidescreenforever
Under A Double DoubleW
Registered: March 13, 2007
Reputation: High Rating
Canada Posts: 5,491
Posted:
PM this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Quoting 8ballMax:
Quote:
Here are the step-by-step procedures I took for Bulk changing the Location (with Pics):


Thanks 8ballmax for all the detailed pictures.. First the good news ..Done, and installed /..
Followed yours (and Mithi's PM ) and after numerous attempts ..and still had same results even after studying screen grabs.. I decided (with my limited PC skills ) to close everyhting down and restart the computer (windows 7 laptop)., and reapplied all the  instructions and voila  it worked..! ..

Thanks again Max for the patience and installing all the  images for us....

now to walk across the room and do the same for the XP PC  .. 

In the 60's, People took Acid to make the world Weird. Now the World is weird and People take Prozac to make it Normal.

Terry
 Last edited: by widescreenforever
DVD Profiler Desktop and Mobile RegistrantStar ContributorBad Father
Registered: July 23, 2001
Registered: March 13, 2007
Posts: 4,596
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Glad it worked out .
My WebGenDVD online Collection
DVD Profiler Desktop and Mobile Registrantmediadogg
Aim high. Ride the wind.
Registered: March 18, 2007
Reputation: Highest Rating
United States Posts: 6,456
Posted:
PM this userVisit this user's homepageDirect link to this postReply with quote
OMGGGGG ....

I missed this whole train. Took off from the station, made a bunch of stops, got to the destination, and I was off in lala land. 

Kudos to all. You have no idea how it made my day. Guess I'd better dust off those pending updates.
Thanks for your support.
Free Plugins available here.
Advanced plugins available here.
Hey, new product!!! BDPFrog.
    Invelos Forums->DVD Profiler: Desktop Technical Support Page: 1  Previous   Next