E// E******* Macro (Excel) to Extract Parameters from 3G XML dump file (Bulk CM)

Hello dears,
Does anybody here knows where can i find a parser to extract parameters from E******* 3G XML dump (Bulk CM), and export it to Excel spreadsheet?

I have excel macros that do the job for:

• Nokia 2G/3G/4G XML
• Huawei 2G/3G CFGMML
• Huawei 3G/4G XML
• E******* 2G Cnaiv2 TXT

Now, i really need the macro to process E******* 3G XML (raw dump file).

I have one, but it's not "optimized", and take hours to process one RNC.

While I am struggling to find a good code (fast), maybe some of you has already developed some kind of similar tool (macro).

If so, please share/contact?

you can use NEPA Tool shared on forum

Quote:

---

Originally Posted by leopedrini

Hello dears,
Does anybody here knows where can i find a parser to extract parameters from E******* 3G XML dump (Bulk CM), and export it to Excel spreadsheet?

I have excel macros that do the job for:

• Nokia 2G/3G/4G XML
• Huawei 2G/3G CFGMML
• Huawei 3G/4G XML
• E******* 2G Cnaiv2 TXT

Now, i really need the macro to process E******* 3G XML (raw dump file).

I have one, but it's not "optimized", and take hours to process one RNC.

While I am struggling to find a good code (fast), maybe some of you has already developed some kind of similar tool (macro).

If so, please share/contact?

---

Use NEPA but need to ask license from person who post in forum.

It is possible to share your macros ?

BR

Quote:

---

Originally Posted by leopedrini

Hello dears,
Does anybody here knows where can i find a parser to extract parameters from E******* 3G XML dump (Bulk CM), and export it to Excel spreadsheet?

I have excel macros that do the job for:

• Nokia 2G/3G/4G XML
• Huawei 2G/3G CFGMML
• Huawei 3G/4G XML
• E******* 2G Cnaiv2 TXT

Now, i really need the macro to process E******* 3G XML (raw dump file).

I have one, but it's not "optimized", and take hours to process one RNC.

While I am struggling to find a good code (fast), maybe some of you has already developed some kind of similar tool (macro).

If so, please share/contact?

---

Hi Leo,


U can use Nexplorer for your purpose .


Cheers

Quote:

---

Originally Posted by gunpowder

you can use NEPA Tool shared on forum

---

Quote:

---

Originally Posted by electron

Hi Leo, U can use Nexplorer for your purpose. Cheers

---

Quote:

---

Originally Posted by RF engineer

Use NEPA but need to ask license from person who post in forum. It is possible to share your macros? BR

---

Thank you all.

For Nepa in the forum, i think it is a good tool (i use it). But i prefer to keep on the 'road' to have Excel/Access macros totally customizable.

There are some 'problems' that nepa doesn't 'fix', for example, when MO has more than 256 fields, be in Huawei CFGMML or E******* 4G XML.
And also some minor bugs that i have found in Nepa Export, for example for Nokia, when comparing XML (that has a number of fields) and the output (with less fields).

But again: nepa is good, and i plan to have something like it.

But i have other plans, including a Baseline macro, that are ready (working), and is based on ALL vendors (2G-3G-4G) tables (MOs).

SO, if i happen to develop the latest macro in the set (parser for E******* XML) in VBA, i'll be able to have great Audits and Baseline already done.

I'll let you know when i find a solution.

(I've tried XMLDom, but now i am going to the 'string parse' because i can manipulate the XML file to get the desired output).

...

About share the tools, yes, i will do it when i finish.
If i do so now, probably a lot of people will be asking me for some kind of support - and i don't have this time, i rather be working on VBA code.

Note that i am not a VBA expert, nor even a good programmer - i just try to find 'workarounds' to get things done. :)

BR,
Leo

Quote:

---

Originally Posted by leopedrini

Hello dears,
Does anybody here knows where can i find a parser to extract parameters from E******* 3G XML dump (Bulk CM), and export it to Excel spreadsheet?

I have excel macros that do the job for:

• Nokia 2G/3G/4G XML
• Huawei 2G/3G CFGMML
• Huawei 3G/4G XML
• E******* 2G Cnaiv2 TXT

Now, i really need the macro to process E******* 3G XML (raw dump file).

I have one, but it's not "optimized", and take hours to process one RNC.

While I am struggling to find a good code (fast), maybe some of you has already developed some kind of similar tool (macro).

If so, please share/contact?

---

Update: When i have all macros working, i will share it ALL, as well as Audits & Baseline macros. :)
So, if anyone wants to help, it will be much appreciated. :)

Dears

You may use E/// TEI or instead of extracting XML, try to command kget instead, much better for large amount of rnc extract data


Regards

