DDI

Colectica is able to import information from the following version of DDI:

  • DDI 3.2

  • DDI 3.1

  • DDI 2.x / Nesstar 1

Note

Importing other types of DDI 2 files may also work, but is not explicitly tested or supported. Please contact us if you have existing data you would like to import and we can work with you to support your formats.

  1. Click the Import DDI button from the Import ribbon tab.

    ../../../../_images/import-ddi-button.png
  2. The import wizard will open. Click the Choose input files button to select the file you wish to import.

    ../../../../_images/import-ddi-wizard.png
  3. Click the Next button.

  4. Colectica will automatically determine the version of the DDI in the file. If you are importing DDI 2, Colectica will attempt to determine the language of the metadata within the file. If the language cannot be determined, you will be prompted for some more information. In this case, provide the information and click the Next button.

  5. Colectica will read the DDI file and show you a summary of its contents.

    ../../../../_images/import-ddi-summary.png
  6. Click the Finish button.

  7. Colectica will import your data. Depending on the size of the DDI 3 file, this may take a few minutes.

Footnotes

1

Nesstar is a product of the Norwegian Social Science Data Services.

DDI 2 to DDI 3 Mapping

Document Description

DDI2

DDI3/Colectica SDK

docDscr

NA

docDscr.citation

NA

docDscr.citation.titlStmt

NA

docDscr.citation.titlStmt.titl

NA

docDscr.citation.titlStmt.IDNo

NA

docDscr.citation.rspStmt

NA

docDscr.citation.rspStmt.AuthEnty

NA

docDscr.citation.prodStmt

NA

docDscr.citation.prodStmt.software

NA

Study Description

DDI2

DDI3/Colectica SDK

stdyDscr

StudyUnit

stdyDscr.citation.titlStmt.parTitl

NA

stdyDscr.citation.titlStmt.IDNo

StudyUnit.DublinCoreMetadata.Identifiers

stdyDscr.citation.titlStmt.subTitl

StudyUnit.DublinCoreMetadata.SubTitle

stdyDscr.citation.titlStmt.altTitl

StudyUnit.DublinCoreMetadata.AlternateTitle

stdyDscr.citation.rspStmt.AuthEnty

StudyUnit.DublinCoreMetadata.Creator

stdyDscr.citation.rspStmt.othld

StudyUnit.DublinCoreMetadata.Contributor

stdyDscr.citation.prodStmt.producer

StudyUnit.DublinCoreMetadata.Contributor

stdyDscr.citation.prodStmt.software

NA

stdyDscr.citation.prodStmt.software version

NA

stdyDscr.citation.prodStmt.software date

NA

stdyDscr.citation.prodStmt.fundAg

StudyUnit.FundingSources.Agency.ItemName.Current

stdyDscr.citation.prodStmt.prodDate

NA

stdyDscr.citation.prodStmt.prodPlac

NA

stdyDscr.citation.distStmt.distrbtr

StudyUnit.DublinCoreMetadata.Publisher

stdyDscr.citation.distStmtdepositr

StudyUnit.DublinCoreMetadata.Source

stdyDscr.citation.disStmt.contact

NA

stdyDscr.citation.disStmt.depDate

StudyUnit.UserAttributes[“Deposition Date”]

stdyDscr.citation.disStmt.distDate

StudyUnit.UserAttributes[“Distribution Date”]

stdyDscr.citation.biblCit

NA

stdyDscr.citation.verStmt.version

StudyUnit.UserAttributes[“Version”]

stdyDscr.citation.verStmt.version date

StudyUnit.UserAttributes[“Date”]

stdyDscr.citation.verStmt.version type

StudyUnit.UserAttributes[“Type”]

stdyDscr.citation.verStmt.verResp

StudyUnit.UserAttributes[“Version Responsibility”]

stdyDscr.citation.verStmt.verResp affiliation

StudyUnit.UserAttributes[“Version Responsibility Affiliation”]

stdyDscr.citation.verStmt.notes

StudyUnit.UserAttributes[“Version Notes”]

stdyDscr.citation.holdings

StudyUnit.Archives.HoldingInformation.ArchiveOrganization.Location.Name

stdyDscr.citation.holdings location

StudyUnit.Archives.HoldingInformation.ArchiveOrganization.Location.Addresses.Address.City

stdyDscr.citation.holdings callno

StudyUnit.Archives.HoldingInformation.ArchiveOrganization.Location.TelephoneNumber

