OfficeClip Forums

OfficeClip Blog
Discussions on OfficeClip Products and Services

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

 

 

 

 

 

 

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

 

      Notes:

  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 vs.net 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

Usage:

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

Examples:

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.

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.

Time Tracking Software

by Admin 9. March 2008 16:03

What is time tracking software? Is it right for my company? Time tracking software provides an easy, efficient way to track the time of employees and managers for projects and tasks. It is also easy to view the time spent on various aspects of the projects as they are happening, allowing for fast adjustments to keep your project moving towards completion without wasting valuable time and money.


How will my business use Time Tracking Software?


Timesheet software
greatly reduces administrative tasks within your organization because all communication is centralized through the same application. This saves massive amounts of paper and also saves time; you don’t have to chase team members and remind them to complete and submit their timesheets. Employees and managers alike will find online timesheets easy to use and helpful and we have discussed how this works for each below:

Used by Employees – If you are worried about your employees resisting the idea of using time tracking software , don’t! It is an opportunity for employees to keep track of what projects they are working on and where their hours are being spent. This gives them a complete record of their productivity on all their projects.

Used by Managers – Managers will also find online timesheet software to be extremely beneficial for many reasons. They will be able to have their employees timesheets automatically routed to them for approval and they can set up rules to help eliminate mistakes and errors for employees entering time. This will save hours and money for the company. Timesheet software can be integrated for the easy transfer of data to and from applications like MS Excel, QuickBooks, Peachtree, etc.

Although change can be difficult, time tracking software are definitely a change for the better for your company and for your employees. The ability to effectively track resources and allocate them to projects in real time will result in increased profitability, reduced costs and better overall organization and productivity among employees.

 
Spend a couple of minutes to browse through the Screen shot tour of Online Timesheet and Expense.




Description of Time Tracking Software

 

How does Time Tracking Software Work?

Time Tracking software easily and effectively tracks the time of your employees anytime, anywhere. Because it is accessed via a web browser, it is perfect for employees who travel, work from home or just need flexibility in accessing and using their timesheets.

  • Multi Tasking – User friendly software that can be used by multiple people and can track multiple clients and projects.

  • Member Management – Managers can set hour and expense rules and/or warnings to employees to better manage things like overtime,travel expenses, etc.

  • Customization – Your employees can allocate and track things like vacation, jury duty, maternity leave, etc. accurately, eliminating many hassles.

  • Cost Control and Profits – You can generate timesheet and management reports to study utilization levels, costs incurred and the profitability achieved from each and every project. The Return on Investment on the timesheet software can be measured in number of months.

  • Security- Timesheet software offers you multiple levels of security so that managers, consultants, assistants, etc. can have various levels of access to information and data. It is also supports DCAA compliance for tracking history, creating audits and logs.


Comparison table for various editions of the Web Timesheet and Expense software provides users flexibility to choose the edition that is suited for them.

Various editions of the Online Timesheet Software is available. Hosted timesheet software can be purchased for as little as $10 a month and can be fully downloaded for around $80 per user. Once your business begins using timesheet software, you should find increased productivity, communication and efficiency as well as reduced costs, better organization and improved ability to effectively manage projects and resources.

More information on the OfficeClip Web Timesheet and Expense software is available at the OfficeClip website.

Online Timesheets

by Admin 9. December 2007 16:12
Online timesheet is a powerful tool you can use to effectively allocate resources to a project and continue to track them through the life of the project. It is also easy to view the time spent on various aspects of the projects as they are happening, allowing for fast adjustments to keep your project moving towards completion without wasting valuable time and money.

Features of Online Timesheets

 

Online timesheets have many features that make them so beneficial to organizations and a few of them are listed below:

  • Multi Tasking – User friendly software that can be used by multiple people and can track multiple clients and projects.

  • Member Management – Managers can set hour and expense rules and/or warnings to employees to better manage things like overtime, travel expenses, etc.

  • Customization – Your employees can allocate and track things like vacation, jury duty, maternity leave, etc. accurately, eliminating many hassles.

  • Cost Control and Profits – You can generate timesheet and management reports to study utilization levels, costs incurred and the profitability achieved from each and every project. The Return on Investment on the timesheet software can be measured in number of months.

  • Security- Timesheet software offers you multiple levels of security so that managers, consultants, assistants, etc. can have various levels of access to information and data. It is also supports DCAA compliance for tracking history, creating audits and logs.

