ShipRush ADO: Advanced Shipping Control

A great degree of control is available by manipulating the shipping template. Shipping templates can be created in advance using ShipRush, and can be modified at any time.

(For steps on how to create templates, please refer to this page.)

For example, say the database needs to control which printer the label is printed to. This can be set in the shipping template, and the query can select the correct template to use.

In the shipping template at the <Shipment> document level the printer settings can optionally be set. (Note that ShipRush does not create printer related entries in a template. These entries need to be created programaticaly or by hand.) In this section of the template you can override the printer type, and printer name.

Example XML from a template:

<?xml version="1.0"?>

<OverridePrinterSettings Value="1"/> // This allows the template to

// override ShipRush settings

<LabelPrinterType Value="0"/> // This is for a laser printer

</Shipment>

</ShipTransaction>

</Request>

Note, that you can use ShipRush in Stand-alone mode (or any other mode) to test these templates. Make the template, open the main ShipRush form, click ShipRush System menu. Open the desired template and ship. The label should be printed on the requested printer.

To allow the SQL query to select a specific template simply return the template filename in the "ShippingTemplate" field. This is the local filename of the template for ShipRush to load (the template must be present and have the same name on all ShipRush shipping stations).

Example (based on MS Solomon example integration):

SELECT

/* here the template is hard set in the query */

/* but we could query a db field for it */

'C:\Temp\LaserPrinter.zpk' as ShippingTemplate,

S.OrdNbr as RecordID,

H.ShipName as CompanyName,

A.Name as ContactName,

A.Addr1 as Address1,

A.Addr2 as Address2,

A.City as City,

A.EmailAddr as EMail,

A.State as State,

A.Zip as ZIP,

A.Country as Country,

A.Phone as Phone,

A.Fax as Fax,

'ShipRush Shipment' as Reference,

12.7 as PackageWeight

FROM SOSched S WITH (NOLOCK)

LEFT JOIN SOHeader H WITH (NOLOCK) ON H.CpnyID = S.CpnyID

AND H.OrdNbr = S.OrdNbr

LEFT OUTER JOIN SOAddress A WITH (NOLOCK) ON (A.CustId = H.CustID)

and (A.ShipToId = H.ShipToID)

WHERE

(S.OrdNbr LIKE '%SEARCHPARAM%%')

Next: Bar Coding