afsDataFTP.exe

afsDataFTP.exe is an application used to send afstrade reference data to a remote source, as data is updated in afstrade.  This application will FTP files, containing afstrade reference data, to a specified directory (see FTPDIRECTORY) on a remote ftp server.  The files will be named using the format AFSData_YYYYMMDD_<counter>.txt, e.g. AFSData_ 20030708_0000001034.txt

Each ftp'd file will be followed by an empty trigger file, a file with the same base name as the data file, but with a .trg extension (e.g. AFSData_ 20030708_0000001034.trg).  The presence of the trigger file guarantees that the original data file has been fully transferred.

The format of the contents of each data file will be as follows:

• The first line will indicate the table from which the data comes. For example:
1. opparent (for Customer information)
2. transact (for Transactor information)
3. account (for Internal Account information)
• The second line, pipe delimited, will contain the word action (indicating the type of action performed) and a list of column names exported
• The remaining lines, pipe delimited, will include the action performed (insert, update, delete) and the actual data exported.  Note that some values (except for the action) may be blank.

The contents of a customer file might be as follows

opparent
action|parent_code|parent_name
insert|SILVERPT|Silver Point
update|BERSHIRE|Berkshire Hataway
delete|BERSHIRE|
insert|BAUPOST|Baupost Group Securities, LLC

The contents of an account file might be as follows

account
action|acct_code|acct_name
insert|ARB|ARBITRAGE
insert|BF|
insert|BOSS|BOSS ACCOUNT

The contents of a transactor file might be as follows

transact
action|trans_id|first_name|last_name
insert|AC|AJ|COOPER
insert|BH|BOB|HANNIGAN
insert|BS|BIRGIT|SUTTER

When this application is first run, the entire dataset is ftp'd.  After that, only changes are sent (so most files will contain only one record) as changes are made to afstrade.  The user may resend all data by clicking the Resend All button on the form (see ShowResendAllButton  to enable this button).

afstrade.ini section

The following afstrade.ini section controls the afsDataFTP application:

[afsDataFTP]
; FTPUserID and FTPPassword indicate the user name and 
; password used to gain access to the FTP site
FTPUserID=myUser
FTPPassword=myPassword
; FTPPassiveMode indicates whether the FTP session is run in Active
; or Passive Mode (0 is the default which indicates Active mode)
;FTPPassiveMode=10 
; FTPBinaryTransfer indicates whether data transfer is performed is
; ASCII or Binary mode (1 is default indicating Binary. If you NEED to use 
;ASCII mode then set this to 0)
FTPBinaryTransfer=1
; LocalFTPDirectory is a holding area for files to be sent. (REQUIRED)
LocalFTPDirectory=C:\temp
; FTPDirectory is the directory on the FTP Host where files are put. 
; (REQUIRED). Set = . if files are placed in the default directory
FTPDIRECTORY=.
; BypassUpload set to 1 will Bypass the FTP files, and just generate the file
; that would have been sent (useful for testing).
;BypassUpload=0
; LocalSentDirectory is set to a local directory where the sent files are copied
LocalSentDirectory=C:\temp\sent
; ShowResendAllButton set to 1 to display button used to Resend all data
;ShowResendAllButton=0

The following afstrade.ini [afsDataFTPTables] section indicates the tables, and the corresponding columns from those tables, that are ftp'd to the remote server.  The general format for each line is 
    <tableName>=<column1>,<column2>, ...,<columnN>
An example section follows.

[afsDataFTPTables]
transact=trans_id,first_name,last_name,trans_type
account=acct_code,acct_name
opparent=parent_code,parent_name
opmast=other_party_code,other_party_name,other_party_type
opdtl=other_party_code,dtc
vacttran=acct_code,trans_id

Lat updated: 06/16/2005