Re: E// E******* Macro (Excel) to Extract Parameters from 3G XML dump file (Bulk CM)
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
Re: E// E******* Macro (Excel) to Extract Parameters from 3G XML dump file (Bulk CM)
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.
Re: E// E******* Macro (Excel) to Extract Parameters from 3G XML dump file (Bulk CM)
As well E/// in attachment parser for printout 2G export.
Re: E// E******* Macro (Excel) to Extract Parameters from 3G XML dump file (Bulk CM)
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
Re: E// E******* Macro (Excel) to Extract Parameters from 3G XML dump file (Bulk CM)
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
Re: E// E******* Macro (Excel) to Extract Parameters from 3G XML dump file (Bulk CM)
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..
1 Attachment(s)
Re: E// E******* Macro (Excel) to Extract Parameters from 3G XML dump file (Bulk CM)
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".
Re: E// E******* Macro (Excel) to Extract Parameters from 3G XML dump file (Bulk CM)
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.
Re: E// E******* Macro (Excel) to Extract Parameters from 3G XML dump file (Bulk CM)
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)
Re: E// E******* Macro (Excel) to Extract Parameters from 3G XML dump file (Bulk CM)
Quote:
Originally Posted by
leopedrini
Same problem I already put the todos on same folder with hunter tool but still same problem occured.