Hi

My question is about moving files that are linked in a container field.

Our company has recently restaructued shared network drives.

I have moved all of the linked.pdf or linkd.doc files to new folder structure, the link in the container field still points to the old location.

 

I have created a Calculted Text field to retrieve the patch using

GetAsText ( Document container)

 formula

i.e. filewin:/G:/XXXX Syd/ARCHIVE/XXXX SHARED/XXXX ONLINE/XXXXXXscreen/XXX Clearances/Correspondence with rightsholders/XXXXXXX16102012.pdf

 

Is there a way to update the container link to the new folder location?

Should be replaced to newer path.

 

Thanks

 

FileMaker Server 10

FileMaker Client 11

You can't update the link, you need to loop through the records and insert the file again.  Since you can calculate the new path, this should be a fairly hands off routine.

Automatic message

This topic has been moved from "Finding & Searching" to "Server 10".

Thanks Wim

So is it possible to do search a text pattern of the path and replace with another text/path for the container field? As the path is almost constant only file names are different.

You can do the search on the calculated text field and calculate a new file path with a replace.  But you then still have to insert the field into the container.

Following script resolved my issue:

Update FilePath
Go to Record/Request/Page [ First ]
Loop
Set Variable [ $old; Value:GetAsText ( Table::Document container ) ]
Set Variable [ $new; Value:Substitute ( $old ; "/old folder/" ;"/new folder/" ) ]
Insert File [ Table::Document container; “$new” ][ Reference ]
Go to Record/Request/Page [ Next; Exit after last ]
End Loop