Update file references of container field

[haseebiqbal]

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

[Wim Decorte]

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.

[Lee Smith]

Automatic message

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

[haseebiqbal]

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.

[Wim Decorte]

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.

[haseebiqbal]

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