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)
Can any one give the idea on this, please.
I have the following XML file and wants to convert into CSV(comma separated value) format.
<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE Waveset PUBLIC 'waveset.dtd' 'waveset.dtd'>
<Waveset>
<Object name='ra8736'>
<Attribute name='ADDRESS'... (2 Replies)
Urgent help to transfer data from .xml to xl sheet where each attribute and value goes into seperate column.Please help me with the command.Please help
Thanks
Uma (9 Replies)
Hi,
I have an xml file and I want to convert it with awk in to a csv file
Test.xml
<Worksheet ss:Name="Map1">
<Table ss:ExpandedColumnCount="2" ss:ExpandedRowCount="2" x:FullColumns="1"
x:FullRows="1" ss:DefaultColumnWidth="60">
<Row>
<Cell><Data... (6 Replies)
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)
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)
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)
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)
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
LEARN ABOUT DEBIAN
amc-mailing
AMC-MAILING(1) Auto Multiple Choice AMC-MAILING(1)NAME
AMC-mailing - mail PDF annotated completed answer sheets to students
SYNOPSIS
auto-multiple-choice mailing [--xmlargs args.xml] --projet project-dir --students-list students-list.csv [--list-encoding encoding]
--email-column col --sender sender-email --subject subject --text email-body [--debug file.log]
[transport arguments...]
DESCRIPTION
The command AMC-mailing.pl sends by email the PDF annotated completed answer sheets to the students. Email addresses are taken from the
students list file.
--projet project-dir
Gives the project directory.
--students-list students-list.csv
sets the students list file name.
--list-encoding encoding
selects an encoding for file students-list.csv (default is utf-8).
--email-column col
sets the name of the column containing the email addresses of the students in the students list file.
--sender sender-email
sets the sender email.
--subject subject
sets the subject of the emails to send.
--text email-body
sets the body text of the emails to send.
--transport transport
sets the transport to use. transport may be sendmail or SMTP.
--debug file.log
gives a file to fill with debugging information.
TRANSPORT ARGUMENTS
Depending on the value used for argument transport, the following arguments can be added:
Transport sendmail
--sendmail-path path
sets the path to the sendmail command (defaults to /usr/sbin/sendmail).
Transport SMTP
--smtp-host host
sets the SMTP hostname (defaults to smtp).
--smtp-port port
sets the port to use (default value is 25).
ARGUMENTS IN A XML FILE
To avoid encoding problems, one can place some arguments in a XML file and use the --xmlargs file.xml argument as the first command
argument. Here is an exemple of such a file:
<?xml version="1.0" encoding="UTF-8"?>
<arguments>
<arg>--sender</arg><arg>Bienvenue <paamc@passoire.fr></arg>
<arg>--text</arg><arg>Voila votre copie corrigee</arg>
<arg>--subject</arg><arg>QCM</arg>
</arguments>
AUTHORS
Alexis Bienvenue <paamc@passoire.fr>
Main author
Jean Berard
Translation from French
Georges Khaznadar
Translation from French
COPYRIGHT
Copyright (C) 2008-2012 Alexis Bienvenue
This document can be used according to the terms of the GNU General Public License, version 2 or later.
Auto Multiple Choice 1.1.1 06/19/2012 AMC-MAILING(1)