Go to Bottom

Copy Shipping Queries

In this Topic: ShowHide

Overview

This topic discusses the function called Copy Shipping Queries, that can be executed from the Shipping & Fulfillment tab of the Maintenance Menu. This function is used to ensure that the latest queries needed by ODBC shipping software applications, such as UPS WorldShip or FedEx ShipManager, are installed in the customer's data file. It also copies the Countries table.

If there is a problem connecting to an external shipping application that uses an ODBC connection abbreviation for Open Database Connectivity, which is the technology that allows applications to access data from a database, independent of the programming language of the application, or the operating system upon which it is run. For example, The Order Manager uses an ODBC Connection to share information with UPS WorldShip., execute the Copy Shipping Queries function.

There is no user interface for this function, when the link is double-clicked, the program immediately executes a command in the background that copies a series of queries from the program file to the customer's store data file. The process takes only a few seconds, and the user is notified when it has been completed.

Queries that are Copied

WorldShipOrders

WorldShip Proper Case

WorldShip Proper Case AC

WorldShipBatchSQL

WorldShipBatchACSQL

WorldShipOrdersSQL

Created: 4/11/11

Go to Top