WO2021184574A1

WO2021184574A1 - Document data importing method and apparatus, document data exporting method and apparatus, and storage medium

Info

Publication number: WO2021184574A1
Application number: PCT/CN2020/098708
Authority: WO
Inventors: 欧钦; 廖拓衡
Original assignee: 平安国际智慧城市科技股份有限公司
Priority date: 2020-03-20
Filing date: 2020-06-29
Publication date: 2021-09-23
Also published as: CN111460017A

Abstract

Disclosed are a document data importing method and apparatus, a document data exporting method and apparatus, a computer device and a storage medium. The document data importing method comprises: when a document data importing instruction carrying a document to be imported is received, calling a corresponding parsing program according to the file format of said document, and parsing said document, so as to acquire text data and annotation data in said document (S240); and after processing the text data according to the annotation data, mapping the text data to an object or a structural body of a service system according to an object name in the annotation data. The document data exporting method comprises: when a document data exporting instruction is received, acquiring a corresponding document exporting template, extracting annotation data to process data to be exported in a service system, so as to acquire processed data; and according to an object name in the annotation data, writing the processed data into a position corresponding to the document exporting template. The complexity of a service system is reduced, and the operating speed of the service system is improved.

Description

Document data import method, document data export method, device and storage medium

Cross-references to related applications

This application claims the priority of the Chinese patent application filed with the Chinese Patent Office on March 20, 2020, the application number is 2020102000514, and the application name is "document data import method, document data export method, device and storage medium", and its entire content Incorporated in this application by reference.

Technical field

This application relates to a document data import method, document data export method, device, computer equipment and storage medium.

Background technique

The business system is a system provided to basic personnel. It is an information system that provides targeted support to the business processing process. It can provide powerful tool support for the completion of a certain job. The import and export functions of the document data of the business system are different. Very commonly used functions in this business system.

The inventor realizes that the current import and export of document data in a business system generally only provides a single import or export function, such as: correspondingly uploading the document data to the business system, or exporting the corresponding data file from the business system. The format of the document and the format of the document data in the document are complex and changeable. When a new format appears, it is necessary to write different codes in different formats and change the code of the business system to meet the import or export of documents or document data in the new format. The development workload is large.

Summary of the invention

According to various embodiments disclosed in the present application, a document data import method, document data export method, device, computer equipment, and storage medium are provided.

A method for importing document data, the method comprising:

When receiving a document data import instruction carrying a document to be imported, analyze the file format of the document to be imported to determine the file format of the document to be imported;

Call a corresponding parsing program according to the file format of the document to be imported, parse the document to be imported, and obtain text data and annotation data in the document to be imported;

Process the text data according to the annotation data to obtain processed data; and

Import the processed data into the business system according to the annotation data.

A method for exporting document data, the method comprising:

When receiving a document data export instruction, obtain a corresponding export document template according to the document data export instruction;

Parse the exported document template and extract annotation data;

According to the annotation data, process the data to be exported in the business system to obtain the processed data; and

Write the processed data into the location corresponding to the exported document template according to the object name in the annotation data.

A document data importing device, the device comprising:

The format analysis module is configured to analyze the file format of the document to be imported when receiving the document data import instruction carrying the document to be imported, and determine the file format of the document to be imported;

The document parsing module is configured to call a corresponding parsing program according to the file format of the document to be imported, parse the document to be imported, and obtain text data and annotation data in the document to be imported;

The first data processing module is configured to process the text data according to the annotation data to obtain processed data; and

The data import module is used to import the processed data into the business system according to the annotation data.

A document data export device, the device includes:

A template obtaining module, configured to obtain a corresponding export document template according to the document data export instruction when the document data export instruction is received;

A template parsing module for parsing the exported document template and extracting annotation data;

The second data processing module is used to process the data to be exported in the business system according to the annotation data to obtain the processed data; and

The data export module is configured to write the processed data into the location corresponding to the export document template according to the object name in the annotation data.

A computer device, including a memory and one or more processors, the memory stores computer readable instructions, and when the computer readable instructions are executed by the processor, the one or more processors execute The following steps:

One or more computer-readable storage media storing computer-readable instructions. When the computer-readable instructions are executed by one or more processors, the one or more processors perform the following steps:

Parse the exported document template and extract annotation data;

The details of one or more embodiments of the present application are set forth in the following drawings and description. Other features and advantages of this application will become apparent from the description, drawings and claims.

Description of the drawings

In order to more clearly describe the technical solutions in the embodiments of the present application, the following will briefly introduce the drawings needed in the embodiments. Obviously, the drawings in the following description are only some embodiments of the present application. A person of ordinary skill in the art can obtain other drawings based on these drawings without creative work.

