|
|
| : Home
| Documentation | adminApp
| Installation |
| |
|
|
| |
|
adminApp Installation
|
|
|
- (*)
Requirements: |
|
In order to run adminApp on your
computer, you must
have Suns Java
version 1.4+ installed. We also suggest
installing the J2SE 1.5 SDK (Standard
Edition
- Developer Kit).
You can test if you have java
installed or find download links here. |
|
|
|
- Install:
|
adminApp
comes with 2 folders
1. the adminApp folder (the actual adminApp
java application that stays on your
computer)
2. the qcomms folder. Uploaded to your
web site.
Ex: http://www.mysite.com/shop/qcomms/qcomms.php
adminApp connects to qcomms.php to
interact with your mysql database(s). |
|
Edit
the qcomms/qcommsheader.php
// must match Admin Username
in your adminApp Web
SiteSettings, see below. The
admin username or //
password in qcommsheader php
have nothing to do with you,
site, mysql, ftp, or any
other username or password.
They are just ones that you
are using for this adminApp.
They cannot contain blank
spaces, funky characters,
etc, etc. Although, you must
use the same ones in your
adminApp Web SiteSettings,
see below.
$adminuser
= "admin";
// must match Admin Password
in your adminApp Web Site
Settings
$adminpass
= "admin";
Then
for each database:
if($dbase
== "shop") {
// if the database used by
adminApp is shop
$dbuser
= "myDBusername";
// then the database
username is myDBusername
$dbpass
= "myDBpassword";
// and database password is
myDBpassword
}
Upload
the qcomms folder to your
web-site
chmodd
both qcomms and the
subfolder qcomms/dbqs 777
Thats it for the web
site configuration. Now to
test the connections with
adminApp |
 If
your java is installed and
working properly, all you
need to do is double click
the adminApp.jar file found
in your adminApp folder.
adminAppīs spash screen
should show up while
adminApp is loading. If it
gets stuck on the Splash
Screen, try
moving the jawin.dll file
and the Jutil.dll to your c:\windows
folder.
If that doesnt work, try
double clicking the
adminapp.bat file. You can
open and edit the
adminapp.bat file with
notepad or any text editor.
If you do not want to see
the console window, just
change the java word to
javaw. You can also copy and
paste the output from the
.bat file to locate the
error given.
Remember, to use
adminApp, you must be
online. It connects to your
qcomms.php file. |
|
|
 You
will first have to edit your
adminApp WebSite Settings.
Click on the Tools menu and
select WebSite Settings. The
following WebSite Settings
dialog box should pop up.
|
|
 Change
the Web Folder Url to
directory in which your
qcomms folder was uploaded.
In this case, the qcomms.php
file would be found at:
http://......./shop/qcomms/qcomms.php
Enter the same username
and password you used in
your uploaded
qcommsheader.php file, see
above. Click apply, confirm,
and close this WebSite
Settings Dialog.
|
|
|
|
|
|
adding your databases to
adminApp.
To add your databases to adminApp, you
need to Open up the Database Query Box.
|
1.
You can open it either by:
Clicking the button top
right corner:
 |
2.
Right clicking over the
spread sheet and select it
from the pop up menu
 |
3.
Or selecting it from the top
Tools menu.
 |
|
Once
the Database Query Box
is open, you will see
an Add Database textfield at the bottom.
Enter your mysql
database name and
click add. It will be
added to your DataBase
list.
Select the Database
from the list to set
it as your current
working database. |
 |
|
|
|
|
 Click
the Refresh Database button,
and it will connect to your
websites qcomms.php and refresh the
database Table list with the
actual tables from your
added database..
|
|
|
|
|
Retreving and editing
records from your database:
Supposing your database name was
"shop" and you wanted to
retreive all records from the table
"product" where the table
field "CategoryID" value
contained "GroovyItems". You
would select the database shop, table
product, field CategoryID, introduce
GroovyItems in the search criteria field.
|
 |
| You
would then either click the
Run Query Label, or just press
your Enter keyboard key. |
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
