Cellica Database Anywhere for Android - Cellica Software Services

86 Pages·2014·2.78 MB·English

Cellica Database Anywhere for Android
User Guide
PRODUCT VERSION: 4.0.0
1 INTRODUCTION _______________________________________________________________ 7
1.1 Features _________________________________________________________________________ 7
2 Using the Cellica Database anywhere on the desktop ____________________________________ 9
2.1 Profile Manager __________________________________________________________________ 10
2.1.1 Add Profile ______________________________________________________________________________ 10
2.1.2 Edit Profile ______________________________________________________________________________ 10
2.1.3 Remove Profile. __________________________________________________________________________ 10
2.1.4 View Profile Data _________________________________________________________________________ 11
2.1.5 Selection of File base and DSN base database. __________________________________________________ 12
2.1.6 File Based Database _______________________________________________________________________ 13
2.1.7 DSN based Database ______________________________________________________________________ 15
2.1.8 Select Tables from your Database ____________________________________________________________ 15
2.1.9 Select Views/Queries from your Database ______________________________________________________ 16
2.1.10 Apply Filters __________________________________________________________________________ 17
2.1.11 Apply Sort ____________________________________________________________________________ 18
2.1.12 Apply Column Sequence: ________________________________________________________________ 19
2.1.13 Selection of Stored Procedure _____________________________________________________________ 20
2.1.14 “Profile available for sync” indication ______________________________________________________ 22
2.2 Form Manager ___________________________________________________________________ 23
2.2.1 Add Form (Create Form) ___________________________________________________________________ 24
2.2.2 Form Properties __________________________________________________________________________ 26
2.2.3 Edit Form _______________________________________________________________________________ 26
2.2.4 Remove Form ____________________________________________________________________________ 26
2.2.5 Export Form(s) ___________________________________________________________________________ 27
2.3 Form Controls ___________________________________________________________________ 27
2.3.1 Label ___________________________________________________________________________________ 27
2.3.2 Text Box ________________________________________________________________________________ 28
2.3.3 QR Code/Bar Code ________________________________________________________________________ 29
2.3.4 Hide Characters __________________________________________________________________________ 30
2.3.5 NFC Scan(Android/ Windows Phone 8/ Windows RT Only) ______________________________________ 30
2.3.6 NFC Lookup(Android/ Windows Phone 8/ Windows RT Only): ____________________________________ 30
2.3.7 URL ___________________________________________________________________________________ 31
2.3.8 Rich Text _______________________________________________________________________________ 31
2.3.9 Lookup Mapping _________________________________________________________________________ 31
2.3.10 Check Box ____________________________________________________________________________ 31
2.3.11 Combo Box ___________________________________________________________________________ 33
2.3.11.1 Combobox fixed value list _____________________________________________________________ 33
2.3.11.2 Combobox based on Another Profile (Lookup) _____________________________________________ 35
2.3.11.3 Combobox based on Another Profile (Lookup Condition) ____________________________________ 35
2.3.12 Button _______________________________________________________________________________ 36
2.3.12.1 First _______________________________________________________________________________ 37
2.3.12.2 Previous ___________________________________________________________________________ 37
2.3.12.3 Next _______________________________________________________________________________ 37
2.3.12.4 Last _______________________________________________________________________________ 37
2.3.12.5 New _______________________________________________________________________________ 37
2.3.12.6 Edit _______________________________________________________________________________ 37
2.3.12.7 Delete _____________________________________________________________________________ 37
2.3.12.8 Find _______________________________________________________________________________ 37
2.3.12.9 Go To Form ________________________________________________________________________ 37
2.3.12.10 Go To Record _____________________________________________________________________ 39
2.3.12.11 Send Email _______________________________________________________________________ 39
2.3.12.12 Go To URL ______________________________________________________________________ 40
2.3.12.13 Phone Call _______________________________________________________________________ 40
2
2.3.12.14 Send SMS ________________________________________________________________________ 40
2.3.12.15 Go To Map _______________________________________________________________________ 40
2.3.12.16 Copy Record _____________________________________________________________________ 40
2.3.12.17 Capture __________________________________________________________________________ 41
2.3.12.18 Print ____________________________________________________________________________ 41
2.3.12.19 Design View ______________________________________________________________________ 41
2.3.12.20 Help ____________________________________________________________________________ 41
2.3.12.21 Send Record ______________________________________________________________________ 42
2.3.12.22 Sync Action button_________________________________________________________________ 42
2.3.13 Date Time ____________________________________________________________________________ 42
2.3.14 Radio Button __________________________________________________________________________ 43
2.3.15 Formula ______________________________________________________________________________ 44
2.3.16 Unbound Image ________________________________________________________________________ 45
2.3.17 Location ______________________________________________________________________________ 45
2.3.18 Grid _________________________________________________________________________________ 47
2.3.18.1 Grid On Main Form __________________________________________________________________ 47
2.3.18.2 Grid on Subform _____________________________________________________________________ 47
2.3.19 Add Page _____________________________________________________________________________ 48
2.3.20 Import Page ___________________________________________________________________________ 49
2.3.21 Delete Page ___________________________________________________________________________ 49
2.3.22 Delete ________________________________________________________________________________ 49
2.3.23 SubForm _____________________________________________________________________________ 49
2.3.23.1 Create SubForm _____________________________________________________________________ 50
2.3.23.2 Relationship ________________________________________________________________________ 52
2.3.24 Quick designing tips for Form _____________________________________________________________ 52
2.3.24.1 Align controls to each other ____________________________________________________________ 52
2.3.24.2 Resize controls uniformly relative to each other on a form ____________________________________ 53
2.3.24.3 Move multiple controls ________________________________________________________________ 53
2.3.24.4 Manage spacing between controls uniformaly relative to each other on a form ____________________ 54
2.3.24.5 Copy/Paste controls on form____________________________________________________________ 54
2.3.24.6 Aspect Ratio ________________________________________________________________________ 54
2.3.24.7 Manage spacing between pixels on form __________________________________________________ 54
2.3.25 Import/Export Form Design ______________________________________________________________ 54
2.3.25.1 Import Form design __________________________________________________________________ 54
2.4 Settings (Preferences) _____________________________________________________________ 55
2.4.1 Start Synchronization/Stop Synchronization ____________________________________________________ 56
2.4.2 Synchronization Settings ___________________________________________________________________ 56
2.4.3 Connection Settings _______________________________________________________________________ 56
2.4.4 Reset ___________________________________________________________________________________ 56
2.4.5 Change Device Resolution/PPI Settings _______________________________________________________ 56
2.4.6 Encryption Settings _______________________________________________________________________ 57
2.5 How to register the software? _______________________________________________________ 57
3 USING THE CELLICA DATABASE ANYWHERE ON THE ANDROID DEVICE _________ 59
3.1 Forms and Profile List on Android Device ____________________________________________ 59
3.2 Forms on Android Phone. __________________________________________________________ 60
3.2.1 Form View ______________________________________________________________________________ 60
3.2.2 Edit Record in Form _______________________________________________________________________ 61
3.2.3 ComboBox (Lookup) in Form on Android phone/Tablet __________________________________________ 62
3.2.4 Date/Time control in Form on Android Phone or Tablet ___________________________________________ 63
3.2.5 Find Button in Form on Android phone/Tablet __________________________________________________ 64
3.2.6 Add/Edit/Delete data on sub form ____________________________________________________________ 65
3.2.7 Picture Control on Android phone/Tablet ______________________________________________________ 65
3.2.8 Send record data as a .png image _____________________________________________________________ 66
3
3.3 Profile List on Android Phone/Tablet ________________________________________________ 67
3.3.1 Menu on Profile List _______________________________________________________________________ 68
3.3.2 Views available on Android Phone/Tablet _____________________________________________________ 68
3.3.2.1 Multiple Record View and Single Record View ____________________________________________ 69
3.3.3 Search Contents __________________________________________________________________________ 71
3.3.4 Backup Unsync Record ____________________________________________________________________ 71
3.3.5 Preferences ______________________________________________________________________________ 72
3.3.5.1 Data Operation Confirmation ___________________________________________________________ 74
4 FREQUENTLY ASKED QUESTIONS ______________________________________________ 75
4.1 Does software send complete database every time? _____________________________________ 75
4.2 Is my database secured? ____________________________________________________________ 75
4.3 What is evaluation period of this software? ____________________________________________ 75
4.4 I have to change the PC where I have installed desktop software, can I install the software on new
PC? _____________________________________________________________________________ 76
4.5 Does I need to create forms compulsary in desktop software? ______________________________ 76
4.6 How to re-install desktop software after a PC crash? _____________________________________ 76
4.7 How I can can input/read qrcode/barcode in Cellica Database? ____________________________ 76
4.8 How to use image control for displaying logo? __________________________________________ 77
4.9 How to use FileMaker Pro to create profiles in desktop application? ________________________ 77
4.10 How to use phone call Feature and Send Email Feature on forms? __________________________ 77
4.11 How to select multiple controls on form designer? ______________________________________ 77
4.12 How to work with multiple controls in form designer?____________________________________ 78
4.13 I am getting message, Device ID “XXXXXX” already present? _______________________________ 78
4.14 Can I associate record timestamp with database record? __________________________________ 78
4.15 How I can backup my form design work/ Forms/ How I can avoid redesigning of forms/ How I can
reuse form/ How I can rename form? _________________________________________________ 78
4.16 Can I use forms designed with single user edition in enterprise edition? ______________________ 79
4.17 How can I sync my database automatically? ____________________________________________ 79
4.18 What time I can set for automatic synchronization? ______________________________________ 79
4.19 How can I change column width in Multi Column view (Grid View)? _________________________ 79
4.20 Whenever I add/edit/delete record on Android Phone/Tablet, in Record view I get Red/Cyan color 80
4.21 How to scan Bar code in Cellica Database? _____________________________________________ 81
4.22 Can I view and sync PDF data ? _______________________________________________________ 83
5 SUPPORTED DATA TYPES ______________________________________________________ 84
6 CONTACT US _________________________________________________________________ 85
7 SYSTEM REQUIREMENT _______________________________________________________ 86

