Tools

Click [Tools] in the main menu bar to access the following useful tools available in DB AppMaker.

Synchronization
Multi-Language Property Editor
Advanced Settings
Release Settings (Android)
Remote Build Settings (iOS)
Copy Table Settings
Copy Field Settings
Sort Tables Alphabetically
Delete Template Cache
Menu Editor

 

Synchronization

During project development, you may occasionally alter your database schema. DB AppMaker provides you with the ability to synchronize your project with the database again. The synchronization process can be invoked in the following situations:

  1. When working in DB AppMaker
    Click [Tools]->[Synchronize] or click thebutton on the toolbar to perform the synchronization. DB AppMaker will check to see if the database schema has been altered. If there are changes, you will be prompted whether or not to proceed with the synchronization.
  2. When opening a project file
    When open a project file, DB AppMaker will automatically check the database to see if the schema has been altered. You will be prompted to keep or update to the new schema.
Note If the database contains a large number of tables/fields, this auto-synchronization feature may make reloading a project file slow. In that case you can disable this feature by unchecking [Tool] -> [Auto Synchronize].

 

Multi-Language Property Editor

Some properties support Multi-Language. This editor allows you to enter your property values for each language. See Multi-Language Project for details.

 

Release Settings (Android)

Release Settings are settings required for signing your app before publishing it, make sure you enter all of them.

Android

 

Key store file

keystore is a binary file that contains a set of private keys. You must keep your keystore in a safe and secure place. Specify the path of your keystore, if the file does not exist, it will be created. Make sure you specify a valid path, e.g. a subfolder under your personal folder, C:\Users\<username>\Documents\DBAppMaker\Keystores\<projectname>.keystore.

Key store password Password of the keystore. (Do not use comma.)
Organization unit Organization unit (Do not use comma.)
Organization Organization (Do not use comma.)
City or Locality City (Do not use comma.)
State of Province State or province (Do not use comma.)
Country Code (XX) Two character country code

Read Signing Your Applications for details.

 

Remote Build Settings (iOS)

If you want to build your app by a Mac computer with Xcode and remotebuild installed and started, you must enter the remotebuild settings of the Mac computer:

 

Remote host name / IP address

Remote host name or IP address of the Mac computer.

You can find the IP address from the Mac System Preferences Network configuration screen:

  • From the Apple menu pull down System Preferences
  • Click on the Network preference pane
  • Your IP address will be visible to the right, e.g.
Port number Port number of the Mac computer, default is 3000
PIN PIN number of remotebuild. If remotebuild is start with --secure false option, leave this setting blank.
Development team Your Apple development team ID

Read Remote Build for details.

 

Advanced Settings

These settings are some advanced general settings, or rarely changed settings for the project, or custom defined settings for use during generation. Click [Tools] -> [Advanced Settings] to change these settings:

 

General
Check Node.js packages on start When DB AppMaker is opened, it will try to check the latest version of the required Node.js packages and update them. If you want to skip, uncheck this option.
Project
Project name Project name. See Project File for more info.
Note Use only alphanumerical characters in project name.
Platforms Supported platforms of the app. Possible values are: All, Android or iOS. By default both Android and iOS are supported.
Connection info of production server

Connection information of the production server serving remote data.

Connection info of the production server is usually different from that on your machine. You can override part of the connect on info by entering a PHP array, e.g.

For MySQL,

array("host" => "myHostName", "port" => myPortNumber, "user" => "myUsername", "pass" => "myPassword", "db" => "myDbName")

For PostgreSQL,

array("host" => "myHostName", "port" => myPortNumber, "user" => "myUsername", "pass" => "myPassword", "db" => "myDbName", "schema" => "mySchemaName")

For Oracle,

array("port" => myPortNumber, "user" => "myUsername", "pass" => "myPassword", "db" => "myTNSName", "schema" => "mySchemeName")

For Microsoft Access,

array("relpath" => "myRelativePath")

where "myRelativePath" is the Access database path on the production server relative to the connection script (dbapp.php).

For Microsoft SQL Server,

array("connectionstring" => "myConnectionString")

where "myConnectionString" is the full connection string for the Windows server to connect to the production SQL Server.

Note Since the array is PHP code, make sure you escape any "$" character (and other special characters) with a backslash (\) in your strings. Read Strings.
File folder on production server For use with remote data. For any non-BLOB field storing file names only, the physical files should be placed in this file folder so that they can be loaded by the connection script (dbapp.php) serving remote data. Default value is "files/".
Note File folder is relative to the connection script (dbapp.php). It should end with a slash, e.g. "files/" (without quotes).
Database path on production server (MS Access)

Database path relative to connection script on production server. For use with Microsoft Access and remote data. Default is empty, i.e. the database will be generated in the same folder of the connection script (dbapp.php).

