Across Boundaries - ( Cipto )

How to Debug CRM 2011 Plugin

cipto — Fri, 10 Feb 2012 06:33:36 GMT

Well there are a couple of ways and steps of doing it.

Like putting it in sandbox, enable it by registry editing.

and than attach debugger….

But it turns out you could do something like Die in PHP.

just throw new Exception(“Trace message”);

and you should see it when you Trigger it correctly

Share this post: | | | |

How to Capture WCF/HTTP Post using Fiddler on IIS server

cipto — Wed, 08 Feb 2012 06:14:50 GMT

This is very interesting. as I’ve got to examine whether a call is being made to a Services/WCF on external site.

on Localhost Fiddler which capture everything correct. because fiddler run under your local account.

If you test on IIS, it’s different though . Worker process run under network service.

you can change it to whatever. but that is a hassle, so complicated.

Since it’s during post back than call services.

When we do simple enabled Fiddler on firefox. it will just set that browser proxy to 127.0.0.1:8888 where Fiddler listen to.

But that is not enough it’s not capturing what are being post and what are the external UI.

The best approach is by adding on web.config

You can now see on fiddler

http://www.west-wind.com/weblog/posts/2009/Jan/14/Monitoring-HTTP-Output-with-Fiddler-in-NET-HTTP-Clients-and-WCF-Proxies

Share this post: | | | |

iTextSharp

cipto — Tue, 07 Feb 2012 09:12:45 GMT

iTExtSharp is a port from java iText. an open source to export things to PDF

you could actually export HTML to PDF. it’s very powerful as you can generate on the fly. just a bit of twist you can make report with PDF, or export things to PDF.

since PDF is like vector based. it’s very scalable meaning when printing it can scale to your preferred page size.

unfortunately there is not enough documentation. and the java thing seems to be a bit different in .Net one.

I am using the latest at this article is written, it’s 5.1.3. You could have the iText documentation in Java, or books like iText in action second edition.

things change a bit in property name. like to set the PageEvent actually it’s on writer.PageEvent=[your custom event]

To Export from HTML to PDF ,follow this pattern. this is also example for adding footer.

public class GeneratePDFHandler : IHttpHandler
{

    public void ProcessRequest(HttpContext context)
    {

        context.Response.Cache.SetCacheability(HttpCacheability.NoCache);
        context.Response.Cache.SetExpires(DateTime.Now.AddDays(-1));
        CultureInfo culture = new CultureInfo("en-AU");
        string ReferalID = context.Request.QueryString["id"];
           
        string contents = File.ReadAllText(context.Server.MapPath("~/template.htm"));
        // Create a Document object
        iTextSharp.text.Document document = new iTextSharp.text.Document(iTextSharp.text.PageSize.A4, 50, 50, 25, 25);
    
        // Create a new PdfWriter object, specifying the output stream
        var output = new MemoryStream();
        var writer = iTextSharp.text.pdf.PdfWriter.GetInstance(document, output);
        writer.PageEvent = new MYPdf();
        // Open the Document for writing
        document.Open();
       // var logo = iTextSharp.text.Image.GetInstance(context.Server.MapPath("~/Images/IoptixxGray.gif"));
        //logo.SetAbsolutePosition(10, 10);
        //document.Add(logo);
                   
      contents = contents.Replace("[Name]", "Cipto");
      var parsedHtmlElements = HTMLWorker.ParseToList(new StringReader(contents), null);


       foreach (var htmlElement in parsedHtmlElements)
           document.Add(htmlElement as IElement);
      
       
      
       document.Close();
       context.Response.ContentType = "application/pdf";
       context.Response.AddHeader("Content-Disposition", string.Format("attachment;filename=WorkOrder-{0}.pdf", ReferalID));
       context.Response.BinaryWrite(output.ToArray());
  }
}

Template.htm as you might guess has the html and a marker to be replaced in above example it’s [Name]

public class MYPdf : PdfPageEventHelper
{
    public override void OnEndPage(PdfWriter writer, iTextSharp.text.Document document)
    {

    Rectangle rect=new Rectangle(50, 50, 545, 792);
    var footerfont = FontFactory.GetFont("Arial",8);
    ColumnText.ShowTextAligned(writer.DirectContent,
    Element.ALIGN_CENTER, new Phrase("My Footer Message", footerfont),
      (rect.GetLeft(0) + rect.GetRight(0)) / 2,
      rect.GetBottom(0) - 45, 0);
    }
}

