Transformation

SledgeHammer

Description: 

Turn your data into open data! SledgeHammer is a powerful tool that facilitates the transofrmation of data across popular proprietary, text, and database formats, and the extraction/generation standards based metadata.

  • Reading data and extracting metadata from: Stata, SPSS, SAS, DDI+ASCII, Stat/Transfer+ASCII,SQL
  • Transforming data into ASCII text format (fixed, csv, delimited), with various optimizations
  • Producing standard metadata from input files. Supported specifications include  DDI-Codebook (1.0-2.1 and 2.5), DDI LifeCycle (3.1-3.2), and Triple-SSS (1.1, 2.0)
  • Computing summary statistics at the variable and category levels for inclusion in DDI or for other purposes. Summary statistics include minimum, maximum, average, standard deviation, count of missing values, weighted and unweighted frequencies
  • Generating scripts for reading ASCII data into R, SAS, SPSS, Stata, Mathematica Notebook, Berkeley SDA, and various flavors of SQL (MS-SQL, MySql, MonetDB,PostgreSQL,Oracle, Vertica, HSQLDB). The database scripts support the creation of database schemas along with bulk loading of the ASCII data.
Creator(s)
Name(s) of institution(s): 
Metadata Technology North America
Contact email: 
mtna@mtna.us
Availability: 
In production
Latest Version: 
1.0.20150717
Operating system requirements
Supported Operating Systems: 
Win64
Linux64
Macintosh
Other system requirements: 
Java
DDI version(s) supported: 
1.x
2.0
2.1
2.5
3.1
3.2
Type: 
Software
Exports DDI XML: 
Yes
Imports DDI XML: 
Yes

Colectica for Excel

Description: 

Colectica for Microsoft Excel is a free tool to document your spreadsheet data using the open standard for data documentation. Document Variables and Datasets: Colectica allows documenting of Variables, Code Lists, and Data Sets directly from within Microsoft Excel. Metadata is Embedded: Colectica saves your standards-based metadata directly in the Microsoft Excel file. If you email or share your file, the metadata will still be attached. Publish Documentation: Colectica for Excel can generate documentation for your Variables, Code Lists, and dataset in PDF, Word, HTML, and XSL-FO. Import Stata to Excel: Colectica for Excel allows direct importing and documenting of Stata data files, with a file extension .dta. The variable names, labels and code lists in the Stata file will also be imported and added to the stored documentation automatically. Import SPSS to Excel: Colectica for Excel allows direct importing and documenting of SPSS data files, with a file extension .sav. The variable names, labels and code lists in the SPSS file will also be imported and added to the stored documentation automatically. Create DDI-Lifecycle Metadata: Export your data documentation to an XML file in the DDI metadata format, the standard for data documentation. Open and edit it from Colectica Designer, Colectica Express, or other DDI applications.

Creator(s)
Name(s) of institution(s): 
Colectica
Contact email: 
support@colectica.com
Availability: 
In production
Latest Version: 
4.1
Operating system requirements
Supported Operating Systems: 
Win32
Win64
Other system requirements: 
Microsoft Excel 2007, 2010, or 2013
Support Available: 
Free, for limited time
DDI version(s) supported: 
3.1
3.2
Type: 
Tool
Exports DDI XML: 
Yes
Imports DDI XML: 
Unknown

DDI-XSLT

Owner: 
Description: 

A collection of xslt-stylesheets for DDI for transformation the metadata to other formats. Curren XSLT in development: DDI 3.1 to XHTML DDI 2.1 to RDF DDI 3.1 to datacite (development version )

Creator(s)
Name(s) of individual author(s)/programmer(s): 
Dan Kristiansen
Jannik Vestergaard Jensen
Thomas Bosch
Benjamin Zapilko
Name(s) of institution(s): 
Danish Data Archive
Danish Data Archive
Gesis
Gesis
Contact email: 
olof.olsson@snd.gu.se
Availability: 
Alpha release
Operating system requirements
Supported Operating Systems: 
Win32
Win64
Linux32
Linux64
Macintosh
Other
Support Available: 
Community-driven support
DDI version(s) supported: 
2.1
3.1
Type: 
Tool
Imports DDI XML: 
Yes

