Cellica Database Anywhere for Windows Phone 8

63 Pages·2013·2.59 MB·English

Cellica Database Anywhere for Windows Phone 8
User Guide
PRODUCT VERSION: 1.0.0.0
1 INTRODUCTION ______________________________________________________________ 5
2 Using the Cellica Database anywhere on the desktop __________________________________ 6
2.1 Profile Manager__________________________________________________________________ 6
2.1.1 Add Profile _____________________________________________________________________________ 7
2.1.2 Edit Profile _____________________________________________________________________________ 7
2.1.3 Remove Profile. __________________________________________________________________________ 7
2.1.4 View Profile Data ________________________________________________________________________ 7
2.1.5 Selection of File base and DSN base database. __________________________________________________ 7
2.1.6 File Based Database ______________________________________________________________________ 8
2.1.7 DSN based Database _____________________________________________________________________ 10
2.1.8 Select Tables from your Database ___________________________________________________________ 11
2.1.9 Select Views/Queries from your Database ____________________________________________________ 12
2.1.10 Apply Filters _________________________________________________________________________ 13
2.1.11 Apply Sort __________________________________________________________________________ 14
2.1.12 Apply Column Sequence: _______________________________________________________________ 15
2.1.13 Selection of Stored Procedure ___________________________________________________________ 16
2.1.14 “Profile available for sync” indication _____________________________________________________ 18
2.2 Form Manager _________________________________________________________________ 18
2.2.1 Add Form (Create Form) __________________________________________________________________ 19
2.2.2 Edit Form ______________________________________________________________________________ 21
2.2.3 Remove Form __________________________________________________________________________ 21
2.2.4 Export Form(s) _________________________________________________________________________ 21
2.3 Form Controls __________________________________________________________________ 21
2.3.1 Label _________________________________________________________________________________ 21
2.3.2 Text Box ______________________________________________________________________________ 22
2.3.3 QR Code/Bar Code ______________________________________________________________________ 23
2.3.4 Check Box _____________________________________________________________________________ 23
2.3.5 Combo Box ____________________________________________________________________________ 24
2.3.5.1 Combobox fixed value list ____________________________________________________________ 25
2.3.5.2 Combobox based on another profile(Lookup) _____________________________________________ 26
2.3.5.3 Combobox based on another profile(Lookup) _____________________________________________ 26
2.3.6 Button ________________________________________________________________________________ 27
2.3.6.1 FIRST ___________________________________________________________________________ 27
2.3.6.2 PREVIOUS _______________________________________________________________________ 27
2.3.6.3 NEXT ____________________________________________________________________________ 27
2.3.6.4 LAST ____________________________________________________________________________ 27
2.3.6.5 NEW ____________________________________________________________________________ 27
2.3.6.6 EDIT ____________________________________________________________________________ 27
2.3.6.7 DELETE _________________________________________________________________________ 27
2.3.6.8 FIND ____________________________________________________________________________ 28
2.3.6.9 GO TO FORM _____________________________________________________________________ 28
2.3.6.10 GO TO RECORD __________________________________________________________________ 30
2.3.6.11 SEND EMAIL _____________________________________________________________________ 30
2.3.6.12 GO TO URL ______________________________________________________________________ 30
2.3.6.13 Phone Call ________________________________________________________________________ 30
2.3.6.14 Send sms _________________________________________________________________________ 30
2.3.6.15 GO TO MAP ______________________________________________________________________ 30
2.3.6.16 Copy Record ______________________________________________________________________ 30
2.3.6.17 Capture ___________________________________________________________________________ 31
2.3.7 Date Time _____________________________________________________________________________ 31
2.3.8 Radio Button ___________________________________________________________________________ 31
2.3.9 Formula _______________________________________________________________________________ 32
2.3.10 Unbound Image ______________________________________________________________________ 33
2.3.11 Location ____________________________________________________________________________ 33
2.3.12 Grid ________________________________________________________________________________ 34
2.3.12.1 Grid On Main Form _________________________________________________________________ 34
2.3.12.2 Grid on Subform: ___________________________________________________________________ 35
2.3.13 Add Page ___________________________________________________________________________ 36
2.3.14 Delete Page __________________________________________________________________________ 36
2.3.15 Delete ______________________________________________________________________________ 36
2.3.16 SubForm ____________________________________________________________________________ 36
2.3.16.1 Create SubForm ____________________________________________________________________ 37
2.3.17 Quick designing tips for Form ___________________________________________________________ 38
2.3.17.1 Resize controls uniformly relative to each other on a form ___________________________________ 39
2.3.17.2 Move multiple controls ______________________________________________________________ 39
2.3.17.3 Manage spacing between controls uniformaly relative to each other on a form ___________________ 39
2.3.17.4 Copy/Paste controls on form __________________________________________________________ 40
2.3.17.5 Aspect Ratio_______________________________________________________________________ 40
2.3.17.6 Manage spacing between pixels on form _________________________________________________ 40
2
2.3.18 Import/Export Form Design _____________________________________________________________ 40
2.3.18.1 Import Form design _________________________________________________________________ 41
2.4 Preferences ____________________________________________________________________ 42
2.4.1 Set Password ___________________________________________________________________________ 42
2.4.2 Start Synchronization/Stop Synchronization___________________________________________________ 42
2.4.3 Synchronization Settings __________________________________________________________________ 42
2.4.4 Connection Settings ______________________________________________________________________ 43
2.4.5 Reset _________________________________________________________________________________ 43
2.4.6 Change Device Resolution/PPI Settings ______________________________________________________ 43
2.4.7 Encryption Settings ______________________________________________________________________ 43
2.5 How to register the software? ______________________________________________________ 44
3 USING THE CELLICA DATABASE ANYWHERE ON THE WINDOWS PHONE 8 _______ 45
3.1 Forms and Profile List on Windows Phone 8 _________________________________________ 45
3.2 Forms on Windows Phone 8. ______________________________________________________ 45
3.2.1 Form View _____________________________________________________________________________ 45
3.2.2 Edit Record in Form _____________________________________________________________________ 46
3.2.3 ComboBox (Lookup) in Form on Windows Phone _____________________________________________ 47
3.2.4 Date Time control on Form for Windows Phone 8 ______________________________________________ 48
3.2.5 Find Button in Form on Windows Phone 8 ____________________________________________________ 48
3.2.6 Add/Edit/Delete data on sub form ___________________________________________________________ 49
3.2.7 Picture Control on Windows Phone 8 ________________________________________________________ 49
3.3 Profile List on Windows Phone 8 ___________________________________________________ 50
3.3.1 Menu on Profile List _____________________________________________________________________ 51
3.3.2 Views available on Windows Phone 8 _______________________________________________________ 51
3.3.2.1 Multiple Record View and Single Record View ___________________________________________ 51
3.3.3 Search Contents _________________________________________________________________________ 53
3.3.4 Preferences ____________________________________________________________________________ 54
3.3.4.1 Data Security ______________________________________________________________________ 55
4 FREQUENTLY ASKED QUESTIONS ____________________________________________ 56
4.1 Does software send complete database every time? ____________________________________ 56
4.2 Is my database secured? __________________________________________________________ 56
4.3 What is evaluation period of this software? ___________________________________________ 56
4.4 I have to change the PC where I have installed desktop software, can I install the software on new
PC ? 57
4.5 Does I need to create forms compulsary in desktop software? ____________________________ 57
4.6 How to re-install desktop software after a PC crash? ____________________________________ 57
4.7 How I can input/read QRcode/Barcode in Cellica Database? ________________________________ 57
4.8 How to use image control for displaying logo? _________________________________________ 57
4.9 How to use FileMaker Pro to create profiles in desktop application? _______________________ 57
4.10 How to use phone call Feature and Send Email Feature on forms? _________________________ 58
4.11 How to select multiple controls on form designer? _____________________________________ 58
4.12 How to work with multiple controls in form designer? __________________________________ 58
4.13 I am getting message, Device ID “XXXXXX” already present? _____________________________ 58
4.14 Can I associate record timestamp with database record?_________________________________ 58
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? ______________________________________________________ 59
4.16 Can I use forms designed with single user edition in enterprise edition?_____________________ 59
4.17 Whenever I add/edit/delete record on device, in Record view I get Red/Cyan color. ___________ 59
4.18 How to scan Bar code in Cellica Database? ____________________________________________ 60
4.19 Can I view and sync PDF data ? _____________________________________________________ 60
5 SUPPORTED DATA TYPES ____________________________________________________ 61
6 CONTACT US ________________________________________________________________ 62
7 SYSTEM REQUIREMENT _____________________________________________________ 63

