| Newbie
for Small Business Solutions (NSBS) |
|
Case
Study 1: Shipment Tracking
and Report Generation |
 |
| A
small business wants to be able to extract and
save detailed shipment tracking information from
it's major carrier websites onto its own proprietary
database. The list of carriers include UPS, FedEx,
DHL, USPS. Currently, the company manually looks
up tracking numbers online on each carrier's website.
The company would like to extract the data on
a periodic basis and save it to their database.
They intend to use the data for the following
purposes: |
| |
 |
1. |
 |
Maintain
a detailed history of all shipping transactions
on their database |
| |
2. |
|
Quickly
lookup a specific customer's shipment information
log |
| |
3.
|
|
Generate customized reports based on
this data (i.e. tracking time from order
receipt to fulfillment, package pickup until
delivery to customer) |
|
| |
| The
Customer Table contains detailed information about
customers (data is fictional) |
| |
|
|
| |
| The
Deliveries Table contains all shipment information
for all customers |
| |
|
|
| |
A
sample tracking data to be retrieved from
the UPS website

|
|

Newbie scripts were developed to read
input files, one for each carrier, that
contains a list of tracking numbers.
Newbie automates the extraction of the
data from the websites and saves them
directly into the Tracking Table
|
|
Snapshot report generated from
the company's database |
|
|
| |
|
|
|
View
other
Case Studies
|
|
|
|
|
|
|
|
|
|
|
View
a
sample quote
of the cost to customize a Newbie Script
(PDF format, 34 kb)
|
|
|
Satisfaction
Guarantee:
|
|
| We
believe providing a solution to a customer's needs
is the top most priority. If Newbie Labs cannot
automate your web task according to your satisfaction,
we will refund the cost of customization plus
any Newbie software license(s) you purchase. In
short, you pay nothing if Newbie does not meet
your requirements and you get the Newbie software
license for free. This guarantee is contingent
upon Newbie Labs having either direct access to
the website that will be automated or have remote
desktop access using
GotoMyPC. Having access to
the website is important for us in order to develop
and test the script so that we can deliver the
solution as promised. |
|
|