FrontAccounting-2.4.7/C2/Installation-of-FrontAccounting-on-Windows-OS/English
| 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 -
|
| Show Slide 3:
System Requirements OS, Web Server and Versions |
To record this tutorial, I‘m using:
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
|
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.
|
| 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
|
| 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
|
| 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. |
