Extension talk:Mccp

=Complete Installation Walkthrough= note: there are many aspects of this install that you will no doubt want to change and customize... but since the extension is an integration of all these things...I wanted to provide you with a super-simple installation walkthrough that is complete... so, here it goes.....

1. First we install and test the WAMP

 * 1) Started with nothing but a machine running windows XP
 * 2) Downloaded WedDev 2.0 from: http://sourceforge.net/project/showfiles.php?group_id=187164
 * Note: saved it to C:\ (this is where it must be run from)
 * 1) Ran "c:\wdsetup-v2.00.exe" and selected "Complete" install type.
 * Note: had to reboot when it was done.
 * 1) Tested my apache server by visiting: "http://localhost/phpinfo.php"
 * Note:got the expected PHP Info page
 * 1) Tested MySQL by visiting: "http://localhost/phpmyadmin/"
 * Note: used the default WebDev MySQL admin username and password of: root:rootwdp
 * Noted the correct "phpmyadmin" response page. so far so good!

2. Next we install and test mediawiki

 * 1) Triggered my mediawiki install by visiting the page: "http://localhost/mediawiki/"
 * Notes:
 * Named it "mytestwiki"
 * provided WikiSysOp password
 * Changed the option for email authentication to "disabled"
 * Used the "Superuser Account" for the database section using root:rootwdp from "phpmyadmin" test above
 * left everything else as default
 * 1) Mediawiki Installation Successful!
 * 2) Moved mediawiki's "LocalSettings.php" file
 * from: "C:\www\webapps\mediawiki\config\"
 * to: "C:\www\webapps\mediawiki\"
 * 1) Then visited: "http://localhost/mediawiki/index.php/Main_Page" and saw the default main page.

3. Next we install PHP's PEAR so as to get the MSExcel Spreadsheet creation tools:

 * 1) Open a command prompt and go to the "C:\www\php5\" directory
 * 2) Trigger the installation of PEAR by typing, "go-pear.bat"
 * press "enter" to accept the system installation
 * press "enter" again to accept all default file layout choices
 * type "Y" to let PEAR alter php.ini
 * press "enter" to continue.
 * press "enter" to finish the PEAR install (note the advice to modify the environment settings, but do nothing yet)
 * (Now we need to install a pre-requisite of "Express Spreadsheet" called OLE')
 * 1) type "pear install OLE-1.0.0RC1" to install PHP OLE
 * 2) next type "pear install Spreadsheet_Excel_Writer-0.9.1" to install Excell writer
 * (keep the command prompt open)

4. Next we need to install WGET

 * 1) with a web browser, visit: "http://users.ugent.be/~bpuype/wget/#download" and download the exe file "wget.exe"
 * Created a folder called "wget" in "c:\www\" to make the path: "c:\www\wget"
 * 1) Copied "wget.exe" to "c:\www\wget\"
 * 2) Test "WGET" in the command prompt by...
 * go to the "c:\www\wget\" folder and type "wget -O trash.txt http://localhost/phpinfo.php"
 * Note a successful response with no failures and note the output file called "trash.txt" in the folder with "wget.exe"

5. Next we need to make sure the SSL is working

 * 1) Re-test "wget" with SSL by typing "wget -O trash-ssl.txt --no-check-certificate https://localhost/phpinfo.php"
 * Note a successful response with no failures and note the output file called "trash-ssl.txt" in the folder with "wget.exe"

6. Next we need to set-up the MS-Access ODBC connection

 * 1) Included in the MCCP Extension zip file (in the b2ccdb folder) is the "template" database
 * ("http://www.mavericks2252.net/archive/mediawiki-extensions/mccp/" called "MCCP_Database.mdb")
 * Save it to "c:\" (wherever, really. just decide where you want it and note the location)
 * 1) Click "Start->Control Panel", then open "Administrative Tools"
 * from "Administrative Tools" open "Data Sources (ODBC)"
 * from "Data Sources (ODBC)" select the "System DNS" tab
 * click "Add", select "Microsoft Access Driver(*.mdb)", click "Finish"
 * Set the Data source name to: "MCCP_Metrology_Database"
 * Select the database file "c:\MCCP_Database.mdb" as the data source (or wherever you saved the template database file)
 * Select "OK" to finish the ODBC driver set-up tool

