Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

Any way to verify that matching import worked?


This topic is 4768 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

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.

Posted

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.

Posted

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...

Posted

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.

This topic is 4768 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

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