RiSE Registration Badges

Is there a way and/or a workaround to capture guest badges for RiSE registrations? I realize there is an "Add Guest" option, but we do not want to create a new record for the guests. My only thought for a work around is to create two questions for the Spouse/Guest Registration function (one being First Name, the other being Last Name), then writing a script to write those values to the Order_Badge table once the registration is submitted.

Incorrect Syntax near 'WHERE' error when Online Membership Application tries to Save Contact.

I have this error only in my UAT environment. When the online membership application is attempting to do the Contact Save, it encounters this error. As it happens there is the dll which has the Contact.Save initiated and it throws the error.

It is working perfectly in Dev & Production, but not in UAT.

System.Data.SqlClient.SqlException: Incorrect syntax near the keyword 'WHERE'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Asi.iBO.DataServer.ExecuteNonQuery(CommandType commandType, String sql, SqlParameter[] commandParameters) at Asi.iBO.ContactManagement.CExtTable.SaveTable(DataServer server)
at Asi.iBO.ContactManagement.CExtTable.Save(DataServer server) at Asi.iBO.ContactManagement.CContact.Save(DataServer server, Boolean validate, Boolean flowDown, Boolean useTransaction)
at Asi.iBO.ContactManagement.CContact.Save(DataServer server, Boolean useNewTransaction) at Asi.iBO.ContactManagement.CContact.Save(DataServer server)
at Asi.iBO.ContactManagement.CContact.Save() at Avion.EMAN.EMAMember.SaveContact(CContact contact, String InstitutionId, String CustomeTypeCode, Boolean IsKeyContact, IiMISUser user)....

Mobile phone app authentication against iMIS


I'm trying to support the business who wishes to have a mobile app developed that will authenticate users against our iMIS database before it will show them the mobile app's content.  (In this case a version of our monthly member only publication).

I'm aware of the instructions on imiscommunity on how to integrate third party sites with the requirement to have them both on the same domain.  (e.g.  We have this set up locally with a third party web content management system installed locally that integrates with our local iMIS environment.  In order to get this working we created a new full user in iMIS that handles the authentication, rather than using the MANAGER account.

Imis Activities not visible in staff site?

In Imis, there seems to be a possibility to store “activities”. In this piece of the documentation!activitytypeswindow1.htm a description is given about how to configure activity types.
When I log in into the staff page, and find a person through “find contacts”, I am able to create a activity of the type “call” on the history tab. I also see that the activity is stored in the ACTIVITY table in the database.

Product category user defined fields in RiSE


We have a client who is currently on eCM and using the eSeries store, and they're making use of the user defined fields on some of the product categories. They're going to be transitioning to RiSE, and they want to continue using the user defined fields, but I'm not seeing any iParts that pick these up. Is there any way to have the Product Display iPart pull in UDFs, or are there any other iParts that make use of them?


SQL query to set paid through date?

Some of our member records have blank paid through date and this cause incorrect member count report.
what is fast way to enter mass Individual membership paid through date. All expiry date will be same for current 2014 members, 12.31.14.
I like to use SQL query and run mass update for 2000+ Individual record's paid thru date.
Is there SQL query to set for this? e.g. member type equal to xx and paid thru date 12.31.14

Overriding order line data pricing in cart based on member status


I'm looking for easiest way to override member pricing based on their status e.g. if member type for cart owner is Full Member and their status is Inactive they should be billed Non-member prices not Member price.
Currently I'm seeing two options:

- Using Special Pricing in the product with 'Amount from filed' based on status
-Overriding order line items in custom control in cart checkout page. Using PartyItemPrice query to get non-member pricing.

Renewal Fees and late fees calculated at renewal time, not before

We are upgrating to v20 very soon and would really like to add the ability for the user to change their status at renewal time (i.e. from practicing to non-practicing). However, the dues amount is different for the different statuses. At the momnet the invoice charges are generated yearly and the amount generated is according to their current status. When they want to renew if they need to change their status they have to call or email and we have to change it in the admin screen, reverse the original invoice and generate a new invoice for the amount for the new status. We really would like to have it that they can change their status when renewing and the amount is derived at renewal time according to the status. an additional kicker is that we have a series of asp pages that they must work through to verify and update various data elements in order to complete their registration per regulatory requirements.

Communities vs. Committees

Does Communities replace Committees or how are they related? How do we access Communities? Under Community all we have is Dashboard, Find Contacts and Add Contact. We are on iMIS 20.1.14. Thank you.

How to retrieve profile image file name

In the mini profile iPart of iMIS20, users can upload an image of themselves, if this feature is enabled.  By default, these images are stored at /net/images/profile.  Each file seems to follow the format id#_random#.jpg (or gif, or png, or bmp, presumably) or id#_random#_T.jpg (gif, png, bmp).  An example for someone having the id of 61525 might be 61525_489866.jpg.  My question is whether this file name is referenced in any of the iMIS tables.  If not, how does iMIS know which file to use when displaying a person's profile?  I was hoping to reference that file name in an IQA.  Can the name be derived through some formula?  I also thought about writing some code that populated Name_Picture.Description or maybe a custom table with the file path.