Skip to content

Releases: meows4h/TextbookDataToExcel

v1.2 - Analytics Overhaul + Improvements

Choose a tag to compare

@meows4h meows4h released this 07 Jul 18:24

Warning

This script will fail to run core functions without certain information being gathered / supplied beforehand, primarily bookstore information. This can be fixed via navigating to the Update CSV section and updating the bookstore csv file prior to running other functions. Larger portions of data will also be missing if a CORE enrollment report is not properly supplied, as well as missing data from Alma and email directories.

Getting Started

For information on how to get started with the script, read readme.md for more information. About the script layout and what each piece of the program does, read documentation.md. Otherwise, run run.bat to get started! Everything should be able to be fully interacted with inside the GUI of the script, no more command line prompts!

Feature Release

This specific release should have fixed issues related to interfacing with the Analytics portion of data, as well as adding in the ability to pull more information. There were also some major bugs in the prior version that should be squashed this time around.

Future Plans

As of this point, the script is feature complete of the core expectations, with only a couple features that would be nice, but are not ultimately a requirement of the original plan. Some of these additional features that may still come along are:

  • ISBN translating from certain bookstore entries
  • Cost comparison and analysis
  • Improvements to GUI and general user interactions, including better written instructions

v1.0 - GUI Release

Choose a tag to compare

@meows4h meows4h released this 25 Jun 18:38

Warning

This script will fail to run core functions without certain information being gathered / supplied beforehand, primarily bookstore information. This can be fixed via navigating to the Update CSV section and updating the bookstore csv file prior to running other functions. Larger portions of data will also be missing if a CORE enrollment report is not properly supplied, as well as missing data from Alma and email directories.

Feature Release

The GUI features and functions are at or function better than the prior CLI version of the script. There may still be bugs or issues that the user will run into, feel free to list feature requests or bug reports within the Issues section of the repository.

For information on how to get started with the script, read readme.md for more information. About the script layout and what each piece of the program does, read documentation.md. Otherwise, run run.bat to get started! Everything should be able to be fully interacted with inside the GUI of the script, no more command line prompts!

Future Plans

There is some improvements that will be made to how the Alma Analytics portion of the script functions, as well as chaining together better information that is gathered from the bookstore. Outside of this, it will just be general additions (i.e. images) to the documentation and cleaning up lots and lots of comments. Otherwise, as far as I am aware, this script mostly accomplishes many of the points it aimed to hit.

v0.8 - Base Functions Working

Choose a tag to compare

@meows4h meows4h released this 29 May 01:00
0c96d4a

Warning

This script will fail to run core functions without certain information being gathered / supplied beforehand, primarily bookstore information. This can be fixed via navigating to the Update CSV section and updating the bookstore csv file prior to running other functions. Larger portions of data will also be missing if a CORE enrollment report is not properly supplied, as well as missing data from Alma and email directories.

Feature Release

This release has the command line interface (CLI) version of the script working in its entirety, though it lacks proper documentation and instructions on how to properly use this version of the script. The graphical user interface (GUI) side of the script works, but it will have some issues across the board due to lack of fully implemented threading support and functions missing complete GUI implementations.

CLI Features

  • Creating a new Excel sheet from bookstore information, compiling in enrollment information from CORE, emails from directories, and backend information from Alma
  • Updating an existing Excel sheet with new information if further data is scraped / gathered after creating a new sheet
  • Updating cached information to make updating / creating Excel sheets much faster after each use
  • Creating a list of emails to send out on textbooks that are ready to email, including proper copyright information, available copies, and links for the professor / instructor to be able to use

GUI Features

  • Creating a new Excel sheet, using the same functions as the CLI version
  • Updating configuration and header information
  • Creating a list of emails, using the same functions as the CLI version
  • Buttons and dynamic input fields for the user to interact with directly
  • As of now, lacks the ability to update the csv files, as well as updating existing Excel sheets

By default, this version will have the CLI version enabled and the GUI disabled. If the user wishes to see / use the GUI, change gui to True in the config.ini file.