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

From Script | Spoken-Tutorial
Revision as of 15:06, 31 October 2019 by Nirmala Venkat (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search
Visual Cue Narration
Slide 1: Title slide Welcome to the spoken tutorial on FrontAccounting installation on Windows OS.
Show Slide 2:

Learning Objectives:

In this tutorial, we will learn to -
  • Install XAMPP
  • Download FrontAccounting software
  • Do the database setup and
  • Install FrontAccounting in Windows OS
Show Slide 3:

System Requirements OS, Web Server and Versions

To record this tutorial, I‘m using:
  • Windows OS version 10
  • Apache, MySQL and PHP obtained through XAMPP 5.5.19
  • FrontAccounting version 2.4.7
  • Firefox web browser and
  • A working Internet connection.

You can use any web browser of your choice.

Only Narration FrontAccounting is a server based Accounting System.

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

[Firefox] Type: https://sourceforge.net/projects/xampp/files/ Open a web browser.

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

[Firefox]Show XAMMP for all OS This will take us to the XAMPP download page.

Here XAMPP is available to download for all operating systems.

[Firefox] Point to XAMPP download green button. The latest version of XAMPP can be downloaded by clicking this green button.
Only narration However, depending upon your software requirement, you may need a different version of XAMPP.

In my case I need XAMPP version 5.5.19.

Click on XAMPP Windows link.

The redirected page will display all the XAMPP versions till date.

[Firefox] Highlight 5.5.19 For this installation, I will select the XAMPP version 5.5.19
[Firefox] Point to xampp-win32-5.5.19-0-VC11-installer.exe Click on the link to download.
Select save radio button Now, click on Save file button and then click on OK button.

The exe file will get downloaded on our machine.

Point to xampp-win32-5.5.19-0-VC11-installer.exe in the Downloads folder Open the folder where you have downloaded the file.

Double-click on the file to start the installation.

Point to User Account Control A User Account Control dialog box opens up.

Click on the Yes button.

Point to Question dialogue box option. Click on the Yes option If you have installed any antivirus software on your machine, you may get another popup window.

Click on the Yes button.

Warning message dialogue box opens In the next window, click on the OK button to ignore the warning message.
Setup Box opens. Now the Setup wizard dialog box opens.

Click on the Next button whenever prompted and follow the installation steps as shown.

Uncheck Learn more about Bitnami for XAMPP check box >> Click on Next. Uncheck the Learn more about Bitnami for XAMPP check box.

Then continue by clicking on the Next button.

Uncheck Launch XAMPP check box >> Click on Finish. Once the installation is done, uncheck the Do you want to start the Control Panel now? checkbox.

Lastly, click on Finish button.

Only Narration Now we should check whether XAMPP is successfully installed on our machine or not.
Point to the Windows Search bar at the bottom left >> type XAMPP Click on the Windows search bar at the bottom left of the screen and type xampp.
Point to XAMPP Control Panel We can see the XAMPP Control Panel in the search list.
RIght Click -> Run as administrator Right-click on the XAMPP Control Panel and select Run as administrator.
Point to Apache & MySQL In the XAMPP Control Panel, make sure that Apache and MySQL services are running.
Point to START button If not, then start these services by clicking on the START button of the respective services.
Slide 5(a): Error messages You may get some error messages like:

Apache shutdown unexpectedly” or

Port 80 in use for Apache Server'” or

Unable to connect to any of the specified MySQL hosts for MySQL database.”

This is because the default port allotted to Apache and MySQL are taken by another software.

slide 5(b): Default Port Default port number for Apache is 80 and for MySQL is 3306.
Slide 5:

Change in Ports

To change these ports, refer to the Additional Reading Material of this tutorial.

And allot the proper port numbers before proceeding further.

For eg: 8080

Open Firefox >> In the address bar type localhost >> press Enter. Now, open Firefox web browser.

In the address bar, type localhost and press Enter.

We should be able to see the XAMPP screen.

Select English if prompted. If prompted for language selection, select English.

We are now in the XAMPP homepage.

Only Narration Let us download Front Accounting software.
Open browser>> type

https://sourceforge.net/projects/frontaccounting/files/FrontAccounting%202.4/2.4.7/

click on frontaccounting-2.4.7.zip

Open another tab in the web browser and go to this URL.

Click on frontaccounting-2.4.7.zip

Download window Immediately, the download begins.

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

Open Downloads folder Once the download completes, open the folder where you have downloaded the file.
Point to the zip file Here is the file which I have downloaded.
Right-click >> select Extract Here Right-click on the file and select Extract Here.
Open folder >> rename the folder as account Once extracted, I will rename the extracted FrontAccounting folder as account.
Slide:6

Folder Renaming

Renaming of the folder name is optional

It helps to identify multiple instances of FrontAccounting installed on a single machine.

Renaming of the folder name is optional, however.

It helps to identify multiple instances of FrontAccounting installed on a single machine.

Only narration Now we have to move the folder account into the web server's root directory.

The path for the root directory is “c:\xampp\htdocs

Right-click>> Copy Right-click on the folder account and select Copy.
This PC -> My Computer -> XAMPP -> htdocs In the left pane, click on “This PC” which is also called as “My Computer”.

Then double click on “Local Disk (C:)” that is C drive

and go to xampp and htdocs.

Right-click>> Paste Inside htdocs, right-click on an empty space and select Paste.
Point to account folder inside htdocs We have successfully installed the XAMPP server.

Make sure that the FrontAccounting installer is in the web server’s root directory.

Slide:7


Adding admin user and Creating database

Next we need to create a database for FrontAccounting to proceed further.

We will do this in phpmyadmin, which is the graphical user interface for MySQL.

It comes along with the XAMPP installation.

Creating Database:

Click on phpmyadmin

Let us go back to the XAMPP Page in the web browser.

On the XAMPP page, in the menu at the left, click on phpMyadmin.

Click on Users accounts >> click on Add User account Click on Users in the top menu and then click on Add User.
Type frontacc In the new window that opens enter a user name of your choice.

I will type frontacc as my user name.

Select Local from the dropdown From the Host drop-down list, select Local.
In Password textbox >> Type admin123 Enter a password of your choice in the Password text-box.

I will type admin123 as my password.

Re-type admin123 Type the same password in the Re-type textbox.
Point to the option Do not click on Generate Password prompt for now.
Point to Create a database with the same name and grant all privileges Under Database for user account, we can see the option-

Create database with the same name and grant all privileges.

Click on it >> Click on the Go button We will check that option and scroll down.

Then click the Go button at the bottom right of the page.

Point to the frontacc database in the side pane We see a message “You have added a new user”

It means a new database with the name frontacc and with a user frontacc has been created.

This user name and password is only for Database login purpose.

Textbox on screen Make a note of the user name, password and database names.

These will be required later to complete the FrontAccounting installation.

Show Slide:8a

Rules and Naming Conventions

* 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.
Show Slide:8b

Rules and Naming Conventions

* Also, as per naming convention, username should not have any spaces in between.
Point We now have XAMPP running and our database is ready.

We are now ready to proceed installing Front Accounting.

Go to the web browser >> URL >> localhost/account In the web browser open a new tab.

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

Point We can see the FrontAccounting webpage showing

Step 1: System Diagnostics

Make sure that Select install wizard language is English.

Scroll down Scroll down and click on Continue button at the bottom of the page.
Step 2: Database Server Settings The title of the next web page is

Step 2: Database Server Settings.

Type:

database user as frontacc

database password as admin123

database Name as frontacc

Keep the server host as localhost

Here, I’ll keep the server port as empty.

If you have changed the MySQL default port number other than 3306, then enter that port number here.

Enter the following details which we have created earlier-

database Name as frontacc

database user as frontacc

database password as admin123

Click>>>Continue Button Ignore the rest of options and click on Continue button at the bottom.
Step 5: Company Settings. Next, you will need to put the details of your own company.

I will demonstrate how to do so.

Type in Company Name >> ST Company Pvt Ltd. In Company Name field, I will type ST Company Pvt Ltd.
Point to the Admin password I will keep the Admin Login as admin.

Then I will type the Admin password as spoken. You can give any password of your choice.

Point to the Re-enter password Re-enter the same password.

Remember this is the login password.

Click on the dropdown box >> select Charts of Accounts Next we see two options for the Charts of Accounts.

I will select Standard new company American COA.

Point to the Select Default Language>> English Select the Default Language as English.
Click on the Continue button Click on the Install button.
FrontAccounting page open

Point towards message

We can see the final message on our screen, FrontAccounting ERP has been installed successfully.

Which confirms that our installation is successful.

Click on Click here to start Click on the link, Click here to start to log-in to the FrontAccounting interface.
Login to FrontAccounting

User name as admin

Password as spoken

Company as ST Company Pvt. Ltd.

In the log-in screen, enter the following details:

User name as admin

Password as spoken

Company as ST Company Pvt. Ltd.

And click on the Login button.

Point to the various tabs We are brought to the Front Accounting Administration page.

We can see various tabs on this page.

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

Only narration This brings us to the end of this tutorial

Let us summarize.

Slide 6:

Summary

In this tutorial, we have learnt to
  • Download and install XAMPP
  • Download and install FrontAccounting software
  • Do the database setup in Windows 10 OS
Slide 7:

About Spoken Tutorial project

The video at the following link summarises the Spoken Tutorial project.

Please download and watch it.

Slide 8:

About Workshop

The Spoken Tutorial Project team conducts workshops and gives certificates.

For more details, please write to us.

Slide 9:

Forum for specific questions:

Do you have questions in THIS Spoken Tutorial?

Please visit this site. Choose the minute and second where you have the question Explain your question briefly Someone from our team will answer them

Slide 10:

Forum for specific questions:

* The Spoken Tutorial forum is for specific questions on this tutorial
  • Please do not post unrelated and general questions on them
  • This will help reduce the clutter
  • With less clutter, we can use these discussion as instructional material
Slide:

Acknowledgement

Spoken Tutorial Project is funded by NMEICT, MHRD, Government of India.

More information on this mission is available at this link.

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

Nancyvarkey, Nirmala Venkat, PoojaMoolya