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