Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Clone https://github.com/precision-sustainable-ag/benchbot_map_generator

    1. cd <path to where you want repo>

    2. git clone https://github.com/precision-sustainable-ag/benchbot_map_generator

  2. Create virtual environment using python 3.9

    1. cd benchbot_map_generator

    2. make sure your python version is 3.9.x using python --version

      1. if your versions is not 3.9.x, install python 3.9

    3. python -m pip install --user virtualenv

    4. python -m venv .venv

  3. Activate virtual environment

    1. ./.venv/Scripts/activate

  4. Install modules

    1. pip install -r requirements.txt

  5. Ask Mikah Pinegar for the credentials.json file and copy it into the top level directory

  6. Run the generate_map.py file and insert the google sheets IDs that are found in the URL in the browser

    1. For example, if the sheets URL for species_by_row is https://docs.google.com/spreadsheets/d/1lFJAUB-NKeRJ3U0ZaQpUJDIxpp06S5HR5xS8JZuXFdQABCDEFG/edit#gid=0 the ID is 1lFJAUB-NKeRJ3U0ZaQpUJDIxpp06S5HR5xS8JZuXFdQ ABCDEFG

    2. python ./generate_map.py '<species_by_row_google_sheets_id>' '<pictures_per_species_sheets_id>'

    3. The command with inserted IDs should look like this except with your keys

      Code Block
      languagepy
      python .\generate_map.py '<species_by_row_sheets_key>ABCDEFG' '<pictures_per_species_sheets_key>HIJKLMN'
  7. Login to your google account using the OAuth popup in your browser

  8. Look at the map.xlsx file that was generated and make sure it looks correct