Page 2 of 3 FirstFirst 123 LastLast
Showing results 11 to 20 of 30

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

  1. #11
    Member Reputation: 41
    Join Date
    2009-11-05
    Location
    Brazil
    Posts
    50


    1 out of 1 members found this post helpful.

    Default 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

  2. # ADS
    Circuit advertisement
    Join Date
    Always
    Location
    Advertising world
    Posts
    Many
     

  3. #12
    Junior Member Reputation: 10
    Join Date
    2014-09-10
    Posts
    2


    Default 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.

  4. #13
    Junior Member Reputation: 10
    Join Date
    2016-06-27
    Posts
    1


    Default 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.

  5. #14
    Member Reputation: 41
    Join Date
    2009-11-05
    Location
    Brazil
    Posts
    50


    Default 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

  6. Thanks electron, gunpowder, dacoder thanked for this post
  7. #15
    Member Reputation: 41
    Join Date
    2009-11-05
    Location
    Brazil
    Posts
    50


    Default 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

  8. #16
    VIP Member Reputation: 1013
    Join Date
    2009-09-07
    Posts
    1,087


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

    Quote Originally Posted by leopedrini View Post
    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..

  9. Thanks electron thanked for this post
  10. #17
    Senior Member Reputation: 478
    Join Date
    2008-11-06
    Posts
    970


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

    Quote Originally Posted by leopedrini View Post
    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".
    Attached Images Attached Images
    RF engineer

  11. #18
    Member Reputation: 41
    Join Date
    2009-11-05
    Location
    Brazil
    Posts
    50


    Default 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.

  12. #19
    Member Reputation: 41
    Join Date
    2009-11-05
    Location
    Brazil
    Posts
    50


    Default 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
    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)

  13. Thanks edinburgh thanked for this post
  14. #20
    VIP Member Reputation: 1013
    Join Date
    2009-09-07
    Posts
    1,087


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

    Quote Originally Posted by leopedrini View Post
    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.
    Last edited by striker; 2016-08-12 at 03:10 PM

Tags for this Thread

Bookmarks

Bookmarks

Posting Rules

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •