#!/usr/bin/perl -w use strict; use warnings; use XML::XPath; use MIME::Lite::TT; use File::Copy; use File::Find; use File::Grep qw( fgrep fmap fdo ); my $file = '/home/jramirez/20120811_XML_Reader_837/test.xml'; my $xp = XML::XPath->new(filename => $file); my $icncount = 1; my $transactioncount = 0; my $billedamount = 0; my $PayerName3 = ''; my $ICN = ''; my $BillingProvider = ''; my $line = ''; my $cmd = ''; my $Name = ''; my $xmlpath = ''; my $xmlname = ''; print $file . "\n"; print $xp . "\n"; foreach my $InterchangeControlHeader ($xp->find('//InterchangeControlHeader')->get_nodelist){ my $InterchangeControlNumber13 = $InterchangeControlHeader->find('@InterchangeControlNumber13')->string_value; $ICN = $InterchangeControlNumber13 } foreach my $Transaction837P ($xp->find('//Transaction837P')->get_nodelist){ my $BillingProviderIdentifier9 = $Transaction837P->find('BillingProviderHierarchicalLevelLoop/BillingProviderNameLoop/BillingProviderName/@BillingProviderIdentifier9')->string_value; $BillingProvider = $BillingProviderIdentifier9; $PayerName3 = $Transaction837P->find('SubscriberHierarchicalLevelLoop/PayerNameLoop/PayerName/@PayerName3')->string_value; $transactioncount++; } foreach my $ServiceLineNumberLoop ($xp->find('//ServiceLineNumberLoop')->get_nodelist){ my $AssignedNumberLine = $ServiceLineNumberLoop->find('ServiceLineNumber/@AssignedNumber1')->string_value; my $LineItemChargeAmount2 = $ServiceLineNumberLoop->find('ProfessionalService/@LineItemChargeAmount2')->string_value; if ($LineItemChargeAmount2 eq '') { $LineItemChargeAmount2 = 0; } $billedamount += $LineItemChargeAmount2; } print 'Billing Provider: ' . $BillingProvider . "\n"; print 'ICN: ' . $ICN . "\n"; print 'Payer: ' . $PayerName3 . "\n"; print 'Total Number Invoices: ' . $transactioncount . "\n"; print 'Total Billed: ' . $billedamount . "\n"; my $SESXML = `find /home/jramirez/PayerDownload/SES/backup/*xml -maxdepth 1 -type f -exec grep -q $ICN '{}' ';' -exec echo '{}' ';' `; chomp $SESXML; my $sesxp = XML::XPath->new(filename => $SESXML); foreach my $interchange ($sesxp->find('//Interchange')->get_nodelist){ $Name = $interchange->find('Accept/@Name')->string_value; print $Name . "\n"; print "I think we got 'em, but we dont!" . "\n"; }