Notes

  1. Database path is relative to the connection script (dbapp.php). It should end with a slash, e.g. "appdata/" (without quotes).
  2. Make sure the web server user has read/write permissions to the database folder.
  3. Configure your server to deny requests for .mdb or .accdb files.
  4. To change database path dynamically, use the Connection info of production server (see above) and change the value of "relpath".
Thumbnail width (List) Thumbnail width in the List page
Thumbnail height (List) Thumbnail height in the List page
Thumbnail width (View) Thumbnail width in the View page
Thumbnail height (View) Thumbnail height in the View page
Compress .css files Compress .css files in the generated app
Compress .js files Compress .js files in the generated app
Use mobile accessibility

Use phonegap-plugin-mobile-accessibility. Supports Use preferred text zoom (see below) and fontsize setting (see Settings).

Use preferred text zoom

Specifies whether or not the app should use the user's preferred text zoom from system settings to scale text within the webview. Requires Use mobile accessibility enabled.

 

Note The settings are defined in the settings.xml located at the "src" folder. If you are an advanced user who customize templates, you can also add your own settings to the "Project" section. Open the settings.xml with a text or XML editor, add a <setting> node under the "Project" section. Make sure you provide an unique id to the setting. Supported data type is "String", "Integer" and "Boolean". If not specified, default is "String". The setting value can be retrieved in the template during code generation (NOT during runtime of the generated app) using the PROJ.id method. Also read Template Tags and Object Properties.

 

 

Copy Table Settings

If you use database built-in query/view to make an alternate version of a table, you need to set up the table and field settings again, this tool help you quickly copies table and field settings from the source table to the view. Click [Tools] -> [Copy Table Settings] to open the following form:

 

Select the [Source table] and the [Target table], click OK to copy the table settings. If a field in the target table has the same name as that in the source table, field settings will also be copied.

Note This feature copies setting without validation. If settings from the source table/field are not applicable to the target table/field, errors may result. Check the settings after copying.

 

 

Copy Field Settings

This tool help you quickly copies field settings from the source table to the view. Click [Tools] -> [Copy Field Settings] to open the following form:

 

Select the [Source table] and the [Target table], the fields of the target table will be listed in the left column, you can then select the respective source fields (from the specified source table) in the right column and click OK to copy the field settings.

 

 

Sort Tables Alphabetically

If you prefer to have the table list displayed in the user interface in alphabetical order, click [Tools] -> [Sort Tables Alphabetically] to do so.

Notes
  1. Re-arranging the table display order by drag-and-drop in the Table Setup page is still supported, so the display order will NOT be re-sorted automatically after synchronizing the project with your database even there are new tables added to the database. Use this tool to sort again if necessary.
  2. Only tables are sorted, the display order of the fields in the user interface or in the generated scripts will NOT be affected by this tool.
  3. The display order of the menu items in the generated apps is still controlled by the Menu Editor, using this tool will NOT affect the menu items.

 

 

Delete Template Cache

DB AppMaker will reuse the pre-processed template scripts to speed up code-generation. We refer to these pre-processed scripts as "template cache", sometimes these template cache may become corrupted resulting from, for example, generating with a corrupted template or badly customized template. In these cases you may want to delete bad template cache and let DB AppMaker builds the template cache again. You can do so by either clicking [Tools] -> [Delete Template Cache] or by manually removing the folder for the template under your Documents folder, i.e. <Documents Folder>\DBAPPMaker\Templates\<TemplateName>.zip\. (Also see Customizing Template.)

 

 

Menu Editor

To open the menu editor, click [Tools] -> [Menu Editor] in the main menu or click the "Menu Editor" icon in the toolbar.

 

Use the following toolbar buttons to manage your menu items:

Add item Add a new menu item. You can add new menu items and link them to your own URLs. Just click the button to add and then enter your URL.
Add child item Add a child menu item to the focused menu item. You can also easily drag-and-drop the icon of a menu item to another menu item to create child menu items.
Delete Delete the focused menu item
Edit item Edit the displayed text of the focused menu item. You can also click the text directly to edit.
Post Post the changes you make to the focused menu item
Cancel Cancel the changes you make to the focused menu item
Refresh Refresh the menu items
Move up one level Move the focused menu item up one level
Move down one level Move the focused menu item down one level
Move Up Move the menu item up
Move Down Move the menu item down
Expand all items Expanse all menu items so all menu items of each level are shown
Collapse all items Collapse all menu items so only menu items of the first level are shown
Multi-Language Show Multi-Language Property Editor for editing unicode menu text

You can show/hide the menu items by checking/unchecking the checkboxes beside the menu item text. If a parent menu item is hidden, all the child items will also be hidden.

If you want to use special characters in the menu caption, you can use HTML entities such as &#euro;.

After modifying, make sure you click [OK] to save the changes.

 

 ©2017 e.World Technology Ltd. All rights reserved.