Hello, Michael. "Last Order" is the last order the fields were imported. It's usually the default when you perform an import.
You haven't described your exact problem. What does "doesn't seem to be working very well" mean?
I basically use this import when I'm sending the client an updated
database. It has not records, and runs an import to pull the records from
the client's old database when launched. I have found that Creation Order
is the most reliable way to run this. But recently it hasn't worked too
well, so I was wondering there was some change in FM12 or 13.
Please define what "hasn't worked too well" means. Are the fields not lining up correctly? Are some records not importing? What exactly is the problem?
Yes, Mike, exactly. The fields were not being imported correctly (since it
runs automatically, I only see the results).
What do you mean, "not correctly"? Are some fields missing? Are the data coming into the wrong fields? Are you receiving any errors during the import? Are records being skipped?
Data gets imported into the wrong fields.
I never use 'creation order', because these can be very different if you are sending a new version of a file. If the field names are exactly the same, use 'matching names'.
What Beverly said.
To get around that I just don't delete fields. But I sometimes do rename
them, so that wouldn't work. But maybe I should try that...
Thanks for you help, Beverly and Mike.
as long as you name them the same on both copies, you're ok.
deleting fields is what gets you into trouble (along with creating fields) using other imports. Unless you clone a copy of the file, you can't be sure the fields 'match' without using "matching names". Still this can be fraught with problems for "interface changes updates".
Michael wrote, in part:
One thing I find confusing is when I look at the script is says Arrange By: "Last Order".
Keep in mind that the import also should be scripted to run without dialog, or the users will also see this "Last Order" option selected.
The opening of the dialog, which allows users to pick an order or rearrange one of their own, causes the saved default order to disappear, even when scripted.