Home

Redatam+ WebServer Basic Manual and New Miranda Web

1. P REDATAMO Redatam SP REtrieval of DATa for Small Areas by Microcomputer entro de Desarrollo de Redal o S Redatam WebServer Basic Manual and New Miranda Web Application REDATAM SPO is a software system developed by the Latin American and Caribbean Demographic Center CELADE which is the Population Division of the Economic Commission for Latin America and the Caribbean ECLAC United Nations www eclac cl celade Redatam R SP WebServer Class Material July 2011 ENGLISH Index Document contents iii ii 4 I Whatts R SP WebSerVe Picasa 5 1 Advantages of R SP WebServer cooocccccccocccnccconccncccononnnonononnnnnnncnnnnnannnnonnanennnonanennnns 5 1 2 R SP WebServer applications available in Redatam SP ooooonncncccccnnococcncnonnncnnanononos 6 ll New Miranda demonstration application ccoonnccconnniconaniconcnccconancnnnnnnnnnanerenannnnas 9 Meck ANEMIA CMS o 9 11 2 Similarities and differences between the execute panels oocccccccccconcconcncconnnno 10 11 2 a Frequencies Basic Characteristics of Population and Housing topic 14 11 2 b Averages and medians Basic Characteristics of Population and Housing topic 15 11 2 Crosstabs Basic Characteristics of Population and Housing topiC o oooooo 16 11 2 d Arealists Basic Characteristics of Population and HOUSING topic oocccccooooomo 16 11 2 e Population by age ANOS rita A A 17 11 2 f
2. Table and Map Map and Graph and Table Graph and Map Similar to the output format box there are percentage type boxes that are present in sub themes that allow to user to specify how the values frequencies are displayed Two options are available R SP WebServer Basic Manual 1 Absolute numbers row percentage column percentage percentage of total If the user doesn t select any of the options absolute numbers will be displayed 2 Total total selected percentage relative percentage This model is only available for sub themes that involve the selection of variables and categories The option total is used when the user wishes to obtain the results for all the categories of the variable When total selected option is activated the output only displays the selected category With the option percentage the output shows the percentage of the selected category of the total Relative percentage is a ratio of the selected category and the rest of the cases for example if the variable is SEX and the selected category Male the relative percentage would be equal to sex ratio Also more specific cells exist The options available in the New Miranda example can be classified as follows Simple selection cell For the selection of one or more variables or indicators The user must activate the list and click the name of a variable to select more
3. E 55 1 Virtual Directory Creation Wizard Web Site Content Directory Where ls the content you want to publish on the Web site Enter the path to the directory that contains the content for this Web site Path C servers redatamhtdocs Cancel The next step is to assign Access Permissions check only the Read permission as shown in the following picture R SP WebServer Basic Manual Virtual Directory Creation Wizard Virtual Directory Access Permissions Set the access permissions for this virtual directory Allow the following permissions Read _ Execute such as ISAPI applications or CGI _ write Browse To complete the wizard click Next Or type the parameters in the following screen Add Virtual Directory P E Site name Default Web Site Path Alias redatam Example images Physical path C servers redatam htdocs ba Pass through authentication Connect as Test Settings 111 4 e Cgibin virtual directory Repeat the process described in Section V 4 to create another virtual directory with the following parameters Alias cgibin case sensitive Path cgibin subdirectory where the R SP WebServer installation files were extracted for example C servers redatam cgibin Permisos Only Execute NOT Run Scripts Il 4 f Protection for cgibin directory Since the cgibin virtual directory will store all
4. File View Help Microsoft Internet Information Ser Application Server Manager E Ay Start Page p 89 LAGUINAGA LAGUI Recent connections Connection tasks Online resources Connect to localhost IS News and Informatior a Connect to a server IS Downloads E Connect to a site IS Forums Connect to an application TechNet MSDN Name J LAGUINAGA iS News Enable IIS News IIS News is disabled click the Enable IIS News link to get the most recent online news 4 t Ready R SP WebServer Basic Manual 111 4 d Redatam virtual directory To create a new virtual directory in the IIS Manager right click on Default Web Site and then choose New and Virtual Directory The system will then launch Wizard to receive some parameters the first one being the Virtual Directory Alias which should be redatam this word is case sensitive as shown in the following picture Virtual Directory Creation Wizard Virtual Directory Alias Specify a short name or alias for this virtual directory Type the alias you want to use to gain access to this Web virtual directory Use the same naming conventions that you would for naming a directory Alias redatarrl Press Next and then Browse to find the htdocs directory located where the R SP WebServer installation files were extracted for example C servers redatam htdocs as in the picture below
5. Water in the Household Water Origin Recerves Pipe Water or not Floor Polisher Availability Exclusive Working Rooms Housing with Elders In addition to the category list the output displays information on the entity to which the variable belongs label type range alias and group Household Categories Hame i VVATERO Entity HOUSIN Label Vater Onigin Type INTEGER Range 0 4 Alias Group Value Labels O Mo response 1 Public network 2 Vell or noria 3 River creek 4 Other 1 3 0 Programming in Redatam This sub node allows the use of Redatam programming language to execute programs and to download the dictionary and the software R SP statistical processor This sub node gives access to the Redatam SP programming menu As the image below shows the center panel of the application is divided into three cells R SP WebServer Basic Manual Write Redatam SP Program County Code 2 County Mame I 0 999 Segments agri I 0 999 Total agric District Code District Mame RAINFALL I 1 199 Rainfall Aver gt The program syntax is written in the upper left cell The cell on the right hand side includes information on the database dictionary If the syntax contains errors those errors are displayed in the cell below the program syntax lower left corner upon clicking Execute button If the program contains no errors the results
6. person variables sub node Person Variables Type of Activity Categories Counts Cumul Oo No response 18 630 35 70 355 40 Remunerat activity 12 546 24 04 59 74 Familiar not payed 1 406 2 69 62 43 No work 401 0 77 63 20 Unemployed 2 506 4 80 63 00 Seeks ist time 423 0 81 68 81 Housewife 10 570 20 25 389 06 Student 2 807 5 38 94 44 Retired 2 492 4 76 949 20 Disabled 418 0 80 100 00 Total 52 189 100 00 100 00 Processed with Redatam SP lECLAC CELADE 2003 2010 Download Excel format Download PDF format R SP WebServer Basic Manual 11 4 b Graphs The following graph displays the distribution of the New Miranda database by marital status for people aged 15 years or older person variables sub node Marital Status Ml Annulled Ml separated MM Union M Morried Annulled Union Widow Single Married Processed with RecatamsP ECLACICELADE 2003 2010 11 4 c Maps The map below presents another output type available in the New Miranda R SP WebServer application lt was obtained from the dependency ratio and sex ratio sub node and is expressed at district level New Miranda by Districts Dependency Ratio Dependency Ratio C 0 40 O57 E 0 58 0 63 0 64 0 70 EN 0 73 0 87 Processed with Redatam 5P MM 0 58 1 25 ECLAC CELADE 2003 2007 R SP WebServer Basic Manual 11 4 d Redatam SP programs Redatam program syntax is th
7. Filter none WF Build Filter Output Format Table ye Table Title To be typed in by the user Optional Areabreak Level This selection allows the user to specify the level at which the results will be expressed e at the database level or for each of the selectable elements of the database This parameter is optional thus if none of the options are selected the application expresses the results at the database level all database which is the default Geographic Area selection To define the geographic area to which the cases included in the process belong The parameter is optional The user can select one of the predefined options or define the selection by self Up to two user defined selections can be created selecting either 1 or 2 user s selection from the box and making a click on Edit A new window will open for the definition of the selection To save the selection and return to the execute menu the user must click on OK R SP WebServer Basic Manual Filter This option allows the user to control the parameters that are processed i e the universe entire database or parts of the database based on specified criteria The parameter is optional If the user doesn t make a selection then entire database will be taken into account in the process unless geographic selections exist On the contrary the application offers the following options 1 select a predefined filter 2 construct a filter in
8. oooooonnccccnccccococnnccoonncooooonnononononononononnnnnononanncnnnnnns 49 IV 5 0 Modify main file clauses specific to RSP WebServel ooooonncccicocicocconnccnnoncccnonanonoss 51 APPENDIX Answers tO exercises ccccecececeeencececenenceceeenenceceeeneneeeeneneeeseeneneeesaeneneeaeaes 56 R SP WebServer Basic Manual Document contents This user manual contains a detailed description of the R SP WebServer module that is part of the Redatam SP software family developed by ECLAC CELADE The document is divided into four sections In the first section the main characteristics of the R SP WebServer are detailed and the R SP WebServer applications available online in the Redatam official webpage are listed In the second section the New Miranda R SP WebServer demonstration application is described The third section of the manual includes a tutorial for the installation of the R SP WebServer on Apache or IIS servers most common servers Finally the fourth section includes guidelines for enabling the server for other Redatam databases and or R SP xPlan applications R SP WebServer Basic Manual I What is RSP WebServer The main objective of the R SP WebServer module is to assist the National Statistical Institutes NSIs in their task to publish data whether it is from censuses surveys vital Statistics or other sources in a safe way and without extra costs The R SP WebServer module allows for the onl
9. Basic Manual R SP WebServer Basic Manual IV Enable the server for other Redatam databases and R SP xPlan applications This chapter is for enabling the site for R SP xPlan applications Before you organize the site structure for another database it is important that you understand the file structure of the site Be aware that the folders that were created when installing the R SP WebServer see 111 2 exist under the root directory servers redatam as shown in the image below cgbin and htdocs docs folder is optional AE S gt Redatarn E Docs DES These two branches are related They contain all the files that are necessary to run R SP Web applications The first branch under servers redatam is cgibin lt is of private nature as it contains the protected part of the application databases images maps inl files etc The second required branch is named htdocs and it contains all public files and documents help files images etc in general all files referenced by the html files executed in internet In this chapter the R SP New Miranda demonstration application will be used as an example In other words it is taken for granted that an R SP xPlan application already exists This in turn means that the following material is at our disposal inl files structured in a conventional manner images and help files Moreover Apache IIS or another Web Server has already been installed IV 1 Comple
10. processes by simply clicking on a subtheme Once this is done the center panel changes appearance and presents in most the cases an execute panel also called menu However the last three nodes offer other options such as access to downloads links etc 11 2 Similarities and differences between the execute panels The execute panel consists of a series of drop down menus and text boxes which the user must complete or select for specifying the parameters such as variable name area break level geographic area output format etc see following image The panel also includes a Help button to access contextualized technical assistance and an Execute button to run the process itself Clicking the Execute button then allows for the display of the output based on the specified format this can be a table a graph a map or a Redatam program or a combination Some of the boxes are standard and are therefore repeated on all panels irrespective of the theme However in a few cases there are some boxes that are specific to particular sub themes R SP WebServer Basic Manual Table Title Vater in the Household Water Origin Recelwves Pipe Water or not Lar Availability Bicycle Availability Number of Beds in Household Kitchen Availability Occupancy Condition Number Persons Less Servants Fredominant Waterial in Floor Select a Variable Areabreak Level All wt Geographic Area All w Edit
11. Dependency ratio user defined ocoocconccoconnconococononononononononnnannonnnononanennnnnnanons 17 11 2 9 AGENDA dol 18 11 2 h Dependency ratios and or Sex ratio ooccccccccococonnccconnnccnnoonnononnnnnononnnnonnnnonnnnannnnnnnnnns 18 1 2 1 Person characteristics DY age 65 ooncccccononnnonoconoonnonnconnonnonnnnnnanconcnnnnnnnnnnnnnanennnnonos 19 11 2 Household characteristics DY age 65 ooocccccccconcconccononnonnononononononnnanonnnnnnanonnnnonanons 19 11 2 k GOO WOMEN T QUO 20 A A A di 19 11 2 1 Average number of CHIGION ici debia 20 11 2 m FODUIAUION IV SCHOO AGC issa eE AAA E A da elas 20 11 2 n Tables for education variables coooconnnnnccccoononnocononnnonononanonnnnnnannnnnnnnnannnnnnnnnnnnos 20 13 Special SUD Nodes anea aaa 20 11 3 a Dictionary IMIOVINAUON a A AS A A A A EA ls 21 11 3 b Program IN ARCA Vi A e 22 3 C A A 24 11 3 d Redata Mes NOME id a 24 Hie ae 11110 18 8 0 rl 6 CO remem eerie E nee ee oe ee 24 11 4 a A A A O 24 11 4 b A A Ale A R 25 11 4 C MAIS A AA A A AA A AA Ad 25 11 4 d REedata MS WOJ ANS A A E E 26 lll Installation and configuration of R SP Webserver cocooonoccccnococccconoononnnananonnnanannnnos 27 111 1 Download R SP WebsSerVer ocoooccccocccccccnccccnococnccnonoconcncnncnconcnononnnonnnnnnnnnonannnnnaninnons 27 2 STAIR OE WOODS SIE AR 27 IS Apache Web Seve sucia ib 28 111 3 a APACHE INSIANQUON ia A AA A A IAEA AAN AAA 29 111 3 b Check the Apache instalation s
12. EMG inl INL File Ej Comunas ENG mp MsP File Ej Distritos _Cormus_ Eli msp MEP File E Distritos Comu6 ENG msp MsP File E Distritos Comu EMG map MsP File E Distritos Comus Elis mp MsP File Ej Distritos _ Comus _ENG mp MsP File E Distritos _EMNG maxp MsP File es Custom ENG sly SL File E Custom2_ENG shy SL File IV 2 Complete Docs folder The docs folder is for storing all the information with reference to the application that may be useful to you or others in reviewing the application adding another one etc Address Ci ServerslRedatamiDocs Folders x Mame O Ee servers A E IIS4_CGI_Timeout_Setup pdf 5 Redatam E webServer_Install_ENG pdf 2 coibin E webServer_Install_ESP pdf a lt gt P C webServer_Install_FR4 pdf 5 htdocs E webServer_Install_PRT pdf E 5 Temp Wt Indicador Fraccion _ESP doc E B WINDOWS Wh Pagina _Multifilter_ESP doc ES Zenworks E Agregar Base _ESP txt E 4 DYD RAM Drive Di E caracteristicas ESP Ext IV 3 Complete htdocs folder The htdocs folder stores all the public information of the application that is information available on the Internet for the users such as images help documents etc R SP WebServer Basic Manual The images folder of the htdocs folder contains all the standard images of the application R SP logos etc The NMIR folder contains the information specific to the New Miranda application RoHelp stores the hel
13. ENGiin Address E C Program Files Redatarn MMIR Folders a Mame 9 NMR A BaserR 5 BaseR E CookBook CookBook ENG 5 ENG ESP ES ESP FRA D FRA PRT E PRT EI NMIRANDACENSO_ENG inl El E Samples 8 NMIRANDACENSO_Esp inl E Redatam E NMIRANDACENSO_Fra inl E i Reference Assemhlies a NMIRANDACENSO_PAT irl 4 This folder and files are created when Redatam SP is installed R SP WebServer Basic Manual Also the other files associated with the application are found in this directory some of the files are stored in ENG folder Address C Program Files RedatarmNMIRENG Folders X Name J nmr a DataSels_ENG inl 5 Base defines_ENG inl El 5 CookBook A GeneralSections_ENG inl Maps _ENG inl gt ESP a Fages EMG inl FRA al Panels_ENG inl 5 PRT E ja Freferences_EMa inl Next go to the folders that have been created for R SP WebServer and try to locate the file that is equivalent to the main R SP xPlan file You can observe that the main file in English is called the same NMIRANDACENSO _ENG inl and is stored in C servers redatam cgibin RpBases NMIR Address E CServers Redatan coibiniRpbases MIP Folders x Mame E 5 Servers A BaseR E 5 Redatam Sens 5 coibin ESP 5 RpBases FRA 5 MiProyecto PRT E NMR 3 Rpsitemain htm S BaseR ES NMTRANDACENSO ENG inl ENG 8 NMIRANDACENSO_ESP inl gt ESP A NMIRANDACENSO FRA
14. Information ae 4 Variables Build Filter Geographic variables Output Format Household variables Person Variables lt 11 2 0 Averages and medians Basic Characteristics of Population and Housing topic These sub themes include an execute panel for the entry of parameters for the calculation of averages and medians of population and housing variables The standard boxes available include the definition of the table title output level geographic selection filter and output format The additional features of this execute panel are the multiple selection cells one for the main variable and two for additional variables to be included in the rows and columns of the output table Median of Number of ears of Age By Row none By Column none R SP WebServer Basic Manual The user must select one of the quantitative variables included in the first box and if desired one variable for the rows and another one for the columns These two by row or by column are optional and can be left blank Il 2 c Crosstabs Basic Characteristics of Population and Housing topic This sub theme allows the creation of contingency tables for population and housing variables either for each entity separately or combining variables from both entities With reference to the standard cells this execute panel is identical to the sub themes that include frequencies averages or medians As the following image shows t
15. Redatam databases it is wise to establish some access restrictions Right click the cgibin entry in the IIS Manager and select Properties R SP WebServer Basic Manual First you have to change the way to access this directory none should be checked as in the following screen cgibin Properties Virtual Directory Documents Directory Security HTTP Headers Custom Errors The content for this resource should come From O A share located on another computer O A redirection to a URL Local path D servers redatamicaibin O Log visits Read C Index this resource C Write C Directory browsing Application settings Application name cgibin Starting point lt Default Web Site gt cqibi Configuration Execute permissions Scripts and Executables o Application pool DeFaultAppPool o Next choose the Documents tab and make sure that the Enable default content page is not checked disabled Fagibla repel a rhe Diq pa y Caesars Crear Ai RTE ees ada Lies Erabi dat A Eras Cira a A AA id Ca da Li a aa par A eer a Press OK to apply those changes and before closing the IIS Manager verify that the installed IIS version is 6 0 Select Help and then click About 111 4 g New Web Server extension IIS version 6 0 This IIS version by default does not allow CGI applications to be executed thus it has to be changed because this Is precisely the ca
16. To open a new window for example the home page of the organization responsible for the application Portada CAPTION Home PAGETYPE DisplayHtml FILENAME http www ine gob nm NEWPAGE YES The DisplayHtml parameter of the PAGETYPE clause tells the program to go to the page indicated in the FILENAME clause This can be for example a help file stored in the directory of the application or an external web page If you want the page to be opened in a new window include the clause NEWPAGE YES Add to each node FILTER PERCENT and OUTPUT FORMAT FILTER and FORMAT clauses assign a predefined filter and output format for the processing nodes of the program FILTER FILTER_1 FORMAT FORMAT_2 Moreover for processing nodes that involve outputs in real numbers PERCENT command must be included PERCENT PERCENT_1 R SP WebServer Basic Manual The different filter percent and output formats are defined in the GeneralSections in file In the New Miranda sample application the output formats available GeneralSections inl file are as follows FORMAT_1 FORMATCAPTION Output Format FORMATN 4 FORMAT1 HTML Table FORMAT2 GRAPH Graph FORMAT3 SPC R Program FORMAT4 GRAPHHTML Table and Graph FORMAT_2 FORMATCAPTION Output Format FORMATN 8 FORMAT1 HTML Table FORMAT2 GRAPH Graph FORMAT3 MAP Map FORMAT4 SPC R Program FORMAT5 GRAPHHTML Table and Graph FORMAT6 MAPHTML Table and Map FORMAT7 GRAPHMAP Map and Grap
17. renseigne a a 29 Ill 3 c Configure Apache to handle R SP WeCDSCIVEN cccccccccssseeeseeccceeecsseeeseeecesssseeeseeees 30 MEJO R S ADACNC a E A AA AA A Ai 31 111 4 Microsoft IIS Server Internet Information Server cccconncccccnnccccononoconnncconcnconanonos 31 111 4 a TUS TAS ANAM OMA tt o a aia 31 111 4 b CHECKS stallati A A A A il 32 WIA AcUvate HS ADPIC NON siii A A ia 33 WHA FRED AIAN IR DAROCA ba 34 R SP WebServer Basic Manual 111 4 e 111 4 f 111 4 g 111 4 h 111 4 COIDIEVIR IA ANECON esca eric eoeeaeleadereaceceeeeasesaas 35 Pr tection lor COIDIN QIOCIONY siieiwwrcivesorreicurecsinavicoresvalumntivenceusenmebemelenbiteninehanannnretatenies 35 New Web Server extension IIS version 6 0 cccccccoccnncccconnccnoooonocononnconononcnnnnnnononos 36 Restrictions ISAPI and CGI IIS version 7 0 oooonncccnccccccoccnnnnnnnncconononnnonononnnnnanonnnnnnns 37 Check R SP WebServer CXCCUTLION cccccccccccessseesseeccescssaueesseeecessaueusseeeeessssaaaaesseeees 38 IV Enable the server for other Redatam databases and R SP xPlan applications 41 IVT Complete COMIN TOMO a sss caceeicasnccecncontuentesawdesdieocdnehcdwdendesiandssbensbbcexcnondeeanateddioctees 41 1 2 Complete DOCS Older ieaiai ER 43 IVS COMICS Madea TOMI sacos 43 IV 4 Edit the R SP WebServer master INL file occccconcncconncnccncnnnononnncnoncnnonananos 44 PAS MAITE nana es 49 IV 5 a Copy and paste from R SP XPIAN
18. than one variable press CTRL button and select the other variables Two variants exist 1 Selection of variables of one entity 2 Selection of variables from two different entities for example PERSON and HOUSIN The list is displayed in one box Multiple selection cells For the selection of one main variable and two additional variables to be included in the rows and columns of the table each in separate cells The selection is done by activating the variable list and clicking on the variables of the three cells This option corresponds to crosstabs or to averages or medians with control variables Numerator and denominator cells Two cells for the numerator and denominator to be used in the calculation of an indicator The user must activate one of the options available in the numerator cell and another one in the denominator cell Such a selection would apply for the construction of indicators such as dependency ratio Variable and category selection cells One cell for the selection of a variable and a second cell for the selection of the categories of the selected variable The user may select more than one category however only one variable may be selected Finally there are sub themes that do not include specific cells in their execute panels This is the case for example when the process involves an indicator that has already been calculated such as average number of children born ll 2 a Frequencies Basic Characterist
19. the box below or 3 use the expression builder option that is activated by clicking the Build filter button ef Athos icelade cepal org coibin Rpw ebEngine exeDefFilterEx BASE NMIRENG Filter JEJE L JLe Jl JE JE NMIF COUNTY DISTRICT hl The image above shows the expression builder window with Filter and Entities boxes Variables Labels OK and Cancel buttons and a toolbar with arithmetic connectors such as and OR To construct a filter the user must select an entity by clicking on the desired entity from the entity list of available entities Next click Variables button and from new the box that opens select the variable A double click on the variable name passes it to the Filter box at the upper part of the window where the expression will be written The user must then choose the operator to be used either using the buttons of the toolbar or typing directly in the box A click on the Labels button opens the category labels list The category value is selected either with a double click or simply writing the value after the operator If the expression uses more than one variable AND or OR must be used to join the two or more conditions Finally the filter is activated by clicking OK The following image shows the construction of a filter for persons who are attending school R SP WebServer Basic Manual le https celade cepal or
20. 56 2 210 2015 email redatam eclac cl Databank CELADE The link to censuses on the website gives access to a list of countries that have made avallable the microdata of one or more Population and Housing Censuses utilizing R SP R SP WebServer Basic Manual WebServer These applications have been developed by the NSlIs with the support of CELADE The applications are available on the NSI websites and or the ECLAC server as a mirror site or at the request of the National Statistical Institute CELADE website also includes links to R SP WebServer applications for obtaining indicators online For example e ICPD Indicator system with comparable information for countries of Latin America and the Caribbean which allows the follow up of the ICPD Programme of Action Cairo 1994 and the Regional Plan of Action subscribed by the countries of Latin America in 1996 e SISE Regional System of Indicators on Ageing The system contains comparable sociodemographic information for elderly for countries of Latin America and the Caribbean e SISPPI Sociodemographic Indicators System for Indigenous Peoples of Latin America SISPPI This system contains sociodemographic indicators built from the 2000 round of population and household census The sociodemographic indicators were selected emphasizing ethnic cohort and gender gaps 2 CEPAL Indicators processing on line O r CC i i i i i i e e
21. CENSO ENG inI PAGETYPE BASE NMIRPRT CAPTION Portugu s INL RpBases NMIR NMIRANDACENSO PRT inl PAGETYPE BASE NMIRFRA CAPTION Francais INL RpBases NMIR NMIRANDACENSO FRA inl PAGETYPE BASE Four sections can be identified INMIRESP NMIRENG etc 1 CAPTION clause identifies a name in this case the language to be displayed on the web page 2 INL details the location and name of the main inl file 3 PAGETYPE indicates that it is a database 3 HR parameter is equal to introduce a horizontal line R SP WebServer Basic Manual Exercise 2 How would you proceed to obtain the following results Nueva Miranda IV 5 Main file The following step is to define for each database the main file that permits their execution in R SP WebServer In R SP xPlan the main file has extension inl Within this file the thematic structure of the application is defined Moreover the other inl files that make up the application are listed Thus the main file already exists and we only need to make some modifications in it So instead of creating we will migrate the files from R SP xPlan to R SP WebServer IV 5 a Copy and paste from R SP xPlan In our example based on the New Miranda database the first thing to do is to identify the files of the R SP xPlan application These files can be found in Program Files Redatam NMIR and the main file if the English version is called NMIRANDACENSO
22. R SP WebServer Windows Internet Explorer Oo Y a http ocalhost cgibin RpWebEngine exe PortalAction Archivo Edici n Ver Favoritos Herramientas Ayuda We le Ba CEPAL CELADE R SP WebServer CEPAL CELADE Bases de Datos Disponibles Nueva Miranda Sitios Online Proyectos Especiales After adding a database group we need to define the sections of the group and the databases within them Below the NMIRGROUP New Miranda is detailed NMIRGROUP CAPTION Nueva Miranda PAGETYPE GROUP ITEMS 6 ITEM1 HR ITEM2 NMIRESP ITEM38 NMIRENG ITEM4 NMIRPRT ITEM5 NMIRFRA ITEM6 Basically four parts can be distinguished 1 Group name within brackets NMIRGROUP in the example 2 Expression that identifies the group in the R SP WebServer database list CAPTION Nueva Miranda 3 Section type with PAGETYPE command GROUP and R SP WebServer Basic Manual 4 The number of elements in the group ITEMS clause and the denomination ITEM clause completed with a sequential number and followed by a database name In this case the age type is GROUP Other options are BASE in case of a database or DISPLAYHTML The following sections of the WebServermain in file show how to establish the sections corresponding to each database that make up the NMIRGROUP group NMIRESP CAPTION Espa ol INL RpBasesINMIRINMIRANDACENSO_ ESPiinl PAGETYPE BASE NMIRENG CAPTION English INL RpBases NMIR NMIRANDA
23. To obtain the desired output format in the first place observe if the option is included within the available output formats defined in the GeneralSections inl file The option is identical to the format 2 R SP WebServer Basic Manual FORMAT 2 FORMATCAPTION Output Format FORMATN 8 FORMAT1 HTML Table FORMAT2 GRAPH Graph FORMAT3 MAP Map FORMAT4 SPC R Program FORMAT5 GRAPHHTML Table and Graph FORMAT6 MAPHTML Table and Map FORMAT7 GRAPHMAP Map and Graph FORMAT8 MAPGRAPHHTML Table Graph and Map Next you need to locate the node Person Variables node in the main inl file of the application NUIRANDACENSO_ ENG and change the parameter of the format clause FREQPOB CAPTION Person Variables NODETYPE FREQUENCY NODESTYLE FREQUENCY DEFAULT NODESHOW YES ROWN ROW_PER1 ABKN ABK_1 FILTER FILTER_1 FORMAT FORMAT_ 2 FORMAT FORMAT_ 2 HTMLHELP redatam RpHelp recorriendolabasededatos htm Save the file and refresh the application page
24. abases node or by individual topic You can e Create an enterprise intranet i Get help with tasks IIS integrates proven Internet L bout ti standards with Windows so that earn ANOU ever e a LE using the Web does not mean Consult reference material having to start over and learn new ways to publish manage or develop View code samples For Windows Vista 7 or Server 2008 the main screen should be as follows QI57 Opera File Edit View Bookmarks Widgets Tools Help E New ob CA Y YE gt p Y 27 http localhost 2 Ly G Google x 60 R SP WebServer Basic Manual Otherwise it may display the default page that was designed by the webmaster If there are errors in the displayed page check the IIS configuration or refer to the Microsoft documentation at htto www microsoft com 111 4 c Activate IIS application To activate the IIS application you have to use the Internet Information Server Manager which is found through the Windows Control Panel Administrative Tools and Internet Information Server Manager Alternatively you can select Start click Run and in open type inetmgr and click Ok The below screen will be shown El Default FTP Site Running nf Default Web Site Running HA Default FTP Site iss Default SMTP Virtual Server Running H 3 Default Web Site Default SMTP Virtual Server For IIS7 the screen should be as follows vers ou re IE e
25. atic structure the left side panel of the image Population and housing Population structure Elderly Fertility Education Dictionary information Programming in Redatam Documentation LO SS YS Each one of these themes also called nodes is divided into sub themes and these in turn to a specific processing type For example Population and housing is divided into the following sub themes e Basic characteristics frequencies means and medians R SP WebServer Basic Manual e Basic characteristics cross tabulations e Basic characteristics arealists Population structure is divided into four sub themes Population by sex and age group Dependency ratio user defined Age distribution Dependency ratio and or sex ratio The following sub themes are included in the Elderly topic e Person characteristics by age 65 e Household characteristics personas 65 Fertility has two sub themes e Children lt 5 Women ratio e Average number of children Education also has two sub themes e School age population e Tables for education variables Dictionary information includes information on the variables included in the Redatam database six subgroups The Programming in Redatam has three subgroups Finally the Documentation topic gives access to the help files and Redatam webpage Each of the sub themes involves specific processes The user can get access to the
26. ation by age and sex The population by sex and age sub node offers three tabulation options by five year age groups by single years or by major age groups Age Variable rears 4ge Groups k Title filter areabreak level and geographic selection boxes are standard The only special characteristic is found in the output format options Graphs are replaced by age pyramids 11 2 Dependency ratio user defined In the dependency ratio execute menu the user defines the numerator and the denominator for the indicator to be calculated As the following image shows first the grouping format for the variable age must be selected Next the user must define the age ranges that make up the numerator and the denominator Numerator Denominator brears Age Groups se Age by Broader Groups Age by Broader Groups 0 14 rears Age Groups 15 64 ho In addition to the standard cells title filter output level and geographic area a cell for the selection of the output type is offered The user can select between Indicator and Indicator and cases R SP WebServer Basic Manual The second option displays in two separate columns the counts for the denominator and denominator Output Type Indicator Indicator Geographic Aren Indicator and Cases l Il 2 g Age distribution In the variable selection box the user can choose between larger age groups or five year age groups The user can select the age groups o
27. ciales Encuestas de Hogares Encuestas DHS Estad sticas Vitales Encuestas Agr colas Censos Agropecuarios Encuestas Industriales Estadisticas Educativas When clicking any of the options on the left hand side you will find out that in fact they are not databases but groups of databases Click on Nueva Miranda New Miranda and the following window will be displayed lt shows the databases available in the four languages mentioned earlier R CEPAL CELADE R SP WebServer Windows Internet Explorer Ge yy A http focalhost coibin RpwWebEngine exe PortalAction 1 X Pe gt ad 1a gt gt w k A R CEPAL CELADE R 5P WebServer fp amb y P gina Qf Herramientas CEPAL CELADE Bases de Datos Disponibles Nueva Miranda Nueva Miranda Sitios Online Censos de Poblaci n Espa ol English Proyectos Especiales Portugu s Francais Encuestas de Hogares WebMaster redatam cepal org Copyright 2002 2007 Centro Latinoamericano y Caribe o de Demograf a CELADE Division de Poblaci n de la minig CEPAL Estad sticas Vitales Tel 56 2 210 2021 Fax 56 2 208 0196 Casilla 179 D Santiago Chile Encuestas DHS Encuestas Agricolas Censos Agropecuarios Encuestas Industriales Estad sticas Educativas The number of clauses in the WebServermain inl file might make you think that the task of creating a new entrance for the application is complicated However it is simpler than it see
28. d the R WebServer_V4Rev00 exe file to any temporary directory in your hard disk the version number 4 and or the revision number 00 will be changed as new versions revisions of the software become available 111 2 Install R SP Webserver Create a new folder on the C disk and name it Servers C Servers and within this folder create a new folder called redatam C servers redatam It is important that you have read and write permissions to this disk Please contact your Network Administrator if you experience any problems creating the folders on your disk Extract the installation files by executing the R WebServer_V4Rev00 exe file double click on the filename in the c servers redatam directory The whole structure of the main installation directory should be as shown in the picture below 1 You can use another disk as well as different directory names However be careful to change accordingly the remaining instructions in this document R SP WebServer Basic Manual mm y a fn Ti AJ oi EE Ho DD fh The Redatam directory is divided into three folders 1 cgibin contains the Redatam databases and this is the protected part of the installation 2 docs contains all the documentation and 3 htdocs is the visible part of the application and can be recognized by the users through its alias redatam 111 3 Apache Web Server This chapter is a quick guide for the users who want t
29. e processing options by the Web Site administrator This characteristic contributes to the management of the identification of the users their entry options and eventually the possibility of a nominal payment These alternatives help to avoid the spread of illegal copies of the databases Furthermore R SP WebServer is easy to implement If an R SP xPlan application is already available the steps to convert it to a R SP WebServer application are only few 1 2 R SP WebServer applications available in Redatam SP In the Redatam official website http www eclac org celade redatam a list of R SP WebServer applications can be found They are organized in three major groups 1 Online censuses 2 Online indicator systems and 3 Demonstration application CEPAL REDATAM ON LINE Mozilla Firefox Sele File Edit view History Bookmarks Tools Help lat CEPAL REDATAM OM LINE Z y si http Juwew eclac org egi bin getprod asp xml fredatamnoticias paginas __ T celade P tt CELADE Divisi n de Poblaci n CEPAL Madea IN OrinNa Software para procesar y mapear datos de censos y encuestas para an lisis local y regional REDATAM ON LINE Online census Indicators processing on line On Line Redatam in the countries WebServer Documents amp Manuals Centro Latinoamericano y Caribe o de Demografia CELADE CEPAL Casilla 179 D Santiago Chile Training Fax 56 2 208 0196 Tel
30. e fourth output type option The following image shows the program obtained as a result of the crosstab of 5 year age groups by education type RUMDEF Job SELECTION ALL TABLE ttito AS CROSSTABRS OF PERSON EDGING BY PERSON EDT YPE OMITTITLE DECIMALS 2 FOOTMOTE Processed with Redatam sP ECLACICELADE 2003 2010 R SP WebServer Basic Manual lll Installation and configuration of R SP Webserver The purpose of chapter is to serve as a quick guide for the R SP WebServer installation either on Apache web server or on Microsoft Internet Information Server IIS The choice of the web server depends on the user s working environment and or his her preferences The chapter is designed in such a way that It is not necessary to have any previous knowledge on any of the web servers Apache or IIS The users who are familiar with the servers can adjust the installation according to their needs The following two chapters describe how to download and install the R SP WebServer application After that each of the Web Servers Apache or IIS are described and finally it will be shown how to check the application and modify it to add new Redatam databases 111 1 Download R SP Webserver The most common way to obtain the R SP WebServer is by downloading it from the official REDATAM web site at http www eclac cl celade redatam In the Updates section you will find a link to the latest version of the software Downloa
31. f interest Moreover the user can select which values are to be displayed in the output table absolute numbers or percentages Select one or more conditions Fears Age Groups Age by Broader Groups Selected Total Fercent Relate Percent Values to include inthe output table The rest of the cells are standard The output formats available include maps 11 2 h Dependency ratios and or Sex ratio This sub theme is for obtaining two indicators dependency ratio ratios and sex ratio The indicator or indicators of interest must be selected from the cell as shown below De Ratio Indicators to include Sex Ratio The rest of the cells are standard The output formats combine tables graphs and maps R SP WebServer Basic Manual 11 2 Person characteristics by age 65 This sub node offers frequencies to be calculated for persons aged 65 years and above Once the variable of interest is selected the user must select the variable categories Select one or more conditions Marital Status Mo response Married Limon single MAC separated nnulled In addition to the standard options a box for the selection of cell percentages is available Total Values to include in the output table m Fercent Relative Percent 11 2 Household characteristics by age 65 This sub theme offers a set of outputs including only persons aged 65 years or above according to their housing characteristics It wo
32. g cgibin ApwebEngine exe DefFilterEx Filter PERSON ATTEND Jl L JLe Jl Je Jobs Entiies Kinship Relationship dl Last Course Approved COUNT Literacy Level DISTRICT Marital Status AREA Number of Children Alive Never attended BLOCK Number of Children Born Alive HOU SIN Number of ears of Age Occupation Category Dccupation Job Type of vy ork Sicha The following sequence was followed 1 HY a a Selection of the PERSON entity in Entity box Click on Variables button Selection of the variable School Attendance from the list of variables in the database A double click on the variable name Click on button to specify the criteria for selection Click on Labels button Double click on Attending Click on OK Output format This allows the users to choose the display format of the output from a list of available display options given in the output format list Once the user clicks Execute the selected output will be displayed in a new window The system offers two output format types that vary depending on the sub theme 1 Table Graph Table and Graph and R SP Program This format has two variations that refer to the graphs In some cases the graph must have up to two variables In other case the graph to be displayed as an age pyramid Table Graph Map R SP Program Table and Graph
33. h Description Allow extension path to execute Cancel R SP WebServer Basic Manual The name suggested for the restriction is R SP WebServer the file you need to add is RpWebEngine exe located in cgibin eg C servers redatam cgibin and select Allow extension path to execute as shown in the following screen Add ISAPI or CGI Restriction 9 Ex ISAPI or CGI path C servers redatam cgibin RpWebEngine exe Description R SP WebServer Allow extension path to execute Repeat the same procedure for the file WebUtilities exe as the suggested restriction name R SP WebuUtilities The next step always in the IIS configuration is to go to the level of cgibin Server and go to Handler Mappings select Edit Feature Permissions and select Scripts and Execute as shown in the following figure Permissions Read 4 Script 4 Execute Cancel 111 4 1 Check R SP WebServer execution Using any Internet browser of your choice access the REDATAM page by typing the following http ocalhost redatam If you followed all the previous steps exactly then the screen should display R SP WebServer Basic Manual Sr a2 Redatam Community Informa Census and Statistics Disemination Microdata Mayor explotacion de la informacion a gran velocidad Agregated Data Some source or data series integrates Output Tables Graphs Thematic Ma
34. h FORMAT8 MAPGRAPHHTML Table Graph and Map FORMAT_ 3 FORMATCAPTION Output Format FORMATN 4 FORMAT1 HTML Table FORMAT2 GRAPH Graph up to 2 variables FORMAT3 SPC R Program FORMAT4 HTMLGRAPH Table and Graph up to 2 variables in the The processing node of frequencies of housing variables of the New Miranda application uses the FORMAT _1 option FREOVIV CAPTION Housing Variables NWODETYPE FREQUENCY NODES TYLE FREQUENCY DEFAULT NWODESHOWU YES ROWN ROW WIW ABEN SABRK 1 FILTER FILTER 1 FORMA T FORMAT 1 R SP WebServer Basic Manual Thus the following list is displayed to the user Vater in the Household Water Origin Receives Pipe Water or not Lar wallability Bicycle Availability N Number of Beds in Household Kitchen Availability Occupancy Condition Number Persons Less servants Predominant Material in Floor Areabreak Level All w Filter none ka Builg Filter Graph R Program Table and Graph Add online help file to each node htm file Each processing node must also include a clause that determines the path and name of the corresponding help file as shown below HTMLHELP redatam RpHelp frecuencias htm These help files must have been created beforehand and saved in RpHelp folder Modifications in FRACTION type processing nodes Introduce the following clauses and parameters in the nodes whose type is FRACTION OUTPUTCAPTION Output Ty
35. he difference is given by the boxes where the row and column variables are selected Select a Variable water in the Household bi By Column Predominant Material in Floor v The selection of a variable from each of the two drop down boxes is obligatory In the Combination sub node the variable lists provided in the two drop boxes are alike and include all the variables from both entities The execute panel also provides the option to select between row column or total percentages If none of the options are selected the output displays absolute numbers In this execute panel the options graph and table and graph only accept up to two variables 11 2 d Arealists Basic Characteristics of Population and Housing topic The arealist sub theme is for producing a frequency distribution of all the categories of the variable for each geographic area As it relates to the standard cells this execute panel is identical to the subthemes mentioned above The difference lies in the box where the variables are selected Also a new output format option is available namely maps also in combination with tables and graphs R SP WebServer Basic Manual Ferson aria Occupation Category school Attendance Last Course Approved Number of ears of Age Variables to include Marital Status bears Age Groups Type of Education Number of Children Born Alive Output Level Enumeration County k 11 2 e Popul
36. http iiey eclac org cgi bin getprod asp xml redatarm noticias paginas E 2 D System oF Indicator P tt CELADE Divisi n de Poblaci n CEPAL R JJTII LIYE Software para procesar y mapear datos de censos y encuestas para analisis local y regional Indicators processing on line system of Indicators with comparable information REDATAM for countries of Latin America and the Caribbean Indicadores para _ ee Family which allows the follow up of the ICPD Programme B del of Action Cairo 1994 and Regional Plan of Action AID Acci n e subscribed by the countries of Latin America in ge la LA Download 1986 Redatam On Line This System of Indicators that contains Th a e 3 comparable information for countries of Latin Indicadores patas Redatam in America and the Caribbean allows the followup of ES el seguimiento a the countries the Platform of Beijing Y International Conference de la Plataforma on Woman Beijing 1995 de Beijing Documents More info vaw eclac climujer amp Manuals Training Regional System of Indicators on Aging SISE The 4 Sistema Regional system contains comparable sociodemographic E so information for elderly tor twenty countries of Latin je IS Databank sobre Envejecimiento America and the Caribbean and it allows to process Information for two census periods 1990 SISE R SP WebServer Basic Manual Finally the website includes a R SP WebSe
37. ics of Population and Housing topic The execute panel of these sub themes Housing variables and Person variables allows the user to generate simple frequencies of housing variables person variables or both R SP WebServer Basic Manual For each sub theme the execute panel is exactly the same the only difference would be the in the variables available for selection Naw Miranda Demonsiraidon Apoliconon eraurad with ir SA Po POPULATION AND HOUSING sf Basic Characteristics Housing Variables Person Variables AVerages Mediana Parameter Definition Crosstabs of Variables dida sii Household Variables Person Variables Table Title Combination Arealist of Variables Type of Activi A Household Variables School Attendance Ferson Variables iiin Last Course Approved Number of Years of Age Select a Variable Mantal Status POPULATION STRUCTURE 5 Years Age Groups Population by Sex and Age Groups Occupation Job Type of Work Dependency Ratio User defined Number of Children Born Alive bik hess dare Children Bome Last Year Dependency Ratio and or Sex Ratio Sn 3 Children during Last Year ELDERS Areabreak Level All Person Characteristics by Age 65 Household Characteristics Persons 65 Geographic Area All v Edit FERTILITY INFANT MORTALITY ChidrensSiAomen Ratio Filter none Children Average EDUCATION Population in School Ages Tables for Education Variables Dictionary
38. in the html files RpOutput_ENG htm etc are located under htdocs NMIR The New Miranda application exists in four languages which explains the folders ENG ESP FRA and PTR Servers 2 3 Redatam gt E coibin Rpbases G NMR BaseR ENG ESP gt FRA G PRT The first folder BaseR contains the database files as is shown in the image below BR hmirPrt dic Archivo DIC BE nimirera dic Archivo DIC BA nimireso dic Archivo DIC BE himirena dic Archivo DIC E NMIRO157 rbf 4KB Archivo RBF E NMIRO156 rbf 4K Archivo RBF E NMIRO155 rbf Bo Archivo REF es uMIRO154 rbf 1KB Archivo REF E NMIRO153 PTR 1KB Archivo PTR NMIRO152 rbf E Archivo RBF E NMIRO151 rbf 4KB Archivo REF E NMIRO150 rbf KB Archivo RBF In the remaining folders ENG ESP FRA and PRT you can find maps geographic selections and images corresponding to each language version A R SP WebServer Basic Manual We will only make reference to the English version of the New Miranda application folder ENG In the following image shows the files that are found in this folder Gel titulo ENG bmp BMP File Gab top redatam NM_EMG gif GIF File E Ppoutput_Eldt htm HTML Document 188 DataSels_ENG inl INL File 18 defines ENG inl INL File a GeneralSections_ENG inl INL File a Maps_ENG inl INL File 18 Pages_ENG inl INL File 18 Panels_ENG inl INL File a Freferences _EMG inl INL File 14 Styles_ENG inl INL File a Utilities
39. ine processing of Redatam databases stored on a server through Intranet or Internet without the users having direct access to them It enables the user to perform tabulations that are carried out from the server through an application via predefined pages This processing simulates the functions of the R SP Process module R SP WebServer applications work through files with an INL extension the same files that characterize the R SP xPlan module These applications comprise of thematic nodes that permit different types of outputs For example there are predetermined outputs that allow users to generate tabulations such as frequencies crosstabs means medians maximums minimums counts area lists or specific indicators defined by the user R SP WebServer applications also include the possibility of online processing utilizing the Redatam programming language In R SP WebServer the outputs can be displayed through geographic selections filters or user defined areas Results of analyses can be displayed as values frequencies in tables as Charts or maps The user can specify how the results are displayed from those three formats In addition another output type available is the Redatam program When obtaining the outputs through online processing using Redatam programming language the user has the same access that R SP Process to the information contained in the database In addition R SP WebServer applications provide the possibility t
40. inl FRA A NMIRANDACENSO_PRT inl S PRT comunaS_dist dbf The associated files also maintain the same names and are stored in the ENG folder in C servers redatam cgibin RoBases NMIR ENG Address B C Servers RedatamcgibiniRpbases NMIR ENG Folders x Mame E Cy Servers A 188 DataSels_ENG inl I ma Redatam A 18 defines ENG inl E 5 coibin 18 Generalsections_ENG inl 5 RpBases a Maps_ENG inl E 5 MiProyecto 18 Pages_ENG inl E MIR 18 Panels _ENG inl 5 BaseR a Preferences ENG inl B 18 Styles _ENG inl 5 ESF 1 Utilities ENG inl 3 FRA Ej Comunas _ENG msp A R SP WebServer Basic Manual If you open both files named NMIRANDACENSO_ ENG inl for R SP xPlan and R SP WebServer you can observe some small differences The R SP WebServer inl file contains some additional clauses such as FILTER FORMAT and HTMLHELP IV 5 b Modify main file clauses specific to R SP WebServer The following sections detail the modifications that must be done in the main file and one modification that must be done in the Preferences inl file Redirect or call pages of other sites with DisplayHtml Supposing that Help and Front Page are included as entries in the thematic structure of the R SP WebServer application the modification would be 1 To redirect the application page to a help file Ayuda CAPTION Help PAGETYPE DisplayHtml FILENAME redatam RpHelp index html 2
41. lias cgibin C servers redatam cgibin Finally you must define the options for these two folders htdocs and cgibin This is done by copying the following sections after the definition of the directory cgi bin lt Directory gt lt Directory C servers redatam htdocs gt Options Indexes FollowSymLinks AllowOverride None Order allow deny Allow from all lt Directory gt lt Directory C servers redatam cgibin gt AllowOverride None Options None Order allow deny Allow from all lt Directory gt R SP WebServer Basic Manual Save the httpd conf file See Annex for more details 111 3 d Restart Apache Look for the Apache icon in the lower right Toolbar and left click it to show the existing options Select Restart to restart the server and activate the new scripts added above Alternatively you may go to the Start button select Program Files Apache Control Apache Server and Restart 111 4 Microsoft IIS Server Internet Information Server Like the Apache web server installation IIS installation is also very simple The difference between them lies in the configuration For the IIS s the configuration is done through its service manager a wizard instead of having to edit the configuration file as in the case of Apache 111 4 a HS installation In order to check if IIS is already installed go to the Windows Control Panel choose the Add Remove Programs option and then use the Add Remo
42. ms Below the first lines of the WebServermain inl file are displayed R SP WebServer Basic Manual NODES 111 NODE1 NODE2 NODE10 NMIRGROUP NODE11 NODE20 ONLINEGROUP NODE21 NODE40 SPECIALGROUP NODE41 NODE30 CENSUSGROUP NODE31 NODE50 ENCHOGGROUP NODE51 ITEM60 DHSGROUP ITEM61 NODE70 ESVITGROUP NODE71 NODE80 ENCAGRGROUP NODE81 NODE90 CENAGRGROUP NODE91 NODE100 ENCINDGROUP NODE101 NODE110 ENCEDUGROUP NODE111 Note that the NODES clause is followed by a numeric parameter which is for indicating the maximum number of database groups or entries available NODE clause is completed with a number in a sequential order 1 2 10 11 etc and the following parameter can either be an asterisk or an expression An asterisk indicates a blank line while an expression represents a database group nickname for internal use For example the New Miranda database group is named NMIRGROUP The number of NODES 111 exceeds by large the real number of nodes However this is done on purpose as it is easier to add new databases between existing ones without the need to rewrite the sequential order for example adding NODE15 between NODE10 and NODE20 R SP WebServer Basic Manual Exercise 1 The following image shows a change in the R SP WebServer group list What changes would you introduce in the WebServermain in file to obtain the same result R CEPAL CELADE
43. n and literacy level In the execute panel there are three cells for the identification of the variables of interest 11 3Special sub nodes In the New Miranda sample application the sub nodes belonging to the nodes Dictionary information Programming in Redatam and Documentation don t include an execute menu as described above The following sections describe the other options offered by the application R SP WebServer Basic Manual Il 3 a Dictionary information As the name indicates the sub nodes of this node provide information on the dictionary Once the user clicks any of the four sub nodes a list with all the variables including entity names labels type alias and group is displayed The sub nodes are All variables Geographic variables Household variables Person variables The image below displays a list of the sub node Geographic variables Geographic Variables fp leony fommna E E ap foon fome CN E fa come fane e E 0 af fen a CN E af fen foma CS 0 ofaa O o A E e ap fpa fae CN E C7 f fea e jaa fe e fe O ES E To get access to a list with the variable categories the user must select the Household or Person categories sub node and select a variable or variables from the available list and click the Execute button 2 R SP WebServer Basic Manual Select one or more Variables press Control key Type of Family 1 Type of Housing Material of External Valls
44. nter your server s information 111 3 b Check the Apache installation Once installed the Apache server will be automatically started and ready for use Look for the Apache icon in the lower right Toolbar to verify it s connected Using any Internet browser access the default Apache page by typing the following in your browser s address box http ocalhost Depending on the Apache version installed a page similar to the following should appear on your screen R SP WebServer Basic Manual y DS EE File Edit View Bookmarks Widgets Tools Help Z New tab 4 E gt E Y 3 http focalhost hdl It works 111 3 c Configure Apache to handle R SP WebServer Using any text editor open the httpd conf file located under the conf directory under the Apache installation directory C Program Files Apache Group Apache2 conf You can also access this file by selecting it directly from the Apache group from the main menu Two modifications must be done one for Redatam to be recognized by Apache and another one for executing it through a script In the Apache 2 2 version the place where these modifications must be done is identified by lt IfModule alias _module gt section Within this section closed with lt IfModule gt and before the ScriptAlias command add the following text Alias redatam C servers redatam htdocs For Redatam ScriptAlias add the following after ScriptAlias command cgi bin ScriptA
45. o incorporate metadata such as documents with descriptions on the characteristics of the data source the questionnaire and methodological manuals Help files and links to organizational WebPages can also be included 1 1 Advantages of R SP WebServer R SP WebServer offers a set of advantages both for the user and for the organization responsible for its implementation From the users point of view the main benefit is the ease of use of the application and the processing speed As will be demonstrated later in this manual the application is designed in a way that both persons with no experience in Redatam and more advanced users can take advantage of it The module allows for the generation of predefined tabulations maps and graphs but also to make use of the Redatam programming language for more specific tabulations The user also benefits from the data processing speed The response time does not depend on the hardware that is used but on bandwidth and the server of the organization offering the database R SP WebServer Basic Manual From the point of view of the NSls the benefits are numerous To begin with it is a free software simple to implement and offers an easy way to control the access to the databases Moreover support and technical assistance is offered by the Redatam Development Centre team of CELADE and through REDATAM user s community R SP WebServer permits the control over the access to the databases and th
46. o use Apache and who haven t installed it yet It is not a comprehensive Apache User s Guide on the contrary the idea is to make installation as easy as possible However it does not limit you from the possibility of tailoring the installation to meet your own preferences The installation includes only two steps 1 The installation itself if not installed yet and 2 The editing of Apache s configuration file to make the R SP WebServer available copy and paste two text blocks contained in this document R SP WebServer Basic Manual 111 3 a Apache installation Verify in the lower right toolbar of your screen to see if Apache is already installed and connected The icon looks as follows and once passing the mouse over the icon the text Running all Apache Services should be displayed lf the Apache server is not yet installed go to http nttpd apache org and download the last official version not Beta This version should be located at the Win32 Binary MSI Installer on the Apache site For the installation process we recommend that you choose the Typical installation Accept all the default options presented by the program that is just click Next as each screen appears Define a domain known to the computer such as DomainName eclac org ServerName www eclac org ServerAdmin myname surname eclac org ix Apache HTTP Server 2 0 Installation Wizard Server Information Please e
47. ollowing clauses and parameters must be added GLOSSARY PROCESSTITLE Parameter Definition TABLETITLECAPTION Table Title BUTTONSUBMIT Execute BUTTONFREQUENCY Execute Frequency BUT TONHELP Help BUTTONFILTER Build Filter BUTTONSELECTION Edit WEBMASTER redatam cepal org COPYRIGHT Copyright 2002 2011 Latin American and Caribbean Demographic Center CELADE ECLAC Santiago Chile EXERCICE 3 Modify the Frequencies of Person Variables node Population and housing gt Basic characteristics so that the output formats available also include combinations of tables and graphs tables and maps maps and graphs and tables graphs and maps R SP WebServer Basic Manual APPENDIX I Answers to exercises EXERCICE 1 In the WebServermain inl delete or block with asterisks from NODE30 to NODE110 Save the file and refresh the R SP WebServer page Blocking is always a better option than deleting NODES 111 NODE1 TITLE NODE2 NODE10 NMIRGROUP NODE11 NODE20 ONLINEGROUP NODE21 NODE40 SPECIALGROUP NODE41 NODE30 CENSUSGROUP NODE31 NODE50 ENCHOGGROUP NODE51 ITEM60 DHSGROUP ITEM61 NODE70 ESVITGROUP NODE71 EXERCICE 2 You only need to indicate in the WebServermain in file that the number of elements included in the NMIRGROUP is three NMIRGROUP CAPTION Nueva Miranda PAGETYPE GROUP ITEMS 3 ITEM1 HR ITEM2 NMIRESP ITEM38 NMIRENG ITEM4 NMIRPRT ITEM5 NMIRFRA EXERCICE 3
48. p files and images used in them Address O CuServers Redatamihtdocs Folders x Mame Servers A images E 5 Redatam ONMIR coibin RphHelp O Docs y 2 Default htm E D htdocs 2 Index html IV 4 Edit the R SP WebServer master INL file The next step is to edit the master file that controls the R SP WebServer main page This file is named WebServermain inl and is found in redatam cgibin Address C Servers Redatamcgibin Folders x Mame E 5 Servers Al ICORpBases 5 Redatam Rpte E caibin 2 borlndmm al Docs 2 cc3250mt dl 5 htdocs i RpwebEngine exe E RowWwebEngine tto E RpwebEngineEng xD E Rp webEngineEsp Web E B E RpWebEnginePrt wD Imebservermain inl Ih Web tilities exe Open the WebServermain inl file with a text editor in order to create a new entrance for the new application Before making any modifications in the file open the page which is displayed by clicking on Enter test site on the Redatam SP server site at http localhost redatam R SP WebServer Basic Manual R CEPAL CELADE R SP WebServer Windows Internet Explorer Jay GO yy I http Jocalhost caibin RpWebEngine exe PortalAction X Pir o ea ss y gt Je i lr cEPAL CELADE R SP WebServer a D db P gina Of Herramientas CEPAL CELADE Bases de Datos Disponibles Nueva Miranda Sitios Online Censos de Poblaci n Proyectos Espe
49. pe OUTPUTN 2 OUTPUT1 OFF Indicator OUTPUT2 COUNTS Indicator and Cases R SP WebServer Basic Manual These lines create a box with special output type options Only indicator or Indicator and cases If you don t include the options the box is not displayed and the output only displays the indicator In New Miranda application the only processing node of the type FRACTION is the user defined dependency ratio Dependency Ratio User defined Parameter Definition Numerator Denominator Age by Broader Groups Age by Broader Groups 0 14 Enumeration County v Output Type Output Level Indicator and Cases Fait Rennranhir Area Replacements in AREALIST type processing nodes In processing nodes of the type AREALIST that involve only one indicator it is more practical to replace the clauses VARCAPTION VARHEIGHT VARN VAR1 and VARSEL1 by only one expression VARFIXED OUTENT DEFINEI DEFINE is the name of the variable defined to calculate the indicator stored in the Defines inl file In New Miranda only one processing node of the type AREALIST exists the children to women ratio This indicator is calculated in DEFINE19 of the program denominated INDMC Thus the clause to be included is R SP WebServer Basic Manual VARFIXED OUTENT INDMC Add GLOSSARY section to PREFERENCES INL Finally in PREFERENCES file a GLOSSARY section with the f
50. ps Greening Better and new features available for all On Line Process Latest Applications Events Comming On Line Applications INEI IV Censo Nacional Econ mico 2008 Diseminaci n de Informaci n Censal El INEI pone a disposici n el Sistema de Consulta de Datos Reuni n de los pa ses de Am rica Latina y El Caribe para PERU IV CENSO NACIONAL ECON MICO 2008 compartir experiencias sobre diseminaci n de censos wRedatam SP Error Page Opera File Edit View Bookmarks Widgets Tools Help G New tab Redatam SP Error Page X iw 44 e gt PD amp F 13 http flocalhost coibin RpWebEngine exe PortalAction P Ly Google Bd 60 N mero de Error 2 en funci n Initialize Directorio Tempo C servers redatam cgibin RpBases Tempo no encontrado fue creado MAIN mainINL AppPath C servers redatam cagibin MainHtm Path MainWorkPath WEB SCRIPT SERVER APPLICATION Where R SP WebServer application is running and will proceed to create a Tempo directory required to store temporary Redatam files It is important that this folder is created by the application and not copied or created on the outside by the user In the case of reinstatement of R SP WebServer or new WebServer versions we recommend that the tempo folder is removed previously similar with the file RoWebEngine tto located in cgibin folder Refresh the page and the list of available databases should be displayed R SP WebServer
51. rks the same way as the sub node described above with the only exception being that the variables belong to HOUSIN entity i e variables at the household level Select one or more conditions Water inthe Household wv Mo response Within household Outside household 11 2 k Children women ratio This sub node is for obtaining an indicator for the proportion of children aged 0 5 to women aged 15 49 by 100 Since the indicator is calculated directly by the system the only cells available on the execute menu are the standard ones R SP WebServer Basic Manual Il 2 1 Average number of children This sub node is for obtaining the average number of children per women The user must indicate variables to be included in the rows and columns of the output If these cells are left blank the output displays the average number of children alive born alive Average of Number of Children Alive w By Row Number of Children Born Alive Number of Children Ale By Column Areabreak Level None 11 2 m Population in school age This sub node is for obtaining outputs of the population according to age groups that normally correspond to different levels of education The user must select one or more of the categories listed Select one or more conditions Schooling Ages 1 2 0 Tables for education variables This sub node gives the option to make crosstabs of up to three variables with reference to educatio
52. rver demonstration application based on the New Miranda database in four languages This application will be presented in the following section R SP WebServer Basic Manual ll New Miranda demonstration application The following image shows the main page of the R SP WebServer demonstration application created with the New Miranda Redatam database x New siraya Demonstration Applicaton eraurad wiih RSS Pla POPULATION AND HOUSING 5 Basit Characteristics Housing variables Person Variables AVErages Medians CTO SU LAUT Pi ct LON EIA Wy her WS eo rys ul Wow wiran SAHEL ERNS Crosstabs of Variables Household variables Person variables Combination Arealist of Variables Houzehold ariables Person Variables Combination ya H4 K Y POPULATION STRUCTURE Wf Population by Sex and Age Groups NACIONES UNIDAS Dependency Ratio User defined Age Distribution CELADE Dependency Ratio and or Sex Ratio Population Division A ECLAC F f ELDERS Person Characteristics by Age 65 Household Characteristics Persons 65 FERTILITY INFANT MORTALITY Children 54 omen Ratio Children Average CELADE Population Division redatamicepal org Tel 56 2 210 2021 Fax 66 2 208 0196 PO BOX 179 D Santiago Chile EDUCATION Population in School Ages Tables for Education yariables lt B 11 1 Thematic structure The application was constructed with the following them
53. se with the R SP WebServer In order to do that go to IIS Manager right click the Web Service Extension and choose Add New Service Extension The system shows the following window R SP WebServer Basic Manual New Web Service Extension Type the name of the new Web service extension and specify the Files that must be enabled For the extension to run Extension name Required Files C set extension status to Allowed The suggested extension name should be redatam and the files to be added are RpWebEngine exe and WebUtilities exe located in the cgibin directory for example C servers redatam cgibin as shown below How Web Service Extemion E a Tepa Be name of khe new Web parioa extension and specify he files Bhat Fat e a is Pe ete Bo pus Estensaon name rodas Required es Dier versien og pE igre oe E A Dr estat ae eer ee ten isos Bet coterie satus Lo Abend Lor comal de 111 4 h Restrictions ISAPI and CGI IIS version 7 0 Similar to the IIS 6 0 in this version the type CGI programs that can be executed with the server must be assigned manually which is the case of R SP WebServer To make these changes in the configuration of IIS you must be positioned at the starting level of the server enter the ISAPI and CGI Restrictions and select Add The following screen is shown Add ISAPI or CGI Restriction Es ISAPI or CGI pat
54. te cgibin folder The first step is to create a directory for the database and all the files associated from maps to images and geographic selections This directory must be created below the cgibin folder and should be named RpBases Remember that this folder contains all the information that is protected by the system so that no one else than you can have access to the information Below the private RpBases folder create a subdirectory for the new R SP WebServer application In our example based on the New Miranda database the folder is named NMIR as can be seen in the image below 2 It s recommended that the principal file is named Guest and the other files as follows DataSels Defines GeneralSections Maps Pages Preferences Styles and Utilities R SP WebServer Basic Manual Servers gt Redatam 3 coibin Rpbases 1 O NMIR In order to keep the information organized database files separated from the rest it is suggested you create the following three folders Base for database files dic rbf and ptr Site for images jpg gif and html files Work for geographic selection files slw or sel maps mxp shp shx dbf etc In the New Miranda example the division of the folders follows the same logic The database and inl files are located under cgibin RoBases NMIR Help files and images referenced to
55. ve Windows Components button at the left side of the screen The system should display the following Windows Components Wirard W losi Compania Tu can add a rae comonomer of Waa To add or mom 4 component chek the check ber onan ha MRE B 3 pari ol the component ell be mised To see what s ncheded m component cick Depts Comparer Accerio ard Uthi 5HE 4 Wi JAopicaton Server 24 5 M Ip Cotticsts Seres 1 4 E ME rad Servants 1 1 ME hE ee Gara na Densch raid ASE HET iemet borran heras 1151 dd e peaa Saree Conca Total dick space saquied 014 MB Dpape arabi on cheb 2050 0 MB If the IIS server is already installed the system will display a check mark at the Application Server line as above If not select the check box and this will then allow you to proceed with the installation process Again it is recommended that you accept the default options presented by the program During the installation process you will be required to insert the original Windows Operating System Installation CD to complete the process R SP WebServer Basic Manual If your operating system is Windows Server 2008 go to Server Manager and verify in server roles if IIS is installed If not proceed to install it Be sure to select the option CGI in Application development It is recommended to accept the default options 111 4 b Check IIS installation Using any Internet browser of your choice access the server s default page by t
56. will be displayed Additional programming assistance may be obtained by downloading the data dictionary and the Redatam SP software R SP Process module Download dictionary A click on the subtheme allows for the download of the New Miranda database dictionary Opening Down_Dictionary dic You have chosen to open E Down_Dictionary dic which is a Text Document From http jicelade cepal org Wihak should Firefox do with this File Open with Notepad default v Do this automatically For Files like this From now on R SP WebServer Basic Manual Download Redatam SP software Through this sub node the user is directed to a webpage for downloading the latest version of the Redatam SP software 1 3 0 Help This sub theme includes a link to a web help page that is displayed on the center panel of the application 11 3 d Redatam SP homepage With a click on this sub node the user is directed to the Redatam SP homepage 11 4 Output panels The New Miranda WebsServer application includes three basic output types tables graphs maps and Redatam programs These are displayed by clicking the Execute button In some cases the three first display formats may be combined Moreover in some cases the graph type available is an age pyramid Table outputs can be saved in Excel xls of PDF pdf formats l1 4 a Tables The following image shows an output table of the variable Type of Activity
57. yping the following address http localhost If this is the first time you have installed IIS the system should display the screen as shown below http localhost localstart asp You do not currently have a default document set for your users Any users attempting to connect to this site are currently receiving an Under Construction page Welcome to IIS 5 0 R Integrated Management Internet Information Services IIS for Microsoft Windows 2000 brings the power of Web computing to You can manage IIS through the windows with IIS you can easily Windows 2000 Computer share files and printers and create Management console or by using applications to securely publish scripting If you have installe information to improve the way your Windows 2000 Server or Windows organization works IIS is a secure 2000 Advanced Server the platform for building and deploying Administration Web site can also be eCommerce solutions IIS also used to manage IIS makes it easy to bring mission critical business applications to the wab You can also right click on a directory and you can share its contents via the Web as well as windows 2000 with IIS scales to configure the most common IIS meet your needs You can settings F Online Documentation e Set up a personal Web server Share information within your The award winning IIS online team documentation includes an index full text search and printing by e Access dat

Redatam+ WebServer Basic Manual and New Miranda Web

Contents

Download Pdf Manuals

Related Search

Related Contents