Tag Archive: php

Item Bin report, and introducing the PSyOPs Framework

A while back, I discovered something of a weakness in DDMS: there’s a bug in the Allowable Functions permissions settings for Item. In short, you can’t give someone read-only access to Item History where bins and inventory are kept. To allow them to view it gives them the ability to change fields on that subscreen. …

Continue reading »

Download a pre-configured XAMPP

The past few days I’ve been working with a fresh installation of XAMPP, used for my article Setting up XAMPP to Work With MSSQL. I realized that if you don’t have some experience with web servers, etc., it can be a bit much. What I mean is, I struggled with it a bit, and it’s …

Continue reading »

Your first MSSQL Report, ‘Flushed Today’

A few weeks ago, I had quite a few orders go sideways on me. The orders that were a mix of wholesale product and items we stock were missing our stocking items from the deliveries. With a little investigation, it seemed the culprit was likely that tickets had been prematurely flushed to status B. As …

Continue reading »

Setting up XAMPP to Work With MSSQL

In this article, I’ll show you how to set up XAMPP on a Windows 7 machine. The process is largely the same on Windows XP, if you’re repurposing an older machine. One thing to keep in mind, though, is the newest versions of XAMPP use a version of PHP for which there is not an …

Continue reading »

A Better Method of Reporting in DDMS

If it wasn’t clear before, I’m a huge evangelist of using the SQL Server for reporting in DDMS. I’ve spent a lot of hours working with DDMS in a lot of ways, and I’ve always seen its reporting capabilities as a huge weak spot. A few years ago, I sat down and got serious about …

Continue reading »

Screen-scraping Addresses from the USPS

As I mentioned in my posts about Web Tools, I wasn’t entirely sure I’d get approval from the Post Office to use the Web Tools servers, so I came up with a plan B. That plan B being screen-scraping the USPS’ website. Like the others, I wrote the code originally in 2010. As it happened, …

Continue reading »

Returning Sales Tax data for Washington State with PHP

Washington State introduced some interesting tax rules back in 2008. Where previously sales tax was calculated at the point of sale, it was changed to be point of delivery. This was a huge distinction for companies that make deliveries. In addition, the state requires tax reporting to be broken down by district. So prior to …

Continue reading »

USPS Web Tools for Address Validation, the tl;dr version

If you just want to know how the hell to get up and past the scripted tests and get on the live server, this post is for you. It goes like so:

Continue reading »

USPS Web Tools for Address Validation, part two

(As noted in part one, this was originally written in 2010 or so, but everything should still apply today.) In Part 1, I walked through the PHP code needed to send and retrieve the XML data the USPS Web Tools API works with. We managed to work our way through the first scripted test you …

Continue reading »

USPS Web Tools for Address Validation, part one

(Note: this was originally written in 2010, to the best of my memory. While some references may be outdated, the code still works, as I’m still using it today.) To use the USPS Web Tools API, you have to sign up and get a user ID and password. This is easy enough to do. Go …

Continue reading »

» Newer posts