Cellica Database for Android(Wi-Fi): FAQ


What is Difference between Wi-Fi version and Interent version?

Following are the additional features in this Wi-Fi version.

1. Supports Signature control.
2. Support images synchronization with desktop database.
3. Instant data synchronization in both direction.
4. No need of internet on device.

Internet version allows to synchronize data from any where.

Wi-Fi version supports synchronization of data only in local Wi-Fi area.


Is my database secured?

Yes, Data transfer between Android device side DBViewer Plus and Server application is secured as 128 bit AES is used for encryption.


What is evaluation period of this software?

Software has 10 days evaluation period. In 10 days, software will work with all features and functionalities. After 10 days, Desktop side application will ask for license key. Then visit Cellica to purchase the software. After purchasing the software, you will get license key. Use it in following activation form.


How can I synchronize data automatically?

To start synchronization automatically, In preferences form of Cellica DB WiFi on your Android device, Set "Sync Menu" option to Disabled. This will allow you to set "Sync Interval". In Sync Interval you can set Day, Hours, Minutes.


What time I can set for automatic synchronization?

For automatic synchronization, you can set :Sync Interval" option in Days, Hours, Minutes.


How to re-install desktop software after a PC crash?

Please send us IMEI/MEID/MAC Address of your iPad/iPod Touch to support@cellica.com and write us exact reason what happened with the PC where you had installed desktop software.


How I can use device id in Cellica Database (Wi-Fi) for iPad ?

Drag TextBox control on form and set �Content Type� property of TextBox on form to �IMEI/MEID/MAC Address�. Now on device when you create new record this field will be populated by device�s IMEI/MEID/MAC Address.


How I can can input/read qrcode/barcode in Cellica Database (Wi-Fi) for iPad ?

Using inbuilt camera to scan QR/BarCode.

In this case we need to use �Content Type� property of TextBox on form. Set this property to �QR Code�.


How to use Send Email Feature on forms?

Use button control on form and then set button action to one of the desired action, �Send email�. Now set the �Data Column� property to set the destination field of profile whose data you want to use.


How to use image control for displaying logo?

Drag Unbound image control on form and set �Content Type� Property to �Logo�. Now on device you have to choose image for this control only once and same will be displayed for all records.


How to use FileMaker Pro to create profiles in desktop application?

A) Until version Filemaker Pro 7

You can create profiles using File base connection (Select your Filemaker Pro Database directly while creating Profile using �Browse� button) and Using DSN base connection (Create DSN of your Filemaker Pro database by using the ODBC driver for Filemaker Pro) on profile connection page.

B) After Version FileMaker Pro 7

Only DSN base connection will work. Create DSN of your Filemaker Pro database by using the ODBC driver for Filmmaker Pro.


How to select multiple controls on form designer?

On Main form:

a. Hold CTRL Key & Select Controls one by one.

b. Drag a rectangle over the controls to select the Controls.

On Subform

a. Hold CTRL Key & Select Controls one by one.


How to work with multiple controls in form designer?

Moving multiple controls

a) Select multiple controls.

b) Now use Arrow keys to move the multiple controls on the form. Or Hold SHIFT Key and Drag Selected Controls to desired place.

Resizing multiple controls

a) Select multiple controls.

b) Use Shift Key + Arrow Keys to resize multiple controls.


I am getting message, Device ID �XXXXXX� already present?

This message appears when installation for same ID is present for single user version or device with this ID is added in Enterprise edition.


Can I associate record timestamp with database record?

You can do this with Cellica Database (Wi-Fi). Profile should have column with type DateTime (Timestamp). Drag �DateTime� control on form, set its Data column property to Timestamp column in which you want to save �Record Timestamp�. Now set �Def Val_Type� property of DateTime control to �Timestamp�. Now when you add or edit record on device side, this field is populated with current timestamp. If you want to do this in background then you can do this by setting �Visible� property of DateTime Control to �TRUE.


How can I associate digital signature with record?

Drag �Bounded Image� control on form set its data column property to column with binary type. Now set the �Content Type� property to �Signature�. On device side user can attach signature with this record by tapping on this control and this will be synced with desktop.


How Cellica Database (Wi-Fi) handles Image/Signature data?

Image/Signature data is considered as binary data in Cellica Database (Wi-Fi). Cellica Database (Wi-Fi) stores Image/Signature data in binary format in user database. User can use this binary data to display Image/Signature in his application or he can view Image/Signature using �View Data�( Ref. 1.1.4 View Profile Data) option in desktop Cellica Database (Wi-Fi). User can also export Image/Signature data in external file in .png format using "Save" button from view data option.


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?

There are 2 ways you can save your form designing work

a) Export multiple forms using �Export� option available on Form Manager Click on �Export� button on Form Manager, you will be presented with list of existing form, select one or more forms from the list, and choose �Export�. Select location for saving forms (.fm) files.

b) Using export button on toolbar in Form Designer window Sometimes you may want to take backup of your form while you are in between form designing process before making big change in design. For this purpose there is �Export Form� button on toolbar on Form Designer Window. Click it to export your existing form layout and save it.


Can I use forms designed with single user edition in enterprise edition?

Yes, Form designed with single user edition can be used in enterprise edition. You need to export forms from single user edition( ref 11) and import them in Enterprise edition form manager while creating new form.


Whenever I add/edit/delete record on Android device, in Record view I get Red/Cyan color.

Cyan color indicates that record synchronization is still in progress. Red color indicates that Record has problem while syncing with desktop database. Status menu shows information related with record syncing process.


How to scan Bar code in Cellica Database?

You need to hold for few seconds on Text Box in Form and it will display menu "Scan Barcode".

On clicking this �Scan Barcode� menu, you will get another dialog, where you have to select type of bar code you want to scan (�Scan QR Code/ Scan Product/Auto Detect�).

Software will scan the Bar code according to this and display data in text box.

Scan QR Code: Use this option to scan QR Code.

Scan Product: Use this option to scan One Dimensional Bar codes on products.

Auto Detect: Use this option, if you do not know the Bar code type.

You can get barcode scanning option in Text Box control on forms, Search Field and in editing profile data.

PS: To enable barcode scanning functionality on your device, you should have installed "Barcode Scanner" application on your Android device.


How can I change column width in Multi Column view (Grid View)?

Please Tap on Grid view on particular column whose width you want to change and hold there for few seconds, Context menu will appear. Select �Resize Column Width� menu to change the width.


When I start Cellica Database (WiFi) Desktop application, I get the messsage "If you are using default windows Firewall on your computer, please add port in Firewall from following path : Control Panel -> Windows Firewall -> Exceptions (Tab) ->Here use "Add Port" button to add port." "If you have custom Firewall then please add the port in your Firewall settings."? Why i am getting this message?

In Cellica Database Wi-Fi version, For proper communication between desktop and device, you should open port 8585 for personal edition and 8787 for Enterprise Edition in Windows Firewall or/and custom Firewall.

If these ports are blocked then software will not able to synchronize data.