Sponsored Content
Full Discussion: Parsing XML
Top Forums Shell Programming and Scripting Parsing XML Post 302620817 by $criptKid617 on Monday 9th of April 2012 09:37:06 AM
Old 04-09-2012
Parsing XML

I am trying to parse an xml file and trying to grab certain values and inserting them into database table. I have the following xml that I am parsing:

Code:
<dd:service name="locator" link="false">
<dd:activation mode="manual" />
<dd:run mode="direct_persistent" proxified="false" managed="true" authenticated="false" perflog="false" dynlog="true" />
<dd:endpoint protocol="iiop" port="21120" />
</dd:service>
<dd:service name="node_daemon" link="false">
<dd:activation mode="manual" />
<dd:run mode="direct_persistent" proxified="false" managed="true" authenticated="false" perflog="false" dynlog="true" />
<dd:endpoint protocol="iiop" port="21121" />
</dd:service>
<dd:service name="management" link="false">
<dd:activation mode="manual" />
<dd:run mode="direct_persistent" proxified="false" managed="false" authenticated="false" perflog="false" dynlog="false" />
<dd:endpoint protocol="http" port="21122" />
<dd:endpoint protocol="iiop" port="21123" />
</dd:service>

I need to create a row for each service type. For instance I need to insert into a table for the service stanza:

locator, 21120
node_daemon, 21121
management, 21123

So I would like to grab the service type and iiop port, but I am having some difficulty doing so. I have come up with the following, but it isn't correct. This will only grab the port, but not the iiop port, but including http ports.

Code:
for k in `cat test.xml | grep port | awk -F"\"" '{print $4}'`
do
echo "$server,dev$i,test,$k" >> test.txt
done
fi

 

10 More Discussions You Might Find Interesting

1. Programming

XML parsing

Hi I want to take an XML file and transform it into a pipe-delimited format. What is the best tool to use for this? I have libxml2 which seems to be the best xml parser around. The xml file will have the following format. <Txn> <Date>120504</Date> <id>99</id> <Items> <Item>... (1 Reply)
Discussion started by: handak9
1 Replies

2. Shell Programming and Scripting

parsing xml

I want to use wget comment to parse an xml parse that exist in an online website. How can I connect it using shell script through Unix and how can I parse it?? (1 Reply)
Discussion started by: walnut
1 Replies

3. Shell Programming and Scripting

XML Parsing

Hi, Need a script to parse the following xml file content <tag1 Name="val1"> <abc Name="key"/> <abc Name="pass">*********</abc> </tag1> <tag2 Name="Core"> <Host Name="a.b.c"> <tag1 Name="abc"> <abc Name="ac">None</abc> ... (4 Replies)
Discussion started by: Mavericc
4 Replies

4. Shell Programming and Scripting

XML parsing

I have a xml file attached. I need to parse parameterId and its value My output should be like 151515 38 151522 32769 and so on.. Please help me. Its urgent (6 Replies)
Discussion started by: LavanyaP
6 Replies

5. Shell Programming and Scripting

Parsing XML

Learned People, Hello ! Till today, for the most part, all of the tricky questions/situations that I encountered were already posted by other folks and all I had to do was peruse through these one at a time and I could find some sort of an answer and all I had to do was add some minor tweaks... (5 Replies)
Discussion started by: ManoharMa
5 Replies

6. UNIX for Advanced & Expert Users

XML Parsing

I had a big XML and from which I have to make a layout as below *TOTAL+CB | *CB+FX | CS |*IR | *TOTAL | -------------------------------------------------------------------------------------------------- |CB FX | | | | DMFXNY EMSGFX... (6 Replies)
Discussion started by: manas_ranjan
6 Replies

7. Shell Programming and Scripting

XML: parsing of the Google contacts XML file

I am trying to parse the XML Google contact file using tools like xmllint and I even dived into the XSL Style Sheets using xsltproc but I get nowhere. I can not supply any sample file as it contains private data but you can download your own contacts using this script: #!/bin/sh # imports... (9 Replies)
Discussion started by: ripat
9 Replies

8. Shell Programming and Scripting

XML parsing

i have xml output in below format... <AlertsResponse> <Alert id="11216" name="fgdfg"> <AlertActionLog timestamp="1356521629778" user="admin" detail="Recovery Alert"/> </Alert> <Alert id="11215" name="gdfg <AlertActionLog timestamp="1356430119840" user=""... (12 Replies)
Discussion started by: vivek d r
12 Replies

9. Shell Programming and Scripting

XML Parsing :

HI I want to parse below file in to two output :- Input :- ?xml version="1.0" encoding="UTF-8"?> <bulkCmConfigDataFile xmlns:un="utranNrm.xsd" <configData dnPrefix="Undefined"> <xn:SubNetwork id="ONRM_ROOT_MO_R"> <xn:MeContext id="C136"> ... (3 Replies)
Discussion started by: asavaliya
3 Replies

