08-27-2007
Sample Unix script file to convert .xml to .csv
Dear all,
Can you send me a script file the changes .xml to .csv file.
Thanks,
Srinivasa
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. UNIX for Dummies Questions & Answers
I have a .csv file in Unix box i need a UNIX script to convert the.csv files to.xls format.
Its very urgent please help me. (1 Reply)
Discussion started by: moon_friend
1 Replies
3. Shell Programming and Scripting
Hi
I have a excel file in unix machine and have to convert it into a .csv file.I have to do this from a unix script.How do we do this?
Thanks
Abhinav (3 Replies)
Discussion started by: akashtcs
3 Replies
4. 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
5. Shell Programming and Scripting
I have huge xml file in server and i want to convert it to .csv with specific column ...
i have search in blog but i didn't get any usefully command.
Thanks in advance (1 Reply)
Discussion started by: pareshkp
1 Replies
6. Shell Programming and Scripting
Hi Guys,
I am new to Shell scripting and need to convert an XML files to a CSV file.
My actual problem is that XML file loading is taking hours and I have decided to convert the XML structure to row based data in a CSV file.
My XML file: Message846 can repeat within main loop and... (1 Reply)
Discussion started by: qamar.shahbaz
1 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
Hello,
I am working on a part of code where I need a awk or shell script to convert the given XML file to CSV or TXT file.
There are multiple xml files and of different structure, so a single script is required for converting data.
I did find a lot of solutions in the forum but... (16 Replies)
Discussion started by: Rashmitha
16 Replies
9. UNIX for Advanced & Expert Users
we have a CSV which i need to convert to XML using Perl or Unix shell scripting.
I was able to build this XML in oracle database. However, SQL/XML query is running for long time. Hence, I'm considering to write a Perl or shell script to generate this XML file. Basically need to build this XML... (3 Replies)
Discussion started by: laknar
3 Replies
10. Shell Programming and Scripting
Hello, I need to get few values from a XML file and output needs to be written in another file with pipe delimited format. The Header & Footer of the Pipe Delimited file will be constant.
The below is my sample XML file. I need to pull the values in between the XML tags <Operator_info to... (15 Replies)
Discussion started by: karthi1305561
15 Replies
LEARN ABOUT CENTOS
xmltest
xmltest(1) General Commands Manual xmltest(1)
NAME
xmltest - Test script to send CIM-XML (via wbemcat) to CIMOM and compare to known results
SYNOPSIS
xmltest [FILE]
DESCRIPTION
xmltest is a script that is used to send a raw CIM-XML test file to the sfcb CIMOM (using wbemcat) and then compares the returned CIM-XML
results against a previously determined 'OK' result file to check whether the returned results match the expected results. If there does
not yet exist an 'OK' corresponding to the XML file then xmltest will save the returned results as the new OK file for later use. If the
returned CIM-XML results don't match the existing 'OK' file a new 'result' file will be generated containing the erroneous results.
If no FILE is specified xmltest will use all files with a .xml extension in the current directory path.
EXAMPLE
If there is no 'OK' file to compare returned CIM-XML results against xmltest will generate one.
# xmltest test/getclass.Linux_OperatingSystem.xml
Running test test/getclass.Linux_OperatingSystem.xml ... OK
Saving response as test/getclass.Linux_OperatingSystem.OK
If the returned CIM-XML results match the existing 'OK' file xmltest will signal that the test passed.
# xmltest test/getclass.Linux_OperatingSystem.xml
Running test test/getclass.Linux_OperatingSystem.xml ... Passed
If the returned CIM-XML results don't match the existing 'OK' file xmltest will signal that the tes failed and generate a 'result' file
containing the erroneous results.
# xmltest test/getclass.Linux_OperatingSystem.xml
Running test test/getclass.Linux_OperatingSystem.xml ... FAILED
Check test/getclass.Linux_OperatingSystem.result for errors
PREREQUISITES
Requires wbemcat on search path.
AUTHOR
Dr. Gareth S. Bestor <bestor@us.ibm.com>
CONTRIBUTORS
Adrian Schuur <schuur@de.ibm.com>
BUGS
Does not adequately deal with additional http headers/footers caused by chunking responses, which will result in false failures when com-
paring results to existing "x.OK" files.
The SBLIM project maintains a mailing list to which you should direct all questions regarding sfcb, sfcc, wbemcli, or any of the SBLIM
providers. To subscribe to this mailing list visit
http://lists.sourceforge.net/lists/listinfo/sblim-issues
The SBLIM Project Bug tracking page can be found at
http://sourceforge.net/tracker/?group_id=128809&atid=712784
COPYRIGHT
(C) Copyright IBM Corp. 2004, 2005
AVAILABILITY
The Small-Footprint CIM Broker (sfcb) is a part of the SBLIM project. The most recent version is available on the web at
http://sblim.sourceforge.net/
SEE ALSO
wbemcat(1)
xmltest Version 1.3.16 August 2005 xmltest(1)