This work is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License.
This script is in draft form, simply to help people import large sets of statistical categories and types in the stat category/Type mapping table. As such, you may have to start and stop the script multiple times to complete the process. Make sure to save the table each time if you run into errors.
Title: Add statistical category and type mappings to Alma table
Author: Henry Steele, Library Technology Services, Tufts University
Date: September 2019
Purpose:
Automate input of statistical category and mapping table, that doesn't have an import function, with the Python Selenium web driver
Input:
The input file, which the script will ask for in a file picker, needs to have the following fields, with no header, in a tab-delimited .txt file
- Statistical Category Description
- Statistical Category Type (likely all the same in import)
In the applications directory, create a secrets folder, and inside that folder a secrets.py file.
The file should have two lines:
- username="an Alma username that has the General System administrator role"
- password="password for that user"
The script will input this table and enter each value pair in the Add Row pop up iteratively.
Process:
- This script uses Python 3, so you will have to have Python 3 installed
- install the dependent package, selenium, by writing
- python3 -m pip install -r requirements.txt
- Go to this downloaded repositories directory, and run the command python3 fileInput.py
- follow the prompt to select your input file
- Don't touch your computer or mouse while the script is running
- Wait for it to complete or hang
- Try saving the table
- **If it won't save because of duplicate values, export the table to Excel and highlight duliplicates to find out which ones to remove.
Note: I don't have the script save the changes. You will need to do this at the end manually. See note above