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.