- Fixed the File References in my product.
- Built a Conversion Issues report for it.
Both of these functions are excellent with the second providing more value to me than the first.
FIXING FILE REFERENCES
Prior to FileMaker Pro 5.5, you couldn’t specify that you only wanted relative file references which are great because if all your files reside in one folder, then you can move that folder anywhere and none of the file references break. Prior to 5.5, less robust file references like IP addresses were stored and, worse, the references weren’t directly accessible for modification. They are in FM7, but even so, the manual method can’t compete with MDM’s file reference powertools.
There’s an *auto-fixer* that will eliminate all references to files outside your solution *and* convert and set your file references to *relative path only* – all the rest go away. I ran auto-fixer without a hitch in less than 2 minutes on my complex 27-file Studio Manager product. That’s time savings!
I had tons of file references in these files and was left with the minimum I need to have things work correctly and as fast as possible. I’ll let you know when I try the performance out how much performance gain I get in FM6 and FM7.
FINDING CONVERSION ISSUES
Whoa! This thing is amazing! New Millenium has identified a total of 82 different possible issues so far. I had 23 of them applicable to my solution. Of those 23, 18 were considered high impact and 7 medium impact. You get a brief description of the element that is causing the issue and then a potentially multi-paragraph description and pointers directly to the files impacted in your solution so you can go fix them right now.
I was tempted and on the verge of converting my Studio Manager files to FM7 without doing much cleanup in the hopes everything would be OK until I ran this report. Here’s just the first 3 of 23 conversion issues found:
(42) Go to Related Record button function
(216) Go to Related Record Script step
(25) External subscript transfer focus to another file
Ack! Those numbers in parentheses beside each issue are the number of occurrences of that issue in my files. I’ve got some serious work to do. It will be easy work with this information and tool but it will be a lot of work.
Luckily, I will at least have a hope in hell of doing the fixes in an organized way and I can run the report on my files to see where I stand in handling the issues. There’s a checkbox that lets me tell it to ignore that issue for now which I bet will come in handy.
FREE STUFF ALERT
You get the Conversion Issues database free when you download the trial version of MDM2. There’s a lot of information in there. Go forth and download!