Loading in 2 Seconds...
Loading in 2 Seconds...
OECD Expert Group on Statistical Data and Metadata Exchange Part 1: Exchange of experience and practices for data sharing and exchange 1.1 Tools presently used Gesmes/TS deliveries from output databases at Statistics Sweden Lars Nordbäck. Preparation phase - Retrieval from the database.
Part 1: Exchange of experience and practices for data sharing and exchange
1.1 Tools presently used
Gesmes/TS deliveries from output databases at Statistics Sweden
The arrays to remove are marked with a minus sign. The minus option is used when a few arrays shall be removed, if a few shall remain you can use a plus sign and enter those arrays to remain
The name of the input gesmesfile is on line one, and the resulting file is in line two.
Gesselect is started by clicking the gesselect.bat file
Name of resulting file
The name of the gesmesfiles to concatenate are entered in a text-file. The first name however shall be on the resulting file
Gesconc is started by clicking the gesconc.bat file
PC-Axis SQL – save queries
PX-Batch – run queries that produces gesmesfiles
GesSelect – selecting arrays from a rectangular retrieval
Gesconc – concatenating several Gesmes-files into one file
Statel/Stadium – keeps track on delivieries
Europe: Croatia, Denmark, Estonia, Finland, Ireland, Iceland, Latvia, Lithuania, Norway, Slovenia, Spain, Sweden and UN/ECE in Geneva
Asia: Taiwan, The Philippines
Afrika: Algeria, Kuwait, East Africa Community, Namibia, Uganda, South Africa
South America: Bolivia and Brazil
Discussions with Romania, Slovakia and Tanzania
IF the statistics is in the Public Output Data Base, SSD, the Gesmes files are created fetching metadata and data fromalt 1) a table entered for the Public SSD on the Statistics Sweden website alt 2) a special composed table especially established for the reporting to other organisations. If necessary a converting file is used to get the demanded codes.If the statistics is missing in the SSD Gesmes files can be created using Excel.
Code converting file
The Excel conversion add in produced by the consultant Anders Törnqvists will be available for other institutions from the consultant direct.
PC-Axis function for creating Gesmesfiles has been further developed to be able to use open array parameters
Gesmesfile – ready to send