Duplicate Merge Manager does not address any of the Informz tables or entries so records merged in iMIS & DMM still exsit as seperate ID's in Informz.

Has anyone run into this issue and created any process or way to deal with these duplicates in INFORMZ?

Has anyone had any problems with INFORMZ tables being dropped (for unknown reasons) and the iMIS system crashing as a result?

I'm talking to an iMIS prospect organization who provides consulting services to their members. They would like to have a time and billing system that would integrate with iMIS. Has anyone created such an application or integrated with an existing application?

Thanks!

Cathy Johnson
Panopea Consulting
cathy.johnson@panopea.com

There are some situations where the prefix + last name form is not proper. Examples:

Sir Paul (not Sir McCartney)
Mother Theresa (not Mother Bojaxhiu)

Likewise there are some situations where you would use either the prefix or designation, but not both. Examples:

Dr. John Smith OR John Smith, M.D. (not Dr. John Smith, M.D.)

I am interested in how people are handling these kind of situations.

I ask because one of the first steps is to 'make sure the 'sp_asi_GetCounter2' stored procedure exists. It doesn't in i15. I SMR'd it and they are checking with Dev on that. In the meantime, I copied it from 10.6 and created it in i15. Here's hoping I didn't break anything. In communication with Informz - haven't heard back yet from them.

Any and all feedback appreciated.

thanks! Joe

This is a replica of a post in the consulting forum.

Has anyone seen or heard of anything that has been developed and / or integrated with imis to allow for product promotions like cross-selling and up-selling between imis modules. The idea is something that is similar to the upsell and cross-sell functionality that exists within orders

Examples of the functionality we are looking for are:

We currently have Informz and would like to begin developing it more on our own by creating custom templates, creating connection to more tables in iMIS and making more fields available for inserting into our mailings. Since documentation on Informz seems to be limited, is there any real development manuals, guides or documents that are avilable out there either from ASI or other users?

Assuming you have installed QAS or Accumail address verification tools into iMIS, when did you last review how it was working? Run a batch check and confirm your accuracy %. Look at the unmatched addresses and see if you can spot a trend as to why they don't match - a specific user, a specific type of customer record, something else?

Or if you don't have one of these tools implemented, maybe it's time to take another look. Accurate addressing saves you time and money. And beyond that, the ability to use address verification data to cross reference advanced MOSAIC and other external behavioural databases can bring a whole new level to your marketing efforts.

All iMIS tables apart from the iMIS .NET tables have a column called TIME_STAMP of datatype timestamp.

Interestingly this column does not tell you when the row was updated, the SQL Server documentation says:

"timestamp is a data type that exposes automatically generated binary numbers, which are guaranteed to be unique within a database. timestamp is used typically as a mechanism for version-stamping table rows. The storage size is 8 bytes."