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.AnalysisUnit
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.AnalysisUnit
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