7. Next we need to install the "MCCP" Extension :-)

 * 1) Download the latest MCCP extension version from: "http://www.mavericks2252.net/archive/mediawiki-extensions/mccp/"
 * 2) Unzip it onto your desktop and we'll put things where they belong manually.
 * 3) from the unzipped MCCP file on your desktop:
 * go in to the "Desktop\{MCCP Zip File}\your-wiki\extensions\" folder ...
 * and copy the folder "mccp" to the "extension" folder of "your" mediawiki folder.
 * (you should now have a copy of that folder at: "C:\www\webapps\mediawiki\extensions\"
 * which is like... "C:\www\webapps\mediawiki\extensions\mccp\")
 * 1) again, from the unzipped MCCP file on your desktop:
 * go in to the "Desktop\{MCCP Zip File}\" base folder...
 * and copy the folder "b2ccdb" to the root web folder of your apache server.
 * (which is: "C:\www\vhosts\localhost")
 * you should now have a copy of this folder at:
 * "C:\www\vhosts\localhost\b2ccdb\"
 * (fyi, the MCCP extension uses iframes to facilitate inline editing... these folders do that...don't mess with them!)
 * you should now have a copy of this folder at:
 * "C:\www\vhosts\localhost\b2ccdb\"
 * (fyi, the MCCP extension uses iframes to facilitate inline editing... these folders do that...don't mess with them!)
 * (fyi, the MCCP extension uses iframes to facilitate inline editing... these folders do that...don't mess with them!)

8. Perform the usual "LocalSettings.php" modification to enable the extensions :-)
$wgExtraNamespaces = array ( 900 => "MCCP_Function Type_ID" ,901 => "MCCP_Function Type_ID_talk" ,902 => "MCCP_Manufacturer_ID" ,903 => "MCCP_Manufacturer_ID_talk" ,904 => "MCCP_Product_ID" ,905 => "MCCP_Product_ID_talk" ,906 => "MCCP_Equipment_ID" ,907 => "MCCP_Equipment_ID_talk" ,908 => "MCCP_Location Site_ID" ,909 => "MCCP_Location Site_ID_talk" ,910 => "MCCP_Location Structure_ID" ,911 => "MCCP_Location Structure_ID_talk" ,912 => "MCCP_Location Room_ID" ,913 => "MCCP_Location Room_ID_talk" ,914 => "MCCP_Location Area_ID" ,915 => "MCCP_Location Area_ID_talk" ,916 => "MCCP_System_ID" ,917 => "MCCP_System_ID_talk" ,918 => "MCCP_Subsystem_ID" ,919 => "MCCP_Subsystem_ID_talk" ,920 => "MCCP_Instrument_ID" ,921 => "MCCP_Instrument_ID_talk" ,922 => "MCCP_Drawing_ID" ,923 => "MCCP_Drawing_ID_talk" ,924 => "MCCP_Task_ID" ,925 => "MCCP_Task_ID_talk" ,926 => "MCCP_Project_ID" ,927 => "MCCP_Project_ID_talk" ,928 => "MCCP_Document_ID" ,929 => "MCCP_Document_ID_talk" ,928 => "MCCP_Log_ID" ,929 => "MCCP_Log_ID_talk" );
 * 1) Open "LocalSettings.php" (found in: "C:\www\webapps\mediawiki", remember? ;-)in a text editor and add the lines:

require_once("$IP/extensions/mccp/database_logs.setup.php"); require_once("$IP/extensions/mccp/statistics.setup.php"); require_once("$IP/extensions/mccp/testing.setup.php"); require_once("$IP/extensions/mccp/product_apps.setup.php"); require_once("$IP/extensions/mccp/product_types.setup.php"); require_once("$IP/extensions/mccp/manufacturers.setup.php"); require_once("$IP/extensions/mccp/products.setup.php"); require_once("$IP/extensions/mccp/location.setup.php"); require_once("$IP/extensions/mccp/systems.setup.php"); require_once("$IP/extensions/mccp/inventory.setup.php");
 * 1) --- MCCP EXTENSIONS -
 * 1) --- MCCP EXTENSIONS -

the end.

8. Configure the Localization variables
this is the only hard/tricky part $mccp_relative_filesystem_path2b2ccdb = "../../b2ccdb/"; $wikipath                            = "mediawiki/"; $mccp_absolute_filesystem_wgetpath   = "c:\\www\wget\\"; $mccp_relative_serverURL2shortlink   = "../../";
 * 1) Notice in the folder ../b2ccdb/ there is a file called "b2x-cfg.php"
 * you must edit this file so that it can find the "mccp" extension folder in your mediawiki
 * 1) Next, open the file "mccp-init.php" in the "extensions/mccp/" folder
 * you will need to set these variables accordingly
 * the setting that should work for this walkthrough look something like this:
 * the setting that should work for this walkthrough look something like this:

$wiki2zb2ccdbpath                    = "../../b2ccdb/"; $wiki2zb2ccdbwwwpath                 = "../../b2ccdb/";

$MCCP_DSN_FileName                   = 'MCCP_Database'; $MCCP_DSN_UserName                   = ''; $MCCP_DSN_Password                   = '';

$MCCP_Devs_Username                  = 'WikiSysop'; $MCCP_Devs_IPAddress                 = '192.168.1.1';

$b2xrequestdataprefix = "wiki_";

9. Initialize the system
An old trick used to eliminate redundant database querries is to generate a static text files of the parts of the database content that doesn't change very often and then just read the text file instead of querying the database repetitively. So we need to do that with our new system. As a side-note, you will also need to re-do this anytime you go in to the database manually and ADD a new system, location or part definition.

Its very easy.... just visit the following pages to create/update the respective text file:


 * Special:MCCP_Database-_Products
 * Special:MCCP_Database-_Location
 * Special:MCCP_Database-_Systems
 * Special:MCCP_Database-_Product_apps
 * Special:MCCP_Database-_Product_types
 * Special:MCCP_Database-_Manufacturers

=10. test it= if everything has gone well, the page you will want to use as the "front-door" to the system is the inventory page.

visit the inventory page at:
 * Special:MCCP_Database-_Inventory

=epiloge= well... that's it... the rest of the information will have to be in the form of a user-manual that i have yet to write.

so until I get to that.. you will have to email me or ask here.

be sure to tell me if you use it and if you have any success....

Cheers! - Rich (revansx)

=User Feedback= ...