Jump to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Stored Import Mapping Changes when Field Access Changes

Featured Replies

I'm not sure if this is a bug, but I've come across a troubling issue with the import mapping being different from what I set for accounts with limited (no access) field access. I don't believe this was an issue in FM6, but it seems to be consistent in FM7, FM8, and FM8.5.

In the attached example, with access to the Salary and Hourly Rate field restricted for the "User" privilege set, if that user tries to run an Import of that file, the stored field mapping is lost for the Name field with was created after the Salary and Hourly rate.

It is understandable why this would be. Since those two fields aren't visible, they shouldn't be selectable in the Import dialog. But since this is a stored Import mapping, it would be nice if it still worked for all the fields the user can see.

The real danger here is not knowing about this so you can work around it (with lookups or something). Someone might go through and add such field access restrictions after the interface and import scripts are all set up, and not check that their imports work correctly for every field with every privilege set.

So does this sound like a bug, or what?

To see the example, login with Account: Admin, Password: admin

ImportMapping.zip

  • 1 month later...

I wonder if the order would be preserved if you set the script which contains the import function to run with full access privilege?

Create an account or sign in to comment

Important Information

By using this site, you agree to our Terms of Use.

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.