Document processing method and device based on configuration template

Abstract

The present application relates to the technical field of data processing, and provides a document processing method and device based on a configuration template, which comprises the following steps: receiving an input file template selected by a user, generating a report file according to the input file template and a corresponding input file template data table; receiving a report file filled by the user, reading data values of data items in the report file, and writing the data values in the report file into a report file data table in units of data items and data values; generating an output file data table according to a pre-generated output file number, the report file data table and an output file template data table; and generating an output file according to the output file template and the corresponding output file template data table. The present application solves the problem that information system input and output pages are fixed and difficult to meet the dynamic adjustment of business, and eliminates the strong coupling relationship between data items caused by the storage structure of a conventional data table.

Description

TECHNICAL FIELD

[0001] The present application relates to the technical field of data processing, and in particular to a document processing method and device based on a configuration template. BACKGROUND

[0002] With the improvement of enterprise informatization, many businesses have been included in information systems, but there are still application scenarios of business interaction with offline electronic documents outside the system. The main reasons are the diversity of offline electronic document formats, hierarchical nesting, formula inclusion, frequent adjustment, and other reasons, which make it difficult to meet the needs of business dynamic adjustment in the form of page forms and other solidification methods in information systems.

[0003] In view of the above phenomenon, the countermeasures adopted by each enterprise mainly include the following:

[0004] 1. In order to avoid frequent changes to the system, some enterprises continue to maintain offline mode for contents with high possibility of adjustment, or use electronic documents independently outside the information system, or attach them to the system as attachments. The disadvantage is that electronic documents and information systems are isolated from each other, and cannot realize comprehensive informationization support for business, which is prone to the situation of "two layers of skin" of online and offline.

[0005] 2. Set up a special technical team in the enterprise or sign a maintenance contract with the system developer to ensure that the information system can be dynamically updated. The disadvantage is that the maintenance cost is high, the technical requirements for the maintenance personnel are high, and the personnel team needs to be stable.

[0006] 3. Purchase commercial GRID plug-in products that support secondary development during information system construction, hire an implementation team familiar with the product, customize the frequently changed part of the content, and need to be effectively integrated with the system. The disadvantage is that additional procurement costs are required, other developers are hired, the system interference content and coupling degree are increased, and the construction difficulty, cost and controllable risk are increased.

[0007] 4. For business with frequent changes in management content, informationization construction can only be suspended, and the relevant business continues to maintain the previous offline mode. When the business tends to be stable or the compatibility of the software product is improved, the business content will be considered to be included in the informationization construction. In this way, it will inevitably affect the informationization coverage rate and efficiency improvement.

[0008] The four manners above cannot effectively solve the problem that the information system cannot dynamically respond to the needs of offline electronic document layout format, filling content and display result. The business activities of an enterprise are complex and changeable, and the data document files independent of the system are a common problem encountered by each enterprise in the process of information construction. If the problem cannot be effectively solved, the coverage and application depth of the information system will be affected, the data entry of the operating personnel in and out of the system will be repeated, the data error probability will be increased, the data quality will be reduced, the work efficiency will be affected, and the overall effect of the enterprise information construction will be greatly reduced. The electronic document as an information carrier and the information system need to have sufficient opening level and compatibility to meet the objective application needs of rapid response to business adjustment, and to play an actual information support role for the enterprise. SUMMARY

[0009] The application provides a document processing method and device based on a configuration template, to solve the problem that an information system cannot dynamically respond to the needs of offline electronic document layout format, filling content and display result in the prior art.

[0010] The application provides a document processing method based on a configuration template, comprising:

[0011] An input file template selected by a user is received, a report file is generated according to the input file template and a corresponding input file template data table, and the report file is provided to the user in a manner of downloading or embedding into an information system, wherein the input file template data table comprises fields of input file template number, output file template number, data item and input data value layout position, each row corresponds to a data item, and the data value corresponding to the data item in the report file is empty or a preset formula;

[0012] A report file filled by the user is received, the data value of the data item in the report file is read, and the input file template number, the output file template number, the data item, the input data value layout position and the data value in the report file are written into a report file data table corresponding to the report file, as units of data item and data value;