For images you can add logo. or embed it in your html template. but the source must be a full internet URL

Share this post: | | | |

CRM 2011 SDK explanation Part 1

cipto — Sun, 05 Feb 2012 13:54:00 GMT

if you are some one that is sitting between CRM 4 sdk, and 2011 SDK. you'll end up and should upgrade using the 2011 one.

Because 2011 support lot's of fix, improvement, easy to use API than 4th version.

since CRM 2011 use WCF there has to be lot's of improvement, also from the size compression being transported.

CRM 2011 SDK support backward compability,as when it deals with CRM 4. it point to the old asmx services , 2007/xxx.asmx

use organizationservice.LoadProperty to load your Lazy load relation property, for example invoices_products

CRM 2011 support Federation Authenticaiton/Claim based authentication.

You only need to use the crmHelperClass and provide username and password with out domain.

Solution is major improvement in 2011. a lot of thing are being simplefied because of this.

on 4th version you've got that metadata thing. but Solution means you can package you custom entity, Plugin and import it again to another CRM instance

Plugin also being enhanced. Now after you install the Developer Tools. which comes with the SDK

You'll get Solution template, Plus CRM Explorer. Plus when developing Plugin/Workflow you get what they called CRM Package, right click and Deploy :)

You'll get Default class called Plugin which provide you with localContext, you can access the servicecontext,organizationcontext,entity here.

It's a very good one, because now you can implement Base plugin for multiple entities, before you need to create class and another class

It's also recommend to deploy it to your Solution. that way when you moved from staging, to prod server. you only import the solution

the CRM 2011 service is also supporting for you to upload your CRM through SDK

most easy to use is Early bound, generate it using CRMSVCutil which will generate strong type for you.

to make sure things is there or not. think of solution.

CRM 2011 use WIF

LINQ to FetchXMl service request is deprecated

Share this post: | | | |

Google map is so god damn easy

cipto — Sun, 05 Feb 2012 13:51:00 GMT

Google map v3 is very easy to implement. it will take you just minutes to create great application

it's HTML5 and mobile compatible also. sadly again not showing on IE7.

You could add Markup , and "Controls" to the map . so that the map take 1 full screen, and your control (html element)

are shown as you choices, on top left, center , bottom right as you like.

you can change icon easily by defining the icon. so cool

all you have to do is have the geocode location.

like on mine it needs filter by post code, so search through the geolocation, set center and zoom in

Share this post: | | | |

Ninject and customMembership asp.net mvc 3

cipto — Sun, 05 Feb 2012 13:43:00 GMT

you use Custom Membership and Ninject and inside your custom membership you'd like to use Property Injection.

The result is always null. why? because asp.net has it's own static property for membership.

which is membership.provider. and this instance is not part of instance ninject management.

to workaround it , you need to use kernel.inject . but on the generate aspnetmvc.cs you would see that it's injection on PreApplicationStart event and won't let you.

so use on PostApplicationStartMethod

[assembly: WebActivator.PreApplicationStartMethod(typeof(TopRankFantasy.App_Start.NinjectMVC3), "Start")]
[assembly: WebActivator.PostApplicationStartMethod(typeof(TopRankFantasy.App_Start.NinjectMVC3), "RegisterMembership")]
[assembly: WebActivator.ApplicationShutdownMethodAttribute(typeof(TopRankFantasy.App_Start.NinjectMVC3), "Stop")]

public static void RegisterMembership()
        {
            bootstrapper.Kernel.Inject(Membership.Provider);
        }

Share this post: | | | |

TSQL Tuning again

cipto — Tue, 31 Jan 2012 07:15:18 GMT

Today I face another tsql tuning.

basic but simple any column that are in join clause and that column is not foreign key . it has no index on it.

So create index on it. and you could use Include Index. which means that column is part of overall index.

the joined column , say you have 3 columns may not over 900 Bytes. int is 4 bytes, and Nvarchar (Starts with N is unicode) it’s multiple by 2.

Example:

CREATE INDEX IX_PTN_Prescription
ON dbo.PTN_Prescription (PTN_FrameHasLensesID)
INCLUDE (PTN_ContactID,PTN_MemberDetailsID)

Another thing is see how you join, and see if it resulting on a lot of logical read. Joined only to indexed column.

when you use Like , Like ‘%’+search+’%’ is heavier that starts with (Like search+’%’)

Case sensitive or not, is set in database . so you need not to use LOWER

