documentation of salo region rotary clubs website
Contents
1. Cem we T update mite id INTO 1 gt name VARGHAR100 gt ype VARCHARIGO Tg INTO D c language CHART gt title VARCHARI100 gt note VARCHAMESS content TEXT c ordering INTO Y gt position VARCHARIGO checked out INTO checked out time DATETIME gt publish up DATETIME gt publish down DATETIME E PTT Sree rure N gt module VARGHAR BO PIS OO OO lt 1 c accom TINYINT M I macman TINYINT lt mg VARGHANES5 raosta Jan di intei rra RR Spereme VAROHAPI B120 1 Sm iny TERS V eeeston Jo VAROHAPIR user Kd INT S uaar ia INT olent TNTS 1 Some c cabs INTO LIESS gt vend INT gt otg name VAROHAR100 gt profile key VARCHAR 100 eke Seeman s N S enr ET Aver Colom aa omen vainun EET TA SARA VANSKAR essei 2 tne VARSAA H tink VARCHARIZ00 name VARECHAR 255 gt data VARGHAR 20400 H gt llename VARCHAR 200 cn VAPGHAPUM gt umemame VAFICHAR 50 gt published TINYINT gt con position VAROHARGES gt usonype VARCOHAR GO 1 Strom ten INT gt monroe TEXT c cache time INT gt suburb VARCHAF 100 Pere em i re N n H 29999 CHARI an i checked out time DATETIME H c litle VARCHARS0 gt country VARCHAMR 100 i c itte native VARCHAR GO Save MT gt postcode VAROGHAM100 Sees Tivi sian VARDHAN QE S MENU CANNE a _ ee NEM este T amenan1aso jo INT2. O htp vunrotarsalofiindexphploption com jevents task icalevent edit year 20118 month 108dzy 27 amp temide1 EHIC Ar Gocgi EB 5 x LI HH Apple Yahoo GoogleMaps YouTube Wikipedia News 125 v Popula G VALIKKO 5 USKELA INNER WHEEL SALO NUORISOVAIHTO VE G TAPAHTUMIA 19 a JEvents x 2 ze Cancel US Viikkokokous Event Thu Oct 27 16 45 06 00PM US Viikkokokous Common Calendar G KALENTERI Subject Testing event Event 4 October2011 Amenya E Oanda X cew CO s Categories Default v Access Level F Activity Bs U BS B Sve Paragraph gt Fontfamih 3 4 5 6 7 8 BLE EEO LE I75 Go 4 4 N amis x 710202122 aaas DA 0 24 25 26 27 mn 20 TED Write what you want to add to the events here G KIRJAUTUMINEN Hi erick 16 18 10 2011 Picture 12 Add event screen shot page Adding a file in the website is also explained in the user manual Refer to Appendix 5 for instructions on how to add files to the website 6 TESTING AND IMPLEMENTATION There are many tests that a web developer can do to cross check if his or her website is up to standards Salo Region Rotary Clubs website was tested 25 against four fundamental web development tests These tests were carried out by online web testing tools and the results are as follows 6 1 Load impact Slow websites means lost customers and revenues Load Impact is an online load test
3. INT Tua iNT gt oid INT c cata INTO gt type INT gt otoka INT gt dencniption gt parama TE gt own_pronx gt pubian up language CHAP S name VARCHARSS allan VARCHAF OR gt imptotal INT gt impmade INT 5 eliekun VARCHAM200 S mtma TINYINT oustombannercode VARCHAR 2048 gt stoky TINY INTO gt ordering INT gt metakey TEXT id gt Motakoy_protix VARCHAR 255 gt puronaso_ typo TINYINT gt Wack coke TINYINT track impressions TINYINT gt checked out INT checked out time DATETIME gt publish down DATETIME gt ronet DATETIME created DATETIME TEXT xr TINYINTI DATETIME ommo o anios VARCHARIE 120 J gt sections INT gt parama TEXT S oromod DATETIME c created by INT 10 created Dy aliae VARCHAR 255 gt moditied DATETIME gt moditied_by INTO gt metakey TEXT gt motacenc TEXT gt metadata TEXT gt reference VARCHAR S0 gt publish_up DATETIME gt publiah down DATETIME Td iNT ents INTEND o language CHART gt assot id INTG 0 litle VARCHAR 255 gt alias VARCHAR 255 5 Mile alias VAMCHANESS S antrotest MEDIUMTEXT gt fullest MEDIUMTEXT gt state TINYINT gt mask INT gt created DATETIME created by INT created by alias VARCHAN 255 gt modifies DATETIME gt modified by INT gt ohecked out INT gt checked out lime DATETIME publish_up DATETI
4. CMS has an advanced Information Architecture This is to ensure that the content is organized consistently and efficiently The whole system can be broken into three logical parts Joomla Framework stores content in the data format in a database Joomla template stores all the instructions for formatting the layout and design of the web pages HTML page this contains content pulled from the database and instructions from the template combined to generate an HTML page Below is a summary image of how content is served into web pages Joomla FRAMEWORK stores content in data format in a database Joomla TEMPLATE re HTML PAGE VIEW ON YOUR COMPUTER stores all the instructions j Content trom the for formatting layout and r Wa database and instructions The combined information design of the web pages from the template combine displays on your computer to generate an HTML page as a web page TURKU UNIVERSITY OF APPLIED SCIENCES THESIS Erick Amenya Oanda Picture 9 Image on how content is served up into web pages On the HTML page Joomla content can be displayed in two ways Uncategorized this would refer to the content that has not been put into any category In many cases uncategorized content is untraceable Categorized this is content that has been put into categories Categorized content is easy to trace in a website Joomla content is also organized in a hierarchy of sections c
5. Clubs have a website that is up and running Easy to use and meeting their needs together with an illustration how to work with Joomla CMS KEYWORDS Content management system system design website testing CONTENT LIST OF ABBREVIATIONS 1 INTRODUCTION 2 THEORETICAL BACKGROUND 2 1 Content management system 2 2 Creating a content management system 2 3 Joomla as content management system 2 4 Installation of Joomla using the JumpBox method 2 5 Information architecture of Joomla 3 PROJECT DEFINITION 3 1 Background information 3 2 Current system 3 3 General system requirements 4 SYSTEM DESIGN 4 1 System specification 4 2 Site maps 4 3 Information architecture of the website 4 4 Database schema 5 DESCRIPTION OF THE REAL SYSTEM 5 1 Main system screen captures 6 TESTING AND IMPLEMENTATION 6 1 Load impact 6 2 Browser test 6 3 Response time test 6 4 Broken link test 6 5 Result 7 EVALUTION 7 1 System implementation challenges and solutions 7 2 System improvements SOURCE MATERIAL NN NN 11 13 13 13 14 15 15 16 19 19 22 22 24 25 26 27 28 28 29 29 30 31 APPENDICES Appendix 1 Joomla 1 5 database schema Appendix 2 Windows JumpBox Appendix 3 Uploading files to the system Appendix 4 Adding an event to the calendar Appendix 5 Templete Source code TABLES TABLE 1 SECTIONS TABLE 2 CONTENT TABLE 3 CATEGORIES RATING TABLE 4 CATEGORIES TABLE 5 SUMMARY OF TEST RESULTS FIGURE
6. c catia INTO sia INT tite VAMCHAN SO S mitan VAFICHA S5 gt un VARICHARCGSO gt ordering INT gt archived TINYINTII gt approved TINYINTI gt access INT gt parama TEXT gt language CHAR gt created DATETIME gt created by INT 10 o orwated_by_ alias VARCHAR 265 gt modifies DATETIME gt modified by INT 10 c metakey TEXT gt metadenc TEXT gt metadata TEXT c featured TINYINTI gt xrotoronoe VARCHAR S0 publish_up DATETIME S publish down DATETIME B 4 ee Td INT gt name VARCHAR 255 gt contact VARCHAR 255 gt emaii VARGHAN 285 S eximinto TEXT gt stato TINYINTO gt checked out INT checked out lime DATETIME gt metakoy TEXT c oven profix TINYINT gt metakey pratis VANCHAME2SS c purchane type TINYINT track olika TINYINT Wack impressione TINY INT To mm c parent id INTOO extension VARCHAR GO tie VARCHAR 265 anas VARCHARESSI 1 gt note VARGHAM Z88 1 i dencription VANCHANS120 puted TINYINTI i Senecned_out RET UM i onecked out timo DATETIME S hienn TINYINT parame VARCHAMGO4m motadoso VARCHAR 024 motakey VARCHAR 024 gt meta S arvatod user eremted lima DATETIME S modified user 18 INTO b Z modinea tuna DATETIME mita INT DIO gt deneription V ARGHARU 2 gt motakoy TEXT gt motadeso TEXT gt publisned INTO la VAFICHA FIO 4i
7. clubs are and why they needed an online system The most important part is how the system was built how the information was accrued what documents were used in design an explanation of main system features on how they work what was tested and finally what needs to be improved felt it was vital to write this document to act as a quick guide to those who want to have an overview on CMS specifically focusing on Joomla It was mandatory to write this system document part after developing the system to act as an explanation of what the systems build was and what it contained and how the main part of the system work The theory part of this document will benefit those who want to get started with a content management system and how to set up Joomla CMS on their local PC before transferring their application online The system documentation part will benefit the system maintenance team if someday there might be a need of migrating from the current platform to another or maintain it The thesis can also act as a manual for the end users on how to work with the system This project had three players My lecturer who could consult for help on the project A fellow student who had a role of translating the content and gathering information for the website to be developed and a club representative who was in charge of content and providing tools for web development 2 THEORETICAL BACKGROUND 2 1 Content management system A content managemen
8. come 1 5 user 1 6 will seem very familiar of the Joomla Framework and CMS Site Map to the right place Joomla will help There are new templates and as a powerful and flexible way to Login you get your website up and running improved user interfaces but most bring your vision of the web to quickly and easily functionality is the same The reality With the administrator now Sample Sites 5 n TN 2 48 16 9 2011 Picture 8 Basic end user admin panel TURKU UNIVERSITY OF APPLIED SCIENCES THESIS Erick Amenya Oanda Appendix 3 User guide of Uploading file to the system Uploading files to the system To begin with login to the system from the administration back end B Kotarysalo Administration US TES ET s sinistrator index php Q7 Google B amp Google Maps YouTube Wikipedia News 172 v Popular Apple Yahoo Joomla Rotarysalo Joomla Administration Login Use a valid username and password to gain access to Username Admin the Administrator Back end Password Return to site Home Page Language Defauk Login O Joomia is Free Software released under the GNU GPL License Picture 13 Login admin page Locate the JFUploader and click on it a gt E new retarysalo fi administrator index2 php E Q Google eo M HH Apple Yahoo GoogleMaps YouTube Wikipedia News 214 v Popular Rotarysalo Admini EX Button fo
9. gt lt link rel stylesheet href lt php echo this gt baseurl gt templates system css system css type text css gt lt link rel stylesheet href lt php echo this gt baseurl gt templates system css general css type text css gt lt link rel stylesheet type text css href lt php echo templateUrl gt css template css gt lt if IE 6 gt lt link rel stylesheet href lt php echo templateUrl gt css template ie6 css type text css media screen gt lt endif gt lt if IE 7 gt lt link rel stylesheet href lt php echo templateUrl gt css template ie7 css type text css media screen gt lt endif gt script type text javascript src lt php echo templateUrl gt script js gt lt script gt lt head gt lt body gt lt div id art page background simple gradient gt lt div gt lt div id art page background glare gt lt div id art page background glare image gt lt div gt lt div gt lt div id art main gt lt div class art Sheet gt lt div class art Sheet tl gt lt div gt lt div class art Sheet tr gt lt div gt lt div class art Sheet bl gt lt div gt lt div class art Sheet br gt lt div gt lt div class art Sheet tc gt lt div gt lt div class art Sheet bc gt lt div gt lt div class art Sheet cl gt lt div gt lt div class art Sheet cr gt lt div gt lt div class art Sheet cc gt lt di
10. report possible security vulnerabilties to the Joomla Security Task Force Learning Joomla A good place to start learning Joomla is the Absolute Beginner s Guide to Joomla There you wil find a Quick Start to Joomla guide and video amongst many other tutorials The Joomla Community Magazine also has articles for new learners and experienced users alike A great place to look for answers is the Frequently Asked Questions FAQ If you are stuck on a particular screen in the Administrator which is where you are now try clicking the Help toolbar button to get assistance specific to that page If you stil have questions please feel free to use the Joomla Forums The forums are an incredibly valuable resource for all levels of Joomia users Before you post a question though use the forum search located at the top of each forum page to see if the question has been asked and answered Getting Involved If you want to help make Joomia better consider getting involved There are many ways you can make a TURKU UNIVERSITY OF APPLIED SCIENCES THESIS Erick Amenya Oanda Appendix 3 Picture 13 Upload file page Click the add file icon then browses and select the files to be uploaded to the website and click Upload zi x GB nttp www rotarysalo fi administrator index php7options com jfuploader amp acts upload A Googie D z ee LI HH Apple Yahoo Google Maps YouTube Wikipe
11. saving time and increasing efficiency Cost There is cost incurred in printing With mass printing this cost is significant Electronic recording saves paper work as well as the cost incurred in the same The online system will reduce that since you can access information without having to print it unless it s necessary 15 Time A search can be done faster with just a click than having to go through all files manually in trying to retrieve some information Protocol Sometimes members of one club have a need to access documents of other club branches to help them in discussion or decision making In such a case a secretary or a committee panel has to make a request to the other club branch to provide them with the required documents This is a long process which should be made shorter and effective In the new system the secretary has access rights to the documents of the other clubs and that is accessed when he signs online Awareness The club wants to make the general public sponsors and the internet community to be aware that it exists and learns its activities hence the need of an online system Every year the club receives exchange students from different parts of the world There is a need for those students to access information easily prior to moving to Finland Workload There is a need for club members to be able to get a meeting agenda prior to the meeting In the current system the secretary has to email each cl
12. the website The Salo Region Rotary Clubs website was built on categorized basis information architecture hierarchy The main club sections are Home klubit Rotarytoiminta Nuorisovaihto Yhteystiedot Web Links FAQ News Feeds Home section categories are Salon klubi Perni n klubi Uskelan klubi Inner Wheel Salo In each category we have relevant articles that change now and again as the system is updated On the right side of the website front page a calendar is displayed This calendar contains all the events planned in that year It is possible to view weekly monthly or daily events from the calendar Above the calendar is where latest event are displayed Latest event is a summary of events from the calendar that are due to happen This is meant to remind the club members of events that are about to happen without having to go to the event calendar for details The middle section of the website front page lays the content that clubs wants to view first This content can be changed depending on what the clubs wish to display to the public on their front page 4 4 Database schema Websites that are built on Joomla CMS adopt its DB schema This is because the system has a default database schema and the only changes a web developer can do to the system is to populate it with content or he can write an extension that has customized interface name but the core will remain same Refer to Appendix 1 to view how each table is rela
13. 10 gt name VARCHAR 50 title VARCHAR 100 rules VAMOHANGSI 20 Toa INT eta un VARCHAPUISO c new unl VARCHAR 50 reterer VARCHAR 50 gt comment VARGHAR 255 published TINYINT 4 gt created date DATETIME gt modified date DATETIME c unomamo VARCHAR 50 gt omat VARCHAR 100 gt password VARCHARI100 gt usenype VARCHARK25 S block TINY INT 4 gt mendtmali TINYINT 4 gt reginterDate DATETIME la stvisiiDate DATETIME gt activation VARCHAR 100 gt params TEXT 16 a a DX c parent JA INT canam S rot INT gt tino VARCHAR 100 9 INTO c ordering INTO rules VAPICHAT S120 7 message d INT c user id to INT gt Umer dd trom INT gt tolder Ja TINYINT S Hate ume DATETIME gt state TINYINTII gt pnonty TINYINTO subject VARCHAP GSS gt mensage TEXT gt tio VARCHAR 100 Appendix 2 Appendix 2 Installing Joomla CMS using Windows JumpBox Windows JumpBox Step 1 Download and install the appropriate VMware file from http downloads vmware com d info desktop downloads vmware player 3 0 Download and extract to the desktop the appropriate JumpBox for Joomla from http downloads vmware com d info desktop downloads vmware player 3 O Step 2 Open the Joomla JumpBox file you extracted to the desktop and click the JumpBox file as indicated in the Print screen Picture below Picture 1 Locating JumpBox Appendix 2 This file will run and
14. 28 j senen klubin presidenttin kaudella 2011 2012 on Matti Fontell ja sihteerin Juha Hekkala 2012 2013 presidenttin jatkaa Juha G KALENTERI 24 25 26 27 25 29 Your Details fo G KIRJAUTUMINEN Picture 10 Image of the home page 23 Picture 11 shows the registration page As it explains itself it is where a user fills in their registration details a gt http mww rotarysalo fi index php7option com user amp view register eo I HH Apple Yahoo GoogleMaps YouTube Wikipedia News 125 v Popular Y SALO PERNIO USKELA INNER WHEEL SALO DISTRICT 1419 FINLAND G VALIKKO E E G TAPAHTUMIA sn Registration Thu oct 20 16 45 06 00PM Rotarytoiminta Aietes s N US Viikkokokous Nuorisovaihto Thu Oct 27 16 45 0 Yhteystiedot 06 00PM 9 Web Links e US Viikkokokous O KALENTERI 4 October 2011 gt Password vey Parts ie Fields marked with an asterisk are required search Copyright 2010 The Rotary clubs of Salo Perni Uskela and Inner Whee Salo Finland All Rights Reserved Picture 11 Screen shot of registration page TURKU UNIVERSITY OF APPLIED SCIENCES THESIS Erick Amenya Oanda Picture 12 shows how to add an event to the page This is where the admin creates some events and publishes them to the front end Refer to Appendix 4 for a step by step instructions on how to add an event to the calendar 9 Edit Event _ ES RA
15. Bachelor s thesis Degree Programme in Business Information Technology Information Systems Management 2011 Erick Amenya Oanda DOCUMENTATION OF SALO REGION ROTARY CLUBS WEBSITE we TURUN AMMATTIKORKEAKOULU TURKU UNIVERSITY OF APPLIED SCIENCES BACHELOR S THESIS ABSTRACT TURKU UNIVERSITY OF APPLIED SCIENCES Degree Programme in Business Information a Technology Information Systems Management December 2011 54 Instructor Paivi Nygren Erick Amenya Oanda DOCUMENTATION OF SALO REGION ROTARY CLUBS WEBSITE Developing web applications running on Joomla CMS content management system is nowadays a common trend in the WWW Due to Joomla CMS ease of updating content advanced system access rights free technical support inexpensive cost of development are among some of the benefits Many organizations are moving to Joomla environment in order to use these benefits Salo Region Rotary Clubs were in need of an online system that they could use to store the previous clubs documents They requested a system that would address that need and many others developed on the Joomla CMS Platform The aim of this thesis was to document that developed system While documenting the system the thesis discusses how to get started with Joomla how to develop the system on Joomla platform how to test for major bugs description of the main processes in Salo Region Rotary Clubs website and how it works As aresult Salo Region Rotary
16. ERSITY OF APPLIED SCIENCES THESIS Erick Amenya Oanda Save the event that you added and then click the apply icon If you view a later event of that month what you added will appear when the date arrives as shown in picture 19 Br amp Tervetuloa Salon alueen lt B http www rotarysalo fi index php option com jevents amp task month calendar amp year 20118 amp month 108day 27 amp ltemid 1 EHC G Google Popular v Testing event eo LI HH Apple Yahoo GoogleMaps YouTube Wikipedia News 125 w Inner vineer Salo 4 O KIRJAUTUMINEN Hi erick Picture 19 Screen shot of the event added Appendix 4 Appendix 5 Appendix 3 Template source code Template source code lt php defined JEXEC or die Restricted access no direct access require once dirname FILE DIRECTORY SEPARATOR functions php document null if isset this document amp this baseUrl this gt baseurl templateUrl this gt baseurl templates this gt template artxComponentWrapper document IDOCTYPE html PUBLIC W3C DTD XHTML 1 0 Transitional EN http www w3 org TR xhtml1 DTD xhtml1 transitional dtd gt html xmlnsz http www w3 org 1999 xhtml xml lang lt php echo this gt language gt lang lt php echo this gt language gt gt lt head gt meta http equiv X UA Compatible content IE EmulatelE7 gt lt jdoc include type head
17. ME gt publish down DATE TIME gt images TEXT gt uris TEXT gt version INT gt parentid INT gt ordering INT gt metakey TEXT gt metadenc TEXT access INT gt nita INT gt metadata TEXT featured TINYINTES gt xmtorence VARCHAMBO content id INT c rating sum INT gt rating count INT ip VARCHA MGO gt miso MEDIUMTEXT gt mage VARCHAME 88 gt magepos VARCHAMGEO gt email o VARCHAR 255 gt dotaun con TINYINTI published TINYINTII gt checked out INT gt checked out time DATETIME ordering INT c parama TEXT accom TINYINT gt mobile VARGHAR 255 gt webpage VARCHARI255 gt sonnamet VARCHARG 65 gt description TEXT i assot id INTO O ionia a aa man as a Pomp gt sonnarmez vAnCHANGESS date DATETIME lt language CHART 1 i S norinamaa VAREHANESS Shite INT commo i S created DATETIME tanto TINYINTIO S ratINTOT lt omatad by INTO checked_out INT Sevei INTEO les i 1 5 oratod by avaa VARCHAR 255 ohecked out ime DATETIME apen vanonamasn c sosi SS Se SS eS ENMARTE gt moaned DATETIME gt modified by INT 10 c metakey TEXT gt matagase TEXT metadata TEXT gt foatured TINYINT M c Kroterence VAROCHAR SO gt publish up DATE TIME gt publish_down DATETIME Bowron moawoct soaron torm VARCHAR28 pe v To INTO O S parent id INTO Y onam n S rot INTO ever INT
18. S Figure 1 First level site map Figure 2 Second level site map Figure 3 Page layout Figure 4 Response time testing PICTURES Picture 1 Locating JumpBox Picture 2 Installation of VMware Picture 3 Configuration page Picture 4 Configuration process Picture 5 Configured page leading you to the Joomla admin page Picture 6 Configuration process Picture 7 Joomla admin control panel Picture 8 Basic end user admin panel Picture 10 Image of the home page Picture 11 Screen shot of registration pages Picture 12 Add event screen shot page Picture 13 Upload file pages Picture 14 Locate the upload file Picture 15 Selecting files to be uploaded Picture 16 File uploaded Picture 17 Screen shot of adding an event page Picture 18 Adding an event to the system Picture 19 Screen shot of the event added Picture 20 Load impact test Picture 21 Browser test Picture 22 Broken link test LIST OF ABBREVIATIONS SEF Search engine friendly 1 INTRODUCTION This thesis can be logically categorized into a theory and practical part The theory part explores the core concepts of a content management system and what a CMS system contains Explored in the theory parts are also the advantages of developing applications on a CMS how to work with it and an overview of Joomla CMS features The practical part is a documentation of a Salo Region Rotary Clubs website which gives a brief background information about what the
19. ae VANAN hmmm TET i rnt VAROHAPL GU creas ps bess wen ie oat HI AEAN Is tbe oikene I5 Cis nisse t We sata Io SAY severe SEC UARDHARISI Sse VARGAID I d deer d TANYNT d vec VADORARI d jenes imuun TUT gt title VAROHARIA8 gt description VARCHAR 255 Copyngnt Torsi Johnsen 2010 Ito toriljonn son com Feel ree 10 redisinbute inis schema but make sure you post backlink to the original blogpost along witty i 7 oategoryid INTO 1 gt name VARCHAR GO gt description TEXT gt parent INTO gt upaatasito INTO Y home TINY INTO title VARCHAR 255 parame VAROHARG04m extension Ja INT gt name VARCHAR 100 gt type VARCHAR O gt element VARGHANC100 S tolder VARCHAR 100 S oont jd TINYINTII gt enabled TINYINT 3 access TINVINTUM gt protested TINYINT gt manitent cache TEXT gt parame TEXT gt custom data TEXT gt system data TEXT gt checked out INTO gt checked out time DATETIME gt ordering INTO http y torkiijonnmen cery201 0 07 10 00mla 1 6 databa me chara Tod MT gt menutype VARCHAR 24 parent ja INT component d INT etemplate mtyle Ja INT Slanguage CHART p L title VARCHAR Z565 aliae VARCHAR 265 gt note VARCHAR 258 m a a eia d gt pain VARCHAR 1024 gt ink VARCHAR1024 type VARGHAR IG gt published TINYINT A devel INT a ordering INT checked out INT onockod out timo TIMESTAMP i
20. ategories and articles respectively Sections The top hierarchy of content in Joomla is composed of sections The simplest way of illustrating the concept of section is as a container inside another container The big container refers to a section and the smaller container refers to categories Section can also be thought as a parent while categories can be thought as children Categories Categories are the second bigger tier after sections in Joomla CMS hierarchy Categories can be thought as the children of the sections A category cannot exist without a section Categories can also be thought to have one or more children know as articles Articles The lowest tier of content in Joomla hierarchy is articles When articles are created they are added in the categories Articles cannot exist without a category Normally the article is what we think as the pages of the website which hold the main content Brenelz Inc 2011 13 3 PROJECT DEFINITION 3 1 Background information Salon Alueen Rotaryklubit is a rotary club organization located in western Finland This organization is composed of three individual rotary clubs Salo Perni and Uskela and all the clubs have close to 150 members summing up from all the clubs The organization has members from diverse professions and they do meet weekly to share ideas and discuss club affairs The Major activity of the organization is to implement successful projects that address the need
21. developed on Joomla CMS as of September 2011 Joomla org 2011 e YLE 1 online newspaper http yle fi uutiset e Harvard University Educational http gsas harvard edu e The Green Maven Eco resources http www greenmaven com 2 4 Installation of Joomla using the JumpBox method There are many ways of installing Joomla on a PC However the method of using a JumpBox server is also efficient A JumpBox is software that makes using server software simple and faster A JumpBox packages an application s software dependencies and application data into a single virtual computer that enables you to focus on the application rather than the details of getting the application to run With the JumpBox you can work offline and upload your work online when done unlike normal cases whereby you can only access your Joomla application when you access your domain provided by your ISP JumpBox 2011 JumpBox relies on a virtualization concept This basically means running a virtual computer inside another computer To install a JumpBox server download visualization software There is plenty visualization software which run on different operating systems If you work on Windows or Linux platform then use VMware and if you are using Mac use the Virtual Box virtualization 11 software as recommended by the Jump Box developers To install Joomla CMS using Windows JumpBox refer to Appendix 3 2 5 Information architecture of Joomla Joomla
22. dia News 125 v Popular EN JFUploader a ea lt eo O MSS 40 jams f PSEKE mmm oN User plugins Cancel Hep Upload Config v Plugins Info Limits Register ing the JFUploader Welcome to the JFUploader ind press Upload to upload LI Upload size 0 KB Size Date index html Testing PDF for Uploads pat Options Add files Remove Resize Original Status File Testing more pdf files docx deleted Picture 14 Locate the upload files3 Your files will be uploaded on a website depending on where you chose to upload them The result will be as Picture 15 e oe Gl http www rotarysalo fi administrator index phpToption com jfuploader amp act upload A Googie m s eo CI HH Apple Yahoo Google Maps YouTube Wikipedia News 125 v Popular BAY JFUploader AQ aa it o e z Plugins Info Limits Register Welcome to the JFUploader load size 0 KB Testing more pdt files docx Testing PDF for Uploads pdt Picture 15 Selecting files to be uploaded Appendix 3 Appendix 3 The highlighted green file is the file that was uploaded to the website The JFUploader can upload many files at one time and of any kind of format and later the uploaded files can be published to the specific location in a system as the publisher desires The JFUploader can be accessed from the admin back end of the system only lt EDhttp www rotarysalo fi administrator index php option com
23. e and publish a report of which specific links are broken The Salo Region Rotary Clubs website was subjected to the broken link test by this agency to verify that the links are working correctly 200 links that were checked we confirmed to work correctly You asked to check the links on this page http www rotarysalo fi Vv A200 response is good This means the link is working B If you see this image the link is not working Check the server response code eg 404 or 500 for an explanation of the problem 404 and 500 responses are explained here Here are the results Checked the links on http www rotarysalo fi Found 22 total links Displaying results 1 10 wv 200 http www redcross fi ajankohtaista uutiset fi FI japani maanjaristys Picture 22 Broken link test 6 5 Result Table 5 shows a summary of all the test results Table 5 Summary of test results Test Result Recommendation Load test Pass Browser test Pass Response time test OK Broken link test OK 29 7 EVALUTION The goal of this thesis was to document activities that were carried out during the development process of a website project The thesis is written through observation of what was implemented and reporting on the results 7 1 System implementation challenges and solutions The most challenging part of the system was to find an extension that could upload many files at once to the sy
24. ed correctly the Welcome to your JumpBox page is shown Click the link to the Joomla administration This should lead you to the administration page as shown below C 192168 128 128 jb welcome html Eva JumpBox Welcome to Your JumpBox for Joomla 1 7 Joomla 1 7 Joomla 1 7 has been preconfigured with the information you just provided If you want to make administrative changes visit the following link Joomla 1 7 Administration To visit the main page of the Joomla 1 7 application use the link below This link is what you would share with other users Joomla 1 7 The default user name and password were also set during configuration they are User Name admin Password Specified during configuration JumpBox The JumpBox Administration Portal allows you to perform various system level tasks To access it visit the following URL https 192 168 128 128 3000 Password Specified during configuration IMPORTANT When you first visit the JumpBox Administration Portal your browser may show an error or warning regarding site security It is safe to accept this certificate and if possible add an exception for this site See the JumpBox SSL Warning FAQ for details Copyright 2007 2011 JumpBox Inc r cu 2 42 A WB 11 16 9 2011 Picture 5 Configured page leading you to the Joomla admin page Step 6 Provide the administration username and password you provided when you were configuring t
25. een ammi sa Tervetuloa Salon alueen pem rotarysivuille tarysivuille Picture 21 Browser test 6 3 Response time test 27 The website was tested against response time by Website Pulse Test Tools This an agency that is located in Seattle United States The organization has labs of servers that checks the response time of a website from all over the world for free All a tester has to do is to put the URL of the website to be tested in their online test tool and then they will run a test and give results The response time test determines the response time of the website when queries requesting for information are sent to the website When the website was tested against response time it was confirmed to be okay Figure 4 below shows summary of response time test result URL tested Test performed from Test performed at Resolved As Status Response Time DNS Connect Redirect First byte Last byte Size http www rotarysalo fi Seattle WA 2011 10 24 15 59 26 GMT 00 00 77 240 25 20 OK 1 639 sec 0 224 sec 0 192 sec 0 000 sec 0 822 sec 0 401 sec 30797 bytes Figure 4 Response time test TURKU UNIVERSITY OF APPLIED SCIENCES THESIS Erick Amenya Oanda 6 4 Broken link test Broken link test is done to spot broken links in a website www 2bone com is a Canadian agency that is located in British Columbia It provides free online tools that check broken links on a websit
26. ent easily which is a big advantage to you and your viewers The fundamental to having a good web content management system is investing in well styled sheets A template is accountable for the basic structure of a website Using HTML CSS and JavaScript can help in creating a good structure of your website What is important is how well content is made available to the end users after it has been retrieved from the database Cartwright D 2005 2 3 Joomla as content management system Joomla is an open source management system which is freely available to the public to use it for their personal or commercial gains Due to Joomla advantages it is used all over the world to develop online applications For instance it is used to develop government applications small business websites organizational websites website or portals personal or family home pages intranets and extranets online magazines among the long list The following are some of the major features of Joomla Installation and administration Installing and configuring Joomla is relatively simple Joomla web based installer enables it to be installed through a few steps It has also been noted to have a rich graphical interface for administering and configuring websites Separation between front end and back end The back and the front end has been vividly separated amp protected with the security authentication mechanism The back end belongs to the administration and
27. entative contacted the company that provided the server space that installed the CMS was only responsible for developing the system on already set up Joomla CMS TURKU UNIVERSITY OF APPLIED SCIENCES THESIS Erick Amenya Oanda 7 2 System improvements The website needs to be migrated to the latest platform of Joomla 1 7 This is because the newer version has more features such as new enhanced security protection Xhtml junction inc 2011 Installing the updated extension needs to be done Even though the current extensions work properly they also need to be checked and upgraded to the newest versions This is because improvement and testing of bugs are an Ongoing process The later the installed version the better it is A special area needs more development All three clubs have secretaries each club being unique there is a need to customize this section to suit more their activities Finally it was a great experience working on such a project learnt many tools for web development as well as documentation skills 31 SOURCE MATERIAL Christianson C Cochran J 2009 ASP NET Content Management System Development Packt Publishing Ltd Suhreed S 2009 Joomla E Commerce with VirtueMart Olton Birmingham Publishing Ltd VMware Inc 2011 Download VMware Player Consulted 16 9 201 1 http downloads vmware com d info desktop downloads vmware player 3 0 Brenelz Inc 2011 Organizing your content Consulted 14 9 2011 htt
28. ges access controls a database style sheets templates output standards TURKU UNIVERSITY OF APPLIED SCIENCES THESIS Erick Amenya Oanda Designers visualize how their web pages will look like to the end user How the images text links and other sections of the web pages will be arranged A basic web page is likely to have a header text Images wrapped in between the text and footer More sophisticated sites might possess different types of pages and each of those pages having its own sections of content In many cases the structure of your databases will be determined by your web content Protecting your website against unauthorized access is vital That is why it s essential to have access controls determining how someone can be granted rights to enter the system and modify the content The basic concept of creating access controls is that of users and groups Major operating system such as Windows Linux UNIX and Fedora controls their systems that way Database is designed to offer an organized mechanism for storing managing and retrieving information that is stored in a CMS When queries requesting for information are run they do retrieve content from a database update them and then store them back for future retrieval A database is made of pages and tables for users Style sheets are responsible for arranging content in the system final front end Having an appropriate style layout in your website can result to view cont
29. he page as shown on the page below BY JumpBox for Joomla 1 6 Bet C 192168 128 128 administrator index php A x g Do you want Google Chrome to save your password Save password Never for this site J Administration Joomla Administration Login Use a valid username and password to gain access to the administrator backend Uno Name Adi Go to site home page Password mm Language Default v Joomla amp is free software released under the GNU General Public License erae o Picture 6 Configuration process TURKU UNIVERSITY OF APPLIED SCIENCES THESIS Erick Amenya Oanda s T Appendix 2 Appendix 2 Step 7 around for administrative tasks If the administration username and password were correct the admin page back end will pop up In the administration page back end is where you will be adding your content and navigating Q 192 168 128 128 administrator index php u Do you want Google Chrome to save your password l Save password Never for this site ra x Administration X Joomla Site Users Menus Content Components Extensions Help A amp None Logged in frontend 1 Logged in backend No messages BB View Site Log out EJ Extension Manager Module Manager JM Puoin Manager n Logged in Users o Template Manager Name Location ID Last Activity Logout Add New Article Article Manager Category Mig Language Manager Menu Manager Super User Administrat
30. i index php option com jevents task day listevents tyear 2011 amp month 10 amp day 27 amp ltemidz1 i53 G Qr Google M HH Apple Yahoo GoogleMaps YouTube Wikipedia News 125 v Popular Y PERNI USKELA INNER WHEEL SALO NUORISOVAIHTO YE 6 VALIKKO lt TAPAHTUMIA Events Calendar Home klubit Thu Oct 20 16 45 6 Sal ibi E j M 06 00PM US Viikkokokous Thu Oct 27 16 45 IPM di lon klu Pet jubi Uskelan klubi 0 Inner Wheel Salo Rotar inta 0 Nuori io Preceding Day Thursday 27 October 2011 Following Day Yhteystiedot Web Links 16 45 18 00 US Viikkokokous by vske a sihteeri Default o FAQ News Feeds Only show my events No G Parana Select Category All categories We have 1 Reset 1623 nE OE EET Picture 17 Screen shot of adding an event page Appendix 4 Click on the add event icon It leads you to a place where you can add your event define when it can be visible by whom and when For instance as shown Picture 18 below NI USKELA INNER WHEEL SALO NUORISOVAIHTO YE G TAPAHTUMIA vents x 9 mda dia 06 00PM US Viikkokokous Thu Oct 27 16 45 06 00PM US Viikkokokous endar G KALENTERI menya E Oanda afault zOU EE EE EE Ses l msi 1 3 4 e t i81 I 139 so 44 Hix 2 amp a I 7 24 25 26 27 24 29 8 I N I am Picture 18 Adding an event to the system TURKU UNIV
31. ing service that lets you load test your website if it can withstand stress load impact generates simulated user traffic to the website for example it might simulate that 100 users are trying to load website pages at the same time While simulating the traffic from these 100 users it also records how fast pages are loaded from the server This gives feedback on how fast a website is when it is being accessed by this 100 users at the same time Salo Region Rotary Clubs website was subjected to load impact test of up to 1000 users accessing the site at one time since the website did not show the 404 error page it is an indication that it did pass the load impact test J Om Gr Yid m MU amp u Yom Vigan s VO Bux Y4 Go zoo gni V Ejoo Vigdwe ue Y v sors sus eT O His C Oloadimpact com view test php te Ox Ga LOAD IMPACT t Tast Recut F 15 54 Te OF a 11001 Picture 20 Load impact test TURKU UNIVERSITY OF APPLIED SCIENCES THESIS Erick Amenya Oanda 6 2 Browser test The website was also subjected to browser test using Microsoft Expression Web 4 Super Preview software A browser test is carried out to ensure that content and website features are in their rightful positions when a user uses any common browsers for example IE Opera Google Chrome Opera Safari The website passed the entire browser test Below in Picture 21 is a test sample result Tervetuloa Salon alu
32. jfuploader amp act upload Ar Google 9 D ae eo QA HH Apple Yahoo GoogleMaps YouTube Wikipedia News 125 v Popular Y ay JFUploader N aa Q C Config User Plugin Cancel Help Upload Config Users Plugins Info Limits Register Checking for previous installation Database tables found using existing settings Successi fully updated database tables to version 2 14 3 Have fun using the JFUploader Welcome to the JFUploader Please select ih foller you want to upload ad the fies tothe Upload queue and press Upload to upia he fies JFUploader Upload folder Jimages PreviousDocuments um Remote 3 files 95 KB Upload Queue Upload size 0 KB Name Size Date index html Testing more pdf files docx Testing PDF for Uploads paf Delete Options Add files Resize Original Upload Status Selected item Testing more pdf files docx Preview not available G Fg 08 v 16 23 18 10 2011 Picture 16 File uploaded TURKU UNIVERSITY OF APPLIED SCIENCES THESIS Erick Amenya Oanda Appendix 4 Appendix 4 Adding an event to the calendar Adding an event to the calendar Login from the administration back end then locate the calendar which is on the right side of the system and click on the date on the calendar you want to add an event to For example want to inform users that on 27 10 will be testing the system this how would add this to the calendar gt http www rotarysalo f
33. management of tasks while the front end belongs to the end user It s possible to submit content to both the front and back end Access control Authenticating and management of tasks depends of which kind of user a group is in Joomla Administrators can create groups and give rights of editing or writing content Publishers have a right of writing submitting editing content written by themselves or the authors while authors have a right of only writing and submitting specific content Extensibility through plugins components and modules Among the biggest features of Joomla is its extensibility feature Joomla CMS has a huge library of plugins components and modules which makes it possible for the users to add some functionality best for the websites Joomla developers have made frameworks that allow them to build applications and run them on the same CMS Nowadays we have a lot of extensions available in Joomla library and they can be downloaded from one source http extensions Joomla org TURKU UNIVERSITY OF APPLIED SCIENCES THESIS Erick Amenya Oanda Search engine friendly URLs Joomla content management system has a capability of generating search engine friendly URLs from its core library of components There are also third party extensions that are capable of managing and generating SEF Search Engine Friendly URLS in the CMS Suhreed S 2009 10 Listed below are some of the online applications and websites that were
34. oks like Le http www rotarysalo fi eo LI HH Apple Yahoo GoogleMaps YouTube Wikipedia News 125 v Popular v SALO PERNIO USKELA NNER WHEEL SALO DISTRIGL 1418 FINLAND ROTARY SALO PERNI USKELA INNER WHEEL G varikko G TAPAHTUMIA Home kut Tervetuloa Salon alueen moram ens 8 Salon klubi 0 Pemi n Hub rotarysivuille US ikkokokous e lan klubi ee Pe Inner Wheel Salo US Viikkokokous Rotarytoiminta 4 0 Nuorisovaihto Yhteystiedot T m on Salon talousalueella olevien Salon Perni n Web Links ja Uskelan rotary klubien sek Inner Wheel Salon 9 aan FAQ yhteinen sivusto Em TwTFS Mutta mit tarkoittaa sana rotary Mita ovat rotary ja Inner Wheel kubit ja miten ne Salon seudulla toimivat l s Q Pana 3456743 Tn T 3 PERUSTIETOA ROTARYSTA 8 siv pdf nikalinkki FIN We have 1 member online What is Rotary 10 41 42 nnn Rotary Minute Youtube video EN How did you get started with Rotary Rotary Minute Kuuntele syd nt si 17 am 19 20 24 22 2 G Us Mew Youtube video EN auttaaksesi muita Salon Rotaryklubi 1948 perustetun 43 j senen klubin presidenttin kaudella 2011 2012 on Markus Submit an Artide Mattila ja sihteerin Ville Elomaa 2012 2013 presidenttin jatkaa Markku 9 Submit a Web Link Mets vuori Klubi kokoontuu Salon Seurahuoneella Asemakatu 1 keskiviikkoisin klo 0 Logout 11 45 12 00 kubiohjekmaan Perni n Rotaryklubi 1963 perustetun
35. open the VMware player setup installer as shown in the picture below Welcome to the installation wizard for VMware Player The installation wizard will install VMware Player on your computer To continue click Next WARNING This program is protected by copyright law and international treaties VMware Player 3 1 223 289 Ka OE 169201 Picture 2 Installation of VMware TURKU UNIVERSITY OF APPLIED SCIENCES THESIS Erick Amenya Oanda Appendix 2 Step 3 After JumpBox server has completed running it will generate the JumpBox console screen as shown below Type the URL shown on the console screen in the browser o oO 21 sua gt C 0192168128128 mitia setup Ex a Picture 3 Configuration page Appendix 2 Step 4 The configuration page shows up if the installation configuration page and the URL were typed correctly Fill in the requested information Provide the name of your virtual computer email address for notification your time zone administrator account password and end user license agreements Then click configure the Application button Your JumpBox will be configured as shown below JumpBox Setup Q 192 168 128 128 initial_setup Ora Configuring the application Please wait ex FP ra m P 2 41 16 9 2011 Picture 4 Configuration process TURKU UNIVERSITY OF APPLIED SCIENCES THESIS Erick Amenya Oanda Appendix 2 Step 5 When the page is configur
36. or 42 2011 09 16 11 47 02 gt Popular Articles 4 e gt Recently Added Articles User Manager Module Manager Extension Manager Language Manager Global Configuration Template Manager Edit profile Joomiai is free software released under the GNU General Public License Version 1 7 0 246 T 169 2011 Picture 7 Joomla admin control panel Appendix 2 Step 8 Click View site this takes you to the user side of the web page You can customize the default page or blow it off and replace it with your content For more information how to work with Joomla Visit http www joomla org J ES lumpBocforioomieiib6e G Home cor X C 192168128128 Buia Font size Bigger Reset Smaller Search JOOMLA ORG SAMPLE SITES MiLJUUa m You are here Home AboutJoomla Joomla Using Joomla Congratulations You have a Joomla site Joomla makes your site easy to build a website just the way you want it and The Joomlal C keep it simple to update and maintain Joomla is a flexible and powerful platform whether you are building a small site for een yourself or a huge site with hundreds of thousands of visitors Joomla is open source which means you can make it work The Joomla Project just the way you want it to This Site Joomla Beginners Upgraders Professionals Home If this is your first Joomla site or If you are an experienced Joomla Joomla 1 6 continues development your first web site you have
37. p brenelz com blog joomla series part 1 organizing your content Joomla org 2011 Joomla content management system home page Consulted 19 10 2011 http www joomla org Yle news corporation 2011 news home page Consulted 7 10 2011 http yle fi uutiset Harvard University 2011 Havard university home page Consulted 8 10 2011 http gsas harvard edu Green Maven Corporation 2011 Grean maven organization home page Consulted 20 10 2011 http www greenmaven com Cartwright D 2005 How to build a content management system Consulted 12 9 2011 http howto techworld com applications 1305 how to build a content management system JumpBox Inc 2011 JumpBox for a content management system Consulted 19 10 2011 http www jumpbox com app drupal7 Xhtml junction Inc 2011 JOOMLA 1 7 ls it advantage of security or a problem to upgrade Consulted 15 11 2011 http www xhtmljunction com blog joomla 1 7 is it advantage of security or a problem to upgrade Torkil J 2011 Joomla 1 5 Database schema Consulted 21 11 2011 http www torkiljohnsen com 2006 04 30 joomla 15 database schema TURKU UNIVERSITY OF APPLIED SCIENCES THESIS Erick Amenya Oanda Appendix 1 APPENDICES Appendix 1 Joomla 1 5 database schema Joomla 1 5 Database Schema extenmon id INT version d VARGHAR 20 Toa NT c template VARCHAR SO c client Ja TINYINT XL EEE S AHUUARIBS EET p IO Hisce HER rumat e ibt Ie er
38. php else gt TURKU UNIVERSITY OF APPLIED SCIENCES THESIS Erick Amenya Oanda lt php echo artxModules document copyright art nostyle gt lt php endif gt lt div gt lt div gt lt div class art Footer background gt lt div gt lt div gt lt div class cleared gt lt div gt lt div gt lt div gt lt div class cleared gt lt div gt p class art page footer gt lt BEGIN Snoobi v1 4 gt script type text javascript src http eu1 snoobi com snoop php tili rotarysalo fi gt lt script gt lt END Snoobi v1 4 gt lt body gt lt html gt Appendix 5
39. rJFUpload Joomla Rotarysalo Site Menus Content Components 0 1 O Logout Akeeba Backup Banner Welcome to Joomla Contacts amp W O Export Content M Congratulations on choosing Joomla as your content management system To help you get started check out these excellent resources for securing your server and pointers to documentation and other helpful resources Add New Article drvens eManacer Section Manaoer Category Manager JFUploader Upload Security News Feeds Config On the Internet security is always a concern For that reason you are encouraged to subscribe to the Joomla d zd f Security Announcements for the latest information on new Joomla releases emailed to you automatically ia o If this is one of your first Web sites security considerations may seem complicated and intimidating There are Plugins three simple steps that go a long way towards securing a Web site 1 regular backups 2 prompt updates to Global Configuration the latest Joomla release and 3 a good Web host There are many other important security considerations that you can learn about by reading the Joomla Security Checklist Media Manager M Info Limits Register If you believe your Web site was attacked or you think you have discovered a security issue in Joomla please do not post it in the Joomla forums Publishing this information could put other Web sites at risk Instead
40. rt Post gt div class art Post body gt Appendix 5 Appendix 5 lt div class art Post inner gt lt div class art PostContent gt jdoc include type message gt lt div gt lt div class cleared gt lt div gt lt div gt lt div class cleared gt lt div gt lt div gt lt div gt lt php endif gt lt jdoc include type component gt lt php echo artxModules document banner4 art nostyle gt lt php echo artxPositions document array user4 user5 art article gt lt php echo artxModules document banner5 art nostyle gt lt div gt lt php if artxCountModules document right gt lt div class art sidebar2 gt lt php echo artxModules document right art block gt lt div gt lt php endif gt lt div gt lt div class cleared gt lt div gt lt php echo artxPositions document array bottom1 bottom2 bottom3 art block gt lt jdoc include type modules name banner6 style artstyle artstyle art nostyle gt lt div class art Footer gt lt div class art Footer inner gt lt php echo artxModules document syndicate gt lt div class art Footer text gt lt php if artxCountModules document copyright 0 gt lt p gt Copyright amp copy 2010 The Rotary clubs of Salo Perni Uskela and Inner Wheel Salo Finland lt br gt All Rights Reserved lt p gt lt
41. s of its community The clubs are focused on improving welfare and helping the rotary club international foundation by participating in programs such as youth exchange program Members of the organization are in additional involved in social services and campaigns for instance eradication of Polio which has been their active agenda since 1980s More information about the specific club history and activities can be found at http www rotarysalo fi 3 2 Current system Currently some of the clubs activities are partially manual The secretary takes memos during the meetings and emails each member the summary of the discussions including the agendas to be discussed in the next meeting then a copy is saved in the organization files In case a new member joins the club and wants to know the previous activities of the club he has to contact the secretary who goes through the club files and provides the member with the required information This process is tiresome and sometimes it can be time consuming depending on the bulk of documents to be searched through If a member misses at club meetings and wants to get details of what was discussed he has to make an inquiry from the members who attended the meeting since the secretary only documents the summary TURKU UNIVERSITY OF APPLIED SCIENCES THESIS Erick Amenya Oanda 3 3 General system requirements To help determine what the system needs and requirements were we held the meetings with
42. signed NO 1 parentid int 11 unsigned NO 0J ordering int 11 NOJ Ol metakey text NOJIII metadesc text NOJI accessl int 11Y unsianed NOI MUL I Ol Table 3 Categories rating jos_content_rating o Field Type Null Key Default Extra o content id int 11 NOJ PRI Ol rating sum int 11 unsigned NOJ 0 rating count int 11 unsigned NO 0 lastip varchar 150 NOJ I o E T Table 4 Categories jos_categories oM oM T MM oM Field Type Null Key Default Extra oM oM T MM oM id int 11 NO PRI NULL auto increment parent id int 11 NOJ 0 title text NO name text NOJIII alias varchar 255 NO image varchar 255 NO section varchar 150 NO MUL image position varchar 90 NO description text NO published tinyint 1 NOI 0 checked out int 11 unsigned NO MUL 0J checked out time datetime NO 0000 00 00 00 00 00 editor varchar 150 YES NULLI ordering int 11 NOI Ol access tinyint 3 unsigned NO MUL Ol count int 11 NOJ OJ params text NO TURKU UNIVERSITY OF APPLIED SCIENCES THESIS Erick Amenya Oanda 21 5 DESCRIPTION OF THE REAL SYSTEM 5 1 Main system screen captures Shown below in Picture 10 is how the home page lo
43. stem to save time The Joomla 1 5 installation suite does not include tools to help upload files A developer has to find a suitable extension that can be able to do the work and install in the Joomla CMS There are few of such a kind that can be located in the Joomla extension directory for example Docs Embed Documents Simple File Lister ARTIO JoomDOC However to find an extension that was compatible with Joomla 1 5 and can upload many files was a hard task Some extension can only take simple file format and very few could take in PDF had to test all the extensions that were available to come up with the best extension that could be appropriate to the system finally settled for JFUploader This is because it can upload many files at once The extension also accepts any file format to be uploaded to the website Complexity of system was an issue Joomla has three parts namely public private and special areas Public refers to the part visible to the public without the need to register into the system The private part refers to the part that is visible to the registered members only and special system area which refers to the part of a system authors club leader secretaries can access decided to implement the public and the private area and some parts of a special area Installing Joomla 1 5 CMS on the web server was a challenge It had many settings and it required other technical skills to install it The club repres
44. t system can be defined as a system that manages content A CMS comes with a number of tools An editor usually WYSIWYG which means what you see is what you get some security tools for granting access to the content in the system and some rights to modify the content a database where content is stored and retrieved when needed and some workflow which dictates how content is managed in the system The website is made of templates which in the front end present the content that the users will be viewing and in the back end are scripts of codes hidden from the end user In many cases programmers designers and editors do work together to make sure that a good site is created A designer is responsible for the create and feel aspect programmers deal with the codes and editors are in command of the content that will be viewed In a content management system restriction on how content is viewed by a specific class of users is mandatory Normally a user management system handles the creation of users and assigning them permissions to access content Navigation and search mechanisms are responsible of how content is retrieved and made easier to be viewed by the end user For a content management system to be useful content should be dynamic and should be displayed to particular users based on navigation choices or specific queries Christianson C Cochran J 2009 7 8 2 2 Creating a content management system To build a web CMS you need pa
45. ted to the other Following are tables extracted from a DB schema for Joomla 1 5 Torkil J 2011 TURKU UNIVERSITY OF APPLIED SCIENCES THESIS Erick Amenya Oanda Table 1 Sections jos_core_acl_aro_sections PRI NULL auto_increment value varchar 230 NO UNI order value int 11 NOI Ol name varchar 230 NO hidden int 11 NO MUL OJ Table 2 Content jos_content 4 Field Type Null Key Default Extra oM do T 4 id int 11 unsigned NO PRI NULL auto_increment title text NO alias varchar 255 NO title_alias text NO introtext mediumtext NO fulltext mediumtext NOJ I state tinyint 3 NO MUL O sectionid int 11 unsigned NO MUL 0 mask int 11 unsigned NO MUL Ol catid int 11 unsigned NO MUL Ol created datetime NO 0000 00 00 00 00 00 created by int 11 unsigned NO 0 created by alias text NO modified datetime NO 0000 00 00 00 00 00 modified by int 11 unsigned NOI Ol checked out int 11 unsigned NO MUL Ol checked out time datetime NO 0000 00 00 00 00 00 publish up datetime NOJ 0000 00 00 00 00 00 publish down datetime NO 0000 00 00 00 00 00 images text NO urls text NO attribs text NO version int 11 un
46. the organization club representatives conducted interviews and participated in the organization meetings to see how the clubs run We also read through their previous websites to gather the information we needed to develop the new website It was proposed that the website should be efficient easy to learn and use The system should be publicly accessible and registered members should have privileges of accessing and retrieving stored club documents such as memos participation lists budgets activity calendars and other related documents when needed They also wanted the overall system to include an email system and a CMS consolidated the problems and wishes to be achieved in the proposed new system into one word to view the overall mental picture of the system needs and requirements as follows Accessibility The club members want a system that they can be able to access from any location and have access to their club information as well as the latest club activities provided that they are connected to the internet Besides that only authorized members can view specific club documents The public can see general information about the club and for the club members They can view more information when they are logged in to the system Bulkiness When it comes to retrieval of past records the bulkiness requires someone to go through a bulk of papers and files The automated online system will facilitate the faster retrieval of data
47. toiminan esittely Salon alueen klubien esittely Muut palvelukohteet Yhteystiedot Figure 1 First level site map 17 The second level site map below is an opened up version of the first lever site map It shows in detail how the parent links relate to child links Salon alueen Rotaryt T pin acne E e a Perni C Pem Y Klubien ohjelmat Inner Wheel Salo Minustako vaihtan perheest mmek Host pe rhe Alueen vaihtant vuosien saatossa J senyys Figure 2 Second level site map TURKU UNIVERSITY OF APPLIED SCIENCES THESIS Erick Amenya Oanda Figure 3 shows specification of a three columned page layout It is a summary of how modules are arranged in the visualized page Right and left module is where components such as login are placed A middle section called main is where content is placed User 3 refers to the header of the page where the logo is placed Top module section is where the main page menus are arranged while breadcrumb is where the title of the page visited appears For details on how each component is arranged refer to appendix 5 Template source code LAYOUT SPECIFICATION USER 4 MODULE POSITION USER 3 MODULE POSITION TOP MODULE POSITION BREADCRUMBS LEFT MODULE POSITION RIGHT NODULE POSITION MAIN CONTENT AREA SYHDICATE LL Ld USER 1 MODULE POSITION USER 2 MODULE POSITION Figure 3 Page layout 19 4 3 Information architecture of
48. ub member the meeting agenda or print them out during the meeting and hand out each member a copy at the end of the meeting This system has downfalls because it s time consuming involves a lot of work on printing and arranging the papers in the right order Salon Alueen Rotaryklubit proposes the need to automate this system in order to curb the above mentioned anomalies in the current system 4 SYSTEM DESIGN 4 1 System specification The system should be able to upload PDF files and other documents It should contain different access levels It was suggested that the website be developed on the Joomla CMS platform and also contain an Email system TURKU UNIVERSITY OF APPLIED SCIENCES THESIS Erick Amenya Oanda 4 2 Site maps Creating site maps before web pages are designed to show clearly how pages are linked to each other This comes with a number of advantages Search engine spiders crawl through your pages they do so by index A well made site map enables the crawlers to find more accurate and updated searches to the user The faster the crawlers are able to navigate through your pages the better the result delivered Having a site map also enables developers to locate content package easily when maintaining a website than having to go through each page to locate specifically the one they are interested in For all those reasons we developed the site maps showing how a page links to each other on the first level site map Rotary
49. v gt lt div class art Sheet body gt lt div class art Header gt lt div class art Header png gt lt div gt lt div class art Header jpeg gt lt div gt lt div class art Logo gt lt h1 id name text class art Logo name gt lt a href lt php echo baseUrl gt gt Salon alueen rotaryklubit lt a gt lt h1 gt lt div id slogan text class art Logo text gt SALO PERNIO USKELA INNER WHEEL SALO lt div gt lt div id slogan text class art Logo text gt District 1410 FINLAND lt div gt lt div gt lt div gt jdoc include type modules name user3 gt lt jdoc include type modules name banner1 style artstyle artstyle art nostyle gt lt php echo artxPositions document array top1 top2 top3 art block gt lt div class art contentLayout gt lt php if artxCountModules document left gt lt div class art sidebar1 gt lt php echo artxModules document left art block gt lt div gt lt php endif gt lt div class art lt php echo artxGetContentCellStyle document gt gt lt php echo artxModules document banner 2 art nostyle if artkCountModules document breadcrumb echo artxPost null artxModules document breadcrumb echo artxPositions document array user1 user2 art article echo artxModules document banners art nostyle lt php if arxHasMessages gt lt div class a
Download Pdf Manuals
Related Search