[0013] An output file data table is generated according to a pre-generated output file number, the report file data table and an output file template data table;

[0014] An output file is generated according to the output file template, the data value of the corresponding data item in the output file data table is filled into the output file, and the output file is provided to the user in a manner of downloading or embedding into an information system.

[0015] According to the document processing method based on the configuration template, the report file is generated according to the input file template and the corresponding input file template data table, comprising:

[0016] reading the input file template number, data item and input data value layout position in the input file template data table;

[0017] generating the report file according to the input file template corresponding to the input file template number;

[0018] setting the data value corresponding to the data item as null or a preset formula according to the input data value layout position.

[0019] According to the document processing method based on the configuration template provided by the application, the report file filled by the user is received, the data value of the data item in the report file is read, and the input file template number, output file template number, data item and data value in the report file are written into the report file data table corresponding to the report file, including:

[0020] The report file filled by the user is received, and the report file number corresponding to the report file is generated, the report file number is generated when the report file is generated or is generated when the user fills in the report file and uploads, and the report file data table is generated after the report file number is generated;

[0021] The input file template number, output file template number, report file number, data item and input data value layout position are written into the report file data table;

[0022] The data value corresponding to each input data value layout position in the report file is read;

[0023] According to the obtained report file number, the data value corresponding to the input data value layout position is read in the report file data table;

[0024] The read data value is written into the data value field of the data row corresponding to the input data value layout position in the report file data table.

[0025] According to the document processing method based on the configuration template provided by the application, the output file data table is generated according to the pre-generated output file number, the report file data table and the output file template data table, including:

[0026] The report file number, output file number and data value field are added on the basis of the output file template data table to generate the output file data table, and the output file template data table includes the fields: input file template number, output file template number, data item and output data value layout position;

[0027] The output file number and the data value corresponding to the same data item in the output file data table in the report file data table are filled into the output file data table.

[0028] According to the document processing method based on the configuration template, the output file is generated according to the output file template, and the data value of the corresponding data item in the output file data table is filled into the output file, and the method comprises the following steps of:

[0029] Reading the output file template number, the output file number and the output data value layout position in the output file data table;

[0030] Generating the output file according to the output file template corresponding to the output file template number, and associating the output file number with the output file;

[0031] Writing the data value into the corresponding position in the output file according to the output data value layout position.

[0032] According to the document processing method based on the configuration template, before the input file template selected by the user is received and the report file is generated according to the input file template and the corresponding input file template data table, the method further comprises the following steps of:

[0033] Receiving the input file template and the output file template uploaded by the user;

[0034] Creating the input file template data table according to the input file template;

[0035] Creating the output file template data table according to the output file template.

[0036] According to the document processing method based on the configuration template, one input file template corresponds to one or more output file templates, or multiple input file templates correspond to one output file template.

[0037] The application further provides a document processing device based on the configuration template, which comprises:

[0038] The report file generation module is used for receiving the input file template selected by the user, generating the report file according to the input file template and the corresponding input file template data table, and providing the report file to the user in the form of download or embedding into an information system, wherein the input file template data table comprises the fields of the input file template number, the output file template number, the data item and the input data value layout position, each row corresponds to one data item, and the data value corresponding to the data item in the report file is empty or a preset formula;

[0039] The filling file data table writing module is configured to receive a filling file filled by a user, read data values of data items in the filling file, and write the input file template number, the output file template number, the data item, the input data value layout position, and the data value in the filling file into a filling file data table corresponding to the filling file;

[0040] The output file data table generating module is configured to generate an output file data table according to the pre-generated output file number, the filling file data table, and the output file template data table.

[0041] The output file generating module is configured to generate an output file according to the output file template, fill the data values of the corresponding data items in the output file data table into the output file, and provide the output file to the user in the form of download or embedded information system.

[0042] According to the document processing device based on the configuration template provided by the application, the filling file generating module comprises:

[0043] The input data reading module is configured to read the input file template number, the data item, and the input data value layout position in the input file template data table.

