search

NSLS-II-SST / rsoxs_scans

stand alone package for loading and validating RSoXS scans for NSLS-II SST-1 beamline
BSD 3-Clause "New" or "Revised" License
0 stars 0 forks source link

Copying Sample Sheet Metadata/Rules from Spreadsheet to Wiki #2

Closed BijalBPatel closed 1 year ago

BijalBPatel commented 1 year ago

Objective: Write a function that converts the sample sheet metadata/rules into a format that can be copy-pasted into the wiki.

BijalBPatel commented 1 year ago

@EliotGann I was curious so i wrote a loader that converts from the spreadsheet to the wiki. Example output is here: https://wiki-nsls2.bnl.gov/beamline7ID1/index.php?title=User:Bijal

Theres a jupyter notebook with the code in the commit (made an 'examples/utility' folder to hold it)

BijalBPatel commented 1 year ago

@EliotGann Updated for what we discussed today and tested on your newest excel sheet.

New usage:

  1. To get code for a single wiki page which has separate tables for each sheet of parameters ('Bar', 'Acquisitions'...) Use either: print(convertSampleSheetExcelMediaWiki(excelSheetInputPath, verbose=False)) print(convertSampleSheetExcelMediaWiki(excelSheetInputPath, verbose=False, paramsSheetToOutput='all'))

  2. To get code for a single wiki page which only has a table for a particular sheet of parameters: print(convertSampleSheetExcelMediaWiki(excelSheetInputPath, verbose=False, paramsSheetToOutput='Acquisitions'))

Example of case 1: https://wiki-nsls2.bnl.gov/beamline7ID1/index.php?title=User:Bijal