Converse MML data to simple form

[visi31]

Also version 4.1-4 has the possibility of ZAHP (alarm history) & alarms for BTS, BSC, RNC etc. to output in excel but it would be more interesting to find a way for other commands that are mentioned in Excel file like: ZEAO, ZEEI, ZUSI, ZEQO, ZESI etc...or to show us how to correct the error appeared on excel file...thanks

[adam07]

to know the BSC adress use the command : ZQRI;

[seair]

rename the excel file "FILTER DATA TOOL V2.xls"

Hello,

Useful tool in theory but when i run it i get this error:


Any Idea????

[adam07]

after rename the file to "FILTER DATA TOOL V2.xls" its work but : it work only for ZAHP , ZEOl and EZOH commands the other commands thas'nt work
plz if anybody have the new version plz shared

[giocatsamac]

Hi EveryBody!
It's new version of Filter Data Tool V2.0!
I Wrote it in a Project in Cambodia!
Enjoy It!

[seair]

first ,thank you!
my friend's MACRO like this:
I don't need to choose the MML COMMAND everytime
but your macro can read single MML in a large log file
both 2 macro are useful~
I hope you can add this button~

Do Until File.AtEndOfStream
Line = File.ReadLine
ElseIf InStr(1, Line, "< ZEEI:SEG") Then
Application.StatusBar = "Reading " & FileLog & " ZEEI SEG MML.........."
Call ZEEI
ElseIf InStr(1, Line, "< ZEQO:SEG") Then
Application.StatusBar = "Reading " & FileLog & " ZEQO SEG MML.........."
Call ZEQO
Loop

————
Private Sub ZEEI()
……
Do Until InStr(1, Line, "COMMAND EXECUTED")
……
Line = File.ReadLineLoop
End Sub

[zaebolll]

Is there any way to connect BSC via excel directly and print logs of commands on excel. I mean instead of tang, to connect BSC with excel.