View are not indexed by it self . several steps needed so it’s column is indexed

--Set the options to support indexed views.
SET NUMERIC_ROUNDABORT OFF;
SET ANSI_PADDING, ANSI_WARNINGS, CONCAT_NULL_YIELDS_NULL, ARITHABORT,
    QUOTED_IDENTIFIER, ANSI_NULLS ON

CREATE VIEW [dbo].[ViewName]
WITH SCHEMABINDING
AS

--Create an index on the view.
CREATE UNIQUE CLUSTERED INDEX IDX_VFRAME 
    ON VIEWNAME(COLUMNA, COLUMNB);

Lastly To test your query execution Time and IO. you could use

--Free plan cache

DBCC DROPCLEANBUFFERS
DBCC FREEPROCCACHE

SET STATISTICS TIME ON
SET STATISTICS IO ON

For statistics IO , scan , logical read, what are the meaning of the result returns

go here

Optimization Detail

Index can be Filtered

Share this post: | | | |

CRM 2011 Improvement

cipto — Sun, 13 Nov 2011 03:30:56 GMT

CRM 2011 has 500 bug fixes from the latest CRM 4.0.

if you see that it took Microsoft 3 years to really released this 2011 version, than you know that there are major improvements

Interface
Connections
Custom Activities
Recurring Events
Goals and Goal Management
Processes
Auditing
Team Record Ownership
Field-Level Security
Improved Outlook Integration
Dynamic Marketing Lists
Data Management
Solution Management
Mobility
Web Resources and Azure Integration
SharePoint Integration
Dynamics Marketplace
CRM SDK,XRM
Azure Extension
New Plugin Architecture

I’m going to drill down each of this in subsequent posts

Share this post: | | | |

Oracle ODP.NET

cipto — Sun, 13 Nov 2011 03:21:11 GMT

Oracle has shifted it’s Newest oracle 11g to a new DLL, and it’s using the efficiency from ado.net and other stuff.

Despite like that it has lack support in Enterprise Library, and you might want to define new database by your self or just use direct oracle client.

The previous one system.data.oracleclient will work for Oracle 9-10g. and for 11 , you have to use this ODP.NET. One main problem that I encounter is the lack of deployment support.

if you want to deploy your application , you have to install oracle client on client computer. that is about 233 MB or more. and that is huge.

Oracle has this XCOPY which meant to be , you just copy your dll to someplace and it should run, but it’s not.

there are lot’s of setting and error on this oracle environment thing

so although you already did what they told us to , Detail

still no luck, Try this and that a lot (copy folder,env variable,c++ runtime).
I get Oracle Exception "The provider is not compatible with the version of Oracle client".
It's because odp.net also have not so good Error message, everything that goes wrong will pop up this message.
have look on the related forum also.
So what I did for last try is to install the ODTwithODAC112021 32 Bit version.
I select the Client one.set it to c:\app .
Download Here
it works

Again what a hassle it is.

Share this post: | | | |

Prevent Caching on Jquery Mobile Page

cipto — Mon, 03 Oct 2011 10:07:04 GMT

when you inject page dynamically using

$page = $('#dynamicpage');
$header = $page.children(":jqmData(role=header)");
$content = $page.children(":jqmData(role=content)");
$footer = $page.children(":jqmData(role=footer)");
$header.html(dynamicp.HeaderTemplate);
$content.html(dynamicp.ContentTemplate);
$footer.html(dynamicp.FooterTemplate);

And jQuery mobile will use that linking page. when you go to that page first time, everything is good.

but when you click go back, and go to that page again. all the formatting,themes,css is gone

what happened is jquery will cache your page based on your hashed url,on the page container.

Simply removing it solve this. this come from this solution . we add the attribute data-cache=never . which will trigger remove it on pagehide

and to create new page is simply like this

so in combination we would Save the original template before it’s processed.

the correct event is pagebeforecreate of the home page. and when removed, we Append it again to the pageContainer.

var originaltemplate='';
$(document).bind("pagehide", function (event, ui) {
    //Remove the Element here, to Trick down Themes Not loaded/no css
    var currentPage = $(event.target);
    //Wohoooo patch
    if (currentPage.attr('data-cache') == 'never') {
        currentPage.remove();
        var id = currentPage.attr('id');
        debugger;
        //append to page container
        switch (id) {
            case 'dynamicpage':
                $(originaltemplate).appendTo($.mobile.pageContainer);
                break;
             ...
            }


    };
  });
$(document).bind("pagebeforecreate", function (event) {
    var currentPageid = $(event.target).attr('id');
    //save it on homepage init, because other is dynamic already although raw html
    debugger;
    if (currentPageid == "homepage") {
        debugger;
        originaltemplate = htmlInclusive($('#dynamicpage'));
     }


});

There you have it all works

Share this post: | | | |

Javascript Namespace and Module Pattern

cipto — Sat, 10 Sep 2011 02:17:00 GMT

I’ve just got a chance to review this Book “Java script Pattern”, the author is the SA of Yahoo, as you might guess YUI.

For ages we know how to make Namespace in JS, but making as a function , that rocks.

I’ve only quick look on Chapter 5.

//Declare the root and namespace function

var Myapplication = Myapplication || {};
Myapplication.namespace = function (ns_string) {    
var parts = ns_string.split('.'),        
parent = MYAPP,        i;   
 // strip redundant leading global  
 if (parts[0] === "MYAPP") {     
   parts = parts.slice(1);   
 }   
 for (i = 0; i < parts.length; i += 1) {        // create a property if it doesn't exist   
     if (typeof parent[parts] === "undefined") {         
   parent[parts] = {};      
  }        parent = parent[parts]; 
   }    return parent;};

//to get the module example

var IneedModule2=Myapplication.namespace('Myapplication.Order.module2');

//Declaring dependency on top of function declaration,So that when minified it doesn’t break

var myFunction = function () {
    // dependencies
    var event = YAHOO.util.Event,
        dom = YAHOO.util.Dom;
    // use event and dom variables
    // for the rest of the function...
};

Way of creating object , could use regular function constructor, or wrap it in immediate function

//using function for creating object