3
List of Figures

Figure 1: Profile Manager ........................................................................................................................... 6
Figure 2: Database Selection ...................................................................................................................... 8
Figure 3: File Based Database Selection .................................................................................................... 8
Figure 4: Excel Selection ............................................................................................................................ 9
Figure 5: Table Selection .......................................................................................................................... 10
Figure 6: DSN Database Selection ........................................................................................................... 10
Figure 7: Table Selection .......................................................................................................................... 11
Figure 8: Select Views/Queries of your database ..................................................................................... 13
Figure 9: Apply Filter ............................................................................................................................... 14
Figure 10: Apply Sort ............................................................................................................................... 15
Figure 11: Arrange Columns .................................................................................................................... 15
Figure 12: Select DSN of Stored Procedure ............................................................................................. 16
Figure 13: Selection of Stored Procedure ................................................................................................ 17
Figure 14: Profile Ready for Sync ........................................................................................................... 18
Figure 15: Form Manager ......................................................................................................................... 18
Figure 16: Profile Selection for Form ....................................................................................................... 19
Figure 17: Form Designer Canvas ............................................................................................................ 20
Figure 18: Text Box Control Properties.................................................................................................... 22
Figure 19: Checkbox Control Properties .................................................................................................. 24
Figure 20: Combo Box Control Properties with Source Type: Valued List ............................................. 25
Figure 21: Combo Box Control Properties with Source Type: Another Profile....................................... 26
Figure 22: Jump to Form........................................................................................................................... 28
Figure 23: Date Time ................................................................................................................................ 31
Figure 24: Radio Button............................................................................................................................ 31
Figure 25: Formula ................................................................................................................................... 32
Figure 26: Location Control (Longitude/Latitude) ................................................................................... 34
Figure 27: Grid Control Field Selection on Main Form Grid ................................................................... 34
Figure 28: Grid Control Field Selection ................................................................................................... 35
Figure 29: Profile selection for Subform .................................................................................................. 37
Figure 30: Create relation between Main form and Sub form .................................................................. 38
Figure 31: Export Form design ................................................................................................................. 41
Figure 32: Import form design ................................................................................................................. 41
Figure 33: Preferences available on Desktop side Cellica Database Anywhere ...................................... 42
Figure 34: Synchronization Settings ........................................................................................................ 42
Figure 35: Change Windows Phone 8 resolution and PPI ........................................................................ 43
Figure 36: Software Registration .............................................................................................................. 44
Figure 37: Edit record on Form ................................................................................................................ 47
Figure 38: Combo Box in Form on Windows Phone 8 ............................................................................ 47
Figure 39: Date Time Control on form ..................................................................................................... 48
Figure 40: Find functionality on form ...................................................................................................... 48
Figure 41: Edit record on form for Grid control ....................................................................................... 49
Figure 42: Menu on Profile List................................................................................................................ 51
Figure 43: Multiple Record View and Single Record View ..................................................................... 52
Figure 44: Menu available on Single Record View .................................................................................. 52
Figure 45: Search Data.............................................................................................................................. 53
Figure 46: Settings on Windows Phone 8 ................................................................................................. 54
Figure 47: Software Registration .............................................................................................................. 56
Figure 48: Status of updated record .......................................................................................................... 59
4
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 Windows Phone 8, update the
data and send updated data from Windows Phone 8 to original database on PC. Now it is possible
with the Cellica Database Anywhere.
Cellica Database Anywhere for Windows Phone 8 allows you to be more productive by allowing
viewing and updating the database contents on your Windows Phone 8. Cellica Database
Anywhere for Windows Phone 8 allows to sync with Microsoft Access, Microsoft Excel, and any
ODBC Compliant database like Oracle, SQL Server etc. The software package consists of two appl
ications: the Cellica Database Desktop (Server) that runs on Microsoft Windows and Windows
Phone 8 Cellica Database (Client) that run on the Windows Phone 8. You will use the Desktop side
software to create the database profiles (make the list of database) for Windows Phone 8 and data
will be synchronize with Windows Phone 8 depending on your sync settings on phone.
Cellica Database on Windows Phone 8 will receive these profiles and data respectively and view
the contents of the database.
1.1 Features
 Synchronize any desktop side database wirelessly on your Windows Phone 8 (Using Internet).
 Supported Databases: Microsoft Access 97/2000/2003/2007/2010, Microsoft Excel 97/2000/