Dataset Documentation Manager

Owner: 
Description: 

Developed by the Data Archive of GESIS, this tool imports SPSS data files; allows documentation of questions, sub-questions and answers; enables language-specific documentation; shows two languages concurrently on the screen; permits reuse of question documentation; exports into a DDI 2-compatible format, for Nesstar or long-term preservation; and exports into a DDI 3-compatible format, supporting enhanced publications.

Creator(s)
Name(s) of individual author(s)/programmer(s): 
Alexander Mühlbauer
Wolfgang Zenk-Möltgen
Name(s) of institution(s): 
GESIS - Leibniz Institute for the Social Sciences
Contact email: 
Wolfgang.Zenk-Moeltgen@gesis.org
Availability: 
In production
Latest Version: 
2.5
Operating system requirements
Supported Operating Systems: 
Win32
Programming/scripting languages used: 
Visual Basic 6
Support Available: 
Free, to any user
DDI version(s) supported: 
1.x
2.0
2.1
Exports DDI XML: 
Yes
Imports DDI XML: 
No

DDI Validator

Description: 

Online schema validation of DDI-Lifecycle and DDI-Codebook (2.1) and 2.5 later on.

Creator(s)
Name(s) of individual author(s)/programmer(s): 
Olof Olsson
Name(s) of institution(s): 
SND
Contact email: 
olof.olsson@snd.gu.se
Availability: 
Beta release
Latest Version: 
0.2
Operating system requirements
Supported Operating Systems: 
Win32
Win64
Linux32
Linux64
Macintosh
Support Available: 
Free, to any user
DDI version(s) supported: 
2.0
2.1
3.1
Type: 
Tool
Exports DDI XML: 
No
Imports DDI XML: 
Yes

Questasy

Owner: 
Description: 

Questasy is a web application developed to manage the documentation and dissemination of data and metadata for panel surveys. It manages questions and variables, including question reuse across multiple studies and longitudinal panels. It also manages concepts, publications, study information, and more. For administrators and project managers, Questasy provides an intuitive interface for managing the metadata. Questasy tracks downloads, and also easily integrates with web tracking applications (such as Google Analytics) to provide detailed statistics on site usage. For researchers, Questasy provides a fast, customizable, easy-to-use web interface for browsing and searching the metadata, and downloading the data. Researchers can also select the variables they are interested in and download a "custom basket" of variables, complete with a custom codebook for their selection. Codebooks are generated in both HTML for browsing and PDF for download/printing.

Creator(s)
Name(s) of individual author(s)/programmer(s): 
Alerk Amin
Edwin de Vet
Bart van Nieuwburg
Name(s) of institution(s): 
CentERdata
Contact email: 
e.balster@uvt.nl
Availability: 
In production
Latest Version: 
4.2.1
Operating system requirements
Supported Operating Systems: 
Win32
Other system requirements: 
Web Server (such as Apache) with PHP Database (such as MySQL)
Programming/scripting languages used: 
PHP, using the cakePHP framework
Support Available: 
For-fee
DDI version(s) supported: 
3.0
Exports DDI XML: 
Yes
Imports DDI XML: 
No

DDI to HTML Stylesheet

Description: 

A tool to transform and format content of DDI documents as HTML pages. 

Codebook2-0.xsl

Creator(s)
Name(s) of institution(s): 
ICPSR
Availability: 
No longer developed, but still available
Latest Version: 
1.0
Operating system requirements
Supported Operating Systems: 
Win32
Win64
Programming/scripting languages used: 
XSLT
Support Available: 
Community-driven support
DDI version(s) supported: 
2.0
Type: 
Tool