Thank you for your post.
Yes, the field mapping import will remain for the session. However, when the file is hosted, the default imports are now with the server; not the client.
Instead, you may want to create a script with the correct field order. Then, you can call the script at any time and the import order is restored.
OK, tahts great thanks. I guess that the script would need to run before the excel file would be imported? Do you know of an example that I could look at?
With a little work I think that this could solve this problem, but.......
The database I have also uses a 'unique' number for logging the entries. This needs to be reset each year of logging entries. So, the logical thing was to use a global field to hold this number, then press reset at the beginning of each year to put it back to zero. However, when on the server, because its now hosted, the global won't reset. Is there a way to reset a global on a hosted server?
You import with this script.
For global fields, as I remember, was some restrictions in calculations, Take a look on Help or documentation.
If you use The Global as auto enter, reset auto enter Next serial too.
I found a way to reset global fields on the server without having to take them down and open them with FMP:
Write a script that sets the value for you as you want.
Create a schedule in server that runs this script.
Use the "run schedule now" option to run the script.
Since FMS scheduler runs this script from a "host" context, the changes to any global fields will "stick".