Logs Manager

Gui app useful to concatenete or execute a key based merge (database like) on your csv/xlsx/xls files

Index

• What is Logs Manager?
• System Dependencies
• Quick Start
• Instructions
• Credits

What is Logs Manager?

Logs Manager is an application developed for a "Networks and distributed systems security" exam at Univeristy Aldo Moro of Taranto Italy.
its goal is to manage log files released from different apps. It can be used to concatenete a large ammount of data logs spreads in different CSV/XLS/XLSX files, in addiction, it can allow merge two log files using a key (column name) at the same way a databases would do.

Functionalities

• Concatenete two or more log files : Useful to unify different files into a single one.
• Key based merge of two log files : Useful to filter records between two log files.

• Requirements and Dependencies

  Python 3.5.3 or higher (tested on 3.7 and 3.8)
  python-dateutil~=2.6.1
  pytz~=2017.2
  six~=1.5
  xlrd~=1.2.0
  jdcal~=1.4.1
  et-xmlfile~=1.0.1
  openpyxl~=3.0.5
  numpy
  pandas~=1.0.3
  PyQt5-sip<13,~=12.8
  PyQt5~=5.15.1
  

  Resources for dependencies required
  Panadas: pandas.pydata.org
  PyQt5: pypi.org/project/PyQt5
  

• Quick Start

  Automatic Setup installer with Python :
  1 - Download and Install "Logs Manager - Setup Online.exe"
  2 - Good work with Logs Manager
  NB: Internet Connection required

• Instructions

  Prerequisites and notes

  • For CSV files, they must have first row with headers separeted by "," and all record attributes must be separeted by ","
  • For XLS/XLSX files, they must have first row with headers
  • All input files must have the same extension but the output file could be chosen as different one: (CSV->XLSX | XLSX->CSV)

  Concatenete Function
  

  1 - Click on "Open" button and select 2 or more log files (CSV/XLS/XLSX) NB: they must have the same extension
  2 - Click on "Save" button and select name and directory of the output file (CSV/XLS/XLSX)
  3 - Click on "CONCAT NOW" to execute concatenation of log files
  

  Merge Function
  

  1 - Click on "Open" button and select 2 log files (CSV/XLS/XLSX) NB: they must have the same extension
  2 - Click on "Save" button and select name and directory of the output file (CSV/XLS/XLSX)
  3 - Select witch type of merge to execute (left,right,outer,inner)
  4 - Select right and left keys to execute merge (Primary Keys)
  5 - Click on "MERGE NOW" to execute concatenation of log files
  

  GUI Output examples
  

  

  

• Credits

  Developed and Designed by:

  Chrism1c