10. Shell Programming and Scripting

XML parsing

I have an xml file where the format looks like below <SESSIONCOMPONENT REFOBJECTNAME ="pre_session_command" REUSABLE ="NO" TYPE ="Pre-session command"> <TASK DESCRIPTION ="" NAME ="pre_session_command" REUSABLE ="NO" TYPE ="Command" VERSIONNUMBER ="1"> ... (8 Replies)
Discussion started by: r_t_1601
8 Replies
asadmin-list(1AS)						   User Commands						 asadmin-list(1AS)

NAME
asadmin-list, list - lists the configurable elements SYNOPSIS
list --user admin_user [--password admin_password] [--host localhost] [--port 4848] [--secure |-s] [--passwordfile filename] [--terse=false] [--echo=false] [--interactive=true] [--monitor=false] dotted_parent_element_name Lists the configurable element. On Solaris, quotes are needed when executing commands with * as the option value or operand. The dotted notation follows these guidelines: o Any list command that has a dotted name that is not followed by a wildcard (*) will get, as its result, the current node's immediate children. For example, list --monitor server lists all immediate children belonging to the server node. o Any list command that has a dotted name followed by a wildcard(*) will get, as its result, a hierarchical tree of children nodes from the current node. For example, list --monitor server.applications.* will list all children of applications and their subsequent child nodes and so on. o Any list command that has a dotted name preceded or followed by a wildcard (*) of the form *dotted name or dotted * name or dotted name* will get, as its result, all nodes and their children matching the regular expression created by the provided matching pattern. OPTIONS
--user authorized domain application server administrative username. --password password to administer the domain application server. --host machine name where the domain application server is running. --port port number of the domain application server listening for administration requests. --secure if true, uses SSL/TLS to communicate with the domain application server. --passwordfile file containing the domain application server password. --terse indicates that any output data must be very concise, typically avoiding human-friendly sentences and favoring well- formatted data for consumption by a script. Default is false. --echo setting to true will echo the command line statement on the standard output. Default is false. --interactive if set to true (default), only the required password options are prompted. --monitor defaults to false; if set to false, the configurable attribute values are returned. If set to true, the monitorable attribute values are returned. OPERANDS
dotted_parent_element_naconfigurable or monitorable element name. Example 1: Using list to view all dotted-name prefixes asadmin> list --user admin --password adminadmin --port 5001 "*" server server.admin-service server.admin-service.das-config server.application-ref.MEjbApp server.application-ref.__ejb_container_timer_app server.application-ref.adminapp server.application-ref.admingui server.application-ref.com_sun_web_ui server.applications server.applications.j2ee-application.MEjbApp server.applications.j2ee-application.__ejb_container_timer_app server.applications.web-module.adminapp server.applications.web-module.admingui server.applications.web-module.com_sun_web_ui server.ejb-container server.http-service server.http-service.http-listener.admin-listener server.http-service.http-listener.http-listener-1 server.http-service.http-listener.http-listener-2 server.iiop-service server.iiop-service.iiop-listener.SSL server.iiop-service.iiop-listener.SSL.ssl server.iiop-service.iiop-listener.SSL_MUTUALAUTH server.iiop-service.iiop-listener.SSL_MUTUALAUTH.ssl server.iiop-service.iiop-listener.orb-listener-1 server.iiop-service.orb server.java-config server.jms-service server.jms-service.jms-host.default_JMS_host server.log-service server.log-service.module-log-levels server.mdb-container server.monitoring-service server.monitoring-service.module-monitoring-levels server.resource-ref.jdbc/PointBase server.resource-ref.jdbc/__TimerPool server.resources server.resources.jdbc-connection-pool.PointBasePool server.resources.jdbc-connection-pool.__TimerPool server.resources.jdbc-resource.jdbc/PointBase server.resources.jdbc-resource.jdbc/__TimerPool server.security-service server.security-service.audit-module.default server.security-service.auth-realm.certificate server.security-service.auth-realm.file server.security-service.jacc-provider.default server.thread-pools server.thread-pools.thread-pool.thread-pool-1 server.transaction-service server.virtual-server.__asadmin server.virtual-server.server server.web-container Example 2: Using list for an application asadmin> list --user admin --password adminadmin --host localhost --port 4848 server.applications.j2ee-application server.applications.j2ee-application.MEjbApp server.applications.j2ee-application._ejb_container_timer_app server.applications.j2ee-application.stateless-simple Example 3: Using list for a web module asadmin> list --user admin --password adminadmin --host localhost --port 4848 server.applications.web-module server.applications.web-module.adminapp server.applications.web-module.adminguip server.applications.web-module.com_sun_web_ui EXIT STATUS
0 command executed successfully 1 error in executing the command asadmin-get(1AS), asadmin-set(1AS) J2EE 1.4 SDK March 2004 asadmin-list(1AS)
All times are GMT -4. The time now is 10:25 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy