CN113919303A - Method and device for automatically generating service information table - Google Patents
Method and device for automatically generating service information table Download PDFInfo
- Publication number
- CN113919303A CN113919303A CN202111286657.5A CN202111286657A CN113919303A CN 113919303 A CN113919303 A CN 113919303A CN 202111286657 A CN202111286657 A CN 202111286657A CN 113919303 A CN113919303 A CN 113919303A
- Authority
- CN
- China
- Prior art keywords
- information table
- service information
- template
- binary
- picture file
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/10—File systems; File servers
- G06F16/11—File system administration, e.g. details of archiving or snapshots
- G06F16/116—Details of conversion of file system types or formats
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/186—Templates
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Stored Programmes (AREA)
Abstract
The invention provides a method and a device for automatically generating a business information table, which can be applied to the field of finance, and the method comprises the following steps: acquiring a service application form in a picture format and converting the service application form into a binary picture file; coding the binary picture file; performing table identification and analysis on the coded binary picture file and writing an analysis result into a database; and generating a service information table according to the analysis result, a pre-stored service information table template and a buried point value preset in the template. The automatic form filling method provided by the application adopts a B/S framework design from a software framework to solve the problems of compatibility, high development, operation and maintenance cost, inconvenience in expansion and the like, and secondly, the automatic form filling method adopts an intelligent identification and automatic generation technology, has high automation degree, reduces the human participation degree, not only improves the working efficiency of the system, but also reduces the error rate.
Description
Technical Field
The present application belongs to the field of software technology, and in particular, to a method and an apparatus for automatically generating a service information table.
Background
At present, when a user transacts loan business in a bank, business personnel manually input hundreds of items of customer information related to the surface signing business by using a surface signing template document which meets business requirements. Ten more sub-templates are shared in the face-to-face signing template, business personnel need to select a plurality of sub-templates according to customer conditions to generate a customer face-to-face signing data template, and then the customer face-to-face signing data template is manually integrated into a complete face-to-face signing data document. This approach has the following drawbacks:
first, the efficiency of business process is not high. The mode of the system for acquiring the customer data needs to be automatically input by the customer, then the customer is verified and confirmed by the service personnel, and then the service personnel manually input the system after confirming no errors, so that the whole process has high manual participation degree, and the existing mature technology is not integrated and used.
Secondly, currently, the related functions of customizing and automatically generating the face-to-face data document are lacked, and business personnel wastes time and labor in integrating the customer data and the printing paper material.
Disclosure of Invention
The application provides a method and a device for automatically generating a business information table, which are used for at least solving the problems that the current business process is low in handling efficiency and depends on more manual operation links.
According to a first aspect of the present application, there is provided a method for automatically generating a service information table, including:
acquiring a service application form in a picture format and converting the service application form into a binary picture file;
coding the binary picture file;
performing table identification and analysis on the coded binary picture file and writing an analysis result into a database;
and generating a service information table according to the analysis result, a pre-stored service information table template and a buried point value preset in the template.
In an embodiment, the encoding processing on the binary picture file specifically includes:
and carrying out 64-bit coding conversion on the binary picture to generate coding parameters.
In an embodiment, performing table identification and parsing on a binary picture file after encoding processing and writing a parsing result into a database includes:
sending the binary image file after the coding processing to an OCR general table recognition background so that the OCR general table recognition background carries out formatting analysis on the binary image file;
and acquiring a return value of the analyzed binary picture file, packaging the return value into a Java object, and writing the Java object into a database.
In an embodiment, generating the service information table according to the parsing result, a pre-stored service information table template and a buried point value preset in the template includes:
converting the analyzed binary picture file into a JSON format;
sending the image file in the JSON format to a pre-stored service information table template;
and positioning according to the embedded point value preset in the template, and filling the content in the JSON format picture into the corresponding positioning embedded point to generate a service information table.
According to the second aspect of the present application, there is also provided an apparatus for automatically generating a service information table, including:
the binary system conversion unit is used for acquiring the service application table in the picture format and converting the service application table into a binary system picture file;
the encoding processing unit is used for encoding the binary picture file;
the analysis writing unit is used for carrying out table identification analysis on the binary picture file after the coding processing and writing an analysis result into a database;
and the table generating unit is used for generating the service information table according to the analysis result, the pre-stored service information table template and the embedded point value preset in the template.
In an embodiment, the encoding processing unit specifically includes:
and the 64-bit coding conversion module is used for carrying out 64-bit coding conversion on the binary picture to generate coding parameters.
In one embodiment, parsing the write unit includes:
the formatting and analyzing module is used for sending the binary image file subjected to the coding processing to an OCR general table recognition background so that the OCR general table recognition background can perform formatting and analyzing on the binary image file;
and the writing module is used for acquiring the return value of the analyzed binary picture file and packaging the return value into a Java object to be written into the database.
In one embodiment, the table generating unit includes:
the JSON format conversion module is used for converting the analyzed binary picture file into a JSON format;
the sending module is used for sending the image file in the JSON format to a pre-stored service information table template;
and the embedded point positioning module is used for positioning according to the embedded point values preset in the template and filling the contents in the JSON format picture into the corresponding positioning embedded point to generate a service information table.
According to a third aspect of the present application, there is also provided an electronic device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, the processor implementing the steps of the method for automatically generating a service information table when executing the program.
According to a fourth aspect of the present application, there is also provided a computer-readable storage medium having stored thereon a computer program which, when executed by a processor, performs the steps of the method of automatically generating a service information table.
From the above, the present application provides a method and an apparatus for automatically generating a service information table, where the method includes: acquiring a service application form in a picture format and converting the service application form into a binary picture file; coding the binary picture file; performing table identification and analysis on the coded binary picture file and writing an analysis result into a database; and generating a service information table according to the analysis result, a pre-stored service information table template and a buried point value preset in the template. According to the method and the device, the picture format of the information table filled by the user is firstly obtained, the picture format is converted into the binary format and is transmitted to the background as the parameter to perform coding processing on the parameter, then the content filled by the user is obtained by performing content identification on the information table in the form of the parameter, meanwhile, the content filled by the user is filled to the corresponding position in the template according to the guidance of the embedded point by setting the embedded point in the preset template, and the automatic generation of the service information table is realized. The method provided by the application can replace manual filling of form data in the banking business handling process, so that the data filling speed is higher, the efficiency is higher, and the problem of manual filling errors is effectively avoided.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, it is obvious that the drawings in the following description are only some embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to the drawings without creative efforts.
Fig. 1 is a flowchart of a method for automatically generating a service information table according to the present application.
Fig. 2 is a flowchart of performing table identification and analysis on a binary picture file after encoding processing in the embodiment of the present application.
Fig. 3 is a flowchart of a method for generating a service information table in the embodiment of the present application.
Fig. 4 is a block diagram of an apparatus for automatically generating a service information table according to the present application.
Fig. 5 is a block diagram of a structure of an analysis write unit in the embodiment of the present application.
Fig. 6 is a block diagram of a table generation unit in the embodiment of the present application.
Fig. 7 is a specific implementation of an electronic device provided in an embodiment of the present application.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
It should be noted that the method and apparatus for automatically generating a business information table disclosed in the present application may be used in the field of financial technology, and may also be used in any field other than the field of financial technology.
The method aims at the problems that when a bank transacts loan face sign business at present, a plurality of information needs to be manually filled in more than ten template forms, and filling is time-consuming, labor-consuming and prone to error. The application provides a method for automatically generating a business information table, a device for automatically generating the business information table, an electronic device and a computer readable storage medium, wherein the method comprises the steps of firstly obtaining a picture format of the information table filled by a user, converting the picture format into a binary format as a parameter, transmitting the binary format to a background to perform coding processing on the parameter, then performing content identification on the information table in the form of the parameter to obtain content filled by the user, and meanwhile, setting a buried point in a preset template to fill the content filled by the user to a corresponding position in the template according to the guidance of the buried point, so that the automatic generation of the business information table is realized. The method provided by the application can replace manual filling of form data in the banking business handling process, so that the data filling speed is higher, the efficiency is higher, and the problem of manual filling errors is effectively avoided.
Based on the above, the present application further provides a device for implementing the method for automatically generating a service information table provided in one or more embodiments of the present application, where the device for automatically generating a service information table may be in communication connection with a client device through a third-party server or the like, so as to receive each service information table automatic generation request sent by each client device.
It is understood that the client devices may include smart phones, tablet electronic devices, network set-top boxes, portable computers, desktop computers, Personal Digital Assistants (PDAs), in-vehicle devices, smart wearable devices, and the like. Wherein, intelligence wearing equipment can include intelligent glasses, intelligent wrist-watch, intelligent bracelet etc..
In another practical application scenario, the aforementioned portion of the apparatus for automatically generating a service information table may be performed in the server as described above, or all operations may be performed in the client device. The selection may be specifically performed according to the processing capability of the client device, the limitation of the user usage scenario, and the like. This is not a limitation of the present application. If all the operations are completed in the client device, the client device may further include a processor for compiling a specific process of analysis of the log.
The client device may have a communication module (i.e., a communication unit), and may be communicatively connected to a remote server to implement data transmission with the server. The server may include a server on the task scheduling center side, and in other implementation scenarios, the server may also include a server on an intermediate platform, for example, a server on a third-party server platform that is communicatively linked to the task scheduling center server. The server may include a single computer device, or may include a server cluster formed by a plurality of servers, or a server structure of a distributed apparatus.
The server and the client device may communicate using any suitable network protocol, including network protocols not yet developed at the filing date of this application. The network protocol may include, for example, a TCP/IP protocol, a UDP/IP protocol, an HTTP protocol, an HTTPS protocol, or the like. Of course, the network Protocol may also include, for example, an RPC Protocol (Remote Procedure Call Protocol), a REST Protocol (Representational State Transfer Protocol), and the like used above the above Protocol.
The following embodiments and application examples are specifically and individually described in detail.
In order to solve the problems in the background art, the present application provides a method for automatically generating a service information table, as shown in fig. 1, including:
s101: and acquiring a service application form in a picture format and converting the service application form into a binary picture file.
S102: and carrying out coding processing on the binary picture file.
S103: and performing table identification and analysis on the coded binary picture file and writing an analysis result into a database.
S104: and generating a service information table according to the analysis result, a pre-stored service information table template and a buried point value preset in the template.
In a specific embodiment, a system for automatically generating a service information table is provided, and the system is built based on a front-end and back-end separation platform of a spring boot background development framework and a vue.js front-end development framework, and is deployed on a PAAS cloud service platform to be provided for a user to use. In the process of automatically generating the service information table, the front end of the system acquires a personal loan application form in a jpg or png picture format shot by a camera through communication with the camera, wherein the application form mainly comprises three contents of basic information of a borrower, basic information of a house purchasing situation and basic loan information, the basic information of the borrower also comprises related personal information of the borrower, such as certificate information, household information and the like, and the loan information mainly comprises the amount, term, guarantee type and the like of loan applied by the borrower. Then the system converts the application form in the picture format into a binary picture file, and transmits the binary picture as a parameter to a back-end controller of the system by using a form object function (FormData) provided by a JavaScript language. The back-end controller of the system obtains the binary picture file, codes the file, sends the file as a parameter to a general form recognition background of the system through an OCR general form recognition interface for recognition, writes the result into a database after obtaining a recognition analysis result, fills the information in the application form in the corresponding position of a service information form template prestored in the system, embeds the buried point in the corresponding position of the service information form, and embeds the information in the position according to the position of the buried point to generate the service information form.
In an embodiment, the encoding processing on the binary picture file specifically includes:
and carrying out 64-bit coding conversion on the binary picture to generate coding parameters.
In a specific embodiment, the back-end controller is responsible for creating an input stream and acquiring a binary image file uploaded from the front end, and the file is encoded by base64 and then uploaded as a parameter to the OCR general table recognition background so as to be analyzed and recognized.
In an embodiment, performing table identification and parsing on the binary picture file after the encoding process and writing a parsing result into a database, as shown in fig. 2, includes:
s201: and sending the binary image file subjected to coding processing to an OCR general table recognition background so that the OCR general table recognition background carries out formatting analysis on the binary image file.
S202: and acquiring a return value of the analyzed binary picture file, packaging the return value into a Java object, and writing the Java object into a database.
In a specific embodiment, the file is encoded by base64 and then is used as a parameter to be uploaded to an OCR general table recognition background so that the file is analyzed and recognized to obtain a return value, the return value is returned to the front end through an OCR general recognition interface, the return value is the formatted analysis of the content in the previously uploaded picture file, and the return value is packaged into a Java object to be put into storage. And simultaneously, returning the analysis result to the front end in JSON format data, and automatically backfilling various information into a corresponding input box of the front end page by a data attribute bidirectional binding mechanism of the VUE through a front end framework.
In an embodiment, generating the service information table according to the parsing result, the pre-stored service information table template and the embedded point value preset in the template, as shown in fig. 3, includes:
s301: and converting the analyzed binary picture file into a JSON format.
S302: and sending the image file in the JSON format to a pre-stored service information table template.
S303: and positioning according to the embedded point value preset in the template, and filling the content in the JSON format picture into the corresponding positioning embedded point to generate a service information table.
In a specific embodiment, the returned value is encapsulated into a Java object for warehousing operation, and the analysis result is returned to the front end in JSON format data, and the data attribute bidirectional binding mechanism of the VUE automatically backfills various information into the corresponding input boxes of the front end page through the front end framework.
After receiving an instruction for generating a service information table, the system firstly performs library writing operation to store data, and then performs embedded point value replacement operation through a prestored template in an XWPFDcolumn object Word format provided by the JAVA POI technology by using a JAVA POI technology, and the specific steps are as follows: firstly, presetting a buried point value at a position of a pre-stored template needing to be automatically filled with information, wherein the buried point comprises a text buried point and a table buried point; secondly, acquiring customer data which are input into the system before through database checking, and storing the customer data in a Map set, wherein a Key value in the Map set corresponds to the buried point value; thirdly, traversing and acquiring each line in the template document by using the XWPFDockent object, nesting and traversing a Map set in each line, and replacing a text buried point value or a table buried point value matched with a key value in the Map set with a value mapped by the key value; and finally, traversing the selected template items, sequentially merging the selected template items into a document object in sequence, wherein the merging among the templates uses an interface provided by the XWPFDcolumn object for creating a new paragraph text to ensure that the format of each template is not influenced by the formats of the upper template and the lower template, and the system exports the final XWPFDcolumn document object into a WPS format file through a Java input output stream technology.
The automatic form filling method provided by the application adopts a B/S framework design from a software framework to solve the problems of compatibility, high development, operation and maintenance cost, inconvenience in expansion and the like, and secondly, the automatic form filling method adopts an intelligent identification and automatic generation technology, has high automation degree, reduces the human participation degree, not only improves the working efficiency of the system, but also reduces the error rate.
Based on the same inventive concept, the embodiment of the present application further provides a device for automatically generating a service information table, which can be used to implement the method described in the above embodiment, as described in the following embodiment. The principle of solving the problem of the device for automatically generating the business information table is similar to that of the method for automatically generating the business information table. As used hereinafter, the term "unit" or "module" may be a combination of software and/or hardware that implements a predetermined function. While the system described in the embodiments below is preferably implemented in software, implementations in hardware, or a combination of software and hardware are also possible and contemplated.
According to the second aspect of the present application, there is also provided an apparatus for automatically generating a service information table, as shown in fig. 4, including:
a binary conversion unit 401, configured to obtain a service application table in a picture format and convert the service application table into a binary picture file;
an encoding processing unit 402 configured to perform encoding processing on the binary picture file;
an analysis writing unit 403, configured to perform table identification analysis on the binary image file after the encoding processing, and write an analysis result into a database;
a table generating unit 404, configured to generate a service information table according to the analysis result, a pre-stored service information table template, and a buried point value preset in the template.
In a specific embodiment, a system for automatically generating a service information table is provided, and the system is built based on a front-end and back-end separation platform of a spring boot background development framework and a vue.js front-end development framework, and is deployed on a PAAS cloud service platform to be provided for a user to use. In the process of automatically generating the service information table, the front end of the system acquires a personal loan application form in a jpg or png picture format shot by a camera through communication with the camera, wherein the application form mainly comprises three contents of basic information of a borrower, basic information of a house purchasing situation and basic loan information, the basic information of the borrower also comprises related personal information of the borrower, such as certificate information, household information and the like, and the loan information mainly comprises the amount, term, guarantee type and the like of loan applied by the borrower. Then the system converts the application form in the picture format into a binary picture file, and transmits the binary picture as a parameter to a back-end controller of the system by using a form object function (FormData) provided by a JavaScript language. And a back-end controller of the system acquires a binary image file, encodes the binary image file, sends the encoded binary image file as a parameter to a general form recognition background of the system through an OCR general form recognition interface for recognition, writes the result into a database after acquiring a recognition analysis result, and fills information in an application form in a corresponding position of a service information form template prestored in the system.
In an embodiment, the encoding processing unit 402 specifically includes:
and the 64-bit coding conversion module is used for carrying out 64-bit coding conversion on the binary picture to generate coding parameters.
In a specific embodiment, the back-end controller is responsible for creating an input stream and acquiring a binary image file uploaded from the front end, and the file is encoded by base64 and then uploaded as a parameter to the OCR general table recognition background so as to be analyzed and recognized.
In one embodiment, as shown in fig. 5, the parsing write unit 403 includes:
the formatting and parsing module 501 is configured to send the encoded binary image file to an OCR general table recognition background, so that the OCR general table recognition background performs formatting and parsing on the binary image file;
and a write-in module 502, configured to obtain a return value of the parsed binary picture file, and encapsulate the return value into a Java object, which is written into the database.
In a specific embodiment, the file is encoded by base64 and then is used as a parameter to be uploaded to an OCR general table recognition background so that the file is analyzed and recognized to obtain a return value, the return value is returned to the front end through an OCR general recognition interface, the return value is the formatted analysis of the content in the previously uploaded picture file, and the return value is packaged into a Java object to be put into storage. And simultaneously, returning the analysis result to the front end in JSON format data, and automatically backfilling various information into a corresponding input box of the front end page by a data attribute bidirectional binding mechanism of the VUE through a front end framework.
In one embodiment, as shown in fig. 6, the table generating unit 404 includes:
a JSON format conversion module 601, configured to convert the parsed binary picture file into a JSON format;
a sending module 602, configured to send the image file in the JSON format to a pre-stored service information table template;
and the buried point positioning module 603 is configured to perform positioning according to a buried point value preset in the template, and fill the content in the JSON-format picture into the corresponding positioning buried point to generate a service information table.
In a specific embodiment, the returned value is encapsulated into a Java object for warehousing operation, and the analysis result is returned to the front end in JSON format data, and the data attribute bidirectional binding mechanism of the VUE automatically backfills various information into the corresponding input boxes of the front end page through the front end framework.
After receiving an instruction of generating a business information table, the system firstly performs shoe library operation to store data, then performs embedded point value replacement operation through a prestored template in XWPFDcolumn object Word format provided by the JAVA POI technology, and comprises the following specific steps: firstly, presetting a buried point value at a position of a pre-stored template needing to be automatically filled with information, wherein the buried point comprises a text buried point and a table buried point; secondly, acquiring customer data which are input into the system before through database checking, and storing the customer data in a Map set, wherein a Key value in the Map set corresponds to the buried point value; thirdly, traversing and acquiring each line in the template document by using the XWPFDockent object, nesting and traversing a Map set in each line, and replacing a text buried point value or a table buried point value matched with a key value in the Map set with a value mapped by the key value; and finally, traversing the selected template items, sequentially merging the selected template items into a document object in sequence, wherein the merging among the templates uses an interface provided by the XWPFDcolumn object for creating a new paragraph text to ensure that the format of each template is not influenced by the formats of the upper template and the lower template, and the system exports the final XWPFDcolumn document object into a WPS format file through a Java input output stream technology.
According to the method and the device, the picture format of the information table filled by the user is firstly obtained, the picture format is converted into the binary format and is transmitted to the background as the parameter to perform coding processing on the parameter, then the content filled by the user is obtained by performing content identification on the information table in the form of the parameter, meanwhile, the content filled by the user is filled to the corresponding position in the template according to the guidance of the embedded point by setting the embedded point in the preset template, and the automatic generation of the service information table is realized. The method provided by the application can replace manual filling of form data in the banking business handling process, so that the data filling speed is higher, the efficiency is higher, and the problem of manual filling errors is effectively avoided.
As will be appreciated by one skilled in the art, embodiments of the present invention may be provided as a method, system, or computer program product. Accordingly, the present invention may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present invention may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.
The present invention is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of the invention. It will be understood that each flow and/or block of the flow diagrams and/or block diagrams, and combinations of flows and/or blocks in the flow diagrams and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
The principle and the implementation mode of the invention are explained by applying specific embodiments in the invention, and the description of the embodiments is only used for helping to understand the method and the core idea of the invention; meanwhile, for a person skilled in the art, according to the idea of the present invention, there may be variations in the specific embodiments and the application scope, and in summary, the content of the present specification should not be construed as a limitation to the present invention.
An embodiment of the present application further provides a specific implementation manner of an electronic device capable of implementing all steps in the method in the foregoing embodiment, and referring to fig. 7, the electronic device specifically includes the following contents:
a processor (processor)701, a memory 702, a communication Interface 703, a bus 704, and a nonvolatile memory 705;
the processor 701, the memory 702 and the communication interface 703 complete mutual communication through the bus 704;
the processor 701 is configured to call the computer programs in the memory 702 and the nonvolatile memory 705, and when the processor executes the computer programs, the processor implements all the steps in the method in the foregoing embodiments, for example, when the processor executes the computer programs, the processor implements the following steps:
s101: and acquiring a service application form in a picture format and converting the service application form into a binary picture file.
S102: and carrying out coding processing on the binary picture file.
S103: and performing table identification and analysis on the coded binary picture file and writing an analysis result into a database.
S104: and generating a service information table according to the analysis result, a pre-stored service information table template and a buried point value preset in the template.
Embodiments of the present application also provide a computer-readable storage medium capable of implementing all the steps of the method in the above embodiments, where the computer-readable storage medium stores thereon a computer program, and the computer program when executed by a processor implements all the steps of the method in the above embodiments, for example, the processor implements the following steps when executing the computer program:
s101: and acquiring a service application form in a picture format and converting the service application form into a binary picture file.
S102: and carrying out coding processing on the binary picture file.
S103: and performing table identification and analysis on the coded binary picture file and writing an analysis result into a database.
S104: and generating a service information table according to the analysis result, a pre-stored service information table template and a buried point value preset in the template.
The embodiments in the present specification are described in a progressive manner, and the same and similar parts among the embodiments are referred to each other, and each embodiment focuses on the differences from the other embodiments. In particular, for the hardware + program class embodiment, since it is substantially similar to the method embodiment, the description is simple, and the relevant points can be referred to the partial description of the method embodiment. Although embodiments of the present description provide method steps as described in embodiments or flowcharts, more or fewer steps may be included based on conventional or non-inventive means. The order of steps recited in the embodiments is merely one manner of performing the steps in a multitude of orders and does not represent the only order of execution. When an actual apparatus or end product executes, it may execute sequentially or in parallel (e.g., parallel processors or multi-threaded environments, or even distributed data processing environments) according to the method shown in the embodiment or the figures. The terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, the presence of additional identical or equivalent elements in a process, method, article, or apparatus that comprises the recited elements is not excluded. For convenience of description, the above devices are described as being divided into various modules by functions, and are described separately. Of course, in implementing the embodiments of the present description, the functions of each module may be implemented in one or more software and/or hardware, or a module implementing the same function may be implemented by a combination of multiple sub-modules or sub-units, and the like. The above-described embodiments of the apparatus are merely illustrative, and for example, the division of the units is only one logical division, and other divisions may be realized in practice, for example, a plurality of units or components may be combined or integrated into another system, or some features may be omitted, or not executed. In addition, the shown or discussed mutual coupling or direct coupling or communication connection may be an indirect coupling or communication connection through some interfaces, devices or units, and may be in an electrical, mechanical or other form. The present invention is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of the invention. It will be understood that each flow and/or block of the flow diagrams and/or block diagrams, and combinations of flows and/or blocks in the flow diagrams and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks. As will be appreciated by one skilled in the art, embodiments of the present description may be provided as a method, system, or computer program product. Accordingly, embodiments of the present description may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, embodiments of the present description may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and so forth) having computer-usable program code embodied therein. The embodiments in the present specification are described in a progressive manner, and the same and similar parts among the embodiments are referred to each other, and each embodiment focuses on the differences from the other embodiments. In particular, for the system embodiment, since it is substantially similar to the method embodiment, the description is simple, and for the relevant points, reference may be made to the partial description of the method embodiment. In the description herein, references to the description of the term "one embodiment," "some embodiments," "an example," "a specific example," or "some examples," etc., mean that a particular feature, structure, material, or characteristic described in connection with the embodiment or example is included in at least one embodiment or example of an embodiment of the specification. In this specification, the schematic representations of the terms used above are not necessarily intended to refer to the same embodiment or example. Furthermore, various embodiments or examples and features of different embodiments or examples described in this specification can be combined and combined by one skilled in the art without contradiction. The above description is only an example of the embodiments of the present disclosure, and is not intended to limit the embodiments of the present disclosure. Various modifications and variations to the embodiments described herein will be apparent to those skilled in the art. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the embodiments of the present specification should be included in the scope of the claims of the embodiments of the present specification.
Claims (10)
1. A method for automatically generating a service information table is characterized by comprising the following steps:
acquiring a service application form in a picture format and converting the service application form into a binary picture file;
coding the binary picture file;
performing table identification and analysis on the binary picture file after the coding processing, and writing an analysis result into a database;
and generating a service information table according to the analysis result, a pre-stored service information table template and a buried point value preset in the template.
2. The method for automatically generating a service information table according to claim 1, wherein the encoding of the binary picture file specifically includes:
and carrying out 64-bit coding conversion on the binary picture to generate coding parameters.
3. The method according to claim 1, wherein the performing table identification analysis on the encoded binary picture file and writing the analysis result into a database includes:
sending the binary image file after the coding processing to an OCR general table recognition background so that the OCR general table recognition background carries out formatting analysis on the binary image file;
and acquiring a return value of the analyzed binary picture file, and packaging the return value into a Java object to be written into a database.
4. The method according to claim 1, wherein the generating a service information table according to the parsing result, a pre-stored service information table template and a buried point value preset in the template comprises:
converting the analyzed binary picture file into a JSON format;
sending the image file in the JSON format to a pre-stored service information table template;
and positioning according to the embedded point value preset in the template, and filling the content in the JSON format picture into the corresponding positioning embedded point to generate a service information table.
5. An apparatus for automatically generating a service information table, comprising:
the binary system conversion unit is used for acquiring the service application table in the picture format and converting the service application table into a binary system picture file;
the encoding processing unit is used for encoding the binary picture file;
the analysis writing unit is used for carrying out table identification analysis on the binary picture file after the coding processing and writing an analysis result into a database;
and the table generating unit is used for generating a service information table according to the analysis result, a pre-stored service information table template and a buried point value preset in the template.
6. The apparatus for automatically generating a service information table according to claim 5, wherein the encoding processing unit specifically includes:
and the 64-bit coding conversion module is used for carrying out 64-bit coding conversion on the binary picture to generate coding parameters.
7. The apparatus for automatically generating service information table according to claim 5, wherein the parsing writing unit comprises:
the formatting and analyzing module is used for sending the binary image file subjected to coding processing to an OCR general table recognition background so that the OCR general table recognition background can perform formatting and analyzing on the binary image file;
and the writing module is used for acquiring the return value of the analyzed binary picture file and packaging the return value into a Java object to be written into the database.
8. The apparatus for automatically generating service information table according to claim 5, wherein the table generating unit comprises:
the JSON format conversion module is used for converting the analyzed binary picture file into a JSON format;
the sending module is used for sending the image file in the JSON format to a pre-stored service information table template;
and the embedded point positioning module is used for positioning according to the embedded point values preset in the template and filling the contents in the JSON format picture into the corresponding positioning embedded point to generate a service information table.
9. An electronic device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, wherein the processor implements the steps of the method of automatically generating a service information table according to any one of claims 1 to 4 when executing the program.
10. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out the steps of the method for automatically generating a service information table according to any one of claims 1 to 4.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111286657.5A CN113919303A (en) | 2021-11-02 | 2021-11-02 | Method and device for automatically generating service information table |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111286657.5A CN113919303A (en) | 2021-11-02 | 2021-11-02 | Method and device for automatically generating service information table |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN113919303A true CN113919303A (en) | 2022-01-11 |
Family
ID=79244851
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202111286657.5A Pending CN113919303A (en) | 2021-11-02 | 2021-11-02 | Method and device for automatically generating service information table |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113919303A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115294588A (en) * | 2022-08-17 | 2022-11-04 | 湖北鑫英泰系统技术股份有限公司 | Data processing method and system based on RPA process robot |
| CN115618841A (en) * | 2022-11-29 | 2023-01-17 | 明度智云(浙江)科技有限公司 | Document export method, device, equipment and storage medium |
-
2021
- 2021-11-02 CN CN202111286657.5A patent/CN113919303A/en active Pending
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115294588A (en) * | 2022-08-17 | 2022-11-04 | 湖北鑫英泰系统技术股份有限公司 | Data processing method and system based on RPA process robot |
| CN115294588B (en) * | 2022-08-17 | 2024-04-19 | 湖北鑫英泰系统技术股份有限公司 | Data processing method and system based on RPA flow robot |
| CN115618841A (en) * | 2022-11-29 | 2023-01-17 | 明度智云(浙江)科技有限公司 | Document export method, device, equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN113919303A (en) | Method and device for automatically generating service information table | |
| CN101661512B (en) | System and method for identifying traditional form information and establishing corresponding Web form | |
| CN104484171A (en) | System, method and associated equipment for designing terminal interface | |
| CN110765102B (en) | Service data processing method and device, computer equipment and storage medium | |
| CN104123364A (en) | Method and device for transmitting and receiving data through mobile terminal | |
| CN113434175B (en) | Data processing method, device, storage medium and equipment | |
| CN111722947A (en) | Service calling method and system | |
| CN109818962A (en) | Business data processing method and device, electronic equipment, storage medium | |
| CN111651140B (en) | Service method and device based on workflow | |
| CN109508282A (en) | Bury the setting method and device, computer storage medium, electronic equipment of point identification | |
| CN112417515A (en) | Configuration software protocol processing method and system | |
| CN116992081A (en) | Page form data processing method and device and user terminal | |
| CN112035401A (en) | Model data processing method and device, electronic equipment and readable medium | |
| CN108829383A (en) | A kind of data processing method and device of interface separation | |
| CN103577260A (en) | Work scheduling method and system for cloud platform | |
| CN107368557B (en) | Page editing method and device | |
| CN110334142B (en) | Intelligent data acquisition method, terminal, server and interaction system | |
| CN105808549A (en) | Client method for automatic framing and frame analysis on basis of mapping files | |
| CN113485942A (en) | Automatic testing method and device based on independent module | |
| CN114492324A (en) | Component data statistical method and device | |
| CN111010366A (en) | Data transmission method and system based on reverse isolation technology | |
| CN113110829A (en) | Multi-UI component library data processing method and device | |
| CN103840858B (en) | Data capture method and Common Information Model CIM service end | |
| CN111008346A (en) | Data acquisition method and device | |
| CN114579132A (en) | Conversion file generation method and device, electronic equipment and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |