Browse By Tags

  • Blog Post: Viewing My Leads on the Interactive Dashboard

    The Interactive Dashboard is a great way to display data. There are many gadgets that you can use and one of them is the List gadget. For example, if I were a business owner and wanted to view a snapshot of all my leads that were in progress as soon as I logged into CRM, then I could use the List...
  • Blog Post: If the Interactive Dashboard refuses to work, this could an error in the JDBC configuration

    The Interactive Dashboard and SData features use JDBC to interact with the database If you find that your Interactive Dashboard refuses to work then it may be a problem with the information in the jdbc properties file. Assuming that your install of Sage CRM is called "crm" then ...
  • Blog Post: An Example Custom Gadget for the Interactive Dashboard

    This is the first a series of articles. Sage CRM allows customers and partners to create new Custom Gadgets for the Interactive Dashboard. Custom gadgets can be used in the both the My CRM and Company Dashboard context. The sample Gadget shows how to make use of the exposed Interactive Dashboard...
  • Blog Post: Security and the SData Gadget and ReadOnly SData provider

    For an introduction to SData REST based web services then please see the article " Accessing SData Provider " Another example of how SData is used in Sage CRM's Interactive Dashboard feature can be found here: " An SData Example – the Sage CRM Interactive Dashboard SData Gadget...
  • Blog Post: What Reports have Charts?

    A customer had a requirement to see which reports had charts associated with them so they could consider them as Chart Gadgets in their Interactive Dashboard. It is not immediately clear from the standard report screen which reports might have a Pie chart or HBar associated with them: To allow...
  • Blog Post: Making an External Table Available as an SData Gadget in the Interactive Dashboard

    Sage CRM has the ability to link to external databases and then allow the System Administrator or Implementor to build screens that look and behave very like system screens. I have written about this before in several articles Linking to 3rd Party Databases Connecting to an External ODBC database...
  • Blog Post: Interactive Dashboard performance can be affected by careless IIS configuration - sanity check every time

    Partners and administrators of end user servers need to know how to avoid some gotchas with the Interactive Dashboard (ID) in the 7.x releases. To help understand how to avoid accidentally affecting the ID performance for the end user, I will outline how it works from a top-level perspective. The...
  • Blog Post: If the Interactive Dashboard refuses to work, this could be a port conflict.

    If another program running on the server has a port conflict with Tomcat it will affect both the Interactive Dashboard and the SData integration with Sage CRM. Errors appearing for SData Provider requests A port conflict for Tomcat would not affect IIS so the main interface for Sage CRM would appear...
  • Blog Post: Creating Groups on Custom Entities in Sage CRM

    I have created a new custom entity called 'Project' using the Advanced Customization Wizard (aka Entity Wizard, Main Entity Wizard). The requirement: The requirement was to be able to use data from the project table in groups used for outbound emails, and within the Interactive Dashboard...
  • Blog Post: Sage CRM and Referential Integrity

    One of the great strengths of Sage CRM is its openness. Its data model is documented and published and available to members of the Developer Program. In some applications relationships between the different entities may be fixed or defined within the database. This is not the case within Sage CRM...
  • Blog Post: What Traditional Context Information is Passed to a Custom Gadget by the Interactive Dashboard?

    Below is an image of a very simple Custom Gadget. The quick answer to the question "What Traditional Context Information is Passed to a Custom Gadget by the Interactive Dashboard?" is nothing! Although the HTML of a Custom Gadget can be produced using an ASP or ASP.NET page, there...
  • Blog Post: Interactive Dashboard URL Blacklist

    The Interactive Dashboard URL Blacklist is a hidden system setting which allows administrators to input a list of banned websites. It specifically relates to the URL/Web Gadget for the Interactive Dashboard. This list can be used to enforce corporate policy, stop the addition of spam sites or to prevent...
  • Blog Post: Creating Interactive Dashboard List Gadgets for Custom Entities

    List Gadgets derive their data from 4 different types of data source Saved Searches Advanced Finds Reports Groups When a custom entity is added to Sage CRM using the Advanced Customization Wizard (Entity Wizard) only the table is created. The default behaviour associated with...
  • Blog Post: Display Google Gadgets on the Interactive Dashboard

    Hi, this is Aisling O'Brien, QA Manager for Sage CRM. In this post I’m going to show you how you can instantly use any of the thousands of publicly available Google Gadgets within Sage CRM's Interactive Dashboard. The whole idea of the Interactive Dashboard is to get Sage CRM users to the...
  • Blog Post: Creating a Simple Custom Gadget

    In this article I am going to explain how to create a simple Custom Gadget for the Interactive Dashboard. The Gadget will show how it can listen to an event in another Interactive Dashboard Gadget, then carry out a task and display the information. The example I will use will be a very simple Gadget...
  • Blog Post: Controlling the Data Passed to Custom Gadgets in the Interactive Dashboard

    This is the second in a series of articles discussing the creation of Custom Gadgets that can be added to the Interactive Dashboard in Sage CRM. In the article " An Example Custom Gadget for the Interactive Dashboard " I mentioned that data is passed to and from Custom Gadgets in JSON format...
  • Blog Post: Creating Groups on External Tables in Sage CRM (E.g. Sage accounting systems)

    The requirement: The requirement was to be able to use data from an external table in a group definition. This will allow data from a Sage accounting system to be used to build groups of Person and Companies that can then be used for outbound emails, and within the Interactive Dashboard as data sources...
  • Blog Post: Pixel Perfect gadget contents with jquery

    I thought I'd share this: so I'm trying to create a custom gadget that displays a map and I want it to resize to fit the size of the gadget in a flexible layout. I needed a method of finding the height and width of the IFrame. It turns out this is very easy to do with some simple jquery. ...
  • Wiki Page: 608-16539 - Unknown scripting language 'JavaScript' error in Interactive Dashboard

    Summary: An error stating that JavaScript is an unknown scripting language may appear when navigating to the Interactive Dashboard. Resolution: On the server, go to Start -> Run . Type CMD then hit Return . A command prompt window will open. In the window that's displayed, enter the following...
  • Wiki Page: 492-16647 - Error creating bean with name 'sdataServiceMetaDataStore'

    Summary: Following an upgrade to v7.1 SP1, an error displayed on interactive dashboard: The Dashboard has experienced a problem. Please contact your system administrator. Browsing to the SDATA schema URL will result in a 404 error page being returned from the Tomcat web server. The following error appears...
  • Wiki Page: 636-17026 - An error occurred when attempting to process the Gadget

    Summary: Sdata gadget not working in Sage 300 ERP integration when used for company information. Symptoms: When creating a new gadget based on a sdata list(Sage CRM sdata feed) and using the company entity the user recieves the following error message: "An error occurred when attempting to process...
  • Wiki Page: 632-17097 - Main Menu Item Dashboard Gadget not functioning because of a customfile menu option

    Summary: After creating a new find menu option (using a customfile) the Main Menu Items on the Interactive dashboard stop functioning and the user also cannot create another Main Menu Item dashboard gadget. Symptoms: When a user goes to a Main Menu Item gadget the following error is shown: "An error...
  • Wiki Page: 492-17112 - Mail merge error with IIS autologin

    Summary: An issue with mail merges may arise when IIS autologin is enabled. Symptoms: The following error message is displayed in the Sage CRM logs: "User with a username xxxx not found in CRM" "User not logged" This issue is caused by Tomcat attempting to check for an active user...
  • Wiki Page: 492-17121 - RSS Gadget - Basic authentication error

    Summary: Adding an RSS feed gadget to the interactive dashboard may throw an error if the feed site has Basic authentication enabled. Symptoms: On creating an RSS feed gadget on the Interactive Dashboard, the gadget displays the following error message: An error occurred when attempting to process the...
  • Wiki Page: 636-17127 - Interactive Dashboard Chart Drilldown Query

    Summary: Interactive Dashboard chart gadget with auto hyperlinking are opening summary screens inside a Gadget window. Symptoms: When a gadget is created based on a report with autohyperlinking activated and the drilldown is selected for the gadget to run a report when clicked, the hyperlinks for some...