ERP»X Tuple

X Tuple

xTuple Integration

Integration with xTuple ERP can be setup with NRG Ship Connect. To set this up, follow these steps:

Step 1: Install Ship Connect PHP Interface
To exchange shipping data back a forth, NRG Ship Connect & xTuple communicate via XML communications. Web service coding written in PHP is provided by NRG and facilitates data transfer from PostgreSQL.

  • Copy xTuple directory to /Library/WebServer/Documents on PostgreSQL Server
  • Edit index.php file as needed, lines 24-28 should reference your PostgreSQL Server

23: // Modify the next 5 lines for your PostgreSQL installation
24: $dbhost = 'localhost';
25: $dbport = '5432';
26: $dbname = 'demo';
27: $dbuser = 'admin'; // postgres
28: $dbpass = 'admin'; // demo

Step 2: Enable PHP
Under OS 10.7 Lion: (Highly preferred)

  • Turn off Web Sharing in System Preferences
  • Edit /etc/apache2/httpd.conf file
  • Remove # from line that contains #LoadModule php5_module libexec/apache2/libphp5.so
  • Enable Web Sharing in System Preferences

Under OS 10.6 Snow Leopard:

  • You must download and install an updated version of PHP with PostgreSQL support. Contact NRG Software for further instructions

Step 3: Verify PHP and PostgreSQL Support
In Safari on the server...

Step 4: Configure Ship Connect for xTuple
Open Ship Connect on the shipping station

  • Open Preferences
  • Go to Developer tab
  • Select Import xTuple from Script popup
  • Click on xTuple tab under Ecommerce Integration
  • Enter "http://xx.xx.xxxx/xtuple/" for Host URL (inserting in your server's IP #)
  • Press Test button to verify connectivity

Step 5: Create Import Rules to convert xTuple service values
Open Ship Connect on the shipping station

  • Go to Ship Connect Settings in preferences
  • Click on Import Rules tab
  • Add rules to convert services, ex: service UPS-GROUND-UPS Ground = UPS Ground

Step 6: Ship a Test Order
Open Ship Connect on the shipping station

  • From the Parcel View, enter a valid Shipment # and press Get Order
  • Verify proper data
  • Ship order in Ship Connect
  • In xTuple, verify data has been populated

xTuple Workflow
Ship Connect integration workflow is very similar to xTuple's support for UPS WorldShip without the need to install ODBC software and data mappings. See process flow at http://www.xtuple.org/UpsWorldShip

  • Print Packing Lists
  • Issue to Shipping
  • Ship order in Ship Connect
  • Come back to xTuple and Ship order