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.
Click the Import DDI button from the Import ribbon tab.
The import wizard will open. Click the Choose input files button to select the file you wish to import.
Click the Next button.
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.
Colectica will read the DDI file and show you a summary of its contents.
Click the Finish button.
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 |