function Gadget() {

    // private member

    var specs = {

        screen_width: 320,

        screen_height: 480,

        color: "white"

};

    // public function

    this.getSpecs = function () {

        return specs;

};

//Creating Object not using regular function

//can we still have private memberS?

//everything inside closure by making immidiate function is private

var toy;

(function () {

 // private member

    var specs = {

        screen_width: 320,

        screen_height: 480,

        color: "white"

};

    // public function

    toy= {

    getSpecs :function () {

        return specs;

};

}());

Passing in globalobject and application to consume locally

var GLOBALUTILIY={d:1,e:2};   
var MYAPP = MYAPP || {};
MYAPP.utilities={};
MYAPP.utilities.module = (function (app, global) {
 
    // references to the global object
    // and to the global app namespace object
    // are now localized

}(MYAPP, this)); // DIRECTLY CALL IT passing GLOBAL as THIS(global scope)
                   // Passing MYAPP as app;

You can all read a long , how to declare other thing on that chapter by your self

Share this post: | | | |

CRM 2011, Could not load file or assembly Microsoft.Crm.Sdk, Version=5.0.0.0

cipto — Wed, 07 Sep 2011 02:42:21 GMT

If you had a previous application from CRM 4 SDK., running on a Server which has CRM 2011 installed, this message appear.

although you have the CRM 4.0 SDK.dll In your bin, it will still look for 5 th version.

the reason is the publisher policy file, told it automatically use the latest one when encountered this dll.

if you still want your existing app to run on that box,the solution is to turn it off

<runtime>
    <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
      <dependentAssembly>
        <assemblyIdentity name="Microsoft.Crm.Sdk" publicKeyToken="31bf3856ad364e35"
         culture="neutral"/>"
        <publisherPolicy apply="no"/>
      </dependentAssembly>
    </assemblyBinding>
  </runtime>

Share this post: | | | |

Using CRMSvcUtil

cipto — Mon, 22 Aug 2011 04:50:00 GMT

To generate the Early Type Bound we need to generate the entity class.

How to use this tool?

go to setting –> Customizations –> Developer Resources

Here is where you get your services URL, since Service can be separated on different Machine

this is super Important

the Organization UniqueName, Service Endpoints.

like the Discovery, Organization Service, Organization Data Service.

what you need on CRMSVCUtil is the Organization Service.

like wise other SvcUtil, is the authentication parameters : /d /u /p /d.

/out : outputfilename

/namespace:

/serviceContextName:

we can output this command during build on vs,but CRM has options for late bound type.

this autogeneration is separated to different tools, it was previously integrated I think. because

this generating slow down the performance

You could also add an extension to what is being generated.

you could include the customization dll, like on example /codeCustomization:"Microsoft.Xrm.Client.CodeGeneration.CodeCustomization, Microsoft.Xrm.Client.CodeGeneration"

Share this post: | | | |

Working with XMLReader on Sencha Touch

cipto — Tue, 16 Aug 2011 13:44:00 GMT

We all should start by including senchatouchdebug.js, or w/comment.js. so that we can read the code and put breakpoint on it to trace better.

On SencaTouch or Ext js, we all work with Data , and it’s all related to these components:

Model, Store, Proxy, Ui Controls(List/NestedList/HTML/Carousel/Form).

Model

Model can have Mapping , custom Convert function.

Model can have association, hasMany or belongTo

Mapping

consider this xml Structure

Don’t use the TotalProperty or SuccessProperty for your custom mapping

Store

Store is a way to Save your Result, it can store to html5 storage, or on memory on your js objects and it cache it for you or not

Store.ClearOnLoadPage : clear the result when movement/navigation happened

Store could have Proxy in it, and proxy can have reader in it.

Proxy

Proxy have several type : Memory, Ajax, ScriptTag,Server,SessionStorage,WebStorage

Reader attached to Proxy : is the way how to read your result is it XML or JSON

XTemplate

Powerful templating. Could use custom Js Function , passed in the Values

ex:

var tpl2 = new Ext.XTemplate('<div class="shoutoutdate">{[this.formatDate(values.dateadded)]}</div>',
 {
compiled: true,
formatDate: function (datetime) {
                try {

                    var date = parseXmlDate(datetime);
                    var datestring = '';
                    var monthNames = ["Jan", "Feb", "Mar", "Apr", "May", "Jun",
                    "Jul", "Aug", "Sep", "Oct", "Nov", "Dec"];
                    var name = monthNames[parseInt(date.getMonth())];
                    datestring = date.getHours() + ':' + date.getMinutes() + ' ' + name + ' ' + date.getDate();
                    return datestring;
                } catch (e) {
                    alert(e);
                    return datetime;
                }
            });

, basic IF

Ajax

Manual ajax is using Ext.Ajax.Request

Decode

JSON using Ext.decode ex: Ext.decode(response.responseText);

Select XML Nodes using :Ext.DomQuery.selectNode(‘Xpath’', XMLRawData); ex: Ext.DomQuery.selectNode(‘Xpath’', store.proxy.reader.xmlData);

Nested XML/JSON

You have Nested XML , with Many Childs. use Association on Model

use the Has Many, already working.

Ext.regModel('Order', {
        fields: [{ name: 'example'}],
        , hasMany: { model: 'product', name: 'products' }

This will Create Nested Store , there is store inside store, Bind it during the Store load callback or datachanged or what ever that is related.

Hint

Mapping is Xpath, so you could use ex:‘Root>Products>Product

for XML the Server Output Content Type Response must be : “text/xml” or “application/xml”

Mapping on XML is case sensitive

Read the API ,Property events related

Trick

To control the Proxy Parameters is using extraParams property. and set it before load of store

During Mapping to XML Attribute which is defined by ‘mapping:@AttributeName’ on Model, I found error ‘DOM Exception 12’ and this is solved by using Patch

To override control UI , use the baseCLS

AddCLS will add the main class root, override with !Important

To theming use the recommended sencha way, Saas

To override a control to looks like another control use the baseCls

everything in Extjs is related and oop , Hierarchal & Nested structure. think what you want for Layout Root inside of it Items inside Items can be other nested Layout,

whether root is panel,carouse,tab, inside of it could be HTML,Vbox,HBox.

Check out Sencha MVC with phonegap

Point of View:

“Looking at Phonegap and Future windows 8, Using Javasript You can create Native App, that is crazy, Javascript Could be the next Cross Platform language”

Share this post: | | | |

Printing using Window.Print and CSS

cipto — Thu, 14 Jul 2011 07:32:00 GMT

Ok perhaps this is a bit old. but worthed to be noted.

at first thought would like to print using the telerik reporting print preview.

but You could print using the regular HTML and defined own CSS applied only when printed.

to print simply call window.print();

the next question is , how can we defined and add css which is only when printed .

simple case i don't want my print image button being printed.

the answer is by using your own css. just specify the media="print" not "screen"

this will told browser the css for printing is that one.

there you can set your #printbutton{ display:none }

you could set the Font of each element etc, do more, example is like the blueprint css framework, the Print.css

Share this post: | | | |