DDI from software

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 Reader

Description: 

Colectica Reader is a free tool to view DDI 3 metadata.

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
Support Available: 
Free, to any user
DDI version(s) supported: 
3.1
3.2
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

XML Beans for DDI 3.1

Description: 

Apache XMLBeans packages for DDI 3.1. XMLBeans is a technology for accessing XML by binding it to Java types. For more information, see http://xmlbeans.apache.org/

Creator(s)
Name(s) of institution(s): 
Jannik Jensen
Dan Kristiansen
Contact email: 
jvj@dda.dk
Availability: 
In production
Latest Version: 
3.1
Operating system requirements
Supported Operating Systems: 
Win32
Win64
Linux32
Linux64
Macintosh
Programming/scripting languages used: 
Java
Support Available: 
Community-driven support
DDI version(s) supported: 
3.1
Exports DDI XML: 
Yes
Imports DDI XML: 
Yes

Colectica Designer

Description: 

Colectica Designer is a visual DDI metadata editor and survey questionnaire designer. It interacts with Colectica Repository to provide advanced data management functionality. Colectica Designer complements existing systems by importing and generating various forms of data, documentation, and source code.

Creator(s)
Name(s) of individual author(s)/programmer(s): 
Jeremy Iverson
Dan Smith
Name(s) of institution(s): 
Colectica
Contact email: 
via http://www.colectica.com/contact
Availability: 
In production
Latest Version: 
3.0.1932
Operating system requirements
Supported Operating Systems: 
Win32
Support Available: 
Free, for limited time
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

Nesstar Publisher

Owner: 
Description: 

Nesstar Publisher is an advanced data management program. It consists of data and metadata conversion and editing tools, enabling the user to prepare these materials for publication and make such resources available to a wider audience. The program allows users to enhance datasets by combining a wide range of catalog and contextual information. Users are given, for example, complete control over the structure of the metadata within internationally recognized data documentation schema, including inserting Web links and URLs that can be viewed within the Nesstar Web client. Nesstar Publisher also allows merging of DDI documents containing markup for different sections of the DDI for the same study. This is especially useful for merging in variable description information generated from SPSS/SAS data definition statements or export files with study descriptions and question text.

Creator(s)
Name(s) of institution(s): 
Norwegian Social Science Data Services
Contact email: 
nesstar-support@nesstar.com
Availability: 
In production
Latest Version: 
4.0
Operating system requirements
Supported Operating Systems: 
Win32
Win64
Programming/scripting languages used: 
C++, Java
Support Available: 
For-fee
DDI version(s) supported: 
1.x
2.1
Exports DDI XML: 
Yes
Imports DDI XML: 
Yes

XML Beans for DDI 3.0

Taxonomy upgrade extras: 
Description: 

Apache XMLBeans packages for DDI 3.0. XMLBeans is a technology for accessing XML by binding it to Java types. For more information, see http://xmlbeans.apache.org/

Creator(s)
Name(s) of individual author(s)/programmer(s): 
DDI Foundation Tools Program
Name(s) of institution(s): 
DDI Foundation Tools Program
Contact email: 
na
Availability: 
No longer developed, but still available
Operating system requirements
Supported Operating Systems: 
Win32
Win64
Macintosh
Programming/scripting languages used: 
Java, XML
DDI version(s) supported: 
3.0
Type: 
Components
Exports DDI XML: 
Yes
Imports DDI XML: 
Yes

XML Beans for DDI 1/2.x

Taxonomy upgrade extras: 
Description: 

Apache XMLBeans packages for DDI 1.0, 1.1, 1.2, 1.2.1, 1.2.2, 1.3, 2.0 and 2.1. XMLBeans is a technology for accessing XML by binding it to Java types. For more information, see http://xmlbeans.apache.org/

Creator(s)
Name(s) of individual author(s)/programmer(s): 
DDI Foundation Tools Program
Name(s) of institution(s): 
DDI Foundation Tools Program
Contact email: 
na
Availability: 
No longer developed, but still available
Operating system requirements
Supported Operating Systems: 
Win32
Win64
Macintosh
Programming/scripting languages used: 
Java, XML
DDI version(s) supported: 
1.x
2.0
Type: 
Components
Exports DDI XML: 
Yes
Imports DDI XML: 
Yes

XCONVERT

Taxonomy upgrade extras: 
Description: 

A tool to convert SAS, SPSS, and Stata data definitions to DDI. The XCONVERT documentation also explains how to convert an SPSS system file into an ASCII data file and a matching DDI file.

Creator(s)
Name(s) of individual author(s)/programmer(s): 
CSM Program, Univ. of Calif., Berkeley
Contact email: 
sda@berkeley.edu
Availability: 
Unknown
Operating system requirements
Supported Operating Systems: 
Win32
Linux32
Other
If other, please describe:: 
Solaris
DDI version(s) supported: 
2.1
Type: 
Software
Exports DDI XML: 
Yes
Imports DDI XML: 
No