 Thank you for being here. My name is Rosado and I'm a member of the membership committee and as Walter said it's important to share some topics with the community and this topic is very important because at this moment this topic handling the membership applications with the MCN script is done only by me inside the membership committee. So my objective with this presentation is share my daily work with the MCN script stuff with you and document the questions to the community to share my notes and what I'm doing. So the MCN script is a tool developed in Bash and for the first membership committee for a developer in the first membership committee in Norway and updated by many members of the membership committee during the next years. So the work with the MCN script starts when we finish a quarter. So to finish a quarter the member on the team should have a GPG key in the computer and he should sign the database with the date of the last minutes, the last meeting minutes of the membership committee. So after that we are able to start the work of a quarter. As Gabriele told there are two big cases to review the renewals and the new applications and every application in compliance with the TDI status is sent here for voting. This is an important topic because I will talk about in the end of the presentation the chats I have made in this comment the Notifier Renewal P to check the list of renewals, check the members who should who will be renewed in this in the in the in this quarter. So to set the renewals the first thing to do is get a property some chains in Garrett if it exists with the poll and check the list of members with Notifier Renewal P the MC script will show a list of IDs and names and after send the renewals with Notify R and then push the gems. So this comment send the email the famous email to the members with the main question if the member want to renew or not and the membership company needs a yes or no as an answer to continue the process if the member answer a yes it's easy because it's just do a Pw with the ID of the number and okay of course yes of course we should check if it's all okay with the contributions of course if the members say yes so the Pw with the ID send a message send a message to a member and send a renewal to Garrett for voting what Garrett told in the last presentation if the member say no so the good practice is lapsed the member because after we it's possible get some lists from the membership comment the script the MC script for the membership committee or for the board or for elections so or even for the reminder message and as you can see a member who doesn't want to renew doesn't want to to get a new message for a reminder for example so the good practice is lapsed the member when the member doesn't want to renew and after this rubber will be cancelled after the membership committee meeting uh if a member was lapsed by mistake we can wreck the rubber with the ID in general it's useful for the list for elections because we should keep in mind that the elections uh should be considered the last list of members of last quarter so we can guarantee the right of the member to vote even if he wants he doesn't want to renew uh this case i will talk after so well if the member don't answer our message our mail after around 20 days more or less we can send a reminder so the difference in this case is that the reminder is sent one by one first we get the list for reminders a list of members with the ID and the name and after one by one with remind and the ID for a new application the most important is check if there is or not a record for the candidate to avoid a case when we can have two records for one person so the first thing is do a display with the name or an ID for the candidate and if there's no record for the candidate then a see with the name and the email of the candidate so uh Gabrielle showed us a screenshot of Garrett when where we vote for approval or not a renewal or a new application so uh voting in Garrett uh required it's only at least at least three MC members uh with uh plus one or proof membership in general we work as with a consensus decision making there's no voting uh in general it's a consensus for the application and the Garrett works as an archive for uh past decisions of the membership body so after handle many new applications and many renewals we reach the end of the quarter so the member on the team should prepare the meeting uh first deny the rejected applications so uh when our candidate uh doesn't reach the requirements of the status we first check with the common visit and after we notify the rejection with the ID and finally we deny the ID and as Gabrielle told this person could reapply in the future after do some contributions relevant contributions and the member on the team should cancel rejected membership renewals it happens sometimes we cancel membership by members who doesn't reach the requirements and uh another uh uh process labs who will not apply for renewal this is important because sometimes there is a situation when the member uh I haven't answered the the renewal but the MC knows he or she will reapply in the next quarter uh for any reason for vocation for example the person doesn't didn't answer but the MC uh knows he or she will know uh next quarter so we let the the ID and uh it's possible to decide even during the meeting of the MC if the person answers the the email the question what on a chat in a in a less formal way for example so um to prepare the meeting the member on the team should uh prepare some visits this this are easy to to prepare uh with this this we can also get some uh information from to to to build some stats for for the members for the forum who knows uh and there is a spreadsheet to uh automatic have the dates for this this it was uh made by war in in the past a long past and uh updated by me in the last uh two terms so at membership come to meeting the members in the band the decision about corner cases final voting in gary plus one minus one and after seven minutes and lists to the tdf staff uh in general for him and so he for burning film so uh they do also a double check in the lists it's important work uh and after that we we do some operational uh stuff as uh set up membership to consider uh it's like to clean the the the status of the database we notify the new members this is important and notify the members about the renewal succeeded succeeded yes perfect so finally we provide the final lists to the board and the and the staff to the lists and and to the website these two lists are getting from the database so this is the end it's time to sign the database and start on your part uh about useful comments we can change the data of uh a member with the modified one with the id uh of course the two the only two uh information we have about the member the full name or the email eventually another asks for change his email we can recover for a local recover a local crash this is amazing because sometimes your local database uh uh let me let me remember uh that uh we are using a tool basis in my kit tool so sometimes your local database crash and you can do a reset to recover the information from the uh the database the main database uh to your local database and sometimes an undo is useful too to uh do a correct con so nice nice cons to use in your in the daily work of the member on the view so my acting finally uh during our meeting in Rome K J suggested to change the sending of the news in the start of the question uh let me show the old approach the current date and the current date plus 45 days was a time frame where all the uh members with the renewal date inside this time frame um uh was uh had his uh renewals sent sent so this works in uh what we call waves of renewal uh methods but uh it it works it worked during a long time but with problems because sometimes as you are working with the current date uh sometimes the membership committee uh had uh little time to to check to review and check the number uh uh answer the members answers so um after study the code the work uh based on the KJ proposal uh I changed one line I spent too much time to to find this line but works so the new approach is get the effective date of the the quarter of the the next quarter and do a minus 90 days uh to get the whole quarter there's some uh issues about dates here so because this I'm testing the solution but uh it works it it have uh since um two quarters yes two quarters and seems okay to be uh the fight as uh the new approach of this uh question and another topic discussed at FOSN was we started to send the renewal notification to the approved members so um this uh demonstrate to the members that the process was finished and demonstrate that the mc are working uh in on the renewals if something may you uh losing in somewhere uh yes and it's a formal communication from the membership company so uh it's it's easy to do and it's already been done and that is it okay that's my daily work with the nc script I'm happy to share with you my contribution to the project and it's important because because today I guess only corn and so we are able to do the whole process because I think you too that is it thank you guys