[0044] The first file generating module is configured to generate a filling file according to the input file template corresponding to the input file template number.

[0045] The filling file initializing module is configured to set the data value corresponding to the data item as empty or a preset formula according to the input data value layout position.

[0046] According to the document processing device based on the configuration template provided by the application, the filling file data table writing module comprises:

[0047] The filling file number generating module is configured to receive a filling file filled by a user, and generate a filling file number corresponding to the filling file. The filling file number is generated when the filling file is generated or when the user fills the filling file and uploads it. The filling file data table is generated after the filling file number is generated.

[0048] The first data writing module is configured to write the input file template number, the output file template number, the filling file number, the data item, and the input data value layout position into the filling file data table.

[0049] The data value reading module is configured to read the data value corresponding to each input data value layout position in the filling file.

[0050] The position searching module is configured to search for the input data value layout position corresponding to the read data value in the filling file data table according to the obtained filling file number.

[0051] The data value writing module is configured to write the read data value into a data value field of a data row corresponding to the input data value layout position in the report file data table.

[0052] The document processing method and device based on the configuration template provided by the application solve the problem of the solidification of the input and output pages of the information system and the difficulty in meeting the dynamic adjustment of the business by configuring the input file template and the output file template, generating the corresponding files according to each file template, and providing the corresponding files to the user in the form of download or embedding into the information system. BRIEF DESCRIPTION OF DRAWINGS

[0053] In order to more clearly illustrate the technical solutions in the application or the prior art, the following will briefly introduce the drawings needed to be used in the embodiments or the prior art description. Obviously, the drawings in the following description are some embodiments of the application, and other drawings can be obtained by those skilled in the art without creative effort on the basis of these drawings.

[0054] Figure 1 is a flowchart of the document processing method based on the configuration template provided by the application;

[0055] Figure 2 is a structural diagram of the document processing device based on the configuration template provided by the application. DETAILED DESCRIPTION

[0056] In order to make the objects, technical solutions and advantages of the application clearer, the technical solutions in the application will be described clearly and completely in combination with the drawings in the application. Obviously, the described embodiments are some of the embodiments of the application, not all the embodiments. Based on the embodiments in the application, all other embodiments obtained by those skilled in the art without creative effort belong to the protection scope of the application.

[0057] The document processing method based on the configuration template in the embodiment of the application, as shown in Figure 1 , includes:

[0058] Step S110, receiving the input file template selected by the user, generating the report file according to the input file template and the corresponding input file template data table, and providing the report file to the user in the form of download or embedding in the information system, wherein the input file template data table includes the fields of input file template number, output file template number, data item and input data value layout position, and each row corresponds to the content of a data item, and the data value corresponding to the data item in the report file is empty or a preset formula. Since the input file template has a related output file template, the output file template number related to the input file template is also stored in the input file template data table. It should be noted that if the output file contains all the contents of the report file, the input file template data table and the output file template data table are the same.

[0059] In this step, various file templates configured by the user are pre-stored in the information system. The file templates usually have two types, input file templates and output file templates, and the specific formats of the file templates are determined according to the actual business needs. For example, taking the business of querying the employee background of a company as an example, the input file template and the output file template of the company employee background are shown in Table 1 and Table 2 as follows:

[0060] Table 1 Input file template of company employee background

[0061]

[0062] Table 2 Output file template of company employee background

[0063] Name / \ Name \ Gender / \ Gender \ Experience Value / \ Experience Value \

[0064] Among them, name and gender represent data items, and their corresponding contents represent data values. In the template, the data values are defined according to data value identifiers. For example, / \ / represents a start identifier, and / / \ represents an end identifier. The information system can identify the data item corresponding to the data value and the input data value layout position according to the two identifiers. For example, / \ / name / / \ indicates that the data item corresponding to the data value is name, and the input data value layout position of the data value in the subsequent report file is B2. Since the table of the above input file template usually uses an Excel table, the numbering of the layout position can refer to the layout position numbering rules of the Excel table.

