|
|
 next
|
  Subject: 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
|
|
|
|
top