Exchange Web Services is better than WebDAV...

(...but SOAP still sucks!)

My mind is rambling again.  Fair warning - this post likely lacks coherency, context, critical details and color.  A pint of scotch (or two) to help you through is recommended.

Breaking the Search ceiling

The standard model for scripted search in Netsuite is fairly simple, but unfortunately very limited.  Thanks to the 2012.1 release we have an additional method for searching that is far more robust.  The new method has a short learning curve and is fairly flexible once you get the basics down.

PHP, mail, attachment

I've only had a handful of occasions where attaching files to an email was required, or even warranted.  Inevitably I would turn to Google, spend an hour or two wading through various dark arts involving base64, mime-types, mail headers and virgin sacrifices at the altar of SMTP.  Today ended up being no different.

SQLSRV for PHP 5.4

Last month PHP 5.4 was recently released to some excitement in the community.  Stodgy old man that I am, I was happy to upgrade as soon as possible, but after the installation I found that Microsoft was not quite yet ready with a new set of drivers for SQL Server.  So I swapped back to the PHP 5.3 cgi and let time do it's work.

Fast forward a few weeks and I find that all of the pieces have happily produced themselves.  Here is a short rundown on installing the newest SQL Server drivers for PHP 5.4:

Building a PHPSuite while napping (pt. 3)

In the last two posts we reviewed how to setup a RESTful web service in Netsuite and a general-purpose REST client in PHP.  In this entry we'll finally make some magic happen by creating two classes to tie this project up.

Building a PHPSuite while napping (pt. 2)

In the last post I discussed writing a general purpose restlet to allow scripting a Netsuite search in PHP. In this post we'll cover how PHP talks to Netsuite's restlet service, and in my next post (hopefully sooner than later) we'll cover implementing a search in PHP.

To start off we need to register our script from last time with Netsuite. Create a new Suitescript Restlet:

Building a PHPSuite while napping (pt. 1)

Netsuite's existing integration solution for PHP, the PHP Toolkit, is plenty powerful, but the minimalist documentation and disappointing end-product (SOAP solutions are so 2006) make it a bit of a PITA. The following came from some attempts to benchmark the existing SOAP solution against Netsuite's relatively recent RESTlet service (the results of which I will post another time. Long story short, REST really is the only solution you should for consideration)