Results 1 to 5 of 5

Thread: Extracting data from XML file

  1. #1
    Join Date
    Dec 2009
    Posts
    192

    Extracting data from XML file

    Hello guys !

    I am new for the XML and need to access the data contents from the XML file.Is it possible to extract the data from the file.Is there any tools are available to access the data.If you have some solutions and compatible codes then please share with me.

    Thanks.

  2. #2
    Join Date
    Oct 2005
    Posts
    2,393

    Using XPath to Extract Data From XML.

    You can access the data from XML documents using the concept of XML Path (XPath) .A node is a complete element within an XML document.

    For example, if you have an XML Document and coded with -

    <customers>
    <customer id="1">
    <companyName>Oracle corp</companyName>
    </customer>
    <customer id="2">
    <companyName>Microsoft</companyName>
    </customer>
    </customers>


    A node could be
    <companyName>Oracle corp</companyName>
    or
    Oracle corp
    or
    id="1"

  3. #3
    Join Date
    May 2008
    Posts
    2,389

    Extract Data by Using the XML Source

    if you are working with the windows application development tools then you can extract the data from the XML file using XML resources.In this scenario,you need to follow some steps-

    1- Open the Integration Services project that includes the package you need.
    2- From the Solution Explorer, double-click on the package and browse it.
    3- Move to the Data Flow tab and click there now from the Toolbox, drag the XML source onto the design surface.
    4- Make a Double click on the XML source.
    5- From the XML Source Editor,select data access mode and set the following -
    • XML file location
    • XML file from variable
    • XML data from variable

  4. #4
    Join Date
    Feb 2008
    Posts
    1,852

    Extracting data from XML file

    After selecting the XML file location,XML file from variable,XML data from variable file location and all ,you need to go further for advance changes to continue the steps -

    • Select Use inline schema to locate that the XML document exist within schema information.
    • To locate an external XML Schema definition language (XSD) schema for the XML file -

    • Locate the existing XSD file.
    • Create an XSD from the XML file.


    • Click on the Columns and update the values in the Output Column listed.
    • Now Click OK to save the changes.

  5. #5
    Join Date
    Jan 2008
    Posts
    1,521

    Extracting data from XML file

    One more way to extract the data from XML document.The XML parser can be used to extract and use the data of the XML file.

    The Implementation of the XML file would be as follows-

    Code:
    < GEN_FSM >
    
    < State >
    
    < Name >
    
    POWERED
    
    < /Name >
    
    < Comment >
    
    USB POWERED State
    
    < /Comment >
    
    < /State >
    
    < State >
    
    < Name >
    
    DEFAULT
    
    < /Name >
    
    < Comment >
    
    USB DEFAULT State
    
    < /Comment >
    
    < /State >

Similar Threads

  1. Replies: 6
    Last Post: 26-02-2011, 10:26 AM
  2. Extracting Selected Data from a txt file
    By sidney786 in forum Software Development
    Replies: 3
    Last Post: 20-08-2010, 01:07 AM
  3. Extracting content from a scan file
    By Emiliio in forum Windows Software
    Replies: 5
    Last Post: 03-02-2010, 12:10 PM
  4. how to create automatic self extracting zip file in vbscript
    By vivekmohan in forum Software Development
    Replies: 1
    Last Post: 03-09-2009, 09:10 AM
  5. Extracting Data and Importing to Excel
    By jaykf014 in forum Software Development
    Replies: 3
    Last Post: 08-10-2008, 06:58 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,751,766,640.35220 seconds with 16 queries