Has anyone found a way to encrypt a fields in a user defined table in iMIS?

I know that a column of data can be encrypted, but wasn't sure how iMIS would handle this.

I am new to the iMIS world. I have a question related to obtaining information specific to an Event order during the order confirmation stage. It seems like it should be readily available in the EventOrderLineData object, but I haven’t been able locate it from the data in the ComboOrderData object that I am retrieving. When the ComboOrderData object is retrieved from the Order Confirmation page it has Lines in it and each line has a Guid called OrderLineId.

Introduction to Problem:

We had a client who moved to another CRM provider but wanted to manage their website’s content with iMIS WCM. The challenges were 1) validating user credentials against the 3rd party CRM when they log in through iMIS, 2) after validation is successful, activate the iMIS website security and 3) add a record in iMIS when the user exists in the 3rd party CRM but not iMIS.

Introduction to Problem:

We had a client who moved to another CRM provider but wanted to manage their website’s content with iMIS WCM. The challenges were 1) validating user credentials against the 3rd party CRM when they log in through iMIS, 2) after validation is successful, activate the iMIS website security and 3) add a record in iMIS when the user exists in the 3rd party CRM but not iMIS.

We are running on a zero inventory model and everytime a customer place an order, we would need to make an upstream order. Quite often we need to make a second upstream order even before the first upstream one has been fulfilled. I am trying to develop a report/query to show how many needs to be ordered from the upstream vendor (I am using Product_Inventory.QUANTITY_AVAILABLE) but has trouble isolating the quantity of the upstream orders that have already submitted to the vendors. Has anyone experienced the similar situation and has any good ideas?

Is there a field that will indicate each and every time a user logs into our website?   That is a table, aspnet_Users which contains, "LastActivityDate", but my 'guess' is that if I go by that, the average visit per users in any given range will always be '1'.      :0(

Any suggestions?  Google Analytics', by the way, has visitor reports that do not provide enough information, as this level of engagement analyis would need to be driven by our database.  Also, even that aside, the level of information that is based on single visits or greater on Google Analytisc has many anomalies.  (This is tangental, but, for instance, if a user visits the site with more than one IP address, such as using mutliple PCs, or a variation of PCs, laptops, and/or  mobile device, Google counts each IP address as a single 'user' visit.  I figure that probably impacts the response distribution around 20% or greater.)

We will be likely upgrading within the next month or so to the latest and greatest 15.2.##, so in preparation, I reviewed the most recently published schema, 15.2.1, (http://www.imiscommunity.com/schema_for_15_2_1).   I couldn't help notice that most of the tables we use were dropped and reincarnated into views. That means I'll be converting tons and tons of scripts from tables to views, and also make updates to Business Objects, iQAs, iMIS Reporting, Crystal Report objects, etc., is that not correct?

Also, with this new version, we should be able to still import our currently existing customized views into the upgrade during the development stage, correct?

We are having iMIS webserver issue, it is very slow and delay responds + hang up with error messages:

1) 08S01: [Microsoft][ODBC SQL Server Drive]Communication link faliure

2) OEProc 1/97 0 - 08S01: [Microsoft][ODBC SQL Server Drive]Communication link faliure

We have iMIS database 15.1.2 with dedicated iMIS app server and iMIS webserver separately, joined with domain server. When I shut down iMIS webserver, this issue is gone. iMIS web server seems to be cause of error, but can't find cause of issue. Our iMIS website is custom built, would code be a issue with this? Any suggestions to where to check, would be much helpful!

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.

Any suggestions on how to promote from dev to test to prod and manage the database without re-keying the configuration please?