Since the release of the “Cloud Flat File” integration feature in Transaction Manager, the need for a service to sync hosted FTP folders and local file system folders has arisen. I created a simple open-source tool to accomplish this task as an option for our customers. While it isn’t a perfect fit for every scenario, it offers an easy set-and-forget model that doesn’t require setting up batch scripts and messing with Windows Task Scheduler. It isn’t perfect, though, as was recently discovered by a high-volume customer.
Continue reading “TFW Windows Interrupts Your Service”XPath and IMT: Namespace Prefixes
With complex XML schemas, it is at times necessary to use the XPath features in IMT to map attributes or elements to column definitions. The basic idea of how this works is pretty simple, but there are a few “gotchas”. Elements with namespace prefixes are one of those scenarios.
Continue reading “XPath and IMT: Namespace Prefixes”Modular RESTlets
I leverage NetSuite RESTlets pretty extensively for several of my projects. When I got tired of keeping track of multiple RESTlet endpoints in various config files for numerous apps, I decided to change my approach.
Continue reading “Modular RESTlets”Hosting NetSuite Suitelets Externally
To create a completely custom UI in NetSuite, you’ll need to create a special script known as a “suitelet”. Suitelets are written in JavaScript and allow you to build an HTML document to be delivered to the browser. In the suitelet, you’ll have access to all of NetSuite’s SuiteScript APIs so you can inject contextual data into the HTML document. NetSuite does not, however, provide a very robust way to manage complex permissions on these scripts much less allow for automated deployments.
Continue reading “Hosting NetSuite Suitelets Externally”Parsing Labeled Data in IMT
This post is a follow-up to my previous post, Parsing Delimited Strings in IMT. That post went into detail on how to parse values from a delimited string based on the desired value’s position in the string. This post will explain how to parse values that are labeled using a real-world example brought to me earlier this week.
Continue reading “Parsing Labeled Data in IMT”Using Node to Build Custom Azure Pipeline Actions
I recently began migrating my projects from the tried-and-true “manual build and deployment” model to Azure Pipelines. For the most part, this is very straight-forward. I simply point to my csproj or package.json and say “go forth and build”. But I found that there was no native way to set version numbers in my csproj files. I didn’t want to commit versions to my repo (I’ll write a post on this in the near future), so I needed some way of automating this in Azure Pipelines.
Continue reading “Using Node to Build Custom Azure Pipeline Actions”Parsing Delimited Strings in IMT
Delimited text is very common in the enterprise space. In fact, EDI – the “lingua franca” at TrueCommerce – is just delimited text at its core. I get asked often how to parse values out of a delimited string using IMT. In this post, I’ll break down how to build these statements.
Continue reading “Parsing Delimited Strings in IMT”