XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Show tree view Topic
Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Go to previous topicPrev TopicGo to next topicNext Topic
Postnext
David StandenSubject: XML To Flat File - Reverse Engineering?
Author: David Standen
Date: 05 Oct 2009 01:13 PM
Hi all - apologies if this is in the wrong section. I have trawled the SSDN for details of flat files, but the conversion seems one way - Flat to XML and I was wondering if Stylus Studio could do the reverse and map XML data into a flat file.

The reason that I am doing this is because of a hard-coded loading system on a legacy database product and a recent change in the submission of data, which no longer conforms to the loading scheme.

Since I am evaluating Stylus Studio pre-purchase, I wanted to get some expert advice because I could be (and probably am) struggling to re-invent the wheel when there is probably a feature that achieves what I am looking for already built in.

Here is a sample of my XML data, which is pretty straight forward.

<?xml version="1.0" encoding="utf-8"?><!DOCTYPE inis SYSTEM "INIS_Atomindex_DTD_v24.dtd"><inis version="1.0">
<inisrecords volume="39" issue="1">
<inisrecord>
<action trn="CA07E2732" type="add"/>
<record role="document" source-system="fibre" trn="CA07E2732" type="journal" rn="39000001">
<publication>
<languages>
<language key="fr">French</language>
</languages>
<titles>
<title type="primary" xml:lang="en">Environmental monitoring of a wind park during the construction phase</title>
<title type="original" xml:lang="fr">Surveillance environnementale d'un parc eolien en phase de construction</title>
</titles>
<date value="2007-09-" sici-chronology="200709">Sep 2007</date>
<physical-description>p. 22-23</physical-description>
<country key="CA">Canada</country>
<creators and-others="no">
<creator type="personal">Castonguay, M.</creator>
<creator type="personal">Caron, F.</creator>
<creator type="affiliation">Pesca Environnement, Maria, PQ (Canada)</creator>
</creators>
<availability inis="no"/>
<is-part-of>
<journal>
<titles>
<title type="primary">Maitrise de l'Energie</title>
</titles>
<identifiers>
<identifier type="issn">0831-4667</identifier>
<identifier type="coden">MAIEEK</identifier>
</identifiers>
<physical-description>v. 22(3)</physical-description>
</journal>
</is-part-of>
</publication>
<classification>
<categories>
<category type="common" level="primary" key="S17">WIND ENERGY</category>
</categories>
<descriptors>
<descriptor type="valid" key="19591" assignment="indexer">air quality</descriptor>
<descriptor type="valid" key="12393" assignment="indexer">construction</descriptor>
<descriptor type="valid" key="02566" assignment="indexer">demolition</descriptor>
<descriptor type="valid" key="19805" assignment="indexer">environmental impacts</descriptor>
<descriptor type="valid" key="06274" assignment="indexer">monitoring</descriptor>
<descriptor type="valid" key="06753" assignment="indexer">noise</descriptor>
<descriptor type="valid" key="06941" assignment="indexer">operation</descriptor>
<descriptor type="valid" key="11528" assignment="indexer">quebec</descriptor>
<descriptor type="valid" key="25295" assignment="indexer">roads</descriptor>
<descriptor type="valid" key="25519" assignment="indexer">wind turbine arrays</descriptor>
<descriptor type="valid" key="10995" assignment="indexer">working conditions</descriptor>
<descriptor type="valid" key="01528" assignment="upposted">canada</descriptor>
<descriptor type="valid" key="21600" assignment="upposted">developed countries</descriptor>
<descriptor type="valid" key="24736" assignment="upposted">environmental quality</descriptor>
<descriptor type="valid" key="06772" assignment="upposted">north america</descriptor>
</descriptors>
<abstracts>
<abstract content="available" xml:lang="en">Wind energy qualifies as green energy because of low gas emissions associated with energy production. However, in order to truly qualify as green, each phase of a wind energy project should be evaluated, including construction, the energy exploitation period, as well as the dismantling of the turbines. Environmental monitoring of wind turbine arrays during the construction and dismantling phases could reveal the environmental impact of a project. This article provided the example of a wind turbine array at l'Anse-a-Valleau, located in a forested territory on the north side of the Gaspe Peninsula along the St. Lawrence River in Quebec. The park was configured to have 67 wind turbines of 1.5 MW each, for a total of 100.5 MW. The project was evaluated at $164 million, with regional economic spending of $65.8 million. During the height of construction, the project employed 240 workers. Ten full-time jobs will be created for the operation phase, scheduled for the end of 2007. The environmental monitoring at the construction site is deemed both technical and social. Good working conditions and communication must be established between the environmental supervisor and the site manager. They must work jointly to ensure good conduct and progress of the work at the construction site. The environmental supervisor must have the necessary authority to stop work upon a breach of regulations in the deforesting phase, since 60 per cent of the territory is on public domain. Environmental monitoring also includes surveillance of the road construction, soil quality, transportation of equipment, air quality, noise pollution, and residual matter management. It was concluded that wind energy is a true form of green energy, and methods used by developers during construction demonstrate responsibility towards the environment. It was suggested that the key to success is to have good pre-planning and good communication between all parties concerned. 4 figs</abstract>
</abstracts>
</classification>
<administratives>
<input-center type="subj" key="CA">Canada</input-center>
<rights held-by="inis">INIS</rights>
</administratives>
</record>
</inisrecord>

Lets assume that from this XML I needed to get the first 5 fields and output them as:

<BeginRecord>
RN
39000001
LANGUAGE
French
TITLE
Environmental monitoring of a wind park during the construction phase
OTITLE
Surveillance environnementale d'un parc eolien en phase de construction
DATE
Sep 2007
<EndRecord>

Also in the data are a series of indexer tags (example below)

<descriptor type="valid" key="19591" assignment="indexer">air quality</descriptor>
<descriptor type="valid" key="12393" assignment="indexer">construction</descriptor>
<descriptor type="valid" key="02566" assignment="indexer">demolition</descriptor>
<descriptor type="valid" key="19805" assignment="indexer">environmental impacts</descriptor>
<descriptor type="valid" key="06274" assignment="indexer">monitoring</descriptor>
<descriptor type="valid" key="06753" assignment="indexer">noise</descriptor>

These would need to be added as

DESCRIPTORS
air quality; construction; demolition; environmental impacts; monitoring; noise etc and so on.

Can anyone give me a head start as to a) Can Stylus Studio do this sort of thing and b) How I would go about setting up said programme to undertake the data conversion?

Any help very gratefully received.

David

Postnext
Ivan PedruzziSubject: XML To Flat File - Reverse Engineering?
Author: Ivan Pedruzzi
Date: 06 Oct 2009 06:04 PM

Hi David,

Which database product you need to work with?



Ivan Pedruzzi
Stylus Studio Team

Posttop
David StandenSubject: XML To Flat File - Reverse Engineering?
Author: David Standen
Date: 06 Oct 2009 06:46 PM
I am working with a proprietary database format known as CVR. The loading program is based on a line by line feed with field titles on lines preceding the actual data itself.

Hence...

FIELD1
Data
FIELD2
Data
FIELD3
Data; Data; Data;

FIELD3 in this example might be a series of author names, culled from the XML.

Any help that you or the technical team can give would be very much appreciated. I know everyone says this, but I am on a deadline to find a solution. I have some time yet, which is why I am exploring this product as it looks like it could probably do what I want, but unless I can see that for myself, it is too high a price tag and my demo ran out without me reaching anywhere like the level of expertise that I think I am going to need.

Regards,


David

 
Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Go to previous topicPrev TopicGo to next topicNext Topic
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!  
go

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.