How to create a UPS Developer Access Key?

I have been tasked to integrate UPS Online Tools with NetSuite ERP using PHP programming language. The job requires retrieving Quantum View reports from UPS on a daily basis, and updating NetSuite Sales Orders with retrieved tracking information. By browsing UPS Developer Kit, I am going to be using at least Quantum View API, and Tracking API to do the trick.

Netsuite Suitelet Examples & Tutorials

NetSuite Suitelets play a vital part in integrating 3rd party web applications with the NetSuite. Writing a suitelet is as easy as writing a simple javascript except that it runs on the server side. Here are a couple of examples of how to write a suitelet. The first example creates a customer of a type LEAD-Unqualified from a POSTed web submission.

Netsuite Suitelet Overview

Suitelets are extensions of SuiteScript that allow developers to write custom NetSuite pages and backend logic. Suitelets are server-side scripts that operate in a request-response model. They are invoked by HTTP GET or POST requests to system-generated URLs, and by default, they are invoked by making a GET request from a browser.

Netsuite SuiteScript (Suitelet) vs. SuiteTalk (Web Service)

Netsuite purposely disallows a user from establishing two separate sessions to the NetSuite portal. That is, you cannot have a session established on Firefox and Chrome or Internet Explorer at the same time, and this is true for any user including the one being used by the Netsuite Web Service. This causes a potential problem where your visitors may be submitting forms at the roughly same time which triggers a second web service call to be made to Netsuite while the previous one is still running. When the second web service call is made before the first one is completed, the first call terminates without completing its task potentially losing a lead or whatever the task the first one was designed to do.

Netsuite PHPToolkit Web Service - Create Customer Tutorial

Netsuite provides a soap-based web service interface called SuiteTalk to allow 3rd-party applications to interface with the Netsuite ERP system. Netsuite also provides Toolkits written in PHP, .NET, and Java programming languages, which will make Netsuite integration easier. We'll use PHPToolkit to create a customer record in Netsuite.

SMTP Email Address Validation

How do you validate an email address? You may validate it with a javascript on the client-side, or run a server-side validation via a regular expression or a newly available filter_var function of the PHP 5.2.x. Perhaps, you may want to go one step further and verify the email address from the remote SMTP server.

Malware detected on website

One of the servers we manage has been compromised, and hosting malware according to Kaspersky Anti-Virus software. The site uses a number of open-source applications such as WordPress, Gnuboard, and phpLinkDirectory. We initially thought it would be either the .htaccess or base64_encode exploit, but after close examination, we found that a plain javascript snippet was inserted into one of the Gnuboard include files (bbs/visit_insert.inc.php).

What is the difference between "Primary Key" and "Unique Key" in SQL?

I've had a chance to with a Postgres database and came across a table with two primary keys. This intrigues me to look up a definition of primary and unique key. I always thought there would only be one primary key in a table, and the values have to be unique. But, what I saw in the PostgreSQL v8.1.23 was something otherwise. It allowed duplicate entries, and also allowed multiple primary keys in a table. Is this possible? Yes, it's called composite Primary Keys. Composite primary keys (multiple primary keys) makeup uniqueness in a table row -- which means composite primary keys work together to provide uniqueness.