MD110 BC8 Info into a database

[sgtwojcik]

I am very new to the Ericsson and am learining it as I go. The previous manager just up and left taking documentation and configurations! I have learned alot through this forum.
We are currently running a MD110 in BC 8 ( VERY old as I am told ) and are in the process of going over to a VoIP device within 18 months.
I need to get the SUDIP info into a database format to better manage the migration (like-for like extensions, groups, etc). So far I have saved the WINFIOL output into a .txt format, but it is too much going line for line as we have around 2000 extensions.
After each extension info I either get >end or a page break (======) before going on to the next extension parse-so standardization is not there.
Any reccomendations on how to get the info into a database format e.g.(Excel), without having to go extension-by-extension and input everything by hand?

Thanks in advance!

 

[whosrdaddy]

you can assemble all information by doing several commmands
with the output of these commands you can assemble something in excel.

save following text into a file and transmit this file from winfiol, it will produce several small files. they represent the complete data inside your MD110

@L CNLIP
CNLIP:LIM=ALL,DEV=YES;
@L IODDP
IODDP;
@L IOIFP
IOIFP;
@L IOIFP2
IOIFP:ATINFO=YES;
@L IOFDP
IOFDP;
@L DCSSP
DCSSP;
@L ALEXP
ALEXP;
@L ALFCP
ALFCP;
@L ALULP
ALULP;
@L ALDIP
ALDIP;
@L SYDAP
SYDAP;
@L SYTDP
SYTDP;
@L ASPAP
ASPAP:PARNUM=ALL;
@L TCMAP
TCMAP:CON=ALL;
@L NADAP
NADAP;
@L SYIDP
SYIDP;
@L NUTRP
NUTRP:ENTRY=ALL;
@L OPCAP
OPCAP:DIR=ALL;
@L OPDDP
OPDDP:DIR=ALL;
@L OPISP
OPISP:DIR=ALL;
@L EXCCP
EXCCP:CAT=ALL;
@L DTCCP
DTCCP:DCAT=ALL;
@L ADCDP
ADCDP:ABB=ALL;
@L ROCAP
ROCAP:ROU=ALL;
@L RODAP
RODAP:ROU=ALL;
@L RODIP
RODIP:DRN=ALL;
@L RODDP
RODDP:DEST=ALL;
@L RORNP
RORNP:ROU=ALL;
@L RONDP
RONDP:ROU=ALL;
@L EXCAP
EXCAP:DIR=ALL;
@L EXDDP
EXDDP:DIR=ALL;
@L KSDDP
KSDDP:DIR=ALL;
@L KSCAP
KSCAP:DIR=ALL;
@L KSMDP
KSMDP:MDN=ALL;
@L KSFKP
KSFKP:DIR=ALL,KTYPE=ALL;
@L ITDAP
ITDAP:DIR=ALL;
@L GHDAP
GHDAP:GRP=ALL,SORT=1;
@L ACGCP
ACGCP:GRP=ALL;
@L ACGMP
ACGMP:GRP=ALL,SORT=1;
@L CSTPP
CSTPP:LIM=ALL;
@L ACPAP
ACPAP:ACDNUM=ALL;
@L MGMGP
MGMGP:MGN=ALL;
@L MGMOP
MGMOP:MONR=ALL;
@L DTDDP
DTDDP:DIR=ALL;
@L DTCAP
DTCAP:DIR=ALL;
@L DTDDP
DTDDP:DIR=ALL;
@L DTCAP
DTCAP:DIR=ALL;
@L DTFUP
DTFUP:DIR=ALL;
@L DGDAP
DGDAP:GRP=ALL;
@L CBDAP
CBDAP:GRP=ALL;
@L SPEXP
SPEXP:DIR=ALL;
@L CDIDP
CDIDP:DIR=ALL;
@L CDCDP
CDCDP;
@L GPDAP
GPDAP:GRP=ALL;
@L GDNDP
GDNDP:GRP=1&&99;
@L ROEDP
ROEDP:ROU=ALL,TRU=ALL;
@L SCEXP
SCEXP;
@L RGDAP
RGDAP;
@L ICFUP
ICFUP;
@L EMFUP
EMFUP;
@L ICMWP
ICMWP:SID=ALL;
@L ISFUP
ISFUP;
@L ISEPP
ISEPP:TERM=ALL;
ISEPP:GRP=ALL;
@L VMFUP
VMFUP;
@L VMPOP
VMPOP;
@L ACFUP
ACFUP;
@L PAEDP
PAEDP:SAR=ALL;
@L PADAP
PADAP:DIR=ALL;
PADAP:EPN=ALL;
PADAP:CPN=ALL;
@L PAALP
PAALP:DIR=ALL;
@L OPCTP
OPCTP:CORG=ALL;
@L OPCGP
OPCGP:DIR=ALL;
@L OPNEP
OPNEP;
@L OPRSP
OPRSP:ROU=ALL;
OPRSP:SDM=ALL;
@L OPDNP
OPDNP;
@L OPCEP
OPCEP:CORG=ALL;
@L CPDNP
CPDNP;
@L CPDLP
CPDLP;
@L RAEQP1
RAEQP:VSID=ALL;
@L RAEQP2
RAEQP:EMDEV=ALL;
@L RAMSP
RAMSP:MSG=ALL;
@L RAGMP_GP
RAGMP:MGP=ALL;
@L RAGMP_DR
RAGMP:DIR=ALL;
@L RADNP
RADNP:VSID=ALL;
@L RODNP
RODNP:ROU=ALL,TRU=ALL;
@L ROECP
ROECP:EQU=ALL;
@L ROCDP
ROCDP:CUST=ALL;
@L ROSCP
ROSCP:LIM=ALL;
@L ROVNP
ROVNP:ROU=ALL;
@L RORIP
RORIP:LIM=ALL;
@L ROELP
ROELP;
@L SEMIP
SEMIP:LIM=ALL;
@L LCDDP
LCDDP:TAB=ENT;
LCDDP:TAB=NLT;
LCDDP:TAB=FDT;
LCDDP:TAB=DNT1;
LCDDP:TAB=DNT2;
@L LCDDP2
LCDDP:TAB=PNR;
LCDDP:TAB=RCT;
@L LCLDP
LCLDP:LIM=ALL;
@L LCOPP
LCOPP:OCPT=ALL;
LCOPP:ROU=ALL;
@L LCTDP
LCTDP;
@L PFCOP
PFCOP:LIM=ALL;
@L NSDAP
NSDAP;
@L EDEQP
EDEQP;
@L EDICP
EDICP:DEV=ALL;
@L EDFIP
EDFIP;
@L CLINP
CLINP;
@L CLFOP
CLFOP;
@L AUCOP
AUCOP:AUTH=ALL;
@L AUCOP2
AUCOP:DIR=ALL;
@L AOCOP
AOCOP:ACO=ALL;
@L ADIDP
ADIDP:DIR=ALL;
@L KSTSP
KSTSP:STRNO=ALL;
KSTSP:GRP=ALL;
@L KSCHP
KSCHP;
@L CHGAP
CHGAP:DIR=ALL;
CHGAP:ROU=ALL;
@L NIINP1
NIINP:DIR=ALL;
@L NIINP2
NIINP:GRP=ALL;
@L NIINP3
NIINP:OPE=ALL;
@L CADAP
CADAP;
@L ALCLP
ALCLP;
@L DUFQP
DUFQP;
@L HIEIP
HIEIP;
@L IOPWP
IOPWP;
@L LSATP
LSATP;
@L LSCNP
LSCNP;
@L ROFCP
ROFCP:BPOS=ALL;
@L TRDIP
TRDIP;
@L TRMSP
TRMSP;
@L TRRSP
TRRSP;
@C

-----------------------------------------------------
What You See Is What You Get
Never underestimate tha powah of tha google!

 

[sgtwojcik]

Thanks Daddy! I will give it a shot.