Dear Dojocho, The downloaded file of your dojo roster is an Excel spreadsheet that has the basic registration information on each member attached to your dojo whether Active or Inactive. Any members who you decide no longer should be on your dojo roster can be removed in the database by changing the “Active” field to “R” from “N” for that record. New or returning members can be added at the end of the list as a new row or by changing the Inactive member’s “Active” field from “N” to “Y”.
In order to update your member’s records or make any further changes on your dojo roster spreadsheet by following the instructions on this “Dojo Roster Update” webpage and forward the spreadsheet should any further changes tbe required to Bob Zimmermann Shihan at: torontoaikikai@gmail.com. This updated spreadsheet will be the basis for your invoice for this year’s Shin Kaze Aikido Alliance annual dues, the invoice will follow shortly. If no further changes are required then no need to send back the spreadsheet, just keep it for your own records.
INSTRUCTIONS
THE OVERALL PROCESS
In order to update this record you will need the Record ID # which is essential in order to make any changes to that record so please do not change this number. The First and Last Name of the individual can be changed if there is a need to correct or update those fields. So go to the Dojo Roster spreadsheet that was attached to the email you received and see what if anything else has changed and needs to be updated. Any changes you make to any fields will be reviewed before any updates to your members records are completed.
- The “Dan”, “Kyu”, “Youth” or “Dojocho” fields should remain as it is presented to you, if there is a change of rank then please use the promotion forms to adjust the current rank. For Kyu Rank promotions go to:https://aikido-db.com/kyu-promotion-form/ for Dan Rank promotions by examination go to: https://aikido-db.com/dan-promotion-form/ or by recommendation go to: https://aikido-db.com/dan-recommendation-form/ .
- The “Status” field in conjunction with the member’s “Rank” will determine the annual fee based on the Country Code of the dojo where the members are attached. Please confirm that each member is properly classified as “Dojocho”, “Adutl Dan”, Adult Kyu”, “Youth Child”, “Full Member”, “Provisional Member”, “Associate Member” or “No longer a member” as appropriate.
- The “US$” field is the relative payment that will be charged for that member based on their status this year so no change is required for this unless there is a change that you have not previously indicated on the status of that member.
- For new members who are not currently in the database, please add a row at the end of the existing records, mark them as “A” in the “Active” field and complete each field in the exact same format as the existing records but do not add a “Record ID#” as that will be automatically added to the record once your excel spreadsheet data is imported into the database.
- For returning members, if the record is not in the database then add a record at the bottom of the existing ones and complete as above or if the record is existing but has an “N” in the “Active” field just change it to a “Y” and update or complete the other fields as per the instructions above.
DATA INPUT
Please be careful with your data input as whatever you put on the returned spreadsheet will become the data in your members records. Thanks in advance for your attention to this and please let us know if you are having any issues shinkazeaikidoalliance@gmail.com