Categories

Updated: 01/19/2005

&"e-Zvit&" reports processing server

&"e-Zvit&" reporting server is an OpenSource 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.
©2003-2019 jCay.com