Member Master file format.
The Member table in the Masterpoint database is a subset of the master member detail. In particular, it contains only six (6) of the fields from the master file, being
Member Number. This MUST be unique, and is
taken from column 1 (A) of the Master file
Surname. This is
taken from column 2 (B) of the master file, and
reformatted
Initials. This is taken from column 3 (C) of the
master file, and reformatted
Home Club. This is taken from
column 4 (D) of the master file, and converted to a numeric
index
Red Points This value is taken from column 15 of the
master file.
Blue Points. This value is taken from column 14
of the master file, and divided by 100.
Rank. This is taken
from column 29 of the masterfile.
Any change in the present format of the master file will cause the file to be rejected.
Warning: A duplicated Member number will cause the initial upload to fail, complaining of a duplicate Key.
Member Master File Processing.
In processing the member master file, the
entire file is extracted to a temporary table, and the contents
then compared to the existing Member table. The differences are
then highlighted to the uploader – as entries to be removed
and or added to the Member Table.
The user is then given the
opportunity to verify this data, and then to confirm or reject
the updates. If they are confirm, the necessary actions are
taken, if they are rejected then all processing is cancelled.
Any entry in the Member table that does not exist in the new table will be deleted.
Any entry in the new table that does not exist in the Member table will be added.
Updates
If any updates are required to this process, please contact pat@ngbu.za.net.
