From: <ice...@us...> - 2013-08-03 15:17:49
|
Revision: 6172 http://sourceforge.net/p/web-erp/reponame/6172 Author: icedlava Date: 2013-08-03 15:17:46 +0000 (Sat, 03 Aug 2013) Log Message: ----------- Update the Manual - Using the webERP Installer - rework of some text to match new installer, and updated screen shots. Modified Paths: -------------- trunk/doc/Change.log trunk/doc/Manual/ManualGettingStarted.html trunk/doc/Manual/images/Installer_1.jpg trunk/doc/Manual/images/Installer_2.jpg trunk/includes/Login.php trunk/install/index.php Added Paths: ----------- trunk/doc/Manual/images/Installer_1a.jpg trunk/doc/Manual/images/Installer_3.jpg Modified: trunk/doc/Change.log =================================================================== --- trunk/doc/Change.log 2013-08-03 10:46:15 UTC (rev 6171) +++ trunk/doc/Change.log 2013-08-03 15:17:46 UTC (rev 6172) @@ -1,21 +1,28 @@ webERP Change Log - +04/8/13 icedlava: Update Manual - Using the webERP Installer - rework of some text due to new installer, and updated screen shots +03/8/13 icedlava: Obfuscate database name in login, do not show company in login if directory/company not wanted. 29/7/13 Serge Gélinas: Profit and loss now has option to show all accounts and by default just shows those with a balance +29/7/13 icedlava: Hard code the page title in Installer html, previously missing - no language strings available at this time - used English +28/7/13 icedlava: Installer - strip inline styles, add html5/css to pretty up, fix small typo/bugs and spelling/grammar. No logic changes. +28/7/13 icedlava: Allow ampersands in company name eg Matthew & Sons Ltd +26/7/13 icedlava: Move Supplier Contact Detail review link to top of page away from Delete button +26/7/13 icedlava: Fix Form Designer xml for GL Journal +26/7/13 icedlava: Fix PO PDF Preview when $result returns Bool in some environments. 25/7/13 Serge Gélinas: Balance sheet now has option to show all accounts and by default just shows those with a balance -24/7/13 Exson: Fixed that empty password should be allowed. Reported by Tim. +24/7/13 Exson: Fixed that empty password should be allowed. Reported by Tim. 24/7/13 Exson: Add the html5 mark for some input fields in WWW_Users.php. 22/7/13 Exson: Fixed the document.form not defined error in GLJournal.php. 22/7/13 Thumb: Fixed the onchange overwritten problem for number class in MiscFunctions.js. Reported by Tim for GLJournal.php lost Credit and Debit mutually exclusive feature. 21/07/13 Exson: allowed the input of numeric format like .5 in MiscFunctions.js rLocalNumber() function. Reported by Tim. -7/21/13 Exson: Fixed the keyChar control to avoid backspace mistake. -7/21/13 Exson: Fixed the number class function in MiscFunctions.js prevent character 0 from input for integer. Reported by Icedlava +7/21/13 Exson: Fixed the keyChar control to avoid backspace mistake. +7/21/13 Exson: Fixed the number class function in MiscFunctions.js prevent character 0 from input for integer. Reported by Icedlava 20/7/13 Phil: Added Tim's javascript as modified a bit to use different styles to allow sorting of tables - images for styles to all themes and added th.ascending th.descending to theme/default.css scripts 19/7/13 Phil: Swag of scripts updated for html5 <input type="tel" "email" pattern required="required" autofocus="autofocus" as per http://www.weberp.org/wiki/TransitionToHtml5 also added many title="" tooltips 19/7/13 Exson: add required to the input field of WWW_Access.php 19/7/13: Exson make the WWW_Access.php html5 compatible 18/7/13: Exson: Move the hidden input after the html document type definition. Reported by Tim. -18/7/13 Exson: fixed the LanguageSetup.php extra language mark introduced by handle locale number. Reported by Tim. -18/7/13: Exson: Fixed the missing negative mark problem reported by Tim. +18/7/13 Exson: fixed the LanguageSetup.php extra language mark introduced by handle locale number. Reported by Tim. +18/7/13: Exson: Fixed the missing negative mark problem reported by Tim. 18/7/13: Exson add a locale style check to pass the style to MisFunctions.js to do locale number format validation in LanguageSetup.php. 18/7/13 Exson: modify the MisFunctions.js to improve the locale number validation feature. 17/7/13 icedlava: stripslashes on Description for consistency with LongDescription but why- only until we fix source of this problem in the code Modified: trunk/doc/Manual/ManualGettingStarted.html =================================================================== --- trunk/doc/Manual/ManualGettingStarted.html 2013-08-03 10:46:15 UTC (rev 6171) +++ trunk/doc/Manual/ManualGettingStarted.html 2013-08-03 15:17:46 UTC (rev 6172) @@ -39,38 +39,49 @@ <h2>Using the webERP Installer</h2> -<p>Assuming that a web server with PHP functionality is operational and a MySQL database server is available either on the same machine or on the network and that the web-server is running under a user that is able to write to the webERP installation directory then a new installation can proceed.</p> +<p>A new installation of webERP requires the following to start:</p> + <ul> + <li>A functioning web server running a minimum of PHP version 5.1</li> + <li>A MySQL database server available either on the same machine or on the network</li> + <li>The web server is running under a user that is able to write to the webERP web directory</li> + <li>The database user must have privileges to create a database and tables</li> + </ul> +<ol> + <li>Copy all of the downloaded webERP files to a directory under the web server's document root directory. At this point there should be no 'config.php' file in the webERP directory.</li> + <li>Enter the URL for the new webERP directory into your web browser, and the installer welcome screen will display:</li> -<ul> - <li>An installation must first copy the scripts to a directory under the web-server's document root directory. Then from a browser enter the URL for the new webERP directory and the installer screen will display:</li> - <li style="list-style: none; display: inline"> <p align="center"><img src="images/Installer_1.jpg"></p> </li> - <li>The installer checks that all the pre-requistes are met for an installation. You will note from the screen shot above that this installation does not have sufficient privileges to install webERP because the web-server is unable to write to the webERP directory. <b>It is first necessary to change the permissions on the directory where webERP is installed to ensure that the user that the web-server runs as is able to write a new configuration file to the web space.</b> Cpanel and Plesk have facilities to enable this change to the permissions. Any messages on this screen displayed in red need to be resolved before the installation can proceed. Do not attempt to run the installer while red messages persist.</li> + <li>The installer welcome screen provides information on the type of messages you might receive during installation. At this page, you must also select your preferred language from the drop down selection box. Click on Next Step to go to the next phase of installation.</li> + <li style="list-style: none; display: inline"> + <p align="center"><img src="images/Installer_1a.jpg"></p> + </li> - <li>Many of the fields required will be populated correctly by default - but all entries should be reviewed to ensure that they are correct. The installer will not be able to determine the host (computer) where the mysql database server is installed and this must be entered.</li> - - <li>The user name and the password to the mysql database server are also required.</li> - + <li>The installer checks that all the pre-requistes are met for an installation. You will note from the screen shot above that this installation does not have sufficient privileges to install webERP because the web server is unable to write to the webERP directory. <b>It is necessary to change the permissions on the directory where webERP is installed to ensure that the user that the web-server runs as is able to write a new configuration file to the web space.</b> Cpanel and Plesk have facilities to enable this change to the permissions. Any error messages displayed in red need to be resolved before the installation can proceed. Do not attempt to run the installer while red messages persist. Fix the error and then click on Check Again to restart from the prior step.</li> <li style="list-style: none; display: inline"> <p align="center"><img src="images/Installer_2.jpg"></p> </li> + <li>If your web server fulfills all requirements for the installation, clicking on Next Step will display the Database Settings screen. Many of the fields required will be populated correctly by default - but all entries should be reviewed to ensure that they are correct. The installer will not be able to determine the host (computer) where the mysql database server is installed and this must be entered. Help appears when you click into an input field.</li> - <li>The name of the company entered in the installer screen will become the name of the mysql database created. Perhaps an abbreviated name for the company without spaces is ideal. weberpdemo is the name of the weberpdemo database and that is a good place to test webERP functionality. You should change this to the name of your company in a live enviroment.</li> + <li>The user name and the password to the mysql database server are also required. The mysql database user must have permission to create a database and tables. Once the required information is entered and checked, click on Next Screen to continue.</li> - <li>It is possible to install the demo database rather than the new empty database to use for a new installation by clicking the check box.</li> + <li style="list-style: none; display: inline"> + <p align="center"><img src="images/Installer_3.jpg"></p> + </li> + <li>The next installer screen displays Company Settings, Options and Administrator Account settings. The name of the company entered in the installer screen will be used in the log in screen and in various reports and screens in your final webERP instsallation.</li> + <li>The Chart of Accounts will be loaded into your webERP installation as a set of starter accounts. T There is a larger file but this may result in errors as your mysql server must be able to handle larger packet sizes. Leave the default selection of 'weberp-new.sql' if in any doubt as it is smaller and should load with default mysql settings.</li> + <li>The logo for the business used on invoices and statments, orders etc. can be uploaded to the appropriate place on the web-server by selecting it on the installer screen. The logo should be a .jpg file and just a small image no more than 170 px accross and 80 pixels high.</li> <li>The time-zone is important if your installation is to display the correct time on the local browsers in the country where the business is domiciled. e.g. it is possible to use a US web-server, and operate the business from France. If no entry was entered for the time-zone then the browser would display the time where the web-server was (in the USA) but it is more appropriate to display the time where the business operates from. It is possible to select from any of the PHP defined time-zones.</li> + <li>The Installation Option section enables you to choose to install the demo database in addition to your own Company database. This will provide you with a demo company loaded with some data to test with.</li> - <li>The logo for the business used on invoices and statments, orders etc. can be uploaded to the appropriate place on the web-server by selecting it on the installer screen. The logo should be a .jpg file and just a small image no more than 170 px accross and 80 pixels high.</li> + <li>Finally the webERP user Administrator account option section enables you to input an email address and choose a new password for the default 'admin' account.</li> - <li>Finally the webERP user "admin" is created, and the password for this user needs to be defined from entries on the installer screen. It is also possible to specify your email address which is stored in the database.</li> -</ul> +<li>Click on the INSTALL button to finalise installation. This might take a while as the installer will create required databases, create a special directory for your webERP install in the 'companies' directory, and writes out the webERP configuration file, config.php. Wait until the login screen appears. You now have a fresh webERP installation from which to start the configuration of the company, see below.</li> +<p> </p> -<p>Hitting the install webERP button will then create the database for the company with the user admin given the password details and provide a fresh webERP installation from which to start the configuration of the company, see below.</p> - <div class="floatright"> <a class="minitext" href="#top">⬆ Top</a> </div> Modified: trunk/doc/Manual/images/Installer_1.jpg =================================================================== (Binary files differ) Added: trunk/doc/Manual/images/Installer_1a.jpg =================================================================== (Binary files differ) Index: trunk/doc/Manual/images/Installer_1a.jpg =================================================================== --- trunk/doc/Manual/images/Installer_1a.jpg 2013-08-03 10:46:15 UTC (rev 6171) +++ trunk/doc/Manual/images/Installer_1a.jpg 2013-08-03 15:17:46 UTC (rev 6172) Property changes on: trunk/doc/Manual/images/Installer_1a.jpg ___________________________________________________________________ Added: svn:mime-type ## -0,0 +1 ## +application/octet-stream \ No newline at end of property Modified: trunk/doc/Manual/images/Installer_2.jpg =================================================================== (Binary files differ) Added: trunk/doc/Manual/images/Installer_3.jpg =================================================================== (Binary files differ) Index: trunk/doc/Manual/images/Installer_3.jpg =================================================================== --- trunk/doc/Manual/images/Installer_3.jpg 2013-08-03 10:46:15 UTC (rev 6171) +++ trunk/doc/Manual/images/Installer_3.jpg 2013-08-03 15:17:46 UTC (rev 6172) Property changes on: trunk/doc/Manual/images/Installer_3.jpg ___________________________________________________________________ Added: svn:mime-type ## -0,0 +1 ## +application/octet-stream \ No newline at end of property Modified: trunk/includes/Login.php =================================================================== --- trunk/includes/Login.php 2013-08-03 10:46:15 UTC (rev 6171) +++ trunk/includes/Login.php 2013-08-03 15:17:46 UTC (rev 6172) @@ -46,7 +46,7 @@ echo _('Company') . '<input type="text" name="CompanyNameField" autofocus="autofocus" required="required" value="' . $DefaultCompany . '" />'; } else { // Show selection box ($AllowCompanySelectionBox == 'ShowSelectionBox') - echo _('Company'); + echo _('Company:').'<br />'; echo '<select name="CompanyNameField">'; if (isset($CompanyList) && is_array($CompanyList)) { foreach ($CompanyList as $key => $CompanyEntry){ Modified: trunk/install/index.php =================================================================== --- trunk/install/index.php 2013-08-03 10:46:15 UTC (rev 6171) +++ trunk/install/index.php 2013-08-03 15:17:46 UTC (rev 6172) @@ -129,6 +129,10 @@ $Language = 'en_US.utf8'; $DefaultLanguage = 'en_US.utf8'; } + //This is the first step - let us initialise some variables (esp. important if installer is rerun) + $DatabaseName = ''; + $DefaultDatabase = ''; + }else{ $Language = $_POST['Language']; @@ -454,8 +458,6 @@ prnMsg(_('Failed to create database '.$DatabaseName.' and the error is '.' '.mysql_error($Db)),'error'); } - - } PopulateSQLData($NewSQLFile,false,$Db,$DBConnectType,$DatabaseName); DBUpdate($Db,$DatabaseName,$DBConnectType,$AdminPassword,$Email,$UserLanguage,$CompanyName); @@ -471,7 +473,6 @@ } - } PopulateSQLData(false,$DemoSQLFile,$Db,$DBConnectType,'weberpdemo'); DBUpdate($Db,'weberpdemo',$DBConnectType,$AdminPassword,$Email,$UserLanguage,'weberpdemo'); @@ -896,7 +897,7 @@ <legend><?php echo _('Database settings'); ?></legend> <div class="page_help_text"> <p> - <?php echo _('Please enter your MySQL Database information below. The database name is also used at log in time to choose the company for use.'); ?><br /> + <?php echo _('Please enter your MySQL Database information below.'); ?><br /> <span><?php echo _('* Denotes required field'); ?></span> </p> </div> @@ -919,7 +920,7 @@ <li> <label for="UserName"><?php echo _('Database User Name'); ?>: </label> <input type="text" name="UserName" id="UserName" value="root" placeholder="<?php echo _('A valid database user name'); ?>" maxlength="16" required="true" />  - <span><?php echo _('Must be a user that has permission to create a database.'); ?></span> + <span><?php echo _('Must be a user that has permission to create a database'); ?></span> </li> <li> <label for="Password"><?php echo _('Password'); ?>: </label> |