Earlier this week, I spent an awesome three days in San Francisco at SugarCon 2011. The conference featured some great discussions, most notably the developer-focused UnCon sessions. SugarCon 2010 was great, but I remember wishing there was more hardcore-developer-focused venues for discussion and learning. UnCon met that need head-on. Special thanks to Jon Whitcraft and John Mertic for the words of wisdom and helpful answers. If you missed the conference, I highly recommend checking out the posted slides from all the presentations. On the first day of the conference, I had the opportunity to give a short presentation on using …

Earlier this week I was trying to make a set_note_attachment call with the SugarCRM REST API, but I got a very strange error. The server was responding with an Error Type 20, saying that the “Module Does Not Exist,” which was bogus because I wasn’t even specifying the optional related_module_name field. Here is the data arra I used to create my original call: $data = array( ‘session’ => $session, ‘note’ => array(‘id’ => $note), ‘file’ => $file, ‘filename’ => $filename, ); As it turns out, I misread the rather confusing documentation on this specific call. In actuality, the API requires …

Earlier this week, I had the wonderful opportunity to speak at SugarCON. Thanks to everyone who came to my presentation; as promised, here are some code samples from the presentation. For the Reports filter modification, I tried my best to describe where each code sample goes within the appropriate files. I couldn’t use code line numbers because at Milsoft, most of the important files are heavily modified. Also note, I used direct MySQL connections in my code. Feel free to use SOAP or the built in SugarCRM database functionality.