Not sure about item #1, but for item #2, this could be possible without the use of a 3rd party editor if you have FileMaker Advanced.
Since you can't copy and paste into an editor, what i have done in the past is run a DDR report on the database including only scripts. You are then able to copy the script from the DDR into any editor you would like and do your find and replace. If you are using MS Word, you could then copy / paste back into the script.
On problem #1, why the change? Does everyone need a unique IP? It looks like from your screen shot that you are changing the location of your FileMaker Server. Why not just send an email with the new link to everyone? Once they connect, it'll be retained and available in their recent connections list. From the File menu, select Send, then Link to Database.
Since you're on Windows, there are a number of software/OS deployment programs out there that can push registry entry changes, etc., to an office of computers, but you're looking at typically tens of thousands of dollars for complete systems. There might be some little app out there that will look for and update a registry entry though.
Running the DDR from FileMaker Pro Advance would help you find what you're looking to replace. There is also a tool out there call 2empowerFM that might help, but I've never used it myself.
For Problem #2, you might want to take a look at 2empowerFM Developer Assistant. You can't do a search and replace, but you can search of all your scripts to find the specific script steps that need to be changed.
Audrey Akhavan ❦
President, FM Magic, Inc.
Certified FileMaker Developer
FileMaker Business Alliance Member
FMPugAZ/FMugAZ Chapter Coordinator
2010 FileMaker Excellence Award for Evangelist of the Year | 2009 Mad Dog Award Winner
Phone: 602-410-0578 | Fax: 602-532-7136
The ip address that i have in the picture is from our production environment of our payroll database. We currently have a development environment, which we recently did not have. Since we are now running the payroll in the production environment, we have to point the development ip address to the development server in SQL Server 2005 development environment. We were trying to see if there was an easier way to just change all 40 or 50 ip addresses from the production environment addresses to the development addresses so that the payroll process will not break when we run it. My supervisor is going into each script and doing this manually.
For #1, yes & no,
Yes - you can create a global variable (.g., $$FILEPATH ) with the path - set it in your startup script (global variables are session specific - you could even store the data in a field and call it on startup) and then change all of your script steps to use the global variable. This would be wise, so the next time you need to change the file path, you will only need to change the global variable one time - either in the startup script or the field, and then it can be used everywhere.
The end result would look like this:
Set Variable $$FILEPATH [your filepathhere]
But no, you can't script replacing the current path with the global variable, so you will have to go through all the scripts (see #2) and make the change.
For #2 - I use 2EmpowerFM's Developer Assistant - it allows you to quickly search for a text string in any script - I just tested it with a file path and it found the step and highlighted it for me. From there, I can paste the new step and continue. Much quicker and easier than a DDR, and it is less than $100 for the tool which you will use constantly.
Hope that helps
Thank you so much!!
For #2, Clip Manager by myFMbutler will allow you to copy all the steps in a script, extract the XML from the clipboard, find and replace within the script, then paste the modified steps back in to FileMaker.