P u r p o s e s  VVwin  M e m b e r s




C h o i c e   m e n u s

Menu

Data

Menu
  • Enter: New members are added with the help of a mask. When you click on 'Save and new Row' of the current membership status is displayed.
  • Edit Form: Member's data of a family are edited with the help of the same mask. You select Memb.No. or Names from a list which you can process then.
  • Edit Table: Member's data of a family are edited without input mask as a table and only the most important fields are indicated. This makes sense, e.g., by fee updates or member-withdrawals. You select Memb.No. or Names from a list which you can process then. In contrast to the Menu dot 'Edit individually' stamped out members with are also indicated this year (A/E/0 stands on '0'!).
  • Members Table: All member's data are indicated like in a tables calculation and can be edited and all fields are indicated.

  • Bank Data: Member's data are indicated with bank code number, account no., IBAN and mandate referenve and can be edit.- If you the question: 'Should missing values be postcalculated?' affirm, the list is completed! Only empty fields are calculated.

  • Check It!: With 'Check It!' becomes on missing Ident-No.=1, wrong A/E/0 and other criteria examined.

  • Export: You can save the member's data for the purpose of handing over near another computer in an external file – from an selected booking entry date. It carries the name 'midat_jjmmtt.csv'. (A complete encoded tables backup is automatically created monthly, 'mi_mm.vep'.)
    You receive at the same time from employees, so to members whose field fkt isn't empty and whose e-mail address is filled, a '[club name]_jjmmtt.ldif' for transmitting into a Thunderbird address table of every Client.
  • Import: You can load member's data from this external file in another computer. The data are attached to the table.
    Pay attention to double M.No.+Ident-No., otherwise the consistency of the database is endangered!

  • Archive: New members are added with the help of a mask. The input mask contains only the entries M.No. and Ident-No., Name, First Name; the fields Birthday, Entry year, Divisions are taken over from the member's data. In the text field data can be entered consecutively to the member.
    Archive data are indicated with the help of the same mask or are edited. The data can be printed out as an index card or as a list.
  • Photos: New members are added with the help of a mask. The input mask contains only the entries M.No. and Ident-No., Name, First Name; the fields Division Codes are taken over from the member's data. In the text field data must be entered the photo file name.
    Photo data are indicated with the help of the same mask or are edited. The data can be printed out as an photo card or as a list.
  • Non-members: New addresses are added with the help of a mask or are edited.
  • Deleted Members: During the last 10 years deleted members to browse.

Lists

Menu
  • Whole Club: Membership list of all club members; contains all data to the member.
  • Club List: Membership list of all club members; contains only address and phone data.
  • New Members: how Whole Club, but only new entries of the current year. The field ejj (entry year) must be filled.

  • Divisions: Division lists; if the data which are necessary to the fee elevation don't contain. You select by divisions.
  • Age Groups: Membership list for members of a freely eligible age group (without fee data). You select by divisions.
    • Children: Membership list for members to 6, between 7 and 11 or between 12 and 14 years.
    • Youth: Membership list for members between 15 and 18 years.
    • Seniors: Membership list for members from 61 years.
    • Div. by age: Membership list for members of a freely eligible age group.
  • Employees:
    • Employees list: Membership list for the members who exercise a function in the club (without fee data).
    • Functions: Function list for the members who exercise a function in the club, ordered by functions.

  • Birthdays:
    • round Birthdays: Birthday list of those members, 50, 60, 70, 75, 80 years and become old. 3 months are always displayed. You are asked by month and year.
    • all Birthdays: Birthday list of all members. You select by divisions.
  • Honours:
    • Honours list: Honour list for the members who have received an honour in the club, ordered with honour.
    • Honours Needle: Honour list of those members who are, e.g., 25, 40 and 50 years in the club, calculated, e.g., from the 18th year (e.g., honours needle in silver, in gold, honourary membership). Honour ID = Ehr1, Ehr2, Ehr3.
    • Actives Needle: Honour list of those members who are, e.g., 10, 20 and 30 years in the club, calculated, e.g., from the 14th year (e.g., actives needle in bronze, in silver, in gold). Honour ID = Akt1, Akt2, Akt3.
      —> Honour kind and honour year are to be set about the Honours stock.

  • WHERE...: You can formulate yourselves a choice condition, e.g., WHERE mail IS NOT NULL (and mail the field with the e-mail address is).

Statistic

