Siemens BR9.0 Macro

[justdream]

Experts,

Do you have macro to Extract database (in Excel sheet) from Siemens BR9.0 ASCII files

and vice vers

If you have also for BR8.0....it will be good to sharing while BR9.0 is my main concern at the main time
-----------
Another point: how come you could find two different sites with the same cell ID in your database exported from the live network (they are belong to the same BSC) !!!!!!!!!

[justdream]

http://www.finetopix.com/showthread....ighlight=macro

[gprastomo]

Hi,

I think its easy to make the asci to excel sheet..
The cell with the same cell id should have different LAC, its operator rule to have specific CI or specific LAC-CI (CI could be same)...

br

Experts,

Do you have macro to Extract database (in Excel sheet) from Siemens BR9.0 ASCII files

and vice vers

If you have also for BR8.0....it will be good to sharing while BR9.0 is my main concern at the main time
-----------
Another point: how come you could find two different sites with the same cell ID in your database exported from the live network (they are belong to the same BSC) !!!!!!!!!

[justdream]

thank s Giprastomo:::but why we have cells with the same Cell ID......for example Optimi and other tools refused my BSC database dur to duplicate Cell ID; it is very strange and unlogic to build two cells in the same BSC using the same Cell ID

[venom]

thank s Giprastomo:::but why we have cells with the same Cell ID......for example Optimi and other tools refused my BSC database dur to duplicate Cell ID; it is very strange and unlogic to build two cells in the same BSC using the same Cell ID

This is due to rehomings,
whenever the cells r rehomed to other BSCs in SIEMENS, their duplicates are created first. Once the cells are rehomed their previous identities are deleted !!

The other reason could be the dummy cell ids, if ur network has dummy cell ids created then u shuld delete it.

In Optimi, if it doesnt accept it then, open ur ascii file in notepad, Obviously optimi will tell you which MEL is having duplicate cellid. Search for the id and change it. You dont have to worry because your cellid information will be imported from other duplicate.

For EBSCs (BR9), i recommend u to use optimi 5.3
Have fun !

[justdream]

thanks a lot experts
now, do you know how to convert the excel to ASCII

[venom]

thanks a lot experts
now, do you know how to convert the excel to ASCII

excel to ascii? why?

the ****s are already in ascii form, in order to understand them, we always convert them in excel form.

Optimi can take the ascii form !! so just ask your BSC owners or the people who are looking the database to provide you the raw ****s !!

[justdream]

I understand but I speak about another issue,
when you create new Database for your BSC you have to convert it to ASCII then send to your radio commander to apply in live network....we have one consultant in another country who is doing that for us I think with special tool
so I just want to know how to do that

[justdream]

Friends,

I noticed that convert all BSC *.asc files simultaneously is not good (sometimes hang…sometimes give empty excels) so it’s better to convert *.asc files one by one,
consequently how to combine data from different excels with multiple sheets!!!!!!

[kenshinz]

try this to combine different excel data

Friends,

I noticed that convert all BSC *.asc files simultaneously is not good (sometimes hang…sometimes give empty excels) so it’s better to convert *.asc files one by one,
consequently how to combine data from different excels with multiple sheets!!!!!!