|
An add-in for Microsoft®
Outlook® that makes it very easy to manage and distribute
centralized projects and tasks to team members and plan and
track the progress, expenses, time and work done on tasks.
|
 |
A collaborative project management and tracking solution
for Microsoft® Outlook®, Team Projects system
enables team members to work, plan on projects and tasks
through Outlook's appointment and task items and allows for
quick reporting of timesheets, expenses and billing, notes
and other intrinsic data to the Team Projects central
database repository. On these real-time data, senior
management can use the Team Projects Manager module to audit
(i.e, accept or decline) the submitted information, quickly
create summary reports or run the integrated OLAP tool for
more advanced statistics and quantified business
intelligence.
With Team Projects Manager module, administrators can
distribute Projects/Tasks and other trackable data fields to
members through Outlook. Team Projects includes a simple
managerial and client install. Email notifications can be
set to trigger automatically on diverse events such as when
reporting, auditing, adding new projects/tasks, assignment
of project manager etc.
Through Microsoft Outlook / Exchange, timesheets are
linked to project data for simplified time reporting,
tracking and improved billing accuracy
Time reporting is simplified- creating and submitting a
time card is as easy as creating an email. Members can
quickly create their timecards with picklists tied to
project and task data, a feature which also improves the
accuracy of project billing.
After a time card is submitted, it is automatically
routed to the appropriate supervisor, eliminating delays in
the approval process. A time card can be approved with the
click of a button, forwarding the card to payroll and
accounting for processing, or sent back to the employee for
revision.
In leveraging the Microsoft Outlook / Exchange platform
for time reporting, TrackerOffice offers an ideal billing
solution for distributed organizations - companies with
multiple locations or employees who travel on a regular
basis. Through their Outlook client, TrackerOffice users can
submit and track their time cards wherever they are located.
Managers can relax knowing their employees are reporting
through a regimented system that promotes accurate,
consistant project time reporting, while executives can
enjoy accurate, up-to-date budget and billing reports.
 |
