Titanium Appcelerator How to disable separatorColor in table view ?

Problem resolved in Android windows7

var tableview = Ti.UI.createTableView({
 separatorColor: 'transparent'
});

Titanium MVC Framework

http://johnkalberer.com/2011/09/08/mvc-for-appcelerator/

Titanium Studio install and configure in Windows 7

1. Download and install Java JDK 1.6.x
2. Download and install android SDK version any with android2.1 API Level 7 ( then you can choose all additional apis )
3. Environmental Variable PATH setup as given below
 %SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;%SYSTEMROOT%\System32\WindowsPowerShell\v1.0\;C:\Program Files\Java\jdk1.6.0_29\bin;C:\Program Files\Android\android-sdk\tools;

SystemRoot --> Windows will take automatically
4. Download and Install Titanium Studio ( Titanium mobile-sdk will install continually with this )

Failed to fetch URL https://dl-ssl.google.com/android/repository/addons_list.xml, reason: File not found

I now spent two hours on this issue
* I have no proxy in my system
* I forced 'http' insteas of 'https'
* I deactivated my virus scanner
* I even deactivated Windows firewall
Nothing helped!
Then I had an idea, I am using Windows 7. So if you are using Windows 7 and you have installed android-sdk under 'C:\Programs' then you have to run the sdk as 
administrator!
Windows Start --> Programs --> android --> android-sdk --> right mouse click --> run as administrator.
This helped, now I am able to install new packages. 

http://code.google.com/p/android/issues/detail?id=21359

Titanium Comparability Matrix

https://wiki.appcelerator.org/display/guides/Titanium+Compatibility+Matrix

Titanium Appcelerator - Import project - resource already exists

If you deleted exiting project folder from "Work Space" means open Titanium Studio -->Window-->Show View--> "Project Explorer" . There you can find deleted project Resource file to delete completely. Then import new in same name again.

Import Excel or CSV to MYsql

1. Convert Excel file to CSV format.
2. Use PHPMYAdmin and then execute below SQL statement.

LOAD DATA LOCAL INFILE 'D:\\filename.csv' INTO TABLE database.tablename FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\r\n' (fieldname1,fieldname2,fieldname3 )