Plandroid Help Documentation

Plandroid supports running simple database searches plus record editing on the customer database directly from the Customer page. However, with some (not insignificant) technical knowledge, it is possible to run much more sophisticated queries against the customer database. For example, you may wish to know which customer records have a Status of Service and a Due date which falls in the coming month so you can plan your service calls. You can query your database to answer this, or any similar question about your data that you have.

To do this you can open your customer database in any SQL-compliant database editing tool. Alternatively, you can download a free command-line program for accessing and modifying SQLite databases from the SQLite site: www.sqlite.org. This site also has introductory documentation on SQL commands, as does Wikipedia.

Your customer database will by default (on Windows XP) be located in the directory: C:\Documents and Settings\All Users\Application Data\DelftRed\Plandroid\Database. The location of your Application Data directory may vary depending on your computer settings or your operating system version.

Go back to How do I?