Jump to content

Changing the path for a referenced file


This topic is 5785 days old. Please don't post here. Open a new topic instead.

Recommended Posts

We currently have a database with thousands of records, each one with a container field containing a reference to a file on our OS X Panther Server. We'd like to be able to upgrade the server at some point and possibly change its name and IP address. Is there a way to run a calculation on every record to update the referenced file path to reflect the files' new location on the new server? We're an all-Mac shop and we're open to using plug-ins if that will make the job any easier.

Link to comment
Share on other sites

Yes, it's possible and not too difficult. First, make yourself a calculation field cOldPath (result is Text) =

YourContainerField

Next, make another text calculation field cNewPath, where you substitute the old path parts for the new ones.

Finally, define a calculation field (result is Container) =

cNewPath

When you get the calculated container to show the files, you can change it to type Container, then delete all the other fields. A backup is recommended before starting this.

Link to comment
Share on other sites

This topic is 5785 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.