Safety Data SheetsTEST: Difference between revisions

From sandbox
Jump to navigation Jump to search
Gfc (talk | contribs)
Bureaucrats, sandbox-editors, Administrators, Widget editors
2,219 edits
Created page with "==Prototyping Studio== ===Ultimaker S5 FDM 3D Printer=== *[https://drive.google.com/open?id=1tfds97R1pNEzg8_UShI2zr4WuGYZ-BfI ABS Filament] *[https://drive.google.com/open?i..."
 
Gfc (talk | contribs)
Bureaucrats, sandbox-editors, Administrators, Widget editors
2,219 edits
No edit summary
 
(One intermediate revision by the same user not shown)
Line 1: Line 1:
==Prototyping Studio==
{{tocright}}
Under Construction
<!--  NOTICE TO EDITORS OF THIS PAGE
      The contents of this page are generated dynamically from a Google Sheet on the Sandbox shared drive
 
      IF YOU WANT TO UPDATE A SAFETY DATA SHEET
      DO NOT EDIT THIS PAGE!
 
      Instead go to:
            https://drive.google.com/open?id=1PxEME2nnUvaZ1qj2ZEh5xxFyDBi94-hlRNhZdkDiVG0
            (must have permission to edit)
 
-->
 
<!--
{{#get_web_data:
url=https://docs.google.com/spreadsheets/d/e/2PACX-1vQaivE1SSnZM2WJLGCX5Xx3w_8ZcJdGt6XI6JB-bVtugrvbqvKpN8TkqJDFfJh4EhDS-YAF3Plh-1Rf/pub?gid=0&single=true&output=csv
|format=CSV with header
|filters=Room=IRB1246
|data=StudioName=Studio, ToolName=Tool, SDSName=SDSName, SDS Link=SDSLink, SDS Doc=SDSGoogleDoc, Room=Room
}}
=={{#external_value:StudioName}}==
==={{#external_value:Room}}===
{| class="wikitable sortable"
! Material
! SDS Doc
! SDS Link
! Tool {{#for_external_table:<nowiki/>
{{!}}-
{{!}} {{{SDSName}}}
{{!}} [{{{SDS Doc}}} (view local copy) ]
{{!}} [{{{SDS Link}}} (weblink to SDS)]
{{!}} {{{ToolName}}}
}}
|}
Crafts and Sewing
{{#get_web_data:
url=https://docs.google.com/spreadsheets/d/e/2PACX-1vQaivE1SSnZM2WJLGCX5Xx3w_8ZcJdGt6XI6JB-bVtugrvbqvKpN8TkqJDFfJh4EhDS-YAF3Plh-1Rf/pub?gid=0&single=true&output=csv
|format=CSV with header
|filters=Room=IRB1242
|data=StudioName=Studio, ToolName=Tool, SDSName=SDSName, SDS Link=SDSLink, SDS Doc=SDSGoogleDoc, Room=Room
}}
=={{#external_value:StudioName}}==
==={{#external_value:Room}}===
{| class="wikitable sortable"
! Material
! SDS Doc
! SDS Link
! Tool {{#for_external_table:<nowiki/>
{{!}}-
{{!}} {{{SDSName}}}
{{!}} [{{{SDS Doc}}} (view local copy) ]
{{!}} [{{{SDS Link}}} (weblink to SDS)]
{{!}} {{{ToolName}}}
}}
|}
Digital Media Studio (IRB1238)
{{#get_web_data:
url=https://docs.google.com/spreadsheets/d/e/2PACX-1vQaivE1SSnZM2WJLGCX5Xx3w_8ZcJdGt6XI6JB-bVtugrvbqvKpN8TkqJDFfJh4EhDS-YAF3Plh-1Rf/pub?gid=0&single=true&output=csv
|format=CSV with header
|filters=Room=IRB1238
|data=StudioName=Studio, ToolName=Tool, SDSName=SDSName, SDS Link=SDSLink, SDS Doc=SDSGoogleDoc, Room=Room
}}
=={{#external_value:StudioName}}==
==={{#external_value:Room}}===
{| class="wikitable sortable"
! Material
! SDS Doc
! SDS Link
! Tool {{#for_external_table:<nowiki/>
{{!}}-
{{!}} {{{SDSName}}}
{{!}} [{{{SDS Doc}}} (view local copy) ]
{{!}} [{{{SDS Link}}} (weblink to SDS)]
{{!}} {{{ToolName}}}
}}
|}
Prototyping Studio
{{#get_web_data:
url=https://docs.google.com/spreadsheets/d/e/2PACX-1vQaivE1SSnZM2WJLGCX5Xx3w_8ZcJdGt6XI6JB-bVtugrvbqvKpN8TkqJDFfJh4EhDS-YAF3Plh-1Rf/pub?gid=0&single=true&output=csv
|format=CSV with header
|filters=Room=IRB1223
|data=StudioName=Studio, ToolName=Tool, SDSName=SDSName, SDS Link=SDSLink, SDS Doc=SDSGoogleDoc, Room=Room
}}
=={{#external_value:StudioName}}==
==={{#external_value:Room}}===
{| class="wikitable sortable"
! Material
! SDS Doc
! SDS Link
! Tool {{#for_external_table:<nowiki/>
{{!}}-
{{!}} {{{SDSName}}}
{{!}} [{{{SDS Doc}}} (view local copy) ]
{{!}} [{{{SDS Link}}} (weblink to SDS)]
{{!}} {{{ToolName}}}
}}
|}
Woodworking Studio (IRB1224)
{{#get_web_data:
url=https://docs.google.com/spreadsheets/d/e/2PACX-1vQaivE1SSnZM2WJLGCX5Xx3w_8ZcJdGt6XI6JB-bVtugrvbqvKpN8TkqJDFfJh4EhDS-YAF3Plh-1Rf/pub?gid=0&single=true&output=csv
|format=CSV with header
|filters=Room=IRB1224
|data=StudioName=Studio, ToolName=Tool, SDSName=SDSName, SDS Link=SDSLink, SDS Doc=SDSGoogleDoc, Room=Room
}}
=={{#external_value:StudioName}}==
==={{#external_value:Room}}===
{| class="wikitable sortable"
! Material
! SDS Doc
! SDS Link
! Tool {{#for_external_table:<nowiki/>
{{!}}-
{{!}} {{{SDSName}}}
{{!}} [{{{SDS Doc}}} (view local copy) ]
{{!}} [{{{SDS Link}}} (weblink to SDS)]
{{!}} {{{ToolName}}}
}}
|}
CNC Studio (IRB1222)
{{#get_web_data:
url=https://docs.google.com/spreadsheets/d/e/2PACX-1vQaivE1SSnZM2WJLGCX5Xx3w_8ZcJdGt6XI6JB-bVtugrvbqvKpN8TkqJDFfJh4EhDS-YAF3Plh-1Rf/pub?gid=0&single=true&output=csv
|format=CSV with header
|filters=Room=IRB1222
|data=StudioName=Studio, ToolName=Tool, SDSName=SDSName, SDS Link=SDSLink, SDS Doc=SDSGoogleDoc, Room=Room
}}
=={{#external_value:StudioName}}==
==={{#external_value:Room}}===
{| class="wikitable sortable"
! Material
! SDS Doc
! SDS Link
! Tool {{#for_external_table:<nowiki/>
{{!}}-
{{!}} {{{SDSName}}}
{{!}} [{{{SDS Doc}}} (view local copy) ]
{{!}} [{{{SDS Link}}} (weblink to SDS)]
{{!}} {{{ToolName}}}
}}
|}
Project Studio (IRB1220)
{{#get_web_data:
url=https://docs.google.com/spreadsheets/d/e/2PACX-1vQaivE1SSnZM2WJLGCX5Xx3w_8ZcJdGt6XI6JB-bVtugrvbqvKpN8TkqJDFfJh4EhDS-YAF3Plh-1Rf/pub?gid=0&single=true&output=csv
|format=CSV with header
|filters=Room=IRB1220
|data=StudioName=Studio, ToolName=Tool, SDSName=SDSName, SDS Link=SDSLink, SDS Doc=SDSGoogleDoc, Room=Room
}}
=={{#external_value:StudioName}}==
==={{#external_value:Room}}===
{| class="wikitable sortable"
! Material
! SDS Doc
! SDS Link
! Tool {{#for_external_table:<nowiki/>
{{!}}-
{{!}} {{{SDSName}}}
{{!}} [{{{SDS Doc}}} (view local copy) ]
{{!}} [{{{SDS Link}}} (weblink to SDS)]
{{!}} {{{ToolName}}}
}}
|}
 
All SDS records in sheet
{{#get_web_data:
url=https://docs.google.com/spreadsheets/d/e/2PACX-1vQaivE1SSnZM2WJLGCX5Xx3w_8ZcJdGt6XI6JB-bVtugrvbqvKpN8TkqJDFfJh4EhDS-YAF3Plh-1Rf/pub?gid=0&single=true&output=csv
|format=CSV with header
|data=StudioName=Studio, ToolName=Tool, SDSName=SDSName, SDS Link=SDSLink, SDS Doc=SDSGoogleDoc, Room=Room
}}
 
== All Safety Data Sheets ==
 
{| class="wikitable sortable"
! Room
! Studio Name
! Tool
! Material
! SDS Doc
! SDS Link {{#for_external_table:<nowiki/>
{{!}}-
{{!}} {{{Room}}}
{{!}} {{{StudioName}}}
{{!}} {{{ToolName}}}
{{!}} {{{SDSName}}}
{{!}} [{{{SDS Doc}}} Sandbox local PDF copy ]
{{!}} [{{{SDS Link}}} Safety Data Sheet]
}}
|}
 
 
 
 
<! -- ==Prototyping Studio==


===Ultimaker S5 FDM 3D Printer===
===Ultimaker S5 FDM 3D Printer===
Line 9: Line 200:
*[https://drive.google.com/open?id=1Y7usl-YFhzc3ikF25mNJ9brVFhy9RSU3 Tough PLA Filament]
*[https://drive.google.com/open?id=1Y7usl-YFhzc3ikF25mNJ9brVFhy9RSU3 Tough PLA Filament]
*[https://drive.google.com/open?id=1ASB1p6f3hTAqMRhUESDOx2qUiD_9A2sh PVA Filament]
*[https://drive.google.com/open?id=1ASB1p6f3hTAqMRhUESDOx2qUiD_9A2sh PVA Filament]
-- >


<! -- Try2: Add SELECT WHERE clause to Google sheets query


Adding the SELECT WHERE clause removes CSV headers If I cut and paste the URL into a web browser the results seem correct but without CSV headers.
I'd rather not use External Data for google sheets without headers since it's too easy to modify columns in sprerad sheet.
{{#clear_external_data:}}
{{#get_web_data:
{{#get_web_data:
  url=https://docs.google.com/spreadsheets/d/e/2PACX-1vQaivE1SSnZM2WJLGCX5Xx3w_8ZcJdGt6XI6JB-bVtugrvbqvKpN8TkqJDFfJh4EhDS-YAF3Plh-1Rf/pub?gid=0&single=true&output=csv
  url=https://docs.google.com/spreadsheets/d/1PxEME2nnUvaZ1qj2ZEh5xxFyDBi94-hlRNhZdkDiVG0/gviz/tq?tqx=out:csv&tq=select%20A%2C%20B%2C%20C%2C%20D%20where%20B%3D'Woodworking%20Studio'
  |format=CSV with header
  |format=CSV
|filters=Studio=Prototyping Studio
  |data=StudioName=Studio, ToolName=Tool, SDSName=SDS Name, SDSLink=SDS Link, SDSDoc=SDSdoc
  |data=StudioName=Studio, ToolName=Tool, SDSName=SDS Name, SDSLink=SDS Link
}}
}}




{| class="wikitable"
{| class="wikitable sortable"
! Studio  
! Studio  
! Tool
! Tool
Line 29: Line 224:
{{!}} {{{SDSName}}}
{{!}} {{{SDSName}}}
{{!}} [{{{SDSLink}}} Safety Data Sheet]
{{!}} [{{{SDSLink}}} Safety Data Sheet]
{{!}} [{{{SDSDoc}}} Safety Data Sheet PDF]
}}
}}
|}
|}


-- >


<!-- Try2: Add SELECT WHERE clause to Google sheets query  
 
<! -- Try3: Add SELECT WHERE clause to Google sheets query  


Why doesn't the query SELECT WHERE clause work? If I cut and paste the URL into a web browser the results seem correct.
Why doesn't the query SELECT WHERE clause work? If I cut and paste the URL into a web browser the results seem correct.
-->


{{#clear_external_data:}}
 
{{#get_web_data:
{{#get_web_data:
  url=https://docs.google.com/spreadsheets/d/1PxEME2nnUvaZ1qj2ZEh5xxFyDBi94-hlRNhZdkDiVG0/gviz/tq?tqx=out:csv&tq=select%20A%2C%20B%2C%20C%2C%20D%20where%20A%3D'Woodworking%20Studio'
  url=https://docs.google.com/spreadsheets/d/1PxEME2nnUvaZ1qj2ZEh5xxFyDBi94-hlRNhZdkDiVG0/gviz/tq?tqx=out:csv&tq=select%20A%2C%20C%2C%20D%20where%20B%3D'Electronics%20Studio'
  |format=CSV
  |format=CSV with header
  |data=StudioName=Studio, ToolName=Tool, SDSName=SDS Name, SDSLink=SDS Link
  |data=StudioName=Studio, ToolName=Tool, SDSName=SDS Name, SDSLink=SDS Link
}}
}}
Line 60: Line 257:




<!-- Try3: Add SELECT WHERE clause to Google sheets query
Why doesn't the query SELECT WHERE clause work? If I cut and paste the URL into a web browser the results seem correct.
-->


{{#get_web_data:
{{#get_web_data:
  url=https://docs.google.com/spreadsheets/d/1PxEME2nnUvaZ1qj2ZEh5xxFyDBi94-hlRNhZdkDiVG0/gviz/tq?tqx=out:csv&tq=select%20A%2C%20C%2C%20D%20where%20A%3D'Electronics%20Studio'
  url=https://docs.google.com/spreadsheets/d/1PxEME2nnUvaZ1qj2ZEh5xxFyDBi94-hlRNhZdkDiVG0/gviz/tq?tqx=out:csv
  |format=CSV with header
  |format=CSV with header
  |data=StudioName=Studio, ToolName=Tool, SDSName=SDS Name, SDSLink=SDS Link
  |data=StudioName=Studio, ToolName=Tool, SDSName=SDS Name, SDSLink=SDS Link
Line 78: Line 271:
! SDS Link {{#for_external_table:<nowiki/>
! SDS Link {{#for_external_table:<nowiki/>
{{!}}-
{{!}}-
{{!}} {{{StudioName}}}
{{!}} {{{ToolName}}}
{{!}} {{{ToolName}}}
{{!}} {{{SDSName}}}
{{!}} {{{SDSName}}}
Line 85: Line 277:
|}
|}


-- >




 
<! --
<!--
 
 
 
For example:
*{{#for_external_table:*{{{ToolName}}} has the following SDS: {{{SDSName}}}.\n}}
*{{#for_external_table:*{{{ToolName}}} has the following SDS: {{{SDSName}}}.\n}}


Line 98: Line 286:
{{#external_value:StudioName}}, {{#external_value:ToolName}}, {{#external_value:SDSName}}, {{#external_value:SDSLink}}
{{#external_value:StudioName}}, {{#external_value:ToolName}}, {{#external_value:SDSName}}, {{#external_value:SDSLink}}


 
-- >
https://docs.google.com/spreadsheets/d/e/2PACX-1vQaivE1SSnZM2WJLGCX5Xx3w_8ZcJdGt6XI6JB-bVtugrvbqvKpN8TkqJDFfJh4EhDS-YAF3Plh-1Rf/pub?gid=0&single=true&output=csv






-->
-->

Latest revision as of 21:27, 28 September 2026

Under Construction


Retrieved from "https://sandbox.umd.edu/wiki/index.php?title=Safety_Data_SheetsTEST&oldid=3248"