Shipping with DHL

In this Topic: Show

Overview

Install DB Connect

1.       Locate DB Connect in the c:\dhl\DBConnect\DbConnectSetup.msi directory.

2.       Double-click DBConnect.exe to launch the installation program.

3.       Right-click Customer Database and select Add New Customer Database.

4.       Select the DSN to the Order Manager data file. See the article Creating an ODBC Connection in Windows for more information.

5.       Under Actions, expand Read From Customer Database, then select Read Shipment.

6.       In the drop down list under Customer Database, select the New Customer Database that you created above.

7.  Select Next.

Map the Database Fields

 

1.       Click on the icon next to your customer database name.

2.       Select WorldShipOrders.

3.       Click on the plus (+) sign to expand WorldShipOrders.

4.       Select OrderNumber in the left hand column and CustomerShipmentId in the right-hand column.  Make foreign key. Then click the >> button.  Repeat this until all of the fields listed below are mapped:          

·         WorldShipOrders.Shipping                        Service/1/ServiceType !!!needs shipping letter instead of name

·         WorldShipOrders.UPSCompanyorName    Consignee/CompanyName

·         WorldShipOrders.UPSAddr1                     Consignee/AddressLine/1

·         WorldShipOrders.UPSAddr2                     Consignee/AddressLine/2

·         WorldShipOrders.UPSCity                        Consignee/City

·         WorldShipOrders.UPSState                      Consignee/DivisionCode

·         WorldShipOrders.UPSZip                         Consignee/PostalCode

·         WorldShipOrders.UPSWeight                   ShipmentDetails/Weight

·         WorldShipOrders.UPSPhone                    Consignee/Contact/PhoneNumber

·         WorldShipOrders.UPSattention                 Consignee/Contact/personname

5.       Click Next.

6.       Click Finish.

Create the Export Map
  1. Click on Write Back Shipment.

  2. In the drop down list under Customer Database, select the New Customer Database that you created above.

  3. Click on the Magnifying Glass icon next to the database name and select Tracking.

  4. Click OK.

  5. Click Next.

  6. Right-click Tracking. Choose Insert.

  7. Click on the plus (+) sign to expand Tracking. Select Cost in the left hand column and ShippingCharge in the right-hand column. Then click the >> button. Repeat this until all of the fields listed below are mapped:

  1. Tracking.OrderNum -- CustomerShipmentId

    Tracking.TrackingID -- ShipmentDetails/Pieces/Piece/AirwayBillNumber

    Tracking.Cost -- ShippingCharge

Note: If you don’t see the fields, click on the Magnifying Glass icon next to DHL Fields.

  1. On the far right panel, check Search Key next to the Tracking.OrderNumber field.

  2. Click Finish.

  3. Click Save and Export on the File menu.

Turn on DBconnect Via .cfg File

·         Located on the C drive c:\dhl\client\cfg\dhlclient.cfg

·         <Module name ="CustomerDB">

·         Edit file and Enable according the screenshot

How you Turn On "Search For"

Select shipment and enter Order Number in "Search For" field

Settings-->User Preferences--> Shipments--> Apply Default Values to Imported Data

And Default Find Shipment By

 

 

 

Created: a long time ago!

Revised: 11/4/14

Go to Top