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..... require_once("$IP/extensions/b2wiki-specialpages/b2wikiextension_b2x_product_apps.setup.php"); require_once("$IP/extensions/b2wiki-specialpages/b2wikiextension_b2x_product_types.setup.php"); require_once("$IP/extensions/b2wiki-specialpages/b2wikiextension_b2x_manufacturers.setup.php"); require_once("$IP/extensions/b2wiki-specialpages/b2wikiextension_b2x_products.setup.php"); require_once("$IP/extensions/b2wiki-specialpages/b2wikiextension_b2x_location.setup.php"); require_once("$IP/extensions/b2wiki-specialpages/b2wikiextension_b2x_systems.setup.php"); require_once("$IP/extensions/b2wiki-specialpages/b2wikiextension_b2x_inventory.setup.php"); require_once("$IP/extensions/b2wiki-specialpages/b2wikiextension_b2x_database_logs.setup.php"); the end.
 * 1) Started with nothing but a machine running windows XP
 * First we install and test the WAMP
 * 1) 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!
 * 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.
 * 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)
 * 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"
 * 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"
 * Next we need to set-up the MS-Access ODBC connection
 * 1) Download the "template" database from "http://www.mavericks2252.net/archive/mediawiki-extensions/mccp/" called "MCCPDb.mdb"
 * Save it to "c:\"
 * 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: "B2X_Metrology_Database"
 * Select the database file "c:\MCCPDb.mdb" as the data source
 * Select "OK" to finish the ODBC driver set-up tool
 * 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}\mccp\extensions" folder (fyi: "MCCP" is is name of the wiki folder on my development machine)...
 * and copy the folder "b2wiki-specialpages" 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... "C:\www\webapps\mediawiki\extensions\b2wiki-specialpages\")
 * 1) again, from the unzipped MCCP file on your desktop:
 * go in to the "Desktop\{MCCP Zip File}\" base folder
 * and copy the two folders "b2ccdb" AND "b2wiki-include" to the root web folder of your apache server.
 * (which is: "C:\www\vhosts\localhost")
 * you should now have a copy of those two folders at:
 * "C:\www\vhosts\localhost\b2ccdb\" and
 * "C:\www\vhosts\localhost\b2wiki-includes\"
 * (fyi, the MCCP extension uses iframes to facilitate inline editing... these folders do that...don't mess with them!)
 * Perform the usual "LocalSettings.php" modification to enable the extensions :-)
 * 1) Open "LocalSettings.php" (found in: "C:\www\webapps\mediawiki", remember? ;-)in a text editor and add the line:
 * 1) again, from the unzipped MCCP file on your desktop:
 * go in to the "Desktop\{MCCP Zip File}\" base folder
 * and copy the two folders "b2ccdb" AND "b2wiki-include" to the root web folder of your apache server.
 * (which is: "C:\www\vhosts\localhost")
 * you should now have a copy of those two folders at:
 * "C:\www\vhosts\localhost\b2ccdb\" and
 * "C:\www\vhosts\localhost\b2wiki-includes\"
 * (fyi, the MCCP extension uses iframes to facilitate inline editing... these folders do that...don't mess with them!)
 * Perform the usual "LocalSettings.php" modification to enable the extensions :-)
 * 1) Open "LocalSettings.php" (found in: "C:\www\webapps\mediawiki", remember? ;-)in a text editor and add the line:
 * Perform the usual "LocalSettings.php" modification to enable the extensions :-)
 * 1) Open "LocalSettings.php" (found in: "C:\www\webapps\mediawiki", remember? ;-)in a text editor and add the line: