Safety Data Sheets: Difference between revisions

From sandbox
Jump to navigation Jump to search
No edit summary
(Replaced all with contents of test page)
Line 1: Line 1:
==Prototyping Studio==
{{tocright}}
<!--  NOTICE TO EDITORS OF THIS PAGE
      The contents of this page are generated dynamically from a Google Sheet on the Sandbox shared drive


===Ultimaker S5 FDM 3D Printer===
      IF YOU WANT TO UPDATE A SAFETY DATA SHEET
 
      DO NOT EDIT THIS PAGE!
*[https://drive.google.com/open?id=1tfds97R1pNEzg8_UShI2zr4WuGYZ-BfI ABS Filament]
*[https://drive.google.com/open?id=1vqGkijvCyl-gekuSZnkV13tTj7hqanmj Breakaway Support FIlament]
*[https://drive.google.com/open?id=1xpwj5eC6dk1Atek2u-48ZB0punkJ4_HV Nylon Filament]
*[https://drive.google.com/open?id=1xCJRczEO9gApkKWybmq9qiJCT-ckVXFv PLA Filament]
*[https://drive.google.com/open?id=1Y7usl-YFhzc3ikF25mNJ9brVFhy9RSU3 Tough PLA Filament]
*[https://drive.google.com/open?id=1ASB1p6f3hTAqMRhUESDOx2qUiD_9A2sh PVA Filament]


      Instead go to:
            https://drive.google.com/open?id=1PxEME2nnUvaZ1qj2ZEh5xxFyDBi94-hlRNhZdkDiVG0
            (must have permission to edit)


-->
<!-- Electronics 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=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:
{{#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/e/2PACX-1vQaivE1SSnZM2WJLGCX5Xx3w_8ZcJdGt6XI6JB-bVtugrvbqvKpN8TkqJDFfJh4EhDS-YAF3Plh-1Rf/pub?gid=0&single=true&output=csv
  |format=CSV with header
  |format=CSV with header
  |filters=Studio=Prototyping Studio
  |filters=Room=IRB1223
  |data=StudioName=Studio, ToolName=Tool, SDSName=SDS Name, SDSLink=SDS Link
  |data=StudioName=Studio, ToolName=Tool, SDSName=SDSName, SDS Link=SDSLink, SDS Doc=SDSGoogleDoc, Room=Room
}}
}}
 
=={{#external_value:StudioName}}==
 
==={{#external_value:Room}}===
{| class="wikitable"
{| class="wikitable sortable"
! Studio
! Material
! Tool
! SDS Doc
! SDS Name
! SDS Link
! SDS Link {{#for_external_table:<nowiki/>
! Tool {{#for_external_table:<nowiki/>
{{!}}-
{{!}}-
{{!}} {{{StudioName}}}
{{!}} {{{SDSName}}}
{{!}} [{{{SDS Doc}}} (view local copy) ]
{{!}} [{{{SDS Link}}} (weblink to SDS)]
{{!}} {{{ToolName}}}
{{!}} {{{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}}}
{{!}} {{{SDSName}}}
{{!}} [{{{SDSLink}}} Safety Data Sheet]
{{!}} [{{{SDS Doc}}} (view local copy) ]
{{!}} [{{{SDS Link}}} (weblink to SDS)]
{{!}} {{{ToolName}}}
}}
}}
|}
|}
 
<!-- CNC Studio (IRB1222)-->
 
<!-- Try2: 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.
-->
 
{{#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/e/2PACX-1vQaivE1SSnZM2WJLGCX5Xx3w_8ZcJdGt6XI6JB-bVtugrvbqvKpN8TkqJDFfJh4EhDS-YAF3Plh-1Rf/pub?gid=0&single=true&output=csv
  |format=CSV
  |format=CSV with header
  |data=StudioName=Studio, ToolName=Tool, SDSName=SDS Name, SDSLink=SDS Link
|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"
{| class="wikitable sortable"
! Studio
! Material
! Tool
! SDS Doc
! SDS Name
! SDS Link
! SDS Link {{#for_external_table:<nowiki/>
! Tool {{#for_external_table:<nowiki/>
{{!}}-
{{!}}-
{{!}} {{{StudioName}}}
{{!}} {{{SDSName}}}
{{!}} [{{{SDS Doc}}} (view local copy) ]
{{!}} [{{{SDS Link}}} (weblink to SDS)]
{{!}} {{{ToolName}}}
{{!}} {{{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}}}
{{!}} {{{SDSName}}}
{{!}} [{{{SDSLink}}} Safety Data Sheet]
{{!}} [{{{SDS Doc}}} (view local copy) ]
{{!}} [{{{SDS Link}}} (weblink to SDS)]
{{!}} {{{ToolName}}}
}}
}}
|}
|}


 
<!-- All SDS records in sheet -->
<!-- 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/e/2PACX-1vQaivE1SSnZM2WJLGCX5Xx3w_8ZcJdGt6XI6JB-bVtugrvbqvKpN8TkqJDFfJh4EhDS-YAF3Plh-1Rf/pub?gid=0&single=true&output=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=SDSName, SDS Link=SDSLink, SDS Doc=SDSGoogleDoc, Room=Room
}}
}}


== All Safety Data Sheets ==


{| class="wikitable"
{| class="wikitable sortable"
! Studio  
! Room
! Tool
! Studio Name
! SDS Name
! Tool  
! Material
! SDS Doc
! SDS Link {{#for_external_table:<nowiki/>
! SDS Link {{#for_external_table:<nowiki/>
{{!}}-
{{!}}-
{{!}} {{{Room}}}
{{!}} {{{StudioName}}}
{{!}} {{{StudioName}}}
{{!}} {{{ToolName}}}
{{!}} {{{ToolName}}}
{{!}} {{{SDSName}}}
{{!}} {{{SDSName}}}
{{!}} [{{{SDSLink}}} Safety Data Sheet]
{{!}} [{{{SDS Doc}}} Sandbox local PDF copy ]
{{!}} [{{{SDS Link}}} Safety Data Sheet]
}}
}}
|}
|}
<!--
For example:
*{{#for_external_table:*{{{ToolName}}} has the following SDS: {{{SDSName}}}.\n}}
{{#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
-->

Revision as of 23:47, 13 November 2019

Error: no local variable "StudioName" has been set.

Error: no local variable "Room" has been set.

Material SDS Doc SDS Link Tool

Error: no local variable "StudioName" has been set.

Error: no local variable "Room" has been set.

Material SDS Doc SDS Link Tool

Error: no local variable "StudioName" has been set.

Error: no local variable "Room" has been set.

Material SDS Doc SDS Link Tool

Error: no local variable "StudioName" has been set.

Error: no local variable "Room" has been set.

Material SDS Doc SDS Link Tool

Error: no local variable "StudioName" has been set.

Error: no local variable "Room" has been set.

Material SDS Doc SDS Link Tool

Error: no local variable "StudioName" has been set.

Error: no local variable "Room" has been set.

Material SDS Doc SDS Link Tool

Error: no local variable "StudioName" has been set.

Error: no local variable "Room" has been set.

Material SDS Doc SDS Link Tool


All Safety Data Sheets

Room Studio Name Tool Material SDS Doc SDS Link
Retrieved from "https://wiki.umiacs.umd.edu/sandbox/index.php?title=Safety_Data_Sheets&oldid=761"