Online Timesheet Software is extremely affordable; hosted timesheet software can be purchased for as little as $10 a month and can be fully downloaded for around $80 per user. Once your business begins using timesheet software, you should find increased productivity, communication and efficiency as well as reduced costs, better organization and improved ability to effectively manage projects and resources.

 
More information on the OfficeClip Web Timesheet and Expense software is available at the OfficeClip website.
 
Spend a couple of minutes to browse through the Screen shot tour of Online Timesheet and Expense.

Learn about Online Timesheets

Using Online Timesheets in Your Business

 

Timesheet software greatly reduces administrative tasks within your organization because all communication is centralized through the same application. This saves massive amounts of paper and also saves time; you don’t have to chase team members and remind them to complete and submit their timesheets. Employees and managers alike will find online timesheets easy to use and helpful and we have discussed how this works for each below:

Used by Employees – If you are worried about your employees resisting the idea of using time tracking software , don’t! It is an opportunity for employees to keep track of what projects they are working on and where their hours are being spent. This gives them a complete record of their productivity on all their projects.

Used by Managers – Managers will also find online timesheet software to be extremely beneficial for many reasons. They will be able to have their employees timesheets automatically routed to them for approval and they can set up rules to help eliminate mistakes and errors for employees entering time. This will save hours and money for the company. Timesheet software can be integrated for the easy transfer of data to and from applications like MS Excel, QuickBooks, Peachtree, etc.

 

Online Timesheet software can make your company more productive by accurately track time spent on various projects. This enables reduced costs and better overall organization and productivity among employees.

Timesheet Software

by Admin 9. July 2007 16:07

What is timesheet software? Is it right for my company? Timesheets provide an easy, efficient way to track the time of employees and managers for projects and tasks. It is also easy to view the time spent on various aspects of the projects as they are happening, allowing for fast adjustments to keep your project moving towards completion without wasting valuable time and money.


What does Timesheet software do?

Timesheet software easily and effectively tracks the time of your employees anytime, anywhere. Because it is accessed via a web browser, it is perfect for employees who travel, work from home or just need flexibility in accessing and using their timesheets. Online Timesheet and Expense software is implemented so that it can be used with a platform independent web browser with a powerful backend sql database. It also has flexible reporting options.

  • Multi Tasking – User friendly software that can be used by multiple people and can track multiple clients and projects.

  • Member Management – Managers can set hour and expense rules and/or warnings to employees to better manage things like overtime, travel expenses, etc.

  • Customization – Your employees can allocate and track things like vacation, jury duty, maternity leave, etc. accurately, eliminating many hassles.

  • Cost Control and Profits – You can generate timesheet and management reports to study utilization levels, costs incurred and the profitability achieved from each and every project. The Return on Investment on the timesheet software can be measured in number of months.

  • Security- Timesheet software offers you multiple levels of security so that managers, consultants, assistants, etc. can have various levels of access to information and data. It is also supports DCAA compliance for tracking history, creating audits and

Various editions of the Online Timesheet Software is available. Hosted timesheet software can be purchased for as little as $10 a month and can be fully downloaded for around $80 per user. Once your business begins using timesheet software, you should find increased productivity, communication and efficiency as well as reduced costs, better organization and improved ability to effectively manage projects and resources.


 Download Web-based Time Tracker and try it free for 30 days.

 

Spend a couple of minutes to browse through the Screen shot tour of Online Timesheet and Expense.

How to use Timesheet Software


How will Timesheet software improve my company?

Timesheet software greatly reduces administrative tasks within your organization because all communication is centralized through the same application. This saves massive amounts of paper and also saves time; you don’t have to chase team members and remind them to complete and submit their timesheets. Employees and managers alike will find online timesheets easy to use and helpful and we have discussed how this works for each below:

  • Used by Employees – If you are worried about your employees resisting the idea of using time tracking software, don’t! It is an opportunity for employees to keep track of what projects they are working on and where their hours are being spent. This gives them a complete record of their productivity on all their projects.
  • Used by Managers – Managers will also find online timesheet software to be extremely beneficial for many reasons. They will be able to have their employees timesheets automatically routed to them for approval and they can set up rules to help eliminate mistakes and errors for employees entering time. This will save hours and money for the company. Timesheet software can be integrated for the easy transfer of data to and from applications like MS Excel, QuickBooks, Peachtree, etc.

Although change can be difficult, timesheet software are definitely a change for the better for your company and for your employees. The ability to effectively track resources and allocate them to projects in real time will result in increased profitability, reduced costs and better overall organization and productivity among employees. 

More information on the OfficeClip Web Timesheet and Expense software is available at the OfficeClip website.

Powered by BlogEngine.NET