2003/2007/2010, Oracle, SQL Server, DB2, MySQL, PostgreSQL, FoxPro, dBase, R:BASE,
Sybase, File Maker Pro, Firebird and any ODBC Compliant Database
 Doesn't require any updates or changes in existing database structure for syncing directly with
existing database, which helps it be the easiest, most user-friendly solution available.
 Only the changed data is synchronized, resulting in reduced wireless/cellular data traffic and
therefore reduced network costs and improves battery life of the mobile devices.
 Supports Form: Design forms with Cellica Database's simple and easy to use form builder
interface.
 Design form on desktop using Label, Text Field, Buttons, Checkbox, Radio buttons, Combo box,
Page, Formula, Location Image/Signature control.
 Supports Sub forms, Design a master/detail form, or a parent/child form using sub form.
 Supports Signature - Associate digital signature with records.
 Synchronize image and signature data with desktop database. Supported Jpg, bmp and PNG
image formats.
 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
 Instant Synchronization- Real time synchronization with no lagging.
 Synchronize data from anywhere (Any part of the world).
 Support for Shapes (Line, Rectangle, Rounded Rectangle, Oval etc.) on form.
 Supported Combo Box and Date Time control - Search as you type feature.
 Support Time/Stamp feature to find when user update particular record.
 Support QR Code (Bar code) Scanning.
 Supports Unicode language database such as Japanese, Chinese, Korean, Russian etc.
