Author Archives: greysagecrm

Directly Log In to Case Summary Screen for a particular case in Self Service

In CRM, URL of a Case’s Summary Screen will look something like given below. “http://localhost/crm62/eware.dll?&Act=281&Mode=1&CLk=T&Key0=8&Key1=43&Key2=57&Key8=46″>” If you will paste this URL into browser and then hit the Enter Keyword, CRM login screen appears. After entering the User Name and Password, when you click on the Log On button, it will redirect you to Case Summary… Read More »

Sage CRM with Sage Pro Multi Company

Coming quickly on the heels of Pro Web order entry in Sage CRM was Pro multi company integration. Like Pro Web order entry, this too uses the existing Sage CRM and Sage Pro connection. I do not want to sound like Nicolas Cage search on another treasure hunt but this was possibly the missing piece… Read More »

Change Default Language/ Date Format in SQL

Usually in SQL, date gets saved as ‘2009-07-27 00:00:00.000’ but when we run the query or call date from any application the SQL gives us the date in desired format like ’07/27/2009’. How does it work? SQL has set of formats according to the different languages for example ‘British’, ‘Dutch’, ‘German’, ‘English’ etc. By Default… Read More »

Time-Out Error while Importing Bulk Data

Have you ever tried importing Bulk Data in SageCRM and received Time Out Script error? Despite of SQL settings there is one more area where we need to check if everything is ok or not. Metabase.XML If you have IIS 6 installed with your system; you will get this file at systemroot System32 Inetsrv folder… Read More »

File to PDF conversion using FOP

FOP i.e. Formatting Objects Processor is one of the very efficient print formatter driven by XSL formatting objects. It is an application which is based on JAVA that reads a formatting object tree and then converts it to the desired output format according to the requirement and parameters we specify. The formatting object tree can… Read More »

Custom Search Screen should retain results when user navigate away from the search screen and return to it

As per the standard Sage CRM functionality, Company (any Standard Entity i.e. Person, Communication, Lead, Opportunity, Cases) search screen retains results when user navigate away from the search screen and return to it. Bur this is not applicable for any custom entity search screen. Custom search screen does not display search results when user navigates… Read More »