It's sometime useful to search an entire database to find out where some specific data is... for instance, you entered data into the UI but you aren't sure where it got stored.

This post contains a SQL Script to search a database for any specific string in any column in any table in your database.

To use this script, simply edit the first line to set the @value variable to the string you wish to search for (see the comment).  You can include "%" as the standard SQL Wildcard character.  As is, the script will search for any string starting with "C:\" ... but you can use exact strings or any arbitrary string you wish.

Hello All,

I have a rather large committee that I'd like to replicate (with a different name) within iMIS 15.0. Is there an easy way to do replicate/duplicate committees in iMIS?

Thanks
Shawn

This is a stored proc to take an input URL with a query string and split out the URL and the individual query string parameters.  For example, if you're considering a URL like this:

http://localhost/imismain100/iMIS/ContentManagement/Template.aspx?ContentCode=SimpleEventEdit&UniformKey=72290518-44b9-428b-909d-10142b4b6b9f&PreserveStatefulBusinessContainer=true&ButtonId=ctl00_TemplateBody_WebPartManager1_gwpste_container_SimpleEventShowcase_ciSimpleEventShowcase_EventShowcase_RefreshButton&ParentPageInstanceKey=ae6cfeb2-21c7-4221-a2e1-43d5e6c5b097&WebsiteKey=d30229f1-d53b-48d7-99ae-d0ce9fea621d&TemplateType=E&DialogCacheParam=0.9562794873612177

I've just started testing the SOA in C# and have successfully developed the add person function and added the other items such as informal name, prfix, suffix etc. Now I'm trying to add address and other informatio about the person but having very little luck. I'v been reviewing the documentation but found it to be a little confusing. Could someone just point me in the right direction or maybe furnish some real world examples.

I'm trying to use the sysresHashPwd function to return a value in SQL thinking that this may be the function that is hashing the Password field in Name_Security. When I use the following:

SELECT dbo.sysresHashPwd ('password')

I receive the following message:

Error in Initialize(): 429

So there are 2 questions:

1. What can I do to work through this error so that I can use the sysresHashPwd function?
2. Is this the function that iMIS uses when it hashes passwords?

Brad Cady

We need to access data in custom tables--not built-in tables that come with iMIS or user-defined tables (UDT’s), but plain old tables that we write in SQL and place into the iMIS database.  Although the iMIS application itself will leave these tables alone, they are used for custom development that involves integrating with iMIS.  Otherwise, they are plain old sql database tables.

We’ve ruled out using Business Object Designer to create Business Objects to access these.  Is better to access these custom tables with stored procedures or with an ORM tool such as NHibernate or Entity Framework?  Will the fact that these tables are in the iMIS database and the fact that these are used for custom development to integrate with iMIS cause one or the other to not work, or otherwise have any problems?

Morning,

Has anyone had any experience with attaching a file to a Customer Activity record using a stored procedure?

We use TaskCentre to run a stored procedure to generate activities for emails but would like to start adding a pdf version of the email as an activity (the same way iEmail does).
Before I go down the road of trying to write it I wanted to see if their was generic code floating around.

Here are the .rdl file and the export of the query related to my forum entry.

This is the message i get when trying to insert a new activity to Manage Committees and when converting an order to an invoice.  I am not sure if this is the proper place to post it or if is is related to the SQL server or something else.
WinIO/63 2627
23000:[Microsoft][ODBC SQL Server dirver] [SQL Server]Violation of PRIMARY KEY contraint ‘pkActivitySEQN’.
Cannot insert duplicate key in object’dbo.Activity’. 01000:[Microsoft][ODBC SQUL Server Driver] [SQUL Server]The statement has been terminated.

Hi I had a question about subreports and iMIS.  I created a subreport but I am having trouble accessing it in iMIS.  I created the report and subreport with 2 different VIEWs and granted both of them access to iMIS and uploaded them to iMIS.  When I click on the report, it loads up fine, however, I can not click on the subreport.  It looks like a link but it does not let me click on it.  Does anyone know how to get around this?