IdeaWazaWiki - User contributions [en]

Archive:Eastern Software System

2009-05-13T11:13:23Z

59.144.163.207:

{{Infobox Company
| company_name = Eastern Software Systems
| company_type = [[Private]]
| foundation = 1990
| location = [[New Delhi, India]]
| area_served = 25 different countries
| key_people = [[Anil Bakht]] ([[Managing Director (official)|Managing Director]]) ([[Sanjay Agarwala]]) ([[CEO]]) 
| num_employees = 300 (2009)
| industry = [[IT]]
| products = [[ebizframeENTERPRISE and ebizframeCORE]]
| homepage = [http://www.essindia.com www.essindia.com]
}}

'''Introduction'''

Ebizframe is an Enterprise Resource Planning ([[ERP]]) software created by an Indian company [http://www.essindia.com Eastern Software Sytems Pvt. Ltd.][ESS] ESS was incorporated in 1990 as a software services company in Delhi. ESS launched its ERP product Makess(1), (2) – subsequently redesigned and launched as ebizframe in year 1999, (3) with possibility of extending it to customers and vendors. Makess on the Net was the first ERP in India to be offered on rental – what is now called SaaS model, in year 2000. (4) (5)

[http://www.essindia.com ESS] received its first venture funding in 1998 from FMO, [[Intel]] and [[Citi Bank]]. (6). It is assessed at [[CMM]] level5 and follows [[ISO]] standards 2000:1901. (7)

ESS was the first Indian company to get into highly competitive branded ERP market and it has been mentioned as one of the successful Indian software products by various independent agencies. (8), (9). Its focus was Indian SME market. ESS moved into international arena in the year 2002-03 through business alliances and is present in 26 countries currently and is a leading player in ERP space in these countries.

Ebizframe has been mentioned as among the top 6 ERP vendors in India for two years in running by Frost and Sullivan. (10) It is one of the rare Indian ERP companies to have grown consistently since its birth and recorded profits unfailingly since 2002-03

==History of ebizframe ERP==

*The precursor to ebizframe, called Makess was launched in 1998 in India on client-server [[technology]] on [[Oracle]] platform. (11)

*First customer for Makess was Sterling Tools Ltd. in Faridabad (12) and is now using its latest version of ebizframe ERP.

*ESS introduced first Indian WAP enabled ERP. (13)

*A generational jump was taken in year 2000 by launching a web based version of Makess, named “Makess on Net” (14), (15) in collaboration with Oracle and Sun Systems. (16). It was an ahead of the times SaaS (‘pay as you use’) model and it attracted a good number of customers and appreciated well by critics and industry people alike for its visionary use of technology and future road map for users. (17), (18)

• The new version on a new technology platform of Oracle with [[e-commerce]] and extranet collaboration possibilities was launched in year 2000 and called ebizframe.(19), (20)

*Ebizframe upgrades have been released regularly and version 7.4 on Oracle 11g is slated to be released in May 2009. (21)

*Ebizframe came up with the concept of ‘bolt-ons’ i.e. functional upgrade granules that are released every quarter and can be added at a customer site without much pain. This concept takes care of major disruptions in customer usage when a new version is sought to be upgraded irrespective of what functionality a customer may be interested in. Now some other global ERPs are also finding merit in this approach.

*During its last 10 years of existence, ebizframe has come up with many flavours for different industry verticals. Major segments apart from engineering, chemicals/pharma ( 22), (23),(24),(25), (26), (27) being retail (28), dairy, food processing (29), (30) agro-industries like Sugar, Breweries and Distilleries, Paper & Packaging (31), Jewelry (32), Retail (33)Textiles & Apparel (34) etc. etc.

*Ebizframe is running currently in 26 countries in different industry segments. (35),(36)

*Ebizframe is also being offered in four more international languages. (37), (38)

*Ebizframe has come up with web portal for customers which can sit on the top of the ERP, tightly integrated with the ERP that provides access to employees, vendors and buyers, and also facilitates its extension to e-commerce. (hyperlink to portal screenshot).

==Technology==

*Ebizframe is based on [[Oracle]] technology, middle-tier being provided by [[Java]] technology. It is currently on Oracle 11g platform and is fully web enabled.

*Interestingly it does not require a middle ware like [[Citrix Server]] for running on browser.

*It can run on [[Windows]], Sun, Solaris, [[Unix]] and [[Linux]] platform. Certified for [[Redhat Linux]] (39), (40).

*ESS has recently introduced state of art Management Dash Board with latest web based light technologies like [[PHP]] and [[Flex]]. (41)

*ESS has recently introduced [[excel]] based Reporting capabilities in ebizframe, giving users virtually unlimited capabilities to generate their own reports and graphic based [[MIS]], Dash board etc.

*Ebizframe can have integrated interface within its menu for [[Oracle Discoverer]].

*Can run on [[LAN]]LAN, [[WAN]], [[Internet]] – in-house hosting as well as [[ISP]] hosting

==Implementation possibilities==
*ERP web-hosted on static IP address in-house with global access

*Hosting by ISP – with server hosted remotely at ISP data centre. It has tied up with Datacentres like Netmagic, India for this purpose.

*SaaS model and MSP model

*Hybrid connectivity through [[VSAT]], [[Broaband]], leased and [[ISDN]] lines. ESS has tied up with many leading service providers to provide customers rich options.

*Ready to use low cost standard implementation with core functions and fast implementation - ebizframeCORE

==Implementation methodology==

ESS implements its [[ERP]] through its own project teams and doesn’t depend on third party consultants. This is much different methodology but highly successful resulting in very high success rate. ESS believes in incremental ERP implementation. It is more successful and leads to least disruption in regular business of the customer. This model is being slowly adopted by other ERP players in the industry.

==Product features==

*Business functions – [[CRM]], [[Sales]], [[Procurement]], Manufacturing, Licensed (sub-contracted mfg.) Finance, Asset maintenance, [[Statutory Compliance]], [[Customer Service]], Administration

Modules –

*Sales – pre-sales activities ([[SFA]]), Sales & Distribution, [[Export]] sales, Sales returns, Inter-location transfers, a separate optional module for Point of Sales, Marketing schemes, incentives for sales & distribution

*Purchase - normal purchases (local and imports), job work, services and service contract management

*Inventory management – Raw material, bought-outs, finished goods, multi-location warehouses etc.

*Production and PPC – Shop floor activities as well as back-office activities, Process based level2 Bill of Material, MRP, production planning, Job cards, [[WIP]] etc.

*Fixed Assets – Management of Fixed Asset register with user defined parameters for depreciation calculation

*EQM – preventive and break-down maintenance, both in-house and third party, tracking spare part consumption, stock ledger and machine history

*Customer Care – post sales complaints management, warranty and out of warranty repairs and billing, tracking support activity for customers

*EIS – Management Dash Board, macro-drill down reporting

*In-built report writing capabilities and user defined dashboard for managers and directors

*Integration of Oracle BI tool Discoverer within ERP

*Extension to Extra-net – web portal integration, e-commerce, EDI,
*Possible to interface with other ERPs.

==Partnerships==

ESS prefers Business Partnership model outside India and is represented by well known IT companies in various countries. ESS also provides marketing support by providing training to the partners’ marketing tea, and where required, deputes trained personnel to help the partners in marketing the software.

==References==

1. [[Economic Times]], [[New Delhi]], June 26, 2000 - Ess-tablishing goals (1)

2. [[DataQuest]] – Jan 31, 1999 – Sizzlers of ’99 – cover story (2)

3. DQ Week – June 8-14, 2000 – ESS discontinues Makess, launches ebizframe (3)

4. DataQuest – Feb 15, 2000 – Sizzlers of 2000 – cover story (4)

5. Computer Resellers News – June 15, 2000 – Advantage ASP (5)

6. DataQuest, Nov 30, 1999 – Interview with Atul Vijaykar (Intel), Anil Bakht (ESS) (6)

7. [[CMM5]] and ISO certificates (7)

8. [[computer world]] – Jun 16-30 2000 – ERP special – User survey ESS in top 10 (8)

9. PCQuest – Dec 1999 – Trends 2000 – Made in India – Ten world class products developed in India (9)

10. [[Frost & Sullivan]] Reports (10)

11. Economic Times, Aug 6, 1999 – ESS for Success (11)

12. Unkown publication, Makess – Driving Sterling Tools to success (12)

13. [[Times of India]], New Delhi – Dec 5, 2000 – Cellbiz from ESS (13)

14. Computerworld Nov 1-15, 1999 – ESS brings Makess on the Net (14)

15. DQ Week, Sep 16-22, 1999 – India’s first ERP on the NET (15)

16. DQ Week, Jan 13-19, 2000 – Sun, Tech Pacific, ESS tie up (16)

17. IT – Information Technology, April 2000 – ERP on Net by Mantra Online, Wipro Net offers rental ERP via Internet (17)

18. DataQuest, Feb 29,2000 – New, Net-savvy ERP Software (18)

19. [[Business Line]], May 2000 – ESS unveils ebizframe (19)

20. Computer Resellers News, 15 June 2000, ESS shifts gear from ERP to ebiz solutions (20)

21. CIOL, July 2006 – Ebizframe – Developers to benefit from Ebizframe-Oracle marriage (21)

22. [[Financial Express]], June 17, 2006, Case Study - Alpha Pneumatics (22)

23. DataQuest, June 15, 2007, Making In-roads (23)

24. DataQuest, Special Report, Case Study – Sidel (24)

25. DataQuest, Special Report, Case Study – Vir Rubber (25)

26. The Machinist, Aug 2007, Case Study – Monarch Catalyst (26)

27. BenefIT, October 2007, Best Practices (27)

28. Economic Times, Nov 11, 2004, Shopper’s Paradise takes to IT (28)

29. DataQuest, Special Report, March 2007, Q&A, Milkfood, (29)

30. [[Express Computers]], …………………., Managing multiple Issues, Case Study Recon Oils (30)

31. ExpressComputers – April 4, 2005, SMI caps production wastage (31)

32. Dataquest – May 15, 2007 – Gems & Jewelry, Case Study - Shrenuj & Co. (32)

33. DataQuest, March 2007, Special Report, Gems & Jewelry – Case Study – Laabh Jewellers (33)

34. ………………………………………., Case study of a Garment manufacturer (34)

35. EFYTimes.com[http://www.efytimes.com EFYTimes], Oct 6 2006, [http://www.essindia.com ESS] honoured with Software Export Excellence (35)

36. India infoline, Oct 6 2006 -[http://www.essindia.com ESS] wins market development award from ESC (36)

37. DQ Channels, Aug 31, 2006, ESS goes global (37)

38. ZDNet India, ……………, ESS translates ebizframe ERP into five international languages (38)

39. CIOL, June 2006, [http://www.essindia.com ESS]ESS solution for Red Hat Linux (39)

40. [[Linux]] for you, Aug 2006, evuzfrane wears Red Hat (40)

41. Screenshots of MDB

Archive:Eastern Software System

2009-05-13T11:12:05Z

59.144.163.207:

{{Infobox Company
| company_name = Eastern Software Systems
| company_type = [[Private]]
| foundation = 1990
| location = [[New Delhi, India]]
| area_served = 25 different countries
| key_people = [[Anil Bakht]] ([[Managing Director (official)|Chairman]]) ([[Sanjay Agarwala]]) ([[CEO]]) 
| num_employees = 300 (2009)
| industry = [[IT]]
| products = [[ebizframeENTERPRISE and ebizframeCORE]]
| homepage = [http://www.essindia.com www.essindia.com]
}}

'''Introduction'''

Ebizframe is an Enterprise Resource Planning ([[ERP]]) software created by an Indian company [http://www.essindia.com Eastern Software Sytems Pvt. Ltd.][ESS] ESS was incorporated in 1990 as a software services company in Delhi. ESS launched its ERP product Makess(1), (2) – subsequently redesigned and launched as ebizframe in year 1999, (3) with possibility of extending it to customers and vendors. Makess on the Net was the first ERP in India to be offered on rental – what is now called SaaS model, in year 2000. (4) (5)

[http://www.essindia.com ESS] received its first venture funding in 1998 from FMO, [[Intel]] and [[Citi Bank]]. (6). It is assessed at [[CMM]] level5 and follows [[ISO]] standards 2000:1901. (7)

ESS was the first Indian company to get into highly competitive branded ERP market and it has been mentioned as one of the successful Indian software products by various independent agencies. (8), (9). Its focus was Indian SME market. ESS moved into international arena in the year 2002-03 through business alliances and is present in 26 countries currently and is a leading player in ERP space in these countries.

Ebizframe has been mentioned as among the top 6 ERP vendors in India for two years in running by Frost and Sullivan. (10) It is one of the rare Indian ERP companies to have grown consistently since its birth and recorded profits unfailingly since 2002-03

==History of ebizframe ERP==

*The precursor to ebizframe, called Makess was launched in 1998 in India on client-server [[technology]] on [[Oracle]] platform. (11)

*First customer for Makess was Sterling Tools Ltd. in Faridabad (12) and is now using its latest version of ebizframe ERP.

*ESS introduced first Indian WAP enabled ERP. (13)

*A generational jump was taken in year 2000 by launching a web based version of Makess, named “Makess on Net” (14), (15) in collaboration with Oracle and Sun Systems. (16). It was an ahead of the times SaaS (‘pay as you use’) model and it attracted a good number of customers and appreciated well by critics and industry people alike for its visionary use of technology and future road map for users. (17), (18)

• The new version on a new technology platform of Oracle with [[e-commerce]] and extranet collaboration possibilities was launched in year 2000 and called ebizframe.(19), (20)

*Ebizframe upgrades have been released regularly and version 7.4 on Oracle 11g is slated to be released in May 2009. (21)

*Ebizframe came up with the concept of ‘bolt-ons’ i.e. functional upgrade granules that are released every quarter and can be added at a customer site without much pain. This concept takes care of major disruptions in customer usage when a new version is sought to be upgraded irrespective of what functionality a customer may be interested in. Now some other global ERPs are also finding merit in this approach.

*During its last 10 years of existence, ebizframe has come up with many flavours for different industry verticals. Major segments apart from engineering, chemicals/pharma ( 22), (23),(24),(25), (26), (27) being retail (28), dairy, food processing (29), (30) agro-industries like Sugar, Breweries and Distilleries, Paper & Packaging (31), Jewelry (32), Retail (33)Textiles & Apparel (34) etc. etc.

*Ebizframe is running currently in 26 countries in different industry segments. (35),(36)

*Ebizframe is also being offered in four more international languages. (37), (38)

*Ebizframe has come up with web portal for customers which can sit on the top of the ERP, tightly integrated with the ERP that provides access to employees, vendors and buyers, and also facilitates its extension to e-commerce. (hyperlink to portal screenshot).

==Technology==

*Ebizframe is based on [[Oracle]] technology, middle-tier being provided by [[Java]] technology. It is currently on Oracle 11g platform and is fully web enabled.

*Interestingly it does not require a middle ware like [[Citrix Server]] for running on browser.

*It can run on [[Windows]], Sun, Solaris, [[Unix]] and [[Linux]] platform. Certified for [[Redhat Linux]] (39), (40).

*ESS has recently introduced state of art Management Dash Board with latest web based light technologies like [[PHP]] and [[Flex]]. (41)

*ESS has recently introduced [[excel]] based Reporting capabilities in ebizframe, giving users virtually unlimited capabilities to generate their own reports and graphic based [[MIS]], Dash board etc.

*Ebizframe can have integrated interface within its menu for [[Oracle Discoverer]].

*Can run on [[LAN]]LAN, [[WAN]], [[Internet]] – in-house hosting as well as [[ISP]] hosting

==Implementation possibilities==
*ERP web-hosted on static IP address in-house with global access

*Hosting by ISP – with server hosted remotely at ISP data centre. It has tied up with Datacentres like Netmagic, India for this purpose.

*SaaS model and MSP model

*Hybrid connectivity through [[VSAT]], [[Broaband]], leased and [[ISDN]] lines. ESS has tied up with many leading service providers to provide customers rich options.

*Ready to use low cost standard implementation with core functions and fast implementation - ebizframeCORE

==Implementation methodology==

ESS implements its [[ERP]] through its own project teams and doesn’t depend on third party consultants. This is much different methodology but highly successful resulting in very high success rate. ESS believes in incremental ERP implementation. It is more successful and leads to least disruption in regular business of the customer. This model is being slowly adopted by other ERP players in the industry.

==Product features==

*Business functions – [[CRM]], [[Sales]], [[Procurement]], Manufacturing, Licensed (sub-contracted mfg.) Finance, Asset maintenance, [[Statutory Compliance]], [[Customer Service]], Administration

Modules –

*Sales – pre-sales activities ([[SFA]]), Sales & Distribution, [[Export]] sales, Sales returns, Inter-location transfers, a separate optional module for Point of Sales, Marketing schemes, incentives for sales & distribution

*Purchase - normal purchases (local and imports), job work, services and service contract management

*Inventory management – Raw material, bought-outs, finished goods, multi-location warehouses etc.

*Production and PPC – Shop floor activities as well as back-office activities, Process based level2 Bill of Material, MRP, production planning, Job cards, [[WIP]] etc.

*Fixed Assets – Management of Fixed Asset register with user defined parameters for depreciation calculation

*EQM – preventive and break-down maintenance, both in-house and third party, tracking spare part consumption, stock ledger and machine history

*Customer Care – post sales complaints management, warranty and out of warranty repairs and billing, tracking support activity for customers

*EIS – Management Dash Board, macro-drill down reporting

*In-built report writing capabilities and user defined dashboard for managers and directors

*Integration of Oracle BI tool Discoverer within ERP

*Extension to Extra-net – web portal integration, e-commerce, EDI,
*Possible to interface with other ERPs.

==Partnerships==

ESS prefers Business Partnership model outside India and is represented by well known IT companies in various countries. ESS also provides marketing support by providing training to the partners’ marketing tea, and where required, deputes trained personnel to help the partners in marketing the software.

==References==

1. [[Economic Times]], [[New Delhi]], June 26, 2000 - Ess-tablishing goals (1)

2. [[DataQuest]] – Jan 31, 1999 – Sizzlers of ’99 – cover story (2)

3. DQ Week – June 8-14, 2000 – ESS discontinues Makess, launches ebizframe (3)

4. DataQuest – Feb 15, 2000 – Sizzlers of 2000 – cover story (4)

5. Computer Resellers News – June 15, 2000 – Advantage ASP (5)

6. DataQuest, Nov 30, 1999 – Interview with Atul Vijaykar (Intel), Anil Bakht (ESS) (6)

7. [[CMM5]] and ISO certificates (7)

8. [[computer world]] – Jun 16-30 2000 – ERP special – User survey ESS in top 10 (8)

9. PCQuest – Dec 1999 – Trends 2000 – Made in India – Ten world class products developed in India (9)

10. [[Frost & Sullivan]] Reports (10)

11. Economic Times, Aug 6, 1999 – ESS for Success (11)

12. Unkown publication, Makess – Driving Sterling Tools to success (12)

13. [[Times of India]], New Delhi – Dec 5, 2000 – Cellbiz from ESS (13)

14. Computerworld Nov 1-15, 1999 – ESS brings Makess on the Net (14)

15. DQ Week, Sep 16-22, 1999 – India’s first ERP on the NET (15)

16. DQ Week, Jan 13-19, 2000 – Sun, Tech Pacific, ESS tie up (16)

17. IT – Information Technology, April 2000 – ERP on Net by Mantra Online, Wipro Net offers rental ERP via Internet (17)

18. DataQuest, Feb 29,2000 – New, Net-savvy ERP Software (18)

19. [[Business Line]], May 2000 – ESS unveils ebizframe (19)

20. Computer Resellers News, 15 June 2000, ESS shifts gear from ERP to ebiz solutions (20)

21. CIOL, July 2006 – Ebizframe – Developers to benefit from Ebizframe-Oracle marriage (21)

22. [[Financial Express]], June 17, 2006, Case Study - Alpha Pneumatics (22)

23. DataQuest, June 15, 2007, Making In-roads (23)

24. DataQuest, Special Report, Case Study – Sidel (24)

25. DataQuest, Special Report, Case Study – Vir Rubber (25)

26. The Machinist, Aug 2007, Case Study – Monarch Catalyst (26)

27. BenefIT, October 2007, Best Practices (27)

28. Economic Times, Nov 11, 2004, Shopper’s Paradise takes to IT (28)

29. DataQuest, Special Report, March 2007, Q&A, Milkfood, (29)

30. [[Express Computers]], …………………., Managing multiple Issues, Case Study Recon Oils (30)

31. ExpressComputers – April 4, 2005, SMI caps production wastage (31)

32. Dataquest – May 15, 2007 – Gems & Jewelry, Case Study - Shrenuj & Co. (32)

33. DataQuest, March 2007, Special Report, Gems & Jewelry – Case Study – Laabh Jewellers (33)

34. ………………………………………., Case study of a Garment manufacturer (34)

35. EFYTimes.com[http://www.efytimes.com EFYTimes], Oct 6 2006, [http://www.essindia.com ESS] honoured with Software Export Excellence (35)

36. India infoline, Oct 6 2006 -[http://www.essindia.com ESS] wins market development award from ESC (36)

37. DQ Channels, Aug 31, 2006, ESS goes global (37)

38. ZDNet India, ……………, ESS translates ebizframe ERP into five international languages (38)

39. CIOL, June 2006, [http://www.essindia.com ESS]ESS solution for Red Hat Linux (39)

40. [[Linux]] for you, Aug 2006, evuzfrane wears Red Hat (40)

41. Screenshots of MDB

Software industry

2006-11-29T11:07:24Z

59.144.117.118: /* External links */

{{globalize}}
{{expand}}

[[Image:Packagedsoftwareatretail.jpg|thumb|right|250px|Starting in the 1980s, application software has been sold in mass-produced packages through retailers]]

'''Software industry''' is a term used to describe the group of businesses involved in the [[software development|development]] and maintenance of [[computer software]]. The software industry started in the mid-1970s at the time of the personal computer revolution. The industry also includes software [[service]]s, such as training and consultancy.

There are mainly two types of businesses in the software industry; those developing [[proprietary]] software such as [[Microsoft]], and those developing [[open source]] software. Developing proprietary software is costly and involves software licensing and the need to protect the software from [[cracking]] and [[piracy]].

The main return on open source comes from selling services, such as training and support, rather than the software itself. Despite doing much business in properietary software, some companies like [[Sun Microsystems]] and [[IBM]] participate in developing free and open source software to deter from [[monopoly|monopolies]] and take a portion of their [[market share]]. [[Netscape]]'s actions are an example of this, and thus [[Firefox]] has become a more popular.

The largest and most profitable of software companies are located in the [[United States]]. As of 2006, the software industry is dominated by [[Microsoft]].

This table, derived from the Software Magazine 500 for 2005 [http://www.softwaremag.com/SW500/index.cfm?StartRow=1&RowsPer=50&BusCat_Search=&PrimBus_Search=&PrimBusCat_Search=&RankSort=ASC&CompSort=&trk=n&id=5] shows the total amount of revenue brought by software and software services companies, per locale.

{| class="wikitable"
!Location
!Total Revenue Millions of [[United States dollar|US$]]
<TR><TD>CA</TD><TD>111836.8</TD></TR>
<TR><TD>NY</TD><TD>101485.1</TD></TR>
<TR><TD>TX</TD><TD>40606.1</TD></TR>
<TR><TD>WA</TD><TD>34744.5</TD></TR>
<TR><TD>MA</TD><TD>19524.9</TD></TR>
<TR><TD>PA</TD><TD>18470.0</TD></TR>
<TR><TD>NJ</TD><TD>9141.3</TD></TR>
<TR><TD>MD</TD><TD>8564.9</TD></TR>
<TR><TD>MO</TD><TD>5486.0</TD></TR>
<TR><TD>WI</TD><TD>3729.7</TD></TR>
<TR><TD>VA</TD><TD>3553.3</TD></TR>
<TR><TD>NC</TD><TD>3497.9</TD></TR>
<TR><TD>IL</TD><TD>3490.2</TD></TR>
<TR><TD>OH</TD><TD>3404.1</TD></TR>
<TR><TD>FL</TD><TD>3350.4</TD></TR>
<TR><TD>GA</TD><TD>2835.0</TD></TR>
<TR><TD>CO</TD><TD>2522.9</TD></TR>
<TR><TD>MN</TD><TD>1483.3</TD></TR>
<TR><TD>MI</TD><TD>1305.7</TD></TR>
<TR><TD>AR</TD><TD>1225.9</TD></TR>
<TR><TD>OR</TD><TD>716.8</TD></TR>
<TR><TD>Japan</TD><TD>603.7</TD></TR>
<TR><TD>AL</TD><TD>573.3</TD></TR>
<TR><TD>England</TD><TD>550.3</TD></TR>
<TR><TD>VT</TD><TD>520.7</TD></TR>
<TR><TD>Canada</TD><TD>498.7</TD></TR>
<TR><TD>AZ</TD><TD>388.6</TD></TR>
<TR><TD>NH</TD><TD>296.6</TD></TR>
<TR><TD>NE</TD><TD>292.8</TD></TR>
<TR><TD>UT</TD><TD>247.6</TD></TR>
<TR><TD>SC</TD><TD>201.5</TD></TR>
<TR><TD>CT</TD><TD>102.4</TD></TR>
<TR><TD>MT</TD><TD>61.8</TD></TR>
<TR><TD>IN</TD><TD>55.1</TD></TR>
<TR><TD>IA</TD><TD>51.1</TD></TR>
<TR><TD>ID</TD><TD>47.3</TD></TR>
<TR><TD>KY</TD><TD>43.7</TD></TR>
<TR><TD>NV</TD><TD>23.1</TD></TR>
<TR><TD>BC</TD><TD>15.8</TD></TR>
<TR><TD>OK</TD><TD>10.4</TD></TR>
<TR><TD>NB</TD><TD>7.8</TD></TR>
<TR><TD>KS</TD><TD>7.6</TD></TR>
<TR><TD>Germany</TD><TD>4.4</TD></TR>
<TR><TD>ND</TD><TD>2.1</TD></TR>
|}

==See also==
*[[Personal Computer]]
*[[Software]]
*[[Software development]]
*[[Software engineering]]
*[[Software engineering economics]]

==External links==
* [http://www.siprofessionals.org/ Software Industry Professionals website]
* [http://www.siia.net/ Software and Information Industry Association website]
* [http://www.softwaremag.com/ Software Magazine website]
* [http://www.conextechno.com/ Sofware Animations India]
[[Category:Industries]]
[[Category:Business]]
[[Category:Information technology]]

{{software-stub}}
{{business-stub}}

Archive:PHP and MySQL Programming/PHP Syntax

2006-08-07T12:26:19Z

59.144.154.75: /* '''<?=''' */

[[Programming:PHP and MySQL|<< Back to PHP and MySQL]]

== PHP tags: ==

=== '''<?php [code] ?>''' ===

* Enclose php code

* Can be configured in the php.ini to be <? ?>, <script language="php"> </script> etc.

* Embedded in normal HTML code

* Within php tags, statements are separated by a ; (generally also followed by a new line).

Example:

<?php
print “Hello World\n”;
$date = date(“Y-m-d H:i:s”);
print “The date and time at the moment is $date”;
?>

=== '''<?=''' ===

* Used if you just want to print out the value of a variable

Example:
<?php
$name = "Bobby";
?>

<?echo $name?>
Which will output ''Bobby''.

Example:
<?=date(“Y-m-d H:i:s”)?>

Which will output something like ''2005-11-09 19:40:05''.

== Commenting ==

==='''#'''===

* Comments out one line

* Example:
echo “Hello”; # Everything from the hash is commented out

* Example:
# This entire line is commented out

==='''//'''===

* Works just as in Java and JavaScript

* Same function as '''#'''

==='''/* (text) */'''===

* Comments out everything between the /* and the */

* Example:
/*All of this is
commented out.
Even this line!*/

== Variables ==

➢ Variables in PHP are denoted by the $ prefix.

e.g. : $a = “Hello World”; # this assigns the string “Hello World” to $a.

e.g. : $b = “$a, I'm Ralfe”; # this assigns “Hello World, I'm Ralfe” to $b.

e.g. : $b = $a.”, I'm Ralfe”; # exactly the same as the previous example.

➢ PHP supports dynamic variables.

e.g. : $c = “response”;

e.g. : $$c = “Hello Ralfe”; # this assigns “Hello Ralfe” to $response.

➢ PHP variables do not have to be declared ahead of time, nor do they require a type
definition. PHP handles all data type conversions.

e.g. : $a = 4;

e.g. : $b = 12;

e.g. : print “The value of a if $a.”; # Uses a as a String.

e.g. : $c = $a + $b; # $a is now used as an Integer again.

➢ PHP supports boolean variables, which can be assigned either a one or a zero, or a
true or false.

e.g. : $a = true;

e.g. : $b = 1;

e.g. : # $a and $b are the same thing!

e.g. : $c = false;

e.g. : $d = 0;

e.g. : # $c and $d are the same thing!

== Operators ==

➢ Arithmetic Operators

$a = 4;

$b = 2;

// Addition: $a + $b = 6

// Subtraction: $a - $b = 2

// Multiplication: $a * $b = 8

// Division: $a / $b = 2

// Modulus: $a % $b = 0

// Increment: $a++

// Decrement: $a--

➢ Assignment Operators

$a = 4;

$b = $a;

// $b = 4;

➢ Comparison Operators

$a == $b // test if two values are equal

$a != $b // test if two values are not equal

$a < $b // test if the first value is less than the second

$a > $b // test if the first value is greater than the second

$a <= $b // test if the first value is less than or equal to the second

$a >= $b // test if the first value is greater than or equal to the second

== Concatenation ==

$a = “Fill the halls “;

$b = “with poisoned ivy...“;

$c = $a . $b; # the '.' operator concatenates two variables.

// $c = “Fill the halls with poisoned ivy...”

== Arrays ==

PHP supports both numerically indexed arrays as well as associative arrays.

$a = array(1, 2, 3, 4);

// $a[0] = 1;

// $a[1] = 2;

// $a[2] = 3;

// $a[3] = 4;

$b = array(“name” => ”Fred”, “age” => 30);

// $b['name'] = “Fred”;

// $b['age'] = 30;

== Decision and Loop Statements ==

'''IF THEN ELSE statement'''

$a = 1;
$b = 10;
if ($a > $b) {
echo “a is greater than b”;
}
else if ($a == $b){
echo “a is equal to b”;
}
else{
echo “a is not greater than b”;
}

'''SWITCH statement'''

$a = 100;
switch($a){
case(10):
echo “The value is 10”;
break;
case(100):
echo “The value is 100”;
break;
case(1000):
echo “The value is 1000”;
break;
default:
echo “Are you sure you entered in a valid number?”;
}

'''FOR statement'''

$a = 10;
for ($i = 0; $i < 10; $i++){
# initialize $i ; while condition ; increment statement
print “$i”;
}

'''FOREACH statement'''

$a = array(1, 2, 3, 4, 5);
foreach ($a as $val){
echo “$val”;
}

'''WHILE statement'''

while ($row = mysql_fetch_row($result)){
print $row[0];
}

'''DO WHILE statement'''

$i = 0;
# Note that it might seem that $i will
do{
# never be printed to the screen, but
print $i;
# a DO WHILE loop always executes at
} while ($i >0);
# least once!

== FUNCTIONS ==

function my_function($value){
if (!$value){
return 0;
}
else{
return ($value % 2);
}
}
$a = 45;
$ans = my_function($a);

== Classes ==

class my_class {
var $value1;
var $value2;
function set_value1($val){
$this->value1 = $val;
}
function set_value2($val){
if ($this->value1 > 0){
$this->value2 = $val;
}
else{
$this->value2 = 0;
}
}
}
$new_class = &new my_class;
$new_class->set_value1(10);
$new_class->set_value2(2);

[[Programming:PHP and MySQL:Introduction|<< 1. Introduction]] | [[Programming:PHP and MySQL|TOC]] | [[Programming:PHP and MySQL:File Handling|>> 3. File Handling]]

[[Category:PHP]]
[[Category:MySQL]]

Archive:PHP and MySQL Programming/Database Connectivity

2006-06-01T09:54:59Z

59.144.165.226: /* Introduction */

[[Programming:PHP and MySQL|TOC]]

== Introduction ==

You can only do so much with storing information in files. When you need to store large amounts of data, and perform intensive number crunching on that data, there is nothing better than a good SQL database. In this section, we'll discuss connecting PHP to a MySQL database and perform queries and retrieve data back from the database.

== Opening a Connection to a MySQL Database ==

The first thing that we need to do before we can interact with any database, is to open up a connection to that database server. This is done by using the mysql_connect() function, which returns a database handler, much like a file handler when dealing with files. The database handler is then used to selecting the active database to use.

Here is the code to setup a connection to the database server, and to select a database to use :

<?
$db = "database1";
$link = mysql_connect("localhost", "username", "password");
mysql_select_db($db, $link);
?>

== Creating a Query ==

Once a connection to a database has been made, you will inevetably want to perform a database query. To create a query on the selected database, we use the mysql_query() function. If you use a SELECT query, then the data returned from that query will be passed to the mysql_query() function, which will in turn return it to a variable which you can specify. In the following example, two queries are made, the first does not return any data, and the second does.

<?
// A Query without any returned data
mysql_query ("INSERT INTO `table1` ('val1', 'val2')");
// A Query with returned data
$query = mysql_query("SELECT * FROM `table1`");
?>

== Retrieving data from a SELECT Query ==

There are many methods for retrieving data from a SELECT Query.

If we take, for example, the following code :

<?
# --- Connect To Database ---
$db = "db1";
$link = mysql_connect("localhost", "user", "pass");
mysql_select_db($db, $link);

# --- Select Info from Database ---
$result = mysql_query ("SELECT val1, val2 FROM tbl1");
?>

To now retrieve the data from the $result variable, we can use one of many methods. The recommended method, however, is to sequentially go through each row of the table, storing it into a one-dimensional array. We do this by using the mysql_fetch_row() function, passing it the variable intowhich the result is stored. Here is a simple example :

<?
while ($row = mysql_fetch_row($result)){
foreach ($row as $field) {
print "$filed . ";
}
print " ";
}
?>

This will simply output the result in table-like format.

Here is another example of using this method :

<?
$counter = 0;
while ($row = mysql_fetch_row($result)){
$val1[$counter] = $row[0];
$val2[$counter] = $row[1];
$counter++;
}
$numRows = $counter;
?>

The above example, simply splits the results up into multiple one-dimensional arrays, for easy manipulation.

== Closing a Database Connection ==

It is not always necessary to close a connection when you are finished, but it is advised. It is, however, necessary to close the connection to the database if you want to open up a new connection to a different database.

To close a connection to a database, we use the mysql_close() function, as follows :

<?
mysql_close();
?>

== Error Handling ==

It is useful when debugging, and even when you just want to make sure that a database does not behave unexpectedly. Once a query has been created via the mysql_query() function, any error messages generated will be stored in the mysql_error() function. Here is a sample code snippet to display a error message. However, when there is no error messages, a blank string is returned.

<?
print mysql_error();
?>

[[Programming:PHP and MySQL:File Handling|<< 3. File Handling]] | [[Programming:PHP and MySQL|TOC]] | [[Programming:PHP and MySQL:Session Handling|>> 6. Session Handling]]

Yogi Tea

2006-03-28T17:09:58Z

59.144.17.143: /* External links */

'''Yogi Tea''' is the name of a range of [[herbal tea]]s manufactured by the [[Golden Temple Company]] in [[Portland, Oregon]]. The recipes use [[cardamom|cardamom seed]], [[cinnamon|cinnamon bark]], [[clove|clove bud]], [[ginger root]] and [[black pepper]] as the basic ingredients, and the packaging informs that the recipes was formulated along the principles of [[ayurvedic medicine]].

==History==
The Yogi Tea Company was founded in 1984 as an outgrowth of the Golden Temple Vegetarian Restaurants in Portland, Oregon. The restaurant was opened by students of [[Yogi Bhajan]], a Mahan Tantric and master of [[Kundalini Yoga]]. After his classes Yogi Bhajan would prepare a blend of tea containing cinnamon, cardamom, cloves, ginger and black pepper which the students dubbed “Yogi tea”. The tea was so popular at Golden Temple Vegetarian Restaurant that they started packaging it.

Over time the company introduced new blends and lines, such as Healing Formula teas in 1991. Also in 1991, the company started making its teas from organic ingredients. The company eventually expanded from [[herbal tea]]s to include blends of [[black tea|black]] and [[green tea|green]] teas, too.

Since 2000, the boxes have featured illustrations by Seva Kaur. The illustrations are based on a devotional poem or prayer found on the inside of the box. The illustrations found on the Chai, Woman's, and Exotic Teas, are done by Latvian artist Anita Kreituse. The boxes use vegetable based inks and dyes, and non-irradiated recycled carton materials.

==Product==

The company produces over 50 blends of tea. These include 22 blends in their Healing Formulas line, 11 green teas, 9 exotic teas, 5 Women’s Healing Formulas, 3 organic chais, and 2 black teas. All the blends contain organic ingredients, but due to a lack of availability for some organic ingredients not all blends are entirely organic. The blends that are 95% organic have the USDA [[Organic certification|organic seal]]. Yogi Botanicals, who has a prohibition on [[Genetically modified organism|GMO]]s, organizes the growing and distribution of the organic herbs and spices required for the teas and [[Quality Assurance International]] acts as a third party certifier. The tea bags are 100% oxygen bleached and recyclable. The bags are placed in a heat-sealed envelope which is then placed into a cellophane-wrapped box.

==External links==
*[http://www.yogitea.com/ The Yogi Tea Company]
*[http://www.yogibotanicals.com/ Yogi Botanicals]
*[http://www.goldentemple.com/ Golden Temple Company]
*[http://www.yogitea.nl/ Yogi Tea Europe]
*[http://xooxonline.info/losingweightnaturally.php Losing weight naturally through Green Tea]

[[Category:Tea brands]]