FrontAccounting/C2/Installation-of-FrontAccounting-on-Windows-OS/English-timed
From Script | Spoken-Tutorial
| Time | Narration |
| 00:01 | Welcome to the spoken tutorial on FrontAccounting installation on Windows Operating System. |
| 00:08 | In this tutorial, we will learn to: |
| 00:10 | download FrontAccounting software, |
| 00:14 | create a database for FrontAccounting, |
| 00:18 | and install FrontAccounting software in Windows OS. |
| 00:24 | To record this tutorial, I'm using- |
| 00:27 | Windows 8 OS, XAMPP 5.6.24 ,
FrontAccounting 2.4.1, Firefox web browser and a working Internet connection. |
| 00:43 | Let’s begin. |
| 00:44 | To run FrontAccounting, we require a web server, php and a database on our machine. |
| 00:52 | We will use Apache as our web server and MySQL as our database. |
| 00:59 | By installing XAMPP package, all of these will get installed together. |
| 01:05 | To install XAMPP package, |
| 01:07 | refer to the XAMPP installation tutorial in the PHP & MySQL series, on this website. |
| 01:14 | Follow the instructions given in this tutorial to install the latest version. |
| 01:20 | I have already installed XAMPP on my machine. |
| 01:24 | To open XAMPP, click on the Windows key on the keyboard and type XAMPP. |
| 01:32 | Click on the XAMPP Control Panel icon from the search list. |
| 01:37 | In the XAMPP Control Panel, make sure that Apache & MySQL services are running. |
| 01:44 | If not, start these services by clicking on START button on the respective services. |
| 01:52 | To stop the services, we have to click on STOP button. |
| 01:57 | You may get some error messages like: |
| 02:00 | “Apache shutdown unexpectedly” or |
| 02:04 | “Port 80 in use for Apache Server” or |
| 02:09 | “Unable to connect to any of the specified MySQL hosts for MySQL database”. |
| 02:16 | This is because the default ports allotted for Apache and MySQL is taken by other software. |
| 02:24 | Default port number for Apache is 80 and for MySQL is 3306. |
| 02:32 | To change these ports, refer to the XAMPP Installation tutorial in the PHP & MySQL series, on this website. |
| 02:40 | Allot proper port numbers before proceeding further. |
| 02:44 | Let us check whether the webserver is running or not. |
| 02:48 | To do so, open the web browser and type localhost in the url. |
| 02:55 | If you have changed the port number, then type localhost:8080. |
| 03:02 | Then press Enter key. |
| 03:05 | This will take us to the Xampp welcome page. |
| 03:09 | Next we have to create a database for FrontAccounting. |
| 03:14 | We can do this with the help of phpmyadmin. |
| 03:18 | To open phpMyAdmin, on the web browser address bar, type: localhost/phpmyadmin. |
| 03:28 | or localhost:8080/phpmyadmin |
| 03:35 | and press Enter. |
| 03:38 | This will open the phpMyAdmin page. |
| 03:42 | Let’s create the database now. |
| 03:45 | On the top left of the phpmyadmin page, click on Databases tab. |
| 03:51 | In the Create database section, type the Database name as frontacc and click on Create. |
| 04:00 | This will create a database named frontacc. |
| 04:06 | Now we will see the installation procedure for FrontAccounting. |
| 04:11 | Open a new web browser tab and type the url [1] |
| 04:26 | and press Enter. |
| 04:29 | Here we can see Download link for FrontAccounting. |
| 04:34 | Click on Download. |
| 04:37 | Immediately, a small dialog box will open. |
| 04:41 | Click on Save file option and then on Ok option. |
| 04:47 | The latest version of FrontAccounting will begin downloading. |
| 04:52 | Once the download completes, open the folder where you have downloaded the file. |
| 04:59 | Here is the file which we have downloaded. |
| 05:03 | Right-click and select Extract All and then on Extract. |
| 05:10 | Open the extracted folder. |
| 05:13 | Inside that, you can see a folder named frontaccounting. |
| 05:18 | Rename it as account. |
| 05:22 | Next, we have to paste the folder account in the Web Server's root directory. |
| 05:28 | The path for the root directory is “c:\xampp\htdocs”. |
| 05:36 | Right-click on the folder account and select Copy. |
| 05:40 | Go to My Computer, C drive, xampp and htdocs. |
| 05:47 | Then right-click and select Paste. |
| 05:50 | Now the account folder is pasted in the Web Server's root folder. |
| 05:55 | Let us start to configure FrontAccounting. |
| 05:58 | Open the web browser and type: |
| 06:01 | localhost/account |
| 06:04 | or localhost:8080/account, |
| 06:09 | depending on your port configuration. |
| 06:12 | Then press Enter. |
| 06:14 | We can see the FrontAccounting webpage. |
| 06:17 | It also says Step 1: System Diagnostics. |
| 06:22 | This means that we have successfully installed the software packages with the Comments as OK. |
| 06:30 | Click on the Continue button. |
| 06:33 | In the “Database server settings” page, enter the following details- |
| 06:38 | Server host as localhost, |
| 06:42 | Database Name as frontacc, |
| 06:46 | Database user as root. |
| 06:49 | Leave the password as blank since XAMPP in Windows doesn’t have any password, by default. |
| 06:57 | Then click on the Continue button. |
| 07:00 | In the “Company Settings” page, enter the following: |
| 07:04 | I will type the CompanyName as ST Co. Pvt. Ltd. |
| 07:10 | Admin Password as spoken. |
| 07:13 | You can give any password of your choice. |
| 07:17 | Re-enter the password. |
| 07:19 | Remember this password. |
| 07:21 | This is the login-password that you need to use to login each time. |
| 07:25 | We can see two options for the “Charts of Accounts”. |
| 07:30 | I will select “Standard new company American COA”. |
| 07:35 | Select the Default Language as English. |
| 07:38 | Click on Install. |
| 07:40 | The installation will take some time to complete. |
| 07:44 | Once completed, we will see a new window. |
| 07:48 | It says the Frontaccounting ERP has been installed successfully. |
| 07:53 | Click on “Click here to start”. |
| 07:56 | This will take us to the FrontAccounting login page. |
| 08:00 | Login with the following details- |
| 08:02 | Username as admin, |
| 08:05 | password as spoken |
| 08:08 | and then click on Login. |
| 08:11 | Now, we are in FrontAccounting admin panel. |
| 08:14 | This brings us to the end of this tutorial. |
| 08:17 | Let us summarize. |
| 08:20 | In this tutorial, we have learnt to: |
| 08:23 | install XAMPP, |
| 08:25 | create a database for FrontAccounting, |
| 08:28 | and install FrontAccounting in Windows. |
| 08:31 | The video at the given link summarizes the Spoken Tutorial project. |
| 08:36 | Please download and watch it. |
| 08:39 | We conduct workshops and give certificates to those who pass our online tests. |
| 08:45 | For more details, please write to us. |
| 08:48 | Spoken Tutorial project is funded by NMEICT, MHRD, Government of India. |
| 08:55 | More information on this mission is available at this link. |
| 09:00 | This script has been contributed by Praveen.
And, this is Nirmala Venkat from IIT Bombay, signing off. |
| 09:06 | Thanks for watching. |
