To add to Will's response, you might want to go through your field
definitions and relationships in version 5/6 before you convert, and
clean any non-alphanumeric chars and spaces in those names. The
conversion process will comment out questionable calculations that
worked fine in 5/6. Not only is it difficult to track these down in 10
in the first place, fixing field/relationship names after the fact
won't then fix your broken scripts/calcs. Do it in 5/6 where it still
works and it will change it everywhere it is referenced, then the
conversion in 10 will beautifully match everything up. Personally, I
go for ODBC compliant names - you might be glad you did someday.
After converting you can now see all the obscure file references 5/6
may have inserted into your files. (File:Manage:External Data Sources)
I change all these to file:filename.fp7, as everything I do is always
in the same folder or same server, and simple relative links are
usually best.
A couple of gotchas in scripts:
Go to Related Record no longer necessarily goes to the first related
record. Sort no longer resets the current record to the first in the
found set. Any script that then loops through the found set may not
start on record number one like it always used to. I insert Go to
Record [First] at the beginning of all these scripts.
In 5/6, a script that calls another script in another file, and ends
there, would leave that file as the frontmost window. No longer.
You'll have to insert Refresh Window [Bring to Front] at the end of
these kinds of navigation scripts to insure the target window pops to
the front like it used to.
just those things can save you 95% of the headaches sometimes involved
in 6 - 10 conversion.
btw, FM10 runs just fine on 10.4, but I think they'll want you to get
up to 10.4.11, which shouldn't be a big deal (free upgrade), unless
you know you have other software that won't handle it.
good luck,
Geoff
On Jan 5, 2010, at 3:31 PM, J. wrote:
Odd simple question for this expert group, but I have at least 100
db’s that I’ve developed on FMPro 5.5, and (obviously) need to
upgrade to a newer or newest version of FMPro –possibly advanced.
Question: How many other versions do I need to use to convert these
without manually(!) converting all of them?
If it matters, I’m a Mac user with OSX 10.4.4 and also will be
needing to use it on my laptop with a newer operating system.
Thanks!
Jackie
