03-13-2017
Hi,
I'm going to be the Devil's Advocate here and suggest something entirely different. If this is a one-time-only conversion you have to do, or if it's something you won't have to do on a regular basis, I'd honestly import the XML into a spreadsheet like MS Excel or OpenOffice/LibreOffice Calc, and then look at tidying it up and exporting it out as a CSV from there.
Of course if this is going to be an ongoing thing you anticipate needing to do many times per day forever then some kind of script would be desirable, but if it's not going to be something you have to spend lots of time doing then you may actually save more time using a spreadsheet than trying to write a script for this.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
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 Replies)
Discussion started by: rossingi_33
2 Replies
2. Shell Programming and Scripting
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% ... (15 Replies)
Discussion started by: pjanakir
15 Replies
3. Shell Programming and Scripting
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:
;;;;;;;;;;;;;;;;;;
;;;;;;;;;;;;;;;;;;
;;;;;;;;;;;;;;;;;;
;;;;;;;;;;;;;;;;;;
;;;;;;;;;;;;;;;;;;... (9 Replies)
Discussion started by: angel2008
9 Replies
4. Shell Programming and Scripting
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"... (2 Replies)
Discussion started by: siba.s.nayak
2 Replies
5. Shell Programming and Scripting
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"... (4 Replies)
Discussion started by: mohan705
4 Replies
6. Shell Programming and Scripting
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 Replies)
Discussion started by: dineshydv
7 Replies
7. Shell Programming and Scripting
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... (1 Reply)
Discussion started by: rspwilliam
1 Replies
8. Shell Programming and Scripting
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>... (6 Replies)
Discussion started by: pareshkp
6 Replies
9. UNIX for Beginners Questions & Answers
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,... (14 Replies)
Discussion started by: palex
14 Replies
10. Shell Programming and Scripting
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... (10 Replies)
Discussion started by: SDohmen
10 Replies
LEARN ABOUT SUSE
ooconvert
ooconvert(1) User Commands ooconvert(1)
Name
ooconvert - Commandline Document Converter Using OpenOffice.org
SYNOPSIS
ooconvert [--help] [--force] input output
DESCRIPTION
This tool converts documents between various formats on the commandline. It uses OpenOffice.org that guarantees the quality of available
import and export filters.
This tool tries to start OpenOffice.org in the server mode on backgroud. It does not work if the OpenOffice.org application has already
been running. Also it slows down the conversion a lot. We hope to reduce these limitations in the further versions.
OPTIONS
input Input file. The filename suffix must be one of the currently supported file formats, see below.
output Output file. The filename suffix defines the output file format. It must be one from the table below. An existing file can be over-
written by the --force option.
--help Print help and exit.
--force
Force an already existing output file to be replaced.
SUPPORTED FILE FORMATS
The current version of this tool does not read the list of available input and output filters directly from OpenOffice.org. The list of
supported file formats is hardcoded and thus limited to:
doc Microsoft Word 97/2000/XP
docx MS Word 2007 XML
dot Microsoft Word 97/2000/XP Template
dotx MS Word 2007 XML Template
html HyperText Markup Language (Web Page)
odt ODF Text Document
ods ODF Spreadsheet
odp ODF Presentation
ott ODF Text Document Template
ots ODF Spreadsheet Template
otp ODF Presentation Template
pdf Portable Document Format
ppt Microsoft PowerPoint 97/2000/XP
pptx Microsoft PowerPoint 2007 XML
pot Microsoft PowerPoint 97/2000/XP Template
potx Microsoft PowerPoint 2007 XML Template
rtf Rich Text Format
stc OpenOffice.org 1.0 Spreadsheet Template
sti OpenOffice.org 1.0 Presentation Template
stw OpenOffice.org 1.0 Text Document Template
sxc OpenOffice.org 1.0 Spreadsheet
sxi OpenOffice.org 1.0 Presentation
sxw OpenOffice.org 1.0 Text Document
swf Macromedia Flash
txt Plain Text
xls Microsoft Excel 97/2000/XP
xlsx Microsoft Excel 2007 XML
xlt Microsoft Excel 97/2000/XP Template
xltx Microsoft Excel 2007 XML Template
TROUBLESHOOTING PROBLEMS
See http://en.opensuse.org/Bugs:OOo for more details about how to report bugs in OpenOffice.org.
AUTHOR
This manual page was created by Petr Mladek <petr.mladek@novell.com>.
OpenOffice.org Converter 2009-02-09 ooconvert(1)