Skip to content
/ iBuy Public

script for populating UIC's iBuy requisition form with data from an Excel spreadsheet

Notifications You must be signed in to change notification settings

JeffKo427/iBuy

Repository files navigation

Install and Setup

  1. Install Firefox in the default location
  2. Make sure you have Python 2.7 or above installed on your computer.
  3. cd splinter && sudo python setup.py install
  4. cd ../openpyxl && sudo python setup.py install
  5. download https://github.com/mozilla/geckodriver/releases and place in system PATH (/usr/local/bin on Unix)

Running:

  1. sudo python iBuy.py username password file [line]
    • username and password are your iBuy username (w/o @uic.edu) and password
    • file is the .xlsx file containing the purchase order (other extensions should work but are untested)
    • [line] is the line number of the first item you would like the script to add (default 8)
      • this is only useful for purchase orders containing multiple vendors
      • the script will scan downwards starting at the line specified until it encounters an item from a different vendor
  2. Enter your computer's password
  3. You will be logged in to iBuy in a new Firefox browser window.
  4. Enter the Supplier in iBuy when prompted to by the script.
  5. Switch back to the terminal and hit enter.
  6. After execution, verify that the information has been copied successfully before submitting the order.

About

script for populating UIC's iBuy requisition form with data from an Excel spreadsheet

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages