CN111950248B - Product report generation method and system based on XML - Google Patents
Product report generation method and system based on XML Download PDFInfo
- Publication number
- CN111950248B CN111950248B CN202010793856.4A CN202010793856A CN111950248B CN 111950248 B CN111950248 B CN 111950248B CN 202010793856 A CN202010793856 A CN 202010793856A CN 111950248 B CN111950248 B CN 111950248B
- Authority
- CN
- China
- Prior art keywords
- file
- product
- data
- preset
- report
- 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.)
- Active
Links
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 application provides a product report generation method and a system based on XML, wherein the method comprises the following steps: acquiring product operation flow data from a plurality of product association 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 a keyword identifier 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.
Description
Technical Field
The application relates to the field of big data, in particular to a method and a system for generating a product report based on XML, which can be applied to the financial field or other fields.
Background
With the increasing level of income and increased financial awareness, people are throwing more funds into financial products issued by financial institutions. The financial institution fully, timely and accurately discloses the product operation information to investors according to the requirements of the regulatory authorities, and is a legal obligation which the financial institution should follow and a basic principle of information disclosure.
The operation of the financial products generally comprises the processes of product, sales, research, wind control, valuation and the like, different professional systems of the financial institutions provide supporting operation, the comprehensive disclosure of various data of product operation information which needs to be integrated and dispersed in each professional system is realized, but the data are scattered and are stored in different formats, investors cannot obtain the information effectively and quickly, and risks such as information omission and the like are easily caused; the mode of unified collection and arrangement release by workers can lead to larger manpower workload and larger requirements on personnel professionals and working timeliness; therefore, there is a need in the industry for a report generation method and system for disclosing and disclosing relevant information to investors and regulatory authorities in time around key information key fields, enhancing transparency of financial products, protecting investors' rights of knowledge, and providing more comprehensive product information to investors more efficiently.
Disclosure of Invention
The application aims to provide a general and efficient XML-based product report generation method and system, which are used for timely and comprehensively collecting operation data of various products among different systems and arranging the operation data into the same data source so that investors can timely acquire the product report information.
To achieve the above object, the present application provides an XML-based product report generation method, which includes: acquiring product operation flow data from a plurality of product association 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 a keyword identifier 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 XML-based product report generation method, preferably, the method further includes: carrying out data cleaning on the XML instance data file according to a preset rule, and identifying the 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 among the data.
In the above method for generating an XML-based product report, preferably, extracting product key field information from the data lake according to a preset product disclosure calendar and a preset XML standard template file includes: acquiring an acquisition time node according to a preset product disclosure calendar; acquiring 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 the product in the data lake according to the product report disclosure field list and the product report key field at the acquisition time node.
In the above XML-based product report generating method, preferably, the adjusting the presentation format of the output text by using a preset CSS cascading 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 format requirement of the report file through the format conversion component and outputting the format.
In the above XML-based product report generation method, preferably, the method further includes: presetting an output template file as an HTML report template file; the product report file conversion format comprises a combination of one or more of a written text format, a PDF file format, and an HTML page format.
The application also provides an XML-based product report generation system, which comprises 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 association systems and storing the operation flow data into a data lake; the instance 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 instance 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 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; and adjusting the display format of the output text through a preset CSS cascading style file to obtain a product report file.
In the foregoing 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 complemented; 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 extraction module includes an extraction unit; the extraction unit is used for obtaining acquisition time nodes according to a preset product disclosure calendar; acquiring 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 the product in the data lake according to the product report disclosure field list and the product report key field at the acquisition time node.
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 call a preset format conversion component according to the report file format requirements; and converting the product report file into a format corresponding to the format requirement of the report file through the format conversion component and outputting the format.
The application also provides 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 above method when executing the computer program.
The present application also provides a computer readable storage medium storing a computer program for executing the above method.
The beneficial technical effects of the application are as follows: the standardization of product report and disclosure key information is realized, and the disclosure format and content of various financial product information are unified; the product report content format can be added according to the actual situation, so as to adapt to the change and dynamically expand the key fields of the disclosed key information in time, and meanwhile, the defect of the key fields of the disclosed key information is avoided.
Drawings
The accompanying drawings, which are included to provide a further understanding of the application and are incorporated in and constitute a part of this specification, illustrate and together with the description serve to explain the application. In the drawings:
FIG. 1 is a flowchart of an XML-based product report generation method according to an embodiment of the present application;
FIG. 2 is a schematic diagram of an XML-based product report generation method according to an embodiment of the present application;
FIG. 3 is a flow chart of extracting key field information of a product according to an embodiment of the present application;
FIG. 4 is a schematic diagram of an XML manifest file for product establishment report and product expiration report disclosure information according to an embodiment of the present application;
FIG. 5 is a schematic diagram of an HTML template for reporting expiration of a product according to one embodiment of the present application;
FIG. 6 is a schematic diagram of a style description template in a CSS cascading style file according to an embodiment of the present application;
FIG. 7 is a schematic diagram of a system for generating XML-based product report according to an embodiment of the present application;
fig. 8 is a schematic structural diagram of an electronic device according to an embodiment of the application.
Detailed Description
The following will describe embodiments of the present application in detail with reference to the drawings and examples, thereby solving the technical problems by applying technical means to the present application, and realizing the technical effects can be fully understood and implemented accordingly. It should be noted that, as long as no conflict is formed, each embodiment of the present application and each feature of each embodiment may be combined with each other, and the formed technical solutions are all within the protection scope of the present application.
Additionally, the steps illustrated in the flowcharts 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 flowcharts, in some cases the steps illustrated or described may be performed in an order other than that herein.
Referring to fig. 1, the method for generating an XML-based product report according to the present application includes:
s101, acquiring product operation flow data from a plurality of product association 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 a keyword identifier in a 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 actual work, the preset output template file may be an HTML report template file, the product report generating method may be shown with reference to fig. 2 when applied, and mainly includes entering a lake with data of each professional system, a service manager presets a product disclosure calendar, a product report template and a disclosure key information key field in a report management system, the system extracts the product key information key field according to the product disclosure key information key field identified by XML on a product preset disclosure date, processes the product key information key field into a product disclosure XML information file, and then may clean and supplement dirty data via the system and the service manager data, and then, combine the HTML template file and the CSS lamination style file in a preset report format, call related component packages, parse the XML information file and convert the XML information file into a product report file in formats such as written text, PDF file and HTML page, and send the product report after approval to the information disclosure channel; for a specific implementation of each step, please refer to the following examples for a detailed description.
Referring to fig. 3, in an embodiment of the present application, 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 an acquisition 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 the products in the data lake according to the product report disclosure field list and the product report key field at the acquisition time node.
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 regular calendar of product establishment date, product expiration date, product duration (month end, quarter end, half year end and year end), and irregular disclosure report. The list file of the product report disclosure field mainly describes key information key fields required to be used for product report disclosure, is stored in an XML format record file, can be dynamically expanded and synchronized to a data lake, and is used as a basis for extracting key information of the product of the data lake. Wherein, the product establishment report and the product expiration report disclosure information XML manifest file can be shown with reference to fig. 4 and 5; in actual work, the operation of the financial products comprises the processes of product, sales, throw-in and research, wind control, valuation and the like, different professional systems of the financial institutions provide supporting operation, data of each professional system enter a lake, meanwhile, service managers synchronously push a product report disclosure calendar and a product report disclosure field list preset by a report management system to the data lake, and a unified data source is provided for data processing such as subsequent product key information extraction and the like. In the process of processing key fields of product report key information, an XML extensible markup language is adopted to identify a product report disclosure field list and the product report key fields, when key information is extracted in processing, specific product related information and fields can be queried according to a product report disclosure XML list file, an initial product report XML information file is derived, and if the XML list file is added or subtracted with labels, the content of the extracted data fields is changed. Thus, the method has the following advantages: 1. the standardization of key fields of the disclosed key information is realized, and the disclosed formats and contents of various financial product information are unified. 2. The expandability of the key fields of the disclosure key information is realized, and new identifiers and attribute names can be defined according to the latest disclosure requirements. 3. And the identification of object level layers such as complex nesting disclosure information is realized through the file structure nesting of XML. 4. For the disclosure report fixed text content, redundant storage is reduced, information supply cost is reduced, and data transmission is facilitated.
Along with the fusion development of big data technology, financial institutions actively push the construction of data lakes, the data lakes gradually develop into a system capable of storing all structured and unstructured data in any scale, and running different types of big data tools to process big data, and at present, synchronous replication of data with a source system is realized through a high-timeliness data exchange system; the key information key fields of the product report are extracted through the data lake, so that the difference between different professional systems of the whole operation flow of the product can be shielded, and a unified data platform is provided for comprehensively, fully and timely disclosing the product report; however, since the data is automatically extracted, there is also some error information, and therefore, in an embodiment of the present application, the method may further include: carrying out data cleaning on the XML instance data file according to a preset rule, and identifying the data information to be supplemented; corresponding data are collected in a product association system according to the data information to be supplemented and are supplemented into the XML instance data file; 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 among the data.
Specifically, when the related system for report management receives the product disclosure information marked by XML, namely the product report XML initial information file, service manager needs to clean data according to the key information key field displayed by the specific product report, the system already cleans data according to a certain rule, submits the filtered result to the service manager, and highlights the content to be supplemented. The service manager mainly processes invalid values and missing values of data. These data are extracted from a plurality of business systems and include historical data, and due to timeliness reasons, there may be data missing, some data may be error data, some data have conflict with each other, namely "dirty data", and data clearing processing needs to be performed, so that the data are converted into a product report XML information file. The above-mentioned processes of cleaning, filling and removing dirty data can be implemented by adopting the existing method, and the present application will not be described in detail here.
In an embodiment of the present application, adjusting the display format of the output text by using a preset CSS cascading 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 format requirement of the report file through the format conversion component and outputting the format. Wherein the product report file conversion format comprises a combination of one or more of a written text format, a PDF file format and an HTML page format. Therefore, the method and the device realize analysis of the XML information file of the product report, call related component packages by combining a preset report format HTML template file and a CSS cascading style sheet, and convert the related component packages into the product report in the formats of written characters, PDF files, HTML pages and the like. In actual operation, the CSS cascading style file is used to adjust the output text to refer to the createpdf.css file, and a style description is provided for the HTML report template file, which is used to describe the information formatting and displaying manner on the web page, and includes rules for applying the style to the elements of the specified type, and particularly, reference is made to fig. 6.
Referring to fig. 7, the application further provides an XML-based product report generating system, which 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 association systems and storing the operation flow data into a data lake; the instance 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 instance 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 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; and adjusting the display format of the output text through a preset CSS cascading style file to obtain a product report file. The product association system may include a product system, a sales system, a lapping system, a wind control system, and an evaluation system.
In the foregoing 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 complemented; 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, the service manager can clean data according to key information key fields displayed by a specific product report, submit the filtered result to staff, and highlight the content to be supplemented. The invalid value and missing value of the data are processed by staff, the data can be extracted from a plurality of service systems and comprise historical data, the data may be missing due to timeliness, some data may be error data, some data have conflict with each other, namely 'dirty data', and the data needs to be subjected to data clearing processing and converted into a final XML instance data file.
In an embodiment of the application, the example data extraction module may include an extraction unit; the extraction unit is used for obtaining acquisition time nodes according to a preset product disclosure calendar; acquiring 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 the product in the data lake according to the product report disclosure field list and the product report key field at the acquisition time node. In actual work, when key information is extracted in big data processing, the product report disclosure XML list file can be adjusted according to actual needs to inquire specific product related information and fields, and a product report XML initial information file is derived, and if the XML list file is added or reduced with labels, the content of the extracted data fields is changed accordingly.
In an embodiment of the present application, the system may further include an output display module, where the output display module is configured to obtain one or more report format requirements, and call a preset format conversion component according to the report format requirements; and converting the product report file into a format corresponding to the format requirement of the report file through the format conversion component and outputting the format. In actual work, after the product report XML initial information file, namely the preliminary XML instance data file, is cleaned and converted into the product report XML information file, namely the final XML instance data file, the system calls related component packages according to the instruction of a service manager by combining the report format HTML template file and the CSS cascading style file, analyzes the XML file and converts the XML file into the product report file in the formats of written characters, PDF files, HTML pages and the like; the building blocks may be implemented using format conversion means in the prior art, and the present application will not be described in detail.
The application provides a method and a system for generating a product report based on XML, which are characterized in that through presetting a product disclosure calendar, a product report template and a disclosure field list, each professional system data, the product disclosure calendar and the disclosure field list enter a lake, and on the preset disclosure date of the product, according to the key information key field of the product disclosure marked by XML, the key information key field of the product is extracted, processed into a product disclosure XML information file, sent to a report management system, cleaned by a system and service manager data, supplemented and cleaned by dirty data, combined with a preset report format HTML template file and CSS cascading style file, related component packages are called, the XML information file is analyzed and converted into a product report file in the format of written text, PDF file, HTML page and the like, and the product report is approved and sent to an information disclosure channel. The method solves the problems of wide data sources, non-uniform information disclosure formats, partial disclosure information deletion and the like of the product operation report, and timely discloses and reveals related information to investors and regulatory authorities through unifying the information disclosure formats of XML files, thereby improving the disclosure quality of the product report.
The application also provides 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 above method when executing the computer program.
The present application 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: a communication module 110, an input unit 120, an audio processing unit 130, a display 160, a power supply 170. It is noted that the electronic device 600 need not include all of the components shown in fig. 8; in addition, the electronic device 600 may further include components not shown in fig. 8, to which reference is made to the related art.
As shown in fig. 8, the central processor 100, also sometimes referred to as a controller or operational control, may include a microprocessor or other processor device and/or logic device, which central processor 100 receives inputs and controls 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 about failure may be stored, and a program for executing the information may be stored. And the central processor 100 can execute the program stored in the memory 140 to realize information storage or processing, etc.
The input unit 120 provides an input to the central processor 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 for displaying display objects such as images and characters. The display may be, for example, but not limited to, an LCD display.
The memory 140 may be a solid state memory such as Read Only Memory (ROM), random Access Memory (RAM), SIM card, or the like. But also a memory which holds information even when powered down, can be selectively erased and provided with further data, an example of which is sometimes referred to as EPROM or the like. Memory 140 may also be some other type of device. Memory 140 includes a buffer memory 141 (sometimes referred to as a buffer). The memory 140 may include an application/function storage 142, the application/function storage 142 for storing application programs and function programs or a flow for executing operations of the electronic device 600 by the central processor 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 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 applications, address book applications, etc.).
The communication module 110 is a transmitter/receiver 110 that transmits and receives signals via an antenna 111. A 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, etc., 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 to receive audio input from the microphone 132 to implement usual telecommunication functions. The audio processor 130 may include any suitable buffers, decoders, amplifiers and so forth. In addition, the audio processor 130 is also coupled to the central processor 100 so that sound can be recorded locally through the microphone 132 and so that sound stored locally can be played through the speaker 131.
It will be appreciated by those skilled in the art that embodiments of the present application may be provided as a method, system, or computer program product. Accordingly, the present application may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present application 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 application is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems) and computer program products according to embodiments of the application. It will be understood that each flow and/or block of the flowchart illustrations and/or block diagrams, and combinations of flows and/or blocks in the flowchart illustrations 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 foregoing description of the embodiments has been provided for the purpose of illustrating the general principles of the application, and is not meant to limit the scope of the application, but to limit the application to the particular embodiments, and any modifications, equivalents, improvements, etc. that fall within the spirit and principles of the application are intended to be included within the scope of the application.
Claims (7)
1. A method for generating an XML-based product report, the method comprising:
acquiring product operation flow data from a plurality of product association 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 a keyword identifier in a preset output template file, and obtaining an output text according to the variable information and the preset output template file;
adjusting the display format of the output text through a preset CSS cascading style file to obtain a product report file;
extracting product key field information from the data lake according to a preset product disclosure calendar and a preset XML standard template file comprises the following steps: acquiring an acquisition time node according to a preset product disclosure calendar; acquiring a product report disclosure field list and a product report key field according to a preset XML standard template file; extracting product key field information corresponding to products in the data lake according to the product report disclosure field list and the product report key field at a collecting time node;
the method for obtaining the product report file by adjusting the display format of the output text through the preset CSS cascading style file further comprises the following steps: acquiring one or more report file format requirements, and calling a preset format conversion component according to the report file format requirements; converting the product report file into a format corresponding to the format requirement of the report file through the format conversion component and outputting the format; the method comprises the steps that an output template file is preset to be an HTML report template file; the product report file conversion format comprises a combination of one or more of a written text format, a PDF file format, and an HTML page format.
2. The XML-based product report generating method of claim 1, further comprising:
carrying out data cleaning on the XML instance data file according to a preset rule, and identifying the 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 of claim 2, wherein data cleansing said XML instance data file according to a preset rule further comprises: and clearing invalid data in the XML instance data file according to the relevance and timeliness among the data.
4. The system is characterized by comprising an acquisition module, an instance data extraction module, an output display module and a text generation module;
the acquisition module is used for acquiring product operation flow data from a plurality of product association systems and storing the operation flow data into a data lake;
the instance 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 instance 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 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; and adjusting the display format of the output text through a preset CSS cascading style file to obtain a product report file;
the example data extraction module includes an extraction unit; the extraction unit is used for obtaining acquisition time nodes according to a preset product disclosure calendar; acquiring a product report disclosure field list and a product report key field according to a preset XML standard template file; extracting product key field information corresponding to products in the data lake according to the product report disclosure field list and the product report key field at a collecting time node;
the output display module is used for acquiring one or more report file format requirements and calling a preset format conversion component according to the report file format requirements; converting the product report file into a format corresponding to the format requirement of the report file through the format conversion component and outputting the format; the method comprises the steps that an output template file is preset to be an HTML report template file; the product report file conversion format comprises a combination of one or more of a written text format, a PDF file format, and an HTML page format.
5. The XML-based product report generating system of claim 4, wherein said instance data extraction module further comprises a cleansing module for cleansing said XML instance data file according to a predetermined 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.
6. An electronic device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, characterized in that the processor implements the method of any of claims 1 to 3 when executing the computer program.
7. A computer readable storage medium, characterized in that the computer readable storage medium stores a computer program for implementing the method of any one of claims 1 to 3, which is executed by a computer.
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 CN111950248A (en) | 2020-11-17 |
| CN111950248B true 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) |
Families Citing this family (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 (5)
| 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 |
| 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 |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20080120323A1 (en) * | 2006-11-17 | 2008-05-22 | Lehman Brothers Inc. | System and method for generating customized reports |
-
2020
- 2020-08-10 CN CN202010793856.4A patent/CN111950248B/en active Active
Patent Citations (5)
| 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 |
| 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 |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111950248A (en) | 2020-11-17 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110489313B (en) | Operation log recording method and device based on block chain and storage medium | |
| US8990157B2 (en) | Replication support for structured data | |
| CN104778241A (en) | Report generation method and system | |
| WO2011132469A1 (en) | Financial data processing device | |
| CN109840159A (en) | Abnormality processing project management method, apparatus, computer installation and storage medium | |
| WO2010129714A2 (en) | System and method for multilingual transcription service with automated notification services | |
| CN111950248B (en) | Product report generation method and system based on XML | |
| CN111651966A (en) | Data report file generation method and device and electronic equipment | |
| CN111625535A (en) | Method, device and storage medium for realizing business data association | |
| CN102708160A (en) | Method and device for establishing question bank | |
| CN111324480B (en) | Large-scale host transaction fault positioning system and method | |
| WO2011132470A1 (en) | Financial data processing device | |
| CN102521717A (en) | Method and device for carrying out statistics on configuration management resource library information | |
| US20230188643A1 (en) | Ai-based real-time natural language processing system and method thereof | |
| CN102014164A (en) | Method of mobile access platform | |
| CN103853697A (en) | Mobile terminal and back-up method for application data thereof | |
| CN115345142A (en) | Contract template generation method and device, computer-readable storage medium and electronic equipment | |
| US7730105B2 (en) | Time sharing managing apparatus, document creating apparatus, document reading apparatus, time sharing managing method, document creating method, and document reading method | |
| CN111882419A (en) | Method and device for quality inspection of files and server | |
| CN112286922A (en) | Data cleaning method, device, equipment and storage medium | |
| CN111782204B (en) | Batch scheduling editing method and device | |
| CN116070716A (en) | Model verification realization method and device and server | |
| US20130024773A1 (en) | System and method for summarizing interactions | |
| JP3098713U (en) | Environmental accounting financial statement creation function | |
| CN113656445A (en) | Data processing 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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |