Sponsored Content
Top Forums Shell Programming and Scripting Extract TAG name and XPATH from XML file via shellscript Post 302689971 by BithunC on Wednesday 22nd of August 2012 10:09:28 AM
Old 08-22-2012
yes raj .. thanx for ur extreme help ....
this is exactly what i need ...
this one is perfect for one xml file ..but in our scenario we have a share folder where almost 10000 xml will be stored every month.
there i can create one param file contains all xml file names with extension.
now my question is ... is it possible to pass that param file into ur above code which will give output as one .txt file contains all element name along with xpath as ur output was.
there might be 200 common elements in all xml files and rest of all are might be new....so we have have to make one superset of all elements and have to put down in one test file along with the xpath.

note : actually we are building sas mapping script to load all xml to oracle db, previously we did manual copy paset work for all xml and it took 10 days to cover almost all elements Smilie
kindly suggest, do we can load all xml element data to oracle db using shell script?

Last edited by BithunC; 08-23-2012 at 04:56 AM..
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Unable to extract a tag from a very long XML message

Hi I have a log file which contain XML message. I want to extract the value between the tag : <businessEventId>13201330</businessEventId> i.e., 13201330. I tried the following commands but as the message is very long, unable to do it. Attached is the log file. Please provide inputs. --... (3 Replies)
Discussion started by: Sapna_Sai
3 Replies

2. Shell Programming and Scripting

how to extract the info in the tag from a xml file

Hi All, Do anyone of you have any idea how to extract each<info> tag to each different file. I have 1000 raw files, which come in every 15 mins.( I am using bash) I have tried my script as below, but it took hours to finish, which is inefficiency. perl -n -e '/^<info>/ and open FH,">file".$n++;... (2 Replies)
Discussion started by: natalie23
2 Replies

3. Shell Programming and Scripting

Bash XML Parsing using Perl XPath

I have a bash script that needs to read input from an XML file, which includes varying numbers of a certain type of child node. I want to be able to iterate through all the child nodes of a given parent. I installed the Perl XML-XPath package from search.cpan.org. Once it's installed, from bash,... (4 Replies)
Discussion started by: jfmorales
4 Replies

4. Shell Programming and Scripting

extract xml tag based on condition

Hi All, I have a large xml file of invoices. The file looks like below: <INVOICES> <INVOICE> <NAME>Customer A</NAME> <INVOICE_NO>1234</INVOICE_NO> </INVOICE> <INVOICE> <NAME>Customer A</NAME> <INVOICE_NO>2345</INVOICE_NO> </INVOICE> <INVOICE> <NAME>Customer A</NAME>... (9 Replies)
Discussion started by: angshuman
9 Replies

5. Shell Programming and Scripting

XML tag replacement from different XML file

We have 2 XML file 1. ORIGINAL.xml file and 2. ATTRIBUTE.xml files, In the ORIGINAL.xml we need some modification as <resourceCode>431048</resourceCode>under <item type="Manufactured"> tag - we need to grab the 431048 value from tag and pass it to database table in unix shell script to find the... (0 Replies)
Discussion started by: balrajg
0 Replies

6. Shell Programming and Scripting

Extract multiple xml tag value into CSV format

Hi All, Need your assistance on another xml tag related issue. I have a xml file as below: <INVOICES> <INVOICE> <BILL> <BILL_NO>1234</BILL_NO> <BILL_DATE>01 JAN 2011</BILL_DATE> </BILL> <NAMEINFO> <NAME>ABC</NAME> </NAMEINFO> </INVOICE> <INVOICE> <BILL> <BILL_NO>5678</BILL_NO>... (12 Replies)
Discussion started by: angshuman
12 Replies

7. Shell Programming and Scripting

How to add the multiple lines of xml tags before a particular xml tag in a file

Hi All, I'm stuck with adding multiple lines(irrespective of line number) to a file before a particular xml tag. Please help me. <A>testing_Location</A> <value>LA</value> <zone>US</zone> <B>Region</B> <value>Russia</value> <zone>Washington</zone> <C>Country</C>... (0 Replies)
Discussion started by: mjavalkar
0 Replies

8. Shell Programming and Scripting

Extract XML tag value from file

Hello, Hope you are doing fine. I have an log file which looks like as follows: Some junk text1 Date: Thu Mar 15 13:38:46 CDT 2012 DATA SENT SUCCESSFULL: Some jun text 2 Date: Thu Mar 15 13:38:46 CDT 2012 DATA SENT SUCCESSFULL: ... (3 Replies)
Discussion started by: srattani
3 Replies

9. Shell Programming and Scripting

Moving XML tag/contents after specific XML tag within same file