4
List of Figures

Figure 1: Profile Manager ........................................................................................................................... 10
Figure 2: Database Selection ....................................................................................................................... 12
Figure 3: File Based Database Selection ..................................................................................................... 13
Figure 4: Excel Selection ............................................................................................................................. 14
Figure 5: Table Selection ............................................................................................................................. 14
Figure 6: DSN Database Selection .............................................................................................................. 15
Figure 7: Table Selection ............................................................................................................................. 16
Figure 8: Select Views/Queries of your database ........................................................................................ 17
Figure 9: Apply Filter .................................................................................................................................. 18
Figure 10: Apply Sort .................................................................................................................................. 19
Figure 11: Arrange Columns ....................................................................................................................... 19
Figure 12: Select DSN of Stored Procedure ................................................................................................ 20
Figure 13: Selection of Stored Procedure ................................................................................................... 21
Figure 14: Profile Ready for Sync .............................................................................................................. 22
Figure 15: Form Manager ............................................................................................................................ 23
Figure 16: Profile Selection for Form ......................................................................................................... 24
Figure 17: Form Designer Canvas ............................................................................................................... 26
Figure 18: TextBox Control Properties ....................................................................................................... 28
Figure 19: Checkbox Control Properties ..................................................................................................... 32
Figure 20: Combo Box Control Properties with Source Type: Valued List ............................................... 34
Figure 21: Combo Box Control Properties with Source Type: Another Profile ......................................... 35
Figure 22: Go To Map action ...................................................................................................................... 40
Figure 23: Select "Help File for form" ........................................................................................................ 41
Figure 24: Select Help File Type ................................................................................................................. 41
Figure 25: Select Help File according to file type ....................................................................................... 42
Figure 26: Sync action button ...................................................................................................................... 42
Figure 27: Date Time ................................................................................................................................... 43
Figure 28: Radio Button .............................................................................................................................. 43
Figure 29: Formula ...................................................................................................................................... 44
Figure 30: Location Control (Longitude/Latitude) ...................................................................................... 46
Figure 31: Grid Control Field Selection on Main Form Grid ..................................................................... 47
Figure 32: Profile selection for Subform ..................................................................................................... 50
Figure 33: Create relation between Main form and subform ...................................................................... 51
Figure 34: Setting Relationship type between main and subform. .............................................................. 52
Figure 35: Import form design ................................................................................................................... 55
Figure 36: Preferences available on Desktop side Cellica Database Anywhere ......................................... 55
Figure 37: Synchronization Settings .......................................................................................................... 56
Figure 38: Change Android device resolution and DPI .............................................................................. 57
Figure 39: Software Registration ................................................................................................................. 58
Figure 40: Edit record on Form ................................................................................................................... 61
Figure 41: Combo Box in Form on Android phone/Tablet ......................................................................... 62
Figure 42: Date/Time Control on form ....................................................................................................... 63
Figure 43: Find functionality on form ......................................................................................................... 64
Figure 44: Edit record on form .................................................................................................................... 65
Figure 45: Menu on Profile List .................................................................................................................. 68
5
Figure 46: Multiple Record View and Single Record View ....................................................................... 69
Figure 47: Menu available on Multiple Record View and Single Record View ......................................... 70
Figure 48: Search Data ................................................................................................................................ 71
Figure 49: Preferences on Android .............................................................................................................. 73
Figure 50: Software Registration ................................................................................................................. 76
Figure 51: Change Column Width .............................................................................................................. 80
Figure 52: Status of updated record ............................................................................................................. 81
6
1 INTRODUCTION
Being away from your office does not mean not having the access to your data. Consider the scenario
when you want to carry a copy of the database on your Android device, update the data and send updated
data from Android device to original database on PC. Now it is possible with the Cellica Database
Anywhere.
Cellica Database Anywhere for Android allows you to be more productive by allowing viewing and updating
the database contents on your Android device. Cellica Database Anywhere for Android device allows to
sync with Microsoft Access, Microsoft Excel, and any ODBC Compliant databases like Oracle, SQL Server
etc. The software package consists of two components: the Cellica Database Desktop (Server) that runs on
Microsoft Windows, and Android device Cellica Database (Client) that run on the Android device. You will
use the Desktop side software to create the database profiles (make the list of database) for Android
phone/ Tablet and data will be synchronize with Android phone/ Tablet depending on your sync settings
on phone/ Tablet.
Cellica Database on Android phone/ Tablet will receive these profiles and data respectively and view the
contents of the database.
1.1 Features
 Synchronize data Wirelessly with Android phone/ Tablet (Using Internet).
 View and update data on Android phone/ Tablet, which will reflect to Server database immediately.
 Synchronize Table/View or Stored Procedure of your database with Android phone/ Tablet
 Synchronize only updated desktop data to Android device.
 Apply SQL Select queries, Filters; Sort the fields and Synchronize data according to it.
 Supports Databases: Microsoft Access 97/2000/2003/2007/2010, Microsoft Excel 97/2000/2003/2007/