FIG. 1 is an application scenario diagram of a method for importing document data or a method for exporting document data according to one or more embodiments;

2 is a schematic flowchart of a method for importing document data according to one or more embodiments;

3 is a schematic flowchart of a method for exporting document data according to one or more embodiments;

Fig. 4 is a structural block diagram of a document data importing device according to one or more embodiments;

Figure 5 is a structural block diagram of a document data importing device in another embodiment;

Fig. 6 is a structural block diagram of a document data export device according to one or more embodiments;

Figure 7 is a block diagram of a computer device in one embodiment.

Detailed ways

In order to make the technical solutions and advantages of the present application clearer, the following further describes the present application in detail with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described here are only used to explain the present application, and are not used to limit the present application.

The document data import method and document data export method provided in this application can be applied to the application environment as shown in FIG. 1. The terminal 102 communicates with the server 104 through the network through the network. When the document data import method is executed, when the server 104 receives the document data import instruction that carries the document to be imported from the terminal 102, the file format of the document to be imported is analyzed to determine the file format of the document to be imported; the server 104 according to the document to be imported The file format calls the corresponding parsing program to parse the document to be imported, and obtain the text data and annotation data in the document to be imported; process the text data according to the annotation data to obtain the processed data; the processed data is based on the annotation data Import into the business system.

When the document data export method is executed, when the server 104 receives the document data export instruction sent by the terminal 102, it obtains the corresponding exported document template according to the document data export instruction; the server 104 parses the exported document template and extracts the annotation data; according to the annotations Data, the data to be exported in the business system is processed to obtain the processed data; the processed data is written into the location corresponding to the export document template according to the object name in the annotation data. The terminal 102 may be, but is not limited to, various personal computers, notebook computers, smart phones, tablet computers, and portable wearable devices. The server 104 may be implemented by an independent server or a server cluster composed of multiple servers.

In one of the embodiments, as shown in FIG. 2, a method for importing document data is provided. Taking the method applied to the server in FIG. 1 as an example for description, the method includes the following steps:

In step S220, when the document data import instruction carrying the document to be imported is received, the file format of the document to be imported is analyzed to determine the file format of the document to be imported.

The document to be imported is to record the graphic data that needs to be imported into the business system, and for documents with annotated data, such as: the name, age, mobile phone number, height, weight and other data recorded in the document need to be imported into the business system to record The document containing the name, age, mobile phone number, height, weight and other data is the document to be imported. The format of the document to be imported can be dox format, dcox format, xls format, pdf format, etc. The way to analyze the file format of the document to be imported is to judge by the file extension.

In step S240, the corresponding parsing program is called according to the file format of the document to be imported, the document to be imported is parsed, and the text data and annotation data in the document to be imported are obtained.

According to different file formats, pre-write the parsing program corresponding to different file formats, such as: pre-write the parsing program for parsing the file format as dox format, pre-write the parsing program for parsing the file format as dcox format, Pre-write the parsing program for parsing the file format as xls format, pre-write the parsing program for parsing the file format as pdf format, and so on. The text data is the content selected by the annotation in the body of the document to be imported, and the annotation data is the data in the annotation box of the annotation.

In step S260, the text data is processed according to the annotation data to obtain processed data.

The annotation data can be the object name, the object name and the name of the converter for data format conversion, the object name and the data validity verification code, and so on.

In one of the embodiments, the step of processing the text data according to the annotation data to obtain the processed data includes:

When the annotated data is only the object name, the annotated content in the text data is obtained as the processed data; when the annotated data is the name of the converter converted from the object name and the data format, the corresponding converter is called according to the converter name, and the text The annotated content in the data is formatted to obtain the processed data; when the annotated data is the object name and the data validity verification code, the data validity verification code is run to verify the data validity of the annotated content in the text data to obtain The valid data is treated as the processed data.

The object name matches the name of the object or structure variable in the business system. The object name can be used to determine where to fill the annotated text data in the business system. When the annotated data is the object name, the annotated text data can be directly used as the processed data, and step S280 is executed. For example, the text data in the document to be imported does not require any processing, and can be directly imported into the business system. Through the object name in the annotated data, determine the location of the text data in the business system, and import the text data into the business The corresponding position of the system is sufficient, which can improve the import efficiency of the documents to be imported.