[0065] If the string between the two identifiers is a data item, it means that the data value corresponding to the data item between the two identifiers is filled in by the user, and the corresponding position in the generated report file is set to empty. If the string between the two identifiers is a formula, it means that the data value corresponding to the data item between the two identifiers is calculated according to the formula based on the data values of other data items filled in by the user.

[0066] In addition to the various file templates configured by the user being stored in the information system, the information system also stores file template data tables corresponding to the file templates. Taking the query company employee qualification business as an example, the file template data tables are shown in Table 3 and Table 4:

[0067] Table 3 Input file template data table of company employee qualification

[0068] Serial Number Input File Template Number Output File Template Number Data Item Input Data Value Position 1 INPUT008 OUTPUT006 Name B2 2 INPUT008 OUTPUT006 Gender D2 3 INPUT008 NULL Year of Birth B3 4 INPUT008 NULL Year of Entry D3 5 INPUT008 NULL Length of Service B4 6 INPUT008 OUTPUT006 Experience Value D4

[0069] Table 4 Output file template data table of company employee qualification

[0070] Serial Number Input File Template Number Output File Template Number Data Item Output Data Value Position 1 INPUT008 OUTPUT006 Name B2 2 INPUT008 OUTPUT006 Gender D2 6 INPUT008 OUTPUT006 Experience Value F2

[0071] The data tables in Table 3 and Table 4 can be generated in advance in the information system according to the file templates configured by the user.

[0072] In this step, the generated report file is provided to the user in the form of being downloaded or embedded in the information system. Specifically, the generated report file can be a word, wps or Excel file, a download link can be provided on the display interface of the information system for the user to download, or the interface of the word, wps or Excel file can be embedded in the information system in the form of purchasing online editing office software, the report file can be directly opened and edited in the information system, for example, the report file is displayed in the form of loading an electronic file in a WEB page. The generated report file is shown in Table 5:

[0073] Table 5 Report file of company employee qualification (unfilled state)

[0074]

[0075]

[0076] The display content in the report file is shown in Table 5.

[0077] In step S120, the user fills in the report file, reads the data values of the data items in the report file, and writes the input file template number, the output file template number, the data item, the input data value layout position and the data value in the report file into the report file data table corresponding to the report file. After generating the report file in Table 5, the user fills in the report file to obtain the filled report file shown in Table 6:

[0078] Table 6 Report file of company employee qualification (filled state)

[0079] Name Zhang San Gender Male Year of Birth 1980 Year of Entry 2000 Length of Service 22 Experience Value Senior

[0080] The data values in Table 6 above are read and filled into the filled-in file data table corresponding to the filled-in file, i.e. the filled-in file data table in Table 7 below is obtained.

[0081] Table 7: Filled-in file data table of company employee qualifications (filled-in state)

[0082]

[0083] Step S130: generating an output file data table according to the pre-generated output file number (for example, SCWJ010), the filled-in file data table and the output file template data table, i.e. generating an output file data table 8 according to Table 7 above and Table 4. The output file number is generated after the filled-in file data table is filled in.

[0084] Table 8: Output file data table of company employee qualifications (filled-in state)

[0085]

[0086] Step S140: generating an output file according to the output file template, filling the data values of the corresponding data items in the output file data table into the output file, and providing the output file to the user in the form of download or embedding into the information system. That is, generating an output file according to Table 2 above, filling the corresponding data values in Table 8 into the generated output file, and the output file is shown in Table 9 below:

[0087] Table 9: Output file of company employee qualifications

[0088] Name Zhang San Gender Male Experience Value Senior

[0089] The generated output file is also provided to the user in the form of download or embedding into the information system. Specifically, the generated output file can be a word, wps or Excel file, a download link can be provided on the display interface of the information system for the user to download, or the interface of the word, wps or Excel file can be embedded in the information system in the form of online editing office software, which can be directly opened in the information system to display to the user.

[0090] The document processing method based on the configuration template provided in the embodiment solves the problem of the solidification of the input and output pages of the information system and the difficulty in meeting the dynamic adjustment of the business, by configuring the input file template and the output file template, generating the corresponding files according to the file templates, and providing the corresponding files to the user in the form of downloading or embedding the information system.

