Input File Scanner Tool
Added a new interface to scan custom excel files and spot any inconsistencies in keywords provided with the original tree taxonomy.
Usage:
-
You need to get the latest code from this Github Repo - either by clicking download .zip or using git clone.
-
Open Command Prompt from Windows Start Menu and navigate to the root location of the folder (repository) where you'll see setup.py. You can use
cd your/path/to/downloaded/folder -
Type in the following command to install the dependencies
pip3 install -r ./pystsup/requirements.txt -
Then, type in the following command to the install the package
pip3 install . -
To run the application type in the following command
python InputFileScanner.py
You would need to pass the tree taxonomy file along with your student and supervisor files.
Once files are selected, click the scan button.
If there are any errors found with data in file, the following error will be displayed:
The tool then automatically highlights the places in both the excel files, where there is a data inconsistency (typo, errors, etc.). Like below:
You can fix these or the keyword taxonomy file. Once you've fixed them you can run the scan again to make sure it's all good. (Running the scan after fixes with automatically removes 'red' colour highlighting 😄 ).
The tool is also made to be case insensitive now. You don't have to worry about upper or lower case differences; it should just work with them.
The process after data cleanse should be straightforward i.e. run python GUI_Application.py and pass the new clean files and obtain student-supervisor allocations. 🎉