December 7, 200421 yr I have a database that will be a multi user file. The majority of the information entered into it will be from importing excel files. Many users will need to import into it. Is there a way that I can save the import order so that it is the same for all users? We don't want to have to keep re-mapping. Thanks
December 7, 200421 yr FMP 6 does only have one mapping if someone screws it up, everybody suffers. Have you considered Apple Script, such matters can be stored in separate records, where you choose the import'ish transferes indiviually designed to suit the particular task. But read what Fenton writes about Applescript in calc'fields: http://fentonjones.com/Articles/25_Bookmarks.html --sd
December 7, 200421 yr Author Sorry I didn't make myself clear. I don't want different mappings, I want multiple users, that are connected to the DB at the same time, to be able to enter data in the same order but not have to re-map each time they launch the database. If I need to make a script I will, but not really familiar with doing so. (We will be getting in Excel forms that are being filled out by a diiferent department, and we don't want to key in all of the information. So the easy solution is to import, but the mapping disappears after you close the database. I want it to stay stationary at all times.)
December 7, 200421 yr Once you perform an import, create a script with the Import Records step, having 'Restore import order' selected. Whenever this script is run, it will use the saved mapping. And, yes, FM 7 allows you to specify the import order within the script step and, therefore, save multiple mappings within a single script.
Create an account or sign in to comment