[0091] In step S110, the input file template and the corresponding input file template data table are used to generate the reporting file, including:

[0092] The input file template number, the data item and the input data value layout position in the input file template data table (for example, Table 3) are read. There are several different input file templates in the information system, each template has a unique number, and the input file template number is stored in the file attribute of the input file template. When the input file template is uploaded to the information system, the information system reads the number in the file attribute, stores the input file template number, and adds a template number in the drop-down list of the template selected by the user.

[0093] The reporting file is generated according to the input file template corresponding to the input file template number. After the input file template number is obtained, the corresponding input file template (for example, Table 1) can be found, so that the reporting file is generated according to the template.

[0094] The data item corresponding data value is set to be empty or a preset formula according to the input data value layout position, so that the reporting file is generated as shown in Table 5.

[0095] In the embodiment, step S120 includes:

[0096] The reporting file filled by the user is received, and the reporting file number (for example, TBWJ007) corresponding to the reporting file is generated. The reporting file number is generated when the reporting file is generated or when the user fills in the reporting file and uploads it. The reporting file data table is generated after the reporting file number is generated.

[0097] The table structure of the report file data table can be preset in the information system after the table structure of the input file template is uploaded, and includes the fields: input file template number, output file template number, report file number, data item, input data value layout position, and data value. It can be seen that the table structure of the report file data table is based on the table structure of the input file template data table and adds the fields of report file number and data value. After the user fills in the report file and uploads it, the report file data table corresponding to the user is generated according to the above fields, and the report file data table of each user corresponds to the respective report file number.

[0098] The input file template number, output file template number, report file number, data item, and input data value layout position are written into the report file data table to obtain Table 10 below:

[0099] Table 10 Report file data table of company employee qualifications (unfilled state)

[0100]

[0101] The data values corresponding to the input data value layout positions in the report file are read.

[0102] According to the obtained report file number, the input data value layout positions corresponding to the read data values are found and read in the report file data table.

[0103] The read data values are written into the data value fields of the data rows corresponding to the input data value layout positions in the report file data table, i.e., Table 7 is obtained.

[0104] Specifically, in the report file data table (Table 10 above), according to the search path of report file number (TBWJ007) in the user uploaded report file --> input file template number (INPUT008) --> data item name (name) --> data value layout position coordinates (B2), the filling position "B2" of the data item "name" in the report file is obtained from the report file data table, and then the "Zhang San" information filled by the user is obtained from the "B2" cell of the report file (Table 6) filled by the user and stored in the field of the data value corresponding to "B2" in the report file data table (Table 10 above). Next, the values of each data item filled by the user are obtained in the above order, and are filled into the report file data table (Table 10 above) to obtain Table 7.

[0105] Step S130 includes adding the filed file number, output file number and data value field on the basis of the output file template data table to generate the output file data table, the output file template data table including the fields: the input file template number, output file template number, data item and output data value layout position. Specifically, the filed file number, output file number and data value field are added on the basis of the structure of Table 4.

[0106] The output file number and the data value corresponding to the same data item in the output file data table in the filed file data table are filled into the output file data table to obtain Table 8.

[0107] In step S140, the output file is generated according to the output file template, and the data value of the corresponding data item in the output file data table is filled into the output file, including:

[0108] The output file template number, output file number and output data value layout position in the output file data table are read.

[0109] The output file is generated according to the output file template corresponding to the output file template number, and the output file number is associated with the output file.

[0110] The data value is written into the corresponding position in the output file according to the output data value layout position.

[0111] For example, according to the output template number (OUTPUT006), output file number (SCWJ010), data value layout position coordinates (B2) and filed value (Zhang San) in the output file data table, the output file is generated and the filed value is automatically filled in the corresponding position in the file layout, and finally the output file as shown in Table 9 is obtained, that is, the display content in the output file is Table 9.

[0112] In this embodiment, before step S110, it further includes:

[0113] The input file template and output file template uploaded by the user are received, that is, after the user configures the input file template and output file template, the user uploads each file template to the information system, for example, uploads Tables 1 and 2 to the information system.

