[DDI-users] Access to DDI

[R.T.A.M. Grim]

Hi Michelle,

As often there is more than one way to get from A to B.
Here is one of many:
- read the access file into SPSS (with ODBC);
- use SPSS-OMS to save data in a XML format;
- use Joachim Wackerow's (ZUMA
http://www.gesis.org/en/software/ddi/tools/spssoms2ddi/),
  XSL transformation file for conversion to DDI, or use NESSTAR directly.

Notes: 1. SPSS-OMS is an XML Output Management System, which converts
SPSS-data to XML;
          2. Not all DDI-elements are captured with Joachim's script above.

Does this help?

Rob
Rob Grim
Tilburg University
Institute for Labour Studies
P.O. Box 90153
5000 LE Tilburg
Tel: + 31 (0)13-466 8077
Mailto: rob.grim at uvt.nl












  -----Original Message-----
  From: ddi-users-bounces at icpsr.umich.edu
[mailto:ddi-users-bounces at icpsr.umich.edu]On Behalf Of A. Michelle Edwards
  Sent: donderdag 19 mei 2005 20:42
  To: Data Documentation Initiative Users Group
  Subject: [DDI-users] Access to DDI


  Good afternoon all!

  Hope everyone's enjoying the beginning of what we hope to be a great
summer!

  I recall that there are a number of DDI users out there using Access or
some other form of database to build their DDI documents.  Sorry I can't
remember names or the like but I do recall a couple of presentations I
attended last year at IASSIST to this effect.  I'm wondering how you would
go about translating the contents of the Access database to an XML document.
Is there a script out there that someone has written?  or is there some
functionality in Access that allows one to accomplish this.

  Any suggestions or assistance would be greatly appreciated.  We have a
local research group who currently hold their metadata in an Access database
and are looking to make the move to Nesstar.  I had suggested going from
Access to XML and then importing into Nesstar - but am unsure myself how the
move from Access to XML would work.

  Thanks and look forward to hearing from you,
  Michelle

  ___________________________________
  A. Michelle Edwards, Ph.D.
  Academic Services, CCS
  Vehicle Services Bldg, University of Guelph
  Guelph, Ontario
  N1G 2W1

  PH: (519) 824-4120 Ext. 54539
  FAX: (519) 767-1620
  Email: edwardsm at uoguelph.ca
  ___________________________________
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.icpsr.umich.edu/pipermail/ddi-users/attachments/20050520/b5f08139/attachment.html