Plandroid - Graphical Air Conditioning Design and Quoting Software

How Do I Connect To My Own Customer Database?

The ability to connect to a different customer database is quite rudimentary in this release, can only work with a fixed database structure, and is unfortunately rather technical. You will need to edit your Plandroid XML configuration file, which could be in a number of different locations. The program looks for configuration information in the following order of precedence:

1. In the user.config file, typically for Windows XP in C:\Documents and Settings\{user}\Local Settings\Application Data\{app_path}\{version}
2. In the Plandroid.exe.config file, typically in your Plandroid installation directory
3. In the Plandroid.exe executable, which is in your Plandroid installation directory, but this cannot be edited

Once you have found your configuration file, you will need to open it, and edit the XML element:

 
   <setting name="CustomDBConnectionString" serializeAs="String">
         <value>Data Source=Custom.db</value>
   </setting>

Replace the existing connection string in the value element with the correct one for your own SQL database. You can then select Tools -> Connect to Database -> Custom Database and you will connect to your own database. Your database must have at least the same fields as the Plandroid default database. The required fields are shown in the SQL command to construct the default database:

CREATE TABLE table1 (QuoteNo INTEGER PRIMARY KEY,
                     FirstName text, 
                     LastName text, 
                     Title text,
                     Address text, 
                     City text, 
                     State text, 
                     Postcode text, 
                     Phone text, 
                     Status text, 
                     Due text)

In addition, Due must be text in a parsable date format, for example 2010-01-01 09:00 AM.

Go back to How do I?

Copyright

Copyright © DelftRed Simulation Technology 2009 – 2011. All rights reserved.

XHTML      CSS     Legal     Privacy