To setup the export of shipping information from UPS WorldShip to Total Order Plus, you will need to map the V drive, Click on the link below for mapping instructions:

https://mindwarecorp.com/networking/mapping-drives-for-top/

The information is imported into the Total Order Plus invoice history file during the Order Entry End-of-Day processing. Information includes the carrier, tracking number, service type (i.e. UPS Ground), amount of shipping and the ship date. This information is available in the Find Order/Invoice Utility on the Order Entry System Menu.

Setup steps are listed below:

1.     Select Import/Export Data from WorldShip menu

2.     Select Create or edit import or export map

3.     Select Export data from WorldShip

4.     Select Export CSV

5.     Select Freight Shipment

6.     Enter TOP_IMPORT001 and select Create

7.     Add fields in the following order

Package:Reference 1

Shipment Info:Void Indicator

Shipment Info:Lead Tracking Number

Shipment Info:Service Type

Shipment Info:Total Shipment Reference Charge

Package:Reference 2

Package:Reference 3

8.     Select Define

9      Enter V:\CO001\UPS\UPS_CSV_EXPORT.csv

10   Select Save

11. Select Import/Export Data from WorldShip menu

12.  Select Automatic Export During End Of Day

13.  Select More

14.  Select TOP_IMPORT001

15.  Select EXPORT

 

Download Java JDK (Not JRE)

Note: Basis doesn’t support the latest version of Java, so version 8 must be used.

Download from:

http://www.oracle.com/technetwork/java/javase/downloads/jdk8-downloads-2133151.html

Open and run after download

Download BASIS BBj (Includes license manager and JDBC/ODBC driver)
Download from www.basis.com > Products > Downloads > BBj and Barista
Open and run
Select default folder (c:\bbj) and select Typical option
Register for a License
Enter customer name for Customer Name
Enter Mindware info for name/phone/email
Enter License
Enter information from BASIS License Registration Form

Select Register & install a license automatically
Configure the BLM to run as a WIndows Service
Startup Type: Automatic
Start the BASIS License Manager
As a Windows Service
Enter password for user
Start BBj Services
Select Finish

You may need to Allow access to the ThinClientProxyService.exe from your Firewall

Start Enterprise Manager
From Windows Start Select BASIS > BBJ > Browser EM
Double Click on PC Name on left side
User: admin
Password: admin123
Select Login

Create Database
Select Anchor icon under DATABASES to attach database
Click on Databases and Select +
Database Name: TOP_SHP### (### = TOP Company Number)
Dictionary Type: Legacy Format
Data Files: C:\TOP_DATA\CO001\
Data Dictionary: C:\TOP_DATA\SGDIR\
Select OK

Table TOP_SHP### should now display

Create Data Source (With Worldship 2014 You Must Do This From Within Worldship)
Select Start > Control Panel > Administrative Tools > Data Sources (ODBC)
Select System DSN Tab
Select Add Button
Select BBj ODBC Driver
Select Finish Button
Name: TOP_SHP###
Description: Total Order Plus Shipping – ###
Server: Name Of PC
Database: TOP_SHP###
User Name: admin
Password: admin123

Select OK

Install ODBC Driver On UPS PC

The Basis ODBC or JDBC driver will need to be installed to interface with the UPS Worldship software. Below are links for both.

ODBC: https://mindwarecorp.com/top-interfacing/install-basis-odbc-driver/

JDBC: https://mindwarecorp.com/top-interfacing/basis-jdbcodbc-installation/

UPS Worldship Installation

Notes:
Where ever you see ### you will need to replace that with the TOP company number, example 001 for company 1.

Follow the UPS Worldship instructions to install the software on the UPS Worldship CD-Rom if it has not already been installed.

Map Drive on UPS PC

Notes:
It will be necessary to map the UNIX top directory to the R drive on the UPS PC.

Click on this link for how to map TOP drives.

Create Folders on UPS PC

1. Create the following folders on the UPS PC (this can be done from the DOS prompt using the MKDIR command or by using the My Computer icon). You will need to create a CO### folder for each TOP company that is going to be interfaced with UPS.

