Search Customer FX

Browse By Tag What's this?

Using SQL User defined functions and Cross Apply to parse SQL data

Recently, I worked on an import where I spent a considerable amount of time working out how to effectively parse data from a SQL table, for insertion into another table. The table I was evaluating basically looked like this: ID, Value ------------------------------ "1", "ABC, DEF, HIJ"...

Posted to Jason Buss' Blog (Weblog) by on
A Look at Querying Data in SalesLogix using IRepository and the SQL Equivalents

For some who have been working in the SalesLogix LAN client for years, the transition from using SQL queries to retrieving data using a repository with the entity model can be a difficult change. This post will look at some common data retrieval methods and the SQL equivalents to help you get your head...

Posted to Ryan Farley's Blog (Weblog) by on
SageCRM Tip - Editing screen definitions - Screen contents missing from screens

On the last SageCRM project I worked on, I ran across a little issue with the CRM interface which was causing me a bit of a headache. I was working with a couple of screens I had defined for a custom entity. These screens were similar, so I was doing a lot of comparing one screen to another. Every once...

Posted to Jason Buss' Blog (Weblog) by on
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...

Posted to Jason Buss' Blog (Weblog) by on
Displaying external data in SageCRM 200

In this post, I will outline a relatively simply process for displaying data in SageCRM from an external data source. To keep this simple, we're not going to worry about any sort of security, and we'll save more advanced formatting for another post. First of all, we need to create a reference...

Posted to Jason Buss' Blog (Weblog) by on
Using Picklist data revisited

Back in January, I posted about the SalesLogix picklist data structure, and outlined how to use the data found in the picklist table to populate other controls such as comboboxes and listboxes. You can find that article here .) If you are performing customizations to version 7.2 or later of SalesLogx...

Posted to Jason Buss' Blog (Weblog) by on
Using SQL views to incorporate external data into SalesLogix cusomizations

Did you know that you can include SQL views in SalesLogix? This can be a very handy method to include data that is not normally part of SalesLogix. It is important to note, that these changes are not sync-aware. However if you are running SalesLogix LAN in a network only environment, this can be a helpful...

Posted to Jason Buss' Blog (Weblog) by on
Creating Modules for SalesLogix Web and Hiding Toolbar Items at Runtime

Creating modules for SalesLogix Web is something that is likely something that is often overlooked or not used because they are assumed to be too complex or are just not understood. A module is an assembly that you've added to a page or the portal that adds functionality to the page. The great thing...

Posted to Ryan Farley's Blog (Weblog) by on
Events based on history in version 6.x SalesLogix

Prior to version 7, there was limited access to those activity and history areas in SalesLogix. In a recent project, I had to perform a series of tasks upon completing an activity with a particular Type/Category/Result combination. This had to be done in a 6.2.1 system. In order to do this, I had to...

Posted to Jason Buss' Blog (Weblog) by on
Populating AutoComplete Strings

I recently had a project which required me to populate the strings collection in an AutoComplete control from data contained in the database. I wanted to take a second to outline how I populate the control's strings, as well as create a reusable script to simplify the process in the future. The FillAutoCompleteString...

Posted to Jason Buss' Blog (Weblog) by on

Page 1 of 14 (133 items) 1 2 3 4 5 Next > ... Last »

Search Customer FX

Upcoming Workshop Dates