Windward Software Wiki

The e-commerce replication feature reduces the amount of time that is required to maintain your e-commerce site's inventory by only transferring those records that have changed since the last time you performed an export. Unfortunately, the e-commerce replication feature is not available if another Windward replication product is in use (Polling, Standalone WAN).

When normal replication is enabled for a dataset, it's possible to get similar results as if e-commerce replication were enabled. In order for this to work:

• you must have Pervasive.SQL enabled in System Five
• your replication setup must be configured to replicate inventory
• your replication setup must be configured to fire at least as often as you want to perform inventory updates to your e-commerce site (ie: if you intend to update your e-commerce site weekly, your replication setup should fire at least once a week)

Provided that the above two conditions are true, modify the XML export setting that you use to do your inventory updates and add the following text to the SQL Query field on the Export Settings tab:

SELECT LocalRecordUnique AS InvUnique
FROM DeltaLog
WHERE FileNo = 7
AND DateTime >= TIMESTAMPDIFF(SQL_TSI_DAY, '1899-12-30', NOW()) - 14

This query will cause System Five to export all inventory records that have been exported through replication in the last 14 days. To modify the window of time that the query considers when doing the export, change the number at the end of the last line (in the example above, it's 14). Changing this value to 7 will reduce the window to just the changes that were made in the last 7 days, for example.

Customer has wear enabled on their license codes, all of a sudden they can no longer use the delta table to export.

Fix this by going to the registry within S5, which can be found under Setup Tools, Configuration. From here enter the following into the registry; go to REPLICATION and add the following key; FORCEEREPLICATION and set its value to “Y”. Now quit and reopen S5 and the export should now work again.