App to create Excel report by importing multiple XML files.

Cancelled Posted Apr 23, 2012 Paid on delivery
Cancelled Paid on delivery

I have an application that audits each computer in a network and creates one XML file for each computer audited and then saves each file in a single location.

I would like a small application to import all the XML files and create an Excel report from them.

Each report has the following information:

<log>

|-<item>

|--<scanner>

|--</scanner>

|--<file>

|--</file>

|-</item>

</log>

There is always a <log> in the file, if items found on the computer are flagged, the <item> tags will appear with further information about what was found.

There will be between 1 and 1000 XML files imported per report.

I want the application to create a report based on all of the information contained in the multiple xml files. With headings such as:

1. Top 10 infected computers.

2. Top 10 threats found. (With number of computers infected for each threat and drill down to show names of computers and further drill down to show all infections on computer when the name is clicked)

3. Total number of computers infected (With a drill down to show each infected computer and what was found on each computer)

4. Total number of computers scanned with drill down to list of total computers and show infection on each computer when name is clicked, same as items 2 and 3)

5. Percentage of computers that are infected.

Any pie charts to augment the report will also be considered a plus.

## Deliverables

See attached sample XML file.

.NET Visual Basic Visual Basic for Apps

Project ID: #2734739

About the project

13 proposals Remote project Active May 3, 2012

13 freelancers are bidding on average $72 for this job

vnb400sl

See private message.

$60.35 USD in 3 days
(46 Reviews)
4.7
chriskerpini

See private message.

$85 USD in 3 days
(8 Reviews)
3.8
Lotusdeveloper

See private message.

$85 USD in 3 days
(18 Reviews)
3.7
DenisSmolentsev

See private message.

$85 USD in 3 days
(9 Reviews)
3.3
ysrahmed

See private message.

$80 USD in 3 days
(7 Reviews)
3.3
dekravw

See private message.

$70.55 USD in 3 days
(5 Reviews)
3.2
yurok1975

See private message.

$49.3 USD in 3 days
(3 Reviews)
0.0
nithyarajeshg

See private message.

$50.15 USD in 3 days
(3 Reviews)
0.0
dpune

See private message.

$85 USD in 3 days
(0 Reviews)
0.0
parama4uvw

See private message.

$50.15 USD in 3 days
(1 Review)
0.0
quickprogexpert

See private message.

$60.35 USD in 3 days
(0 Reviews)
0.0
torajiv

See private message.

$85 USD in 3 days
(0 Reviews)
0.0
vw8138996vw

See private message.

$84.15 USD in 3 days
(0 Reviews)
0.0