If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

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.

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.

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