[Openroad-users] Importing XML files into Ingres/OpenROAD

[Bloomfield, Martin (PSD)]

OpenROAD experts,

We are starting on a new project that involves receiving analysis
results from various laboratories.  Currently these results are sent to
us in flat (^ separated) text files.  However, the labs have great
difficulty creating these files accurately.  We have been requested to
change the format of these files to be XML, for which a schema is
currently being developed.

The problem I have is how to process these XML files using OpenROAD to
get the information into our Ingres database.  None of us at PSD have
any experience of working with XML files and I have not been able to
find any information on importing data from XML into Ingres, apart from
mention of the xmlimport function provided as part of Application
Server.  We are currently looking at creating a standard OpenROAD
client-server application as there are no web requirements.

Has anyone any experience of importing XML files into an Ingres
database, and if so can you provide any advice / guidance as to the best
way of doing this?  Alternatively, can anyone point me in the direction
of some guidance documentation on how to go about processing XML files
and importing the data into an Ingres database.  

We are currently using Ingres 2006 (r3) on Windows as our back-end and
OpenROAD 4.1 SP2 on Windows XP for clients.

Many thanks for any assistance.

Martin Bloomfield.
____________________________________________
Application Developer & Database Administrator
IT Branch,
Pesticides Safety Directorate
YORK

Email: martin.bloomfield at psd.defra.gsi.gov.uk
Website: www.pesticides.gov.uk

Department for Environment, Food and Rural Affairs (Defra)

This email and any attachments is intended for the named recipient only.
If you have received it in error you have no authority to use, disclose,
store or copy any of its contents and you should destroy it and inform
the sender.
Whilst this email and associated attachments will have been checked
for known viruses whilst within Defra systems we can accept no
responsibility once it has left our systems.
Communications on Defra's computer systems may be monitored and/or
recorded to secure the effective operation of the system and for other
lawful purposes.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/ms-tnef
Size: 3029 bytes
Desc: not available
Url : http://peerlessit.com/pipermail/openroad-users/attachments/20061113/f6e3f1f6/attachment.bin