Important

The WebSell Data Gateway has been deprecated and replaced by the Windward Data Gateway. Follow instructions for installation and configuration of the Windward Data gateway to provide WebSell functionality. Do not install the WebSell Data Gateway any more.

If you are installing WebSell and the customer has Ecomm Staging as well (Sidekick most likely), you need to find the section in the Setup Wizard that allows you to setup the WebSell URL separately from the one Staging uses so they don't conflict and you get two Order import menu items in the Navigator.

This will require at least Zen Actian v14.10.0.035 to work. (There is now an optional true/false setting called V12Compatible that can be added to the WebSellConfig section of the \Settings\WindwardDataGateway_settings.json file. This allows you to use Zen Actian V12 or higher.)
Download and install this version from our SharePoint site V14.10.007.000
Download and patch the installation with V14.11.026.000

WebSell SystemFive Integration has 2 components that allow and control the sync between the website and SystemFive.

Windward Data Gateway
Web Sync
PAM

Web Sync and PAM installation are software provided by WebSell.

Follow this link https://labs.websell.io/support/SYSFI/
Download and install both installers as prompted, no need to change anything

1. Installer

Run the PowerShell installer WWInstallerV2.ps1 as admin to install and then configure the Windward Data Gateway for WebSell support. Download Here

2. Setup the WebSell Setting

The PowerShell installer will prompt for the Server name and DSN and add it to the config JSON file for you.

3. Install the service

The PowerShell script will install, configure and start the Windows Service for you.

4. RECSTATE table with indexes

You should not need to do this step anymore, the RECSTATE table should already be included in the newer release of System5. You can check if it exists via PCC > tables. If it doesn’t, follow the steps below to manually create it.

Open up Pervasive Control Centre (v12) Or Zen Control Centre (v14)
Expand the DSN
Expand Table
And double-click ABSENCE table to load
Delete the command that is already in there
Copy / Paste the commands below

CREATE TABLE RecState IN DICTIONARY USING 'RecState.Btr'(
"Unique" IDENTITY,
"FileType" SMALLINT NOT NULL,
"RecordID" INTEGER NOT NULL,
"RecordGUID" UNIQUEIDENTIFIER NOT NULL,
"OperationType" CHAR(1) NOT NULL CASE,
"TimeStampUTC" DOUBLE NOT NULL,
"UserID" INTEGER NOT NULL );

CREATE INDEX "1_FILETYPE_RECORD" ON "RecState"("FileType", "RecordID");

CREATE INDEX "2_FILETYPE_TIMESTAMPUTC" ON "RecState"("FileType", "TimeStampUTC");

CREATE INDEX "3_RECORDGUID" ON "RecState"("RecordGUID");

NOTE

The command lines above are composed of 2 statements separated by "#". You will need to execute them separately by highlighting the first command then the 2nd. see sample below.

When you have executed both commands, you can close the Absence table and don't SAVE.

5. Disable/Enable "Use Record-State Tracking

This is just to reload the table with fresh records. But if it is not enabled, simply enable it.

Setup Wizard > Miscellaneous

6. Restart the service

Now run “services.msc”

Look for the service name “Windward Data Gateway” and restart it.

7. Test if the gateway is accessible

To test if you can connect to the gateway,

Open a browser and load the URL with the format below

Format: http://SERVERNAME:9934

Note

Since we are at the server at this point, HTTP://localhost:9934 should work the same. Also, the port is the same for all customers.

If there is a firewall on the server, a rule will need to be added to allow inbound traffic for port 9934.

Also if, you get an error loading the "Ecomm Staging Import" in system5 but not from the browser. try to use the Server IP Address instead.

If the IP ADDRESS is not static this will get renewed in a few days and changes.

8. Apply their SystemFive License Code

Ecomm Staging must be enabled

9. Edit SystemFive registry

New Setup Method:

Go into the Setup Wizard, Network Settings, ECOM Staging, WebSell tab and click Enabled and set the WebSell URL here (http://servername:9934) and it will get its own Order import setting and Navigator link (if you don’t see this, S5 may need an update).