...

Info
ROWS requires an X Stream License. Please contact your account manager or technical support for more information.

Table of Contents

ROWS is an integration between two CXT customers for on demand ordersfor on demand orders.

Warning
ROWS will not transfer parcel-level data or signatures through the web service.

As orders are entered in X Dispatch the Operations App on the originator's system, they are transferred via the CXT remote order web service to the recipient's system and will populate as new orders in X Dispatchthe Operations App. As the recipient completes the orders, updates, including completion times for pickups and deliveries along with PODs, are transferred via the CXT web service back to the originator's system.

Information that will transfer through ROWS:

...

At Origin
Picked Up
At Destination
Delivered
Confirmed

...

Configuration for Originator

Fully setup customer record(s).
Create the internet user for the customer record(s). See Internet Users (Classic Operations App) for more information.
- Check the following boxes:
  - Approved
  - Allow Accessorial Charges
- Select other options as needed.
Image RemovedImage Added
Create a human resource record. See Human Resources - New / Edit Human Resource for more information.
On "Misc" tab:
- Enter the following data in the "UserData" fields:
  - UserData1: Internet user's "User ID" from the recipient's system that the orders will be created under.
  - UserData2: Internet user's password from the recipient's system.
  - UserData3: ServiceTypeID from recipient's system that will be used when placing the order. Enter a 0 if no service type will be used. See Service Types (Classic Operations App) for more information.
  - UserData4: Order type ID from the recipient's system. Only one order type per human resource / driver is permitted. For multiple order types, create additional human resources.
  - UserData5: ROWS URL (for originator customer):https://<domain>/rows.rows.asmx
    - Example: https://9999.cxtsoftware.net/rows/rows.asmx
  Image RemovedImage Added
Create a driver record. See Drivers - NClaw / Edisic Driver for more information.
Set up the following:
- Human Resources: Select the human resource created in the previous step.
- Primary Format: Select "ROWS Exchange".
- Primary Email: Enter the ROWS URL from the recipient's system. https://<domain>/rows.rows.asmx@ROWS For cloud customers, <domain> would be <CXTID>.cxtsoftware.net, where <CXTID> is the 4 digit CXT customer id. For example, if the CXT customer id is 9999, this would be https://9999.cxtsoftware.net/rows/rows.
  asmx@ROWS
  asmx@ROWS
Image RemovedImage Added

Note
A human resource / driver record must be created for each order type that the recipient's system will carry out.

Configuration for Recipient

Fully setup customer record(s).
Create the internet user for the customer record(s). See Internet Users (Classic Operations App) for more information.
- Check the following boxes:
  - Approved
  - Allow Accessorial Charges
- Select other options as needed.
Image RemovedImage Added
Create or modify the following message formats: I believe these are included in the baseline database, so they may/should exist for the customer depending on their version of XD.
- ROWS Delivery (Order - Delivered)
  - Set "Message Type" to "Customer - On Demand".
  - Format date as "ddd mm/dd/yy h:nn AM/PM".
  - Check the "Execute SQL Statement" box on the Advanced tab.
  - Enter the following SQL on the Advanced tab for each ROWS message format:
    EXEC spQueueRowsStatusSend
    Code Block
    EXEC spQueueRowsStatusSend @OrderID=[OrderID]
- ROWS Pickup (Order - Picked Up)
  - Set "Message Type" to "Customer - On Demand".
  - Format date as "ddd mm/dd/yy h:nn AM/PM".
  - Check the "Execute SQL Statement" box on the Advanced tab.
  - Enter the following SQL on the Advanced tab for each ROWS message format:
    EXEC spQueueRowsStatusSend
    Code Block
    EXEC spQueueRowsStatusSend @OrderID=[OrderID]
- ROWS Confirmation (Order - Status Update)
  - Set "Message Type" to "Customer - On Demand".
  - Format date as "ddd mm/dd/yy h:nn AM/PM".
  - Check the "Execute SQL Statement" box on the Advanced tab.
  - Enter the following SQL on the Advanced tab for each ROWS message format:
    EXEC spQueueRowsStatusSend
    Code Block
    EXEC spQueueRowsStatusSend @OrderID=[OrderID]
See Message Formats (Classic Operations App) for more information.
Attach the message formats to the customer record where orders are received from the originator.
Image Modified

Note

Order type(s) must have the appropriate "Hours of Operation" enabled, to receive orders.
Image RemovedImage Added
If a service type will be used when placing orders, the service type is assigned to the order type.
Image RemovedImage Added