System and method for solving office file format conversion

Abstract

The invention discloses a system and method for solving office file format conversion, and the method comprises the steps: S1, calling a file conversion service through a use end, and obtaining a converted file id; s2, calling a file downloading interface by the use end to obtain a converted file; s3, storing the calling log in a database; s4, synchronizing the file between the file conversion servers; s5, subscribing the theme of the message queue by the use end, and updating the file information when the file conversion is finished; the system comprises a file uploading module, a file batch uploading module, a file conversion module, a message notification mechanism, a failure retry mechanism, a cluster deployment module, an access setting module, an asynchronous conversion processing module and a log calling module. According to the method, the output quality and compatibility are ensured, the robustness of the system is improved, service lateral expansion is supported, use by developers is facilitated, a file path is returned instantly, long-time waiting is avoided, and process recording and problem analysis are facilitated.

Description

Technical Field

[0001] The present invention relates to the technical field of format conversion, and in particular to a system and method for solving office file format conversion. Background Art

[0002] Existing document conversion technologies mainly include using virtual printers to output documents to PDF or image formats, using Microsoft Office API and OpenOffice / LibreOffice command line tools for automated conversion, and using SWFTools to convert PDF to Flash.

[0003] To achieve online preview or format conversion of files, it is usually necessary to convert the document to another format, which involves complex processing procedures and technology stacks. For example, when using virtual printers, Office API, OpenOffice / LibreOffice and other tools for conversion, multiple factors need to be considered to ensure the conversion quality. The following problems exist:

[0004] 1. High error rate: During the conversion process, if the document is incorrect, damaged or encrypted, it may cause the conversion to fail and eventually cannot be previewed or used normally;

[0005] 2. The layout format is difficult to guarantee: the converted documents often have problems such as disordered layout and abnormal display, especially for documents containing complex layouts and embedded objects;

[0006] 3. No support for consistent preview on multiple devices: Existing solutions often cannot provide consistent preview effects on different devices and operating systems, which brings inconvenience to users;

[0007] 4. Performance issues: When processing large documents, the conversion speed is slow and consumes a lot of resources, especially when using methods such as Flash player, performance bottlenecks are prone to occur;

[0008] 5. Security issues: Using third-party online services for document conversion may pose a risk of privacy leakage, and the lack of effective security measures may lead to unauthorized access to data. Summary of the invention

[0009] The purpose of the present invention is to provide a system and method for solving the office file format conversion problem in view of the above technical problems.

[0010] A method for converting office file formats includes the following sub-steps:

[0011] S1: The user calls the file conversion service and obtains the converted file ID;

[0012] S2: The user calls the file download interface to obtain the converted file;

[0013] S3: Call logs are stored in the database;

[0014] S4: Synchronize files between file conversion servers;

[0015] S5: The user subscribes to the message queue topic and updates the file information when the file conversion is completed.

[0016] Further, a method for solving office file format conversion, the log is used to check the historical call file information;

[0017] The synchronization file is used for convenient access.

[0018] Furthermore, a method for solving the problem of office file format conversion is provided, wherein step S1 includes the following sub-steps:

[0019] S11: The user uploads the file to be converted to the document conversion server through the API gateway;

[0020] S12: The request reaches the format conversion backend service through the API gateway and F5 payload;

[0021] S12: Synchronously obtain the task ID and query the progress of document conversion through the task ID.

[0022] Further, a method for solving the problem of office file format conversion, step S2 includes the following sub-steps:

[0023] S21: After receiving the file, the document conversion server converts the file;

[0024] S22: The file is converted into the target file format, and the task status is updated and an MQ message is sent to complete the conversion.

[0025] Further, a method for solving the problem of office file format conversion, the step S3 comprises the following sub-steps:

[0026] S31: The backend service generates a converted file and a call information file and stores them in a file storage server;

[0027] S32: The backend service stores the data in the request and conversion process into the MySQL database.

[0028] Further, a method for solving the problem of office file format conversion, the step S4 comprises the following sub-steps:

[0029] S41: The backend service sends an MQ message indicating that the conversion is complete;

[0030] S42: The user consumes the mq message and previews the converted file through the download address in the message.

