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

[Kevin Moore]

Hi Martin,

The only thing I can suggest is that you use a 3rd party too to parse
the XML filel, or develop a dll which you can call into from openroad.  

It would be a doddle to write in .NET / c# if you have any c# guru's
there?

Cheers

Kev


>  -----Original Message-----
> From: 	openroad-users-bounces at peerlessit.com
> [mailto:openroad-users-bounces at peerlessit.com]  On Behalf Of
> Bloomfield, Martin (PSD)
> Sent:	13 November 2006 15:08
> To:	Openroad-Users
> Subject:	Importing XML files into Ingres/OpenROAD
> 
> 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
>  << File: ATT140855.txt >> 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://peerlessit.com/pipermail/openroad-users/attachments/20061113/ad428722/attachment.html