Hi Forum. I have an XML file with the following requirement to move the <AdditionalAccountHolders> tag and its content right after the <accountHolderName> tag within the same file but I'm not sure how to accomplish this through a Unix script. Any feedback will be greatly appreciated. ... (19 Replies)
Discussion started by: pchang
19 Replies

10. UNIX for Beginners Questions & Answers

Grepping multiple XML tag results from XML file.

I want to write a one line script that outputs the result of multiple xml tags from a XML file. For example I have a XML file which has below XML tags in the file: <EMAIL>***</EMAIL> <CUSTOMER_ID>****</CUSTOMER_ID> <BRANDID>***</BRANDID> Now I want to grep the values of all these specified... (1 Reply)
Discussion started by: shubh752
1 Replies
PACEMAKER(8)						  System Administration Utilities					      PACEMAKER(8)

NAME
Pacemaker - Part of the Pacemaker cluster resource manager SYNOPSIS
cibadmin command [options] [data] DESCRIPTION
cibadmin - Provides direct access to the cluster configuration. Allows the configuration, or sections of it, to be queried, modified, replaced and deleted. Where necessary, XML data will be obtained using the -X, -x, or -p options OPTIONS
-?, --help This text -$, --version Version information -V, --verbose Increase debug output Commands: -u, --upgrade Upgrade the configuration to the latest syntax -Q, --query Query the contents of the CIB -E, --erase Erase the contents of the whole CIB -B, --bump Increase the CIB's epoch value by 1 -C, --create Create an object in the CIB. Will fail if the object already exists. -M, --modify Find the object somewhere in the CIB's XML tree and update it. Fails if the object does not exist unless -c is specified -P, --patch Supply an update in the form of an xml diff (See also: crm_diff) -R, --replace Recursivly replace an object in the CIB -D, --delete Delete the first object matching the supplied criteria, Eg. <op id="rsc1_op1" name="monitor"/> The tagname and all attributes must match in order for the element to be deleted -d, --delete-all When used with --xpath, remove all matching objects in the configuration instead of just the first one -5, --md5-sum Calculate the on-disk CIB digest -6, --md5-sum-versioned Calculate an on-the-wire versioned CIB digest -S, --sync (Advanced) Force a refresh of the CIB to all nodes -a, --empty Output an empty CIB Additional options: -f, --force -t, --timeout=value Time (in seconds) to wait before declaring the operation failed -s, --sync-call Wait for call to complete before returning -l, --local Command takes effect locally. Should only be used for queries -c, --allow-create (Advanced) Allow the target of a -M operation to be created if they do not exist -n, --no-children (Advanced) When querying an object, do not return include its children in the result Data: -X, --xml-text=value Retrieve XML from the supplied string -x, --xml-file=value Retrieve XML from the named file -p, --xml-pipe Retrieve XML from stdin -A, --xpath=value A valid XPath to use instead of -o -o, --scope=value Limit the scope of the operation to a specific section of the CIB. Valid values are: nodes, resources, constraints, crm_config, rsc_defaults, op_defaults, status -N, --node=value (Advanced) Send command to the specified host EXAMPLES
Query the configuration from the local node: # cibadmin --query --local Query the just the cluster options configuration: # cibadmin --query --scope crm_config Query all 'target-role' settings: # cibadmin --query --xpath "//nvpair[@name='target-role']" Remove all 'is-managed' settings: # cibadmin --delete-all --xpath "//nvpair[@name='is-managed']" Remove the resource named 'old': # cibadmin --delete --xml-text '<primitive id="old"/>' Remove all resources from the configuration: # cibadmin --replace --scope resources --xml-text '<resources/>' Replace the complete configuration with the contents of $HOME/pacemaker.xml: # cibadmin --replace --xml-file $HOME/pacemaker.xml Replace the constraints section of the configuration with the contents of $HOME/constraints.xml: # cibadmin --replace --scope constraints --xml-file $HOME/constraints.xml Increase the configuration version to prevent old configurations from being loaded accidentally: # cibadmin --modify --xml-text '<cib admin_epoch="admin_epoch++"/>' Edit the configuration with your favorite $EDITOR: # cibadmin --query > $HOME/local.xml # $EDITOR $HOME/local.xml # cibadmin --replace --xml-file $HOME/local.xml SEE ALSO: CRM shell, crm(8), crm_shadow(8) AUTHOR
Written by Andrew Beekhof REPORTING BUGS
Report bugs to pacemaker@oss.clusterlabs.org Pacemaker 1.1.7 April 2012 PACEMAKER(8)
All times are GMT -4. The time now is 06:12 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy