slxdeveloper.com Latest Articles

Generating Table IDs in T-SQL

Jason Van Pee — Thu, 22 Apr 2010 23:05:12 GMT

Generating SalesLogix IDs outside of SalesLogix can be a challenging concept. Third party applications go through the SalesLogix OLEDB provider and call the "slx_dbids" function to generate an ID for the specified table. The problem with this approach is that I don’t want to go through a third party application to insert records into my SalesLogix database. This article will look at how to generate SalesLogix table ID values using the .NET CLR in a SQL Function and call via T-SQL.

Author: Jason Van Pee
Category: External / SalesLogix OLE DB Provider

Read article...

Customizing Group Panes/List Views/F8 Queries

RJ Samp — Thu, 15 Oct 2009 22:00:00 GMT

We’ve talked about being able to ‘do stuff’ based on a user selection of the Groups, or the group itself.

Author: RJ Samp
Category: Architect / SalesLogix VBScript Articles

Read article...

Setting up a Multi-Byte Environment for SalesLogix

Matt Dockins — Fri, 29 Feb 2008 19:52:18 GMT

Setting up a multi-byte environment for SalesLogix is a fairly simple process, but there are some items to take into consideration for a sound deployment on a global basis.

Author: Matt Dockins
Category: General / SalesLogix Administration

Read article...

Creating a Crystal Reports Custom Function Library

Ryan Farley — Fri, 21 Sep 2007 18:34:19 GMT

You don't always have to massage your data with complex formulas to report on it. Complex calculations in a report can be difficult at times. Not only that, but can cause your report to run unbearably slow. Custom function libraries allow you to pull the complex calculations & functions out of the report and in to an environment where you can better control their output.

Author: Ryan Farley
Category: General / Miscellaneous SalesLogix Articles

Read article...

Integrating SalesLogix Leads with LinkedIn Sample Bundle

Ryan Farley — Tue, 19 Jun 2007 21:42:47 GMT

This post contains a sample bundle for integrating the LinkedIn social network with SalesLogix leads.

Author: Ryan Farley
Category: Downloads / Code Samples

Read article...

Integrating SalesLogix Leads with LinkedIn

Ryan Farley — Tue, 19 Jun 2007 21:38:05 GMT

Social networks have become a big part of today's online landscape. This is true for professionals as well. LinkedIn is a social network that allows professionals to find out more and interact with others whose needs or services align with themselves. This article will show how we can integrate this resource with leads in SalesLogix to show our SalesLogix users as much information about our leads as possible and will provide a complete sample for integrating LinkedIn with SalesLogix leads.

Author: Ryan Farley
Category: Architect / SalesLogix VBScript Articles

Read article...

How to Filter a SalesLogix Crystal Report by ID at Runtime

Mark R. Bailey — Wed, 06 Jun 2007 21:40:07 GMT

This article describes how to call provide a Crystal Reports parameter to a report at runtime via a script. This example details how to feed the current OpportunityID to a report when a button is clicked.

Author: Mark R. Bailey
Category: Architect / Architect How To Articles

Read article...

Dropping SalesLogix Tables

Todd Hardin — Fri, 01 Jun 2007 22:16:12 GMT

Having recently done and upgrade from a rather old DB to v7.0.1, I've encountered a few tables that cannot be deleted from SalesLogix via DB manager. This sample shows the process to completely drop a SalesLogix table.

Author: Todd Hardin
Category: Downloads / Code Samples

Read article...

How to Add a Custom Column to the Manage Products Grid

Mark Mazzitello — Thu, 26 Apr 2007 22:49:00 GMT

This article discusses how to add a custom column to the SalesLogix Manage Products datagrid. This out of the box area is difficult to customize. Following the steps outlined in this article will help you make an easy task of customizing this area.

Author: Mark Mazzitello
Category: Architect / Architect How To Articles

Read article...

Simple Back Office Integration for SalesLogix Whitepaper

Mark Richardson — Wed, 25 Apr 2007 23:43:41 GMT

This whitepaper describes how to easily use back office data in SalesLogix through the use of SQL views. Note: This applies to version 6.2 and earlier only.

Author: Mark Richardson
Category: Downloads / Code Samples

Read article...

Automated SalesLogix Integrity Checks Whitepaper