br//juan/rf

Quote:

---

Originally Posted by leopedrini

Hello dears,
Does anybody here knows where can i find a parser to extract parameters from E******* 3G XML dump (Bulk CM), and export it to Excel spreadsheet?

I have excel macros that do the job for:

• Nokia 2G/3G/4G XML
• Huawei 2G/3G CFGMML
• Huawei 3G/4G XML
• E******* 2G Cnaiv2 TXT

Now, i really need the macro to process E******* 3G XML (raw dump file).

I have one, but it's not "optimized", and take hours to process one RNC.

While I am struggling to find a good code (fast), maybe some of you has already developed some kind of similar tool (macro).

If so, please share/contact?

---

Hello Juan.

Yes, we can use E/// TEI to process the XML;
Or as you suggest, use kget command instead (that you told is much better for large amount of rnc extract data).

The point here is that we want to have 'independent' parsers, i mean - if you receive an XML file from somebody, you can process it.

For the first option (TEI), it use to be NOT AVAILABLE to most operators; :(
And for kget, although you have less data, by using the XML you have ALL data, and it is much better to do other audits/baseline/etc...

....

Since last week i didn't receive any macro to process E/// XML, so i think this task is really difficulty.

I'll try to find some free time, and create a parser from scratch.

As all my macros uses Access, i am thinking about changing the XML structure in a way that Access can read it*.

* If you read (import) a raw E******* XML into Access database, it shows almost all tables. Only some fields are wrong - the ones that have a second level. But i think i am delving too much here, maybe we can discuss if there is some other people interested in the package.

I'll keep my work, and let you know if (and when) i find a solution.

BR,
Leo

Hi Leo,

Meanwhile Can you share Nokia XML Macros. That would be good use for me. Thanks in advance

Quote:

---

Originally Posted by SHIVAM

Hi Leo,

Meanwhile Can you share Nokia XML Macros. That would be good use for me. Thanks in advance

---

I would like to share it ALL only when i have it ALL. :(

If i do so, probably i'll receive a lot of questions, support, etc... Trust me, even if you say you'll not, when you try to run, and have a small problem, you'll ask me. :) And so will do EVERYONE. :(

So: when i find and/or develop my E******* Macro, i will share it all, as i will have time to answer for that kind of question (that for sure will have, because we have different OS, different Office versions, etc).

Hope you understand.

Hello Experts,

Just an update: i am almost finishing a macro to handle E******* XML, but i am stuck. :(

I am handling the XML like a TXT file, and arranging it properly.

If any of you have some experience developing macros/vba, please contact me, so i can share the (unfinished) code, and maybe you can help to finish it. :)

And again: as soon as i have a working macro that parsers E******* 3G XML, i will SHARE ALL MY MACROS with EVERYONE.
It is because my main goal is to have other macros running on these databases (Access) that are generated by the macros. It includes BASELINE, Parameters Mapping Comparison, Audits (Neighbors, Consistency Check, etc...).

If you anything that can help in this task (get a parser for E******* XML) please let us know. :)

BR,
Leo

Hello leopedrini!

Thank you very much for your job.
I think we're at the beginning of something really nice in our field (Telecommunications).
You'll be responsible to let everybody have access to such tools.

I will do my best to find a macro that is missing for you, because i am eager to use those for Huawei (CFGMML 2G, CFGMML 3G, eNodeB 4G).
I will be forever thankful to you man!!!!

RF Specialist.

As well E/// in attachment parser for printout 2G export.

Hello friends.

Follows NEtwork PArser for ALL available vendors & technologies. :)

http://www.telecomhall.com/hunter-ne...rk-parser.aspx

The macros are available in the form of Trial (free, but with no support neither access to community/support) and PRO.

BR,
Leo

Some minors bugs where fixed. :)

For now, and given received feedback, everything is OK for:
Huawei 2G
Huawei 3G
Huawei 4G

E******* 2G
E******* 3G
E******* 4G

Nokia 2G
Nokia 3G
Nokia 4G

Quote:

---

Originally Posted by leopedrini

Some minors bugs where fixed. :)

For now, and given received feedback, everything is OK for:
Huawei 2G
Huawei 3G
Huawei 4G

E******* 2G
E******* 3G
E******* 4G

Nokia 2G
Nokia 3G
Nokia 4G

---

E******* is not working for now..

Quote:

---

Originally Posted by leopedrini

Hello dears,
Does anybody here knows where can i find a parser to extract parameters from E******* 3G XML dump (Bulk CM), and export it to Excel spreadsheet?

I have excel macros that do the job for:

• Nokia 2G/3G/4G XML
• Huawei 2G/3G CFGMML
• Huawei 3G/4G XML
• E******* 2G Cnaiv2 TXT

