I want to put them in the database field by field like catagory, operation target....status; in this way. AND will make a sql query from it. COULD YOU PLEASE HELP ME ON THIS?
you can use perl :xml parser to parse this file
Sample perl code.
#!/usr/bin/perl
use XML::Simple;
use Data::Dumper;
my $config = XMLin('new.xml');
print Dumper($config);
i/p:
<?xml version='1.0' encoding='ISO-8859-1' standalone='no'?>
<LogItems>
<log logid="83efeae5190809080000080410">
<category>Upstream.TEL</category>
<operation>MAKE</operation>
<target>mms</target>
<user>purple</user>
<starttime>20080908000008.985701</starttime>
<stoptime>20080908000009.293774</stoptime>
<status>OKAY</status>
</log>
</LogItems>
Output:
$VAR1 = {
'log' => {
'status' => 'OKAY',
'stoptime' => '20080908000009.293774',
'target' => 'mms',
'starttime' => '20080908000008.985701',
'user' => 'purple',
'category' => 'Upstream.TEL',
'operation' => 'MAKE',
'logid' => '83efeae5190809080000080410'
}
};
your perl script will return hashmap some thing like above.You just need to make key as column name and value value for the coulum and insert using perl DBI module