When the annotation data is the name of the converter for the object name and data format conversion, the corresponding converter is called according to the converter name, and the annotated content in the text data is formatted to obtain the processed data. The name of the converter has a one-to-one correspondence with the converter. The converter can include a converter for date format conversion, a converter for number format conversion, a converter for letter case conversion, etc., such as date format conversion, text The date format in the data is "XXXX year XX month XX day", and the date format is required to be "XXXX/XX/XX" when importing into the business system, and the date in the text data is converted by calling the converter for converting the date format , The date format is required as the processed data when importing into the business system. When the format of the text data in the document to be imported is different from the data storage format of the business system, the business system can call the converter to perform the format conversion by using the converter name of the data format conversion in the annotation data. The code logic for format conversion does not need to develop code logic such as how to determine which converter to use for format conversion, just call it directly according to the converter name.

When the annotated data is the object name and data validity verification code, run the data validity verification code to verify the data validity of the annotated content in the text data, and obtain the valid data as the processed data, such as: by running the code, The data in the text data is validated by valid data scope and rules. When it does not meet the corresponding scope or rules, the relevant data will be ignored and recorded. The data that meets the requirements are processed data. You can verify age, mobile phone number, IP address, etc., and you can customize the verification rules, such as age verification. The valid range of the age data in the text data is 18-65, and the annotation data is "${age, max=65, min=18}". When there is error data in the text data in the document to be imported, or some data that does not need to be imported into the business system, the business system can run the data validity verification code in the annotation data, which can extract the corresponding data from the text data in the document to be imported. Data import without the need to develop and build a large amount of data validity verification code in the business system, just run it directly.

Step S280: Import the processed data into the business system according to the annotation data.

For example, if it is the age that needs to be entered into the business system, the age data is obtained from the processed data obtained after age verification and mapped to the object or structure of the business system.

The above-mentioned document data import method, when a document data import instruction carrying a document to be imported is received, the corresponding parsing program is called according to the file format of the document to be imported, the document to be imported is parsed, and the text data and comments in the document to be imported are obtained Data; Annotation data can process text data. After processing the text data according to the annotation data, it is mapped to the object or structure of the business system according to the object name in the annotation data. There is no need to change the code in the business system, avoiding a large amount of work of modifying the system code, reducing the development workload, reducing the complexity of the business system, and improving the operating speed of the business system.

In one of the embodiments, the step of importing the processed data into the business system according to the annotation data includes: determining the correspondence between the object name and the processed data according to the object name in the annotation data; and processing according to the object name The corresponding relationship of the subsequent data maps the processed data to the object or structure of the business system.

The object is a certain component in the business system. Structure is a kind of data structure, a kind of aggregate data type in C language. The object name in the annotation data matches the object or structure variable name in the business system. The object name can be used to determine where to fill the annotation text data in the business system. By determining the correspondence between the object name and the processed data Relationship, which maps the processed data to the object or structure of the business system that matches the object name.

In one of the embodiments, before the step of receiving the document data import instruction carrying the document to be imported, the method further includes: obtaining the pre-imported document; calling the annotation script file to perform annotation processing on the pre-imported document to obtain the document to be imported.

The pre-imported document is a document that records the graphic data that needs to be imported into the business system and does not have annotated data. Annotate the pre-imported document through the annotation script file. The annotation script file is used to annotate the pre-imported document. The annotation script file writes the corresponding annotation program according to the format and layout of the pre-imported document, such as: Word document, run the annotation script File, find the corresponding paragraph of the Word document, annotate the annotation data of the corresponding paragraph, obtain the document to be imported that records the graphic data that needs to be imported into the business system, and annotate the document to be imported with the annotation data, and annotate the pre-imported document by calling the annotation script file Processing can improve the efficiency of document data import.

In one of the embodiments, a method for importing document data is illustrated by an example, and the example is as follows:

There is a batch of survey data that needs to be imported into the business system. It is derived from manual collection and manually entered into the Word document. The data may be entered incorrectly. The data in the document includes name, age (minimum 0 years old, maximum 120 years old), mobile phone number ( Domestic operators), height (unit: cm, minimum 30 cm, maximum 230 cm, rounded), weight (unit: kg, minimum 1.0 kg, maximum 200.0 kg).

Annotate by selecting the data (ie text data) in the document in the Word document, the annotation data of the annotation is:

Name: ${name}

Age: ${age, min=0, max=120}

Mobile phone number: ${mobile, type="mobile"}

Height: ${height, min=30, max=230}

Weight: ${weight, type="decimal", min=1.0, max=200.0}

The code imported into the business system compiles the following data structure:

When importing, the data validity verification will be carried out through the annotation data, and the valid data will be obtained as the processed data and mapped to the newly instanced Person object. The data that has not passed the data validity verification will be recorded and prompted later .

