We help IT Professionals succeed at work.

How do you change a file name within a database with multiple files without affecting the relationships scripts?.

tombstoneproductions
on
303 Views
Last Modified: 2010-04-27
I am working on a database with multiple files and I need to change the name of one file to a different name. How can I do that without affecting the scripts or the relationships?  I was also wondering if there was a way to do a multiple find and replace that would search all fields and scripts within a database or at least within a file.  

I have tried to go in and manually change every instance that I can find but I still run into situations where the relationship is lost.  I tried pointing to the new file after receiving the dialog that the file could not be found but that didn't solve the problem.  There were still missing links and graphics.

I am working with Filemaker Pro 9 Advanced on a MacBook Pro.

Thank you in advance.
Comment
Watch Question

Commented:
no trick to locate the names except making a html design report (needs the advanced version) then searching in it.
as far as replacing it, normally ext files are referenced, so if you change filepath/names there but keep the ref name, your scripts should be OK. (file/manage/external data sources)
An exception I think is for import and export actions where the filename is hardwired in scripts; my advice for these is to use variables declared at startup; this way, if several scripts use the same name, all you have to do is alter the startup script variable definition. OF course this does not apply to your exusting file
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Commented:
true, I forgot this one, long time I did not convert a fm6 set of files where that was a real need.

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.