Xml to csv Post: 302992901

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Help to convert XML to CSV

Apologies if this has already been covered in this site somewhere, I did try looking but without any success. I am new to the whole XML thing, very late starter, and have a requirement to convert an XML fiule to a CSV fomat. I am crrently working on a Solaris OS. Does anyone have any suggestions,...

2. Shell Programming and Scripting

CSV to XML

Iam pretty new to UNIX and would like to convert a CSV to an XML file using AWK scripts. Can anybody suggest a solution? My CSV file looks something like this : Serial No Growth% Annual % Commission % Unemployed % 1 35% 29% 59% 42% 2 61% ...

3. Shell Programming and Scripting

CSV processing to XML

Hi, i am really fresh with shell scripting and programming, i have an issue i am not able to solve to populate data on my server for Cisco IP phones. I have CSV file within the following format: ;;;;;;;;;;;;;;;;;; ;;;;;;;;;;;;;;;;;; ;;;;;;;;;;;;;;;;;; ;;;;;;;;;;;;;;;;;; ;;;;;;;;;;;;;;;;;;...

4. Shell Programming and Scripting

XML to csv transformation

Hi, I want to write a perl script. Which should accept the xml file, one xsl file and the loaction. The perl script should process the xml file using the xsl file and puts the out put in specified location. For example: My.perl is perls cript. my.xml is like this <?xml version="1.0"...

5. Shell Programming and Scripting

XML to CSV specific

Hi , Please any one to help on ,extract this xml code into csv columns list. <SOURCEFIELD BUSINESSNAME ="" DATATYPE ="date" DESCRIPTION ="" FIELDNUMBER ="1" FIELDPROPERTY ="0" FIELDTYPE ="ELEMITEM" HIDDEN ="NO" KEYTYPE ="NOT A KEY" LENGTH ="19" LEVEL ="0" NAME ="BUSINESS_DATE"...

6. Shell Programming and Scripting

Convert xml to csv