The above-mentioned document data import method, when a document data import instruction carrying a document to be imported is received, the corresponding parsing program is called according to the file format of the document to be imported, the document to be imported is parsed, and the text data and comments in the document to be imported are obtained Data; Annotation data can process text data. After processing the text data according to the annotation data, it is mapped to the object or structure of the business system according to the object name in the annotation data. There is no need to change the code in the business system, avoiding a large amount of work of modifying the system code, reducing the development workload, reducing the complexity of the business system, and improving the operating speed of the business system. By calling the annotation script file to perform annotation processing on the pre-imported document, the efficiency of document data import can be improved.

In one of the embodiments, as shown in FIG. 3, a method for exporting document data is provided. Taking the method applied to the server in FIG. 1 as an example for description, the method includes the following steps:

In step S420, when the document data export instruction is received, a corresponding export document template is obtained according to the document data export instruction.

The export document template is used to receive the written graphic data. At least one export document template can be preset according to the document format. For example, the export document template can include: export document template in dox format, dcox format The export document template of, the export document template of xls format, the export document template of pdf format and so on. The export document template can also be set according to the data type of the data to be exported. For example, a certain type of data needs to be written into the export document template after a specific processing before being exported, and the export document template is preset according to the data type and so on. The document data export instruction carries the relevant information of the data to be exported. When the document data export instruction is received, the export document format is determined according to the relevant information of the data to be exported in the document data export instruction, and the export document template is determined according to the export document format. Path; Obtain the export document template according to the obtained path.

The path for obtaining the document template can be obtained from a disk file, a document template uploaded by the user through the terminal, or a remote procedure call. According to the position selected by the annotation in the export document template as the position where the data to be exported is written, the annotation data corresponding to the annotation is used to process the data to be exported.

In step S440, the exported document template is parsed, and the annotation data is extracted.

The annotation data can be the object name, the object name and the name of the converter for data format conversion, or the object name and expression. The object name guides the variable name in the target data structure when exporting or the variable name in the source data structure when exporting. The object name can be formed by code or automatically generated by predefined rules. The object name matches the name of the object or structure variable of the data to be exported, which means that the data to be exported is filled into the corresponding comment position. Example: For example, there are two member variables in a data structure, namely name and age, then you can fill in the comments of the template similar to "${name}" and "${age}" to match the data structure The name and age member variables. In practical applications, the template is usually pre-written or generated, but the data is filled in afterwards and may not be uniform. For example, the common date and time format conversion requires only the date, but the source data may contain a time part, which needs to be converted into a date format. Expressions are similar to formulas in Excel and can provide additional functions such as calculations, statistics, and branch judgments. For example, if you need to provide a certain calculation function, you can provide a method name to indicate it. For example, for a tax calculation function, the input parameter is salary income, then you can fill in ${tax, expr="tax(salary)"} in the remarks, and the output content is the amount of tax paid.

In step S460, the data to be exported in the business system is processed according to the annotation data, and the processed data is obtained.

The annotation data can be the object name, the object name and the name of the converter for data format conversion, or the object name and expression.

In one of the embodiments, the step of processing the data to be exported in the business system according to the annotation data to obtain the processed data includes: when the annotation data is only the object name, according to the object name, obtaining the data associated with the object in the business system The data to be exported corresponding to the name is used as the processed data; when the annotation data is the name of the object name and the converter name for data format conversion, the corresponding converter is called according to the converter name, and the data to be exported corresponding to the object name in the business system is called Perform format conversion to obtain processed data; when the annotated data is an object name and expression, the expression engine is called to parse and execute the expression, and the data to be exported corresponding to the object name in the business system is processed, and the processed data is obtained. The data.

When the annotation data is the object name, the object name matches the object or structure variable name of the data to be exported, which means that the data to be exported is filled in the corresponding annotation position, and the object name corresponding to the object name in the business system is obtained according to the object name. As processed data, the data can be directly filled into the corresponding annotation position. For example, the data to be exported does not require any processing, and can be directly written into the export document template. The object name in the annotated data can be used to determine the application of the data to be exported. To fill in the position, just write the data to be exported into the corresponding position of the export document template, which can improve the export efficiency of the data to be exported.

When the annotation data is the name of the converter for the object name and data format conversion, the corresponding converter is called according to the converter name, the format conversion of the data to be exported corresponding to the object name in the business system is performed, and the processed data is obtained. The name corresponds to the converter one-to-one. The converter can include a converter for date format conversion, a converter for digital format conversion, a converter for letter case conversion, etc., such as date format conversion, business system The date format is "XXXX/XX/XX", and the date format required for exporting the document template is "XXXX year XX month XX day". The date in the business system is converted by calling the converter for converting the date format to obtain the exported document The data in the date format required by the template is used as the processed data. When the format of the data to be exported is different from the format of the exported document template, the business system uses the converter name of the data format conversion in the annotation data to call the converter to perform the format conversion, and then fill in the exported document template according to the object name. The business system develops the code logic of how to perform format conversion, without the need to develop code logic such as how to determine which converter to use for format conversion, just call it directly according to the name of the converter.

