Set Up Data Post-Back
The data post-back feature lets you get updated shipment data from both Order Lookup and Batch Print back into your data source. The data post-back feature is optional.
By entering static field values, such as text, in posting back data, Endicia Professional can write fixed data, such as SHIPPED, with each data post-back action that it performs. For more information, see Enter Static Field Values in Posting Back Data.
- Note: The setup or changes that you make in the following Steps apply only to the current profile.
Steps
- Manually start the Data Connections Setup wizard for Post-Back Data:
- Select Edit > Preferences.
- Select the Data Source and Post-Back tab.
- In the Post Back Data areas, select your data source type:
- Database or CSV/Text File
- QuickBooks
- Click the Configure button.
Select Data Map > New.
The Data Connections Setup wizard automatically starts.
- Click Next.
- Select a data source connection type, and complete the wizard:
- OLE-DB
- Dynamic Excel Integration
- ODBC
For guidance on connecting to specific types of databases, see:
After completing the wizard, the Post Back Data Map window appears.
- On the Post Back Data Map window, if the Table field is available (under the Data Source field), select your database table.
Otherwise, proceed to the following Step.
- On the Package Details tab, on the Order Number row, click the Select button, and then select the field from your data source that corresponds to (connects or maps to) the Order Number.
- For the remaining data post-back fields on the various tabs, continue mapping your fields to the Endicia Professional fields that you require for posting back.
For example, you might want to map the Tracking Number, Postmark Date, and Transaction Date Time fields for writing back to your data source.
- Optional: If you are posting back using Dynamic Excel Integration, you can customize the post-back formulas (otherwise, skip to Step 7)... ...MORE Customized formulas are advanced feature that requires knowledge of Excel formulas. For more information, see also See "About Connecting to Microsoft Excel" and See "About Using Excel Formulas in the Post-Back Process".
To customize post-back formulas:On the row that you want to customize the formula, click the Formula button.
By default a variable appears in the field.
- Enter your formula customization:
- Enter Excel formulas on the field.
- Select from the variables list and click the Add to Formula button.
Each variable begins with a dollar sign—$. - Tip! Each selected variable displays a specific help in the upper left area.
- To revert to the Endicia Professional default formula, click Restore Default Formula.
When done, close the Excel Formula window: click OK.
On the Post Back Data Map window, the Formula button is in bold font to indicate an edited formula.
- When you have completed mapping your fields, click OK.
- Specify your data post-back options:
- On the Data Source and Post-Back tab, click the Options button.
- Review and select your options:
- Edit Post-Back Fixed Data: Click the button and enter text to appear in the Description and Rubber Stamp fields when posting back.
- Automatically post back data.
- Post back data from test prints.
- Post back records missing reference ID's.
- Always insert new records.
- Delete records after post-back.
- Display Columns: Select which fields to display for post back.
- Click OK.
-
Optional: Determine whether you need to close your database connection after completion of posting-back data.
For more information, see Disconnect Upon Post-Back Completion.
After you have set up data post-back, you need to configure automatic data post-back.
Copyright © 2017 Endicia. All Rights Reserved.