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 - 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.
Show Slide 4: FA is a server based Accounting System. Use XAMPP to setup the web server on our machine.	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. 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 dialog 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 dialog 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 6: 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's start downloading FrontAccounting.
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 7: 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 8: 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 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:9a 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:9b Rules and Naming Conventions	Also, as per naming convention, username should not have any spaces in between.
Previous slide continues	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	Here I will 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 10: 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 11: About Spoken Tutorial project	The video at the following link summarises the Spoken Tutorial project. Please download and watch it.
Slide 12: About Workshop	The Spoken Tutorial Project team conducts workshops and gives certificates. For more details, please write to us.
Slide 13: 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 14: 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 15: 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