FrontAccounting-2.4.7/C2/Installation-of-FrontAccounting-on-Windows-OS/English-timed

From Script | Spoken-Tutorial
Revision as of 16:01, 22 January 2020 by PoojaMoolya (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search
Time Narration
00:01 Welcome to the spoken tutorial on FrontAccounting installation on Windows OS.
00:07 In this tutorial, we will learn to Install XAMPP
00:12 Download FrontAccounting software
00:15 Do the database setup and

Install FrontAccounting in Windows OS

00:21 To record this tutorial, I‘m using:

Windows OS version 10

00:26 Apache, MySQL and PHP obtained through XAMPP 5.5.19
00:32 FrontAccounting version 2.4.7
00:36 Firefox web browser and A working Internet connection.
00:41 You can use any web browser of your choice.
00:44 FrontAccounting is a server based Accounting System.

So we will be using XAMPP to setup the web server on our machine.

00:52 Open a web browser.

In the address bar, type this URL and press Enter.

00:59 This will take us to the XAMPP download page.
01:03 Here XAMPP is available to download for all operating systems.
01:08 The latest version of XAMPP can be downloaded by clicking this green button.
01:13 However, depending upon your software requirement, you may need a different version of XAMPP.
01:19 In my case I need XAMPP version 5.5.19.
01:24 Click on XAMPP Windows link.
01:28 The redirected page will display all the XAMPP versions till date.
01:32 For this installation, I will select the XAMPP version 5.5.19
01:39 Click on the link to download.
01:43 Now, click on Save file button.

The exe file will get downloaded on our machine.

01:51 Open the folder where you have downloaded the file.
01:55 Double-click on the file to start the installation.
01:59 A User Account Control dialog box opens up.

Click on the Yes button.

02:06 If you have installed any antivirus software on your machine, you may get another popup window.

Click on the Yes button.

02:15 In the next window, click on the OK button to ignore the warning message.
02:21 Now the Setup wizard dialog box opens.
02:25 Click on the Next button whenever prompted and follow the installation steps as shown.
02:31 Uncheck the Learn more about Bitnami for XAMPP check box.

Then continue by clicking on the Next button.

02:40 Once the installation is done, uncheck the Do you want to start the Control Panel now? checkbox.
02:47 Lastly, click on Finish button.
02:51 Now we should check whether XAMPP is successfully installed on our machine or not.
02:56 Click on the Windows search bar at the bottom left of the screen and type xampp.
03:02 We can see the XAMPP Control Panel in the search list.
03:06 Right-click on the XAMPP Control Panel and select Run as administrator.
03:12 In the XAMPP Control Panel, make sure that Apache and MySQL services are running.
03:18 If not, then start these services by clicking on the START button of the respective services.
03:24 You may get some error messages like:

Apache shutdown unexpectedly

03:30 Port 80 in use for Apache Server'
03:34 Unable to connect to any of the specified MySQL hosts for MySQL database.”
03:41 This is because the default port allotted to Apache and MySQL are taken by another software.
03:47 Default port number for Apache is 80 and for MySQL is 3306.
03:55 To change these ports, refer to the Additional Reading Material of this tutorial.
04:00 And allot the proper port numbers before proceeding further.

For eg: 8080

04:07 Now, open Firefox web browser.
04:11 In the address bar, type localhost and press Enter.

We should be able to see the XAMPP screen.

04:19 If prompted for language selection, select English.

We are now in the XAMPP homepage.

04:27 Let's start downloading FrontAccounting.
04:30 Open another tab in the web browser and go to this URL.
04:37 Click on frontaccounting-2.4.7.zip
04:42 Immediately, the download begins.

Click on the Save File button and then click on OK button.

04:49 Once the download completes, open the folder where you have downloaded the file.
04:54 Here is the file which I have downloaded.
04:57 Right-click on the file and select Extract Here.
05:01 Once extracted, I will rename the extracted FrontAccounting folder as account.
05:07 Renaming of the folder name is optional.

However, it helps to identify multiple instances of FrontAccounting installed on a single machine.

05:17 Now we have to move the folder account into the web server's root directory.
05:22 The path for the root directory is “c:\xampp\htdocs
05:29 Right-click on the folder account and select Copy.
05:33 In the left pane, click on “This PC” which is also called as “My Computer”.
05:39 Then double click on “Local Disk (C:)” that is C drive

And go to xampp and htdocs.

05:47 Inside htdocs, right-click on an empty space and select Paste.
05:53 We have successfully installed the XAMPP server.
05:57 Make sure that the FrontAccounting installer is in the web server’s root directory.
06:02 Next we need to create a database for FrontAccounting to proceed further.
06:07 We will do this in phpmyadmin, which is the graphical user interface for MySQL.

It comes along with the XAMPP installation.

06:17 Let us go back to the XAMPP Page in the web browser.
06:21 On the XAMPP page, in the menu at the left, click on phpMyadmin.
06:27 Click on Users in the top menu and then click on Add User.
06:33 In the new window that opens enter a User name of your choice.

I will type frontacc as my User name.

06:42 From the Host drop-down list, select Local.
06:46 Enter a password of your choice in the Password text-box.
06:50 I will type admin123 as my password.
06:54 Type the same password in the Re-type textbox.
06:58 Do not click on Generate Password prompt for now.
07:02 Under Database for user account, we can see the option-

Create database with the same name and grant all privileges.

07:10 We will check that option and scroll down.
07:14 Then click the Go button at the bottom right of the page.
07:18 We see a message “You have added a new user”
07:22 It means a new database with the name frontacc and with user frontacc has been created.
07:29 This user name and password is only for Database login purpose.
07:34 Make a note of the user name, password and database names.
07:38 These will be required later to complete the FrontAccounting installation.
07:43 Database name and username need not be the same.

To have different names, create the database first and then create a user for that database.

07:53 Also, as per naming convention, username should not have any spaces in between.
07:59 We now have XAMPP running and our database is ready.
08:02 We are now ready to proceed installing Front Accounting.
08:07 In the web browser open a new tab.

In the address bar type localhost/account and press Enter.

08:17 We can see the FrontAccounting webpage showing

Step 1: System Diagnostics

08:22 Make sure that Select install wizard language is English.
08:26 Scroll down and click on Continue button at the bottom of the page.
08:31 The title of the next web page is Step 2: Database Server Settings.
08:37 Here I will keep the Server Host as localhost

I’ll keep the Server Port as empty.

08:44 If you have changed the MySQL default port number other than 3306, then enter that port number here.
08:52 Enter the following details which we have created earlier-

database Name as frontacc

09:00 database user as frontacc
09:03 and database password as admin123
09:07 Ignore the rest of options and click on Continue button at the bottom.
09:12 Next, you will need to put the details of your own company.

I will demonstrate how to do so.

09:19 In Company Name field, I will type ST Company Pvt Ltd.
09:24 I will keep the Admin Login as admin.

Then I will type the Admin Password as spoken.

09:31 You can give any password of your choice.
09:34 Re-enter the same password.

Remember this is the login password.

09:40 Next we see two options for the Charts of Accounts.
09:44 I will select Standard new company American COA.
09:49 Select the Default Language as English.
09:52 Click on the Install button.
09:55 We can see the final message on our screen, FrontAccounting ERP has been installed successfully.

Which confirms that our installation is successful.

10:06 Click on the link, Click here to start to log-in to the FrontAccounting interface.
10:12 In the log-in screen, enter the following details:

User name as admin

Password as spoken

10:22 Company as ST Company Pvt. Ltd.

And click on the Login button.

10:28 We are brought to the Front Accounting Administration page.
10:32 We can see various tabs on this page.

We will learn how to use many of these later in this series.

10:39 This brings us to the end of this tutorial

Let us summarize.

10:44 In this tutorial, we have learnt to

Download and install XAMPP

10:50 Download and install FrontAccounting software
10:53 Do the database setup in Windows 10 OS
10:57 The video at the following link summarises the Spoken Tutorial project.

Please download and watch it.

11:05 The Spoken Tutorial Project team conducts workshops and gives certificates.

For more details, please write to us.

11:13 Do you have questions in THIS Spoken Tutorial?

Please visit this site.

11:18 Choose the minute and second where you have the question

Explain your question briefly . Someone from our team will answer them

11:27 The Spoken Tutorial forum is for specific questions on this tutorial
11:32 Please do not post unrelated and general questions on them

This will help reduce the clutter

11:39 With less clutter, we can use these discussion as instructional material
11:44 Spoken Tutorial Project is funded by MHRD, Government of India.
11:49 The script has been contributed by Spoken Tutorial team.

This is Pratik Kamble from IIT Bombay signing off.

Thank you for joining.

Contributors and Content Editors

PoojaMoolya