Differences between revisions 2 and 3
Revision 2 as of 2012-11-08 20:07:51
Size: 3414
Editor: LanceEdgar
Comment: fix link to git source
Revision 3 as of 2014-05-25 19:36:08
Size: 3406
Editor: LanceEdgar
Comment: Update download link (Trac).
Deletions are marked like this. Additions are marked like this.
Line 40: Line 40:
To see a full list of which types of changes and deletions are supported, it's probably best to go [[http://git.edbob.org/klaus/sms-deploy-rattail/blob/master/Options/Deploy_Rattail/OFFICE/RATTAIL_DEPLOY_CHG.SQI|straight to the source]]. To see a full list of which types of changes and deletions are supported, it's probably best to go [[https://rattailproject.org/trac/browser/sms-deploy-rattail/Options/Deploy_Rattail/OFFICE/RATTAIL_DEPLOY_CHG.SQI|straight to the source]].
Line 46: Line 46:
You can download the latest version [[http://rattail.edbob.org/downloads/Deploy_Rattail/|here]]. You can download the latest version [[https://rattailproject.org/trac/downloads|here]].

DEPLOY_RATTAIL Option for LOC SMS

The DEPLOY_RATTAIL option adds export hooks to (some of) the deployment mechanisms for a server instance of SMS.

What It Does

Whenever a "deploy auxiliary" or "deploy changes" process occurs on the server, the deployed data is written to CSV files within the server's folder structure.

It uses the concept of a "batch" (generic term, not the same as a batch in SMS) which is used to "group" the CSV files, so that it may be possible to determine which go together and which came first, etc. Each batch is given a numeric identifier zero-padded to 8 digits. This identifier is incremented between batches (i.e. deployments). Batch identifiers use a counter which is unique to the batch type; i.e. "auxiliary" batch IDs increment separately from "change" batch IDs.

Deploy Auxiliary

Anytime auxiliary data is deployed from the SMS server, all (supported) auxiliary data is written to a batch of CSV files in the Storeman\XchRattail\Auxiliary folder. As of this writing, an example of the output would be:

  • C:\Storeman\XchRattail\Auxiliary\00000001_CLG_LOAD.CSV

  • C:\Storeman\XchRattail\Auxiliary\00000001_DEPT_LOAD.CSV

  • C:\Storeman\XchRattail\Auxiliary\00000001_SDP_LOAD.CSV

Note that even though the user is prompted as to which auxiliary data they would like to deploy, all auxiliary data is written to a CSV batch regardless of the user's choice. In fact, the CSV data is written before the user is even prompted to choose which data to deploy. This is due to a technical limitation of the hooks made available by the SMS deploy auxiliary script.

Deploy Changes

Anytime changes are deployed from the SMS server, all changed data records (i.e. exactly what is being deployed) is written to a batch of CSV files in the Storeman\XchRattail\Changes folder.

As of this writing, support exists for most of the common tables, and includes both changes and deletions. No files are written for tables which contain no changes or deletions.

In addition to the change/delete files themselves, two "boundary" files are also generated. These currently serve the purpose of letting a file monitor process know when the batch is truly finished being written, as the monitor may simply wait until the "end boundary" file appears. This is done in case the monitor may wish to process the changes/deletions in a particular order, i.e. instead of the order in which DEPLOY_RATTAIL generates them.

As of this writing, an example of the output might be:

  • C:\Storeman\XchRattail\Changes\00000001_CHANGES_BEGIN

  • C:\Storeman\XchRattail\Changes\00000001_CLK_CHG.CSV

  • C:\Storeman\XchRattail\Changes\00000001_OBJ_CHG.CSV

  • C:\Storeman\XchRattail\Changes\00000001_CHANGES_END

To see a full list of which types of changes and deletions are supported, it's probably best to go straight to the source.

Installation

Installing DEPLOY_RATTAIL is done the same as for any other "official" SMS option. Simply place it in your install folder along with the rest of the options and install away.

You can download the latest version here.

Utilities/LOCSMS/DeployRattail (last edited 2021-10-13 18:24:26 by LanceEdgar)