Page 1 of 1
How to update Cross Collection Path

Posted:
14 Feb 2013, 10:45
by rhopkins
I've had to move my collection to an external hard-drive as my laptop was full. I just keep buying too much!
I've sorted iTunes after several attempts at copying a 160GB collection - they don't make it easy, do they? Te proper iTunes method of changing library name, consolidating library just kept crashing.
Anyway, how do I now update my Cross database with the new path to my collection? I've tried opening it up in an SQLLite browser but for some reason I just can't get the UPDATE SQL syntax working correctly. There must be an easier way than this that I'm missing?
Re: How to update Cross Collection

Posted:
14 Feb 2013, 10:58
by rhopkins
I've solved it myself using the REPLACE function via SQLLite Browser.
- Code: Select all
UPDATE Music SET fullpath = REPLACE(fullpath,"<old-library-location>","<new-library-location>");
There were a couple of other tables with entries that I updated by hand.
You can still tell me the easy way to do it.

Re: How to update Cross Collection Path

Posted:
14 Feb 2013, 11:38
by sylMV
You could have used the Cross the "Resolve All Missing Tracks" of File menu

Re: How to update Cross Collection Path

Posted:
14 Feb 2013, 11:45
by rhopkins
sylMV wrote:You could have used the Cross the "Resolve All Missing Tracks" of File menu

'sake
Being a nerd, my way was more fun.
Re: How to update Cross Collection Path

Posted:
22 Feb 2013, 17:29
by RayOne
Greetings!
Just seen your topic here. It already helped to answer one of my questions half way since it has a similar subject to it. But: One of the most important remaining questions for me (using Cross 2.3. with WIN7 64 bit) is this one:
Is possible to transfer your ANALYZED collection into a new installed system while keeping everything like it was before? Because I find it always pretty annoying to have days only spending analyzing the whole collection after I renewed my system...So, if there is a way how to do this please let me know, appreciate, M8!
Thanks a lot!
EZ
Ray
a.k.a.
DJ RayOne
Re: How to update Cross Collection Path

Posted:
22 Feb 2013, 17:50
by rhopkins
RayOne wrote:Greetings!
Just seen your topic here. It already helped to answer one of my questions half way since it has a similar subject to it. But: One of the most important remaining questions for me (using Cross 2.3. with WIN7 64 bit) is this one:
Is possible to transfer your ANALYZED collection into a new installed system while keeping everything like it was before? Because I find it always pretty annoying to have days only spending analyzing the whole collection after I renewed my system...So, if there is a way how to do this please let me know, appreciate, M8!
Thanks a lot!
EZ
Ray
a.k.a.
DJ RayOne
You need to find your peak directory. Something like c:/Documents & Settings/users/<user>/Mixvibes/peak.
Re: How to update Cross Collection Path

Posted:
22 Feb 2013, 19:37
by superdj4life
I'm in the same boat, I tried the resolve all missing tracks but all it does it tell me what tracks are missing then you have to manually point each track to the correct location. not bad for a couple of songs but with thousands of tracks it's going to be faster to simply rescan the collection. besides the SQlite method (great find btw) is there any way to do this?
Re: How to update Cross Collection Path

Posted:
04 Mar 2013, 12:44
by Support@MixVibes
After you resolve the fist file, it ask you if it should look at the same location for other missing files.
cross_relocate01.JPG
cross_relocate02.JPG