If you want imported records to be imported in certain order, you have to manually or via script sort your records first
you have 2 options.
One is simply taking the correct pick from the "arrange by:" popup, i.e. "matching names".
I'm not sure you want to read the second one, but here it is, in synthetic form.
have a UUID in both tables, build a "importer database" having one record and one field (I like to call it pivot), link the to be imported db by uuid = pivot, do the same with the destination db but this time set the relationship to allow creating records. You'll end up with a giant spider.
In a script, using eSQL,
- fetch the names of fields from source which are not globals or calcs or summaries (*)
- fetch the uuids from the source and loop on them, setting the pivot to an element of this list
- do a second loop on the field names from the source, getting their value and "setting field by name" in the destination table.
Due to the nature of the relationship, records will be automatically created, matching values will be set and you can forget forever that stupid matching fields dialog.
I do not "classically" import any more, I use this method to import. It may take longer but it can be run on dozens of databases and tables nighttime.
(*) for how to do this I recommend this superb post:
That is exactly the problem.
As you can see from the two screen captures in my original post, I DID reassociate the field names with the new fields. The problem is that the associations do not 'stick'. ie, the next time I run the script, the names are NOT associated.
If you use Save export order it will remember you the order your choose no matter if you add or delete fields
Think big. Think having 100 solutions of different age at 100 different locations and having to import their data into your new version. While the destination table stays the same, the source one does not.