How to update Cross Collection Path

   Discuss technical issues with the community. Mixvibes staff provides no support on this board.
Forum rules
Click here to join MIxvibes on DISCORD https://discord.gg/gMdQJ2cJqa

How to update Cross Collection Path

Postby rhopkins on 14 Feb 2013, 10:45

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?
Last edited by rhopkins on 14 Feb 2013, 11:00, edited 1 time in total.
MacBook Pro - 15" (Mid 2014)
2.2Ghz Processor
16GB RAM

U-Mix Control Pro 2
Cross 3.3.10
rhopkins
 
Posts: 532
Joined: 28 Jan 2011, 14:10
Location: Brisbane


Re: How to update Cross Collection

Postby rhopkins on 14 Feb 2013, 10:58

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. :lol:
MacBook Pro - 15" (Mid 2014)
2.2Ghz Processor
16GB RAM

U-Mix Control Pro 2
Cross 3.3.10
rhopkins
 
Posts: 532
Joined: 28 Jan 2011, 14:10
Location: Brisbane


Re: How to update Cross Collection Path

Postby sylMV on 14 Feb 2013, 11:38

You could have used the Cross the "Resolve All Missing Tracks" of File menu :)
SylMV

Image
User avatar
sylMV
 
Posts: 3098
Joined: 04 Jan 2007, 10:38


Re: How to update Cross Collection Path

Postby rhopkins on 14 Feb 2013, 11:45

sylMV wrote:You could have used the Cross the "Resolve All Missing Tracks" of File menu :)


'sake :lol:

Being a nerd, my way was more fun.
MacBook Pro - 15" (Mid 2014)
2.2Ghz Processor
16GB RAM

U-Mix Control Pro 2
Cross 3.3.10
rhopkins
 
Posts: 532
Joined: 28 Jan 2011, 14:10
Location: Brisbane


Re: How to update Cross Collection Path

Postby RayOne on 22 Feb 2013, 17:29

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
RayOne
 
Posts: 21
Joined: 15 Nov 2009, 19:32
Location: Franconia


Re: How to update Cross Collection Path

Postby rhopkins on 22 Feb 2013, 17:50

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.
MacBook Pro - 15" (Mid 2014)
2.2Ghz Processor
16GB RAM

U-Mix Control Pro 2
Cross 3.3.10
rhopkins
 
Posts: 532
Joined: 28 Jan 2011, 14:10
Location: Brisbane


Re: How to update Cross Collection Path

Postby superdj4life on 22 Feb 2013, 19:37

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?
M4500 Quad Core i5 3ghz (Windows 8 Ent x64)
8Gb DDR3 MEM 320Gb HDD
2x Stanton STR8-100 Vinyl Turntables
2x Stanton CMP-800 CD Turntables
Behringer DDM4000
Novation Dicer
Numark IDJ3
User avatar
superdj4life
 
Posts: 127
Joined: 18 Oct 2007, 01:11
Location: Denver, Colorado


Re: How to update Cross Collection Path

Postby Support@MixVibes on 04 Mar 2013, 12:44

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
You do not have the required permissions to view the files attached to this post.
User avatar
Support@MixVibes
 



Return to Community Support




Who is online

Users browsing this forum: No registered users and 26 guests

Board index

 
 
   
 
© 2014 Mixvibes