When the annotation data is the object name and expression, the expression engine is called to parse and execute the expression, and the data to be exported corresponding to the object name in the business system is processed to obtain the processed data; in actual applications, in order to achieve some If the formula cannot be satisfied, or provide some external data exchange functions, the expression will be parsed and executed through the expression engine. The expression can be loaded with custom functions to achieve more flexible data processing functions. For example: there is a batch of employee salary information in the business system, and it is necessary to export the salary table based on the employee salary information. The salary table needs to include the name, the salary that should be paid, the amount of tax deduction, and the actual salary. Some data in the salary table need to pass the employee salary When the information is calculated and obtained, the corresponding calculation formula is annotated in the export document template. When exporting, the corresponding calculation formula is directly executed based on the employee salary information to obtain the salary payable, the amount of personal tax deduction, the actual salary, etc. There is no need to develop a lot of expression code logic in the business system, just call the expression engine to parse and execute the expression directly according to the expression in the annotation data.

In step S480, the processed data is written into the position corresponding to the exported document template according to the object name in the annotation data.

Write the processed data into the corresponding location of the exported document template according to the object name in the annotation data. For example, if the annotation in the Excel workbook is filled in the column of the worksheet, then the processed data is filled in the cell below it or Specify the start and end cells in the comment.

The above-mentioned document data export method, when receiving the document data export instruction, obtain the corresponding exported document template according to the document data export instruction; analyze the exported document template, extract the annotation data, and the annotation data can be processed for the exported data; The data to be exported in the system is processed to obtain the processed data; the processed data is written into the position corresponding to the export document template according to the object name in the annotation data. There is no need to change the code in the business system, avoiding a large amount of work of modifying the system code, reducing the development workload, reducing the complexity of the business system, and improving the operating speed of the business system.

In one of the embodiments, a method for exporting document data is illustrated with an example, and the example is as follows:

There is a group of employee salary information in the business system that needs to be exported to a table. The data required by the table includes name, salary to be paid, individual tax deduction amount, and actual salary.

The annotation data of the following annotations in the export document template is:

Name: ${name}

Salary payable: ${total, type="decimal", min=2200.0}

Tax deduction: ${tax, expr="tax(total)"}

Actual salary: ${final, type="decimal", expr="${total}-${tax}"}

The code exported by the business system writes the following data structure:

When exporting, after parsing the expression in the annotation data, call the written "tax" method to calculate the tax deduction amount and calculate the actual salary.

It should be understood that, although the various steps in the flowchart of FIGS. 2-3 are displayed in sequence as indicated by the arrows, these steps are not necessarily performed in sequence in the order indicated by the arrows. Unless specifically stated in this article, the execution of these steps is not strictly limited in order, and these steps can be executed in other orders. Moreover, at least some of the steps in Figure 2-3 may include multiple sub-steps or multiple stages. These sub-steps or stages are not necessarily executed at the same time, but can be executed at different times. These sub-steps or stages The execution order of is not necessarily performed sequentially, but may be performed alternately or alternately with at least a part of other steps or sub-steps or stages of other steps.

In one of the embodiments, as shown in FIG. 4, a document data import device is provided, which includes: a format analysis module 310, a document analysis module 320, a first data processing module 330, and a data import module 340, wherein:

The format analysis module 310 is configured to analyze the file format of the document to be imported when a document data import instruction carrying the document to be imported is received, and determine the file format of the document to be imported;

The document parsing module 320 is configured to call a corresponding parsing program according to the file format of the document to be imported, parse the document to be imported, and obtain text data and annotation data in the document to be imported;

The first data processing module 330 is used to process the text data according to the annotation data to obtain the processed data; and

The data import module 340 is used to import the processed data into the business system according to the annotation data.

In one of the embodiments, the first data processing module 330 is also used to: when the annotation data is only the object name, obtain the annotated content in the text data as the processed data; when the annotation data is converted from the object name and data format When converting the name of the converter, call the corresponding converter according to the converter name to convert the annotated content in the text data to obtain the processed data; when the annotated data is the object name and the data validity verification code, the data validity is run The verification code is used to verify the data validity of the annotated content in the text data, and obtain valid data as the processed data.

In one of the embodiments, the data import module 340 is also used to: determine the correspondence between the object name and the processed data according to the object name in the annotation data; according to the correspondence between the object name and the processed data, the processed data The data is mapped to the object or structure of the business system.

