There will be times when the SpeedSearch Server is on an application server in the company domain and the web host is out in the DMZ
It is possible for the .DLL file that supports Xbar to fail, in which case the Command Prompt must be used to unregister and reregister the file with Windows, to get it working again.
In the web client you are able to retrieve the raw SQL statement of a group. At some point along the way in the life cycle of the web, the storage format of the SQL statement changed. There is a method GroupSQL that used to return the same SQL as what you would see if […]
after rebooting the connection failed with the message "Unable to connect to server".
If you’ve ever imported activities into your Infor CRM (Saleslogix) database, you’ll likely hear from users that they’ve been bombarded with notifications. In some instances, you might want to clear those notifications so newly created activity notifications don’t end up getting lost in them all. Luckily, you can do that with a single SQL statement. […]
Connect with fellow users and get more out of Infor CRM. For those of you that have been with Infor CRM for a while (perhaps you still call it Saleslogix?), you may fondly recall the Saleslogix User Group that existed in the not too distant past. This group was a great place for users to […]
A post showing how to use Linq to sum an entity collection quickly.
When installing any Infor CRM product, it is important to make sure User Account Control settings are disabled.
Checking to see if the current user is on the same team as an account’s account manager is an easy task. Luckily, the User entity has a built-in business rule called GetUserTeamMembers which returns a list of OwnerJoin entities. For these OwnerJoin entries, the Child property will contain the Owner entity for each team member […]
Reading Data Using the Infor CRM SData REST API from a .NET Application Using the DotNetSDataClient Library
When working with the Infor CRM SData REST API from a .NET application or website, there are a few different choices for libraries you can use to make the SData code easier. The original library was called the SDataCSharpClientLib, which I have written about previously. However, the SDataCSharpClientLib was replaced with the newer DotNetSDataClient library. […]
In order to delete unused templates from the Write menu, it is necessary to delete these items in the Windows registry.
I was recently working with a client who was having trouble installing the 8.3 Web Action items manifest (Infor v8.3 Action Items VFS.zip). Within this manifest are actions like create triggers or drop indexes. Whenever these Database Definition Language commands were attempted they would receive the dreaded and completely useless “Object Reference not Set to […]
Domain Group Policy can overwrite the ability of some Infor CRM components to log on as a service.
I had the need to call a business rule in Infor CRM from a stored procedure in SQL. This turned out to be a relatively easy task, although you want to make sure you think through what you’re doing for this to not introduce performance problems in SQL. Keep in mind, sometimes SData requests can […]
After installing Xbar 1.3, Outlook 2010 did not have the Record to History icons in the toolbar ribbon. In Outlook, go to File, Options, Add-Ins and you will see Infor CRM Outlook Connecter listed in the Disabled Add-Ins.
Adding support for attachments to a custom entity in Infor CRM Web is a pretty simple task as long as you know what the steps are. Luckily, the out of the box attachments SmartParts is built in a way to make it work with new custom entities without customization. It takes only 2 easy steps. […]
When attempting to delete and attachment using the Infor CRM 8.2 Web Client, you may get an error that the "requested value 'Modified' was not found." This occurs when values for RemoteAttachments.Status in the underlying database are not correct.
We had not seen this error in the InforCRM Customer Portal until recently, and the befuddling aspect was the SLXClient attachment upload worked perfectly. The Application Architect setup was checked and IIS was setup and running with the WebDll user running the CustomerPortal application and web pool.
How to Import Data Into Infor CRM (Saleslogix) Using SQL Server Integration Services (SSIS) With Auto-Generated Table ID Values
Importing data into Infor CRM (Saleslogix) is a task that is typical for any system. However, sometimes the custom format table ID values are a roadblock in using standard, or widely used tools to do the job. In this article I will look at creating a simple data import using SQL Server Integration Services (SSIS) […]