Dave McGill — Wed, 25 Apr 2007 23:13:24 GMT

SalesLogix currently has 107 different integrity checks that can be run from the Administrator program, but SalesLogix failed to provide a way to schedule them so they needed to be run manually. The automated version of these integrity checks will allow for the tests to be run as a scheduled SQL job and notify support personnel only when there is a problem.

Author: Dave McGill
Category: Downloads / Code Samples

Read article...

Script to Determine the Versions of Installed SalesLogix Program Files

Bob (RJ)Ledger — Wed, 25 Apr 2007 21:11:17 GMT

This utility script will create a file on the desktop named SlxVersions.txt that lists the version numbers for all DLL, OCX, and EXE files in the SalesLogix Installation directory.

Author: Bob (RJ)Ledger
Category: Downloads / Utilities

Read article...

How to Repair a Missing SendSLX Button using an AutoIt Script

David Henry — Wed, 25 Apr 2007 19:33:03 GMT

After upgrading 500 clients from 6.2.4 to 6.2.6 most everyone lost their SendSLX button. i had to release a quick fix. I know Sage had provided a .bat fix that doesn't always do the trick so this is what i came up with. Users can repair it themselves by running the EXE from the network using the following AutoIt code compiled to exe.

Author: David Henry
Category: General / SalesLogix Administration

Read article...

A Guide to The .NET Extension Deployment Attributes

Ryan Farley — Wed, 24 Jan 2007 00:02:49 GMT

When developing .NET Extensions for SalesLogix 7, there are some options available for deployment of your extension. These options are often overlooked, misunderstood, and are certainly undocumented. However, knowing what they are, and how to use them, can assist you to accurately and easily deploy your extensions.

Author: Ryan Farley
Category: Architect / SalesLogix .NET Extensions Articles

Read article...

SalesLogix v7 Database Schema ERD

Ryan Farley — Tue, 16 Jan 2007 18:43:24 GMT

This post contains a Visio file containing a complete Entity-Relationship Diagram for the SalesLogix version 7 database.

Author: Ryan Farley
Category: Downloads / Documentation

Read article...

Leveraging .NET in SalesLogix (Applies to any version)

Ryan Farley — Wed, 10 Jan 2007 16:33:46 GMT

This article contains all sample code, overviews, and screencasts from Ryan Farley's Nav 06 Sage summit presentation. This article includes a bonus screencast that will walk you through the process of embedding a .NET control in any version of SalesLogix. The concepts in this article and screencasts do not use the .NET Extensions feature of v7, but instead focuses on a generic way to include .NET in your SalesLogix development efforts.

Author: Ryan Farley
Category: Architect / SalesLogix .NET Extensions Articles

Read article...

How to Launch a Contact Process via Script - Sample Code

Walter Shpuntoff — Tue, 29 Aug 2006 17:23:37 GMT

This article contains sample code and bundle for the article "How to Launch a Contact Process via Script". Samples included in legacy and VBScript.

Author: Walter Shpuntoff
Category: Downloads / Code Samples

Read article...

How to Launch a Contact Process via Script

Walter Shpuntoff — Tue, 29 Aug 2006 17:15:49 GMT

This article describes the steps to launch a contact process programatically. Sample scripts in both VBScript and legacy basic are included.

Author: Walter Shpuntoff
Category: Architect / Architect How To Articles

Read article...

SQL Profile Template

Timmus Agersea — Fri, 25 Aug 2006 19:20:39 GMT

This SQL Profiler template will properly configure Profiler to perform a SQL trace on a SalesLogix database.

Author: Timmus Agersea
Category: Downloads / Utilities

Read article...

Creating SalesLogix Table ID Values - The Definitive Guide

Ryan Farley — Thu, 10 Aug 2006 08:06:11 GMT

Knowing how to create valid SalesLogix table ID values is a crucial part of working with SalesLogix. The subject of creating SalesLogix table ID values is common among those new to SalesLogix. Let's face it. There is some knowledge that is required when working with SalesLogix, and creating table IDs is no exception. This article will provide all details needed to start creating ID values to get you inserting new data in SalesLogix in no time.

Author: Ryan Farley
Category: External / SalesLogix OLE DB Provider

Read article...