XML Parser v1.5 for NOKIA

[hugotg83]

Hello,

This is a XML Parser to convert nokia configuration xml to xls, In my case,
I export the BSC configuration from NOKIA OSS to check the parameters of: BTS, HOC, POC, ADCE, etc.

You have to open the file with excel,
-click on "Browse Open Import FIle" and select the xml file.
-Click on "Browse Save Proceesed File" to save the xls result file, and
-Click on "Parse XML FIle to start the process.

This Parser has a problem, never ending process, I always get a Microsoft Visual Basic Error: "Run-time error '9': Subscript out of range". When this happens, I click END and automatically opens a Excel file with the BSC configuration, but incomplete, especially on ADCE, SO if in the first run of this parser yo don't obtain the information that you need, you can try parsing the xml again.


Its not perfect, but helps.



If anyone knows a better method, please let me know.


Download XML Parser v1.5.rar from Sendspace.com - send big files the easy way

[mau2k]

The error that you describe may be caused by office language when its try to erase blank sheets because this tool is created for spanish version.

To solve the problem you have to replace into XML_Plan_Parser function the lines:

' Delete initial blank sheets
For i = 1 To Application.SheetsInNewWorkbook
Sheets("Hoja" & i).Delete
Next

by:

If Application.International(xlCountryCode) = 34 Then
Sheet = "Hoja"
Else
Sheet = "Sheet"
End If

' Delete initial blank sheets
For i = 1 To Application.SheetsInNewWorkbook
Sheets(Sheet & i).Delete
Next


There are some other errors but this tool is a big help!

bye.

[hugotg83]

Try with this other parser that I found on this forum, is 1.4 version.

Download XML CM Plan Manager Parser v1.4).rar from Sendspace.com - send big files the easy way

I used this lower version, and works much better.

[maxim1]

Will this work for 3g elements ?