Cyrious Control integrates with Endicia so that USPS shipping address information may be automatically retrieved and tracking and cost information can be fed back into Control during the closeout process.

1. Update Control and the SSLIP to 05.50 or later.

1. Start the SSLIP and log into Control to ensure that the database is up-to-date.

NOTE: If you do not upgrade to the version above or newer this article will not work.

1. Run SQL Server's Management Studio application and log into SQL Server.

1. Expand Security folder then right-click Logins and click New Login.

1. Login Name will be shipper.

1. Select SQL Server Authentication.

1. Password will be autoshipper.

1. Uncheck “Enforce Password Policy”.

1. Select “Server Roles” on left hand list.

1. Select ALL checkboxes on right side.

1. Click OK and close Management Studio.

1. Open Control panel in Windows and go to Administrative Tools.

1. Open Data Sources(ODBC).

1. Click on System DSN tab.

1. Click Add and select SQL Server entry from list.(Bottom of list)

1. Name Data Source ControlSQL.

1. Server value will be \

1. Click Next.

1. Choose “With SQL Server authentication…” option.

1. Click “Client Configuration” button.

1. Select TCP/IP and uncheck “Dynamically Determine Port” option.

1. Set Port Number to 1433.

1. Click OK.

1. Login ID should be shipper.

1. Password will be autoshipper.

1. Click Next.

1. Select “Change the default database to:” option to StoreData.

1. Click Next and click Finish.

1. Test the data source and verify that you are able to connect to the server.

1. Click OK to close ODBC Administrator.

1. If Starting up for the first time, you'll come across a “Source Data Connection” screen with an “Edit Source Data Map”, Click on that.

start_data_base_linking.bmp_width400

  * If Endicia has been setup already, you can access this by going to Edit -> Preferences -> Data-Source and Post-Back, for Order Lookup select Datasource OR CSV/TextFile, then click on "Configure" next to it. Then, under the Data Source section, click on "New".

preference_screen_for_mapping.bmp_width600

1. This will be the “Create New Data Source” screen. Select the first radio button option for “Create a new data source (using OLE_DB) for Microsoft Access, Excel, SQL Server, Text/CSV files, or Visual FoxPro”.

select_datasource.bmp_width400

1. Click Next

1. For the dropdown on the next screen for Data Provider, select “Microsoft SQL Server”

1. Click Next

select_odbc_source.bmp_width400

1. The screen will load all of the computers that it sees. Once done, select the Server name that SQL is installed on. Then type in the name of the Database. For most customers, this is StoreData

1. Click Next

select_database.bmp

1. Choose “SQL Authentication” as the database login, and use the credentials from the steps above. Login ID is shipper. Password is autoshipper.

datasource_login.bmp_width400

1. Check the box for “Show database connection string.

1. Click Next

1. In the connection string, look for the portion that states “Data Source=SERVERNAME”. This will need to be modified to include the Instance of SQL that that database is installed on. For example “Data Source=SERVERNAME\SQL2008R2” for an instance of SQL installed on 2008 R2 instance.

edit_connection_string.bmp_width400

1. Click Next

1. Name the Data Source, such as “Cyrious”

name_datasource.bmp_width400

1. Click on Next

1. Click on OK

1. If Starting up for the first time, you'll come across a “Source Data Connection” screen with an “Edit Source Data Map”, Click on that.

start_postback_linking.bmp_width400

  * If Endicia has been setup already, you can access this by going to Edit -> Preferences -> Data-Source and Post-Back, for Post-Back Data select Datasource OR CSV/TextFile, then click on "Configure" next to it. Click on the Top Left Icon for "New Data Map"

1. Follow all of the above instructions for Source Mapping to create a Post-Back Mapping

1. Go to Edit → Preferences → Data-Source and Post-Back, for Order Lookup select Datasource OR CSV/TextFile, then click on “Configure” next to it.

1. Click on “Guild Me” under the SELECT Statement section

1. Click on Next

1. For “Choose a table or other object”, pull the box down and select “dbo.ShipperInfoForShipments”

1. Click Next

select_table_object.bmp_width400

1. For “Choose the Order Number Field”, select “OrderNumber”

1. Click Next

1. Click OK

1. Under Package Details: (Endicia Field → Cyrious Field)
   • Order Number → OrderNumber
   • Mail Class → CarrierService
   • Value → InsuredValue
   • Description → Description
   • Weight → Weight

package_details.bmp

1. Under Recipient Address: (Endicia Field → Cyrious Field)
   • Name → FullName
   • Company → CompanyName
   • Address 1 → StreetAddress1
   • Address 2 → StreetAddress2
   • City → City
   • State → State
   • Postal Code → PostalCode
   • Country → Country
   • Email → Email
   • Phone → Phone

recipient_address_details.bmp

1. Under Return Address (Endicia Field → Cyrious Field)
   • Address 1 → ShipFromStreetAddress1
   • Address 4 → ShipFromCity
   • Address 5 → ShipFromState
   • Address 6 → ShipFromPostalCode
   • Check “Combine lines 4, 5, and 6 into line 4 as City, State, Zip”

return_address_details.bmp_width400

1. Click OK

1. Go to Edit → Preferences → Data-Source and Post-Back, for Post-Back Data select Datasource OR CSV/TextFile, then click on “Configure” next to it.

1. Click on the “Select” button next to Table.

1. Select “dbo.UPSShippingLogForShipments”

1. Select OK

1. For Package Details (Endicia Field → Cyrious Field, can use the “Select” button next to each to select it)
   • Order Number → OrderNumber
   • Postage Amount → ShipperCharge
   • Tracking Number → TrackingNumber
   • Postmark Date → ShipDate
   • Actual Weight → Weight

package_details_postback.bmp

1. On the Order Lookup Tab, enter the Shipment Number (Ex: 1000-SAA) in the first field under Shipping Address

1. Click Retrieve Order

include_componentbacklinks