after I make changes via the nav designer, what do i have to do to have the changes take affect?
I am attempting to use the nav designer to control who gets to use some of the items in system setup. I have assigned a role to the items of sys admin if i don't want the user to see it and I have added a product manager role to the user and assigned it to item I want them to see. It doesn't seem to lock the user out of the sys admin items.
Tools
using nav designer for left hand items
SQL Function for credit card number decryption in iMIS15 and SQL2005
There is a continuing need for a SQL Function or equivalent to decrypt credit card information from iMIS.
Of course there is an overall security concern, but there still are frequent requirements by customers to have a method to decrypt credit card info, beyond the standard reporting in iMIS.
I have done a little research on this. There is just a little info on it in www.imiscommunity.com.
Usefull C# code. How to find an IMISID of currently logged in user.
Hi All,
Recently I run into the issue of where(how) to find iMIS ID of currently logged in user in iMIS Public views.
After some research I finally come up with folowing code:
// VERY USEFULL ONE - Returns iMIS ID for currently Logged in USER
private string GetCurrentiMISID()
{
string _id = "";
if (Request.Cookies["UserID"] != null)
{
Task Centre Documentation???
I purchased a license for Task Centre to handle some subscription and dues business rules. We have successfully installed the application and it appears to be connected to iMIS, but the tasks we created cause iMIS to crash. We were starting with a simple task when a UD table was updated to run a script. The help listed in the GUI does not have much useful information, it just write out in sentences what its doing rather than explaining what it's for, and the online documentation takes you to iMIS community but there's nothing on iMIS community.
Populating Public User Passwords
When switching to a new website most clients want this to be as "seemless" as possible for the members. We would like to populate the public user username and passwords with the values they already know. eSeries allowed this type of functionality with a process to populate the username and password, however the public view does not. Has anyone developed a process to do this for the public view? I am thinking some webservice or stored proc could be leveraged to cycle thru exsisting passwords in a table so that they coulld be encrypted and then stored correctly in iMIS ready for the public view to use. Open to other thoughts or ideas too....
Development Mode
Hi all,
I was wondering if there is an option to enable E-mail redirecting to a single account to prevent Customers in the database from receiving test E-mails?
Thanks.
Creating Crystal Reports that insert data - Example Member Card tracking in Activity
Sometimes a custom Crystal Report is needed which does not use the iMIS search dialog boxes. This is usually the case when there are nested queries and multiple joins.
This solution was created to permit the generation of a Member Card export that inserts an Activity recording the generation. Because we did not use a search dialog, we could not use the option PRINT_CREATE_ACTIVITY.
So...
I based the report on a stored procedure. The key is that you must do the insert part of the stored proc before you do the select for the data.
Analytics: Tracking: Content Record Breakout
We are a small trade association with one heck of a lot of content (www.steel.org). We are struggling with our web analytics. We've experimented with Urchin, Google Analytics, etc. We are running into issues with breaking out the traffic via content areas. I've seen other topics on this, but no real resolution. I would like to pose a couple of questions:
1) what do you use for web traffic measurement with your eSeries CMS site?
SQL functions
Here are a couple of sql functions that some clients have found useful, expecially in Crystal reports.
Note that these functions can cause some performance degradation, but usually worth it for the simplification it gives to the reports by for instance, not having to add gen_table multiple times
SET ANSI_NULLS OFF
SET QUOTED_IDENTIFIER OFF
GO
create function [dbo].[fn_Relationships]( @ID varchar(10))
Tweaking your machine's settings for improved high-speed bandwidth
For the last few weeks, I've been running with Windows registry settings tweaked by the TCP Optimizer program. The TCPOptimizer.exe program sets a collection of apparently widely-known registry settings that 'open up the pipe' on the client side.
I'm currently running with Windows XP Professional. If you are running Vista, I can't help you. ;)