Elxis CMS Forum

Support => General => Topic started by: ROUBOS on February 01, 2013, 07:32:27

Title: Can this be done using Elxis? (create database forms, reports)
Post by: ROUBOS on February 01, 2013, 07:32:27

Hi,
can this be done using elxis? Is there a component that might do it?

I want to create a small database like an inventory system. And I want a user to logon to a page, and to be able to use an online form to enter data into the database, and then retrieve information like reports off it.

Example: a quarry has a range of Blocks sorted by series or type for sale. Then a user logs on to enter client/customer details. And then use a form to place orders). Then to be able to print a report on all orders placed that day, make changes to the orders and keep track of information.

So basically data entry to database tables, and report printing online.

thanks
any suggestions will be appreciated 

at the moment trying to create the databse on Access2010, even trying to create pages using mysql php generators

Title: Re: Can this be done using Elxis? (create database forms, reports)
Post by: xmanhattan on February 02, 2013, 11:48:08

Hello Roubos,

I have used Elxis with downloads/content/219.html and created scripts for programs that users wanted.
The way I did it was to setup a special user login and give that person access to a link so that only that person could run the program that they wanted.

The best way for you to proceed is to write the program and then place it in a separate directory.  You can setup one or more separate tables under the Elxis database for your program using the same naming as your other tables, e.g. elx_name.  This will also be backed up when ever the admin does a backup of the database.

Hope this info helps.