Difference between revisions of "FrontAccounting/C2/Installation-of-FrontAccounting-on-Windows-OS/English-timed"

From Script | Spoken-Tutorial
Jump to: navigation, search
Line 5: Line 5:
 
|-
 
|-
 
|  00:01
 
|  00:01
|  Welcome to the spoken tutorial on '''FrontAccounting''' installation on Windows Operating''' '''System'''.
+
|  Welcome to the '''spoken tutorial''' on '''FrontAccounting''' installation on '''Windows Operating System'''.
  
 
|-
 
|-
 
| 00:08
 
| 00:08
| In this tutorial we will learn to:-
+
| In this tutorial, we will learn to:
  
 
|-
 
|-
 
| 00:10
 
| 00:10
| Download '''FrontAccounting''' software.
+
| download '''FrontAccounting''' software,
  
 
|-
 
|-
 
| 00:14
 
| 00:14
| Create a database for '''FrontAccounting'''.
+
| create a database for '''FrontAccounting''',
  
 
|-
 
|-
 
| 00:18
 
| 00:18
| And install '''FrontAccounting''' software in '''Windows''' OS.
+
| and install '''FrontAccounting''' software in '''Windows''' OS.
  
 
|-
 
|-
 
| 00:24
 
| 00:24
| To record this tutorial I'm using-
+
| To record this tutorial, I'm using-
  
 
|-
 
|-
 
| 00:27
 
| 00:27
| '''Windows 8 OS'''
+
| '''Windows 8 OS''',
'''XAMPP 5.6.24 '''
+
'''XAMPP 5.6.24 ''',
'''FrontAccounting 2.4.1'''
+
'''FrontAccounting 2.4.1''',
'''Firefox '''web browser and a working Internet connection
+
'''Firefox '''web browser and a working Internet connection.
  
 
|-
 
|-
Line 40: Line 40:
 
|-
 
|-
 
| 00:44
 
| 00:44
| To run '''FrontAccounting,''' we require a '''web server,''' '''php''' and a '''database''' on our machine.
+
| To run '''FrontAccounting,''' we require a '''web server, php''' and a '''database''' on our machine.
  
 
|-
 
|-
Line 52: Line 52:
 
|-
 
|-
 
| 01:05
 
| 01:05
|  To install '''XAMPP ''' package
+
|  To install '''XAMPP ''' package,
  
 
|-
 
|-
 
| 01:07
 
| 01:07
| Refer to the '''XAMPP''' installation tutorial in the '''PHP & MySQL''' series on this website.
+
| refer to the '''XAMPP installation''' tutorial in the '''PHP & MySQL''' series, on this website.
  
 
|-
 
|-
Line 76: Line 76:
 
|-
 
|-
 
| 01:37
 
| 01:37
| In the '''XAMPP Control Panel''', make sure that '''Apache''' & '''MySQL ''' services are running.
+
| In the '''XAMPP Control Panel''', make sure that '''Apache''' & '''MySQL ''' '''service'''s are running.
  
 
|-
 
|-
Line 84: Line 84:
 
|-
 
|-
 
| 01:52
 
| 01:52
|  To stop the services, we have to click on '''STOP button'''.
+
|  To stop the services, we have to click on '''STOP''' button.
  
 
|-
 
|-
 
| 01:57
 
| 01:57
|  You may get some error messages like:
+
|  You may get some '''error''' messages like:
  
 
|-
 
|-
 
| 02:00
 
| 02:00
| '''“Apache shutdown unexpectedly”'''
+
| '''“Apache shutdown unexpectedly”''' or  
or  
+
  
 
|-
 
|-
 
| 02:04
 
| 02:04
| '''“Port 80 in use for Apache Server”'''
+
| '''“Port 80 in use for Apache Server”''' or  
or  
+
  
 
|-
 
|-
Line 114: Line 112:
 
|-
 
|-
 
| 02:32
 
| 02:32
|  To change these '''ports''', refer to the '''XAMPP''' Installation tutorial in the '''PHP & MySQL ''' series, on this website.
+
|  To change these '''ports''', refer to the '''XAMPP Installation''' tutorial in the '''PHP & MySQL ''' series, on this website.
  
 
|-
 
|-
Line 126: Line 124:
 
|-
 
|-
 
| 02:48
 
| 02:48
| To do so, open the web browser and type '''localhost''' in the url.
+
| To do so, open the '''web browser''' and type '''localhost''' in the '''url'''.
  
 
|-
 
|-
 
| 02:55
 
| 02:55
| If you have changed the port number, then type '''localhost:8080'''
+
| If you have changed the '''port''' number, then type '''localhost:8080'''.
  
 
|-
 
|-
Line 150: Line 148:
 
|-
 
|-
 
|  03:18
 
|  03:18
|  To open '''phpMyAdmin''', on the web browser address bar, type '''localhost/phpmyadmin '''
+
|  To open '''phpMyAdmin''', on the web browser '''address bar''', type: '''localhost/phpmyadmin'''.
  
 
|-
 
|-
Line 158: Line 156:
 
|-
 
|-
 
|  03:35
 
|  03:35
| And press '''Enter'''.  
+
| and press '''Enter'''.  
  
 
|-
 
|-
Line 186: Line 184:
 
|-
 
|-
 
| 04:11
 
| 04:11
| Open a new web browser tab and type the url [https://sourceforge.net/projects/frontaccounting]
+
| Open a new web browser tab and type the '''url''' [https://sourceforge.net/projects/frontaccounting]
  
 
|-
 
|-
Line 222: Line 220:
 
|-
 
|-
 
|  05:03
 
|  05:03
| Right-click and select '''Extract''' '''All''' and then on '''Extract.'''
+
| Right-click and select '''Extract All''' and then on '''Extract.'''
  
 
|-
 
|-
Line 230: Line 228:
 
|-
 
|-
 
| 05:13
 
| 05:13
|  Inside that you can see a folder named '''frontaccounting'''.
+
|  Inside that, you can see a folder named '''frontaccounting'''.
  
 
|-
 
|-
Line 238: Line 236:
 
|-
 
|-
 
| 05:22
 
| 05:22
| Next we have to paste the folder account in the Web Server's root directory.
+
| Next, we have to paste the folder '''account''' in the '''Web Server''''s '''root''' directory.
  
 
|-
 
|-
 
| 05:28
 
| 05:28
| The path for the root directory is “'''c:\xampp\htdocs'''”
+
| The path for the '''root''' directory is “'''c:\xampp\htdocs'''”.
  
 
|-
 
|-
Line 266: Line 264:
 
|-
 
|-
 
| 05:58
 
| 05:58
|  Open the web browser and type  
+
|  Open the web browser and type:
  
 
|-
 
|-
Line 274: Line 272:
 
|-
 
|-
 
| 06:04
 
| 06:04
| or '''localhost:8080/account'''
+
| or '''localhost:8080/account''',
  
 
|-
 
|-
 
| 06:09
 
| 06:09
| depending on your port configuration.
+
| depending on your '''port''' configuration.
  
 
|-
 
|-
Line 302: Line 300:
 
|-
 
|-
 
| 06:33
 
| 06:33
| In the “'''Database server settings'''” page enter the following details-
+
| In the “'''Database server settings'''” page, enter the following details-
  
 
|-
 
|-
 
| 06:38
 
| 06:38
| '''Server host''' as '''localhost'''
+
| '''Server host''' as '''localhost''',
  
 
|-
 
|-
 
| 06:42
 
| 06:42
| '''Database Name''' as '''frontacc'''.
+
| '''Database Name''' as '''frontacc''',
  
 
|-
 
|-
 
| 06:46
 
| 06:46
| '''Database user''' as '''root'''
+
| '''Database user''' as '''root'''.
  
 
|-
 
|-
Line 326: Line 324:
 
|-
 
|-
 
| 07:00
 
| 07:00
| In the “'''Company Settings'''” page enter the following:
+
| In the “'''Company Settings'''” page, enter the following:
  
 
|-
 
|-
Line 350: Line 348:
 
|-
 
|-
 
| 07:21
 
| 07:21
| This is the login password that you need to use to login each time.
+
| This is the login-password that you need to use to login each time.
  
 
|-
 
|-
Line 374: Line 372:
 
|-
 
|-
 
| 07:44
 
| 07:44
| Once completed, we will see a new window.  
+
| Once completed, we will see a new '''window'''.  
  
 
|-
 
|-
Line 382: Line 380:
 
|-
 
|-
 
|  07:53
 
|  07:53
|  Click on “'''Click here to start'''”
+
|  Click on “'''Click here to start'''”.
  
 
|-
 
|-
Line 394: Line 392:
 
|-
 
|-
 
| 08:02
 
| 08:02
| '''Username''' as '''admin'''
+
| '''Username''' as '''admin''',
  
 
|-
 
|-
Line 406: Line 404:
 
|-
 
|-
 
| 08:11
 
| 08:11
|  Now we are in '''FrontAccounting''' admin panel.
+
|  Now, we are in '''FrontAccounting''' admin panel.
  
 
|-
 
|-
Line 418: Line 416:
 
|-
 
|-
 
| 08:20
 
| 08:20
| In this tutorial, we have learnt to
+
| In this tutorial, we have learnt to:
  
 
|-
 
|-
 
| 08:23
 
| 08:23
| Install XAMPP.
+
| install '''XAMPP''',
  
 
|-
 
|-
 
| 08:25
 
| 08:25
| Create a database for FrontAccounting.
+
| create a database for FrontAccounting,
  
 
|-
 
|-
 
| 08:28
 
| 08:28
| And install FrontAccounting in Windows.
+
| and install FrontAccounting in '''Windows'''.
  
 
|-
 
|-
 
| 08:31
 
| 08:31
|  The video at the given link summarizes the Spoken Tutorial project.  
+
|  The video at the given link summarizes the '''Spoken Tutorial''' project.  
  
 
|-
 
|-
Line 450: Line 448:
 
|-
 
|-
 
| 08:48
 
| 08:48
|  Spoken Tutorial project is funded by NMEICT, MHRD, Government of India.  
+
|  Spoken Tutorial project is funded by '''NMEICT, MHRD,''' Government of India.  
  
 
|-
 
|-
Line 459: Line 457:
 
| 09:00
 
| 09:00
 
| This script has been contributed by Praveen.  
 
| This script has been contributed by Praveen.  
And this is Nirmala Venkat from IIT Bombay, signing off.  
+
And, this is Nirmala Venkat from IIT Bombay, signing off.  
  
 
|-
 
|-

Revision as of 17:20, 14 June 2018

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.

Contributors and Content Editors

Jyotisolanki, Ranjana, Sandhya.np14