CN111950248A - XML-based product report generation method and system - Google Patents
XML-based product report generation method and system Download PDFInfo
- Publication number
- CN111950248A CN111950248A CN202010793856.4A CN202010793856A CN111950248A CN 111950248 A CN111950248 A CN 111950248A CN 202010793856 A CN202010793856 A CN 202010793856A CN 111950248 A CN111950248 A CN 111950248A
- Authority
- CN
- China
- Prior art keywords
- product
- file
- data
- xml
- preset
- 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.)
- Granted
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/186—Templates
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/103—Formatting, i.e. changing of presentation of documents
- G06F40/106—Display of layout of documents; Previewing
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/12—Use of codes for handling textual entities
- G06F40/14—Tree-structured documents
- G06F40/143—Markup, e.g. Standard Generalized Markup Language [SGML] or Document Type Definition [DTD]
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02P—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
- Y02P90/00—Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
- Y02P90/30—Computing systems specially adapted for manufacturing
Abstract
The invention provides a method and a system for generating a product report based on XML, wherein the method comprises the following steps: acquiring product operation flow data from a plurality of product correlation systems, and storing the operation flow data into a data lake; extracting product key field information from the data lake according to a preset product disclosure calendar and a preset XML standard template file, and supplementing the product key field information into the preset XML standard template file to generate an XML instance data file; analyzing corresponding variable information in the XML instance data file through a template engine according to the keyword identification in a preset output template file, and obtaining an output text according to the variable information and the preset output template file; and adjusting the display format of the output text through a preset CSS stack style file to obtain a product report file.
Description
Technical Field
The invention relates to the field of big data, in particular to a product report generation method and a product report generation system based on XML, which can be applied to the financial field or other fields.
Background
With the increase of income level and the strengthening of financial consciousness, people devote more funds to financial products issued by financial institutions. The financial institution fully, timely and accurately reveals product operation information to investors according to the requirements of a supervision institution, is legal obligation which the financial institution should follow, and is also a basic principle of information disclosure.
The financial product operation generally comprises the processes of product, sale, investment, wind control, valuation and the like, different professional systems of financial institutions provide support operation, and product operation information needs to be integrated and dispersed in various professional systems, but the data are dispersed and stored in different formats, so that investors cannot effectively and quickly acquire the information, and risks such as information omission are easily caused; the mode of uniformly collecting, arranging and releasing by workers can lead to large workload of manpower and large requirements on the professional property and the working timeliness of the workers; therefore, there is a need in the art for a report generation method and system that unifies information disclosure formats around key information key fields, timely discloses and reveals related information to investors and regulatory agencies, enhances the transparency of financial products, and protects the acquaintances of investors, so as to provide more comprehensive product information to investors more efficiently.
Disclosure of Invention
The invention aims to provide a universal and efficient XML-based product report generation method and system, which can timely and comprehensively collect operation data of various products among different systems and arrange the operation data into a same data source so that investors can timely know the product report information.
In order to achieve the above object, the present invention provides a method for generating an XML-based product report, the method comprising: acquiring product operation flow data from a plurality of product correlation systems, and storing the operation flow data into a data lake; extracting product key field information from the data lake according to a preset product disclosure calendar and a preset XML standard template file, and supplementing the product key field information into the preset XML standard template file to generate an XML instance data file; analyzing corresponding variable information in the XML instance data file through a template engine according to the keyword identification in a preset output template file, and obtaining an output text according to the variable information and the preset output template file; and adjusting the display format of the output text through a preset CSS stack style file to obtain a product report file.
In the above method for generating an XML-based product report, preferably, the method further includes: carrying out data cleaning on the XML instance data file according to a preset rule, and identifying data information to be supplemented; and acquiring corresponding data in a product association system according to the data information to be supplemented and supplementing the corresponding data into the XML instance data file.
In the above method for generating an XML-based product report, preferably, the data cleaning of the XML instance data file according to a preset rule further includes: and clearing invalid data in the XML instance data file according to the relevance and timeliness of the data.
In the above method for generating an XML-based product report, preferably, the extracting key field information of a product from the data lake according to a preset product disclosure calendar and a preset XML standard template file includes: acquiring a collection time node according to a preset product disclosure calendar; obtaining a product report disclosure field list and a product report key field according to a preset XML standard template file; and extracting product key field information corresponding to products in the data lake at a collection time node according to the product report disclosure field list and the product report key field.
In the above method for generating a product report based on XML, preferably, the obtaining a product report file by adjusting the presentation format of the output text through a preset CSS stack style file further includes: acquiring one or more report file format requirements, and calling a preset format conversion component according to the report file format requirements; and converting the product report file into a format corresponding to the report file format requirement through the format conversion component and then outputting the converted product report file.
In the above method for generating an XML-based product report, preferably, the method further includes: presetting an output template file as an HTML report template file; the product report file conversion format comprises one or more of a combination of written text format, PDF file format and HTML page format.
The invention also provides a product report generating system based on XML, which comprises an acquisition module, an instance data extraction module and a text generating module; the acquisition module is used for acquiring product operation flow data from a plurality of product correlation systems and storing the operation flow data into a data lake; the example data extraction module is used for extracting product key field information from the data lake according to a preset product disclosure calendar and a preset XML standard template file, and supplementing the product key field information into the preset XML standard template file to generate an XML example data file; the text generation module is used for analyzing corresponding variable information in the XML instance data file through a template engine according to keyword identification in a preset output template file, and obtaining an output text according to the variable information and the preset output template file; and adjusting the display format of the output text through a preset CSS cascading style file to obtain a product report file.
In the above embodiment, the instance data extraction module further includes a cleaning module, where the cleaning module is configured to perform data cleaning on the XML instance data file according to a preset rule, and identify data information to be supplemented; and acquiring corresponding data in a product association system according to the data information to be supplemented and supplementing the corresponding data into the XML instance data file.
In the above XML-based product report generating system, preferably, the instance data extracting module includes an extracting unit; the extraction unit is used for obtaining a collection time node according to a preset product disclosure calendar; obtaining a product report disclosure field list and a product report key field according to a preset XML standard template file; and extracting product key field information corresponding to products in the data lake at a collection time node according to the product report disclosure field list and the product report key field.
In the above XML-based product report generating system, preferably, the system further includes an output display module, where the output display module is configured to obtain one or more report file format requirements, and invoke a preset format conversion component according to the report file format requirements; and converting the product report file into a format corresponding to the report file format requirement through the format conversion component and then outputting the converted product report file.
The invention also provides 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 method when executing the computer program.
The present invention also provides a computer-readable storage medium storing a computer program for executing the above method.
The invention has the beneficial technical effects that: the standardization of product reports and disclosure key information is realized, and the formats and contents of various financial product information disclosures are unified; the product report content format can meet the requirement of convenient addition according to the actual situation, adapt to the change in time and dynamically expand the key fields of the revealed key information, and simultaneously avoid the missing of the key fields of the revealed key information.
Drawings
The accompanying drawings, which are included to provide a further understanding of the invention and are incorporated in and constitute a part of this application, illustrate embodiment(s) of the invention and together with the description serve to explain the principles of the invention. In the drawings:
FIG. 1 is a flowchart illustrating a method for generating an XML-based product report according to an embodiment of the present invention;
FIG. 2 is a schematic diagram illustrating a method for generating an XML-based product report according to an embodiment of the present invention;
FIG. 3 is a flowchart illustrating a process of extracting key field information of a product according to an embodiment of the present invention;
FIG. 4 is a schematic diagram of an XML listing file of product formation report and product expiration report disclosure information according to an embodiment of the present invention;
FIG. 5 is a schematic diagram of a product expiration report HTML template provided in accordance with an embodiment of the present invention;
fig. 6 is a schematic diagram of a style description template process in a CSS stack style file according to an embodiment of the present invention;
FIG. 7 is a schematic structural diagram of an XML-based product report generation system according to an embodiment of the present invention;
fig. 8 is a schematic structural diagram of an electronic device according to an embodiment of the present invention.
Detailed Description
The following detailed description of the embodiments of the present invention will be provided with reference to the drawings and examples, so that how to apply the technical means to solve the technical problems and achieve the technical effects can be fully understood and implemented. It should be noted that, unless otherwise specified, the embodiments and features of the embodiments of the present invention may be combined with each other, and the technical solutions formed are within the scope of the present invention.
Additionally, the steps illustrated in the flow charts of the figures may be performed in a computer system such as a set of computer-executable instructions and, although a logical order is illustrated in the flow charts, in some cases, the steps illustrated or described may be performed in an order different than here.
Referring to fig. 1, a method for generating an XML-based product report according to the present invention includes:
s101, acquiring product operation flow data from a plurality of product correlation systems, and storing the operation flow data into a data lake;
s102, extracting product key field information from the data lake according to a preset product disclosure calendar and a preset XML standard template file, and supplementing the product key field information into the preset XML standard template file to generate an XML instance data file;
s103, analyzing corresponding variable information in the XML instance data file through a template engine according to the keyword identification in the preset output template file, and obtaining an output text according to the variable information and the preset output template file;
s104, adjusting the display format of the output text through a preset CSS cascading style file to obtain a product report file.
In practical work, the preset output template file may be an HTML report template file, the product report generation method may refer to fig. 2 when applied, and mainly includes entering a lake by data of each professional system, setting a product disclosure calendar, a product report template and disclosure key information key fields in advance in a report management system by a service manager, extracting the product key information key fields according to the product disclosure key information key fields identified by XML by the system on a preset disclosure date of a product, processing the product disclosure key information key fields into a product disclosure XML information file, cleaning, supplementing and cleaning dirty data by the system and the service manager, combining a preset report format HTML template file and a CSS stack style file, calling a related component package, analyzing the XML information file and converting into a written text, a PDF file, an HTML page and other format product report files, the product report is approved and then sent to an information disclosure channel; the detailed implementation of each step is described in detail with reference to the following examples.
Referring to fig. 3, in an embodiment of the present invention, extracting product key field information from the data lake according to a preset product disclosure calendar and a preset XML standard template file includes:
s301, acquiring a collection time node according to a preset product disclosure calendar;
s302, obtaining a product report disclosure field list and a product report key field according to a preset XML standard template file;
s303, extracting product key field information corresponding to products in the data lake from a collection time node according to the product report disclosure field list and the product report key field.
In the above embodiments, the product disclosure calendar is mainly used for starting a product report disclosure process on a specified date, and the common disclosure calendars include a product establishment date, a product expiration date, a regular calendar (month end, quarter end, half year end, and year end) of a product life period, and an irregular disclosure report. The product report disclosure field list file mainly describes key information key fields required by product report disclosure, is stored in an XML format record file, can be dynamically expanded and synchronized to a data lake as a basis for extracting key information of a product in the data lake. Wherein, the product formation report and the product expiration report disclosure information XML manifest file can refer to fig. 4 and 5; in actual work, the financial product operation comprises the processes of product, sales, research, wind control, valuation and the like, different professional systems of financial institutions provide support operation, data of the professional systems enter the lake, meanwhile, a product report disclosure calendar and a product report disclosure field list preset by a business management worker in a report management system are synchronously pushed to the data lake, and a uniform data source is provided for data processing such as subsequent product key information extraction. In the process of processing key fields of product report key information, an XML extensible markup language is adopted to mark a product report disclosure field list and product report key fields, when key information is processed and extracted, specific product related information and fields can be inquired according to a product report disclosure XML list file, a product report XML initial information file is exported, and if tags are added or reduced in the XML list file, the content of extracted data fields changes accordingly. Therefore, the method has the following advantages: 1. the standardization of key fields for disclosing the key information is realized, and the format and the content of information disclosure of various financial products are unified. 2. The extensibility of the key field of the disclosure key information is realized, and new identification and attribute names can be defined according to the latest disclosure requirement. 3. And the document structure nesting of the XML realizes the identification of object level hierarchies such as complex nesting disclosure information and the like. 4. For the fixed text content of the disclosure report, redundant storage is reduced, information supply cost is reduced, and data transmission is facilitated.
With the fusion development of big data technology, financial institutions actively promote the construction of data lakes, the data lakes gradually develop into a system which can store all structured and unstructured data of any scale, can operate big data tools of different types and process big data, and synchronous data copying with a source system is realized through a high-timeliness data exchange system at present; by extracting key information key fields of the product report from the data lake, the difference between different professional systems of the whole product operation process can be shielded, and a uniform data platform is provided for comprehensively, fully and timely disclosing the product report; however, since the data is extracted automatically, there is also some error information, and therefore, in an embodiment of the present invention, the method may further include: carrying out data cleaning on the XML instance data file according to a preset rule, and identifying data information to be supplemented; collecting corresponding data in a product correlation system according to data information to be supplemented and supplementing the corresponding data into the XML instance data file; wherein, the data cleaning of the XML instance data file according to the preset rule further comprises: and clearing invalid data in the XML instance data file according to the relevance and timeliness of the data.
Specifically, after a related system for report management receives product disclosure information marked by an XML, that is, a product report XML initial information file, a service manager needs to perform data cleaning according to key information key fields displayed by a specific product report, the system already performs data cleaning according to a certain rule, submits a filtered result to a service supervisor, and highlights content to be supplemented. The service supervisor mainly processes invalid values and missing values of the data. The data are extracted from a plurality of business systems and comprise historical data, the data can be missing due to timeliness, some data can be error data, and some data have conflict with each other, namely 'dirty data', and the data need to be subjected to data clearing processing and converted into a product report XML information file. The above processes of cleaning, filling and removing dirty data can be implemented by using the existing method, and the present invention is not described in detail herein.
In an embodiment of the present invention, adjusting the presentation format of the output text by using a preset CSS stack style file to obtain a product report file further includes: acquiring one or more report file format requirements, and calling a preset format conversion component according to the report file format requirements; and converting the product report file into a format corresponding to the report file format requirement through the format conversion component and then outputting the converted product report file. Wherein, the product report file conversion format comprises one or more combinations of written text format, PDF file format and HTML page format. Therefore, the XML information file of the product report is analyzed, and the related component package is called and converted into the product report in the format of written characters, PDF files, HTML pages and the like by combining the preset report format HTML template file and the CSS cascading style sheet. In actual work, the CSS cascading style file is adopted to adjust the output text to refer to a createddf.cs file, a style description is provided for the HTML report template file, and is used for describing the format and display mode of information on a web page, and the style description includes rules for applying the style to elements of a specified type, which can be specifically referred to as fig. 6.
Referring to fig. 7, the present invention further provides a product report generating system based on XML, where the system includes an acquisition module, an instance data extraction module, and a text generation module; the acquisition module is used for acquiring product operation flow data from a plurality of product correlation systems and storing the operation flow data into a data lake; the example data extraction module is used for extracting product key field information from the data lake according to a preset product disclosure calendar and a preset XML standard template file, and supplementing the product key field information into the preset XML standard template file to generate an XML example data file; the text generation module is used for analyzing corresponding variable information in the XML instance data file through a template engine according to keyword identification in a preset output template file, and obtaining an output text according to the variable information and the preset output template file; and adjusting the display format of the output text through a preset CSS cascading style file to obtain a product report file. Wherein the product association system may include a product system, a sales system, a commissioning system, a wind control system, and an evaluation system.
In the above embodiment, the instance data extraction module further includes a cleaning module, where the cleaning module is configured to perform data cleaning on the XML instance data file according to a preset rule, and identify data information to be supplemented; and acquiring corresponding data in a product association system according to the data information to be supplemented and supplementing the corresponding data into the XML instance data file. Specifically, after receiving the XML instance data file of the product report, the service manager may perform data cleaning according to the key information key fields displayed by the specific product report, submit the filtered result to the staff, and highlight the content to be supplemented. Invalid values and missing values of data are processed by staff, the data can be extracted from a plurality of business systems and comprise historical data, the data can be missing due to timeliness, some data can be wrong data, some data have conflict with each other, namely 'dirty data', data clearing processing is needed to be carried out, and the data are converted into a final XML instance data file.
In an embodiment of the invention, the example data extraction module may include an extraction unit; the extraction unit is used for obtaining a collection time node according to a preset product disclosure calendar; obtaining a product report disclosure field list and a product report key field according to a preset XML standard template file; and extracting product key field information corresponding to products in the data lake at a collection time node according to the product report disclosure field list and the product report key field. In actual work, when key information is extracted in big data processing, a product report disclosure XML list file can be adjusted according to actual needs to inquire specific product related information and fields, and an XML initial information file of a product report is exported, wherein if tags are added or reduced in the XML list file, the content of the extracted data fields changes accordingly.
In an embodiment of the present invention, the system may further include an output display module, where the output display module is configured to obtain one or more report file format requirements, and invoke a preset format conversion component according to the report file format requirements; and converting the product report file into a format corresponding to the report file format requirement through the format conversion component and then outputting the converted product report file. In actual work, after a product report XML initial information file, namely a primary XML example data file, is cleaned and converted into a product report XML information file, namely a final XML example data file, the system calls a related component package according to instructions of service managers by combining a report format HTML template file and a CSS (cascading style document), analyzes the XML file and converts the XML file into a product report file with written characters, a PDF (Portable document Format) file, an HTML page and other formats; the building blocks can be realized by format conversion components in the prior art, and the invention is not described in detail here.
The invention provides a method and a system for generating a product report based on XML, which comprises the steps of presetting a product disclosure calendar, a product report template and a disclosure field list, enabling professional system data, the product disclosure calendar and the disclosure field list to enter the lake, extracting key fields of product key information according to key fields of product disclosure key information identified by XML on a preset disclosure date of a product, processing the key fields of the product into a product disclosure XML information file, sending the product disclosure XML information file to a report management system, washing the product by data of a system and a service manager, supplementing and washing dirty data, calling a related component package by combining a preset report format HTML template file and a CSS (cascading style file), analyzing the XML information file, converting the XML information file into a written text, a PDF (Portable document), an HTML page and other format product report, and sending the product report to an information disclosure channel after approval. The method solves the problems that the data source of the product operation report is wide, the information disclosure format is not uniform, part of disclosure information is lost and the like, and the related information is disclosed to investors and supervision authorities in time through the uniform information disclosure format of the XML file, so that the product report disclosure quality is improved.
The invention also provides 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 method when executing the computer program.
The present invention also provides a computer-readable storage medium storing a computer program for executing the above method.
As shown in fig. 8, the electronic device 600 may further include: communication module 110, input unit 120, audio processing unit 130, display 160, power supply 170. It is noted that the electronic device 600 does not necessarily include all of the components shown in FIG. 8; furthermore, the electronic device 600 may also comprise components not shown in fig. 8, which may be referred to in the prior art.
As shown in fig. 8, the central processor 100, sometimes referred to as a controller or operational control, may include a microprocessor or other processor device and/or logic device, the central processor 100 receiving input and controlling the operation of the various components of the electronic device 600.
The memory 140 may be, for example, one or more of a buffer, a flash memory, a hard drive, a removable media, a volatile memory, a non-volatile memory, or other suitable device. The information relating to the failure may be stored, and a program for executing the information may be stored. And the central processing unit 100 may execute the program stored in the memory 140 to realize information storage or processing, etc.
The input unit 120 provides input to the cpu 100. The input unit 120 is, for example, a key or a touch input device. The power supply 170 is used to provide power to the electronic device 600. The display 160 is used to display an object to be displayed, such as an image or a character. The display may be, for example, an LCD display, but is not limited thereto.
The memory 140 may be a solid state memory such as Read Only Memory (ROM), Random Access Memory (RAM), a SIM card, or the like. There may also be a memory that holds information even when power is off, can be selectively erased, and is provided with more data, an example of which is sometimes called an EPROM or the like. The memory 140 may also be some other type of device. Memory 140 includes buffer memory 141 (sometimes referred to as a buffer). The memory 140 may include an application/function storage section 142, and the application/function storage section 142 is used to store application programs and function programs or a flow for executing the operation of the electronic device 600 by the central processing unit 100.
The memory 140 may also include a data store 143, the data store 143 for storing data, such as contacts, digital data, pictures, sounds, and/or any other data used by the electronic device. The driver storage portion 144 of the memory 140 may include various drivers of the electronic device for communication functions and/or for performing other functions of the electronic device (e.g., messaging application, address book application, etc.).
The communication module 110 is a transmitter/receiver 110 that transmits and receives signals via an antenna 111. The communication module (transmitter/receiver) 110 is coupled to the central processor 100 to provide an input signal and receive an output signal, which may be the same as in the case of a conventional mobile communication terminal.
Based on different communication technologies, a plurality of communication modules 110, such as a cellular network module, a bluetooth module, and/or a wireless local area network module, may be provided in the same electronic device. The communication module (transmitter/receiver) 110 is also coupled to a speaker 131 and a microphone 132 via an audio processor 130 to provide audio output via the speaker 131 and receive audio input from the microphone 132 to implement general telecommunications functions. Audio processor 130 may include any suitable buffers, decoders, amplifiers and so forth. In addition, an audio processor 130 is also coupled to the central processor 100, so that recording on the local can be enabled through a microphone 132, and so that sound stored on the local can be played through a speaker 131.
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 above-mentioned embodiments are intended to illustrate the objects, technical solutions and advantages of the present invention in further detail, and it should be understood that the above-mentioned embodiments are only exemplary embodiments of the present invention, and are not intended to limit the scope of the present invention, and any modifications, equivalent substitutions, improvements and the like made within the spirit and principle of the present invention should be included in the scope of the present invention.
Claims (12)
1. A method for generating an XML-based product report, the method comprising:
acquiring product operation flow data from a plurality of product correlation systems, and storing the operation flow data into a data lake;
extracting product key field information from the data lake according to a preset product disclosure calendar and a preset XML standard template file, and supplementing the product key field information into the preset XML standard template file to generate an XML instance data file;
analyzing corresponding variable information in the XML instance data file through a template engine according to the keyword identification in a preset output template file, and obtaining an output text according to the variable information and the preset output template file;
and adjusting the display format of the output text through a preset CSS stack style file to obtain a product report file.
2. The XML-based product report generating method of claim 1, wherein the method further comprises:
carrying out data cleaning on the XML instance data file according to a preset rule, and identifying data information to be supplemented;
and acquiring corresponding data in a product association system according to the data information to be supplemented and supplementing the corresponding data into the XML instance data file.
3. The XML-based product report generating method according to claim 2, wherein the data cleansing of the XML instance data file according to the preset rule further comprises: and clearing invalid data in the XML instance data file according to the relevance and timeliness of the data.
4. The method of claim 1, wherein extracting key field information of a product from the data lake according to a predetermined product disclosure calendar and a predetermined XML standard template file comprises:
acquiring a collection time node according to a preset product disclosure calendar;
obtaining a product report disclosure field list and a product report key field according to a preset XML standard template file;
and extracting product key field information corresponding to products in the data lake at a collection time node according to the product report disclosure field list and the product report key field.
5. The XML-based product report generating method of claim 1, wherein adjusting the presentation format of the output text by a preset CSS stack style file to obtain a product report file further comprises:
acquiring one or more report file format requirements, and calling a preset format conversion component according to the report file format requirements;
and converting the product report file into a format corresponding to the report file format requirement through the format conversion component and then outputting the converted product report file.
6. The XML-based product report generating method according to claim 5, wherein the preset output template file is an HTML report template file; the product report file conversion format comprises one or more of a combination of written text format, PDF file format and HTML page format.
7. A product report generation system based on XML is characterized by comprising an acquisition module, an instance data extraction module and a text generation module;
the acquisition module is used for acquiring product operation flow data from a plurality of product correlation systems and storing the operation flow data into a data lake;
the example data extraction module is used for extracting product key field information from the data lake according to a preset product disclosure calendar and a preset XML standard template file, and supplementing the product key field information into the preset XML standard template file to generate an XML example data file;
the text generation module is used for analyzing corresponding variable information in the XML instance data file through a template engine according to keyword identification in a preset output template file, and obtaining an output text according to the variable information and the preset output template file; and adjusting the display format of the output text through a preset CSS cascading style file to obtain a product report file.
8. The XML-based product report generating system according to claim 7, wherein the instance data extracting module further comprises a cleaning module, the cleaning module is configured to perform data cleaning on the XML instance data file according to a preset rule and identify data information to be supplemented; and acquiring corresponding data in a product association system according to the data information to be supplemented and supplementing the corresponding data into the XML instance data file.
9. The XML-based product report generating system of claim 7, wherein the instance data extraction module includes an extraction unit;
the extraction unit is used for obtaining a collection time node according to a preset product disclosure calendar; obtaining a product report disclosure field list and a product report key field according to a preset XML standard template file; and extracting product key field information corresponding to products in the data lake at a collection time node according to the product report disclosure field list and the product report key field.
10. The XML-based product report generating system according to claim 7, further comprising an output presentation module, wherein the output presentation module is configured to obtain one or more report file format requirements, and invoke a preset format conversion component according to the report file format requirements; and converting the product report file into a format corresponding to the report file format requirement through the format conversion component and then outputting the converted product report file.
11. 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 method of any of claims 1 to 6 when executing the computer program.
12. A computer-readable storage medium, characterized in that the computer-readable storage medium stores a computer program for executing the method of any one of claims 1 to 6.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010793856.4A CN111950248B (en) | 2020-08-10 | 2020-08-10 | Product report generation method and system based on XML |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010793856.4A CN111950248B (en) | 2020-08-10 | 2020-08-10 | Product report generation method and system based on XML |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111950248A true CN111950248A (en) | 2020-11-17 |
| CN111950248B CN111950248B (en) | 2023-10-10 |
Family
ID=73331874
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010793856.4A Active CN111950248B (en) | 2020-08-10 | 2020-08-10 | Product report generation method and system based on XML |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111950248B (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113486646A (en) * | 2021-06-28 | 2021-10-08 | 平安信托有限责任公司 | Product report issuing method and device, electronic equipment and readable storage medium |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1277692A (en) * | 1997-10-22 | 2000-12-20 | 艾利森公司 | Apparatus and method for highlighting holidays of a specified location in a calendar software application |
| US20080120323A1 (en) * | 2006-11-17 | 2008-05-22 | Lehman Brothers Inc. | System and method for generating customized reports |
| CN106020953A (en) * | 2016-05-12 | 2016-10-12 | 青岛海信移动通信技术股份有限公司 | Method and device for establishing schedule in electronic calendar |
| CN106649223A (en) * | 2016-12-23 | 2017-05-10 | 北京文因互联科技有限公司 | Financial report automatic generation method based on natural language processing |
| CN109684515A (en) * | 2018-12-29 | 2019-04-26 | 中国电力科学研究院有限公司 | A kind of key sections on-line identification Data Data analysis method and system based on XML |
| CN111324780A (en) * | 2020-02-28 | 2020-06-23 | 北京三快在线科技有限公司 | Storage method, transmission method, device and storage medium of product data |
-
2020
- 2020-08-10 CN CN202010793856.4A patent/CN111950248B/en active Active
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1277692A (en) * | 1997-10-22 | 2000-12-20 | 艾利森公司 | Apparatus and method for highlighting holidays of a specified location in a calendar software application |
| US20080120323A1 (en) * | 2006-11-17 | 2008-05-22 | Lehman Brothers Inc. | System and method for generating customized reports |
| CN106020953A (en) * | 2016-05-12 | 2016-10-12 | 青岛海信移动通信技术股份有限公司 | Method and device for establishing schedule in electronic calendar |
| CN106649223A (en) * | 2016-12-23 | 2017-05-10 | 北京文因互联科技有限公司 | Financial report automatic generation method based on natural language processing |
| CN109684515A (en) * | 2018-12-29 | 2019-04-26 | 中国电力科学研究院有限公司 | A kind of key sections on-line identification Data Data analysis method and system based on XML |
| CN111324780A (en) * | 2020-02-28 | 2020-06-23 | 北京三快在线科技有限公司 | Storage method, transmission method, device and storage medium of product data |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113486646A (en) * | 2021-06-28 | 2021-10-08 | 平安信托有限责任公司 | Product report issuing method and device, electronic equipment and readable storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111950248B (en) | 2023-10-10 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102591847A (en) | Document processing apparatus and method for processing document | |
| JP5533188B2 (en) | Financial data processing apparatus, financial data processing method, and financial data processing program | |
| CN111897890B (en) | Financial business processing method and device | |
| CN110990222B (en) | Cross-platform graphical operation monitoring method and device based on mainframe | |
| CN113449236A (en) | Method and device for generating and storing electronic protocol of bank system | |
| CN111950248A (en) | XML-based product report generation method and system | |
| CN112181417B (en) | Front-end research and development configuration device and method | |
| WO2011132470A1 (en) | Financial data processing device | |
| CN111882419B (en) | Method and device for quality inspection of files and server | |
| CN113837870B (en) | Financial risk data approval method and device | |
| CN115509637A (en) | Form-based intelligent filling method, system, equipment and medium | |
| CN102521717A (en) | Method and device for carrying out statistics on configuration management resource library information | |
| KR102492008B1 (en) | Apparatus for managing minutes and method thereof | |
| CN113297179A (en) | Method and device for processing supervision submission data | |
| CN111783432A (en) | Generation method and device of credit certificate examination key point list | |
| CN109815447B (en) | Word form Schema processing system | |
| CN112783633A (en) | Data updating system and method based on resource mutual exclusion scheduling model | |
| CN111783391A (en) | Online artificial text marking system and method | |
| CN111859041A (en) | Data transmission method and device | |
| CN111782204B (en) | Batch scheduling editing method and device | |
| CN111428018B (en) | Intelligent question-answering method and device | |
| CN107544750A (en) | Terminal device | |
| CN114065096A (en) | Card approval aging data processing method and device | |
| CN116070716A (en) | Model verification realization method and device and server | |
| CN112487090A (en) | Data synchronization method, data display platform and computer readable 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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |