11/21/2024 4:50:37 PM
slxdeveloper.com
Now Live!
|
|
|
Description: |
Something lacking in SalesLogix is the ability to send a link to other SalesLogix user in reference to a particular record in SalesLogix. Say you want to send an e-mail to another SalesLogix user regading XYZ Corp. Wouldn't it be nice to be able to send him a link in the e-mail to allow him to jump right to the record in question? The SalesLogix URL Link solves this problem and provides a way to create hyperlinks to accounts, contacts, opportunities, tickets, and anything that is represented as a SalesLogix MainView. We'll create a custom URI handler and use SalesLogix automation to move to the appropriate record.
|
Category: |
SalesLogix COM
|
Author: |
Ryan Farley
|
Submitted: |
3/10/2006
|
|
|
Stats: |
Article has been read 39797 times
|
Rating:
- 5.0 out of 5 by 11 users |
|
|
|
fiogf49gjkf0d
Something lacking in SalesLogix is the ability to send a link to other SalesLogix user in reference to a particular record in SalesLogix. Say you want to send an e-mail to another SalesLogix user regading XYZ Corp. Wouldn't it be nice to be able to send him a link in the e-mail to allow him to jump right to the record in question? The SalesLogix URL Link solves this problem and provides a way to create hyperlinks to accounts, contacts, opportunities, tickets, and anything that is represented as a SalesLogix MainView. We'll create a custom URI handler and use SalesLogix automation to move to the appropriate record.
Before we get too far into this, I do want to point out. The URL Link will be a built in part of SalesLogix version 7. I've modeled the code here to match how the built in URL Link will work so things will transition smoothly to version 7.
In order to create a hyperlink we'll need to create a URI handler. Similar to a website URL that begins with HTTP, we need to have our own prefix to handle our hyperlinks. We'll use 'slx' as our handler. What we want to end up with is a link that describes the table that the record is contained in and the primary key of the record itself. This will work with MainViews. We'll want to make happen is to move to the MainView for the table and go to the record for the primary key value.
We'll want the URL to look like this:
slx://tablename/primarykey
Example:
slx://account/AXXXX0000001
Setting up the URI handler is easy enough. Just a simple addition to the system's registry. When we add the entries to the registry we'll need to indicate the application name and path that we can pass the table name and primary key values to on the command line. This application could be a simple VBScript file, or a full executable. We'll be using an executable to avoid any problems with virus scanners.
Our registry entries will be as follows (these can be pasted into a text file and given an 'reg' extension for easy adding to the registry.)
Windows Registry Editor Version 5.00
[HKEY_CLASSES_ROOT\slx]
@="SalesLogix Protocol Handler"
"URL Protocol"=""
[HKEY_CLASSES_ROOT\slx\DefaultIcon]
@="C:\\Program Files\\SalesLogix\\salesLogix.exe"
[HKEY_CLASSES_ROOT\slx\shell]
[HKEY_CLASSES_ROOT\slx\shell\open]
[HKEY_CLASSES_ROOT\slx\shell\open\command]
@="\"C:\\Program Files\\SalesLogix\\SalesLogixUrlLink.exe\" %1"
Once we add this into the registry the URI handler is complete. Now all we need to do is build the SalesLogixUrlLink.exe and place it in the path we specified in the registry.
When a 'slx' hyperlink is clicked, the 'open' command associated with the handler (our executable) is invoked. The entire URL is passed on the command line to the application. So, for the example listed above of slx://account/AXXXX0000001, the entire URL of slx://account/AXXXX0000001 will be passed on the command line to our application. What we first need to do is parse out the table name and ID value. Once we get the table name and ID value we can instanciate an automation object to communicate with SalesLogix and then call ShowDetails. ShowDetails is a generic method which will allow us to generically load the appropriate MainView for the table and also specify the ID for the record we wish to display. For the C# code below, don't forget to add a COM reference to the 'SalesLogix Library' found in SalesLogix.exe.
using System;
using System.Windows.Forms;
using System.Runtime.InteropServices;
using System.Text.RegularExpressions;
// Add COM reference to 'SalesLogix Library' found in SalesLogix.exe
namespace SlxDeveloper.SalesLogixUrlLink
{
public class LinkHandler
{
[DllImport("user32.dll", CharSet=CharSet.Auto)]
public static extern IntPtr FindWindow(string ClassName, string WindowText);
static void Main(string[] param)
{
// quit if for whatever reason we didn't get params
if (param.Length == 0) return;
// if SalesLogix is not running we don't want to continue
if (FindWindow(null, "SalesLogix") == IntPtr.Zero)
{
MessageBox.Show("SalesLogix is not running.", "SalesLogix Link");
return;
}
// get table name and id value
MatchCollection col = new Regex(@"\w+").Matches(param[0]);
string table = col[1].Value;
string id = col[2].Value;
// now we need to load SalesLogix and move to the
// mainview for the values passed
SalesLogix.SlxApplication slx = null;
try
{
slx = new SalesLogix.SlxApplicationClass();
// call ShowDetails to generically load the mainview
// for the table name passed to us and move to the
// specified id value
slx.BasicFunctions.ShowDetails(table, id);
}
catch (COMException) { /* eat exception, SalesLogix likely not installed */ }
finally
{
if (slx != null) Marshal.ReleaseComObject(slx);
}
}
}
}
Now we can compile that code as 'SalesLogixUrlLink.exe' and copy it to the SalesLogix directory (since that is what we specified in the registry entries above).
Now that we have the code complete we can use the SalesLogix URL Link in any number of locations. We could add hyperlinks to SalesLogix records (which are represented by a MainView in SalesLogix) in intranet webpages, e-mails sent regarding customers, opportunities, or tickets in SalesLogix, even in messenger conversations, and many other types of locations.
All we need to do is form the URL. We could easily put a button on the toolbar captioned 'Get Record Hyperlink' with a script that does the following:
Sub Main
Dim shell
Dim mv
Dim link
Dim recname
Set mv = Application.MainViews.ActiveView
link = "slx://" & mv.BaseTable & "/" & mv.CurrentID
recname = Replace(mv.Caption, " ", "%20")
Set shell = CreateObject("WScript.Shell")
shell.Run "mailto:?subject=" & recname & "&body=" & recname & "%0A" & link, 1, false
Set shell = Nothing
End Sub
This would allow the user to copy the current record (whether it be an account, contact, opportunity, ticket, or other custom MainView record) as an e-mail containing a hyperlink to the record. The result produced here would have something such as "Account: Abbott Ltd." in the subject line and the body of the mail window would be like the following:
Account: Abbott Ltd.
slx://ACCOUNT/AGHEA0002669
Another very useful scenario would be to use the hyperlink is notifications sent by KnowledgeSync to provide a quick and easy way for users to jump to records mentioned in the notifications sent regarding SalesLogix records.
I am glad to see that the SalesLogix URL Link will be making it into the product for version 7. This is an invaluable and time-saving way to assist the user to jump to records and send links to records to other users.
Until next time, happy coding!
-Ryan
- 3/13/2006 - I just wanted to note (thanks RJLedger) that the current BETA of version 7 uses a format of slx:tablename/primarykey for the links (note no '//' after the colon). However, IMO that is a bug and should be fixed before it's release. Should you wish to use that format now, the code in this article will continue to work with that format thanks to the regular expression (it doesn't really care what it starts with. It will work with slx: as well as slx:// - either way will work for this code. I'll update the article again when I hear back if they've fixed that problem in v7.
|
|
|
|
Rate This Article
|
you must log-in to rate articles. [login here] 
|
|
|
Please log in to rate article. |
|
|
Comments & Discussion
|
you must log-in to add comments. [login here]
|
|
|
- subject is missing.
- comment text is missing.
|
|
| Re: The SalesLogix URL Link Posted: 3/11/2006 2:53:56 PM | fiogf49gjkf0d You've done it again. Very clean and functionality I've wished I've had since I started with SalesLogix back in '90. | |
|
| Re: The SalesLogix URL Link Posted: 3/13/2006 4:28:37 PM | fiogf49gjkf0d Thanks Rob. I know. I first built a "URL Link" sort of thing for SalesLogix about a year and a half ago. After I built it I was amazed that it wasn't just a built in part of SLX because it made so much sense. After some talk about it at a SLX meeting with some other BPs (and with it coming in v7 as a built in part), I figured it was time to write it up for the site.
-Ryan | |
|
| Re: The SalesLogix URL Link Posted: 3/20/2006 10:32:40 AM | fiogf49gjkf0d Ryan - another sweet how-to, thanks!
However, could someone please give me some help on how to create the toolbar captioned 'Get Record Hyperlink'?
I have everything else in place, I just cannot figure out how to make a toolbar with scripting behind it.
Thanks. Sam | |
|
| Re: The SalesLogix URL Link Posted: 3/20/2006 11:54:59 AM | fiogf49gjkf0d Sam, an excellent question for the forums!
Meanwhile, I'll update the zip to include a sample bundle with the toolbar button (but still worth posting the question to the forums since you might get an answer before I'm able to update it!) | |
|
| Re: The SalesLogix URL Link Posted: 3/20/2006 6:27:07 PM | fiogf49gjkf0d I've updated the bundle to contain a sample bundle with a toolbar. Enjoy. | |
|
| Re: The SalesLogix URL Link Posted: 3/21/2006 10:29:47 AM | fiogf49gjkf0d Thanks Ryan - I have installed the bundle, and have the toolbar. However, it appears as text in Outlook, not a hyperlink. Ideas? | |
|
| Re: The SalesLogix URL Link Posted: 3/21/2006 10:59:08 AM | fiogf49gjkf0d Hi Sam,
The bundle provided was intended to be just a quick sample to demonstrate how to build the URL/link from the current record in SalesLogix. If this was to be used for production, I would opt to not just shell a mailto link, but instead I would create an actual Outlook MailItem so you could format the body of the e-mail as HTML and have the URL appear as a hyperlink. I would have the hyperlink show the record name, not the URL, so the end result would be like:
Record Name
Know what I mean? Do a quick google search for "Outlook MailItem" and you're bound to find some good examples for creating HTML e-mail's for Outlook. | |
|
| Re: The SalesLogix URL Link Posted: 3/23/2006 4:14:47 PM | fiogf49gjkf0d Application.BasicFunctions.QueMessage. It's a good place to start and honestly you're only wanting to fill in the body as any touching of the recipients raises the Outlook security prompt if done outside of this function. SalesLogix actually has a good example on how to manipulate the Outlook COM object if you need something a little more robust. It's named SLX_DoOutlook_AS and apparently hasn't changed since v6. The cool part about this code is it strips the signature and repurposes the body with the signature at the bottom, something mailto: doesn't do I believe. | |
|
| Re: The SalesLogix URL Link Posted: 10/22/2007 11:57:09 AM | fiogf49gjkf0d Hi Ryan,
Does this code work for Saleslogix 6.2 Web Client?
Thanks,
Felipe. | |
|
| Re: The SalesLogix URL Link Posted: 10/22/2007 11:59:43 AM | fiogf49gjkf0d Felipe,
No, this is for LAN client only.
-Ryan | |
|
| Re: The SalesLogix URL Link Posted: 10/22/2007 6:30:31 PM | fiogf49gjkf0d Thanks Ryan,
Do you know how can I achieve the same functionality for the Saleslogix Web Client?
Felipe. | |
|
| Re: The SalesLogix URL Link Posted: 1/21/2009 3:41:58 PM | fiogf49gjkf0d Hi. Im very new to SLX and our company has just upgraded from v6.2.3 to v7.5. You mentioned that this SLX URL Link is built into v7. Please are you able to show or direct me where to access it in v7.5? Many thanks | |
|
| Re: The SalesLogix URL Link Posted: 1/21/2009 5:06:18 PM | fiogf49gjkf0d Mel,
It exists in SLX 7.5, there's no where to "see" it, it's just built in. You can test it by opening SLX and going to start|run and entering something like "slx:ACCOUNT/AGHEA0002669" (without the quotes, change that last part, the ID to be a valid accountid in your system).
-Ryan | |
|
| Re: The SalesLogix URL Link Posted: 1/21/2009 5:41:22 PM | fiogf49gjkf0d Hi Ryan
It's there alright. Tried it with Account, Contact and Lead and they all worked fine. However for Ticket I always get an Invalid Record result. All I did was to copy paste the Ticket ID onto the command. Is there any particular reason it doesnt work same way in Tickets?
Thanks Mel | |
|
| Re: The SalesLogix URL Link Posted: 1/22/2009 8:05:01 AM | fiogf49gjkf0d Hello
We are running SLX 6.2 and I have installed the plugin and it works a treat. but I have installed the bundle for the toolbar button but I am not seeing the button. I installe it from the admin tool. Am I doing something wrong? Where should I see the button? | |
|
| Re: The SalesLogix URL Link Posted: 1/12/2010 8:52:29 AM | fiogf49gjkf0d Hello Ryan, I am new to SLX development. We are using SLX version 7.5. I need to generate an email (in outlook )from SLX with a link to SLX. So i tried the above code and its creating a line of text inside an email , which takes me to SLX if run the line from command prompt or from a browser. How can i display it as a URL (hyperlink text) in outlook itself
Thanks in advance
| |
|
| Re: The SalesLogix URL Link Posted: 1/12/2010 10:21:36 AM | fiogf49gjkf0d rxp6745,
You'll need to format the e-mail as HTML so you can add the link as a hyperlink using standard HTML anchor tags.
-Ryan | |
|
| Re: The SalesLogix URL Link Posted: 1/12/2010 12:57:38 PM | fiogf49gjkf0d Thanks that worked !!...
| |
|
|
|
|
|
Visit the slxdeveloper.com Community Forums!
Not finding the information you need here? Try the forums! Get help from others in the community, share your expertise, get what you need from the slxdeveloper.com community. Go to the forums...
|
|
|
|
|
|