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,

We are working on uprgrading to iMIS 15 and have a dedicated iMIS 15 test DB server. We want our end users to test the iMIS 15 Client but when we install the cilent software on a workstation that has iMIS 10 Client software, the iMIS 10 software no longer works with a "Page cannot be found" error. Re-installing the iMIS 10 software brings that software back to a working state but the 15 software does not work. ASI support indicates this is not supported. Has anybody figured out how to get the 2 software versions to co-exist on the same workstation?

I am currently working on converting a new customer to iMIS 15. They have a couple hundred items and some have multiple categories. When I attempt to insert the data into the dbo_OrderProductCategoryLookup table I get duplicate keys. Nothing gets inserted so there must be another table getting populated. Any idea what tables need to be populated so the customer doesn't have to do the setup for eac

Hi,

We received the following problem from a customer and was wondering if anyone could suggest a fix or offer some insight. At this point in time I do not know if the customer has applied any of the updates.

Thanks!

Deb Cain

-------------------------------------------------

I have updated our iMIS test environment from version 10.6 to version 15 and we are also using E-series with that. Our clients normally join through our chapters and the chapter will then send us a paper form with their information. We then enter that information hear at headquarters.

Frequently, customers have a previous website where they have logins and passwords they would like to preserve in a new iMIS based website.

The following is sample Coldfusion code on how to access the new i15 MembershipWebService and user the RegisterWebUser method to load logins and passwords into iMIS in bulk.

This can also be modifled to replace the Generate Logins functionality of e-SEries by pre assigning logins and passwords based on a formula.