Menu
  • Whole Club:
    – Membership active/passive Adu./You.
    – Age groups according to sports alliance m/f.
    – Entries/escapes of the last 5 years of Adu./You.
    The list can be often printed out arbitrarily, the data are not stored.

  • Members Inquest:
    • Membership by associations and years.
      The menu point 'Output Years' generates the files 'BestandJG.xml' and '...ja.dat' to the passing on to the sports alliance. Youy receive also the files 'mista5yy.xml' and 'mista5yy.csv' by associations for your statistics.
    • Membership by associations, sports and age groups .
      The menu point 'Output Age Groups' generates the file 'BestandAG.xml' to the passing on to the sports alliance. Youy receive also the files 'mista1yy.csv' by sports and 'mista4yy.xml' and 'mista4yy.csv' by associations for your statistics, in addition, with the turn of the year the statistics about the last 10 years ('mista4.csv').
    • The menu point 'Output Associations' generates in each case for an association the age group statistics about the last 10 years.

  • Statistics:
    • Sports Divisions:
      – Membership Adu./You. m/f.
      These data are stored and can be worked on for representation purposes and be printed.
    • Age structure:
      – Membership m/f/Sum.
      – Age groups according to statistical regional authorities.
      These data are stored and can be worked on for representation purposes and be printed.
    • Population pyramid: Value row for a population pyramid as csv file for representation purposes.
  • Frequencies:
    Membership by
    – divisions, banks, fee classes, honours, functions,
    – entry years, years of birth, post code, streets, places of residence.

Letters

Menu
  • Admissions Letter: Print of a confirmation letter on club note paper, with SEPA direct debit communication. You are asked for the Memb.No. The text can be adapted in the files 'aufnbrf.rmd' and 'sepabrf.rmd'.
  • Termination Letter: Print of a termination letter on club note paper. You are asked for the Memb.No. The termination text can be adapted in the file 'kndgbrf.rmd'.
  • Exclusion Letter: Print of a exclusion letter on club note paper. You are asked for the Memb.No. The exclusion text can be adapted in the file 'aussbrf.rmd'.

  • Circular Letters: You provide your circular with Textmaker, Writer or Word, without address and date, and store it as a RichText in the file 'rundschreiben.rtf' and file it in the folder \cmnd. In the menu you select a receiver's group.
  • Circular Emails: You proceed like in circular described. The file 'rundschreiben.rtf' is sent as an appendix.

  • Address Labels: Addressing data are printed on sticking labels.
  • Mail Merge Data: Addressing data become in two external ASCII files
    'addat.csv' with , as a separator and embedded in '
    'addat.txt' with firm record length
    and can be copied with every word processing be used.

Menu
    Receiver's groups with Circular Letters, Circular Emails, Address Labels, Mail Merge Data:

    • Family Club Place/Postal Service: All members with Ident-No.=1 which live at the club place/district (post code of the club address!) or not live there.

    • All Division Members: All members of a division or all whole club.
    • Divisions by Age: All members of a division of the respective age group.
    • All Employees: All members with a function in the club.
    • Employees by Function: All employees according to function code.

    • Honours Needle: Everybody in the concerning year honourary.
    • Actives Needle: Everybody in the concerning year honourary.
    • Round Birthdays: All with round birthday in the concerning month.

    • No-members: Well-chosen non-member's groups.

    • WHERE: You can formulate yourselves a choice condition.
    • E m p t y T a b l e : You are able to do the temporary table fill.

    • Test print: Print of a letter or the first etiquette sentence to the examination of the correct paper adjustment.

      —> The receivers are interstored in each case in a temporary table and to you before printing are indicated. You can carry out in this changes and also give new receivers. With non-desired you extinguish the name or the whole record.

Tools

Menu
  • Protocol: Print of the protocol with day date.

  • Member-admissions: List of all entered members of a certain year.
  • Member-withdrawals: List of all resigned members of a certain year.
  • Member Numbers: List all used M.No.
  • Passives: Print of passive lists for club and tennis.

  • Newspapers: Print of newspaper lists of the members with 'Z' in its data, sorts according to post code, district, street, no., for club place and postal service. If you want to add town plans of the districts in the club place for the distributors, these must be given as 'district-id.jpg' in the folder /icons.
  • Divisons Adresses: List of the members as a print pass. You select by divisions.
  • Member Mails: Print of the mail list of the members. You select by divisions.

  • Member Cards: Print of member cards with or without photo on business cards. You select by divisions.

vvClub
Management

© Dr. Hartmut Braun, Karlsruhe
vv

 Club Management

M e m b e r s