[0114] The input file template data table is created according to the input file template. Specifically, the input file template number and output file template number in Tables 1 and 2 are respectively read, and the data item of the input file template is read according to the data item and data value identifier in Table 1 to generate the data table as shown in Table 3,

[0115] According to the output file template, an output file template data table is created. Specifically, the input file template number and the output file template number are obtained, and the data items of the output file template are read according to the data items and the data value identifiers in Table 2, and a data table as shown in Table 4 is generated.

[0116] In the embodiment, at the database level, a storage unit taking data items and values as basic units is established through innovative design of the storage structure, and the strong coupling relationship between data items caused by the conventional storage structure is eliminated. The front end mainly adopts a configuration template to support the input and output directly facing the user, and meet the needs of the user for dynamic adjustment of the format and content of the layout. The bottom layer adopts a database structure design reducing the data coupling of the storage space, realizes the independence of the data item access, and strengthens the correlation between the input and output files and between the data items and the layout positions.

[0117] In the embodiment, one input file template corresponds to one or more output file templates, so that different users view different contents in the reporting file, and different contents are generated into output files according to different output file templates.

[0118] Or, one input file template corresponds to one output file template, so that the user can view the contents of multiple reporting files in one output file.

[0119] The document processing device based on the configuration template provided by the present application is described below, and the document processing device based on the configuration template described below can be correspondingly referred to the document processing method based on the configuration template described above.

[0120] As shown in Figure 2 The document processing device based on the configuration template of the present application comprises:

[0121] The reporting file generation module 210 is configured to receive an input file template selected by a user, generate a reporting file according to the input file template and a corresponding input file template data table, and provide the reporting file to the user in a manner of downloading or embedding into an information system, wherein the input file template data table comprises fields of an input file template number, an output file template number, data items, and input data value layout positions, each row of the input file template data table corresponds to one data item, and the data values corresponding to the data items in the reporting file are empty or preset formulas.

[0122] The reporting file data table writing module 220 is configured to receive a reporting file filled by a user, read the data values of the data items in the reporting file, and write the input file template number, the output file template number, the data items, the input data value layout positions, and the data values in the reporting file into a reporting file data table corresponding to the reporting file in a unit of data items and data values.

[0123] The output file data table generation module 230 is configured to generate an output file data table according to the pre-generated output file number, the report file data table and the output file template data table.

[0124] The output file generation module 240 is configured to generate an output file according to the output file template, fill the data value of the corresponding data item in the output file data table into the output file, and provide the output file to the user in the form of download or embedding into the information system.

[0125] The document processing device based on the configuration template provided by the present application solves the problem of the solidification of the input and output pages of the information system and the difficulty in meeting the dynamic adjustment of the business by configuring the input file template and the output file template, generating the corresponding file according to each file template, and providing the corresponding file to the user in the form of download or embedding into the information system. Moreover, the input and output files are stored in the database of the information system according to the data items in rows, and for the case of increasing the data items for the dynamic adjustment of the business, the structure of the data table does not need to be changed, but only the data row needs to be increased, the storage structure is more flexible, and the strong coupling relationship between the data items caused by the conventional data table storage structure is eliminated.

[0126] Optionally, the report file generation module 210 comprises:

[0127] The input data reading module is configured to read the input file template number, the data item and the input data value layout position in the input file template data table.

[0128] The first file generation module is configured to generate the report file according to the input file template corresponding to the input file template number.

[0129] The report file initialization module is configured to set the data value corresponding to the data item as empty or a preset formula according to the input data value layout position.

[0130] Optionally, the report file data table writing module 220 comprises:

[0131] The report file number generation module is configured to receive the report file filled by the user, generate the report file number corresponding to the report file, and generate the report file number when the report file is generated or when the user fills the report file and uploads it. The report file data table is generated after the report file number is generated.

[0132] The first data writing module is configured to write the input file template number, the output file template number, the report file number, the data item and the input data value layout position into the report file data table.

[0133] The data value reading module is configured to read data values corresponding to the layout positions of the input data values in the reporting file.

[0134] The position searching module is configured to search for the layout positions of the input data values corresponding to the read data values in the reporting file data table according to the obtained reporting file number.

