technewsi.com Blog

adminApp - ver1.2 released

2010-11-21T11:25:00.000-08:00

[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

2010-10-21T15:52:00.000-07:00

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

2010-09-13T02:18:00.000-07:00

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

2010-09-12T15:07:00.000-07:00

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

2010-09-09T14:50:00.000-07:00

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

2010-09-06T05:17:00.000-07:00

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.