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

About

Update: We have been restructuring iMIS Community to give you easier, more intuitive access to the information you need. Most of the top-level changes are done, but deeper restructuring continues. Please let us know if you have problems or ideas for improvement!

How to modify the public view screens for shopping cart - ie: PO# or the words purchase order

I am trying to find the page in public view that says purchase order when going to shopping cart.   I want to change this to CHEQUE.  Can anyone tell me where I can find it/

 

zz

Simplifying browser jumping: Firefox's IE Tab

I've just installed Firefox's wildly popular IE Tab add-on, which promises to make my life easier! The problems:

  • remembering to always open certain applications and sites in IE
  • doing without functionality (such as Window Resizer) I have in Firefox only
  • needing to quickly toggle a given URL between both browsers, for testing

The solution is this add-on that hosts Internet Explorer inside of Firefox and allows you to control which browser context is used for which site. (That is, open the site via FF, and it launches in the right browser; one right-click lets me toggle between browsers.) Sites I run in IE include Sonexis (web conferencing), Outlook Web Access, and the iMIS Full view (.../imis15/admin). Some tips:

Refreshing View Meta-Data

When database schema changes, as it often does during upgrades or customizations, any existing views refering to that schema remain unaltered.  For example, if a UserId field is lengthened from 30 to 60 characters in the schema, any view referencing that field will remain at 30 characters.  The solution to this, short of editing all the views, is to call sp_refreshview on the view.

The following is a little script that can be run on your database.  It will refresh the views for all schema objects in the 'dbo' schema (which includes all IMIS tables).  If you have a lot of tables in your database that exist in other schemas, you may wish to eliminate the clause that limits the script to only 'dbo', in order to ensure everything is refreshed and up to date.  This can be run at any time, and it is completely non-destructive.  If this script throws any errors, it's likely due to the existence of old obsolete views that reference schema that has either been renamed or dropped... you'll have to manually fix such issues by either fixing or dropping the offending view.

Duplicate ecommunity post emails

I have a customer that continually has members and staff receive duplicate emails for community posts. Alot of times it it more than two. Has anyone else seen this problem and if so what did you to resolve. I have other ecommunity sites on this server and I'm not having this problem with the other sites.

Thanks, Terry

[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

Why is this happening?

I am performing a simple display of events. I dont want to do anything more but display them.

So i need a user and i am using a

user = CStaffUser.GetDefaultStaffUser();

it works everywhere else except in this one section where this pops up.

Don't use "ID" as a fieldname in your User-Defined tables!

Be aware -

Re. public & casual view iMIS15.0.3 - don't include a field with fieldname 'ID' field in your User-Defined Tables. Because if you do, and you make these fields available for update in public/casual view, then your clients (and their members) will get the following error on update: "The variable name '@ID' has already been declared. Variable names must be unique within a query batch or stored procedure"

Populating INVOICE table when creating a CRegistration object

Hello,
 We are using the iBO.NET version 1.0.2964.25045 with iMIS version 10.6.30.07 to register users for events and process their payments. When we use the iBOs a row IS NOT entered into the INVOICE table. But a row IS entered into the INVOICE table when using the iMIS desktop application. I have looked at the CInvoice class, but it does not contain a Save method. Can you tell me what I need to do in order to get the iBOs to populate the INVOICE table. I have included the relevant code below.

Great presentation tool for zooming the screen and more

With age catching up to my eyes, I plan to put this on all my machines, so I thought I'd share it.  It is from Microsoft but is unsupported.  It takes almost minimal space (1.2 MB RAM) but very powerful tool.

 

iMIS and eSeries 10.5.28.02 with SQL Server 2005

It is getting progressively harder to find older copies of application software.  Can anyone tell me if it is possible to use SQL Server 2005 with iMIS and eSeries version 10.5.28.02?