[0135] The data value writing module is configured to write the read data values into data value fields of data rows corresponding to the layout positions of the input data values in the reporting file data table.

[0136] Optionally, the output file data table generating module 230 is specifically configured to:

[0137] The reporting file number, the output file number and the data value fields are added to the output file template data table to generate an output file data table, the output file template data table includes the fields of the input file template number, the output file template number, the data item and the output data layout position, and the output file number and the data values corresponding to the same data items in the output file data table are filled into the output file data table.

[0138] Optionally, the output file generating module 240 includes:

[0139] The output data reading module is configured to read the output file template number, the output file number and the output data layout position in the output file data table.

[0140] The second file generating module is configured to generate an output file according to the output file template corresponding to the output file template number, and associate the output file number with the output file.

[0141] The output file writing module is configured to write the data values into corresponding positions in the output file according to the output data layout position.

[0142] Optionally, the document processing device based on the configuration template further includes:

[0143] The file template receiving module is configured to receive the input file template and the output file template uploaded by a user.

[0144] The first template data table creating module is configured to create an input file template data table according to the input file template.

[0145] The second template data table creating module is configured to create an output file template data table according to the output file template.

[0146] Optionally, one input file template corresponds to one or more output file templates, or multiple input file templates correspond to one output file template.

[0147] The device embodiments described above are merely illustrative, wherein the units described as separate components can or can not be physically separated, and the components displayed as units can or can not be physical units, i.e., can be located in one place, or can be distributed to multiple network units. Part or all of the modules can be selected to achieve the purpose of the embodiment scheme according to actual needs. Those skilled in the art can understand and implement it without creative labor.

[0148] Through the description of the above embodiments, those skilled in the art can clearly understand that the embodiments can be realized by means of software and the necessary general hardware platform, and of course can also be realized by hardware. Based on such understanding, the above technical solutions can be embodied in the form of a software product, which can be stored in a computer readable storage medium, such as a ROM / RAM, a magnetic disk, an optical disk, etc., and includes a plurality of instructions to make a computer device (which can be a personal computer, a server, or a network device, etc.) execute the methods described in each embodiment or some parts of the embodiments.

[0149] Finally, it should be noted that: the above embodiments are only used to illustrate the technical solutions of the present application, and not to limit them; although the present application has been described in detail with reference to the foregoing embodiments, those skilled in the art should understand that: it can still modify the technical solutions recorded in the foregoing embodiments, or make equivalent replacement for part of the technical features; and these modifications or replacements do not make the essence of the corresponding technical solutions deviate from the spirit and scope of the technical solutions of the embodiments of the present application.

Claims

1. A configuration template-based document processing method, characterized by, include: The system receives the input file template selected by the user, generates a form based on the input file template and the corresponding input file template data table, and provides the form to the user by downloading or embedding it into the information system. The input file template data table includes fields: input file template number, output file template number, data item, and input data value layout position, with each row corresponding to one data item. The data value corresponding to the data item in the form is empty or a preset formula. Receive the completed form from the user, read the data values ​​of the data items in the form, and write the input file template number, output file template number, data items, input data value page positions, and data values ​​in the form into the form data table corresponding to the form; Generate an output file data table based on the pre-generated output file number, the data table for filling in the information file, and the data table for output file template; An output file is generated based on the output file template. The data values ​​of the corresponding data items in the output file data table are filled into the output file. The output file is then provided to the user by downloading or embedding it into the information system. The input file template data table, output file template data table, reporting file data table, and output file data table are each stored in the database of the information system according to the data items, row by row.

