Container field path

[Cateleb]

Hi, first off I'm using FM11 so it's not super containers

 

I have stored the reference only to several thousand files (mainly pdf and zip) for which the path has been C:/mypath .. but we are upgrading our systems so I can't use the C: drive anymore.

 

Is there a way to change the path to E:/mypath ?

 

thanks

 

 

 

 

[greerso]

If you are saying that you have a text field with a path to a file, it is very easy to replace the contents of all fields containing C:/mypath.... with E:/mypath... using the "Replace Field Contents" option in the "Records" menu to update a field in all records of the current found set.  There is no undo, so do it on a copy of your database to make sure you're getting the expected result.  If you have FMP Advanced you can try the calculation in the data viewer first to make sure you're getting what you want.

 

The calc could look something like "Substitute ( self ; "C:/" ; "D:/" ).  If not all records need to be changed you could use "Case"

 

Supercontainer is a third party product by 360Works, not a feature of FMP12 but FMP12 does have a similar feature.

 

Best,

 

Danny

[Cateleb]

Hi Danny,

 

the field is a container field  .. documents::file (ie not a text field)  which holds the reference to the zip file, eg "100341.zip"  

 

I've a calc field to show the full path ... GetAsText(documents::file) which shows  filewin:/c:/zips/100314.zip .. however that can't be replaced / altered as it's a calc.  

 

I don't know how .. or even if it's possible .. to amended the "reference" in the actual container field

 

the only work around I can figure is to do a script that will basically delete the contents of all the existing container fields then re insert the new reference for the zip file ... the 100341 in the above example is our file reference number so I "should" be able to match the right zip with the right record :-) .. I'll practice on a a back up first !

 

regards 

Cateleb