• C:\TOP_DATA (contains cpy_ups###.bat)
• C:\TOP_DATA\CO### (contains top_ups.tpm)
• C:\TOP_DATA\SGDIR (contains *.1 files)

Download UPS interface files from Mindware website

1. Go to https://mindwarecorp.com/downloads-top-shipping-interface/. Click on Save Target AS -> Click on Browse -> Save files in C:\TOP_DATA\SGDIR folder

2. Unzip the interface files in the C:\TOP_DATA\SGDIR folder

3. Copy C:\TOP_DATA\SGDIR\cpy_ups.bat to the C:\TOP_DATA\CO### folder. The contents of the file is below. You will need to do this for each TOP company.

COPY R:\CO001\OEST1 C:\TOP_DATA\CO001

Notes:
If you are using a company number besides 001, you will need to use NotePad to edit the file. Change the 001 in both places to the correct company number.

4. Copy C:\TOP_DATA\SGDIR\top_ups.tpm to the C:\TOP_DATA\CO### folder. The contents of the file is below. You will need to do this for each TOP company.

DICTIONARY=C:\TOP_DATA\SGDIR\
DATA=C:\TOP_DATA\CO001\

Notes:
If you are using a company number besides 001, you will need to use NotePad to edit the file. Change the 001 to the correct company number.

Create an Icon to Copy the Ship-To File

1. Create an icon for copy command:

Right Click on desktop -> Select New -> Select Shortcut
Use browse to select the C:\TOP_DATA\CO###\CPY_UPS.BAT file
Enter icon name: Copy TOP ### Ship-To File
Select Finish

Create UPS Map
1. Start UPS Worldship software

2. Select Import-Export > Tools

3. Select Connection Assistant

4. Select Create a new map for import -> Select Next

5. For Import Data Type select Shipment -> Select Next

6. Select By Known ODBC Source

7. Select Launch the ODBC Administrator (then follow the steps below)

• Select System DSN Tab
• Select Add Button
• Select BBj ODBC Driver
• Select Finish Button
• Name: TOP_SHP###
• Description: Total Order Plus Shipping – ###
• Server: Name Of PC
• Database: TOP_SHP###
• User Name: admin
• Password: admin123
• Select OK

8. Select TOP_SHP### from ODBC Sources list > Select Next

9. Select New Map

10. Enter TOP_UPS### for New Map Name -> Select Next

11. Select Finish

12. Select OE_SHIPTO for ODBC Table

13. Select Ship To for WorldShip Fields

14. Connect the following fields, first select field from OE_SHIPTOVIEW -> From Ship To Select Connect.

[one_half]

OE_SHIPTO
CC_NAME
SHIPTO_ADD1
SHIPTO_ADD2
SHIPTO_ADD3
SHIPTO_CITY
SHIPTO_NAME
SHIPTO_STATE
SHIPTO_ZIP
SHIPTO_CTRY
ORDER_NO
RECV_UPS_NO

[/one_half]

[one_half]

Ship To
Attention
Address 1
Address 2
Address 3
City or Town
Company or Name
State
Postal/ZIP Code
Country/Territory
Customer ID
Receiver UPS Account Number

[/one_half]

15. Select ORDER_NO then select Define Primary Key for Import button

16. Select Package for WorldShip Fields

[one_half]

OE_SHIPTO Package
ORDER_NO
PO_NO
INVOICE_NO
SHPMNT_VALUE

[/one_half]

[one_half]

TO Package
Reference 1
Reference 2
Reference 3
Declared Value Amount

[/one_half]

17. Select Shipment Information for WorldShip Fields

[one_half]

OE_SHIPTO
SERVICE_TYPE
BILLING_OPT
NOTIFY_FLG
NOTIFY_FLG
EMAIL_ADDR

[/one_half]

[one_half]

Shipment Information
Service Type
Billing Option
QVN Option
QVN Ship Notification Option
Notification Recipient 1 E-mail

[/one_half]

18. Select Ship From for WorldShip Fields

[one_half]

OE_SHIPTO
RETURN_NAME
RETURN_ADD1
RETURN_ADD2
RETURN_CITY
RETURN_STATE
RETURN_ZIP
RETURN_CTRY

[/one_half]

[one_half]

Ship From
Company or Name
Address 1
Address 2
City or Town
State/Province/Country
Postal/ZIP Code
Country/Territory

[/one_half]

19. Select OK

20. Select No to batch import question

Notes:
Repeat for each company beginning with step number 2.

Setup Keyed Import

1. Select UPS OnLine Connect
2. Select Keyed Import
3. Select More
4. Select TOP_UPS### (where ### is the company number)
5. Select Import

Using UPS With TOP ODBC Interface

1. Double Click on Copy TOP Ship-To File icon
2. Start UPS Worldship
3. Select Import-Export
4. Select Keyed Import
5. Select TOP_UPS### (where ### is the company number, if first time select More, then select TOP_UPS###)
6. Enter TOP Order Number (Include leading zeros) and push the Enter or Tab key (below is example of keyed import entry window)

Setting Up Service Type In TOP

1. Enter a ? from any Order Entry Menu
2. Select Ship Via Maintenace
3. Enter F1 for Maintenance from display mode
4. Enter TOP ship via code for UPS
5. Select N to edit
6. Enter correct UPS service type for each corresponding ship via code, see list below:

• Next Day Air Early AM
• Next Day Air
• Next Day Air Saver
• 2nd Day Air AM
• 2nd Day Air
• 3 Day Select
• Ground

 

Download ODBC Driver & BLM
Create C:\TEMP folder if not already there
For Basis ODBC 3.01 Driver: http://njy.b6a.myftpupload.com/downloads-top-odbc-driver/
For Basis BLM License Manager:https://mindwarecorp.com/downloads-top-odbc-license/

Install BLM (BASIS License Manager)
Close all programs
Run C:\TEMP\blmgr11300.exe
UnZip to C:\TEMP
Run C:\TEMP\SETUP.EXE
Select English
Select Next for Welcome Window
Select Yes for Software License Agreement
Select Next for Location
Select Next for Select Program Folder Window
Select Next for Register for a BASIS License
Enter License Registration Information
Company Name:
First Name:
Last Name:
Email Address:
Phone Number:
Serial Number: (On License Registration Form)
Authorization Number: (On License Registration Form)
Select Next
Select Next for License Registration and Delivery Methods
Select OK for License Installed
Select No for installing another license
Select Finish for Installation Complete
Select OK to reboot
Uncheck the readme file option and select Finish
Select Finish for Setup Complete (system will reboot)

Install ODBC Driver
Run C:\TEMP\1467301.exe
UnZip to C:\TEMP
Run C:\TEMP\SETUP.EXE
Select English
Select Next for Welcome Window
Select Yes for Software License Agreement
Select Typical Setup and Next for Setup Type
Select Next for Select Program Folder
Close BASIS ODBC Driver 3.01 Window
Check box for Only check this box if using BASIS License Manager and select Next
Select Yes for Attention warning
Check option for Configure this application to use the BASIS License Manager and select Next
Enter name for PC in box and select Next (Start -> Settings -> Control Panel -> System -> Computer Name)
Select OK for Installation Successful
Select Finish for Installation Complete
Uncheck the readme file option and select Finish

Create TOP Configuration File

File name: /SGDIR/TOP.TPM

Sample TOP.TPM file:
; Top of config file
DICTIONARY=C:\TOP\SGDIR\
DATA=C:\TOP\CO001\
; Bottom of config file

Create Data Source

Select Start -> Settings -> Control Panel -> Administrative Tools

Select Data Sources (ODBC) Icon

Select Add

Select Basis ODBC Driver

Enter Data Source Name: TOP

Enter Data Source Description: Total Order Plus

Enter data source configuration file: drive_dir/SGDIR/TOP.TPM
(drive_dir examples, C:/TOP, /u/top, /<scosysv,port=1100>)

Notes:
If you need to setup ODBC for multiple companies, you will need to repeat the steps above beginning with Create TOP Configuration File. Use the company directory number after TOP (example top3.tpm, data source name top3) for each company you setup.