2. The configuration template-based document processing method of claim 1, wherein, Generate a form based on the input file template and the corresponding input file template data table, including: Read the input file template number, data item, and input data value layout from the input file template data table; Generate a form based on the input file template corresponding to the input file template number; Based on the position of the input data value on the page, set the corresponding data value of the data item to empty or a preset formula. 3.The configuration template based document processing method of claim 2, wherein, The system receives a completed form from the user, reads the data values ​​of the data items in the form, and, using data items and data values ​​as units, writes the input file template number, output file template number, data items, and data values ​​from the form into the corresponding form data table, including: The system receives the completed form from the user and generates a form number corresponding to the form. The form number is generated when the form is generated or when the user completes and uploads the form. The form data table is generated after the form number is generated. Write the input file template number, output file template number, filling file number, data item, and input data value layout position into the filling file data table; Read the data values ​​corresponding to the page positions of each input data value in the data entry file; Based on the obtained file number, find the position of the input data value corresponding to the read data value in the file data table. Write the read data values ​​into the data value field of the data row corresponding to the position of the input data value in the data table of the data entry file.

4. The document processing method based on configuration templates according to claim 1, characterized in that, The output file data table is generated based on the pre-generated output file number, the data table for filling in the information, and the data table for output file templates, including: To generate an output file data table, add fields for input file number, output file number, and data value to the output file template data table. The output file template data table includes the following fields: input file template number, output file template number, data item, and output data value layout position. Enter the output file number and the data values ​​corresponding to the same data items in the output file data table into the output file data table.

5. The document processing method based on configuration templates according to claim 4, characterized in that, An output file is generated based on the output file template, and the data values ​​of the corresponding data items in the output file data table are filled into the output file, including: Read the output file template number, output file number, and output data value layout position from the output file data table; An output file is generated based on the output file template corresponding to the output file template number, and the output file number is associated with the output file. Write the data values ​​to the corresponding positions in the output file according to their positions on the page.

6. The document processing method based on configuration templates according to claim 1, characterized in that, Before receiving the user-selected input file template and generating the form based on the input file template and the corresponding input file template data table, the process also includes: Receive input and output file templates uploaded by users; Create an input file template data table based on the input file template; Create an output file template data table based on the output file template.

7. The document processing method based on a configuration template according to any one of claims 1 to 6, characterized in that, One input file template corresponds to one or more output file templates, or multiple input file templates correspond to one output file template.

8. A document processing device based on a configuration template, characterized in that, include: The form generation module is used to receive the input file template selected by the user, generate a form based on the input file template and the corresponding input file template data table, and provide the form to the user by downloading or embedding it into the information system. The input file template data table includes fields: input file template number, output file template number, data item and input data value layout position, and each row corresponds to one data item. The data value corresponding to the data item in the form is empty or a preset formula. The data table writing module for filling in forms is used to receive the form filled in by the user, read the data values ​​of the data items in the form, and write the input file template number, output file template number, data items, input data value page positions and data values ​​in the form into the data table corresponding to the form; The output file data table generation module is used to generate an output file data table based on the pre-generated output file number, the filling file data table, and the output file template data table. The output file generation module is used to generate an output file according to the output file template, fill the data values ​​of the corresponding data items in the output file data table into the output file, and provide the output file to the user by downloading or embedding it into the information system. The input file template data table, output file template data table, filling file data table and output file data table are each stored in the database of the information system according to the data items row by row.

9. The document processing apparatus based on a configuration template according to claim 8, characterized in that, The data entry generation module includes: The input data reading module is used to read the input file template number, data item, and input data value layout position from the input file template data table; The first file generation module is used to generate a filling file based on the input file template corresponding to the input file template number; The file initialization module is used to set the data value corresponding to the data item to empty or a preset formula according to the position of the input data value on the page.

10. The document processing apparatus based on a configuration template according to claim 8, characterized in that, The data table writing module for the data entry file includes: The form number generation module is used to receive the form completed by the user and generate the form number corresponding to the form. The form number is generated when the form is generated or when the user completes the form and uploads it. The form data table is generated after the form number is generated. The first data writing module is used to write the input file template number, output file template number, filling file number, data item and input data value layout position into the filling file data table; The data value reading module is used to read the data values ​​corresponding to the page positions of each input data value in the data entry file; The location lookup module is used to find the position of the input data value on the page corresponding to the read data value in the data table of the data entry file based on the obtained data entry file number; The data value writing module is used to write the read data values ​​into the data value field of the data row corresponding to the position of the input data value in the data table of the data entry file.

Images