stdyDscr.citation.holdings URI

StudyUnit.Archives.HoldingInformation.ArchiveOrganization.Location.Urls

stdyDscr.citation.notes

NA

stdyDscr.citation.serStmt

StudyUnit.SeriesStatement

stdyDscr.citation.serStmt URL

StudyUnit.SeriesStatement.SeriesRepositoryLocation

stdyDscr.citation.serStmt.serName

StudyUnit.SeriesStatement.SeriesName

stdyDscr.citation.serStmt.serInfo

StudyUnit.SeriesStatement.Description.Current

stdyDscr.stdyInfo

NA

stdyDscr.stdyInfo.subject

StudyUnit.Coverage.TopicalCoverage.Subjects

stdyDscr.stdyInfo.subject.keyword

StudyUnit.Coverage.TopicalCoverage.Keywords

stdyDscr.stdyInfo.subject.keyword vocab

StudyUnit.Coverage.TopicalCoverage.Keywords.CodeValue.OtherValue

stdyDscr.stdyInfo.subject.keyword vocabURI

StudyUnit.Coverage.TopicalCoverage.Keywords.CodeValue.CodeListUrn

stdyDscr.stdyInfo.subject.topcClas

NA

stdyDscr.stdyInfo.subject.topcClas vocab

NA

stdyDscr.stdyInfo.subject.topcClas vocabURI

NA

stdyDscr.stdyInfo.abstract

StudyUnit.StudyAbstract

stdyDscr.stdyInfo.sumDscr

NA

stdyDscr.stdyInfo.sumDscr.timePrd

NA

stdyDscr.stdyInfo.sumDscr.timePrd date

NA

stdyDscr.stdyInfo.sumDscr.timePrd event (start/end)

NA

stdyDscr.stdyInfo.sumDscr.timePrd cycle

NA

stdyDscr.stdyInfo.sumDscr.collDate

NA

stdyDscr.stdyInfo.sumDscr.collDate date

NA

stdyDscr.stdyInfo.sumDscr.collDate event (start/end)

NA

stdyDscr.stdyInfo.sumDscr.collDate cycle

NA

stdyDscr.stdyInfo.sumDscr.nation

StudyUnit.Coverage.SpatialCoverage.CountryCodes

stdyDscr.stdyInfo.sumDscr.nation abbr

NA

stdyDscr.stdyInfo.sumDscr.geogCover

StudyUnit.Coverage.SpatialCoverage.Description

stdyDscr.stdyInfo.sumDscr.geogUnit

StudyUnit.Coverage.SpatialCoverage.BoundingBox

stdyDscr.stdyInfo.sumDscr.anlyUnit

StudyUnit.AnalysisUnits

stdyDscr.stdyInfo.sumDscr.universe

StudyUnit.StudyUniverse

stdyDscr.stdyInfo.sumDscr.dataKind

StudyUnit.KindsOfData

stdyDscr.stdyInfo.notes

StudyUnit.DublinCoreMetadata.Description

stdyDscr.method.dataColl

StudyUnit.DataCollections

stdyDscr.method.dataColl.timeMeth

StudyUnit.DataCollections.Methodology

stdyDscr.method.dataColl.dataCollector

StudyUnit.DataCollections.CollectionEvents.DataCollectorOrganizations

stdyDscr.method.dataColl.dataCollector abbr

StudyUnit.DataCollections.CollectionEvents.DataCollectorOrganizations.Organization.Nickname

stdyDscr.method.dataColl.dataCollector affiliation

NA

stdyDscr.method.dataColl.frequenc

StudyUnit.DataCollections.CollectionEvents.DataCollectionFrequency

stdyDscr.method.dataColl.sampProc

StudyUnit.DataCollections.ProcessingInstructionSchemes

stdyDscr.method.dataColl.deviat

NA

stdyDscr.method.dataColl.collMode

StudyUnit.DataCollections.CollectionEvents.ModesOfCollection

stdyDscr.method.dataColl.resInstru

StudyUnit.DataCollections.CollectionEvents.Instruments

stdyDscr.method.dataColl.sources.dataSrc

StudyUnit.DataCollections.CollectionEvents.DataSources

stdyDscr.method.dataColl.collSitu

StudyUnit.DataCollections.CollectionEvents.CollectionSItuations

stdyDscr.method.dataColl.actMin

