OT Re: XML generation from a text file

This reply is of-topic.


Try shell sriptin:
[jarkko@hypsu02 development]$ cat files.txt
C:\kix\Enterprise031114\Enterprise
C:\kix\Enterprise031114\Enterprise\AFC
C:\kix\Enterprise031114\Enterprise\AHAW
         
[jarkko@hypsu02 development]$ cat txt2xml.sh                                  
                                    
#!/bin/sh
. /etc/init.d/functions
echo "<?xml version=\"1.0\" encoding=\"ISO-8859-1\"?>" > files.xml
echo "<?xml-stylesheet type=\"text/xsl\" href=\"multiple_input3.xsl\"?>" >>
files.xml
echo "<someURIs>" >> files.xml
echo ""
for pattern in `cat files.txt` ; do
# be sure that all is in one line
echo -n "<file>" >> files.xml | echo -n $pattern >> files.xml |echo "</file>"
>> files.xml
done
echo ""
echo "</someURIs>" >> files.xml
#EOF

[jarkko@hypsu02 development]$ cat files.xml
<?xml version="1.0" encoding="ISO-8859-1"?>
<?xml-stylesheet type="text/xsl" href="multiple_input3.xsl"?>
<someURIs>
<file>C:\kix\Enterprise031114\Enterprise </file>
<file>C:\kix\Enterprise031114\Enterprise\AFC </file>
<file>C:\kix\Enterprise031114\Enterprise\AHAW </file>
</someURIs>


For what it is worth.
Cheers,
Jarkko






Lainaus SHEIKH Sajjad <Sajjad.SHEIKH@xxxxxxxxxxx>:

<!-- Hi all,
<!-- 
<!-- I have a plain text file as following.
<!-- I want to read the text file line by line and add each line as a value
<!-- of element of an xml document.
<!-- 
<!-- The generated xml document will be as following.
<!-- 
<!-- Any suggestion?
<!-- 
<!-- 
<!-- OUTPUT
<!-- Folder_structure.xml
<!-- --------------------
<!-- <?xml version="1.0" encoding="ISO-8859-1"?>
<!-- <?xml-stylesheet type="text/xsl" href="multiple_input3.xsl"?>
<!-- 
<!-- <someURIs>
<!--   <file>C:\kix\Enterprise031114\Enterprise\file.xml</file>
<!--   <file>C:\kix\Enterprise031114\Enterprise\AFC\file.xml</file>
<!--   <file>C:\kix\Enterprise031114\Enterprise\AHAW\file.xml</file>
<!-- </someURIs>
<!-- 
<!-- INPUT
<!-- Folder_structure.txt
<!-- --------------------
<!-- 
<!-- C:\kix\Enterprise031114\Enterprise
<!-- C:\kix\Enterprise031114\Enterprise\AFC
<!-- C:\kix\Enterprise031114\Enterprise\AHAW
<!-- 
<!--  XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list
<!-- 
<!-- 


***************************************************
* Jarkko Moilanen                                 *
* Project Manager, ITCM (www.itcm.org)            *
* Profound XML technology Expert                  *
* University of Tampere                           *
* Hypermedia Laboratory                           *
***************************************************

 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list