4.7.3 Create Endicia Import Map

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.