In one of the embodiments, as shown in FIG. 5, the document data importing device further includes an annotation processing module 350 for obtaining the pre-imported document; calling an annotation script file to perform an annotation processing on the pre-imported document to obtain the document to be imported.

In one of the embodiments, as shown in FIG. 6, a document data export device is provided, including: a template acquisition module 510, a template analysis module 520, a second data processing module 530, and a data export module 540, wherein:

The template obtaining module 510 is configured to obtain a corresponding export document template according to the document data export instruction when a document data export instruction is received;

The template analysis module 520 is configured to analyze the exported document template and extract annotation data;

The second data processing module 530 is configured to process the data to be exported in the business system according to the annotation data to obtain the processed data; and

The data export module 540 is configured to write the processed data into the location corresponding to the export document template according to the object name in the annotation data.

In one of the embodiments, the second data processing module 530 is further configured to: when the annotation data is only the object name, according to the object name, obtain the data to be exported corresponding to the object name in the business system as the processed data; When the data is the name of the converter for the object name and data format conversion, the corresponding converter is called according to the converter name, and the data to be exported corresponding to the object name in the business system is formatted to obtain the processed data; when the annotation data is When the object name and expression are used, the expression engine is called to parse and execute the expression, and the data to be exported corresponding to the object name in the business system is processed to obtain the processed data.

For the specific limitation of the document data importing device, please refer to the above limitation of the document data importing method, which will not be repeated here. Each module in the above-mentioned document data importing device can be implemented in whole or in part by software, hardware, and a combination thereof. The above-mentioned modules may be embedded in the form of hardware or independent of the processor in the computer equipment, or may be stored in the memory of the computer equipment in the form of software, so that the processor can call and execute the operations corresponding to the above-mentioned modules.

Regarding the specific limitation of the document data exporting device, please refer to the above limitation of the document data exporting method, which will not be repeated here. Each module in the above-mentioned document data exporting device can be implemented in whole or in part by software, hardware, and a combination thereof. The above-mentioned modules may be embedded in the form of hardware or independent of the processor in the computer equipment, or may be stored in the memory of the computer equipment in the form of software, so that the processor can call and execute the operations corresponding to the above-mentioned modules.

In one of the embodiments, a computer device is provided. The computer device may be a server, and its internal structure diagram may be as shown in FIG. 7. The computer equipment includes a processor, a memory, a network interface, and a database connected through a system bus. Among them, the processor of the computer device is used to provide calculation and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system, computer readable instructions, and a database. The internal memory provides an environment for the operation of the operating system and computer-readable instructions in the non-volatile storage medium. The database of the computer equipment is used to store document data. The network interface of the computer device is used to communicate with an external terminal through a network connection. When the computer readable instruction is executed by the processor, a method for importing document data or/and a method for exporting document data is realized.

Those skilled in the art can understand that the structure shown in FIG. 7 is only a block diagram of part of the structure related to the solution of the present application, and does not constitute a limitation on the computer equipment to which the solution of the present application is applied. The specific computer equipment may include More or fewer parts than shown in the figure, or some parts are combined, or have a different arrangement of parts.

A computer device includes a memory and one or more processors. The memory stores computer-readable instructions. When the computer-readable instructions are executed by the processor, the one or more processors execute the steps of the document data importing method.

One or more computer-readable storage media storing computer-readable instructions. When the computer-readable instructions are executed by one or more processors, the one or more processors execute the steps of the above-mentioned document data import method; wherein, the The computer-readable storage medium may be non-volatile or volatile.

A computer device includes a memory and one or more processors. The memory stores computer readable instructions. When the computer readable instructions are executed by the processor, the one or more processors execute the steps of the document data export method.

One or more computer-readable storage media storing computer-readable instructions. When the computer-readable instructions are executed by one or more processors, the one or more processors execute the steps of the method for exporting document data; wherein, the computer The readable storage medium may be non-volatile or volatile.

A person of ordinary skill in the art can understand that all or part of the processes in the methods of the foregoing embodiments can be implemented by instructing relevant hardware through computer-readable instructions. The computer-readable instructions can be stored in a non-volatile computer. In a readable storage medium, when the computer-readable instructions are executed, they may include the processes of the above-mentioned method embodiments. Wherein, any reference to memory, storage, database, or other media used in the embodiments provided in this application may include non-volatile and/or volatile memory. Non-volatile memory may include read only memory (ROM), programmable ROM (PROM), electrically programmable ROM (EPROM), electrically erasable programmable ROM (EEPROM), or flash memory. Volatile memory may include random access memory (RAM) or external cache memory. As an illustration and not a limitation, RAM is available in many forms, such as static RAM (SRAM), dynamic RAM (DRAM), synchronous DRAM (SDRAM), double data rate SDRAM (DDRSDRAM), enhanced SDRAM (ESDRAM), synchronous chain Channel (Synchlink) DRAM (SLDRAM), memory bus (Rambus) direct RAM (RDRAM), direct memory bus dynamic RAM (DRDRAM), and memory bus dynamic RAM (RDRAM), etc.

