|
You can create your own queries if you know SQL or have us create them for you. Following are instructions for
writing your own scripts. You can also simply browse through the
instructions to get an idea of what scripts can do. Several sample
scripts are included in the download (they are described below).
If you would like us to create a
Mailware Script for you please contact
us.
The download above contains several sample
scripts you
can examine, edit and use. Anyone can install and use the samples,
however it is strongly recommended you install them to your Sample
Data Directory and test them there. When prompted for the Data
Directory (not the install directory) select your Sample Data Directory folder
(usually c:\Program Files\Mailware 20XX\sampdata - see Locating
your Data Directory in our Tips
page).
After installing the script tool, open Mailware. Click
the Tools text menu item. The bottom portion of the menu will contain
a list of available queries. You can run a query by simply
selecting it, however some queries require you create a text file
first (e.g., ImportTrackingNumbers.mws).
The scripts that MAY be installed are
(scripts change frequently so your list may vary):
-
CleanItems.mws - Deletes orders with blank order numbers.
-
ClearTracking.mws - Empties the Tracking.db table. This deletes
ALL tracking information for ALL ORDERS.
-
FixImportedPhones.mws - Formats phone numbers to include dashes (123-123-1234)
-
ImportTrackingNumbers.mws - Imports tracking numbers from a file created from your shipping software. The file must be in comma delimited format and must contain the Mailware order number and the tracking number (e.g., "10", "123" imports tracking number 123 into order number 10).
Name the file "TrackingNumbers.txt" and place it in your data directory.
-
Paid.mws - Calculates the total order amount and enters it into the paid amount field on the Order screen Payment tab.
This is useful for imports that do not include the paid
information (e.g., the Yahoo-MOM import from Yahoo Stores).
Advanced Users
To create your own queries you need to know the SQL query language. If not, you can order queries
through our custom programming
service.
For a full SQL reference please
visit
http://www.elevatesoft.com/dbisam4d5_sql_reference.htm
|
