Jump to content

HELP! -- Any Tools to Quickly Rename LOTS of Fields?


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

Recommended Posts

Am porting a set of FMP5 files to FMP9.

6,782 field names need to be converted to standard format (e.g., remove $ chars, leading numerics, etc.) I have all the fields in an Excel SS and am planning on cutting & pasting NewName over OldName, but it will be horribly tedious. Is there a third party application that will run on Filemaker 6, 7, 8 or 9 that can make this task bearable?

Link to comment
Share on other sites

You could simply open the Excel file in FileMaker. This will give you the option to convert the first row of the spreadsheet to field names.

It might also be possible to do what you want with Clip Manager.

If nothing else, you could probably make this happen with a macro utility such as iKey.

Link to comment
Share on other sites

THANK YOU!

I could not get the iKey program to work, as it "blew up" when I told it to run a script, but your suggestion gave me the idea to try QuicKeys (After I googled twenty times to remember the name). I downloaded the 30 day free trial and in less than 10 minutes have a script running that does one complete loop from Excel to FMP, using the F3 key -- such a simple blessing!. Now I just have to work up the courage to let it loop automatically!

Link to comment
Share on other sites

It would be nice, but the solution runs everything from inventory to press schedules to time sheets, for three large printing facilities, with full historical archiving. The current number of fields is unlikely to be reduced, however the number of files will be, as some of the related FP5 tables will (someday) be combined into single FP9 files.

Link to comment
Share on other sites

Can't you sue the developer for bad conduct of his trade, and then hire a better one for the revenue gained by the process?? :)

No - Seriously do I mean that an ongoing process where, you normalize bit by bit is the best solution to your problem, the excess number of field doesn't need to get renamed, but instead made to evaporate into thin air ...all fields where a pre/postfix'ed number have found it's way into the naming "convention" ...are likely candidates for this process.

--sd

Link to comment
Share on other sites

This topic is 6137 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
×
×
  • Create New...

Important Information

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