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.