Now, i really need the macro to process E******* 3G XML (raw dump file).

I have one, but it's not "optimized", and take hours to process one RNC.

While I am struggling to find a good code (fast), maybe some of you has already developed some kind of similar tool (macro).

If so, please share/contact?

---

Dear

Iam facing issue that when i click the run it open the folder path and when select the file , it is opening the text file as excel sheet then give is error"attached".

Hello RF engineer.

The behavior "open the target folder when running" is expected.

I inserted this just to simplify.

Regarding the error, it should not happen. Note that - even the tool open the folder - you need to wait for it to process. Every CFGMML.txt file will be 'converted' into an CFGMML.mdb (Access Database).

You can insert your detailed error here:
http://www.telecomhall.net/c/downloads

There's a Community developing the tool together, so it's easier to find answers.

Hello striker.

Yes, it is working for E******* 2G, 3G and 4G.

Did you download the 'todos.exe' auxiliary tool?

As you can check in the 'updated' instructions:
http://www.telecomhall.net/t/hunter-...rmat-trial/375

Quote:

---

Important: to be able to process (parse) E******* 3G XML or 4G E******* XML, you need to download an auxiliary (free) program that converts UNIX to DOS.
E******* dump are in UNIX format, so only have LF (Line Feed) and miss (CR) Carriage Return.
Before everything we need to convert it. (* We have it in the roadmap, and future versions of the Hunter Macro will have it inside; for now, we use this free auxiliary tool, ok?)
So, please visit http://www.thefreecountry.com/tofrodos/7 and download Tofrodos (zip format) (about 110 Kb)
For the macro to run, you only need to have the file ‘todos.exe’ in the same directory of the macro (that file can be found inside the zip file downloaded)

---

Quote:

---

Originally Posted by leopedrini

Hello striker.

Yes, it is working for E******* 2G, 3G and 4G.

Did you download the 'todos.exe' auxiliary tool?

As you can check in the 'updated' instructions:
http://www.telecomhall.net/t/hunter-...rmat-trial/375

---

Same problem I already put the todos on same folder with hunter tool but still same problem occured.

Hello striker.

It's very strange. Can you send more details to my email? (contact@telecomhall.com)

As you can chek in the tool Forum, people are using it, and till now they don't have received this error... :(

http://www.telecomhall.net/

Hi leopedrini ,

Thank for your efforts , can you add Parameter compare feature
comparing 2 Bulks for example like NEPA

Quote:

---

Originally Posted by leopedrini

Hello striker.

It's very strange. Can you send more details to my email? (contact@telecomhall.com)

As you can chek in the tool Forum, people are using it, and till now they don't have received this error... :(

http://www.telecomhall.net/

---

Hi,

I used for E/// 3G and it gives error too. For what WCDMA SW version you have tried to parse with this macro?


Cheers

Hello striker.

The macro is no version dependent.

Can you share details of the error?

(The best option is to send me a sample - contact@telecomhall.com or even better: ask for help in the tool forum).

But i'll try to see what problem are you facing...

I think we should develop parameter comparison with baseline.

hi leo,

i get this error when trying to parse huawei 2G mml. How do i solve this?
http://i63.tinypic.com/315o4s2.png

thanks

Too many problems with this tool. I had some problems with Huawei dump.
Brs,

Quote:

---

Originally Posted by dacoder

hi leo,

i get this error when trying to parse huawei 2G mml. How do i solve this?
http://i63.tinypic.com/315o4s2.png

thanks

---

Quote:

---

Originally Posted by lihanbok

Too many problems with this tool. I had some problems with Huawei dump.
Brs,

---

It successfully worked before, with huawei 2G mml. Now its giving me that error. The difference i know of between past and current mml is the file size. Previously it was around 60MB, now its about 90MB.

Hello.

We are developing new tools (currently we're testing it. Soon we will publish it)

This one has some limitation (for large files, it shows this error).

Be aware that all tools are free (Hunter is an Open Source Tool), meaning that you can see and change* the code.

(Do a search on 'Hunter Password' in that forum)

BR,
Leo

Quote:

---

Originally Posted by leopedrini

Hello.

We are developing new tools (currently we're testing it. Soon we will publish it)

This one has some limitation (for large files, it shows this error).

Be aware that all tools are free (Hunter is an Open Source Tool), meaning that you can see and change* the code.

(Do a search on 'Hunter Password' in that forum)

BR,
Leo

---

thanks...looking forward to using the new tools.

Hi,
I can send You the NePa. It's for E******* dump files.

Please find New (Free) Parsers for E******* 2G, 3G and 4G at:
http://www.telecomhall.net/

Anyone has the XSLT Schema (.xsd file) for version 14.04?