Open Endicia and select Edit > Preferences > Data Source and Post-Back tab
Under Source Data > Order Lookup click Configure
Under Data Source click New to open the Data Connections Setup Wizard and make the following selections/entries:
- Shipping data connection method: ODBC Connection
- ODBC Data Source: select the name of the ODBC connection you defined
- User Name & Password: enter your Presidio database User Name & Password
- Create SELECT Statement Choose a table: dbo.vwShipIntegrationSource
- Choose the Order Number field: sLookUpJobSeq
In the Connected Fields section, map the 2 fields on the Package Details tab as shown below:
Click the Edit Service Codes button next to Service and make the following entries
| Service Method |
Code |
| First-Class Package Service |
101 |
| Priority Mail |
130 |
| Media Mail |
104 |
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
Map the 10 fields on the
Recipient Address tab as shown below:
Click OK to complete the Import Setup.
Article ID: 176, Created: March 22, 2022 at 10:45 AM, Modified: March 22, 2022 at 1:31 PM