bodastage/bts-ce-lite

BTS-CE-Lite (Boda-Lite) is a cross platform vendor and technology agnostic telecommunication network management desktop application

Boda-Lite

Boda-Lite is a minimal feature version of bts-ce. It is a cross platform telecommunication management desktop app.

Features

• Parsing and loading telecommunication configuration management(CM) dumps for various vendors(Ericsson, Huawei, Nokia, ZTE)
• Parsing and loading telecommunication performance management(PM) network dumps
• Reports module that supports tabular, graphs, and composite(dashboard-like) reports
• Advanced GIS module
• Network baseline audit
• Utilities: CSV to Excel, KML Generator

Built with

• Electron
• ReactJs
• SQLite3

Screenshots

Running dev mode

export SKIP_PREFLIGHT_CHECK=true
yarn run start 

#
yarn run electron-dev-unix

Getting help

To report issues with the application or request new features use the issue tracker. For help and customizations send an email to [email protected].

License

Apache 2.0

bts-ce-lite's Issues

Getting Dump successfully parsed, if there is no input

When there is no selected type of CM file available in input folder, it gives "Dump successfully parsed. Find csv files in"

Version database changes with migrations

As of version 0.2.3, the database is setup through an sql script this will get complex as the app evolves. Additionally, new version setup deletes and creates the database which means all the data is lost. With versioned migrations, this will not be the case.

Add Mac OSX application icon

Delete .travis-ci.yml

Clean up/remove wrong travis-ci config file called .travis-ci.yml

Fix eslint warnings

There are number of ...assigned a value but never used no-unused-vars errors

Parsing txt files causes tool to hang at uncompressing stage

Reproducing: Place a .txt file in the input folder to be parsed and click process button in the Process CM Dumps module.

Determining the file mime type is done by using the file-type nodejs package. It is unable to determine the mime type of a text file as there is no meta data to work with; see issue sindresorhus/file-type#55

Solution for this should be to skip files with undefined mime types for now.

Preserve column positions/ordering when exporting tabular data

Boda-Lite Version: 0.2.3
Operating System: Windows, Linux, MacOSX

When exporting tabular report data after reordering the columns, the exported file does not preserve the new column order.

Mac OSX system PATH lost in production in v0.2.1 and causing psql not to be found

• Operating System: Mac OSX
• Boda-Lite Version: 0.2.0

In development PATH is fine. When running the installed production version, the PATH is unavailable.

Related issue:
electron/electron#5626

Solution is to run fix-path from https://github.com/sindresorhus/fix-path

Add option to select the number of rows shown for tabular data

Create combined cell parameter report for all vendors

Report Download in Excel format Fails

Version: 0.3.0-beta.1
OS: Windows 10

Move windows build to appveyor

Boda-Lite Version: 0.2.2

Build windows releases from appveyor because of native dependencies

Process CM Dumps been running for almost 9 hours (..parsing Huawei NBIExport_XML files)

Boda-Lite Version: 0.2.3

Process CM dump has been running for almost 9 hours trying to parse Huawei NBIExport_XML files

log.log

Bug in migrations

The combined 2G parameter report has a wrong parameter name assigned; the parameter name begins with a number!

bts-ce-lite/db/migrations/1564271714995_create-key-parameter-and-network-entity-reports.js

Line 1 in 63bb888

