Giter Club home page Giter Club logo

society-membership-checker's Introduction

Exeter Guild/FIXR Event Membership Cross-referencer

Really simple command line application that cross references two csv files to find people that have bought members tickets, despite not being members! An example event.csv and society.csv has been provided.

To use:

  • Obtain the CSV of your members via the society dashboard on the exeter guild, and rename it 'society.csv'

SOCIETY PAGE

  • Obtain the CSV of your FIXR Event attendees, and rename it 'event.csv'

FIXR PAGE

  • Place both CSVs in the same folder as this application

How it works:

People often use their nicknames on FIXR which means they don't always match their student names on the membership csv. Any name that doesn't immediately match will be called a 'suspected liar'.

For each suspected liar, you'll be prompted with all members with surnames that match, and then all members with firstnames that match. Use your brain to see if they actually do own a membership!

If there are no firstname/surname matches, the application will automatically declare them as a liar. There's a slight issue with this:

'Daniel Day-Lewis' on the student guild may be 'Danny Day' to FIXR. Even though he is innocent, this application will call him a liar. Poor guy.

Things that could break this application:

  • CSV column positions changing on either the guild or FIXR
  • Not using the keyword 'Non' for your non-members tickets

Things I could add:

  • The liar's fixr emails to be displayed in the output
  • Make it find the columns instead of using indexing
  • A name match score?

society-membership-checker's People

Contributors

jamespilcher avatar

Watchers

 avatar

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.