Safety Data SheetsTEST: Difference between revisions

From sandbox
Jump to navigation Jump to search
(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...")
 
No edit summary
 
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
 
      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)
 
-->
<!-- 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:
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 198:
*[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 222:
{{!}} {{{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 255:




<!-- 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 269:
! SDS Link {{#for_external_table:<nowiki/>
! SDS Link {{#for_external_table:<nowiki/>
{{!}}-
{{!}}-
{{!}} {{{StudioName}}}
{{!}} {{{ToolName}}}
{{!}} {{{ToolName}}}
{{!}} {{{SDSName}}}
{{!}} {{{SDSName}}}
Line 85: Line 275:
|}
|}


 
-->




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




{{#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 23:44, 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