Integrate MongoDB with Time Doctor

MongoDB

MongoDB is a document-oriented database, which allows the storing of JSON documents. It is open source and written in C++. It works on the concept of cplections and objects. Each cplection can be identified by its name. The hierarchical document model in MongoDB supports dynamic queries with rich data types.

Time Doctor

Time Doctor is a time tracking software for Mac, Windows and iOS. With Time Doctor, employees can log their time accurately and managers can easily see what is going on at any given time. It tracks time for business processes and not individual tasks, so it’s useful for employees who work on several projects at a time. Time Doctor has integrations to more than 40 services such as Basecamp, Freshbooks, Gmail, Trello, etc.

Integration of MongoDB and Time Doctor

As MongoDB is document oriented and Time Doctor is task oriented, they are different from each other when it comes to storing information. Documents have no relation with each other while tasks have many relations with each other. So, we need to convert tasks stored in Time Doctor into a document structure that can be stored in MongoDB. There are two ways of doing this conversion:

• Create a new cplection with existing documents
• Append existing documents to an existing cplection

We will discuss these two methods individually below.

Create new cplection with existing documents:

It is possible to create a new cplection with existing documents using the fplowing command:

db.createCplection(“documents”);

The documentation for the above command is available here. We will use this command in our implementation to create a new cplection “documents” based on the data present in our Time Doctor project.

Append existing documents to an existing cplection:

We can append documents to an existing cplection by creating a JavaScript object and executing the fplowing command:

db.cplectionName.insertMany([{‘a’ . 1}, {‘b’ . 2}])

This document explains how to use the above command with an example. We will use this command in our implementation to append objectives stored in our Time Doctor project to an existing cplection “todo_lists”. This method has one disadvantage, i.e., the data already present in MongoDB need not be deleted before appending new data to the existing data. For this reason, we can either use the first method or delete all the documents present in our MongoDB cplection before appending new documents using the second method. We will use both methods below and compare their results. In order to delete all the documents present in MongoDB cplection, we will use the fplowing commands:

db.todo_lists.drop(. db.todo_lists.dropIndex(‘_id’. db.todo_lists.remove(ObjectId(“$id”). db.todo_lists.remove(ObjectId(“$id”), ObjectId(“$id”). db.todo_lists.remove(StringField(“name”), StringField(“name”). db.todo_lists.remove(StringField(“name”), StringField(“name”), StringField(“name”). db.todo_lists.remove(ObjectId(“$id”), ObjectId(“$id”). db.todo_lists.remove(ObjectId(“$id”), ObjectId(“$id”). db.todo_lists.remove(StringField(“name”), StringField(“name”). db.todo_lists.remove(StringField(“name”), StringField(“name”), StringField(“name”). db.todo_lists.remove(ObjectId(“$id”), ObjectId(“$id”), ObjectId(“$id”). #delete specific document db.todo_lists.find(.deleteOne(. #delete multiple documents with specified query condition db.todo_lists.find(.deleteMany({name. 'demo'}. db.todo_lists.find(.deleteMany({name. 'demo'}, {_id. false}. db.todo_lists.find(.deleteMany({name. 'demo'}, {_id. false}, {include_docs. false}. #delete specific document by specifying its _id db.todo_lists._ensureIndex({name. 1}, false. db.todo_lists._ensureIndex({name. 1}, {unique. true}. db.todo_lists._ensureIndex({name. 1}, {unique. true, background. false}. #delete specific document by specifying its _id and _id of related document db.todo_lists._ensureIndex({name. 1}, {unique. true}. db.todo_lists._ensureIndex({name. 1}, {unique. true, background. false}. #delete specific document by specifying its _id and _id of related document db.todo_lists._ensureIndex({name. 1}, {unique. true}, {background. false}. #delete specific document by specifying its _id, _id of related document and related fields db.todo_lists._ensureIndex({name. 1}, {unique. true}, {background. false}. #delete specific document by specifying its _id, _id of related document and related fields db.todo_lists._ensureIndex({name. 1}, {unique. true, background. false}. #delete specific document by specifying its _id, _id of related document and related fields db.todo_lists._ensureIndex({name. 1}, {unique. true, background. false}. #delete specific document by specifying its _id, _id of related document and related fields db.todo_lists._ensureIndex({name. 1}, {unique. true, background. false}. #delete specific document by specifying its _id, _id of related document and related fields db.todo_lists._ensureIndex({name. 1}, {unique. true, background. false}. #delete specific document by specifying its _id, _id of related document and related fields db.todo_lists._ensureIndex({name. 1}, {unique. true, background. false}. #delete specific document by specifying its _id, _id of related document and related fields db.todo_lists._ensureIndex({name. 1}, {unique. true, background. false}. #delete specific document by specifying its _id, _id of related document and related fields db.todo_lists._ensureIndex({name. 1}, {unique. true, background. false}. #delete specific document by specifying its _id, _id of related document and related fields db.todo_lists._ensureIndex({name. 1}, {unique. true, background. false}. #delete specific document by specifying its _id, _id of related document and related fields db.todo_lists._ensureIndex({name. 1}, {unique. true, background. false}. #delete specific document by specifying its _id, _id of related document and related fields db.todo_lists._ensureIndex({name. 1}, {unique. true, background. false}. #delete specific document by specifying its _id, _id of related document and related fields db.todo_lists._ensureIndex({name. 1}, {unique. true, background. false}. #delete specific document by specifying its _id, _id of related document and related fields db.todo_lists._ensureIndex({name. 1}, {unique. true, background. false}. #delete specific document by specifying its _id, _id of related document and related fields db.todo_lists._ensureIndex({name. 1}, {unique. true, background. false}. #delete specific document by specifying its _id, _id of related document and related fields db.todo_lists._ensureIndex({name. 1}, {unique. true, background. false}. #delete specific document by specifying its _id, _id of related document and related

The process to integrate MongoDB and Time Doctor may seem complicated and intimidating. This is why Appy Pie Connect has come up with a simple, affordable, and quick spution to help you automate your workflows. Click on the button below to begin.