Documentation for PC-AXIS

Detailed description for PC-Axis file format 2008.

You can download documentation for the following:

System Manual 2008

List of contents
Chapter 1. Overview
Chapter 2. Directories and files
Chapter 3. INI file
Chapter 4. Pcaxisen.txt Text file
     New texts for menus and labels
Chapter 5. Pcaxisen.msg Message file
     New texts for messages
Chapter 6. pcaxisen.hlp Help file
Chapter 7. PC-Axis database
Chapter 8. PC-Axis file format
Chapter 9. Classifications
Chapter 10. Partitioned variable
Chapter 11. Saved query PXQ
Chapter 12. Installation program
     Installation instructions for users and administrators
Chapter 13. PC-Axis and SQL databases
Chapter 14. Saved query PXS (SQL)
Chapter 15. Comparison PX file format and SQL database
     More about SQL database

PC-Axis Installation 2008

There are 3 different ways to handle the PC-Axis ini file pcax2000.ini.

PC-Axis first checks if there is a line in the file pcaxisen.txt under section "About", "ini=c:\xxxx" If this is found the program uses the directory indicated. If the directory does not exist it will be created and the pcax2000.ini will be copied there.

If there is no information in pcaxisen.txt the program checks if there is a file pcax2000.ini in the same directory where pcaxis.exe resides If it is found the program uses this.

If none of the above applies the ini file is looked for in the Windows directory.

If Pcax2000.ini is not found in any of these locations, the program gives an error message and continues loading using pcaxisen.txt to show menus in English. There are installation packages for all three options on the download page

System Manual 2007

PC-Axis file format
Ini file
Installation description for administrator
PC-Axis connection to SQL
Codes in text file read by PC-Axis SQL
PC-Axis keywords compared to the SQL meta base
Description of PXQ files, saved queries for px files
Description of PXS files, saved queries for SQL retrieval

New texts for menus and labels
New message texts

System Manual 2006

PC-Axis file format
Ini file
Text file for menus and labels: pcaxisen.txt
Text file for messages: pcaxisen.msg
Directories and files
PC-Axis with SQL databases
PC-Axis connection to SQL

XML Documentation

The XML formats are part of the CoSSI model and comes in three different formats: CALS, XDF and KEYS.
Description is found on the web site of Statistics Finland.

New NMP (Null, Point, Missing) Documentation

The description of new possibilities to have symbols for different data in the SQL database has been updated. Download a word document (Updated January 2006).

Description of new keywords in PC-Axis file format for NPM.

PC-Axis Installation 2006-2007

To accomodate installation of PC-Axis in different LAN environments the following applies regarding the ini file pcax2000.ini.

Default is to place the file in the Windows directory. This is done when the normal installation program on CD-ROM or downloading on the Internet is used.

If the Windows installation on the PC does not permit the normal user to update files in the Windows directory, there are two other alternatives, which can be used depending on if the program resides on a server or the users PC.

The order in which these three alternatives are used are:

1. Pcax2000.ini is found in the Windows directory
2. Pcax2000.ini is placed in the PC-Axis directory where the pcaxis.exe file is found
3. Pcax2000.ini is placed in another directory and the name of this directory is indicated in the text file (pcaxisen.txt, etc) under section "About", "ini=c:\xxxx"

If Pcax2000.ini is not found in any of these locations, the program gives an error message and continues loading using pcaxisen.txt to show menus in English.

Functions in dlls 2006

PX-Web: (except maps)
Create a new PX file from an existing (after select, edit, calculation) or convert to another file format PxWebExe2006.dll (2006-09-22)
Functions call pxFileBatch2006.

PX-Web: (maps)
Use 2003 version.

PX-Web
Run a saved query PxWebpxq2006.dll (2006-09-22)
Function calls pxFileBatch2006.

Error codes

101=MATRIX error
102=SUBJECT AREA error
103=UNITS error
104=TITLE error
105=DESCRIPTION error
106=STUB error
107=HEADING error
108=VALUES error
109=CODES error
110=NOTE or NOTEX error
111=NOTE or NOTEX for Variable error
112=VALUENOTE error
114=COMPRESSED error
115=ELIMINATION yes/no error
117=PARTITION error
120=CONTENTS error
121=KEYS error
123=PRECISION error
124=DOMAIN error
125=SUBJECT CODE error
130=TITLE or DESCRIPTION missing
131=MATRIX missing
132=SUBJECT AREA missing
133=SUBJECT CODE missing
134=STUB och HEADING missing
135=UNITS missing
136=CONTENTS missing
137=DECIMALS missing
138=SHOWDECIMALS error
140=Value stated as ELIMINATION is wrong
141=Value missing for unit variable
142=COPYRIGHT is wrong
143=DAYADJ is wrong
144=SEASADJ is wrong
145=SOURCE is wrong
146=CONTACT is wrong
147=REFPERIOD is wrong
148=AXIS-VERSION is wrong
149=LAST-UPDATED is wrong
150=CREATION-DATE is wrong
151=STOCKFA is wrong
152=CFPRICES is wrong
153=TIMEVAL is wrong
154=BASEPERIOD is wrong
155=DATABASE is wrong
156=INFOFILE is wrong
160=Keyword dependent on CONTVARIABLE found but no contents variable
161=CONTVARIABLE or dependent keyword error
162=PRESTEXT error
163=CHARSET error
164=MAP error
165=LANGUAGE error
166=AGGREGALLOWED error
167=AUTOPEN error
168=DOUBLECOLUMN error
169=DESCRIPTIONDEFAULT error
170=CONFIDENTIAL error
171=CODEPAGE error
172=LANGUAGES error
173=DATASYMBOL1-6 error
174=DATASYMBOLSUM error
175=DATASYMBOLNIL error
176=DATANOTE error
177=DATANOTESUM error
178=NEXTUPDATE error
179=PXSERVER error
180=DATA missing
181=DIRECTORYPATH error
182=UPDATEFREQUENCY error
183=INFO error
184=LINK error
185= SURVEY error
186=VARIABLE-TYPE error
187=DEFAULT-GRAPH error
188=TABLEID error
189=HIERARCHYLEVELSOPEN error
201=HIERARCHYLEVELS error
202=HIERARCHYNAMES error
203=HIERARCHIES error
204, not enough memory to allocate
205=SYNONYMS error
206=ROUNDING error