[DDI-users] RE: DDI-users Digest, Vol 16, Issue 2

[Jon Johnson]

Rob 

I have written a python program that will take an SPSS portable format file
and create a ddi compliant xml file. Its still beta at the moment as there
are some wrinkles, especially unique ID's, but it may be suitable for your
purposes.

It also currently writes out a SIR schema and the datafile for import. It
would not be too much work to write a module that writes an Oracle/MySQL
schema and the appropriate 

On a side point if it is not too late, I would suggest you look at using SIR
if you are storing and manipulating survey data, it is far more flexible
than a relational database.

cheers

Jon Johnson
Senior Database Manager
Centre for Longitudinal Studies

Email: j.johnson at ioe.ac.uk
Tel: +44 (0) 20 7612 6571
Fax: +44 (0) 20 7612 6686

Room 641, Institute of Education, 20 Bedford Way, London WC1H 0AL
 


-----Original Message-----
From: ddi-users-bounces at icpsr.umich.edu
[mailto:ddi-users-bounces at icpsr.umich.edu] On Behalf Of
ddi-users-request at icpsr.umich.edu
Sent: 07 July 2005 17:01
To: ddi-users at icpsr.umich.edu
Subject: DDI-users Digest, Vol 16, Issue 2

Send DDI-users mailing list submissions to
	ddi-users at icpsr.umich.edu

To subscribe or unsubscribe via the World Wide Web, visit
	http://www.icpsr.umich.edu/mailman/listinfo/ddi-users
or, via email, send a message with subject or body 'help' to
	ddi-users-request at icpsr.umich.edu

You can reach the person managing the list at
	ddi-users-owner at icpsr.umich.edu

When replying, please edit your Subject line so it is more specific than
"Re: Contents of DDI-users digest..."


Today's Topics:

   1. DDI-elements (R.T.A.M. Grim)


----------------------------------------------------------------------

Message: 1
Date: Thu, 7 Jul 2005 12:02:19 +0200
From: "R.T.A.M. Grim" <Rob.Grim at uvt.nl>
Subject: [DDI-users] DDI-elements
To: "DDI" <ddi-users at icpsr.umich.edu>
Message-ID: <GBEOLHGBKCGKOBFDEJHHKEOFCDAA.Rob.Grim at uvt.nl>
Content-Type: text/plain;	charset="iso-8859-1"

Hi list,

I am converting (SPSS) data-files and metadata to a Mysql and a Oracle
database. I have two questions relating to this subject:

1. I wonder if there's anyone who has already made a setup with 'create
table' statements for ddi-elements in Mysql (or Oracle 9i, or both?) and is
willing to share these set-up files?

2. Can anyone point me to a working example (or example-code) how to link
ddi-elements to (external) controlled vocabularies;

In general, tips and tricks, do's and don'ts, are welcomed at this phase,
for creating and deploying searchable ddi-catalogs.

Thnx in advance for your reaction!

Rob



Rob Grim
Institute for Labour Studies
Tiburg University (Netherlands)
+31 13 466 80 77
Mailto: rob.grim at uvt.nl





------------------------------

_______________________________________________
DDI-users mailing list
DDI-users at icpsr.umich.edu
http://www.icpsr.umich.edu/mailman/listinfo/ddi-users


End of DDI-users Digest, Vol 16, Issue 2
****************************************