5
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. 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 setting various application preferences such as Synchronization settings,
Connection Settings and 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 Windows Phone 8 to get the desktop designed form and database to Windows
Phone.

2.1 Profile Manager

Use Profile Manager to add profiles (list of database) for your Windows Phone 8. Use Add Profile/
Remove Profile buttons to update the profiles list.

Figure 1: Profile Manager

6
2.1.1 Add Profile
Use Add Profile button to select the database, which you want to synchronize with Windows
Phone 8.
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.
2.1.4 View Profile Data

View records of selected profile in single record mode.

2.1.5 Selection of File base and DSN base database.
Select the database, which you want to synchronize with Windows Phone 8. User can select
File Based as well as DSN based database. Apply Filter/ Sort for selected tables.

7
Figure 2: Database Selection

2.1.6 File Based Database

Figure 3: File Based Database Selection

8
Click on Browse button to select file of type: MS Access, MS Excel, FoxPro, dBase, you will get
the screen as follows.

1. Select Files of type such as Microsoft Access Database (*.mdb, *.accdb), Excel Files (*.xls,
*.xlsx, *.xlsm), or FoxPro/dbase Database (*.dbf) files and then select File name of your choice,
for example NWIND.mdb, and click Open.
2. When you select an Excel file using Browse button, you will get a dialog prompt as:

Figure 4: Excel Selection

Here, when you select "View As Excel Worksheet", contents will be shown similar to that of
Excel Worksheet. Whereas, when you select "Use first row as a field header", it will be treated
as a database. In this case, customized SQL queries will work on your Spreadsheet.
9
Figure 5: Table Selection

To manually apply filters and sort orders click on "Filters" and "Sort" buttons.
2.1.7 DSN based Database
Click on popup provided to select database via Database Source (DSN) such as Oracle,
MySQL, and SQL Server. You will get list of available Database Source Name.

Figure 6: DSN Database Selection

10