StudyUnit.DataCollections.CollectionEvents.ActionsToMinimizeLosses

stdyDscr.method.dataColl.ConOps

StudyUnit.DataCollections.ProcessingEvents.ProcessingEvent.ControlOperation

stdyDscr.method.dataColl.weight

StudyUnit.DataCollections.ProcessingEvents.ProcessingEvent.Weighting

stdyDscr.method.dataColl.cleanOps

StudyUnit.DataCollections.ProcessingEvents.ProcessingEvent.CleaningOperation

stdyDscr.method.notes

NA

stdyDscr.method.anlyInfo

StudyUnit.AnalysisUnits

stdyDscr.method.anlyInfo.respRate

StudyUnit.DataCollections.ProcessingEvents.ProcessingEvent.ResponseRateDescription

stdyDscr.method.anlyInfo.EstSmpErr

StudyUnit.DataCollections.ProcessingEvents.ProcessingEvent.SamplingError

stdyDscr.method.anlyInfo.dataAppr

StudyUnit.DataCollections.ProcessingEvents.ProcessingEvent.OtherAppraisalProcess

stdyDscr.method.stdyClas

NA

stdyDscr.dataAccs

NA

stdyDscr.dataAccs.setAvail

NA

stdyDscr.dataAccs.setAvail media

NA

stdyDscr.dataAccs.setAvail.accsPlac

NA

stdyDscr.dataAccs.setAvail.accsPlac URI

NA

stdyDscr.dataAccs.setAvail.origArch

NA

stdyDscr.dataAccs.setAvail.avlStatus

NA

stdyDscr.dataAccs.setAvail.collSize

NA

stdyDscr.dataAccs.setAvail.complete

NA

stdyDscr.dataAccs.setAvail.fileQnty

NA

stdyDscr.dataAccs.setAvail.notes

NA

stdyDscr.dataAccs.useStmt

Archives.Archieve.ArchieveSpecifics.DefaultAccess.Access

stdyDscr.dataAccs.useStmt.confDec

Archives.Archieve.ArchieveSpecifics.DefaultAccess.Access.ConfidentialityStatement

stdyDscr.dataAccs.useStmt.confDec required

NA

stdyDscr.dataAccs.useStmt.confDec formNo

NA

stdyDscr.dataAccs.useStmt.confDec URI

NA

stdyDscr.dataAccs.useStmt.specPerm

NA

stdyDscr.dataAccs.useStmt.specPerm required

NA

stdyDscr.dataAccs.useStmt.specPerm formNo

NA

stdyDscr.dataAccs.useStmt.specPerm URI

NA

stdyDscr.dataAccs.useStmt.restrctn

Archives.HoldingInformation.Archieve.ArchieveSpecifics.DefaultAccess.Access.Restrictions

stdyDscr.dataAccs.useStmt.contact

Archives.HoldingInformation.Archieve.ArchieveSpecifics.DefaultAccess.Access.ContactOrganization

stdyDscr.dataAccs.useStmt.contact affiliation

NA

stdyDscr.dataAccs.useStmt.contact URI

Archives.HoldingInformation.Archieve.ArchieveSpecifics.DefaultAccess.Access.ContactOrganization.OrganizationImageUri

stdyDscr.dataAccs.useStmt.contact email

Archives.HoldingInformation.Archieve.ArchieveSpecifics.DefaultAccess.Access.ContactOrganization.OrganizationRegistryId

stdyDscr.dataAccs.useStmt.citReq

Archives.HoldingInformation.Archieve.ArchieveSpecifics.DefaultAccess.Access.CitationRequirement

stdyDscr.dataAccs.useStmt.deposReq

Archives.HoldingInformation.Archieve.ArchieveSpecifics.DefaultAccess.Access.DepositionRequirement

stdyDscr.dataAccs.useStmt.disclaimer

Archives.HoldingInformation.Archieve.ArchieveSpecifics.DefaultAccess.Access.Dsiclaimer

stdyDscr.dataAccs.useStmt.conditions

Archives.HoldingInformation.Archieve.ArchieveSpecifics.DefaultAccess.Access.AccessConditions

stdyDscr.dataAccs.notes

Archives.HoldingInformation.Archieve.ArchieveSpecifics.DefaultAccess.Access.Description

stdyDscr.othrStdyMat

StudyUnit.PhysicalInstance.OtherMaterials

stdyDscr.othrStdyMat.relMat

