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

User Tools

Trace: • 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 [2014/10/23 11:54] – adamgroups: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://wiki.umn.edu/MxpWork/WebHome|Return to MXPwork on UMwiki]]  
  
 +{{QUERY:projectdb}}
 +
 +~~NOCACHE~~
  
-<database mxp auth=physuser-mxp database=@mysql:host=physuser-db.spa.umn.edu;dbname=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 
-ProjDate, date, Date, visible alwaysshow 
-MXPCodeDescription, text, Category, required length=40 visible 
-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 
-</database> 
groups/mxp/projectdb.1414083255.txt.gz · Last modified: 2014/10/23 11:54 by adam

Page Tools