Differences between revisions 2 and 3
⇤ ← Revision 2 as of 2008-10-31 04:43:04 →
Size: 2206
Editor: DannyCheung
Comment:
← Revision 3 as of 2009-01-06 02:49:25 → ⇥
Size: 4494
Editor: DannyCheung
Comment:
Deletions are marked like this. Additions are marked like this.
Line 2: Line 2:
Sends data between two sites, usually a branch computer and the HO server. Polling consists of several programs working in unison to create, filter and process data to a store. The programs are controlled by commin. The parameters used with the programs are accessed/altered by comaad. Sends data between two sites, usually a branch computer and the HO server. Polling consists of several programs working in unison to create, filter and process data to a store. The programs are controlled by {{{commin}}}. The parameters used with the programs are accessed/altered by {{{comaad}}}.
Line 5: Line 5:
 1. Transaction or File Maintenance record is created/altered
Line 7: Line 6:
 1. File is filtered for certain transaction/record types  1. File is filtered and converted into a polling file. Filtering is determined by parameters set in comaad->Generate Options
 1. Polling file is filtered for certain transaction/record types before sending to peer. Filtering is determined by parameters set in comaad->Distribute Options
Line 9: Line 9:
 1. Peer filters file for certain transaction/record types  1. Peer filters file for certain transaction/record types. Filtering is determined by comaad->Process Options
Line 11: Line 11:
== Polling File Maintenance Records == == File Maintenance Records ==
Line 14: Line 14:
 1. {{{XXaad}}} creates entry(s) in log.dat
 1. {{{logmin}}} reads entries from log.dat and only outputs certain record types into slog.dat. Effectively, {{{logmin}}} acts as a filter.
 1. slog.dat is sent to the other location
 1. On the other end, {{{logmin}}} reads certain entries from slog.dat and outputs it to another file
 1. On the other end, {{{XXaad}}} processes output file and applies changes.		  1. {{{XXaad}}} creates entry(s) in log.dat.
 1. {{{logmin}}} reads entries from log.dat and only outputs certain record types into slog.dat. {{{logmin}}} simply acts as a filter.
 1. {{{logmin}}} reads entries from slog.dat and only outputs certain record types into rslog.dat.
 1. rslog.dat is sent to the other location
 1. On the other computer, {{{logmin}}} reads certain entries from rslog.dat and outputs it to slog.dat
 1. On the other computer, {{{XXaad}}} processes slog.dat and applies changes.
Line 25: Line 26:
 1. On other computer, {{{reclstr}}} converts sendtrn.dat to daycomm.dat, which just a structurally the same as daytrn.dat  1. On other computer, {{{reclstr}}} converts sendtrn.dat to daycomm.dat, which just structurally the same as daytrn.dat
Line 27: Line 28:
== Debtor Balances ==
 1. {{{sdbrep}}} reads entries from debtr.dat and dumps closing balance into debbal.dat
 1. debbal.dat is sent to the other computer
 1. On the other computer, {{{rdbmin}}} reads in debbal.dat and updates the closing balances for debtors
== Stock Counts ==
 1. {{{spost}}} or {{{stpost}}} places updated stock counts into stcount.dat in accordance to the option in {{{pollcont}}}
 1. {{{sscrep}}} reads in stcount.dat, filters the stock counts and outputs to rstcount.dat
 1. rstcount.dat is sent to the other computer
 1. On the other computer, {{{rscmin}}} reads in stcount.dat and updates the stock counts in the stock file
== Order Deletions and Completions ==
 1. {{{XXeat}}} adds entry in log.dat to denote that a Quote, Customer Order or Purchase Order has been completed
 1. {{{logmin}}} reads entries from log.dat and only outputs certain record types into slog.dat. {{{logmin}}} simply acts as a filter.
 1. {{{logmin}}} reads entries from slog.dat and only outputs certain record types into rslog.dat.
 1. rslog.dat is sent to the other location
 1. On the other end, {{{logmin}}} reads certain entries from slog.dat and outputs it to another file
 1. On the other end, {{{oqdel}}} (which is {{{sieat}}}, but renamed) deletes the completed/deleted quotes and customer orders from tran.dat
 1. On the other end, {{{podel}}} (which is {{{steat}}}, but renamed) deletes the completed purchase orders from tran.dat
