adminApp - ver1.2 released

[ver 1.2 Release]    2010-11-19
-------------------------
- Added language and locale settings for the help documentation.
- Last [number of search results] used is remembered and saved.
- Last database and table used is remembered and saved.
- Delete Rows menu added to right click pop up on spread sheet.

adminApp MySql - Spread Sheet App ver1.1 released

adminApp - MySQL to Spread-Sheet App ver1.1










adminApp the client side application written in Java that gives you spread sheet support to your MySQL database and requires no drivers has a new version release:

[ver 1.01 Release Beta]    2010-10-16
-------------------------
- Added Portuguese (Portugal) language and locale settings.
- Search Query box with added search functionality.
- Add to Pending Queiries option added to right click menu and top Menu in Spread sheet
- qcomms file fixed to accept large sql queires.
- updating mechanism added to update qcomms.php without having to upload via FTP
- New funky splash image

adminApp working with 2 databases

Working with a local database and a remote database is easy with adminApp.
Once you have adminApp downloaded:
http://www.technewsi.com/projects/adminApp/

with local and remote databases set up:
http://www.technewsi.com/projects/adminApp/docs/

Suppose you wanted to transfer records from your remote database to you local database for testing.
Search the records you would like in your remote database (see Tutorials -> Searching Records in docs).
After the results are returned on the spread-sheet, switch in the database list to your local database:





Then click the Upload records button found on top right hand corner of adminApp.
All records are uploaded to your local database.

Using JremoveBOM with FileZilla

You can remove them byte order marks from your pages before uploading them with FileZilla.
Download JRemoveBom:

http://www.technewsi.com/projects/JremoveBOM/

In FileZill menu Edit -> Settings (select File Viewing / Editing in pop-up)
Then manually enter JRemoveBom in the Custom File Associations box.
example:
php C:\Program Files\JremoveBOM\JremoveBOM.exe

Now when you right click over your Local Site file in Filezilla and select View / Edit, it will launch JRemoveBom and check the file for BOM´s before you upload it to your server.

Javascript Compression

If your using alot of Javascript and/or CSS in your applications, and want to keep it as compact as possible, you might want to check out yuicompressor (Java Application).
http://developer.yahoo.com/yui/compressor/

to run it with a .bat file (modify file locations - basically compressing original style.css to the css_c compressed folder.):
java -jar yuicompressor-2.3.5.jar --line-break 0 --nomunge D:\www\xampp\htdocs\web\css\style.css -o D:\www\xampp\htdocs\web\css_c\style.css

In php you can then just toggle the original code and compressed code with something like:

if($debugg) {
$siteJsDir = $siteWebDir . "/js_c";
$siteCssDir = $siteWebDir . "/css_c";
} else {

$siteJsDir = $siteWebDir . "/js";
$siteCssDir = $siteWebDir . "/css";

}

then include it in web page
echo "link href=$siteCssDir/style.css  .......................

tSMSLogic SMS Software

if your looking for some heavy SMS logic or have come up with the next best SMS Social twist, this may help. All open sourced:
http://www.technewsi.com/projects/tSMSLogic/index.php

tSMSLogic is based on Kalkun and uses the gammu-smsd daemon (running with mysql), for
sending and retrieving incoming SMS messages.