[0031] A system for solving office file format conversion, including a file upload module, a file batch upload module, a file conversion module, a message notification mechanism, a failure retry mechanism, a cluster deployment module, an access setting module, an asynchronous conversion processing module, and a call log module;

[0032] The file upload module saves the file uploaded by the caller on the server;

[0033] The file batch upload module supports submitting multiple files at one time and performing conversion processing at the same time;

[0034] The file conversion module converts the uploaded file into a target format;

[0035] The message notification mechanism performs message notification via MQ after the conversion is completed;

[0036] The failure retry mechanism supports an automatic retry mechanism when file conversion fails;

[0037] The cluster deployment module is deployed in a cluster manner to support horizontal expansion of services;

[0038] The access setting module supports backend service access and frontend page submission;

[0039] The asynchronous conversion processing module quickly returns the file path and performs asynchronous conversion in the background;

[0040] The call log module records the call log information and provides query services.

[0041] The beneficial effects of the present invention are as follows: through a system and method for solving the problem of office file format conversion, the best conversion path is automatically selected according to the specific type of the input file to ensure output quality and compatibility; it supports the processing of multiple file conversion requests at the same time, significantly improving the system throughput; all transmitted data is encrypted and protected to prevent unauthorized access; when encountering a temporary error, reconversion is automatically attempted to improve the robustness of the system; it is deployed in a cluster manner to support horizontal expansion of services; it supports back-end service access and front-end page submission, which is convenient for developers to use; the file path is returned immediately, and the background asynchronous conversion is performed to avoid long waiting times; and call log information is saved to facilitate process recording and problem analysis. BRIEF DESCRIPTION OF THE DRAWINGS

[0042] Figure 1 The present invention is a flowchart of a method for solving the problem of converting office file formats.

[0043] Figure 2It is a structural diagram of a system for solving office file format conversion. DETAILED DESCRIPTION

[0044] In order to have a clearer understanding of the technical features, purposes and effects of the present invention, specific embodiments of the present invention are now described with reference to the accompanying drawings.

[0045] As attached Figure 1 As shown, a method for solving office file format conversion includes the following sub-steps:

[0046] S1: The user calls the file conversion service and obtains the converted file ID;

[0047] S2: The user calls the file download interface to obtain the converted file;

[0048] S3: Call logs are stored in the database;

[0049] S4: Synchronize files between file conversion servers;

[0050] S5: The user subscribes to the message queue topic and updates the file information when the file conversion is completed.

[0051] Further, a method for solving office file format conversion, the log is used to check the historical call file information;

[0052] The synchronization file is used for convenient access.

[0053] Furthermore, a method for solving the problem of office file format conversion is provided, wherein step S1 includes the following sub-steps:

[0054] S11: The user uploads the file to be converted to the document conversion server through the API gateway;

[0055] S12: The request reaches the format conversion backend service through the API gateway and F5 payload;

[0056] S12: Synchronously obtain the task ID and query the progress of document conversion through the task ID.

[0057] Further, a method for solving the problem of office file format conversion, step S2 includes the following sub-steps:

[0058] S21: After receiving the file, the document conversion server converts the file;

[0059] S22: The file is converted into the target file format, and the task status is updated and an MQ message is sent to complete the conversion.

[0060] Further, a method for solving the problem of office file format conversion, the step S3 comprises the following sub-steps:

[0061] S31: The backend service generates a converted file and a call information file and stores them in a file storage server;

[0062] S32: The backend service stores the data in the request and conversion process into the MySQL database.

[0063] Further, a method for solving the problem of office file format conversion, the step S4 comprises the following sub-steps:

[0064] S41: The backend service sends an MQ message indicating that the conversion is complete;

[0065] S42: The user consumes the mq message and previews the converted file through the download address in the message.

[0066] A system for solving office file format conversion, including a file upload module, a file batch upload module, a file conversion module, a message notification mechanism, a failure retry mechanism, a cluster deployment module, an access setting module, an asynchronous conversion processing module, and a call log module;

[0067] The file upload module saves the file uploaded by the caller on the server;

[0068] The file batch upload module supports submitting multiple files at one time and performing conversion processing at the same time;

[0069] The file conversion module converts the uploaded file into a target format;

