Difference between revisions of "Shipping Integration"

From Fishbowl
Jump to navigation Jump to search
m
Line 25: Line 25:
 
# Click the '''Test Connection''' button to ensure you can connect to your database and then Click '''OK'''.
 
# Click the '''Test Connection''' button to ensure you can connect to your database and then Click '''OK'''.
  
=== ODBC troubleshooting ===
+
Click [[#ODBC troubleshooting|here]] for ODBC troubleshooting information.
 
 
Below is some troubleshooting information that may be helpful when completing the ODBC setup.
 
 
 
'''32bit/64bit'''
 
* The first question to ask when setting up or troubleshooting ODBC connection issues is “Is this computer 32bit or 64bit?” The answer to this question then prompts where you setup the ODBC. Follow the appropriate steps found [[#ODBC_Setup|here]].
 
* Also, make sure that the ODBC connection, named Fishbowl, is only setup in one of the two available places available. You can setup other connections to the Fishbowl database for other purposes but DO NOT name them “Fishbowl”.
 
* Using the ODBC connection for something other than UPS/FedEx, such as Microsoft Access.
 
** When running a 64bit computer and Microsoft access, the ODBC needs to be setup in Control Panel > Administrative Tools > Data Sources (ODBC) > System DSN tab.
 
** Use the fbclient64.dll file.
 
** Make sure to not name it Fishbowl if you use UPS/FedEx/Endicia. If you don’t, it doesn’t matter what you name it.
 
** The rest of the setup of that ODBC is the same as for UPS/FedEx/Endicia.
 
* Sometimes, if the Test Connection keeps erroring out and everything looks correct,  you can click Ok > then click Add > re-add all the information and click Test Connection and it will connect. Random, but it’s worked a lot for me.
 
 
 
'''Using the wrong .dll file'''
 
* When running a 32bit computer, you will never have this issue. This is most common with 64bit machines.
 
* The fbclient64.dll cannot be used in the ODBC setup for the UPS/FedEX/Endicia integration.
 
* Use the fbclient32.dll found [http://www.fishbowlinventory.com/wiki/images/fbclient32.dll here]. If there are still connection issues, try grabbing the fbclient32.dll from the Fishbowl server computer in C:\Program Files (x86)/Fishbowl/database/odbc.
 
 
 
'''Firewall/Antivirus'''
 
* The firewall is blocking port 3050. You can try placing 3050 in the server path to see if that allows the connection. An example of how this would look is here: (192.168.25.2:3050:C:\Program Files (x86)\Fishbowl\database\data\example.FDB) This will most likely still fail, but it’s something I always try. So, now, follow these steps to dig deeper:
 
** Open the command prompt and type: telnet ServerIPAddress 3050. An example of how this would look: telnet 192.168.25.2 3050.
 
* If you receive an error that telnet is not a recognized command follow [http://www.leateds.com/2009/telnet-for-windows-vista-windows-7/ these instructions]. Choose Telnet Client and Telnet Server.
 
** If the command prompt screen goes blank, that means you have a connection and there is not an issue with this port being blocked. In this case, go back and triple check the settings above. (You can continue on and open ports and see if that makes a difference if you want but it more than likely something setup wrong.)
 
** If you receive an error about it failing to connect, you more than likely have a firewall problem. So, you will need to open the ports. Here is how.
 
* (WARNING: Opening firewall ports can potentially be a security risk. For more information, we recommend consulting with your IT professional.) On the Fishbowl Server computer, go to Control Panel, System and Security, Windows Firewall. Click on Advanced Settings on the left hand side and this will open a screen where you can setup rules to unblock port 3050. Click on Inbound Rules and then click New Rule on the right hand side. Choose Port, then choose TCP (you will repeat this same process for UDP) and enter 3050 as the specific port. Choose Allow the Connection in the next screen and choose all in the next screen and then name is Fishbowl 3050 TCP (or Fishbowl 3050 UDP). Click Finish and you are done, after you have created both. Now go back to the client computer and click test connection and it will connect.
 
 
 
'''Fishbowl Hosted Services'''
 
* Some customers have desired to keep UPS/FedEx/Endicia on their local machines when using Fishbowl Hosted Services. This is currently under construction and being tested. This page will be updated with steps as soon as we have them locked down.
 
 
 
'''Random Troubleshooting Setup'''
 
* If you are setting up the ODBC and it just keeps failing over and over and everything looks correct, you can try one more thing. Click OK to close that connection you were working on and click Add to add a new connection and just enter all of the settings again. Surprisingly, this will connect and you can then just delete the other connection. I’ve had about a 97% success rate by doing this. Odd, but it works.
 
  
 
== FedEx integration ==
 
== FedEx integration ==
Line 144: Line 113:
 
# Place a checkmark next to '''Automatically post back data''', click '''OK''', and then click the '''X''' in the top-right corner to close the '''Post-Back''' window.<br>[[File:Endicia Automatically Post Back Data.png]]
 
# Place a checkmark next to '''Automatically post back data''', click '''OK''', and then click the '''X''' in the top-right corner to close the '''Post-Back''' window.<br>[[File:Endicia Automatically Post Back Data.png]]
 
# Click the '''Order Lookup''' tab in the main window, enter a Sales Order number, and then click '''Retrieve Order''' to pull information from Fishbowl.<br>[[File:Endicia Order Lookup.png]]
 
# Click the '''Order Lookup''' tab in the main window, enter a Sales Order number, and then click '''Retrieve Order''' to pull information from Fishbowl.<br>[[File:Endicia Order Lookup.png]]
 +
 +
== Troubleshooting ==
 +
 +
=== ODBC troubleshooting ===
 +
 +
Below is some troubleshooting information that may be helpful when completing the ODBC setup.
 +
 +
'''32bit/64bit'''
 +
* The first question to ask when setting up or troubleshooting ODBC connection issues is “Is this computer 32bit or 64bit?” The answer to this question then prompts where you setup the ODBC. Follow the appropriate steps found [[#ODBC_Setup|here]].
 +
* Also, make sure that the ODBC connection, named Fishbowl, is only setup in one of the two available places available. You can setup other connections to the Fishbowl database for other purposes but DO NOT name them “Fishbowl”.
 +
* Using the ODBC connection for something other than UPS/FedEx, such as Microsoft Access.
 +
** When running a 64bit computer and Microsoft access, the ODBC needs to be setup in Control Panel > Administrative Tools > Data Sources (ODBC) > System DSN tab.
 +
** Use the fbclient64.dll file.
 +
** Make sure to not name it Fishbowl if you use UPS/FedEx/Endicia. If you don’t, it doesn’t matter what you name it.
 +
** The rest of the setup of that ODBC is the same as for UPS/FedEx/Endicia.
 +
* Sometimes, if the Test Connection keeps erroring out and everything looks correct,  you can click Ok > then click Add > re-add all the information and click Test Connection and it will connect. Random, but it’s worked a lot for me.
 +
 +
'''Using the wrong .dll file'''
 +
* When running a 32bit computer, you will never have this issue. This is most common with 64bit machines.
 +
* The fbclient64.dll cannot be used in the ODBC setup for the UPS/FedEX/Endicia integration.
 +
* Use the fbclient32.dll found [http://www.fishbowlinventory.com/wiki/images/fbclient32.dll here]. If there are still connection issues, try grabbing the fbclient32.dll from the Fishbowl server computer in C:\Program Files (x86)/Fishbowl/database/odbc.
 +
 +
'''Firewall/Antivirus'''
 +
* The firewall is blocking port 3050. You can try placing 3050 in the server path to see if that allows the connection. An example of how this would look is here: (192.168.25.2:3050:C:\Program Files (x86)\Fishbowl\database\data\example.FDB) This will most likely still fail, but it’s something I always try. So, now, follow these steps to dig deeper:
 +
** Open the command prompt and type: telnet ServerIPAddress 3050. An example of how this would look: telnet 192.168.25.2 3050.
 +
* If you receive an error that telnet is not a recognized command follow [http://www.leateds.com/2009/telnet-for-windows-vista-windows-7/ these instructions]. Choose Telnet Client and Telnet Server.
 +
** If the command prompt screen goes blank, that means you have a connection and there is not an issue with this port being blocked. In this case, go back and triple check the settings above. (You can continue on and open ports and see if that makes a difference if you want but it more than likely something setup wrong.)
 +
** If you receive an error about it failing to connect, you more than likely have a firewall problem. So, you will need to open the ports. Here is how.
 +
* (WARNING: Opening firewall ports can potentially be a security risk. For more information, we recommend consulting with your IT professional.) On the Fishbowl Server computer, go to Control Panel, System and Security, Windows Firewall. Click on Advanced Settings on the left hand side and this will open a screen where you can setup rules to unblock port 3050. Click on Inbound Rules and then click New Rule on the right hand side. Choose Port, then choose TCP (you will repeat this same process for UDP) and enter 3050 as the specific port. Choose Allow the Connection in the next screen and choose all in the next screen and then name is Fishbowl 3050 TCP (or Fishbowl 3050 UDP). Click Finish and you are done, after you have created both. Now go back to the client computer and click test connection and it will connect.
 +
 +
'''Fishbowl Hosted Services'''
 +
* Some customers have desired to keep UPS/FedEx/Endicia on their local machines when using Fishbowl Hosted Services. This is currently under construction and being tested. This page will be updated with steps as soon as we have them locked down.
 +
 +
'''Random Troubleshooting Setup'''
 +
* If you are setting up the ODBC and it just keeps failing over and over and everything looks correct, you can try one more thing. Click OK to close that connection you were working on and click Add to add a new connection and just enter all of the settings again. Surprisingly, this will connect and you can then just delete the other connection. I’ve had about a 97% success rate by doing this. Odd, but it works.

Revision as of 18:04, 10 June 2013

In addition to Fishbowl's built-in UPS features, Fishbowl can also be integrated with FedEx, WorldShip, and Endicia by utilizing a technology called Open Database Connectivity or ODBC.

ODBC setup

Fishbowl runs on a database management system called Firebird. Firebird has an ODBC Driver (Open Database Connectivity) that allows other programs like FedEx, WorldShip, and Endicia to connect with the Fishbowl database. To setup the ODBC connection, complete the steps below on each computer that will be using a shipping application.

  1. Locate the Firebird ODBC installer found inside the Fishbowl installation directory. Take note of the file location and the last two numbers of the filename which indicate whether you have a 32-bit or a 64-bit system.
    • 32-bit: Default location is C:\Program Files\Fishbowl\odbc\Firebird_ODBC_Win32.exe
    • 64-bit: Default location is C:\Program Files (x86)\Fishbowl\odbc\Firebird_ODBC_x64.exe
  2. Run the Firebird ODBC installer and complete the installation using the default settings.
  3. Open the ODBC Data Source Administrator window. If you are on a 64-bit system (you ran the 64-bit installer in step 1) it is important that you open the file referenced below, instead of the Control Panel.
    • 32-bit: Open the Control Panel, go to Administrative Tools, and then click Data Sources (ODBC)
    • 64-bit: Open C:\Windows\SysWOW64\odbcad32.exe
  4. Click the System DSN tab and then click the Add button.
  5. Select the Firebird/Interbase driver and then click Finish.
  6. A new Firebird ODBC Setup window will appear. Enter the following information in the appropriate fields. The fields are case-sensitive.
    • Data Source Name (DSN): Fishbowl
    • Database: This is the location of your company's Fishbowl database.
      • If you are setting up the ODBC on a Fishbowl Client computer, the path must include the computer name or IP address of the Fishbowl Server computer, for example: 192.168.1.10:C:\Program Files\Fishbowl\database\data\MYCOMPANY.FDB. If you are unable to establish on ODBC connection, you may need to open port 3050 on the server computer.
    • Client: Browse to the odbc folder inside the Fishbowl installation directory and select fbclient32.dll
      • 64-bit: If you do not have fbclient32.dll, you may download it here and then paste it in the odbc folder. You may also copy the file from the Fishbowl\database\odbc directory on the Server computer.
    • Database Account: GONE
    • Password: fishing
    • All other fields: No change necessary
      Firebird ODBC setup.png
  7. Click the Test Connection button to ensure you can connect to your database and then Click OK.

Click here for ODBC troubleshooting information.

FedEx integration

Follow the steps below to complete the FedEx Integration:

  1. Complete the ODBC setup.
  2. Install the latest version of FedEx Ship Manager. The installer can be downloaded by completing this form.
  3. Turn on the ability to show hidden files. (Windows 7 instructions - Windows XP instructions)
  4. Download the .XML files for FedEx by clicking this link.
  5. Paste the .XML files into the FedEx Profiles folder. The location of the Profiles folder varies with different versions, but is typically in one of the following locations.
    • C:\ProgramData\FedEx\Integration\Profiles
    • C:\Documents and Settings\All Users\Application Data\FedEx\Integration\Profiles
  6. Open FedEx Ship Manager.
  7. Click the Integration menu and select FishbowlSingle.
  8. The Lookup Value window will appear. If not, ensure the ODBC driver is installed correctly. Enter the sales order number and click OK.
    FedEx Lookup Value.png
    • NOTE: The sales order must be in the Shipping module to show up in FedEx and the order number must be entered exactly as it appears in Fishbowl.
  9. The order should have now pulled in. If the carton weight was set in Fishbowl, this will pull into FedEx. Otherwise, the weight can be added in FedEx. Once the information is correct, click Ship. This will print a label and send the tracking number, cost, and updated weight back into Fishbowl to finish.

UPS integration

NOTE: All versions of Fishbowl 2013 and later are UPS.png UPS Ready® which means that UPS features are built into Fishbowl and directly accessible with no additional software required. The instructions below are for integrating with UPS WorldShip, which is no longer required for Fishbowl 2013 or later. For instructions on setting up UPS directly from Fishbowl, see UPS setup.

Follow the steps below to complete the UPS WorldShip Integration:

  1. Complete the ODBC setup.
  2. Install the latest version of UPS WorldShip. The installer can be downloaded by completing this form.
  3. Download the .dat files for UPS by clicking here. To download individual .dat files, see UPS WorldShip Mapping Files.
  4. Paste the .dat files into the UPS Shipment folder. The location of the Shipment folder varies with different versions, but is typically in one of the following locations.
    • C:\UPS\WSTD\ImpExp\Shipment
    • C:\UPS\UOWS\ImpExp\Shipment
  5. Open UPS WorldShip.
  6. Click the Import/Export Data menu, click Automatic Export After Processing Shipment, and then click More.
  7. Select Fishbowl Export from the list and click Export.
  8. Click on Import/Export Data menu, click Automatic Export During End of Day, and then click More.
  9. Select Fishbowl Export from the list and click Export.
  10. Click on Import/Export Data menu, click Keyed Import, and then click More.
  11. Select FishbowlSO, FishbowlPO, or FishbowlXO (Sales Order, Purchase Order, or Transfer Order) from the list and click Import.
  12. The Enter Import Key window will appear. If not, ensure the ODBC driver is installed correctly. Enter the sales order number and press Enter on the keyboard.
    UPS Enter Import Key.png
    • NOTE: The sales order must be in the Shipping module to show up in UPS and the order number must be entered exactly as it appears in Fishbowl.
  13. The order should have now pulled in. If the carton weight was set in Fishbowl, this will pull into UPS. Otherwise, the weight can be added in UPS. Once the information is correct, click Process Shipment. This will print a label and send the tracking number, cost, and updated weight back into Fishbowl to finish.

Troubleshooting tips

In either UPS or FedEx if you get an error to the effect of "Order Num Not Found" or "No Data given for the key value", check the following things:

  • Make sure that the ODBC connection is pointing to the correct database. If it is not looking at your current database, orders that you see in Fishbowl cannot be seen by the shipping software.
  • Ensure there is a country listed on the Ship To address on the Sales Order in Fishbowl, and that there is a default phone number listed for the customer. Add the country to the Ship To address if it is not there, and you can check the customer default phone number by going to Sales > Customer module > Contacts tab, and verify that the default box is checked for the customer. If you don't have a country or default phone number for most of your customers, you can always opt to have that information disconnected from the import, meaning it won't be imported into UPS or FedEx. To have that done, contact technical support.

If you receive an error that UPS or FedEx cannot export the tracking information back to Fishbowl, or the information just doesn't show up in Fishbowl after shipping the order in UPS or FedEx, check the following things:

  • In Fishbowl, reopen the sales order number in question from the search pane on the left of the Shipping Module. This will refresh the order and show any changes that were made to the order, like the tracking information being exported.
  • If you're using UPS, make sure that "Fishbowl Export" is selected under the Import/Export Data > Automatic Export After Processing Shipment menu.
  • If you still have issues after checking those things, contact technical support.

In the event that UPS has "found multiple records", you will need to manually edit the package information after importing and before processing labels. UPS will only import the original shipment, and will therefore export carton tracking number(s), cost(s) and weight(s) back to that shipment rather than the current one. This occurs even if the original shipment has already been fulfilled, possibly weeks prior. Follow these steps to avoid this potential problem:

  • Delete all values from the Ref 2 field in WorldShip. These numbers refer to the specific cartons, which are from to the original shipment. The correct Ref 2 codes cannot be imported.
  • Correct the shipping service class and package weight(s), if necessary
  • Process the shipment, and manually copy the resulting tracking number and cost into Fishbowl.

Endicia integration

  1. Complete the ODBC setup.
  2. Create a Professional account on Endicia.com and download the Endicia Professional Suite. Run the installer and install Dazzle and Endicia Professional.
  3. Open Endicia Professional, click the Edit menu, choose Preferences, click on the Database tab, and then click the Edit Order Lookup Data Map button.
    Endicia Edit Order Lookup Data Map.png
  4. Click the New button in the Data Source area.
    Endicia New Data Source.png
  5. Click Next, choose the ODBC data source option, and then click Next.
    Endicia Create ODBC Step.png
  6. Select Fishbowl from the dropdown. Leave the User Name and Password fields blank, and then click Next and OK to complete the wizard.
    Endicia ODBC Data Source.png
  7. If you see the Create a SELECT Statement window, click Cancel to dismiss it.
    Endicia Select Statement Wizard.png
  8. Click the Advanced Editor button in the SELECT Statement area.
    Endicia Advanced Editor.png
  9. Paste the following query into SQL Editor window and then click OK.

    SELECT so.num AS ordernumber, shipcarton.id as groupcode, so.cost, shipcarton.freightweight as weight, so.customercontact as name, so.shiptoname as company, so.shiptoaddress as address1, so.shiptocity as city, stateconst.code as state, so.shiptozip as postalcode, countryconst.abbreviation as country, carrier.name, shipcarton.cartonnum, customercontactview.contactnum as phone, ( select First 1 coalesce(mainEmail.datus, billEmail.datus) as CustomerEmail from so inner join customer on so.customerid = customer.id left join address mainaddress on (customer.accountid = mainaddress.accountid and mainaddress.typeid = 50 and mainaddress.defaultflag = 1) left join address billtoaddress on (customer.accountid = billtoaddress.accountid and billtoaddress.typeid = 20) left join contact mainEmail on (mainaddress.id = mainEmail.addressid and mainEmail.typeid = 60 and mainEmail.DEFAULTFLAG = 1) left join contact billEmail on (billtoaddress.id = billEmail.addressid and billEmail.typeid = 60 and billEmail.Defaultflag = 1 ) WHERE so.num='$ORDERNUMBER' ) as CustomerEmail FROM so LEFT JOIN countryconst ON so.shiptocountryid = countryconst.id LEFT JOIN stateconst ON so.shiptostateid=stateconst.id LEFT JOIN carrier ON so.carrierid = carrier.id LEFT JOIN shipcarton ON so.id = shipcarton.orderid LEFT JOIN customercontactview ON so.customerid=customercontactview.custid WHERE so.num='$ORDERNUMBER'

    Endicia Query.png
  10. Select the following fields in the Connected Fields area:
    Endicia Connected Fields.png
    • Select the following fields on the Package Details tab:
      Order Number -> SONUMBER, Group Number -> SHIPCARTONID, Value -> COST, Weight -> FREIGHTWEIGHT
      Make sure to check the Weight is in pounds checkbox.
    • Select the following fields on the Recipient Address tab:
      Name -> CUSTOMERCONTACT, Company -> SHIPTONAME, Address 1 -> SHIPTOADDRESS, City -> SHIPTOCITY, State -> CODE, Postal Code -> SHIPTOZIP, Country -> ABBREVIATION, Phone -> CONTACTNUM
    • Select the following fields on the Rubber Stamps tab:
      Rubber Stamp 1 -> SHIPCARTONID
    • OPTIONAL: Select CUSTOMEREMAIL in the Email field on the Recipient Address tab to automatically send emails via Dazzle.
    • OPTIONAL: Select the BILLTO fields on the Return Addresses tab to bring in a different return address.
  11. Click OK to close the Order Lookup Data Map window, then click the Edit Post-Back Map button on the Database tab.
    File:Endicia Edit Post Back Map.png
  12. Click the New Data Map button in the top-left corner of the Post Back Data Map window.
    Endicia New Data Map.png
  13. Click Next, choose the ODBC data source option, and then click Next.
    Endicia Create ODBC Step.png
  14. Select Fishbowl from the dropdown. Leave the User Name and Password fields blank, and then click Next and OK to complete the wizard.
    Endicia ODBC Data Source.png
  15. Click the Select button to the right of the table field and choose the SHIPPINGIMPORT table.
    Endicia Table Select.png
  16. Select the following fields on the Package Details tab.
    Order Number -> IGNORE, Postage Amount -> CARTONCOST, Tracking Number -> TRACKINGNUM, Transaction ID -> ID, Group Code -> SHIPCARTONID, Actual Weight -> CARTONWEIGHT
    Make sure to check the Weight is in pounds checkbox.
  17. Click OK to close the Post Back Data Map window and then click OK to close the Preferences window.
  18. Click the Tools menu, select Postback Data, and then click Options in the top-left corner.
    Endicia Postback Options.png
  19. Place a checkmark next to Automatically post back data, click OK, and then click the X in the top-right corner to close the Post-Back window.
    Endicia Automatically Post Back Data.png
  20. Click the Order Lookup tab in the main window, enter a Sales Order number, and then click Retrieve Order to pull information from Fishbowl.
    Endicia Order Lookup.png

Troubleshooting

ODBC troubleshooting

Below is some troubleshooting information that may be helpful when completing the ODBC setup.

32bit/64bit

  • The first question to ask when setting up or troubleshooting ODBC connection issues is “Is this computer 32bit or 64bit?” The answer to this question then prompts where you setup the ODBC. Follow the appropriate steps found here.
  • Also, make sure that the ODBC connection, named Fishbowl, is only setup in one of the two available places available. You can setup other connections to the Fishbowl database for other purposes but DO NOT name them “Fishbowl”.
  • Using the ODBC connection for something other than UPS/FedEx, such as Microsoft Access.
    • When running a 64bit computer and Microsoft access, the ODBC needs to be setup in Control Panel > Administrative Tools > Data Sources (ODBC) > System DSN tab.
    • Use the fbclient64.dll file.
    • Make sure to not name it Fishbowl if you use UPS/FedEx/Endicia. If you don’t, it doesn’t matter what you name it.
    • The rest of the setup of that ODBC is the same as for UPS/FedEx/Endicia.
  • Sometimes, if the Test Connection keeps erroring out and everything looks correct, you can click Ok > then click Add > re-add all the information and click Test Connection and it will connect. Random, but it’s worked a lot for me.

Using the wrong .dll file

  • When running a 32bit computer, you will never have this issue. This is most common with 64bit machines.
  • The fbclient64.dll cannot be used in the ODBC setup for the UPS/FedEX/Endicia integration.
  • Use the fbclient32.dll found here. If there are still connection issues, try grabbing the fbclient32.dll from the Fishbowl server computer in C:\Program Files (x86)/Fishbowl/database/odbc.

Firewall/Antivirus

  • The firewall is blocking port 3050. You can try placing 3050 in the server path to see if that allows the connection. An example of how this would look is here: (192.168.25.2:3050:C:\Program Files (x86)\Fishbowl\database\data\example.FDB) This will most likely still fail, but it’s something I always try. So, now, follow these steps to dig deeper:
    • Open the command prompt and type: telnet ServerIPAddress 3050. An example of how this would look: telnet 192.168.25.2 3050.
  • If you receive an error that telnet is not a recognized command follow these instructions. Choose Telnet Client and Telnet Server.
    • If the command prompt screen goes blank, that means you have a connection and there is not an issue with this port being blocked. In this case, go back and triple check the settings above. (You can continue on and open ports and see if that makes a difference if you want but it more than likely something setup wrong.)
    • If you receive an error about it failing to connect, you more than likely have a firewall problem. So, you will need to open the ports. Here is how.
  • (WARNING: Opening firewall ports can potentially be a security risk. For more information, we recommend consulting with your IT professional.) On the Fishbowl Server computer, go to Control Panel, System and Security, Windows Firewall. Click on Advanced Settings on the left hand side and this will open a screen where you can setup rules to unblock port 3050. Click on Inbound Rules and then click New Rule on the right hand side. Choose Port, then choose TCP (you will repeat this same process for UDP) and enter 3050 as the specific port. Choose Allow the Connection in the next screen and choose all in the next screen and then name is Fishbowl 3050 TCP (or Fishbowl 3050 UDP). Click Finish and you are done, after you have created both. Now go back to the client computer and click test connection and it will connect.

Fishbowl Hosted Services

  • Some customers have desired to keep UPS/FedEx/Endicia on their local machines when using Fishbowl Hosted Services. This is currently under construction and being tested. This page will be updated with steps as soon as we have them locked down.

Random Troubleshooting Setup

  • If you are setting up the ODBC and it just keeps failing over and over and everything looks correct, you can try one more thing. Click OK to close that connection you were working on and click Add to add a new connection and just enter all of the settings again. Surprisingly, this will connect and you can then just delete the other connection. I’ve had about a 97% success rate by doing this. Odd, but it works.