Browse by Tags

• ASP
• ASP.NET
• Button Group
• clone
• COM
• custom captions
• custom_tables
• Data Type
• dates
• Email
• eWareQuery Object
• External Database
• Fields
• Import
• Include Files
• Key Attribute Profiling
• Oracle
• Person
• Phone Numbers
• Self Service
• SQL
• Stored Procedure
• StoredProc
• Web 2.0
• Web Services
• Workflow
• XML

• Add/Subtract Days to a Date and pass to a Record Object

  This article has been updated.(again 14th April 2009) Dates can be a bit of a challenge. This article explains three points: how to convert a record’s date field value into a JavaScript Date object. how... Posted Apr 14 2009, 12:05 by Jeff Richards with | with 4 comment(s) Filed under: COM, Record Object, dates

• Linking to 3rd Party Databases

  Within the Administration screens is the location that allows the System Administrator to create an additional database connection to a 3rd party database. Administration -> Advanced Customization ... Posted Mar 31 2009, 11:14 by Jeff Richards with | with no comments Filed under: COM, custom captions, SQL, custom_tables, eWareQuery Object, Record Object, External Database, Oracle

• The Sage CRM StoredProc Data Type

  This article has been edited to include extra information and to bring the code up to date with the coding standard introduced with Sage CRM 6.2 In the default system the StoredProc datatype is used to... Posted Feb 26 2009, 04:00 by Jeff Richards with | with 2 comment(s) Filed under: Self Service, Record Object, Fields, Data Type, StoredProc, Stored Procedure

• Getting the Database DataType for a field

  The code example in this article has been corrected and brought into line with the coding standard introduced in Sage CRM 6.2 Occasionally you may be faced with a requirement to know what database datatype... Posted Feb 25 2009, 09:05 by Jeff Richards with | with no comments Filed under: SQL, eWareQuery Object, Record Object, Data Type

• Musing on Key Attributes and Workflow

  Is it possible to use Key Attribute Data in workflow? Now there is a question! At first sight the answer would be no. Workflow rules are either controlled by a JScript condition or in the case of escalation... Posted Feb 25 2009, 02:40 by Jeff Richards with | with 1 comment(s) Filed under: Workflow, SQL, eWareQuery Object, Record Object, Key Attribute Profiling

• Cloning a Person and assigning to a new Company

  This article has been updated based on feedback from a partner. As a result of a conversation I had with a colleague at the Asian conference I have uploaded a sample ASP page that shows how you can clone... Posted Feb 10 2009, 03:23 by Jeff Richards with | with 2 comment(s) Filed under: Email, ASP, COM, Phone Numbers, Record Object, Button Group, Person, clone

• More about XML creation and the Record.XML property

  Another way of creating XML feeds from Sage CRM is to use the XML property of the COM Record object. The XML property is available in all currently supported releases of Sage CRM (Sage CRM 5.8, Sage CRM... Posted Jan 27 2009, 04:10 by Jeff Richards with | with no comments Filed under: ASP, Record Object, XML

• Creating XML feeds from Sage CRM

  The inclusion of additional software components created in Flash or Silverlight within the Sage CRM interface is becoming more common. Very often these are little units of Ajax code or embedded objects... Posted Jan 22 2009, 07:18 by Jeff Richards with | with 1 comment(s) Filed under: ASP, Web Services, eWareQuery Object, Record Object, ASP.NET, Web 2.0, Include Files, XML

• Using Code to Import Data in a on Premise Installation

  The links in this article have been corrected. Problems will arise with any code that does a direct insert into a table. Where possible inserts from external data sources should use the CreateRecord API... Posted Dec 31 2008, 10:00 by Jeff Richards with | with 2 comment(s) Filed under: ASP, COM, Import, eWareQuery Object, Record Object

• More thoughts on the Web Services and the StoredProc datatype

  The StoredProc data type only will fire when a record object is added to a screen object. Specifically this must be a new record. The actually firing of the StoredProc is tied to the loading of the interface... Posted Oct 13 2007, 10:00 by Jeff Richards with | with no comments Filed under: Web Services, Record Object, StoredProc