Logos Form and Report Manager ( LFRM ) enables you to integrate databases into your Joomla website. For example, using LFRM one can easily build an interface for searching and viewing sport scores, adding contact information for organizations or clubs, loading data from a file, and creating reports that summarize sales. One can quickly build complex applications using a few queries and, because LFRM works directly with the database you have maximum control over how your application works.

LFRM enables Joomla websites to access and interact with many different types of databases such as Mysql, SQL Server, Oracle and MS Access. Through this simple yet powerful enhancement, a typical website can become an information store and serves as a communication point between the users and organizations or businesses. Data from the database can be exported in many non-HTML output formats such as XML, JSON, and CSV. Numerous types and varieties of application can be developed using LFRM and customized to satisfy the most demanding of business or organizational requirements.

The LFRM Wizard can assist developers in generating a basic application by creating the skeletal code needed to add, edit, publish, and delete records. This tool not only reduces unnecessary errors and efforts but also dramatically reduces development time and budget costs, which in turns increases work productivity and benefits the business end users and organizations down the line.

Many form generators overlook the issue of website performance and security. Here LFRM adds more benefits through the use of Query Caching and Form Protection. Query Caching allows complex query results to be stored on the server, reducing the load on the database and thus, increases performance on the website. Form Protection greatly decreases the chance of hackers attacking the database to steal or destroy data, rendering the website totally incapacitated and customers' data compromised and used in unauthorized manners. These issues were on the mind of the creators of LFRM during the design phase and had been incorporated so that LFRM users will not have to work through these issues.

Logos Form and Report Manager is the most powerful form and report generator available for Joomla, offering extensive features to integrate your data into your website and to offer your users safe and secure access to that data.  Using LFRM you can build complex reports that report on anything, even on systems that reside outside of Joomla.

To see some of these features in action, please visit the GMITC Demo website, http://demo.gmitc.biz, where you can test many of the basic and advanced features.

Among LFRM's many features are the following:

Grid Pagination Users can use a dynamic grid to view and browse the data. Using LFRM is it possible for the user to instantly access thousands of records directly in the browser, even if the client is offline. The grid display is not the only layout available with LFRM. It is also possible to display data in an HTML table and an single vertical record. You can create your own layouts to meet specific business needs.
Sorting, Grouping, and Editing The grid display also allows one to organize data. It is possible to sort fields numerically, alphabetically, and by date, and data can also be grouped into similar sets and summarized, letting users easily understand the data. The grid display also supports inline editing so that records can be updated without using a separate form.
Form Generation The form view is the standard inferface that a user will use to search the database. LFRM provides several input types such as standard text, file, and list input elements, as well as advanced elements such as WYSIWYG editors and date/time selectors. Forms are not limited to searches of the database. One can also generate forms to add and edit records, to remove records, or even to manipulate several data sets at once using LFRM's advanced Multiple Execution Feature ( MQE ).
Input Validation There are several ways to validate user input directly on the client using built-in data types such as e-mail, url, int, float, and date validations. You can also define lists of acceptable characters as well as minimum and maximum limits on length. Special inputs, such as a file upload input, provide even more control of user input.
Data Export In addition to the standard HTML interface, LFRM also supports the export of data in formats such as CSV, JSON, and XML. Using these formats one can use LFRM to build REST applications and supply data to non-Joomla remote clients.
LFRM Queries Queries are the hard of LFRM. Because you can define your own queries, you are not limited to the standard features of other form generators. Using LFRM you can perform any database CRUD operation that you could using a direct connection to the database, including operations like SELECT, UPDATE, and DELETE, and advanced syntax such as JOIN, GROUP BY, CALL, and LOAD. In essence, LFRM supports most features that your database does.
LFRM Wizard If you are new to databases and do not know how to build queries then the LFRM Wizard can help you generate several standard queries that you can modify to your needs. Just point the Wizard to your database and table, and the Wizard will automatically generate the queries you need to search, edit, and maintain the database.
Joomla Integration In addition to running as a component, LFRM can also be used within Joomla articles and as a module using the Plugin and Module extensions.
Sample Applications When you purchase LFRM you can also use any of several prebuilt sample applications. Simply upload the XML file to your server and the application will be installed. The applications are a great way to start using LFRM because you can customize the application's queries to suit your specific business needs.

