With synthetic intelligence taking deep roots round our lives and making it simpler for us to do numerous issues, an increasing number of software program builders, IT firms and start-ups are in search of methods to combine state-of-the-art AI know-how into their merchandise to get the leap over their rivals.
Many fashionable CRM platforms, electronic mail purchasers, private assistants, video editors, mission administration applications and different kinds of software program instruments now come outfitted with AI assistants permitting their customers to work quicker and be extra productive.
Workplace software program is just not an exception. The thought of integrating synthetic intelligence into digital doc workflows has been successful the minds of workplace software program builders over the previous few years and now there are a number of attention-grabbing integration examples that considerably change the best way folks work with workplace recordsdata.
On this article, we are going to check out essentially the most profitable examples of symbiosis between synthetic intelligence and workplace software program, and study the method of integrating an AI assistant into an workplace bundle by the instance of ONLYOFFICE Docs, an open-source workplace suite.
AI and workplace software program: greatest integration examples
The market of workplace software program is very aggressive, and it’s an evident incontrovertible fact that the largest firms all the time have a bonus over different gamers. Nonetheless, even small firms and impartial builders can provide you with elegant options bringing the ability of synthetic intelligence into the universe of doc modifying and collaboration.
Here’s a fast overview of among the hottest workplace packages with built-in AI assistants out there available on the market:
- Microsoft 365. The Redmond big introduced its personal AI instrument often known as Copilot in March 2023. It combines the ability of huge language fashions (LLMs) and makes it simpler for customers to work with the Microsoft 365 apps, together with Groups, Outlook and Edge. Copilot is deeply built-in into the Microsoft ecosystem and lets you write and edit textual content content material in Phrase, analyze tendencies and create complete knowledge visualizations in Excel, and create spectacular displays primarily based in your prompts in PowerPoint. Copilot for Microsoft 365 is on the market with a paid subscription.
- WPS Workplace. Microsoft Workplace’s competitor from China, WPS Workplace, has an AI assistant known as WPS AI. It’s a generative AI instrument that permits customers to generate textual content content material, summarize massive paperwork, analyze knowledge, extract outlines from PDFs and create assembly drafts. WPS AI can be utilized in textual content paperwork and PDF recordsdata and affords a free trial with a restricted set of options. To entry its full performance, it is advisable to buy one of many paid variations.
- Google Workspace. The Google company has an AI-powered assistant for its productiveness apps known as Gemini. This instrument is constructed into Docs, Sheets and Slides permitting you to write down varied sorts of content material and generate pictures in textual content paperwork, create tables and formulation in spreadsheets, and generate new slides with pictures and content material in displays. Gemini for Google Workspace is on the market as a paid add-on. Apparently, the Google Workspace Market additionally affords totally different AI assistants developed by third-party builders for Docs, Sheets and Slides however it’s best to strive them at your personal threat.
- Zoho WorkDrive. This on-line content material collaboration platform and storage has an IA integration function known as Zia. It’s an AI-based writing assistant out there in some Zoho merchandise, together with Zoho Author. Utilizing Zia, you may test your content material for spelling and grammar errors and enhance its readability. The primary goal of this instrument is that can assist you write concisely and clearly. Zia can also generate new content material and pictures. It’s not out there without spending a dime.
Taking every part into consideration, the next conclusion appears evident: the preferred workplace suites present wonderful AI integration choices however nearly all of them are paid.
Now let’s discover the case of ONLYOFFICE Docs, an open-source workplace bundle, that gives strong AI capabilities primarily based on ChatGPT and uncover how this integration works.
ONLYOFFICE Docs and AI: a short overview
ONLYOFFICE Docs is an open-source and free workplace suite for textual content paperwork, spreadsheets, displays, fillable types and PDF recordsdata. The suite has a self-hosted model for native deployment and a cloud-based model for a fast begin. There may be additionally a desktop consumer for Linux, Home windows and macOS and cellular apps for Android and iOS. The supply code of the ONLYOFFICE suite is on the market on GitHub.
ONLYOFFICE Docs has an open API, which makes it attainable to combine the editors with third-party providers. Such integrations work by way of plugins, particular add-ons that convey new capabilities and options. Amongst dozens of ready-to-use plugins for the ONLYOFFICE suite, you could find people who allow the ability of synthetic intelligence. Extra exactly, these are the plugins for ChatGPT and Zhipu Copilot.
Each ChatGPT and Zhipu Copilot are accessible within the ONLYOFFICE editor’s interface by way of separate plugins that may be put in and deleted with a couple of clicks by way of the Plugin Supervisor. These plugins are formally developed and maintained by the ONLYOFFICE crew. As all different plugins, they’re out there without spending a dime.
To make these plugins work, it is advisable to specify an API key offered by the corresponding platform. Relating to ChatGPT, you could find a sound API key within the settings of your OpenAI account.
Once you enter a sound API key within the ChatGPT plugin and allow it by way of the Plugins tab, you’ll have entry to the next options by way of the context menu, which makes it simpler to work with texts*:
- Era of textual content content material primarily based in your prompts;
- Creation of pictures in several resolutions;
- Translation to a number of languages, together with English, Spanish, Italian, Chinese language, German, French, and many others.;
- Phrase evaluation;
- Extraction of key phrases;
- Textual content summarization;
- Textual content manipulation;
- Correction of spelling and grammar errors;
- Communication with the chatbot.
The Zhipu Copilot plugin offers related writing help options in ONLYOFFICE Docs and is designed for Chinese language-speaking customers as a result of it’s primarily based on a localized data base.
In ONLYOFFICE Docs, you may work together with the ChatGPT service not solely in textual content paperwork but in addition in spreadsheets and displays, so you may carry out varied duties corresponding to knowledge evaluation and discovering info in your slides.
Now that you recognize what ChatGPT and Zhipu copilot can do for you if you work on workplace recordsdata, let’s take a deeper have a look at the ChatGPT plugin to see the way it works and what key components its supply code contains.
Word: the ONLYOFFICE builders assume no duty for the accuracy or reliability of the knowledge offered by ChatGPT and ZhiPu Copilot.
Construction of the ChatGPT plugin
The ChatGPT plugin consists of 5 directories, with the HTML recordsdata saved individually within the root listing. Here’s a fast overview of every file with code samples:
1. index.html: Because the plugin operates as a background plugin, it doesn’t require a person interface. The index.html file references all of the scripts, code recordsdata, and stylesheets, guaranteeing they’re utilized when the plugin is activated.
<head>
<meta charset="UTF-8" />
<title>OpenAI</title>
<script kind="textual content/javascript" src="https://onlyoffice.github.io/sdkjs-plugins/v1/plugins.js"></script>
<script kind="textual content/javascript" src="https://onlyoffice.github.io/sdkjs-plugins/v1/plugins-ui.js"></script>
<hyperlink rel="stylesheet" href="https://onlyoffice.github.io/sdkjs-plugins/v1/plugins.css">
<script kind="textual content/javascript" src="https://www.sitepoint.com/artificial-intelligence-into-office-software-with-onlyoffice-docs/scripts/desktop.js"></script>
<script kind="textual content/javascript">
if (!/MSIE d|Trident.*rv:/.check(navigator.userAgent)) {
doc.write("<script kind="textual content/javascript" src="https://www.sitepoint.com/artificial-intelligence-into-office-software-with-onlyoffice-docs/vendor/GPT-3-Encoder/encoder.js"></script>");
doc.write("<script kind="textual content/javascript" src="https://www.sitepoint.com/artificial-intelligence-into-office-software-with-onlyoffice-docs/scripts/code.js"></script>");
} else {
doc.write("<script kind="textual content/javascript" src="https://www.sitepoint.com/artificial-intelligence-into-office-software-with-onlyoffice-docs/scripts/code_ie.js"></script>");
}
</script>
</head>
Code contained in the <head> tag of index.html file
2. chat.html: This file defines the HTML construction for the chatbox that seems when you choose the chat possibility within the ChatGPT plugin.
3. Different HTML recordsdata: The foundation listing accommodates extra HTML recordsdata for varied error messages and logs. These recordsdata are designed to deal with situations corresponding to inadequate tokens or invalid requests, to ensure the plugin responds appropriately to totally different situations.
Overview of the assets listing
The assets listing primarily includes two elements: CSS kinds and pictures for various modes.
1. CSS Sub-directory: This accommodates kinds.css and customized.css. Each stylesheets apply CSS to numerous elements all through the plugin.
2. Picture Directories: The second part contains the next:
- mild accommodates pictures optimized for light-themed editors;
- darkish accommodates pictures optimized for dark-themed editors;
- icons contains icons in varied side ratios and sizes for various show settings and themes.
These above-mentioned assets be sure that the ChatGPT plugin capabilities properly throughout totally different editor themes and resolutions.
Overview of the scripts listing
The code.js file accommodates the core logic for the plugin that integrates varied functionalities powered by the OpenAI API. Let’s undergo this file in additional element:
1. Initialization and Setup:
- The plugin initializes variables, together with an API key, mannequin settings, and UI components.
- The checkApiKey technique retrieves the OpenAI API key from native storage.
operate checkApiKey() {
ApiKey = localStorage.getItem('OpenAIApiKey') || '';
if (!ApiKey.size) {
bHasKey = false;
} else {
bHasKey = true;
}
};
A code snippet from checkApiKey() technique
2. Context Menu Era:
- The getContextMenuItems() technique dynamically generates context menu gadgets primarily based on the kind of choice within the doc (e.g., textual content choice, pictures, shapes, hyperlinks, and many others.).
- If the API secret is current, extra choices like spelling and grammar correction, textual content rewriting, translation, and picture era are added to the context menu of the plugin.
- This technique additionally features a logic to test for the presence of pictures within the doc and an possibility for producing picture variations.
operate getContextMenuItems(choices) {
hyperlink = null;
checkApiKey();
let settings = {
guid: window.Asc.plugin.guid,
gadgets: [
{
id : 'ChatGPT',
text : generateText('ChatGPT'),
items : []
}
]
};
A code snippet from getContextMenuItems() technique
3. Occasion Dealing with:
- The plugin attaches occasion handlers for context menu actions. For instance, the onContextMenuShow() occasion triggers the show of the customized context menu and performs extra checks, corresponding to retrieving the present phrase.
- The onSettings() occasion handler opens a settings modal dialogue when the settings menu merchandise is clicked, and extra.
4. Utility Strategies:
- Helper strategies like generateText() for textual content translation, showError() for error show, and isEmpyText() for textual content validation are included within the code.js file as properly.
- The createSettings() technique creates a UI container displaying token info and a settings button.
operate createSettings(textual content, tokens, kind, isNoBlockedAction) {
let url;
let settings = {
mannequin : mannequin,
max_tokens : maxLen - tokens.size
};
if (settings.max_tokens < 100) {
console.error(new Error('This request is just too massive!'));
return;
}
A code snippet from createSettings() technique
The subsequent file is chat.js. It manages the logic for the chatbox, which could be initialized by right-clicking wherever within the doc. It really works together with the chat.html file to make sure the chatbox’s construction and performance are applied accurately.
operate createMessage(textual content, kind) {
let chat = doc.getElementById('chat');
let message = kind ? doc.createElement('div') : doc.getElementById('loading');
let textMes = doc.createElement('span');
textMes.classList.add('form-control', 'span_message');
textMes.innerText = textual content;
chat.scrollTop = chat.scrollHeight;
if (kind) {
message.classList.add('user_message');
chat.appendChild(message);
sendMessage(textual content);
} else {
message.id = '';
message.innerText="";
}
message.appendChild(textMes);
};
Code snippet of the createMessage() technique from the chat.js file
Now a couple of phrases concerning the settings.js file. It manages the settings part of the plugin. That is the place customers enter their API keys. This file additionally validates the API key entered by the person.
operate createError(error) ;
operate createLoader() {
if (!window.Asc.plugin.theme)
window.Asc.plugin.theme = {kind: 'mild'};
$('#loader-container').removeClass( "hidden" );
loader && (loader.take away ? loader.take away() : $('#loader-container')[0].removeChild(loader));
loader = showLoader($('#loader-container')[0], loadMessage);
};
Code snippets of createError() and createLoader() strategies from the settings.js file
There are additionally another .js recordsdata within the scripts listing that primarily embrace JavaScript for error prompts (as talked about earlier within the HTML part). Moreover, some recordsdata comprise JavaScript triggers for various environments the place the plugin could be used (desktop model, cloud model, and many others.).
Translations listing
This listing accommodates translation recordsdata for various languages, every represented by a .json file. Utilizing the onTranslate() technique, the plugin checks this listing, identifies the file akin to the system’s language and retrieves the mandatory translated textual content.
This mechanism ensures that the plugin can dynamically adapt to numerous languages, offering a localized and user-friendly expertise.
The seller and the licenses listing
The seller listing homes the code and useful resource recordsdata for the third-party libraries used within the plugin. This listing ensures that every one exterior dependencies are neatly organized and simply accessible.
This listing has three elements:
1. OpenAI (Chat GPT BPE Encoder Scripts): these scripts are important for encoding and decoding the textual content returned by the GPT engine.
2. Select2 Library Scripts: this can be a highly effective library that enhances the plugin’s person interface by offering customizable choose bins, making the plugin simpler to make use of.
3. jQuery Base File: jQuery simplifies HTML doc traversal and manipulation, occasion dealing with, and animation, making the UI extra dynamic and responsive.
This was an in depth overview of the ChatGPT plugin created by the ONLYOFFICE builders for his or her workplace suite. If you wish to discover the plugin’s code intimately and the strategies it makes use of, you may take a loot at this GitHub page.
Utilizing the identical rules and the ONLYOFFICE API, you may construct a plugin for every other AI-based writing assistant and use its capabilities inside the interface of an workplace suite.