can someone explain this error to me?  I'm trying to figure out how to find the duplication so i can correct it.

Importing Contacts into new tables ...

*** ERROR importing contacts ***

Violation of PRIMARY KEY constraint 'PK__@InsertKeyMap__56E4FB26'. Cannot
insert duplicate key in object '#55F0D6ED'.
Msg 2627, Level 14, State 1, Server OHIO, Procedure asi_Name_Insert_Update, Line 501

We currently have a 10.6 installation running on Windows Server 2003 and SQL2000. We have built a new server environment on Windows Server 2008 R2(64-bit) and a new Sql2008R2 installation. We intend to install 15.2 in this new environment.

What steps do we need to take to accomplish this? There doesn't seem to be a direct path to do so. I'm assuming we'll need to upgrade to some lower version then upgrade again to 15.2. The question is how we go about accomplishing this in the environment described above.

thank you,
paul Chesney

We have a client who's moving from eCM to WCM (10.6 to 15.2). I'm running a migration test and running into a series of errors (some of which I've overcome/fixed, one I'm still stuck on). Outside of the information on iMIS docs, is there any other documentation on the tool?

I've run the tool a couple times (for multiple clients) and I think it has some wonderful, time-saving qualities. Each attempt has shown a different derivation of success. I would like to get some more background on it though and especially during these troubleshooting times, more information would benefit me tremendously.

In eSeries ColdFusion there was a Header file that we used to look at a variety of variables and then redirect the user to an appropriate web page.  If the membership was expired, redirect to a custom Membership Expired page with a link to the Bill Dues page.  If heading for Events registration and a non-member, redirect to a custom Select Non-member Type page to select and set a registration class.

I put together the attached chart as a quick reference for my activity imports into iMIS 15.1.  It maps iMIS activity field names with the prompts on the activity setup screen. Others may find it useful when using the iMIS 15.1 Data Transfer Utilities > Import Utility. 

Hi people.

In 10.6  our users run an ADHOC query to identify which records they have touched during the day to produce labels to post out their results..

In this case the Name_Results_Summary  table where their username is entered into the table in the updated_by field.

Here is the username element fo the adhoc..

Name_Results_Summary.UPDATED_BY = Substring(user_name(),1,Case when charindex('_',user_name()) > 0 Then charindex('_',user_name())-1 Else len(user_name())End )

Hi all.

Here I was looking for an item on how to modify a menu item. The search engine reported all sorts of data but none about my subject matter until I found one on task list item.

The same article is here in iMIS community. It was the next comment that put me on to the right track. Site navigation module..

Well i found the answer and am impressed.. Yes it does not happen often but 15.1 has done that for me.

Posted this issue in the blog but though it might fit well here in the Forum.

Problem
I initially logged the issue we were having working with the latest 15.1 release. The issues presented itself when using an existing DB and upgrading in a test environment. Installing with a demo database worked fine but using a 15.0 DB and upgrading presented this .net error trying to load the web view (Shown below). The error indicated it could not find the site map node. This turned out to be misleading. After many installs and re-installs on both a demo and upgrade I resolved the issue.

The way user logins are handled and stored has changed in iMIS 15.1

In this new version of iMIS, all your users (logins in the Name_Security table) will have matching records in the UserMain table. Importing all these users into UserMain can have a snag though: it's possible for there to be the same login ID in Name_Security as one already specified in UserMain. That is, two separate logins could exist with the same login id. This is no longer the case.

We have upgraded to iMIS 15.0.3. All user information from 10.6 came over ok but when trying to provide other users with an iMIS logins and clicking on the "User Credentials" button on the Customers page an error occurs after about a minute saying "Error - Page Unavailable". this happens to Customers with and without exisitng iMIS logins alike. If anyone has any ideas it would be appreciated.

Thanks,