OfficeClip Forums

OfficeClip Blog
Discussions on OfficeClip Products and Services

Get the most from OfficeClip: Login from your mobile!

by Admin 6. October 2008 12:10

This is a really handy feature of OfficeClip. Log in to OfficeClip from your mobile phone and access all your contacts, notes, tasks, appointments, etc. from anywhere you happen to be! This allows you to be even more flexible because you don't need to be on a computer. You could be in a taxi, on a train or having a coffee and be able to get all your OfficeClip information, such as Contacts, easily from your phone.

OfficeClip was created using the Microsoft .Net framework®, giving it flexible configuration and implementation on numerous web client devices, such as web browsers, Palm® devices, and web-enabled mobile phones. To access your OfficeClip contacts from your Web Contact Manager, and other applications, simply visit to login to your OfficeClip account. Couldn't be easier!!

Another great feature of OfficeClip is the ability to send SMS messages. Within every member's information, there is a place to add a mobile number and then you can manage the SMS. This gives you the ability to either disable the SMS entirely or to specify what type of SMS messaging you would like to receive. To send an SMS to someone, just click the link beside their mobile number. Remind a team member about a meeting, send an update on a web timesheet report or share information about an account in Web Contact Manager  all from within OfficeClip! This is a an easy, efficient and very quick way to communicate with your colleagues, whether they are in the office, out to lunch or traveling for work.

If you enjoy these features, or have questions, we encourage you to leave comments for us and for other readers!

Tags: , , , , ,

OfficeClip Tips | OfficeClip Products

Timesheet Rules Enhancement

by Admin 3. July 2008 18:07

We’ve been able to add some functionality to the Timesheet Rules feature. This enables you to automate certain communication (or actions) based on the values of a submitted timesheet. For example, if your company’s policy states that certain departments/employees must submit a minimum of hours worked, then this feature will automate the notification of when/if a particular user fails to meet the requirements. Therefore, both employee and manager can be a little more efficient in the submit and approve pieces of the time tracking workflow.

Here’s a quick guide to setting up rules through the Timesheet Admin console:

1. Add a condition to the rule (also, you can set the order of the conditions to set the appropriate precedence)

2. Select the action which you would like to occur, once a submitted timesheet has met the condition(s) of the rule.

3. Name the Rule, so that you will be able to easily identify it from the Rule List view.


Timesheet Rule

Tags: , , ,

OfficeClip Products | OfficeClip Tips

Issue Tracker Escalation Rules

by Admin 3. July 2008 18:07

Issues are often entered in the system and forgotten. OfficeClip Web Issue Tracker Escalation Rules allows administrators to decide what to do when a critical issue is not attended for a predetermined amount of time. These rules are defined in Condition – Action format. For example, a rule can be set such that if an issue is open and critical and not worked on for a period of two days then an action is triggered. Actions can be set for sending email, changing the value of a field or even sending SMS messages. This feature can be accessed from the Rules Menu of the Issue Tracker Admin screen.

Issue Tracker Escalation








OfficeClip Tips | OfficeClip Products

Sql Server Express Incremental Backup and Log Shipping

by Admin 3. July 2008 18:07

Many of our customers (with installed version of OfficeClip Suite) were asking us how to take backup of the database and how to avoid data loss if the server died. Most of our users run OfficeClip on Sql Express database and Microsoft does not provide Log Shipping for the Sql Server Express Edition.

So we decided to write a command line interface which would manage incremental backup and restore for our customer. Anticipating that this would be a useful solution for many other sql express users, we decided to make the source available free. Here are some of the features:

  1.  Full backup is taken every day (regardless of how often the program is run)
  2. Incremental backup is taken periodically (say 10 minutes) when the program is run
  3. It can keep the past backup history for a certain number of days
  4. Log file is created in HTML format so it is easy to read
  5. Backup can be restored using a single command that first restores the most recent full backup and then restores all the incremental backups in the correct order
  6. It is possible to use the Windows Scheduler and run the program periodically and save the files to a destination machine and restore periodically thereby simulating log shipping
  7. It can be run from a command prompt



  1. Before running this program on a database, you must change the database to “Full Recovery Mode” from the Sql Server Express Management Studio.
  2. For restoring the backups make sure that the sql server user name and permission should match in both database.
  3. The program is released under BSD License, so that you can also use it commercially without paying any royalities whatsoever.
  4. It is written in C# using .net framework 2.0 in visual studio 2005 but should run on any 2008 editions.
  5. If you are an OfficeClip customer, the same program is available in the distribution and it is called ocbackup.exe.

Download: Source Code | Executables Only


To see all the options, run the program: OfficeClip.OpenSource.LogShipping.exe (from the LogShipping\bin\debug folder)


The following command takes transactional backup every time it is run, takes full backup every day, keeps old backup for 7 days for the database called officeclip. The backup files are stored in the folder E:SqlBackups. It can be run every 10 minutes using the windows scheduler.

 OfficeClip.OpenSource.LogShipping -bd 7 -c backup -d officeclip -f “E:\SqlBackups” -s “Server=(local);Database=Master;Trusted_Connection=True”

The following command restores the backup to the database called officeclipR. The files are read from the folder E:SqlBackups.

 OfficeClip.OpenSource.LogShipping -bd 7 -c backup -d officeclipR -f “E:\SqlBackups” -s “Server=(local);Database=Master;Trusted_Connection=True”

License: BSD License

If you download and end up using this code, please leave a note. We would like to know who is using this code.

Tags: , ,

Developer Resources | OfficeClip Tips

Field-based Access Rules for Contact Manager

by Admin 29. June 2008 18:06

Based on our users feedback we have implemented a field-based access permission for our Web Contact Manager. This allows administrators to provide read, write, delete or append access to a role based on the value of a contact field. For example, if you want to restrict members of Georgia Team only to see the contacts who are in the State of Georgia, you can program this rule in the contact manager at organization level.


OfficeClip Contact Manager has many levels of security; the list below provides a recap of all security levels that can be set for contacts:

  1. Organization Level Permission: Allows administrator to set default permission for all contacts in the organization. For example, an administrator can set the system such that only administrators can see all contacts and the contact creator can see only his/her contact.
  2. Role Level Privileges: Administrators can create roles and provide privilege for the role users.
  3. Role Level Object Permission: Allows creator or administrators to restrict a group of contacts accessible to only a particular role.
  4. User Level Object Permission: Allows creator or administrators to restrict a group of contacts accessible to only a particular user.
  5. Field-based Object Permission: Rules can be defined in the system so that when a contact is added or edited, permission is controlled based on the value of a field.


OfficeClip Tips

Powered by BlogEngine.NET