Wednesday, December 31, 2008

How to Reset Your Case Numbering for 2009

Some programs reset their case numbering counter every year, so that the first new case of the year will be numbered XXXX00001. If you're one of those programs, here's a reminder on how to do the reset.

* Log into your preferred database administration software (often this is phpMyAdmin.)

* Select your Pika database from the menu of
databases on the server.

* Click on the tab labeled "SQL".

* Paste the following SQL code into the form:

UPDATE counters SET count='0' WHERE id='case_number'

* Click the "Go" button.

That's it! Give us a call if you run into any problems, (888) 321-7452 x0. Happy New Year!

Pika CMS 4.0 Demo Site is Online

The demo site for 4.0 is online at Let me know if you need the password. Enjoy!

Wednesday, December 10, 2008

Pika CMS 4.00 Released

Greetings Pika Community,

I am pleased to announce the immediate availability of Pika CMS 4.00 for general release. Those of you with Pika subscriptions can download the software from:

Here is a brief list of the new features added for this release (a
more complete listing is available in changelog.txt included in the release).
  • New customizable HTML Template libraries for developers
  • Case Documents are now stored in the database
  • Document Storage now supports folders
  • Form Letters can now be managed from System Settings
  • RSS feeds for your Case Lists and Calendar appointments
  • Form validation on Case Tabs to prevent data loss
  • Red Flags can now be managed from System Settings
  • Time entry screens and Activity screens have been re-written
  • amworley account has been renamed to pikasupport
For a more complete list of changes please refer to the changelog.txt included in the release.

These updates were funded by the subscription dues paid by Pika
clients. Thank you for your continued support!

Please give us a call if there's something you'd like to see in the
next version. We're already working on several new projects. They include:
  • Batch Form Letter report
  • Saveable reports
  • Helpdoc Manager
  • Survey Module
  • Menu and Special Table Editor
  • Calendar updates

Wednesday, December 3, 2008

Comments Are Now Enabled

I have enabled comments on blog entries, per a reader suggestion. We'll see how it goes - please play nice. Comment away!

Tuesday, December 2, 2008

Pika 4.0 Sighting

Pika 4.0 will be out by next week. Matt is working on some new sample form letters, and I am touching up the new graphics. We also have one more round of quality assurance testing to run, and then it'll be ready to roll. Here's list of some of the exciting changes it will introduce:

  • New form letters listing
  • Ability to upload form letters from Pika
  • Document storage folders
  • Documents now stored in database, making db replication possible
  • Red flag editor
  • Save confirmation popup
  • New graphics

More information to follow... stay tuned!