Creating a new App from scratch in the Orixa DB Utility

The Files you Need

  1. The base Orixa App. You will run this once installation & App building is complete to actually see and use your data.
  2. The Orixa DB Utility. You will run this to create your Orixa Database.
  3. A small number of support files, which will be stored in the same folder as your Orixa App.
  4. At least one creation script, which will be used to build the App.
  5. The Orixa Server program (this is optional, and only needed if you are planning to run the full enterprise version of the program)

Steps

  1. Download all the files, and copy them into a folder on your computer that you are happy to use as the "root" for your App.
  2. Run the Orixa DB Utility and from the "Files" menu, select "Create New Session".
  3. Fill in the details on the "new session" form: A name for the App, and the location of the database-folder that you want to use to store all the data in your App. This folder is usually a sub-folder of the main folder you have used in step 1. Pick a sensible password for your system. If you are using the Orixa Server Program, follow the actions in Step 4., and then enter the IP Address and Port for your server. Once you have completed the settings, close this window, and the Orixa DB Utility will create a new database session on your computer, and store start-up values in the computer's Registry.
  4. If you are using the Orixa Server Program, run it, and open it to set its "Server Settings." Add the Orixa Server Program to your "Start-up Folder" in Windows so it will run whenever Windows starts, or set it to run at start-up using MSConfig. On a server the IP Address is usually 127.0.0.1 and Port 12010.
  5. After you click "Create Session" in step 3., you will be returned to the main screen of the Orixa DB Utility, the new database schema elements will be created and a new session opened. The Framework data-tables will have been created. But as there are not yet any data-tables in your database, you will be prompted to run a SQL Script to create the rest of your system.
  6. Open a Creation Script in the SQL Window, and run it. This should create all the database schema elements your App needs.
  7. Exit the Orixa DB Utility, rename the Orixa App so it has the name you used in step 3., above. You can add a "software logo" JPG image file to the root folder which will be displayed when the App runs, or leave the standard Orixa logo in place. 
  8. Run the Orixa App, it should open showing the "software logo" you have chosen, and prompt you to log-on. The Creation Script will have created one default "Developer" user, and given them a default password of "*****" (5 star symbols) Type **** in the password field, and either press enter, or change the password to something sensible. The App should now launch.
  9. Once your App has launched you can adapt and develop it yourself.


Where do I get the files and documentation with steps to follow?
Email us and we will discuss your needs and the files and Creation Scripts you need.