Tools

 

These tools have been created by CSPro users to accomplish tasks either impossible to complete or cumbersome with the standard CSPro software interface. If you have a tool that others might find useful, please share it. These tools are provided for use at your own risk. Always backup your application and data files before using a tool. Source code for some of these tools may be available upon request. If a tool does not run on your computer, try putting these files from Microsoft’s .NET framework in the same folder as the tool.

The source code for any of these tools is available upon request.

Code Colorizer

When sharing CSPro logic code in a document or on a website, the color formatting of the code is lost, which can make the code more difficult to read. This tool reads in logic files and outputs HTML that maintains the proper formatting. Options allow the user to include line numbers in the HTML code, or to add hyperlinks that will link calls to user functions to their declaration. HTML code can be saved to a file, or copied to the clipboard for integration with software such as Microsoft Word or email programs. Download: CSProCodeColorizer.zip

Code Colorizer For Notepad++

By putting this file in your %APPDATA%\Notepad++ folder, .app files will be colored using the same colors as are present in CSPro’s logic editor. The script will also color .pff files. This requires having the software package Notepad++. Download: userDefineLang.xml

IPUMS Codebook to CSPro Dictionary Converter

This program converts a IPUMS codebook to a CSPro dictionary. IPUMS data is stored in a UNIX-style text file that ends each line with only a line feed, whereas Windows text files end lines with a carriage return and then a line feed. CSPro expects both the CR+LF, so before you can read the IPUMS data with the CSPro dictionary, you must convert the data file to Windows format. A tool like unix2dos can be used for this conversion. Download: IPUMS2CSPro.zip

Language Setter

This program modifies the Windows registry values for all CSPro programs, setting the language setting to a certain value. This can be useful for changing between two languages, or for setting the language on machines where the language settings were not applied to all users of the machine due to computer rights settings. This program can be executed and a language name specified, or it can be run on the command line (perhaps as part of a batch file). “SetCSProLanguage Armenian” is how to run the program from the command line. Download: SetCSProLanguage.zip

Listing File Comparer

This CSPro batch application, written for Bangladesh’s 2011 census processing, provides a summary report of the error message percentages across data files. If processing multiple data files that are divided by a certain attribute (typically geography), it can be useful to check whether certain edits apply disproportionately across the files (geographies). See the included DOS batch files for examples of how to use this tool effectively. The report comes in CSV format, which can be opened easily in Excel. Download: listingFileComparer.zip

Locate Incomplete Cases

This program searches a directory (or subdirectories) and searches for CSPro data files that have incomplete (i.e., partially saved) cases. The program displays a listing of these files, and counts how many incomplete cases are in each file. Download: locateIncompleteCases.zip

Operator Log Statistics

This is an Excel spreadsheet that, by following several steps outlined in the zip file, will display detailed statistics based on the operator logs from a keying operation. By creating an Excel pivot table, it is easy to get details about the efficiency and accuracy of keyers. Download: operatorLogStatistics.zip

Operator Statistics Viewer

This tool builds upon the Excel spreadsheet listed above. This standalone program allows easy analysis of one or more log files. Features include an option to associate names with operator IDs, the ability to set targets and view progress towards those targets, and many ways to visualize the data from operator logs in tabular and graph form. Download: OperatorStatisticsViewer.zip

Production Runner

This program was created for processing Kenya’s 2009 census. A user can create a batch production file that lists the order in which PFF or batch (.bat) files are processed. Options include the ability to run more than one process at a time if the input of certain PFF files does not depend on the output of preceding PFF files, and the ability to turn off a machine after data processing. This tool was designed to simplify the task of running edits or tables on multiple data files. See Kenya’s spec file as an example. Download: CSProProductionRunner.zip

Record Cleaner

This tool “cleans” a data file’s records, removing records of a type not listed in the dictionary and adding required records that are not present. This tool will prevent you from getting “Invalid Record type” or “Required Record or Group ______ not found” messages when you process your data. It will also give you a limited report showing you what records were inserted and deleted. Download: RecordCleaner.zip

Save Array Viewer

This program is designed for people using DeckArrays to edit data. It reads the .sva file produced by a CSPro batch program when using save arrays. The program displays the file in spreadsheet format and, if using DeckArrays, displays the proper index labels taken from the dictionary. Default values can be highlighted as a way to identify the completeness of the DeckArrays. Download: SaveArrayViewer.zip

Table Translator

This tool extracts strings from TBW files, creating a phrase dictionary. The user can provide a translation for each phrase in the phrase dictionary and then run the program again, replacing all of the original phrases with the translated equivalent. A detailed guide is provided at the above link. Download: translateTBW.zip

Version Shifter

This program is designed for power users who have multiple versions of CSPro on their machines. It can change the registry to associate all of the CSPro files (.dcf, .ent, etc.) with an older version of CSPro. (Some users will have to run the tool in administrative mode to allow for this functionality.) The program can also change the version numbers embedded in CSPro files. This is useful if you want to make a newer application work in an older version of CSPro. Download: CSProVersionShifter.zip