Icon

Compile_​MS_​Track_​ForKnime

Workflow for Translational Biology department / PROTEOMICS group.

Scope: Compile instrument tracking information.
Remarks: Use Excel spreadsheet as input file (Orbi-Booking data sheet).
Generate Excel file as output.
History:
21-05-2019: Added new instruments in configuration table.
July-2020: New version - New instrument configuration table and new rules to compute activities. Add option to view graph of activities per month.

Data processing: Input processing Output Processing Workflow name : Compile_MS_TrackingDescription: Compile activities per instrument based on Excel input file and data read from Orbi-Booking data sheet. Generate as well gloab summary sheet for the year and summary sheet per month. Enable visualization of graphs ofactivities per month all instrument s includedCustomer: Internal (Translational Biology)History: July 2020 -: creation of the workflow (using prototype version as strating point). Dec 2020 : migrated workflow under new knime version. Added Year and Color columns in configuration table to be able to use workflow on previous year (only 2020 and above) and color schema. Output Processing Output Processing Output Processing Input processing Node 4402Set proper col orderfor outputNode 209Node 211Node 213Node 224Node 226Node 227Node 228Node 427Node 429Recup du moissur chaque ligneKeep only valid data rowsA finaliser suite àretour CP le 16/11Node 457Node 458update logstart workflowInit varCreate tmpdir andExcel output file nameNode 4597Node 4598Node 4600set graph title and image file nameupper port ifdisplay graph seleted in GUINode 4614Node 4615Node 4616update logNode 4402update logNode 4402Node 4626Node 4630Node 4631create zipfile for svg file if anyNode 4634Node 4635Node 4636Node 4637set var for zipNode 4642set var for zipNode 4647Node 4648Node 4649Node 4650Node 4651Node 4652Node 4653Node 4654Table Config Instwith new instrumentsas of Dec 2020Added column for Yearif we want to runworkflow for previous yearGet instrument listfor expected YearFilter instrumentsFilter instrumentsensure we use proper colorHFX instrumentsin RedNode 4667Append Log Messageto Log File Table Creator Get list of files to combineinto final Excel file Download file Get Inputfile from GUI Table Row ToVariable Loop Start Variable Loop End Error messagein GUI Check if Orbi-Booking sheetexists in input file Check if Year is uniquein input data file Error msg in GUI Java Snippet Rule-basedRow Filter Build Summarytables per month Build global summarytable for current year Merge Variables(deprecated) Java Edit Variable InitializeVariables URL to FilePath (Variable) Table Reader Table Reader Java Edit Variable Flow Variable IF Switch(Flow Variable Value) Flow VariableEnd IF Empty Table Switch End IF Select Month(s)in GUI Display Bar Chart anddownload image file in GUI Java Edit Variable Append Log Messageto Log File Java Edit Variable Append Log Messageto Log File For each instrument in inputfile - prepare summary tables CSV Reader Column Rename List Files Zip Files Empty Table Switch End IF Inject Variables(Data) Java Edit Variable Inject Variables(Data) Add Empty Rows Java Snippet Merge Variables Excel Reader (XLS) Merge Variables Table Rowto Variable Excel Writer (XLS) Table Rowto Variable Table Rowto Variable Missing Value Table Creator Row Filter Column Filter Column Filter Color Appender Color Manager RowID Data processing: Input processing Output Processing Workflow name : Compile_MS_TrackingDescription: Compile activities per instrument based on Excel input file and data read from Orbi-Booking data sheet. Generate as well gloab summary sheet for the year and summary sheet per month. Enable visualization of graphs ofactivities per month all instrument s includedCustomer: Internal (Translational Biology)History: July 2020 -: creation of the workflow (using prototype version as strating point). Dec 2020 : migrated workflow under new knime version. Added Year and Color columns in configuration table to be able to use workflow on previous year (only 2020 and above) and color schema. Output Processing Output Processing Output Processing Input processing Node 4402Set proper col orderfor outputNode 209Node 211Node 213Node 224Node 226Node 227Node 228Node 427Node 429Recup du moissur chaque ligneKeep only valid data rowsA finaliser suite àretour CP le 16/11Node 457Node 458update logstart workflowInit varCreate tmpdir andExcel output file nameNode 4597Node 4598Node 4600set graph title and image file nameupper port ifdisplay graph seleted in GUINode 4614Node 4615Node 4616update logNode 4402update logNode 4402Node 4626Node 4630Node 4631create zipfile for svg file if anyNode 4634Node 4635Node 4636Node 4637set var for zipNode 4642set var for zipNode 4647Node 4648Node 4649Node 4650Node 4651Node 4652Node 4653Node 4654Table Config Instwith new instrumentsas of Dec 2020Added column for Yearif we want to runworkflow for previous yearGet instrument listfor expected YearFilter instrumentsFilter instrumentsensure we use proper colorHFX instrumentsin RedNode 4667Append Log Messageto Log File Table Creator Get list of files to combineinto final Excel file Download file Get Inputfile from GUI Table Row ToVariable Loop Start Variable Loop End Error messagein GUI Check if Orbi-Booking sheetexists in input file Check if Year is uniquein input data file Error msg in GUI Java Snippet Rule-basedRow Filter Build Summarytables per month Build global summarytable for current year Merge Variables(deprecated) Java Edit Variable InitializeVariables URL to FilePath (Variable) Table Reader Table Reader Java Edit Variable Flow Variable IF Switch(Flow Variable Value) Flow VariableEnd IF Empty Table Switch End IF Select Month(s)in GUI Display Bar Chart anddownload image file in GUI Java Edit Variable Append Log Messageto Log File Java Edit Variable Append Log Messageto Log File For each instrument in inputfile - prepare summary tables CSV Reader Column Rename List Files Zip Files Empty Table Switch End IF Inject Variables(Data) Java Edit Variable Inject Variables(Data) Add Empty Rows Java Snippet Merge Variables Excel Reader (XLS) Merge Variables Table Rowto Variable Excel Writer (XLS) Table Rowto Variable Table Rowto Variable Missing Value Table Creator Row Filter Column Filter Column Filter Color Appender Color Manager RowID

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: cbaudinaud
Created at: 2017-06-19
On NodePit since: 2022-02-06
Last update: 2024-04-26
Created with KNIME version: v4.2.2

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!