Microsoft® Office Outlook1
integration |
|
|
Support pre-defined Outlook
fields as well as custom
fields defined for that folder |
|
|
Choose any customized form
defined for that Outlook folder |
|
|
Supports POP, IMAP, Exchange
mailbox and Public folders |
|
|
Exports the contents of the
Outlook folder to a database |
|
|
Optionally include items from the
subfolders in the export, either
to a single table or to separate
table for each subfolder |
|
|
Export all kind of Outlook items –
mails, posts, appointments,
tasks, journals or contacts |
|
|
Supports export of notes (Plain
Body or HTML Body of the
Outlook item, including task,
appointment and contact item). |
|
|
Enumerated values for predefined
Outlook fields are exported as
readable values (e.g., Internal
value for ‘Importance’ field of an
Outlook item can be 0, 1 or 2.
During export to a database, these
values are translated to Normal, Low
and High) |
|
|
No
security warning from Outlook
Unlike other add-ins for Outlook,
Database Exporter is designed to
overcome the security warning that
is usually displayed to the user if
some third party application tries
to access certain email address/body
fields of an Outlook item |
|
|
Real-time monitoring of incoming
emails/new items of an Outlook
folder, and automatically export the
data to a database |
|
|
Unicode
Support |
|
|
Special
MSI installer available for
enterprise wide deployment (upon
request) |
1
Outlook® 2002, 2003, 2007
|
|
Version:
2.0
Released: 22nd April
2010
License:
75 USD
Have any questions?
Email us: support@assistmyteam.net
Download brochure
|
|
|
|
|
|
Purpose of this add-on You have already customized
an Outlook form with your own fields. At some point
of time, you're going to want to put data into it or
get that data out. But it might come as a big
surprise that you cannot use Outlook's
built-in Import and Export wizard to export
data from custom forms. User-defined custom fields are absent on
the data mapping grid in the export wizard. Even
worse, you might not get any built-in Outlook fields
data at all, if
you try to export from items that were created with
custom forms. So, you are
forced to write codes to handle all import/export
chores involving custom forms yourself. What worst
is that, what you wrote works only for that
particular Outlook form that you customized. What if
you have many customized forms?
Database Exporter add-in for Microsoft Outlook is
designed to overcome this limitation (i.e., the
inability of the Outlook's built-in 'Import and
Export Wizard' to handle data in custom forms), by
allowing you to export any kind of data, including
custom fields, to a database, in a simple click, or
even better, on the fly with no intervention from
the user.
How does it work? With Database Exporter, there
are 3 ways of exporting Outlook data to an external
database, namely:
|
Exporting items of an Outlook folder to a
database
To export the contents of an Outlook folder,
click the ‘Export to DB’ button as shown below.
You will be shown with the ‘Select Fields’
dialog, with which you can opt which form to be
used for displaying the available fields.
|
| |
By default, the first option ‘Retrieve from
the first item’ is selected, and what it does
is, to probe the first item of the folder and
automatically seek out all the available fields,
including any number of user defined custom
fields. It is recommended that you stick with
this option of displaying the fields, unless,
you want to retrieve Outlook specific fields
only (second option), or want to use a
particular custom form out of many defined for
that Outlook folder (third option).
 |
| |
|
Exporting items including those in subfolders
By default, when you export the contents of an
Outlook folder using the ‘Export to DB’ button,
only the items of the current folder is taken
into account. Items inside the subfolders (if
any) are excluded from the export. Below are a
few export options available. |
| |
  When
exporting to database, include all items from
subfolders - When you choose to export the
contents of an Outlook folder, enable this
option to include items in subfolders of any
number of levels.
For example, below, the current folder is ‘My
Company’. When exporting this to database, if
you had checked this option, the contents of the
subfolders such as ‘Bookings’, ‘Cases’,
‘Ongoing’, ‘Customers’ etc, will also be
exported to the same database.
 Export
all data from all subfolders to a single table
- Export all the items in the current folder, as
well as those in subfolders in the same/single
table, using this option. With this, the fields
that you had chosen for the current folder will
be applied to all the items in the subfolders as
well.
 Export
data of each subfolder to separate table in same
database - Another option is to export items
in each of the subfolder to a separate table.
This gives more flexibility in configuring the
field options of the subfolders to be exported.
For example, you can set the same chosen fields
as that of the root folder, or use the default
form for that subfolder, or even better, probe
the first item of the subfolder to seek out the
available fields. The latter option comes handy
if you have user defined fields available on the
folder or the item level.
|
| |
|
Automation - Monitor an Outlook folder for live
export to database One major feature introduced in version 2 is the
real-time monitoring of any number of Outlook
folders (can be a public folder or shared
mailbox folder
too). This will automatically process incoming
mails or newly added appointments, tasks or
contact items and add the data for the chosen
fields to the database, without any intervention
from the user. This automation would be
particular useful, if you want to maintain a
parallel copy or backup of your current Outlook
items.
|
| |
Automatic export works by allowing Database
Exporter to monitor selected Outlook folders
(can be a shared or a public folder too), such
that, when new emails are received or new
appointments or tasks are added, Database
Exporter automatically processes those items in
real time and extract relevant data and add them
to a pre-configured database. Each folder would
have exactly one database each.
Automatically update DB record when
Outlook item is updated/changed – If you
enable this option, whenever an existing
Outlook item on a monitored folder is edited and
saved, instantly the changes will also be
reflected in the corresponding record in the
database. This feature enables you to maintain
synchronization between the Outlook items and
the records in the database, on the fly, with no
manual work.
Removing database record on item deletion
from Outlook
If the Outlook folder is monitored for auto
export, a delete button appears in the Database
Exporter toolbar that enables you to delete the
unnecessary Outlook items and at the same time,
remove the corresponding database records
automatically.
Automatic live export enables you to maintain
a parallel copy of the Outlook data and keeps
the database in synchronization with that
particular Outlook folder. This spares you from having to do that laborious
work of copying and pasting the data from
Outlook to database manually. |
| |
|
