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.

Logos Form and Report Manager is more than your normal form extension. LFRM can connect with major database systems such as MySQL, Oracle, MSSQL and MS Access and can output data in any format including HTML, XML, and JSON, among others. It also lets you build complex queries with a simple tag syntax. From the bottom-up, LFRM is designed to give the you power and flexibility in creating applications.

For those less familiar with databases, the LFRM Wizard will generate a basic application for you. Simply point LFRM to your MySQL database and follow the steps - the wizard will generate the skeletal code you need to add, edit, publish, and delete records.

Logos Form and Report Manager is optimized to be efficient and secure.  Query caching allows complex query results to be stored on the server to reduce the load on the database, and user input is automatically escaped to prevent SQL injection attacks.  In addition, you can use LFRM's Form Protection feature to require input be submitted by the form interface.

Previous versions of LFRM were also known as LQM or Logos Query Manager.

Logos Form and Report Manager is the most powerful form and report generator available for Joomla. 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.

A demo of many of LFRM's features is available on the GMITC Demo Website, http://demo.gmitc.biz .

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.

Some database knowledge is required to use this component - specifically, the knowledge to query a database using the Structured Query Language, or SQL. Knowledge of HTML and PHP will prove helpful for those wanting to exploit the full capabilities of this component.

Purchasing LFRM

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.

Purchase the LFRM package.

Getting Started Manual

The LFRM 4.0 Getting Started manual is an essential guide to those new to LFRM. The document is structured as a tutorial and will walk you through the steps of creating a basic application.

Additional documentation is within the component itself.

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 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 and 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.

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.

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.

What Is the Activation Code?

In order to use LFRM you will need to register your purchase and obtaining an activation code.  The activation code will disable the nag message that reminds you to register.

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.

How Do I Receive Updates to LFRM ?

You can download new versions of the LFRM extensions from the website, but these new versions always require the corresponding version of the LFRM Library. First you need to register your purchase. Click My Stuff from the top menu for more information.

What is Logos Query Manager?

Logos Query Manager (LQM) is an earlier version of LFRM. Starting with version 4.0, LQM was rebranded as LFRM. Much of the backend and internal functionality is identical, but LFRM uses a new library on the frontend (site application) to generate the form and grid display.

Can I Upgrade from LQM to LFRM?

Yes, as long as you are within your subscription period.

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 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.

Logos Form and Report Manager is provided "as is". Although GMITC has an excellent reputation for helping users on the forum, purchase of this software does not imply any official support obligations. One may request support via the GMITC forum.