The current version of Logos Form and Report Manager works with recent releases of the Joomla 1.5 system. It will not work with either Joomla 1.0 or any of the Mambo distributions. LFRM also requires PHP 5, and the DOMDocument core library must be enabled.

The LFRM package consists of the LFRM components and the special LFRM library which handles the interaction between the website and the database. Once you have completed the order and registered your site, you can then download updates for one year.

A variety of licenses are available for users. If you wish to build an application and deploy it on several sites, we recommend that you purchase a multi-license package which are offered at a discount.

Logos Form and Report Manager is extensively documented. For questions about how to install or to build forms and reports, please visit our wiki documentation.

Support is provided via the GMITC Support Forum where we have a forum board dedicated to questions related to all aspects of LFRM. We do not provide support via e-mail.

Consulting services are also available. We can help you build or customize your LFRM application.

Will LFRM Work with Joomla 1.0?

No. The LFRM extensions only works with the new Joomla 1.5 system.

Will LFRM Work with Joomla 1.5?

Yes. The LFRM extensions are native Joomla 1.5 extensions. The LFRM Library is not dependent on Joomla and will thus work on any system including 1.5 .

What is the minimum requirement I need to install LFRM on my server? And what can happen if I don't have these requirements?

To use LFRM, your hosting provider or your server will need PHP 5 and MySQL 5.0. In addition, one will need to have some knowledge of database and SQL language proficiency.

What databases can LFRM connect to?

LFRM can connect to MYSQL, Oracle, Postgressql, MSAccess, and SQL Server, among others.

What is the LFRM Library?

The library is a commercial library used by the LFRM Joomla extensions. Although you can download the extensions for free, it is the library that performs the actual work of LFRM.

How Much Does LFRM Cost?

The Logos Form and Report Manager extensions for Joomla are free but the LFRM library costs $50 for one site. Multiple site licenses are available as well. If you purchase LFRM, you can receive updates for one year. Please see 'Pricing' page for more details.

How Do I Purchase LFRM?

You can purchase it using your credit card or PayPal account. Bank and Western Union transfers are not accepted.

Can I Purchase LFRM Using a Credit Card?

Yes. Use the PayPal payment method. When you arrive at the PayPal site, click the Continue button under the text "Don't have a PayPal Account".

Is There a Free Trial Version of the Library?

Not at this time.

How do I check my purchase history?

You can check on this information in the ‘My Stuff’ tab on the GMITC website.

Once I Purchase LFRM, How Do I Receive It?

After the transaction has been processed, you will receive a download link by mail. Usually this link is mailed to you immediately. You can click on My Stuff to view information about your orders, registrations, and updates. If there are any problems, please contact us via the support forum. Please remember that the component and library work together and must be of the same version.

Once I Have the Extensions and Library, How Do I Install Them?

Please have a look at the LFRM Getting Started Manual and the section titled Installation.

Why Should I Register on the Forum?

You should register on the forum if you wish to receive online support. Once you become a member of the forum, you will have access to all forum discussions and other users Q & A materials about LFRM as well as best practices, tips and tricks.

How long do I have to receive new update after my initial purchase?

You have one year from the time of initial purchase to download new updates.

Can I transfer LFRM from one site to another site or do I need to make another purchase?

Yes. You may transfer the use of LFRM to another site as long as only have one production site using LFRM at any given time.

What is an SQL injection attack? And what does that have to do with LFRM?

An SQL injection attack is a security vulnerability in which hackers can add additional SQL statement into an online form and get access to, and therefore, compromise the integrity and security of a database. In some case, the database itself can be taken over by hackers that can then delete or steal data for unauthorized use. LFRM comes equipped with form protection and SQL injection protection built-in for additional added security to prevent this vulnerability.

Any part of LFRM, such as CMS-specific extensions or the library, are delivered unencrypted and you are free to modify any of the files for your own usage. If you wish to share your modifications, please do so on the GMITC forum but be mindful to post the modifications, not the entire file. Generally speaking, GMITC is more concerned about helping people adapt the software than policing the license.

The LFRM Joomla Extensions, including the component, module, and content plugin, are licensed under the GNU General Public License. The LFRM application does require non-Joomla libraries that must be installed in order to fully utilize all features and that can be purchased from the GMITC website.

The LFRM Library is a proprietary library and its redistribution and usage, in whole or in part, is restricted by the license agreement. By purchasing, installing, or using this library, you are agreeing that its distribution and usage complies with laws in your country.