2010, Oracle, Microsoft SQL Server, Sybase, FileMaker Pro, DB2, MySQL, PostgreSQL, FoxPro, dBase,
R:BASE and any ODBC Compliant Database.
 Get the data of Views and Stored Procedure of DSN base database on Android device.
 Create your own custom database on Android device, or choose from one of the predesigned templates
such as Vehicle Info, Bank Account, and Membership Info etc.
 Supported Password protection.
 Supports Unicode language database such as Japanese, Chinese, Korean, Russian etc.
 Supported Forms on phone/ Tablet.
 Design form on desktop with Label, Text Field, Buttons, Checkbox, Combo box, Page control
 Supports Sub forms, Design a master/detail form, or a parent/child form using sub form.
 Send single record data on form as a .PNG image by Email.
 Image control on form, Select image on device for each record.
 Create form in Portrait/ Landscape mode.
 Import/Export form design.
7
 Data is not stored on any Intermediate Server.
 While synchronization data is AES encrypted and compressed.
 Data is more secured as it is transfer through SSL.
 Password protection supported for device side application.

8
2 USING THE CELLICA DATABASE ANYWHERE ON THE DESKTOP

This section will explain how to use Cellica Database Anywhere software on the PC.
Run CellicaDatabase from the shortcut available on the desktop, or use Start Menu: Start->
Programs-> Cellica Database Anywhere-> Cellica Database Anywhere.
There are three modules available here.

