iMIS Community facilitates the collaborative development of iMIS applications and solutions among the customers, partners, and developers of Advanced Solutions International.

Bulk Insert Committee Records into Activity

Hi,

I would like to know if there is a better way to enter committee and section member information into iMIS.  95% of our Committee and Section members are the same so we would like to try to avoid re-entering them into iMIS manually if possible.  I had tried doing INSERT INTO SELECT statement from a temp table to Activity table but we cannot add new members into iMIS after the bulk inserts.  The error I got was about "cannot insert duplicate key in Activity table.  The primary key for Activity table is "SEQN" and I have also supplied the unique numbers in my temp table.  Not sure what went wrong.   Is there any other tables I would need to watch out for besides Activity table?  Has anyone had a better way to import the activity records?  The "Import Activities" in iMIS can only import records with the same data values, which is no use for us.

SQL 2005 Service Pack 4 & IE 9 - Windows 2008 Updates - Any iMIS15 Issues?

I wanted to ask the Community about the updates below that Windows Update is telling me that I need to install on my Windows 2008 Servers.  I am very diligent about keeping the servers updated with the monthly security patches but I am hesitant to pull the trigger on service pack updates and IE version changes.  I have been burned before with iMIS bombing in some way, shape, or form after a service pack upgrade (be it either to the OS itself or SQL).  I have a two server configuration consisting of a 32bit Windows 2008 iMIS application server and a 64bit Windows 2008 SQL Server 2005/Exchange 2007/Public Web server.  I wanted to check to see if I should install the SQL service pack 4 and IE 9 on the servers and if anyone had issues (or if ASI has reported issues).

One content record on multiple content pages

I would like to create a content record and pull it in to multiple pages. The content record would consists of a set of links that will get updated from time to time. It would be great if we only had to update one content record instead of going into each page and updating it several times.

Is this possible?

Appyling 15.1.3.8850 patch generating error

Trying to install this patch I am getting the following error:

Truncating iMISTable...
TRUNCATE TABLE IMISTable
Bulk-Loading iMISTable... 
SQLState = S1000, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]Invalid format file version

 

Can anyone shed any light?

Method to Set LookupCodeDescription

This was an easy function to use GetLookupCodeDescription.

 

Is there a method to write to the gen_tables?

Is there a BO like

 Asi.Business.BusinessContainer container = new Asi.Business.BusinessContainer();
     Guid groupTypeKey = Asi.Business.Common.GroupType.iMISModuleUsers;         
     Asi.Business.Common.GroupController controller = Asi.Business.Common.GroupController.NewGroupController(container);
     Asi.Business.Common.Group newGroup = controller.Add(groupTypeKey);
     Asi.Business.Common.Group newCommitteeGroup = controller.Add(groupTypeKey);
     newGroup.Name = "My New Group";
     newGroup.Description = "Group for managing contacts";
     newGroup.Commit();

updating a customers record from .net page

I'm working on a project where we pull member data from a view and display on a page inside a sharepoint site. The view pulls Name, Address, affiliation, location, email, web link, and a couple of custom fields. These fields are pulled from multiple iMIS tables. When I try to update the view I get an error stating I cannot update a view that updates multiple base tables. How can I update a customers demographic information? It doesn't appear I can use the membershipwebservice? 

could not start print job

I have a custom crystal report in the Billing module (iMIS version 15.1.3)  which runs a command behind the scene and every time I go to run the report, I’m prompted with the custom parameters but as soon as I select OK, I get an error below:

“Could not start print job”

WCM Document Manager

Using 15.1.3, I'm trying to determine how to modify the allowed file extension types to the Upload utility in the Document Manager.  You reach this while in the Telerik Edit and clicking on the Document Manager icon.  There's an Upload button.  On that screen it also shows you the allowed file types.

I've looked at the web.config file under the \Net folder but that is for Communities and doesnt affect the Doucment Manager.  Can anyone tell me how to modify the Upload file types?

Set Up Relationship types

We are wanting to use Relationship tab and need to input types of relationships.  We are a corporate membership association, so our member is the company, with employees subordinate to that main member type - the company. 
This has been important to mention, in that much of what we have to do in iMIS involves "exceptions to norms". 
MAIN QUESTION:  We have people that need to be listed more than once under related companies.  We would like to not have to show the individuals under each of those companies, so we can eliminate "duplicate records". 
I don't even know where to begin defining and naming the relationship in Set up relationship types.  Much of what I have read about it is for individual membership organizations.... 

Adding explanatory text to Event Registration form WCM

We have recently upgrade to iMIS 15.1.3.8845 from 10.6 and setting up our website with our first event.  On our Create New Account form/page, we have included a number of user defined fields from cutom tables we have in iMIS, demographic questions, options to opt in and out of certain things, etc.  For backoffice deskstop use these fields and their labels make perfect sense to us, but on our form we would like to include some text to explain these more fully.