Mobile app version of vmapp.org
Login or Join
Debbie626

: Report generator for Cisco call manager We have an old Cisco call manager at our office and the call manager generates a call history report in .csv files everyday. We need to make the call

@Debbie626

Posted in: #LookingForAScript #WebApplications

We have an old Cisco call manager at our office and the call manager generates a call history report in .csv files everyday. We need to make the call log history report available for managers on web based system.

What tool will help to automatically generate web pages for the .csv files when the call manager creates the .csv file?

10.02% popularity Vote Up Vote Down


Login to follow query

More posts by @Debbie626

2 Comments

Sorted by latest first Latest Oldest Best

 

@Sue5673885

You could open the csv file in Excel and save as .html. If you want it done automatically you can do this with VBA:

Workbooks.Open ("export.csv")
Workbooks("export.csv").SaveAs "export.html", xlHtml

10% popularity Vote Up Vote Down


 

@Pope3001725

A basic PERL, PHP, or Python script would be needed to parse it and display the results for you. If you can't find an existing script for parsing those log files then you would need to write one yourself. Fortunately working with CSV files is easy. If you choose to use PHP they have a lot of built in functions for parsing CSV files.

10% popularity Vote Up Vote Down


Back to top | Use Dark Theme