I need to convert below xml code to csv. I searched other posts as well but this post (_https://www.unix.com/shell-programming-scripting/174417-extract-parse-xml-data-statistic-value-csv.html) gives "sed command garbled" error. As of now I have written a long script to do it, but can it be done with...

7. Shell Programming and Scripting

How to convert xml to csv ?

I am in need of converting billions of XML into csv file to load data to DB, i have found the below code in perl but not sure why it's not working properly. CODE: #!/usr/bin/perl # Script to illustrate how to parse a simple XML file # and pick out all the values for a specific element, in...

8. Shell Programming and Scripting

XML to CSV

I want to pharse below Xml Using Shell Scripting . Thanks in Advance <md> <neid> <neun>1523</neun> <nedn>XXX1212</nedn> <nesw>fffff12515</nesw> </neid> <mi> <mts>20141128001500</mts> <gp>550</gp> <mt>pmct1</mt> <mt>pmNo2</mt> <mt>pmNo3S</mt> <mv> <moid>Ma=1,Rn=1,Ul=311C</moid>...

9. UNIX for Beginners Questions & Answers

Xml to csv (again)

Hello, I have copied .xml code for a single item below. I am trying to extract three items (field indices*b244 (second occurrence), b203, and j151), so the desired output would be: 9780323013543 Manual of Natural Veterinary Medicine: Science and Tradition, 1e 68.95 A parallel solution,...

10. Shell Programming and Scripting

Converting XML to CSV

Hello, For i while i have been using XMLStarlet to convert several XML files to CSV files. So far this always went fine. Today however i got a new XML format however but i cannot find out how to get the data i need. Below is part of the code where it shows the different format. What...

LEARN ABOUT DEBIAN

mkdoc::xml::treebuilder

MKDoc::XML::TreeBuilder(3pm)				User Contributed Perl Documentation			      MKDoc::XML::TreeBuilder(3pm)

NAME

       MKDoc::XML::TreeBuilder - Builds a parsed tree from XML data

SYNOPSIS

	 my @top_nodes = MKDoc::XML::TreeBuilder->process_data ($some_xml);

SUMMARY

       MKDoc::XML::TreeBuilder uses MKDoc::XML::Tokenizer to turn XML data into a parsed tree. Basically it smells like an XML parser, looks like
       an XML parser, and awfully overlaps with XML parsers.

       But it's not an XML parser.

       XML parsers are required to die if the XML data is not well formed.  MKDoc::XML::TreeBuilder doesn't give a rip: it'll parse whatever as
       long as it's good enough for it to parse.

       XML parsers expand entities. MKDoc::XML::TreeBuilder doesn't.  At least not yet.

       XML parsers generally support namespaces. MKDoc::XML::TreeBuilder doesn't - and probably won't.

DISCLAIMER

       This module does low level XML manipulation. It will somehow parse even broken XML and try to do something with it. Do not use it unless
       you know what you're doing.

API

   my @top_nodes = MKDoc::XML::Tokenizer->process_data ($some_xml);
       Returns all the top nodes of the $some_xml parsed tree.

       Although the XML spec says that there can be only one top element in an XML file, you have to take two things into account:

       1. Pseudo-elements such as XML declarations, processing instructions, and comments.

       2. MKDoc::XML::TreeBuilder is not an XML parser, it's not its job to care about the XML specification, so having multiple top elements is
       just fine.

   my $tokens = MKDoc::XML::Tokenizer->process_data ('/some/file.xml');
       Same as MKDoc::XML::TreeBuilder->process_data ($some_xml), except that it reads $some_xml from '/some/file.xml'.

Returned parsed tree - data structure
       I have tried to make MKDoc::XML::TreeBuilder look enormously like HTML::TreeBuilder.  So most of this section is stolen and slightly
       adapted from the HTML::Element man page.

       START PLAGIARISM HERE

       It may occur to you to wonder what exactly a "tree" is, and how it's represented in memory.  Consider this HTML document:

	 <html lang='en-US'>
	   <head>
	     <title>Stuff</title>
	     <meta name='author' content='Jojo' />
	   </head>
	   <body>
	    <h1>I like potatoes!</h1>
	   </body>
	 </html>

       Building a syntax tree out of it makes a tree-structure in memory that could be diagrammed as:

			    html (lang='en-US')
			     / 
			   /	 
			 /	   
		       head	   body
		      /	       
		    /	 		 
		  /	   		   
		title	  meta		    h1
		 |	 (name='author',     |
	      "Stuff"	 content='Jojo')    "I like potatoes"

       This is the traditional way to diagram a tree, with the "root" at the top, and it's this kind of diagram that people have in mind when they
       say, for example, that "the meta element is under the head element instead of under the body element".  (The same is also said with
       "inside" instead of "under" -- the use of "inside" makes more sense when you're looking at the HTML source.)

       Another way to represent the above tree is with indenting:

	 html (attributes: lang='en-US')
	   head
	     title
	       "Stuff"
	     meta (attributes: name='author' content='Jojo')
	   body
	     h1
	       "I like potatoes"

       Incidentally, diagramming with indenting works much better for very large trees, and is easier for a program to generate.  The $tree->dump
       method uses indentation just that way.

       However you diagram the tree, it's stored the same in memory -- it's a network of objects, each of which has attributes like so:

	 element #1:  _tag: 'html'
		      _parent: none
		      _content: [element #2, element #5]
		      lang: 'en-US'

	 element #2:  _tag: 'head'
		      _parent: element #1
		      _content: [element #3, element #4]

	 element #3:  _tag: 'title'
		      _parent: element #2
		      _content: [text segment "Stuff"]

	 element #4   _tag: 'meta'
		      _parent: element #2
		      _content: none
		      name: author
		      content: Jojo

	 element #5   _tag: 'body'
		      _parent: element #1
		      _content: [element #6]

	 element #6   _tag: 'h1'
		      _parent: element #5
		      _content: [text segment "I like potatoes"]

       The "treeness" of the tree-structure that these elements comprise is not an aspect of any particular object, but is emergent from the
       relatedness attributes (_parent and _content) of these element-objects and from how you use them to get from element to element.

       STOP PLAGIARISM HERE

       This is pretty much the kind of data structure MKDoc::XML::TreeBuilder returns. More information on different nodes and their type is
       available in MKDoc::XML::Token.

NOTES

       Did I mention that MKDoc::XML::TreeBuilder is NOT an XML parser?

AUTHOR

       Copyright 2003 - MKDoc Holdings Ltd.

       Author: Jean-Michel Hiver

       This module is free software and is distributed under the same license as Perl itself. Use it at your own risk.

SEE ALSO

       MKDoc::XML::Token MKDoc::XML::Tokenizer

perl v5.10.1							    2004-10-06					      MKDoc::XML::TreeBuilder(3pm)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Help to convert XML to CSV

Discussion started by: rossingi_33

2. Shell Programming and Scripting

CSV to XML

Discussion started by: pjanakir

3. Shell Programming and Scripting

CSV processing to XML

Discussion started by: angel2008

4. Shell Programming and Scripting

XML to csv transformation

Discussion started by: siba.s.nayak