You cannot select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

History

Thomas A. Christensen II affa7796ac Sanitize `redacted` name		3 years ago
..
README.md	Sanitize `redacted` name	3 years ago
limsdatapull.yaml	Add auto-updating sample database	3 years ago
refresh-lims-data.bat	Add auto-updating sample database	3 years ago
updatedata.py	Add auto-updating sample database	3 years ago

README.md

StarLIMS Data Pull

Pulls positive SC2 sample IDs and relevant dates from StarLIMS.

NOTE: These scripts are encrypted, but are generally intended for use on Windows machines. Decrypt them on a Linux/Mac machine using the entire repo instructions, then copy over using a secure flash drive or similar method.

Usage

Double-click refresh-lims-data.bat in any location.

Installation

This script requires Miniconda.

Download and install Miniconda
1. Select "Just Me" when asked who to install for
2. All other default options will work
Press Win+R, type %USERPROFILE% and press Enter
Create a new folder called limsdatapull
Copy all of the decrypted files to limsdatapull
Open Anaconda console (not PowerShell) from the Start Menu
Run conda create -n limsdatapull -f %USERPROFILE%\limsdatapull\limsdatapull.yaml
Answer y to all the prompts
Close the console
(Optional) Copy refresh-lims-data.bat to the Desktop
(Optional) Set up a scheduled task to run refresh-lims-data.bat regularly

When refresh-lims-data.bat is run, a new file called SequenceDatabase.xlsx will be added to limsdatapull. This file can be referenced by other spreadsheets for efficient and timely lookup data from StarLIMS.