Trivedi Solutions
Consulting -> Lotus Notes | Domino | Java
Trivedi Solutions offers premium computer consulting services leveraging Lotus Notes, Domino and Java technologies.
At Trivedi Solutions,
Our clients have ranged from multi-nationals to sole proprietorships.
Here are details about selected projects we have worked on in the past:
Technology Solutions used:
Lotus Notes, Java, CORBA
This client had a large Notes based financial
system that needed to be ported to their Intranet
so it could be accessed on the road by users
via Internet browsers.
Extensive customizing was needed to port the
system to the Intranet. Besides this, the
system presented a unique challenge:
Domino renders Lotus Notes views to the web
by either composing an HTML document or using
a Java applet to display the view. However,
this solution is only appropriate for smaller
databases.
This client had a database with over 250k
records in most views. Asking users to
scroll through the entire view to locate
their documents was not practical. Neither
was using a Database search because it would
offer too many hits per search term to be
a valid method.
Trivedi Solutions programmed a custom Java 2.0
applet to do a lookup based on user input
and present the user with a list of Accounts
matching the input. The applet would then
open up the selected document within a new
browser window.
Technology Solutions used: Lotus Notes/Domino
A client involved in market research needed
a modular Notes-based system that would offer
secure platforms for product discussion amongst
registered users.
Trivedi Solutions delivered a Notes based system
that could deploy databases based on templates
within minutes. Registration modules for these
databases allowed Internet users to register
themselves and authenticate with the servers
unattended. The databases would be housed by
the company in an ASP model, with users accessing
all the features via the Web.
Technology Solutions used: Domino, Adobe Acrobat, Visual Basic, Custom NT Service
This multinational Pharmaceutical company used
a Lotus Notes system to track documents used for
making FDA submissions for new drug applications.
Since this is a very large organization there are
many versions of desktop settings and customizations
(e.g., Word templates) existing throughout the
company. Also, the company used both Macs and PCs
and different Word processing applications (MS Word,
WordPerfect). It was therefore necessary for
the system to freeze the document formatting at
one point in the process to ensure a common format.
The solution decided upon was to incorporate a module
in the Notes application that was able to dynamically
generate PDF copies of any Word or WordPerfect
document within the system. The rendering had to
be instant, on demand and automated behind-the-scenes.
Trivedi Solutions developed a custom VB application
that ran as a native NT Service application on a
server trusted by the Notes server. The service
maintained queues and parameters (priority,
processing inputs, etc.) for the PDF Rendering process.
The service was multi-threaded and could recover
by itself upon failure. The Notes server simply
put in a file on the Rendering Server and picked
up the PDF copy of the file seconds later.
This program was scaleable and was developed while
Adobe itself was working on a similar solution.
Upon release into production it surpassed the needs
of the client, and was so successful that other
departments incorporated this solution within
their systems.
Technology Solutions used: Lotus Notes, DB2 UDB v5.2, Notrix v5.1, ERwin
This client had a Notes based system which tracked
Insurance Policies and associated Medical Providers.
The system had grown too large for the data to be
continued to be hosted in Notes. The performance
had deteriorated so much that the data needed to
be urgently moved from Notes into their Data
Warehouse.
The client wished to continue using Notes as the
UI for the system so as to make the upgrade
transparent to the users and have no need for
retraining.
The Notes documents in the System existed in a
hierarchical model with up to six levels of
Response Documents in a Many-To-Many relationship.
There was some duplication of data between Notes
and the Data Warehouse which the client wanted to
remove.
Trivedi Solutions made Structural and systemic
changes to the Notes data to make it quasi-relational
in nature. After extensive data modeling a set
of DB2 data elements was designed to house the
Notes data. The data was exported into DB2 and
a new module was created to query the Warehouse
data and create Notes documents on the fly upon
user query. The system upgrade was seamless and received very well by the clients.
Technology Solutions used: Lotus Notes/Domino
The clients for this system were top company executives.
Because of their extensive traveling, they had two
or more copies of the same set of files on their laptops
and on various company network drives.
Making sure all the sets were current and maintaining
updates between various datasets was a problem.
The clients felt they needed more than the simple
replication offered by the Windows Briefcase. They
decided to move the files into a custom Lotus Notes System
and use replication to keep the files updated in all locations.
Since they had used the same file folder structure for
years, they wished to port the structure to Notes (up to
nine subdirectories, with files in any or all of them)
Trivedi Solutions designed a Notes system that recreated
the directory structures visually within the Database Views.
The documents were imported as attachments which would
henceforth be tracked via versioning within the Notes
database. Check-in and Check-out functionality was also
provided to maintain security and prevent duplication.
Technology Solutions used: Lotus Notes/Domino, Visual Basic
This multinational pharmaceutical company needed to
update its stock quote prices on the company's Intranet
home page.
The Security and Firewall configurations prevented
a simple HTML redirect to incorporate the data into
the web page. The client needed a custom server-based
CGI program that would fetch the stock price from Yahoo,
parse the HTML tags to find the Stock Price field,
and update the static Intranet page with the data
found.
Trivedi Solutions wrote a Visual Basic program to
successfully meet the clients needs.
Technology Solutions used: Lotus Notes, VBA, OLE
This client had an existing Budgeting System that
incorporated data stored in numerous MS Excel files.
The system had grown to a point that there were
too many files, and no way to easily track the
versions and to ensure that all the latest updates
were incorporated into one set of Budget files.
The Budget files used graphs and many complicated
formulae, so the client wanted to continue using
MS Excel to store the data; but needed a way to
house, track and report on the Budgetary data.
The client also wanted to add some Workflow to
the application and needed to differentiate
data access via security levels.
Trivedi Solutions devised a system that used
embedded Excel spreadsheets within a Notes
application to maintain the information.
Select data from the spreadsheets was displayed
within Notes fields for inspection and
rudimentary calculations (totals etc.) The
application implemented workflow and Access
Control levels and housed an in-built Help
System.
Technology Solutions used: Lotus Notes, Java
A client needed a Notes system NOT using the Notes
Calendar to perform dairy functions. Data for
daily events was kept in an outside text file.
Because the system required numerous date and
time manipulations which the Notes Calendar
object doesn't expose, a new system had to be
developed from scratch.
Trivedi Solutions developed a custom calendaring
application with full features including
resolution of Gregorian dates and Leap Year
calculations, and used it to assign and track
resources. The system offered full-featured
calculation and planning functions with date, time
and resource modules.
Later the system was ported to the web using Java 2.0.