[0070] The message notification mechanism sends a message notification via MQ after the conversion is completed, so that the user can update the final conversion result in time;

[0071] The failure retry mechanism supports an automatic retry mechanism when file conversion fails;

[0072] The cluster deployment module is deployed in a cluster manner to support horizontal expansion of services;

[0073] The access setting module supports backend service access and frontend page submission, which is convenient for developers to use;

[0074] The asynchronous conversion processing module quickly returns the file path and performs asynchronous conversion in the background to avoid long waiting times;

[0075] The call log module records the call log information and provides query services.

[0076] Specific embodiment 1 A technical stack of a system for solving office file format conversion:

[0077]

[0078]

[0079] Specific embodiment 2 Functional performance indicators of a system for solving office file format conversion:

[0080]

[0081] This solution uses a system and method to solve the problem of office file format conversion. It automatically selects the best conversion path according to the specific type of input file to ensure output quality and compatibility; supports processing multiple file conversion requests at the same time, significantly improving system throughput; encrypts all transmitted data to prevent unauthorized access; automatically attempts to reconvert when encountering temporary errors, improving the robustness of the system; is deployed in a cluster manner to support horizontal expansion of services; supports back-end service access and front-end page submission, making it easier for developers to use; instantly returns the file path and performs asynchronous conversion in the background to avoid long waits; and saves call log information to facilitate process recording and problem analysis.

[0082] The above shows and describes the basic principles and main features of the present invention and the advantages of the present invention. It should be understood by those skilled in the art that the present invention is not limited to the above embodiments. The above embodiments and descriptions are only for explaining the principles of the present invention. Without departing from the spirit and scope of the present invention, the present invention may have various changes and improvements, which fall within the scope of the present invention to be protected. The scope of protection of the present invention is defined by the attached claims and their equivalents.

Claims

1. A method for solving office file format conversion, characterized in that: It includes the following sub-steps: S1: The user calls the file conversion service and obtains the converted file ID; S2: The user calls the file download interface to obtain the converted file; S3: Call logs are stored in the database; S4: Synchronize files between file conversion servers; S5: The user subscribes to the message queue topic and updates the file information when the file conversion is completed.

2. A method for solving office file format conversion according to claim 1, characterized in that: The log is used to check the historical call file information; The synchronization file is used for convenient access.

3. A method for solving office file format conversion according to claim 1, characterized in that: The step S1 comprises the following sub-steps: S11: The user uploads the file to be converted to the document conversion server through the API gateway; S12: The request reaches the format conversion backend service through the API gateway and F5 payload; S12: Synchronously obtain the task ID and query the progress of document conversion through the task ID.

4. A method for solving office file format conversion according to claim 1, characterized in that: The step S2 comprises the following sub-steps: S21: After receiving the file, the document conversion server converts the file; S22: The file is converted into the target file format, and the task status is updated and an MQ message is sent to complete the conversion.

5. A method for solving office file format conversion according to claim 1, characterized in that: The step S3 has the following sub-steps: S31: The backend service generates a converted file and a call information file and stores them in a file storage server; S32: The backend service stores the data in the request and conversion process into the MySQL database.

6. A method for solving office file format conversion according to claim 1, characterized in that: The following sub-steps are described in step S4: S41: The backend service sends an MQ message indicating that the conversion is complete; S42: The user consumes the mq message and previews the converted file through the download address in the message.

7. A system for solving office file format conversion, which implements a method for solving office file format conversion according to any one of claims 1 to 6, characterized in that: Including file upload module, file batch upload module, file conversion module, message notification mechanism, failure retry mechanism, cluster deployment module, access setting module, asynchronous conversion processing module, call log module; The file upload module saves the file uploaded by the caller on the server; The file batch upload module supports submitting multiple files at one time and performing conversion processing at the same time; The file conversion module converts the uploaded file into a target format; The message notification mechanism performs message notification via MQ after the conversion is completed; The failure retry mechanism supports an automatic retry mechanism when file conversion fails; The cluster deployment module is deployed in a cluster manner to support horizontal expansion of services; The access setting module supports backend service access and frontend page submission; The asynchronous conversion processing module quickly returns the file path and performs asynchronous conversion in the background; The call log module records the call log information and provides query services.

Images