Go to the U of M home page
School of Physics & Astronomy
School of Physics and Astronomy Wiki

User Tools

Trace: • ethics • projectdb
groups:mxp:projectdb

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
groups:mxp:projectdb [2022/12/21 14:46] – cse-sull0153groups:mxp:projectdb [2023/08/01 15:35] (current) – cse-sull0153
Line 1: Line 1:
 ====== MXP Project Database ====== ====== MXP Project Database ======
  
-The database contains summaries of over 500 MXP projects going back to 1970. Data from Kurt's long-standing database was imported to MySQL running on a department server, and is accessed here using the Database2 DokuWiki plugin. Thanks to Alex Schumann for setting this up for us. +The database contains summaries of over 500 MXP projects going back to 1970. Data from Kurt's long-standing database was imported to MySQL running on a department server, and is accessed here using the [[https://www.dokuwiki.org/plugin:dbquery|DokuWiki dbquery Plugin]].
  
-Search to narrow the results. Click the "Examine Record" button at right to show the complete record including the report location, and if invented at the time ;-), URL for the experiment webpage. When viewing the URL, __Right-click the link and use Open in New Tab__, since navigation back to the wiki can be annoying. Use the "OK" button at bottom of page to return from wiki record view to wiki list view. 
  
-[[https://zzz.physics.umn.edu/groups/mxp/projectdb|Return to MXP Database ]] 
-  
-<database2 mxp auth=oit-csempx database=@mysql:host=mysql-prod5.oit.umn.edu;dbname=cse_mxp maydrop=!@ALL mayadmin=@admin,manager mayedit=@admin,manager,wick mayinsert=@webgrp_mxp maydelete=@webgrp_mxp,@admin,manager mayfilter=@ALL mayexport=@ALL mayprint=@ALL mayviewlog=@ALL sort=!ProjDate> 
  
-IDPrimKey, integer, id, primary readonly +{{QUERY:projectdb}} 
-ProjDate, date, Date, visible alwaysshow + 
-MXPCodeDescription, text, Category, required length=40 visible +~~NOCACHE~~
-ProjName, text, Project Name, length=256 visible alwaysshow +
-ProjDescription, text, Project Description, visible alwaysshow +
-Students, text, Students, length=150 visible alwaysshow +
-Student1, text, Student1, length=40 +
-Student2, text, Student2, length=40 +
-Student3, text, Student3, length=40 +
-RefMXP, text, Reference, length=5 visible alwaysshow +
-ProjEqBuilt, text, ProjEqBuilt, length=256 +
-RepLocation, text, RepLocation, length=50 alwaysshow +
-RefAIP, text, RefAIP, length=50 +
-ProjURL, URL, ProjURL, length=256 alwaysshow +
-Notes, text, Notes, length=100 alwaysshow +
-</database2>+
  
groups/mxp/projectdb.1671655604.txt.gz · Last modified: 2022/12/21 14:46 by cse-sull0153

Page Tools