One. Office software application requirements in office automation systems
Most of the final expressive form of office automation is the file information and industry information, documents, and industry information extension. The file is the source of information. The most important tools currently dealing with documents and files are desktop office software. Therefore, constructing practical, convenient, efficient, low-input OA systems, not only considering document integration, but also considers the integration of paperwork. The key to solving two integrated and application systems is the integration technology of office automation systems and desktop office software.
Due to a single development of domestic development, the platform-dependent development is serious, many OA developers use the development model of the "group platform appropriate customization". The problem is to customize complex applications and in terms of interfaces with other business systems. Integrated other software and equipment, because the group platform is built too "high", there is a small space for developers to be too small, and many functions are difficult to achieve. Therefore, in many document-processed office automation applications, this often occurs: information (document) often flows in the system in an attachment method, processing of information (document reading, modification) call Word or other Word processing software, as well as query information, you need to open the application, and the query information needs to be copied to the Office document. At present, most office automation systems apply this model. Different points are only used with Domimo / Notes, with Exchange / Outlook, also based on Web. This mode makes office operations often switched back and forth between the business system environment and the Office software application environment. This model is that the business logic layer and data performance layer cannot automatically perform data interaction, often requires office personnel to understand the system application Complex operations, even need repeated copy, paste the work.
In fact, Office and OA integration have always existed, but domestic Office software must consider forward compatibility in addition to the integration methods proposed in the OA integration, but need to comply with Microsoft (At present, the industrial technical standards of the most OA architecture in Microsoft platforms). The domestic Office software should be compatible with the system constructed from the Microsoft platform and does not rely on Microsoft platforms, is the largest technical difficulty at the stage.
With the gradual application of office stars in the government office, Zhizhima's characteristics of domestic office automation systems, based on existing products, such as embedded applications, etc., and implements development development. The integrated interface provided. The goal of the Office of the Office is to establish an efficient and convenient official document to handle the environment to ensure the safety, completeness, real, accurate, intelligent, sharing, real-time management and utilization of office information, and improve office efficiency.
Currently, office star controls have a complete and forward-compatible solution for four mainstream OA systems:
Domino / Notes
ActiveX and General API are provided;
Exchange / Outlook
Provides OLE1, OLE2, ACTIVEX, and General APIs;
Web
Provide ActiveX;
Application system developed with DEPHI, VC, VB, PB
It provides a variety of different languages to bridge between C (office star controls), so the office star control supports integration requirements for application systems developed by different development languages.
two. Domino / Notes Integration Office Star Control Solution
1. The principle of notes defects and integrated MSOFFICE
In the 1990s, the vast majority of the OA system was based on the Lotus Notes of the original lotus. It has powerful, flexible workflow definitions and management functions, and storage management functions for non-structured data (mainly text data), is the ideal development platform for office automation systems that are transferred to the main content. Currently, most of the operations of OA are basically the system developed by this environment. However, since the platform background data management system is a non-relational database and a relational model cannot be established. Therefore, the business office automation system based on relational model (relational data inventory storage and management data) is difficult to combine with Lotus Notes to develop platforms. Even if the definition and management of workflows uses Notes, data management uses a relational database, and its operational efficiency is also difficult to achieve the ideal effect. This is one of the problems that OA and business office automation are difficult to integrate. At present, there is a large number of Microsoft Offcie calls in the Notes system. By supporting Microsoft's standards in Notes / Domino, Lotus has established between the two environments, cultivated very close connections, COM technology in Notes program Application, greatly enriched the function and application range of Notes applications, to use the MS Office COM object in Domino Designer, you must confirm that the correct object library is used, and these libraries can be automatically displayed in Domino Designer after the Office is installed. come out. Although these are not accurate OLE classes, they still show "Ole classes" categories in the Domino Designer Design Interface "Reference". Among them, Word 8.0 corresponds to Office97, Word9.0 corresponds to Office2000.
To ensure that the integrated application can run correctly, the user should register the corresponding Windows application (such as Word or Excel) in the local registry.
2. Notes Integration Office Star Control Principle
As weequate we can understand that office star control has established standard bridges for COM, that is, all COM technical standards in Notes can also call the Office Star Control.
three. B / S cross-platform mode integrated solution
With the development of intermediate parts and Web technology, three or multi-layer distributed applications are increasingly popular. In this architecture, the client only stores a degraded layer software, the application logic includes transaction processing, monitoring, information queuing, web services, etc., the background is the database. However, in the implementation process of the application architecture of the browser, it also brings a series of technical issues.
This is because the browser is developed to adapt to the network application, and the Chinese word processing office software is developed to adapt to the application of office documents, so the Chinese characters are complex typing, editing functions, Web scripting languages are unable to implement, so that The office circulation system implemented by the browser has encountered great obstacles in editing typography.
The amount of information in the office automation system is quite large and cumbersome. It has proved that excellent client has considerable role in the processing of documents. Moreover, in addition to office automation systems, office personnel personal writing documents and with external information exchange are inseparable from client-side processing software. Therefore, desktop Office software is inevitably a basic support component of the application system, and as the Office software supports the support of application system integration applications, B / S structural application systems and Office application combined will significantly expand the office automation system. The idea of architecture.
Office Star Control provides unique embedded mode integration with OA system, strengthens the overall and systematicity of OA systems. Here is the office star control integration program:
ActiveX control
ActiveX is a set of technical sets that Microsoft proposed using COM (Component Object Model, Parts Object Models) use software components to interact in network environments. It doesn't matter with specific programming languages. As a technique for Internet application development, ActiveX is widely used in various aspects of the web server as well as clients. At the same time, ActiveX technology is also used to easily create a normal desktop application. For Windows platforms, office star controls are standard ActiveX controls, developers can extend their own web application server-side and clients using office star controls.
The following figure is the architecture of the solution
The picture below is a special application project screenshot.
four. Conclude
Advanced design patterns of office stars have provided strong support for the establishment of secondary development and applications based on its basis. Multi-system integration can be provided with multiple solutions and application systems seamlessly, regardless of the enhancement of office star system functions, automated operations and components implementation can provide excellent solutions. These programs are easier to reflect people-oriented regression in computer applications, providing users with more consistent choices.
