telecomHall.com | Hunter Blog | Tips Blog | Course Blog | Groups

General instructions for using the CM parsers to process any network dump


#1

Here at telecomhall we share with you powerful, fast and easy to run parsers that can process all raw CM dumps* you may have. (*CM - Configuration Management files with configuration parameters of your entire network).

Hunter Boda parsers are written in Java and distributed as “.jar” files.

The easiest way to run a jar file in Windows is to use the command prompt. (Tip: to run the command prompt, look for “cmd.exe”).

The parsers can be used on other platforms that have Java installed besides Windows.

This write-up focuses on Windows as it is the currently supported platform for the Hunter tools.

Important: Make sure you run the command on one line only (NOT on separate lines).

One of the best ways to learn is by example, so let’s see the Boda parsers in action with examples for Ericsson 3G (please note that exactly the same procedure applies to other Technologies (2G/3G/4G) or Vendor (Huawei, Nokia, Ericsson, and ZTE). You’ll see how fast and easy it is to process your dumps.

Suppose you have downloaded 2 files:
MyFile1.xml
MyFile2.xml

First thing to do is create a folder to store these 2 files:
C:\HUNTER\Boda\Ericsson_3G\Data\MyFolderWithMyRawData\

Then create a folder to store the output (where the parsed files will be stored):
C:\HUNTER\Boda\Ericsson_3G\Output\MyOutputFolder\

If you the followed the Hunter recommended folder structure, you will have the Boda parser (.jar file) in the Scripts Folder but you can place it in any other folder you prefer.
C:\HUNTER\Boda\Ericsson_3G\Scripts\boda-bulkcmparser.jar

At this point, your work is almost done! :slight_smile:

Now, you have 2 options (always remember that the command is run on ONE LINE only - NOT on separate lines!). I am emphasizing this because the command appears to be on multiple lines in this example. This is due to the limited sentence width.

How to run the parser to process ONE file.
Let’s say you want to process MyFile1.xml. The command would be:

java -jar C:\HUNTER\Boda\Ericsson_3G\Scripts\boda-bulkcmparser.jar C:\HUNTER\Boda\Ericsson_3G\Data\MyFolderWithMyRawData\MyFile1.xml C:\HUNTER\Boda\Ericsson_3G\Output\MyOutputFolder\

How to run the parser to process ALL files in a folder.
Let’s say you want to process all files (MyFile1.xml, MyFile2.xml…). The command would be:

java -jar C:\HUNTER\Boda\Ericsson_3G\Scripts\boda-bulkcmparser.jar C:\HUNTER\Boda\Ericsson_3G\Data\MyFolderWithMyRawData\ C:\HUNTER\Boda\Ericsson_3G\Output\MyOutputFolder\

That’s it. You will find several csv files (Text files that can be opened with Microsof Excel ).

The generated csv files have extra IDENTIFY fields, with very useful information like ‘Filename’ (for the name of the raw dump file processed) and ‘varDateTime’ (for the date and time the dump was taken).

If you are reading this for the first time, you’ll be surprised with the results. And if you are already a Hunter user - and use the Boda parsers - you probably already know the power those tools give you. Either way, your feedback, and suggestions are valuable to us. This is mainly because we want to expand the solutions to other domains (like PM - Performance Mangement and FM - Faulty Management) and other types of Analysis (Geo Mapping, Charting, etc) and eventually fully a functioning SON solution around this.

Your participation in the forum is certainly the most important part for this roadmap. Besides the tools, we also want to develop and establish best practices and analyses. This we cannot do alone.

So, feel free to post your comments in the forum, add new topics, invite your friends to join and to share whatever may be useful for the community.

BR
Emmanuel


Huawei 4G XML OSS Parameters Dump Parser
Ericsson 4G XML OSS Parameters Dump Parser
Nokia 4G XML OSS Parameters Dump Parser
Nokia 3G XML OSS Parameters Dump Parser
Ericsson 3G XML OSS Parameters Dump Parser
Ericsson 2G CNAIv2 OSS Parameters Dump Parser
Huawei 3G CFGMML OSS Parameters Dump Parser
Nokia 2G XML OSS Parameters Dump Parser
ZTE 2G XML OSS Parameters Dump Parser
ZTE 3G XML OSS Parameters Dump Parser
ZTE 4G XML OSS Parameters Dump Parser
Huawei NBI export parser for GNBI,UNBI, and SRANNBI export XML files
Huawei 4G XML OSS Parameters Dump Parser
#4

Emmanuel and Leo,
Great work!!! and Thanks for sharing these powerful tools.

BR
GM


#5

Hi emannel

Thanks for such initiative , one note for parser output , is their in roadmap also combine all CSV in one Excel with multiple sheet whenever search for parameter will be to find rathar than open CSVs.

BR
Aso


#6

Bonjour,
la command Java fonctionne correctement mais pas d’Output CSV.


#7

@aso,

We did not want to convert the dump files directly into an Excel document because there is more flexibility for the users in what they could do with the parsed output if it is CSV format. Nevertheless, we have put something together that can help combine the CSV files into an Excel workbook.

boda-csvtoexcel.zip (12.2 MB)

Usage instructions:

  1. Download the above zip file
  2. Uncompress the zip file
  3. From the windows cmd terminal, run java -Xms1024m -jar boda-csvtoexcel.jar <folder_containing_the_csv_files> name_of_the_excel_doc
  4. Sit back and wait for the process to complete.

Below are screenshots of how to run the tool and the expected output.

Disclaimer: This is still being tested so it may not work as advertised :slight_smile:

BR,
Emmanuel


#8

Thank you dear for your help .

BR
Aso


#9

Hi @Emmanuel,

I run this command to convert to excel:
java -jar C:\Hunter\Boda\Ericsson_2G\Scripts\boda-csvtoexcel.jar C:\Hunter\Boda\Ericsson_2G\Output\Ericsson\ 2G_Parameters.xlsx

And gave this error:

Can You help me?

BR,
SC


#10

@CSilva,

If you have more than 4G RAM on your laptop, you can increase the Java heap size to 2G (-Xms2048m ).

java -Xms2048m  -jar C:\Hunter\Boda\Ericsson_2G\Scripts\boda-csvtoexcel.jar C:\Hunter\Boda\Ericsson_2G\Output\Ericsson\ 2G_Parameters.xlsx 

.
Let me know if this helps.

Emmanuel


#11

Hi @Emmanuel,

My laptop has 8G RAM. Now I ran the command and gave the following message:

Thanks,
SC


#12

@CSilva, I will test this over the weekend and release a new version. Thanks for the feedback.


#13

Hi Emmanuel, for Ericsson, the newer SRAN OSS uses an xml format for 2G parameters too and doesn’t need the CNAIv2 export. Do you have a view on this and if and when you are planning to develop the same?

thanks


#14

I will look into it.

Emmanuel


#15

@Emmanuel is there any new version for csvtoexcel tool


#16

Thanks for sharing this in here. You are running a great forum, keep up this good work.