Skip to content

Latest commit

 

History

History
113 lines (84 loc) · 3.11 KB

README.md

File metadata and controls

113 lines (84 loc) · 3.11 KB
Raw

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?

    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