Cellica Database(Wi-Fi) Forms
Download & install desktop software on windows based PC from the following link.http://www.cellica.com/DownloadforWiFi.html
What our clients says: http://www.cellica.com/Testimonials.html
Features:
• No changes require in existing database design for syncing directly with database, which helps it be the easiest, most user-friendly solution available.
• View and update data on device, which will reflect to Server database immediately while in network.
• Supports offline access to data and Changes will be synchronized later once network is available.
• Synchronize Table/View or Stored Procedure of your database.
• Only the changed data is synchronized in compressed and encrypted format, resulting in reduced wireless data traffic and improves battery life of the devices.
• “Change Detection Logic” searches only updated data in desktop database and send it to device. Also Sync Server receives and synchronizes records collected/updated on device to desktop database.
• No record or size limit. It depends on space available on device’s internal memory(/SD card).
• Use SQL Select queries, Filters and Sorts to refine specific data set.
• Supported Databases: Microsoft Access(*.mdb,*.accdb)(97 and onwards), Microsoft Excel(*.xls,*.xlsx)(97 & onwards), Oracle, SQLServer, DB2, MySQL, PostgreSQL, FoxPro, dBase, R:BASE,Sybase, FileMaker Pro, Firebird & any ODBC Compliant Relational Database.
• Password protection for Profiles/Forms(SOHO/Enterprise Edition) & Application.
• Make a phone call for the selected field's numeric contents.
• Find and Find again option to search a record.
• Data is secured as 128 bit AES use for Encryption.
• Support Unicode language database such as Japanese/Chinese/German/ Russian etc.
• Transfer data to SD Card or Main memory.
• Supports Multi Record and Single Record View as default views for Database Profile on device.
• Supports Form: Design Custom user interface using simple and easy to use form builder interface.
• Design form on desktop with Label, TextBox, Button, Checkbox, Radio button, Combobox, DateTime, Page, Container, Location and Shape controls.
• Design a master/detail form or a parent/child form using subform control.
• Synchronize Image/Signature/PDF data with desktop database.
• Supports Time/Stamp feature to find when user update particular record.
• Supports Barcode Scan using inbuilt camera/External Bluetooth Barcode Scanner.
• Use Print functionality on forms.
• Create form in Portrait/Landscape mode
Extra Features for SOHO/Enterprise Edition
• Set permissions for each users like Add/Edit/Delete records for each “Database Profile” and Sync Permissions to specify one way sync or both way sync to Control device side records updates capabilities for individual users.
• NFC Scan.
• Macro Programming feature.
• Graphs(Pie, Bar,Cluster,Stack,Area,Line).
User Guide:http://www.cellica.com/AndroidCellicaDatabaseWiFiUserGuide.pdf
Device side is free to download. User needs to purchase desktop software after 10 days evaluation period. Cost of desktop software is $39.99Purchase the full version software from the following link.http://www.cellica.com/WiFi.html
Quick steps for initial synchronization setting between desktop and device.http://www.cellica.com/CellicaDatabase_Desktop_Android_SyncSettings.pdf
If you are using Firewall on your computer,please add port in Firewall from following path.
Control Panel-> Windows Firewall-> Exceptions(Tab)-> Here use "Add Port" button,you will get "Add a port" dialog.
Add whatever name you want to give this port information in "Name" Text field and Add "8585" in "Port number" text box. Please confirm that "TCP" option is selected.
Category : Business
Reviews (20)
I've been using Cellica database for six years now and I can't recommend it enough. I have changed devices a number of times during that time and it has worked well across them all. Cellica Customer Services (which I've only had to contact when switching devices) have always been prompt, competent and courteous in all their responses. This is a quality business grade database form with reliable professional backup to match.
Have been using this app for a few years now and find it useful. Tech support has always been excellent.
dont bother I have had this program for a few years and have had NOTHING but problems with it.
Brilliant, the best DB App on the web, used it for many years.
Some database savvy is prerequisite, and there is a bit of a learning curve concerning settings, use of the form designer, etc. But short of writing your own code, it is hard to imagine a more flexible mobile database tool that allows you to work productively away from any signal and just synchronize periodically. Also, the support staff is very responsive, and the instructional videos are useful. Finally, I appreciate the low cost for the individual version. I'm already thinking of the enterprise version.
The people have the only true, easy to use sql database sync for android. If you run into trouble with system crashes like I did, they're right there with quick effective support. Really a class team & product. I have the WiFi version.
This program is not for me.
Good idea but on my Motorola Milestone X2 it puts duplicates in my database. However it could be the operator. Lol
App is good. Much better than handbase for Android. It's registered to a specific device, so forms are created for that resolution and in landscape OR portrait. They don't flip perfectly. Scrolling is from palm pilot era. App auto dials from phone fields, maps addresses and uses GPS, extensive field sorting, take photos directly from app to your database etc, etc. Background services are idle by choosing manual updates. It's an enterprise level app, not a toy. Customer service is ok but could be better.
2/17/13: Is a great app but has a service that runs ALL the time, eats 2% of phone battery even when I am never using app!! What if every app did this?? No option not to run service if not using app! STUPID. Enterprise version might need always-on service for keeping all users in sync but single user version does not need to waste battery against user wishes. Will change review when Crllica makes smarter app.
I have been looking for a long time to find an App that would synchronize seamlessly with Access databases. This suits the bill. Can even use password protected databases. What I like about it is that the Cellica desktop program does not need to be running in order to synchronize with your Access database. You can synchronize on demand from your phone. Nice. I have been using HandBase and this App is so much better & polished. The desktop program is a bit pricy but if it works well it is worth it. There are a few things I would like to see improved such as 1) smoother scrolling 2) option to display passwords as you type and 3) enter password only when opening database (for password protected databases. This App is close to a 5. I 'll use it some more and maybe update my review
The form editor works ok but needs heaps of refinement to make it useful on the latest devices. Data syncs very well
Does this app need dial out access to my phone? Uninstalling until I get a good answer.
Bought this software only to find out it is a mediocre application. They should put it back in Beta. The fields do not adjust when you use it in the landscape mode. The fields are too limited in size and will not allow the text to wrap. The real kicker was when it stopped syncing. I got shuffle back and forth between several tech support folks and then suddenly dropped. Don't waste your money here. My suggestion, go to HanDBase. At least it works and the fields are not as limited.
I created profiles for and synced 6 databases (MS Access and MS Excel) to my tablet in a matter of minutes. The syncing works perfectly and is very fast (one of the databases is over 50,000 records - it was very fast). The form editing program needs some work - the editor has a fixed window size despite more real estate being available. This makes it more difficult to create tablet-sized forms. Otherwise, very impressed so far.
Takes too long to understand. No phone support for a $40 app??? Shame! GUI is an eye soar. Completely useless without several hours of trial & error.
Asks for desktop's IP and port. IP is fine but port isnt something that is very clearly defined in any instructions. The default value of 8585 doesnt seem to work. Please help... The non-WiFi version though works like a charm and the only reason im looking to use the WiFi version is for instant sync. Three stars till helped.
Good app. But register IMEI and need constant internet to use. USD 800 for enterprise edition is way too much. Customer service is good on the beginning and then they start to ignore. Change this issues and we might consider again.
in your case Support grows from “SUPPPPPPER” !!! I suggest change the name to “Super Support Team! It works, now I am able to make time studies for example for the garment industry in India or all around the world and update my database in the office.Very good. Super. Now the company owner can start working with real operation time for example in the cutting area much much earlier. Again thanks a lot.
Very disappointed. I don't see any design options in the Android version. It keeps asking me if I installed the desktop version. When I go to the website to download the desktop version, I keep getting a Captcha error. Tried several times, but still won't work. Can't finish evaluation for my homeowner's association.