MarkEEaton
/
new-books-desktop
mirror of https://github.com/MarkEEaton/new-books-desktop.git
1
0
Fork 0
Code Issues Packages Projects Releases Wiki Activity
A desktop application that converts a CSV of new books into HTML suitable for pasting into a LibGuide
82 Commits 1 Branch 4 Tags 667 KiB
Python 100%
Go to file
Mark Eaton c78b8511a0
Merge pull request #15 from MarkEEaton/dependabot/pip/pillow-10.3.0 
Bump pillow from 10.2.0 to 10.3.0
 		2024-04-03 20:42:28 -04:00
dist/gooey include image and language files that gooey demands 2023-07-18 16:33:01 -04:00
img add screenshot, rm data directory 2020-03-07 22:21:45 -05:00
LICENSE Create LICENSE 2019-01-02 09:27:57 -05:00
README.md Update README.md to add windows requirement 2023-07-18 17:21:47 -04:00
convert.py changes to reflect the new spreadsheet layout 2023-07-18 16:31:16 -04:00
requirements.txt Bump pillow from 10.2.0 to 10.3.0 2024-04-03 16:20:37 +00:00
setup.py add setup.py for py2exe 2021-11-23 18:38:12 -05:00

README.md

Make an HTML document out of a spreadsheet of new books

Screenshot of the application

  • This application was developed to solve a specific problem faced by our librarians: how to turn a spreadsheet of new books into an HTML document quickly and easily.
  • Because our acquisitions librarian needed to be do this regularly, coding the HTML by hand was not a viable option.
  • So the application we wrote automatically produces an HTML output from a CSV file. This HTML is suitable for cutting and pasting into a LibGuide.

To set up the application

These instructions assume you already have the following installed: git, python 3

This application will only work in Windows environments. Other operating systems are not supported.

To build the converter executable at the command line (you only need to do this part once):

$ git clone https://github.com/markeeaton/new-books-desktop   # this will clone the github repository to your machine
$ cd new-books-desktop   # go to the repository directory
$ python -m venv venv    # create a virtual environment
$ . venv/Scripts/activate           # activate the virtual environment
$ pip install -r requirements.txt   # to get the necessary packages
$ python setup.py py2exe            # to create the application

The executable application will be in the new-books-desktop/dist directory, along with a bunch of supporting files. Those supporting files are necessary too.

Once the application has been built, you can run it. You can navigate to your CSV file.

The CSV should be organized as follows:

A B C D E F
LC Class Author Title Call Number ISBN Format
... ... ... ... ... ...
  • "Format" should be either "print" or "ebook"
  • Be sure to include a row with column headers!
  • You can run the application to process the CSV file. The output will be an html file in the same directory as the CSV.

Want to run a command line version?

See the repository for the command line application.

Want to see more?

Presented as a poster "Improving Workflows and Outreach with Python: Automating a New Books LibGuide" at ACRL 2019 in Cleveland, OH