Knowledge Base

iMIS Integration - Frequently Asked Questions

  • Updated

This article provides answers to some of the questions that are most frequently asked when working with the Higher Logic Thrive Marketing Enterprise (Thrive Marketing Enterprise) iMIS integration.

If you have an issue, review this article to see if there's a recommended solution or workaround.

Frequently asked questions

Question Answer
Why can't I see my IQA in the list of available lists? Did you set up the IQA? See Add iMIS IQAs to the Real Magnet Groups Table.
Why am I getting this error message?

"The getCustomDemographicMetadata reply for the query “Query/List Name” does not contain required “ContactId” field. API returned [{“DataType”:”String”,”FieldName”:
”QueryResults”,”Prompt”:
”QueryResults”,”TableName”:””}] metadata"

There are two possible reasons for this:

  1. The ContactID is no longer present for the IQA. To resolve this, ensure the IQA has the iMIS ID aliased to ContactID. If the IQA is no longer required, delete the upload job in Thrive Marketing Enterprise.

  2. A failure was encountered via the SQL server. The Thrive Marketing Enterprise integration is typically installed via the App Server – meaning the App Server must be able to run this IQA via SQL. To resolve this, log in to the App Server and run the view/query in question. Typically, the query may not complete due to the time at which it is scheduled and it is competing for resources, or there is an error with the query.
Why am I getting a "Missing Field" error?

Ensure that the fields are present in the AdHoc Query, IQA, or SQL view – generally, this means an individual removed the field from the iMIS list type.

To resolve this:

  1. Return the field to the query in iMIS,
    OR
  2. Remap the upload job.
  1. If a new field was created or removed from the query, you can select Settings > Integration Settings > iMIS Management > Edit the Upload Job > Map a new field to the Real Magnet Field > Select Create Schedule >Select Submit If the query is no longer needed – you can then delete the upload job.
Why did my query only pull over half of my results? Did you put in a sort order for that query? Typically, the results for the query are ordered by the iMIS ID; these results are then paged via the integration. If there is a sort applied to a field like an expiration date, for example, the results are no longer ordered in a way that maintains their order via paged results. Remove the sort order of the query and re-run the upload job.
Why is there an error message when I attempt to import an IQA or SQL view? Your IQA or SQL view must contain the column CONTACTID.
Why is there an error message when I attempt to import an IQA? Your IQA name cannot contain a / –: This will alter the path (location) of the IQA, resulting in iMIS being unable to retrieve the path successfully to export or to update the Thrive Marketing Enterprise bridge. Simply remove the slash and re-save the IQA.
My adHoc query contains a complex calculation, will the bridge accept it? No. At the moment, the Thrive Marketing Enterprise bridge does not properly handle ad-hoc queries used as calculations if they have sub-select queries in them. The same results can be easily handled through a SQL View. With a little more setup, this could be done with an IQA query as well.
Why are there multiple opens or link clicks in my recipient's activity history? Thrive Marketing Enterprise reports gross opens and clicks.
Why is tracking data not syncing to my iMIS?

Did you select tracking data? Login to Thrive Marketing Enterprise and:

  1. Select Settings.
  2. Select Integrations.
  3. Select iMIS Management.
  4. Select Manage Tracking.
  5. Select the tracking items to sync to iMIS.
Why is this individual record missing tracking information? Ensure that individual is assigned a ContactID. If the individual was uploaded outside of the Real Magnet Scheduler, you must ensure that it also has its ContactID mapped to the Custom Member ID. This is how the iMIS platform identifies that individual in its database. If an individual is missing this information, no tracking information will push back for that recipient to iMIS.
Why am I getting this message?

"This upload job has one or more groups to which you do not have access."		 Do you have access to the group? If your account is Enterprise, you'll need to ensure that you have access to the group the Upload Job is connected to.
Can I change what Member Type a record is created as in iMIS? Yes. You can make this change by going to General Lookup/Validation > RealMagnet_Settings. You will want to change the table: Prospect_Member_Type, the value in Description must match an existing member Type.
Why can't I see the Sync On Send option when sending a message? You must at least have Read Only Access for integration upload jobs in order to use this functionality.
What happens if the tracking data portion is canceled mid-stream? Thrive Marketing Enterprise logs the failure and re-attempts to send the data through to iMIS.
What happens if I am using Internet Explorer? Due to Internet Explorer's security configurations, as part Thrive Marketing Enterprise’s compatibility steps, we recommend:
  • Adding magnetmail.net to Trusted Sites
  • Using Compatibility Mode
Server was unable to process request ---> There is an error in XML document (1,337) ---> Instance validation error: 'PasswordExpired' is not a valid value for LogonResultCodes The error is related to the Manager password for iMIS. If this value gets changed, it must be updated in the Webservice Configuration file by ATS, help@atsol.org.
Was this article helpful?
0 out of 0 found this helpful
Return to top

Can’t find what you’re looking for?

Create a Case Call US Support