This open source system facilitates the submission, storage, and analysis of reports in organizations. Users can submit reports via online forms, email, or Excel files which are then stored in a database. The system allows for easy analysis of reporting data using SQL queries.
e-Zvit is an Open Source reporting server that facilitates the sending, storing, and analyzing of reporting forms. This system is suitable for organizations of all sizes and can work with forms created in MS Excel, with the XLS extension. Reporting forms can be processed via online submission, email, or file upload.
The project allows for the creation of a common database of reports for multiple organizations, departments, and companies. It uses a system of global variables to analyze received data, including predefined variables and those resulting from SQL queries to the database. The data from multiple forms of the same type can be combined into a single report.
Reports sent via email can be analyzed using the system demon Cron, or another scheduler application. This allows for automated processing of reports, mailbox logs, debtor lists, and more. The system supports connection to multiple databases, including PostgreSQL, MSSQL, Interbase, Informix, ODBC, MySQL, Oracle, PearDB, and ADODB.
Access to the system is determined by an organization's position in the overall hierarchical structure of organizations using e-Zvit. Users with the same organization have the same rights, and information received from one organization is only available to its parent companies.
The hierarchical structure of organizations using e-Zvit is tree-based, allowing for multiple subordinate organizations with a single parent company. This structure enables the reporting system to serve multiple organizational "trees" without being tied to a single root.
In conclusion, e-Zvit is a highly functional reporting server that enables efficient and effective reporting form processing and analysis for organizations of all sizes. Its support for multiple database systems and automated processing makes it a reliable and robust solution.
Version 1.0: N/A