The technical features of the above embodiments can be combined arbitrarily. In order to make the description concise, all possible combinations of the technical features in the above embodiments are not described. However, as long as there is no contradiction in the combination of these technical features, they should be It is considered as the range described in this specification.

The above-mentioned embodiments only express several implementation manners of the present application, and the description is relatively specific and detailed, but it should not be understood as a limitation on the scope of the invention patent. It should be pointed out that for those of ordinary skill in the art, without departing from the concept of this application, several modifications and improvements can be made, and these all fall within the protection scope of this application. Therefore, the scope of protection of the patent of this application shall be subject to the appended claims.

Claims

A method for importing document data, including:

When receiving a document data import instruction carrying a document to be imported, analyze the file format of the document to be imported to determine the file format of the document to be imported;

Call a corresponding parsing program according to the file format of the document to be imported, parse the document to be imported, and obtain text data and annotation data in the document to be imported;

Process the text data according to the annotation data to obtain processed data; and

Import the processed data into the business system according to the annotation data.
The method according to claim 1, wherein the step of processing the text data according to the annotation data to obtain the processed data comprises:

When the annotation data is only the object name, acquiring the annotated content in the text data as the processed data;

When the annotation data is the name of the converter converted from the object name and the data format, invoking the corresponding converter according to the converter name to perform format conversion on the annotated content in the text data to obtain the processed data; and

When the annotated data is the object name and the data validity verification code, the data validity verification code is run to perform data validity verification on the annotated content in the text data, and the valid data is obtained as the processed data.
The method according to claim 2, wherein the step of importing the processed data into a business system according to the annotation data comprises:

Determine the correspondence between the object name and the processed data according to the object name in the annotation data; and

According to the correspondence between the object name and the processed data, the processed data is mapped to the object or structure of the business system.
The method according to claim 1, wherein before the step of receiving the document data import instruction carrying the document to be imported, the method further comprises:

Obtain pre-imported documents; and

Call the annotation script file to perform annotation processing on the pre-imported document, and obtain the document to be imported.
A method for exporting document data, including:

When receiving a document data export instruction, obtain a corresponding export document template according to the document data export instruction;

Parse the exported document template and extract annotation data;

According to the annotation data, process the data to be exported in the business system to obtain the processed data; and

Write the processed data into the location corresponding to the exported document template according to the object name in the annotation data.
The method according to claim 5, wherein the step of processing the data to be exported in the business system according to the annotation data to obtain the processed data comprises:

When the annotation data is only the object name, according to the object name, obtain the data to be exported corresponding to the object name in the business system as the processed data;

When the annotation data is the name of the object name and the converter name of the data format conversion, the corresponding converter is called according to the converter name, the format conversion of the data to be exported corresponding to the object name in the business system is performed, and the processing is obtained. After the data; and

When the annotation data is an object name and an expression, the expression engine is called to parse and execute the expression, and the data to be exported corresponding to the object name in the business system is processed to obtain the processed data.
A document data importing device, including:

The format analysis module is configured to analyze the file format of the document to be imported when receiving the document data import instruction carrying the document to be imported, and determine the file format of the document to be imported;

The document parsing module is configured to call a corresponding parsing program according to the file format of the document to be imported, parse the document to be imported, and obtain text data and annotation data in the document to be imported;

The first data processing module is configured to process the text data according to the annotation data to obtain processed data; and

The data import module is used to import the processed data into the business system according to the annotation data.
A document data export device, including:

A template obtaining module, configured to obtain a corresponding export document template according to the document data export instruction when the document data export instruction is received;

A template parsing module for parsing the exported document template and extracting annotation data;

The second data processing module is used to process the data to be exported in the business system according to the annotation data to obtain the processed data; and

The data export module is configured to write the processed data into the location corresponding to the export document template according to the object name in the annotation data.
A computer device includes a memory and one or more processors. The memory stores computer-readable instructions. When the computer-readable instructions are executed by the one or more processors, the one or more Each processor performs the following steps:

When receiving a document data import instruction carrying a document to be imported, analyze the file format of the document to be imported to determine the file format of the document to be imported;

Call a corresponding parsing program according to the file format of the document to be imported, parse the document to be imported, and obtain text data and annotation data in the document to be imported;

