Login / Register  search  syndication  about

          Jason Buss' Blog

Jason Buss on SalesLogix development & customization, SQL, and more.

Displaying external data in SageCRM with ASP

In my last blog post, I outlined how to display data from external database in SageCRM 200.  This week, I'm going to do the same thing, but instead of connecting to an external datasource through SageCRM, I'm going to display the data using a custom ASP page.  If you recall from my last post, we had to create a view so that we could include the required channelID field to be able to display the data in the Team CRM area.  One of the benefits of using a custom ASP page is that we can pull directly from the source table without having to add additional data elements.  Also, we have the ability to display this view almost anywhere in SageCRM.  With the other process, we couldn't add the page to Companies (for example) without establishing a relationship between the external data and company data.

First of all, we need to create a simple ASP page displaying the information we wish to see.  I'm going to pull in the same data as I did in my last example:

set conn=Server.CreateObject("ADODB.Connection")
conn.Open"Provider=SQLOLEDB;UID=sa;PWD=CFXPASS;Data Source=crmDev;Initial Catalog=Northwind;"
set rs = Server.CreateObject("ADODB.recordset")
sql="SELECT orderdate, requireddate, shipaddress, shipcity from Orders"
rs.Open sql, conn

<table border="1" width="100%">
<%for each x in rs.Fields
    response.write("<th>" & x.name & "</th>")
<%do until rs.EOF%>
    <%for each x in rs.Fields%>


Save this file as "Northwind.asp".  Once the file is saved, it needs to reside in the CustomPages folder of the CRM installation.  Typically, this is found in "...\CRM\InstallName\WWWRoot\CustomPages".

Now that the asp page is saved and in the correct location, go to the same location we added the other Northwind tab.  This was under Administration->Advanced Customization->System Menus.  Once there, edit the "Channel" tab group to add the new tab.


Set the following properties:

  • Caption : in this case "Northwind Orders ASP" 
  • Action : Set this to customfile.  This will let SageCRM know that this a file in the CustomPages folder
  • Custom File : Enter the name of the custom ASP page. (Northwind.asp)

Click Add and then Save to add the new tab.  That's all there is to it!


This isn't meant to be an ASP tutorial, so the formatting is pretty simple. However, you can see how simple it is to add a custom ASP page to Sage CRM.


Thanks for reading!  Smile

What's This?
Bookmark and Share

About Jason Buss

   Jason is a senior application developer with Customer FX.

Related Content
   Using Global Script functions in InforCRM
I recently had a project that required me to be able to check if a user belonged to a particular team.
Posted on May 05, 2015 by Jason Buss to Jason Buss' Blog
   Better Code Organization for Infor CRM (Saleslogix) Mobile Customizations
When customizing the Infor CRM (Saleslogix) Mobile client, it's common for the ApplicationModule to g
Posted on May 05, 2015 by Ryan Farley to Ryan Farley's Blog
   Index of Posts for Starting with Infor CRM (Saleslogix) Development
The blogs on customerfx.com go all the way back to 2003. There's years and years worth of information
Posted on Dec 30, 2014 by Ryan Farley to Ryan Farley's Blog
   Telnet Sample to Send an SMTP email
I am always forgetting how to test sending an email through an SMTP gateway using the Telnet client. 
Posted on Dec 12, 2014 by Kris Halsrud to Kris Halsrud's Blog
   Problem setting SLXTextbox enabled property / Setting unexposed base control properties for a custom control
I recently had an issue with a Quickform where I was attempting to set the Enabled property of a TextBox
Posted on Dec 05, 2014 by Jason Buss to Jason Buss' Blog


Twitter Trackbacks for Displaying external data in Sage CRM with ASP - The Customization Blog [customerfx.com] on Topsy.com said:

Pingback from  Twitter Trackbacks for                 Displaying external data in Sage CRM with ASP - The Customization Blog         [customerfx.com]        on Topsy.com

August 26, 2009 4:23 PM

Leave a Comment

All contents Copyright © 2015 Customer FX Corporation
Customer FX Corporation
2324 University Avenue West, Suite 115
Saint Paul, Minnesota 55114
Tel: 800.728.5783

  Follow @CustomerFX on twitter
Follow the best news, tips, and articles
  Subscribe to Customer FX on youtube
Watch SalesLogix tutorial videos from Customer FX
Login / Register