Created by: Aiden Olsen
supplier2opens is a python script that allows the automatic conversion from different supplier lists/carts to the OPEnS shopping list format saving lost of time.
The program takes in a csv or excel spreadsheet containing the necessary information required for the OPEnS shopping list. The script then organized the data correctly and copies the formatted contents to you clipboard to be easily pasted into the OPEnS shopping list.
Currently the following suppliers lists/carts are supported:
This following demo walks you through how to process a digikey list.
git clone https://github.com/OPEnSLab-OSU/supplier2opens
cd supplier2opens
python3 -m venv venv
source venv/bin/activate # see table below to for other os/shells
pip install -r requirements.txt| Platform | Shell | Command to activate virtual environment |
|---|---|---|
| POSIX | bash/zsh | $ source /bin/activate |
| fish | $ source /bin/activate.fish | |
| csh/tcsh | $ source /bin/activate.csh | |
| PowerShell | $ /bin/Activate.ps1 | |
| Windows | cmd.exe | C:> \Scripts\activate.bat |
| PowerShell | PS C:> \Scripts\Activate.ps1 |
Digi-Key allows you to to create lists of components and is a really handy was to organize components for PCBs. Follow the instructions below to export the file required for the script.
- Open your digikey list
Account & Lists > Listsand select the desired list - Download the csv by clicking
Downloadand changing the export format toCSV - Run the following command:
python supplier2opens.py <path-to-csv>
Mouser allows users to export shopping cart contents, however it is formatted differently than the OPEnS shopping list. Follow the steps below to export the excel sheet required for processing.
- Open your cart
Cart > View Cart - Export the cart to excel
Export > To Excel - Run the following command:
python supplier2opens.py <path-to-xls>