StudyUnit.PhysicalInstance.OtherMaterials.DublinCoreMetadata.SubTitle.Current

stdyDscr.othrStdyMat.relMat.citation.titlStmt.titl

StudyUnit.PhysicalInstance.OtherMaterials.DublinCoreMetadata.Title

stdyDscr.othrStdyMat.relMat.citation.holdings URI

StudyUnit.PhysicalInstance.OtherMaterials.UrlReference

stdyDscr.othrStdyMat.relMat.citation.notes

StudyUnit.PhysicalInstance.OtherMaterials.DublinCoreMetadata.Description.Current

stdyDscr.othrStdyMat.relStdy

StudyUnit.PhysicalInstance.OtherMaterials.DublinCoreMetadata.SubTitle.Current

stdyDscr.othrStdyMat.relStdy.citation.titlStmt.titl

StudyUnit.PhysicalInstance.OtherMaterials.DublinCoreMetadata.Title

stdyDscr.othrStdyMat.relStdy.citation.holdings URI

StudyUnit.PhysicalInstance.OtherMaterials.UrlReference

stdyDscr.othrStdyMat.relStdy.citation.notes

StudyUnit.PhysicalInstance.OtherMaterials.DublinCoreMetadata.Description.Current

stdyDscr.othrStdyMat.relPubl

StudyUnit.PhysicalInstance.OtherMaterials.DublinCoreMetadata.SubTitle.Current

stdyDscr.othrStdyMat.relPubl.citation.titlStmt.titl

StudyUnit.PhysicalInstance.OtherMaterials.DublinCoreMetadata.Title

stdyDscr.othrStdyMat.relPubl.citation.holdings URI

StudyUnit.PhysicalInstance.OtherMaterials.UrlReference

stdyDscr.othrStdyMat.relPubl.citation.notes

StudyUnit.PhysicalInstance.OtherMaterials.DublinCoreMetadata.Description.Current

stdyDscr.othrStdyMat.othRefs

StudyUnit.PhysicalInstance.OtherMaterials.DublinCoreMetadata.SubTitle.Current

stdyDscr.othrStdyMat.othRefs.citation.titlStmt.titl

StudyUnit.PhysicalInstance.OtherMaterials.DublinCoreMetadata.Title

stdyDscr.othrStdyMat.othRefs.citation.holdings URI

StudyUnit.PhysicalInstance.OtherMaterials.UrlReference

stdyDscr.othrStdyMat.othRefs.citation.notes

StudyUnit.PhysicalInstance.OtherMaterials.DublinCoreMetadata.Description.Current

File Description

DDI2

DDI3/Colectica SDK

fileDscr

PhysicalInstance.FileIdentifications

fileDscr.URI

NA

fileDscr.fileTxt

DataFileIdentification

fileDscr.fileTxt.FileName

DataFileIdentification.path

fileDscr.fileTxt.FileName ID

DataFileIdentification.Identifier

fileDscr.fileTxt.dimensns

PhysicalInstance.FileStructure

fileDscr.fileTxt.dimensns.caseQnty

PhysicalInstance.FileStructure.GrossFileStructure.CaseQuantity

fileDscr.fileTxt.dimensns.varQnty

NA

fileDscr.fileTxt.fileType

PhysicalInstance.Format

fileDscr.fileTxt.fileCont

NA

fileDscr.fileTxt.fileStrc

NA

fileDscr.fileTxt.fileStrc type

NA

fileDscr.fileTxt.fileStrc.recGrp

NA

fileDscr.fileTxt.dataChck

NA

fileDscr.fileTxt.fileCont.dataMsng

NA

fileDscr.fileTxt.fileCont.verStmt

NA

fileDscr.fileTxt.fileCont.verStmt.version

NA

fileDscr.fileTxt.fileCont.verStmt.notes

NA

fileDscr.fileTxt.filePlac

NA

fileDscr.fileTxt.ProcStat

NA

fileDscr.fileTxt.dataMsng

NA

fileDscr.fileTxt.verStmt

NA

fileDscr.fileTxt.verStmt.version

NA

fileDscr.fileTxt.verStmt.notes

NA

Data Description

DDI2

DDI3/Colectica SDK

dataDscr

PhysicalInstance.DataRelationShips.DataRelationship

dataDscr.var

PhysicalInstance.DataRelationShips.DataRelationship.LogicalRecords.VariableSchemesInRecord.VariableScheme.Variables

dataDscr.var ID

Variable.Identifier

dataDscr.var name

Variable.ItemName

dataDscr.var files

Variable.Attachments

dataDscr.var dcml

If it is NumericDomain, skip; if it is a CodeList, add to CodeList.CategoryScheme.Categories

dataDscr.var intrvl

CodeList.Level.Interval

dataDscr.var.labl

Variable.Label

dataDscr.var.labl level

NA

dataDscr.var.qstn

QuestionActivity.Question

dataDscr.var.qstn.preQTxt

UserAttribute key=”preQTxt”

dataDscr.var.qstn.qstnLit

question.QuestionText[language]

dataDscr.var.qstn.postQTxt

UserAttribute key=”posQTxt”

dataDscr.var.qstn.ivuInstr

question.InterviewInstruction[“language”]

dataDscr.var.valrng

question.responseDomain

dataDscr.var.valrng.range

NumericDomain

dataDscr.var.valrng.range max

NumericDomain.High

dataDscr.var.valrng.range min

NumericDomain.Low

dataDscr.var.sumStat

PhysicalInstance.Statistics

dataDscr.var.sumStat type = vald

PhysicalInstance.VariableStatistic.Valid

dataDscr.var.sumStat type = min

PhysicalInstance.VariableStatistic.Minimum

dataDscr.var.sumStat type = max

PhysicalInstance.VariableStatistic.Maximum

dataDscr.var.sumStat type = mean

PhysicalInstance.VariableStatistic.Mean

dataDscr.var.sumStat type = stdev

PhysicalInstance.VariableStatistic.StandardDeviation

dataDscr.var.valrng.range UNITS

Variables.MeasurementUnit

dataDscr.var.location

NA

dataDscr.var.location.width

NA

dataDscr.var.location.RecSegNo

NA

dataDscr.var.invalrng

NA

dataDscr.var.invalrng.range

NA

dataDscr.var.invalrng.range.min

NA

dataDscr.var.invalrng.range.max

NA

dataDscr.var.invalrng.item

NA

dataDscr.var.invalrng.item.VALUE

NA

dataDscr.var.invalrng.item.UNITS

NA

dataDscr.var.universe

Variable.Universes

dataDscr.var.universe.clusion

Variable.Universes.Universe.IsInclusive

dataDscr.var.catgry

Code.Category

dataDscr.var.catgry.catValu

Code.Value

dataDscr.var.catgry.labl

Code.Category.Label

dataDscr.var.catgry.missing

Code.Category.isMissing

dataDscr.var.varFormat

Determine the variable type

dataDscr.var.varFormat.type

variable.RepresentationType

dataDscr.var.varFormat.schema

variable.TextRepresentation.Description

dataDscr.var.notes

variable.Description

dataDscr.var wgt

NA

dataDscr.version

NA

dataDscr.varGrp

StudyUnit.ResourcesPackages.variableSchema

dataDscr.varGrp.ID

PhysicalInstance.VariableGroup.AgencyId

dataDscr.varGrp type

PhysicalInstance.VariableGroup.TypeOfGroup.Value

dataDscr.varGrp var

PhysicalInstance.VariableGroup.Items

dataDscr.varGrp.labl

PhysicalInstance.VariableGroup.Label

dataDscr.varGrp.txt

PhysicalInstance.VariableGroup.Desciption

dataDscr.varGrp.defntn

PhysicalInstance.VariableGroup.Description

dataDscr.varGrp.universe

PhysicalInstance.VariableGroup.Universes

dataDscr.varGrp.universe clusion

PhysicalInstance.VariableGroup.Universes.Universe.isInclusion

dataDscr.varGrp.notes

NA

dataDscr.ID

NA

dataDscr.xml-lang

NA

Other Study Materials

DDI2

DDI3/Colectica SDK

otherMat

StudyUnit.PhysicalInstance.OtherMaterials

otherMat level

NA

otherMat URI

StudyUnit.PhysicalInstance.OtherMaterials.UrlReference

otherMat.labl

StudyUnit.PhysicalInstance.OtherMaterials.DublinCoreMetadata.Title

otherMat.txt

StudyUnit.PhysicalInstance.OtherMaterials.DublinCoreMetadata.SubTitle

otherMat.notes

StudyUnit.PhysicalInstance.OtherMaterials.DublinCoreMetadata.Description