Transcript PX-Web 2014 May R1

PX-Web 2015 December
Maria Gunnarsson SCB
Mikael Nordberg SCB
Whats new?
•
•
•
•
Saved Query (PX-Web 2015 May)
Improved security
Select values from group
Connection to metadata systems
Improved security
• Character blacklist for verifying:
• Parameters in URL
• Input fields
• Security in the component for reading CNMM
databases has been improved
Connection to metadata systems
• META-ID
• ” The META-ID keyword is used to reference a external
meta information about a table, variable or value. ”
• Introduced 2013
• META-ID=”RT:12”;
• META-ID(”VARIABLE”)=”v:167”;
• META-ID(”VARIABLE”,”VALUE”)=”val:232”;
PX-Web implementation
• Connections to more than one metadata system
• Various number of arguments
META-ID=”SYS1:arg1:arg2”;
Metadata system id
Arguments 1..n
META-ID=”SYS1:arg1:arg2,SYS2:arg1:arg2”;
Metadata system 1
Metadata system 2
metadata.config
• Define URL signatures to your metadata system(s)
• Table-, variable- and value level
• Per system and language
• Example:
…
<onVariable>
<metaSystem id="META1">
<link px-lang="sv" labelStringFormat="om {0}" urlStringFormat="http://www.scb.se/variable/{0}"/>
<link px-lang="en" labelStringFormat="About {0}" urlStringFormat="http://www.scb.se/en/variable/{0} /"/>
</metaSystem>
</onVariable>
…
META-ID(”VARIABLE”)=”META1:region”;
Will in english produce a link with:
Text = About region
URL= http://www.scb.se/en/variable/region
Metadata per database
• Per database you can configure:
• If metadata connections shall be used or not
• Which metadata.config file to use
• Your own implementation of metadata-connections
• Settings in the database.config file
DEMO!
Plans for 2016
•
•
•
•
•
•
•
Responsive PX-Web
Login per database
Settings per database
Chart improvements
API GET
Charts from API
API Builder
• Missing anything?