January 18 2014
"e-Zvit" reporting server is an Open Source system for sending in, saving and analizing of reporting forms. Any tall structure of reporting organizations can use "e-Zvit" system for working with blanks made in MS Excel(with the XLS extension). The system processes reporting forms receiving on-line, by e-mail, uploading as an Excel file.
Report analizis: "e-Zvit" project allows to create the database of reports,common for a few organizations, departments of a company etc.It uses a system of the global variables for analizing of the received reports. There are some predefined global variables in the system. Another ones are the result of SQL queries to the database. You can gather and sum the data from a number of the reporting forms of the same type, in the one resulting report. It can be usual excel file where the resulting data defined as global variables. Therefore, the structure of your reporting form(Excel file) is of no importance. Analisis of reports sent by e-mail can be made by means of system demon Cron (or another sheduler making system tasks). Using these program capabilities you can check the mailbox, process sent reports, make mailbox log, clear the mailbox, make lists of debtors etc. with the certain periodicity. You also can connect to the following databases:postgresql, mssql,interbase, informix, odbc, mysql, oracle, peardb, adodb.
Access system: "e-Zvit" access system makes in compliance with organization's position in the general hierarchical system of the companies taking part in "e-Zvit". It means that two users from the same organisation have the same rights. Information, received from some organization, is available only for the parent ones.The tall structure of organizations taking part in the Zvit system is the tree-type. It means that an organization can have a number of subordinate ones but only a single parent company. Such a structure allows the reporting system to serve a few "trees" don't bind with the same root.