1. Profile Manager
2. Form Manager
3. Settings (Preferences)

Profile Manager allows you to select your Table/Views/Stored Procedure to transfer to device.
Form Manager allows you to design the form on the created profile in Profile Manager Module.
Preference allows to set various application preferences such as Synchronization settings, Connection
Settings etc.

First use “ Profile Manger” to select your database then only use “ Form Manager” to design the form.

Once you create the Profile and Forms in desktop side Cellica Database Anywhere software, just sync from
Android device to get the desktop designed form and database to Android device.

9
2.1 Profile Manager
Use Profile Manager to add profiles (list of database) for your Android device. Use Add Profile/
Remove Profile buttons to update the profiles list.

Figure 1: Profile Manager

2.1.1 Add Profile
Use Add Profile button to select the database, which you want to synchronize with Android device.
On clicking “ Add Profile” button, you will get “ New Profile: Database Connection” dialog.
2.1.2 Edit Profile
Use Edit Profile button to update the selected profile. You can select another Table/Views/Queries/Stored
Procedure. Also you can change the Filter/Sort/Column Sequence of selected Profile.
2.1.3 Remove Profile.
Use “ Remove Profile” button to remove the selected profile from device and desktop.
This action will remove profile first from desktop software and then on next sync from device, it will be
deleted from device also.

10