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.

Any way to verify that matching import worked?

Featured Replies

I am importing and updating mutilple records based on "Matching" an UID. Was trying to stay away from creating an additional import table. Was wondering if there is a way to identify when a matching record is not found. Tried setting error code on, but get no error whether the matching record is found or not.

Found set will be empty if no records match (unless the "add new records option) is selected and new records are imported.

Not sure why the error code is not working: it should.

  • Author

That made sense.. but I am getting Get (LastError) =0, Get (FoundCount)=0 whether there is a match or not.. Running the import in a loop..

#IMPORT RECORDS

Set Error Capture [On]

Import Records [No dialog; $path; Client_Import.xsl; Update matching; Windows ANSI]

#Check for Matching Company ID

Show Custom Dialog ["Error"; Get (lastError) & Get (FoundCount)]

If [Get (FoundCount)=0]

etc...

  • Author

Found the issue, like I said, was using a loop and forgot to include a "Show All Records" before the import.. because after the first one.. it would only have that single record.

Thanks Vaughan.

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.