Fuzzy SQL Update Sugar Contacts

Ever need to match up records for updates but there is no clear relationship to the existing data? There may be duplicates, multiple hits, or a new update may be needed. Here is some sample SQL I used when I needed to reassign contacts in SugarCRM based on a certain kind of relevance, no predictable fields or keys, the data comes in a bucket of excel. Yikes!

This applies to SugarCRM 6.x and is not tested on 7.x without retooling but the technique would help with similar data.

Continue reading “Fuzzy SQL Update Sugar Contacts”

Dynamically Run Golang Code

Golang, Google’s GO language, emphatically has no support for dynamically loading modules. I have a project, however, that can require a completely different configuration based on very minor changes in situations and environment. Nightmare! I hate it when there is no clear solution to a problem. Then I realized I can write my own code dynamically! Continue reading “Dynamically Run Golang Code”

Get Campaign Listing From InBox25 API Using Golang

Inbox25 is a pretty versatile email vendor. It provides a huge number of ways to integrate with CRMs and online services in ways that provide email tools, lead tracking, reporting, and an expanding palette of features. Definitely check them out at http://inbox25.com if you have no idea what they do.

Continue reading “Get Campaign Listing From InBox25 API Using Golang”