Process the text data according to the annotation data to obtain processed data; and

Import the processed data into the business system according to the annotation data.
The computer device according to claim 9, wherein the processor further executes the following steps when executing the computer readable instruction:

When the annotation data is only the object name, acquiring the annotated content in the text data as the processed data;

When the annotation data is the name of the converter converted from the object name and the data format, invoking the corresponding converter according to the converter name to perform format conversion on the annotated content in the text data to obtain the processed data; and

When the annotated data is the object name and the data validity verification code, the data validity verification code is run to perform data validity verification on the annotated content in the text data, and the valid data is obtained as the processed data.
The computer device according to claim 10, wherein the processor further executes the following steps when executing the computer-readable instructions:

Determine the correspondence between the object name and the processed data according to the object name in the annotation data; and

According to the correspondence between the object name and the processed data, the processed data is mapped to the object or structure of the business system.
The computer device according to claim 9, wherein the processor further executes the following steps when executing the computer readable instruction:

Obtain pre-imported documents; and

Call the annotation script file to perform annotation processing on the pre-imported document, and obtain the document to be imported.
One or more computer-readable storage media storing computer-readable instructions, which when executed by one or more processors, cause the one or more processors to perform the following steps:

When receiving a document data import instruction carrying a document to be imported, analyze the file format of the document to be imported to determine the file format of the document to be imported;

Call a corresponding parsing program according to the file format of the document to be imported, parse the document to be imported, and obtain text data and annotation data in the document to be imported;

Process the text data according to the annotation data to obtain processed data; and

Import the processed data into the business system according to the annotation data.
The storage medium according to claim 13, wherein the following steps are further performed when the computer-readable instructions are executed by the processor:

When the annotation data is only the object name, acquiring the annotated content in the text data as the processed data;

When the annotation data is the name of the converter converted from the object name and the data format, invoking the corresponding converter according to the converter name to perform format conversion on the annotated content in the text data to obtain the processed data; and

When the annotated data is the object name and the data validity verification code, the data validity verification code is run to perform data validity verification on the annotated content in the text data, and the valid data is obtained as the processed data.
The storage medium according to claim 14, wherein the following steps are further performed when the computer-readable instructions are executed by the processor:

Determine the correspondence between the object name and the processed data according to the object name in the annotation data; and

According to the correspondence between the object name and the processed data, the processed data is mapped to the object or structure of the business system.
The storage medium according to claim 13, wherein the following steps are further performed when the computer-readable instructions are executed by the processor:

Obtain pre-imported documents; and

Call the annotation script file to perform annotation processing on the pre-imported document, and obtain the document to be imported.
A computer device includes a memory and one or more processors. The memory stores computer-readable instructions. When the computer-readable instructions are executed by the one or more processors, the one or more Each processor performs the following steps:

When receiving a document data export instruction, obtain a corresponding export document template according to the document data export instruction;

Parse the exported document template and extract annotation data;

According to the annotation data, process the data to be exported in the business system to obtain the processed data; and

Write the processed data into the location corresponding to the exported document template according to the object name in the annotation data.
The computer device according to claim 17, wherein the processor further executes the following steps when executing the computer-readable instructions:

When the annotation data is only the object name, obtain the data to be exported corresponding to the object name in the business system as the processed data according to the object name;

When the annotation data is the name of the object name and the converter name of the data format conversion, the corresponding converter is called according to the converter name, the format conversion of the data to be exported corresponding to the object name in the business system is performed, and the processing is obtained. After the data; and

When the annotation data is an object name and an expression, the expression engine is called to parse and execute the expression, and the data to be exported corresponding to the object name in the business system is processed to obtain the processed data.
One or more computer-readable storage media storing computer-readable instructions, which when executed by one or more processors, cause the one or more processors to perform the following steps:

When receiving a document data export instruction, obtain a corresponding export document template according to the document data export instruction;

Parse the exported document template and extract annotation data;

According to the annotation data, process the data to be exported in the business system to obtain the processed data; and

Write the processed data into the location corresponding to the exported document template according to the object name in the annotation data.
The storage medium according to claim 19, wherein the following steps are further performed when the computer-readable instructions are executed by the processor:

When the annotation data is only the object name, obtain the data to be exported corresponding to the object name in the business system as the processed data according to the object name;

When the annotation data is the name of the object name and the converter name of the data format conversion, the corresponding converter is called according to the converter name, the format conversion of the data to be exported corresponding to the object name in the business system is performed, and the processing is obtained. After the data; and

When the annotation data is an object name and an expression, the expression engine is called to parse and execute the expression, and the data to be exported corresponding to the object name in the business system is processed to obtain the processed data.