RefreshFM : The import order options we should have
Submitted by Nicholas Orr on 12 August 2013 – 6:29am
RefreshFM 2.0 is finally released and the last update since the beta added a function that has always been a request of mine in Import dialogs within FileMaker Pro itself : the ability to choose “Matching IDs” in the field mapping.
Using this option in RefreshFM, you can create an import order that still works if you delete fields, and add fields, and rename fields from either source or destination table.
This works in RefreshFM because we build the import script ourselves, and with FileMaker Pro 12 there’s a change to the way copy and paste works in that it now respects the order you copy, instead of just switching to “Last Order” like FMP 11 and earlier did.
So we can dynamically build any import order we like. Having a choice of matching names is good, I think having matching ids is even better, and I hope this concept comes into the FileMaker product line at some point. Although an overhaul of the import dialog would be the best outcome, as there’s quite a few other suggestions I’d make for that.