300 likes | 416 Views
PX development. Mikael Nordberg & Petros Likidis Statistics Sweden. Parts of the presentation. Part 1 – development since the last meeting Part 2 – Demo of PX-Web 2012 Part 3 – Future development Part 4 – Demo PX-Web customization Part 5 – Q and A. Development since Switzerland.
E N D
PX development Mikael Nordberg & Petros Likidis Statistics Sweden
Parts of the presentation • Part 1 – development since the last meeting • Part 2 – Demo of PX-Web 2012 • Part 3 – Future development • Part 4 – Demo PX-Web customization • Part 5 – Q and A
Integration of web controls into Statistics Swedens Statistical database • Use the PX Web controls on the web site of Statistics Sweden (EpiServer) • A number of improvements of the web controls
Menu • The TableOfContent web control (Menu tree) is loaded dynamically • StartNode property (only display a specific branch of the tree) • ExpandNode property (Specified node will be expanded by default) • UrlLinkMode property (display URL links as tree nodes or as images)
Selection of variables and values Content variable • Changed how the content variable is displayed • If there is a content variable it is always displayed as the first variable • Hides the content variable if it only contains one value and the ”Remove Single Content” setting is set to true
Aggregations and valuesets • Variable name is not added to dropdownlistwhen variable has valuesets or aggregations • Aggregation namedisplayedtogether with variable name after aggregation selection • New propertyValuesetMustBeSelectedFirst. If set to truevalueset must be selectedbeforeselection of valuescan be made
Search values • Searchresultsdisplayed in grid with paging • Possibility to show all values
Table • Cropped table • MaxRows and MaxColumns properties • Information displayed when table is cropped • Supports pivot operation
Information • Added new keyword OFFICIAL-STATISTICS • Displays information about official statistics in the Information web control
Support for logginguserbehavior • Added PxAction event to the VariableSelector and CommandBar web controls • Fired when operation is executed, presentation view selected or table saved to file • Event arguments: • ActionType • Operation • Presentation view • Save as • ActionName (operation-/presentation-/file format ID) • TableId • NumberOfCells • NumberOfContents
Other… • W3C compliance for web controls • Per cent operation optimized • PRN file format renamed to CSV • PX-Web: • Removed the generation of Menu.xml for CNMM databases • Support for multiple CNMM databases • General handling and logging of application errors • Improved handling of settings in settings.config • Added Custom.css where changes to the default style sheets shall be defined
Testing of PX-Web • Load tests • Memory leak discovered and was fixed before version 1.0 of PX-Web • Security tests • Security tests performed by external company • Mission: Try to hack the application! • Result: Security is very good • Could not gain any unauthorized access to the system • Could not make the application unavailable by sending incorrectly formatted data to the application
Security tests • Positive • Usesbuilt-insecurity in ASP.NET • The IP-filter is effective – Should be used! • Considerations • Possible to access PX-files that are not accessible from the menu (PX-files that are located in anotherdirectory). • OnlyPX-files are affected • Onlyone administration account • Will be implemented in later version • Manipulation of the rxid parameter • Contains no securityrelated information • Abort processingwhen IP-filter is activated • Has beenfixed • Potentiallyvulnerablecode in PCAxis.Sql • Will be fixed by Statistics Norway
PX-Web 2011 • First version of the new PX-Web was released this year!
PX-Web 2012 • Added one more feauture charting • Beta 1 was released this Monday • We have defined a new concept, views • Restructured the settings in the administration interface.
Views continued Views could be consider as diffrent perspectives of the data • Table • Chart • Footnotes • Other metadata
Demo PX-Web 2012
What is going on right now? • Attributes on cell level • API:s • New version of the Nordic Data Model 2.3
Ideas for the future • Customization manual • New selection page • Input from you from this meeting and from the mail group
Demo customization of PX-Web