const 2G_KEY_PARAMAETERS = `

Login shows loading icon with form fields disabled on linux

Operation System: Ubuntu/Linux
Boda Lite Version: 0.2.2

On Linux, the app is installed under /opt/Boda-Lite. This folder is owned by root with permissions value 760. When the app is launched, it is supposed to create an sqlite database with the log in credentials. This is not happening because the account it is launched from does not have permissions to read or write to the resources folder. The result is the login page just should a loading icons that never ends!

Create new SVG logo

Property 'id' has no initializer and is not definitely assigned in the constructor. TS2564

TypeScript error in .../src/entities/User.ts(7,5):
Property 'id' has no initializer and is not definitely assigned in the constructor. TS2564

Add edit option to composite reports

As of version 0.2.0, there is no way to edit a composite/dashboard stype report. The user would have to delete and create a new report.

installed successfully but not able to run

The application has got successfully installed, but when i open the application, its stuck with blank page and i can find some javascript errors,

ELECTRON_ASAR.js:160 Uncaught Error: \?\C:\Users\Swaro\AppData\Local\Temp\1fbec1b8-ffa8-4f52-a109-238d6878d98f.tmp.node is not a valid Win32 application.
\?\C:\Users\Swaro\AppData\Local\Temp\1fbec1b8-ffa8-4f52-a109-238d6878d98f.tmp.node
at process.module.(anonymous function) [as dlopen] (ELECTRON_ASAR.js:160:31)
at Object.Module._extensions..node (internal/modules/cjs/loader.js:722)
at Object.module.(anonymous function) [as .node] (ELECTRON_ASAR.js:169:18)
at Module.load (internal/modules/cjs/loader.js:602)
at tryModuleLoad (internal/modules/cjs/loader.js:541)
at Function.Module._load (internal/modules/cjs/loader.js:533)
at Module.require (internal/modules/cjs/loader.js:640)
at require (internal/modules/cjs/helpers.js:20)
at Object. (C:\Users\Swaro\AppData\Local\Programs\Boda-Lite\resources\app.asar\node_modules\sqlite3\lib\sqlite3.js:4)
at Object. (C:\Users\Swaro\AppData\Local\Programs\Boda-Lite\resources\app.asar\node_modules\sqlite3\lib\sqlite3.js:209)

Add Reports to get Relations and Missing Neighbour

typeorm throws error: (DriverPackageNotInstalledError): SQLite package has not been found installed

System
Windows 10
[email protected]
[email protected]
[email protected]

Typeorm throws error above when using sqlite3.

Similar to:
typeorm/typeorm#2456

Add portable/unpacked version to build/release artifacts

I will cater to those with very strict corporate policies and can't install software on their laptops.

Add numeric value filters i.e. less/greater than, less/greater than or equals, in range

Add numeric value filtering for :

• less than
• less than or greater than
• greater than
• greater than or equal
• in range or between

Reference: https://www.ag-grid.com/javascript-grid-filter-component/

Add managed object browser

Add module to browser all managed objects in the db

Show loading progress while the tabular data has not yet loaded

Cannot compile namespaces when the '--isolatedModules' flag is provided. TS1208

System
Windows 10 Home
[email protected]
[email protected]
[email protected]

Running : yarn run dev throws error below:

Set "allowJs": false, in tsconfig.json so that th typescript compiler does not mess with the js and jsx files

Related to:
facebook/create-react-app#5587

Input and output folder should not be the same

Wrong count of csv files left to be loaded in log file

Operating System: Windows, Linux. Mac OSX
Boda-Lite Version: v0.2.2

During loading, the number of csv files that have not loaded is wrong. This happens when the csv file name has no corresponding table and the error below is added to the log

...
...[error] Pool_Connect_Query: error: relation "huawei_cm.BRD_MOD" does not exist
...[info] Skipping loading of BRD_MOD
...

Add error boundaries to gracefully hand UI issues

UI bugs crash the app and render it unusable. Error boundary components to handles this cases.

Running fresh migrations has no effect

Version: 0.3.1
OS: Windows, Mac, Linux

After version 0.3.1 the option to upgrade the database or run a fresh setup was introduced. However, it seems the refresh setup option has no effect. The log file shows message: No migrations to run!

Add scheduler to run scheduled tasks

Example of schedule tasks:

• fetching dumps and processing them
• network audits
• predictions
• etc...

Error: spawnSync mongoimport ENOENT

MongoDB import fails, "error","message":"Error: spawnSync mongoimport ENOENT"

Load file asynchronously to speed up loading

Load a given number of files in parallel at a time to speed up the loading.

Add PR and issue submission templates

Purge react-persist store when new version is started

OS: All
Boda-Lite Version: 0.2.0

Issue:
When a new release is installed after uninstalling the old one, the redux state persists because of react-persist. There should be a way to detect that a new version is being installed add the store purged during a possible migration operation.

uws\src\networking.h(7): fatal error C1083: Cannot open include file: 'openssl/opensslv.h': No such file

c:\users\emmanuel\documents\bodastage\code_repos\pr\bts-ce-lite\node_modules\xrs\node_modules\uws\src\networking.h(7): fatal error C1083: Cannot open include file: 'openssl/opensslv.h': No such file or directory (compiling source file ..\src\addon.cpp) [C:\Users\Emmanuel\Documents\Bodastage\code_repos\pr\bts-ce-lite\node_modules\xrs\node_modules\uws\build\uws.vcxproj]
gyp ERR! build error
gyp ERR! stack Error: C:\Program Files (x86)\Microsoft Visual Studio\2017\BuildTools\MSBuild\15.0\Bin\MSBuild.exe failed with exit code: 1
gyp ERR! stack at ChildProcess.onExit (C:\Users\Emmanuel\Documents\Bodastage\code_repos\pr\bts-ce-lite\node_modules\node-gyp\lib\build.js:262:23)
gyp ERR! stack at ChildProcess.emit (events.js:189:13)
gyp ERR! stack at Process.ChildProcess._handle.onexit (internal/child_process.js:248:12)
gyp ERR! System Windows_NT 10.0.17763
gyp ERR! command "C:\Program Files\nodejs\node.exe" "C:\Users\Emmanuel\Documents\Bodastage\code_repos\pr\bts-ce-lite\node_modules\node-gyp\bin\node-gyp.js" "rebuild" "--target=4.2.0" "--arch=x64" "--dist-url=https://atom.io/download/electron" "--build-from-source"
gyp ERR! cwd C:\Users\Emmanuel\Documents\Bodastage\code_repos\pr\bts-ce-lite\node_modules\xrs\node_modules\uws
gyp ERR! node -v v10.15.3
gyp ERR! node-gyp -v v3.8.0
gyp ERR! not ok

CM MOs mapped to the same name are not all loaded when truncation is switched on

Boda-Lite: 0.2.3, 0.0.3-alpha.1, 0.0.3-alpha.2
Operating System: All

When the "Clear tables before loading" option is on, MOs that are mapped to the same table are not all loaded. An example is the ZTE Plan Templates, GGsmRelation and UGsmRelation are loaded into zte_cm.GsmRelation. When loading with the "Clear table before loading" option turned on, only the data of the last file to be loaded will be seen.

Add Huawei 5G MO tables

ACL6
ACLRULE6
ALMCORRSHLD
ALMCURCFG
ALMFILTER
ALMSHLDRULE
AUTHDLFREQRANGE
BACKTUNNEL
BATCTPA
BATTERY
BBPLINK
BDU
BFD
BITS
BLKSCTPPEERIPV4
BLKSCTPPEERIPV6
CARRIERRESOURCE
CCU
CFLTINFO
CFMBNDIP
CFMLOCALMEP
CFMMA
CFMMD
CFMMEP
CFMRMEP
CHK
CPRIPORT
CROSSCERT
CTRLLNK
DFU
DFUMLCLIENT
DHCPSW
DIESELGEN
DIRECTIPSECBLKLST
DIRECTIPSECWHITELIST
DNSSRV
DOT1X
DOT1XAUTH
DSCP2PCPMAP
DSCP2QUEMAP
EMU
ENERGYCON
EP2IPRSCGRP
ETH3AH
ETHDM
ETHLM
ETHOAM3AH
ETHTRUNK
ETHTRUNKLNK
EXTCONNPORT
EXTRRURES
FILEFOOTER
FLTMASKCFG
FMU
FTPCLT
FTPCLTPORT6
GNB5QICONFIG
GNBABNMSG
GNBABNMSGMATCHRULE
GNBABNMSGMODIFYRULE
GNBAMFDOMAINNAME
GNBCAFREQUENCY
GNBCHRCTRL
GNBCIPHERCAPB
GNBCONNSTATETIMER
GNBCUNG
GNBCUNGINTERFACE
GNBCUS1
GNBCUS1OP
GNBCUX2
GNBCUX2INTERFACE
GNBCUXN
GNBCUXNINTERFACE
GNBDRXPARAMGROUP
GNBDUDRXPARAMGROUP
GNBDULTENRSPCTSHRCG
GNBDUMACPARAMGROUP
GNBDUNARFCNCELLGROUP
GNBDUNARFCNCGCELL
GNBDURSVDPARAM
GNBEUTRAEXTCELLPLMN
GNBEUTRAEXTERNALCELL
GNBFLOWCTRLPARAMGRP
GNBINFOSAMPLECONFIG
GNBINTEGRITYCAPB
GNBMEASCOMMPARAMGRP
GNBNGSONCONFIG
GNBOPERATOR
GNBPDCPPARAMGROUP
GNBQCIBEARER
GNBRLCPARAMGROUP
GNBRSVD
GNBRSVDCFG
GNBRSVDCFGGROUP
GNBSHARINGMODE
GNBTRACKINGAREA
GNBX2SONCONFIG
GNBXNBLACKWHITELIST
GNBXNSONCONFIG
GNODEBFUNCTION
GNODEBPARAM
HAGRP
HTCDPA
IFIP
INTERCLK
INTERFACE
INTERFACEPARA6
IP2IPRSCGRP
IPADDR4
IPADDR6
IPROUTE4
IPROUTE6
IPRSCGRP
IPRSCGRPALG
IPSECBINDITF
IPSECDTNL
LINECLK
LLDP
LLDPGLOBAL
LLDPLOCAL
LOCALETHPORT
LOCALIP
LOCALIP6
LOOPBACK
MAINSALARMBIND
MANRESALMRPT
MDU
MEB
MOCRSVDPARA
MPT
NEMNT
NRCELL
NRCELLALGOSWITCH
NRCELLANR
NRCELLCAMGMTCONFIG
NRCELLEUTRANNFREQ
NRCELLEUTRANRELATION
NRCELLMOBILITYCONFIG
NRCELLNSADCCONFIG
NRCELLOP
NRCELLQCIBEARER
NRCELLRELATION
NRCELLRESELCONFIG
NRCELLRSVD
NRCELLRSVDCFG
NRCELLSUL
NRDUCELL
NRDUCELLALGOSWITCH
NRDUCELLCARRMGMT
NRDUCELLCHNPWR
NRDUCELLCORESET
NRDUCELLCOVERAGE
NRDUCELLCSIRS
NRDUCELLOP
NRDUCELLPAGINGCONFIG
NRDUCELLPDCCH
NRDUCELLPDSCH
NRDUCELLPRACH
NRDUCELLPUCCH
NRDUCELLPUSCH
NRDUCELLQCIBEARER
NRDUCELLRSVD
NRDUCELLRSVDCFG
NRDUCELLRSVDPARAM
NRDUCELLSELCONFIG
NRDUCELLSMARTPWRLOCK
NRDUCELLSPCTCLOUD
NRDUCELLSRSMEAS
NRDUCELLSUL
NRDUCELLTRP
NRDUCELLTRPBEAM
NRDUCELLTRPCUSTBEAM
NRDUCELLTRPIFINFO
NRDUCELLUEPWRSAVING
NRDUCELLUETIMERCONST
NRDUCELLULPCCONFIG
NRDUCELLULTACONFIG
NREXTERNALNCELL
NREXTERNALNCELLPLMN
NRINTERRATHOPARAM
NTPCP
OP
OUTPORT
PACKETFILTER
PACKETFILTERING
PEERCLK
PEU
PHYPORT
PINGFILTER
PINGFILTER6
PMU
PORTLR
PORTPOLICY
PRI2QUE
PSU
RAE
RAEDEVICEDATA
RAESUBUNIT
RAS
RASDEVICEDATA
RASSUBUNIT
RCSSERVER
RETPORT
RFAEQM
RFC
RFCPORT
RFU
RHUB
RHUBRESQUOTA
RRU
RRUCHAIN
RVD
RVDDEVICEDATA
RVDSUBUNIT
RXBRANCH
SCTPTEMPLATE
SECURITYPEER
SFP
SRCIPROUTE4
SUBIF
SUBNETVLAN
SYNCETH
SYSTEMOM
TCU
TIMETHRD
TMA
TMADEVICEDATA
TMASUBUNIT
TOD
TRANSPORT
TRP
TUNNELITF
TXBRANCH
UCIU
UEIU
USB
USCU

Refactor and use typescript throughout

Add log file so that user can share it when app crashes

Add sheet index when combining csv to excel

Add map reports

Error while building native node modules(sqlite3, pg, and uws).

OS: Windows 10
Node version: v10.15.3
yarn version: 1.15.2
npm version: 6.4.1

Issue is related to windows-build-tools installation. Below is an extract from the error logs.

...
error MSB8020: The build tools for v140 (Platform Toolset = 'v140') cannot be foun
...

NPM Install, Unable to verify first certificate

Add documentation and link it to read the docs

Huawei 2G/3G/4G NBIExport_XML arsing & loading successful but all H// tables empty

Boda-Lite Version: 0.2.3
Operating System: Windows

Successfully completed the parsing and loading of Huawei NBIExport files but no data in all Huawei tables.

log.log

Packaging fails due to wrong Python version

Systems:
Windows 10 Home
[email protected]
[email protected]

gyp ERR! configure error
gyp ERR! stack Error: Command failed: C:\Users\USERNAME\AppData\Local\Programs\Python\Python35\python.EXE -c import sys; print "%s.%s.%s" % sys.version_info[:3];
gyp ERR! stack   File "<string>", line 1
gyp ERR! stack     import sys; print "%s.%s.%s" % sys.version_info[:3];
gyp ERR! stack                                ^
gyp ERR! stack SyntaxError: invalid syntax

Similar issue:
electron/forge#585

[error] copyFromStream.errorEvent: Error: Connection terminated. [MONAME.csv]

Operating System: Windows, Linux. Mac OSX
Boda-Lite Version: v0.2.2

Above line shows up at the end of the loading process in the logs. It does not seem to affect the loading.

Timer reset

Clicking the x icon on right hand of "Parsing files" under Process CM Dumps whilst execution resets the timer.

Boda-Lite Version: 0.2.2
Operating System: Windows

Sorting is not captured when exporting a tabular report

Boda-Lite Version: 0.2.3
Operation System: All

The exported csv or excel workbook is not sorted even when some column is sorted.