== Tenders ==
 1. {{{XXeat}}} adds entry in daytend.dat
 1. {{{stendmin}}} reads daytend.dat, performs some record pointer conversions and outputs to sendtend.dat
 1. {{{stendmin}}} reads sendtend.dat, filters the tenders and outputs to rsendtend.dat
 1. rsendtend.dat is sent to the other computer
 1. On the other computer, {{{stendmin}}} reads rsendtend.dat, filters the tenders and outputs to stendtend.dat
 1. On the other computer, {{{stendmin}}} reads in sendtend.dat and updates tender.dat

Polling

Sends data between two sites, usually a branch computer and the HO server. Polling consists of several programs working in unison to create, filter and process data to a store. The programs are controlled by commin. The parameters used with the programs are accessed/altered by comaad.

General Polling Process

  1. Transaction or File Maintenance record changes are saved to a file

  2. File is filtered and converted into a polling file. Filtering is determined by parameters set in comaad->Generate Options

  3. Polling file is filtered for certain transaction/record types before sending to peer. Filtering is determined by parameters set in comaad->Distribute Options

  4. File is sent to peer

  5. Peer filters file for certain transaction/record types. Filtering is determined by comaad->Process Options

  6. Peer adds transaction/record changes into it's own database

File Maintenance Records

When a new file maintenance record is added, a copy of the record (along with some extra information) will be placed in the "logfile" (log.dat). When you delete a record, an entry in the logfile will also be created. Altering a file maintenance record will create two entries in log.dat. One will be a snapshot of the record before the change and the other will be a copy of the record after the change.

  1. XXaad creates entry(s) in log.dat.

  2. logmin reads entries from log.dat and only outputs certain record types into slog.dat. logmin simply acts as a filter.

  3. logmin reads entries from slog.dat and only outputs certain record types into rslog.dat.

  4. rslog.dat is sent to the other location

  5. On the other computer, logmin reads certain entries from rslog.dat and outputs it to slog.dat

  6. On the other computer, XXaad processes slog.dat and applies changes.

Transactions

  1. XXeat creates an entry in daytrn.dat

  2. sen2post copies the entries from daytrn.dat, adds a bit of extra information and outputs it to sendtrn.dat

  3. sendpost reads sendtrn.dat and outputs certain transactions to rsndtrn.dat

  4. rsndtrn.dat is sent to other computer

  5. On other computer, sendpost reads in rsndtrn.dat, filters transactions and outputs to sendtrn.dat

  6. On other computer, reclstr converts sendtrn.dat to daycomm.dat, which just structurally the same as daytrn.dat

  7. On other computer, XXpost will now add transactions to its transaction history file

Debtor Balances

  1. sdbrep reads entries from debtr.dat and dumps closing balance into debbal.dat

  2. debbal.dat is sent to the other computer

  3. On the other computer, rdbmin reads in debbal.dat and updates the closing balances for debtors

Stock Counts

  1. spost or stpost places updated stock counts into stcount.dat in accordance to the option in pollcont

  2. sscrep reads in stcount.dat, filters the stock counts and outputs to rstcount.dat

  3. rstcount.dat is sent to the other computer

  4. On the other computer, rscmin reads in stcount.dat and updates the stock counts in the stock file

Order Deletions and Completions

  1. XXeat adds entry in log.dat to denote that a Quote, Customer Order or Purchase Order has been completed

  2. logmin reads entries from log.dat and only outputs certain record types into slog.dat. logmin simply acts as a filter.

  3. logmin reads entries from slog.dat and only outputs certain record types into rslog.dat.

  4. rslog.dat is sent to the other location

  5. On the other end, logmin reads certain entries from slog.dat and outputs it to another file

  6. On the other end, oqdel (which is sieat, but renamed) deletes the completed/deleted quotes and customer orders from tran.dat

  7. On the other end, podel (which is steat, but renamed) deletes the completed purchase orders from tran.dat

Tenders

  1. XXeat adds entry in daytend.dat

  2. stendmin reads daytend.dat, performs some record pointer conversions and outputs to sendtend.dat

  3. stendmin reads sendtend.dat, filters the tenders and outputs to rsendtend.dat

  4. rsendtend.dat is sent to the other computer

  5. On the other computer, stendmin reads rsendtend.dat, filters the tenders and outputs to stendtend.dat

  6. On the other computer, stendmin reads in sendtend.dat and updates tender.dat

Polling (last edited 2022-04-13 03:06:32 by 203-206-72-221)