blog

Replace SQL

I need your help. I have been tasked with a project of updating Address_1 and Address_2 in the Name_Address table. I found some script that will work but ran into a snag and need some help.

On a test table, I ran the following script to correct an address of 105 Drake Dr

UPDATE tempjohncross
SET Address_1=(
REPLACE (Address_1,
'Dr',
'Drive'));

The script fixed the record as 105 Driveake Drive

Adding Java to ContentArea1

Below is Java Script that my organization would like to add to our website. It is nothing fancy just links to print, post to facebook , email content, etc. I can get this to work in plain html, but fails to work when I put this in WCM editor. Any help would be greatly appreciated.

<!-- AddThis Button BEGIN -->
<div class="addthis_toolbox addthis_default_style ">
<a class="addthis_button_preferred_1"></a>
<a class="addthis_button_preferred_2"></a>
<a class="addthis_button_preferred_3"></a>
<a class="addthis_button_preferred_4"></a>
<a class="addthis_button_compact"></a>
<a class="addthis_counter addthis_bubble_style"></a>
</div>
<script type="text/javascript" src="http://s7.addthis.com/js/250/addthis_widget.js#pubid=xa-4df60b4b7cf5b867"></script>
<!-- AddThis Button END -->

Business object designer error after creating object with wrong Properties.

Hello, 

I have created a business object in BOD and somehow saved it with the wrong properties and published. Now when I try to open BOD from iMIS I am getting following server error:

---------------------------------------

Server Error in '/iMIS15' Application.

MaxLength applies to string data type only. You cannot set Column 'DecisionDate1' property MaxLength to be non-negative number.

 

Business Object only returns column names.

The SQL returns 3 rows and the rows shows an array of 4 rows including the field names.

Normally the ds would be filled with a data adapter.

 

private DataSet getCommitteeCodesObject(Guid transactionID, string credentials, string error)
            {

                DataSet ds = null;
                Asi.iBO.ContentManagement.CWebUser user = null;
                try
                {

SOA bindings and 'rest' service

A couple questions.

1) The SOA services are setup by default with a netTcp binding. I noticed right away the configuration changes they had made (amazingly high maximum lengths), and I'm wondering if there's a listing of other example bindings anywhere, say for SOAP connectivity.

(If not, I'm just going to continue with the plan of modifying a base configuration, which I assume will be fine, but having worked with iMIS ...)

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();

ASP.NET MVC Web site authenticating against iMIS Membership Web service

We have a number of custom administrative tools that we're moving into a separate, internal-only, Web site.

Currently the applications use their own ASP.NET authentication tables, but it would be ideal to leverage the information contained within iMIS directly. Not single-sign on, but sign-on validating against iMIS.

Since we've already got the site setup, I wanted an addition that would impact the site as little as possible. For that reason, I decided to first look at the Membership Web services - methods returned by the service and some detail on http://www.imiscommunity.com/use_the_membership_web_service as well - and see if we could successfully leverage that.

Duplicate a Committee

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

How to get high-quality images out of Visio (especially if you need them to make PDFs)

While Visio makes great diagrams and flow charts, it does not make great JPGs (or really, any other file formats other than their own VSDs.) I've struggled with needing to make PDFs from annotated JPGs created in Visio, and the resulting PDF looked grainy and blurry. After some digging on the Internets, I found a forum post made by a Microsoft employee who works on Visio, and discovered that Microsoft knows their JPG converter is terrible (even if you are saving them as 100% quality) and that the best way to get a high-quality resulting image is to save it as an EMF file. You can then paste the EMF file into Word (where it looks great), or use Word to create a PDF (also great).  Problem solved!

Syndicate content