CN116401218A - File export method and terminal equipment - Google Patents
File export method and terminal equipment Download PDFInfo
- Publication number
- CN116401218A CN116401218A CN202310671691.7A CN202310671691A CN116401218A CN 116401218 A CN116401218 A CN 116401218A CN 202310671691 A CN202310671691 A CN 202310671691A CN 116401218 A CN116401218 A CN 116401218A
- Authority
- CN
- China
- Prior art keywords
- data
- file
- template
- export
- information
- 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
- 238000000034 method Methods 0.000 title claims abstract description 96
- 238000012545 processing Methods 0.000 claims abstract description 130
- 230000008569 process Effects 0.000 claims description 37
- 238000001914 filtration Methods 0.000 claims description 13
- 238000004140 cleaning Methods 0.000 claims description 12
- 238000004590 computer program Methods 0.000 claims description 10
- 238000012790 confirmation Methods 0.000 claims description 8
- 230000008878 coupling Effects 0.000 abstract description 11
- 238000010168 coupling process Methods 0.000 abstract description 11
- 238000005859 coupling reaction Methods 0.000 abstract description 11
- 238000005516 engineering process Methods 0.000 abstract description 2
- 238000010586 diagram Methods 0.000 description 13
- 230000006870 function Effects 0.000 description 12
- 238000007726 management method Methods 0.000 description 9
- 238000013523 data management Methods 0.000 description 7
- 238000012423 maintenance Methods 0.000 description 7
- 235000010627 Phaseolus vulgaris Nutrition 0.000 description 4
- 244000046052 Phaseolus vulgaris Species 0.000 description 4
- 230000009286 beneficial effect Effects 0.000 description 4
- 238000011161 development Methods 0.000 description 3
- 230000018109 developmental process Effects 0.000 description 3
- 238000012986 modification Methods 0.000 description 3
- 230000004048 modification Effects 0.000 description 3
- 238000004891 communication Methods 0.000 description 2
- 238000000586 desensitisation Methods 0.000 description 2
- 238000013461 design Methods 0.000 description 2
- 210000001503 joint Anatomy 0.000 description 2
- 238000006467 substitution reaction Methods 0.000 description 2
- 238000012550 audit Methods 0.000 description 1
- 230000006399 behavior Effects 0.000 description 1
- 230000003542 behavioural effect Effects 0.000 description 1
- 238000012508 change request Methods 0.000 description 1
- 238000006243 chemical reaction Methods 0.000 description 1
- 239000012141 concentrate Substances 0.000 description 1
- 238000003032 molecular docking Methods 0.000 description 1
- 230000006855 networking Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 238000011165 process development Methods 0.000 description 1
- 238000012827 research and development Methods 0.000 description 1
- 230000033772 system development Effects 0.000 description 1
- 238000012384 transportation and delivery Methods 0.000 description 1
- 238000010200 validation analysis Methods 0.000 description 1
- 230000000007 visual effect Effects 0.000 description 1
- 238000012800 visualization Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/10—File systems; File servers
- G06F16/16—File or folder operations, e.g. details of user interfaces specifically adapted to file systems
-
- 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
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/02—Banking, e.g. interest calculation or account maintenance
-
- 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
- Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
- Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Theoretical Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Physics & Mathematics (AREA)
- Strategic Management (AREA)
- Entrepreneurship & Innovation (AREA)
- General Business, Economics & Management (AREA)
- Finance (AREA)
- Accounting & Taxation (AREA)
- General Engineering & Computer Science (AREA)
- Marketing (AREA)
- Economics (AREA)
- Human Resources & Organizations (AREA)
- Data Mining & Analysis (AREA)
- Tourism & Hospitality (AREA)
- Human Computer Interaction (AREA)
- General Health & Medical Sciences (AREA)
- Computational Linguistics (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Databases & Information Systems (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Artificial Intelligence (AREA)
- Health & Medical Sciences (AREA)
- Development Economics (AREA)
- Technology Law (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present application relates to the field of data processing technologies, and in particular, to a method for exporting a file and a terminal device, where the method includes: template information sent by a file requesting party according to service requirements is received; determining a corresponding file export template in a template library according to the template information; wherein the attributes of the file export template include the data origin and associated data processing class; acquiring data from the associated data sources by utilizing the data processing class to obtain corresponding data files; and carrying out secondary processing on the data file according to the file export template to obtain an export file, and outputting the export file according to the requirement. Therefore, the method and the system can effectively solve the problems of high coupling degree, low data processing efficiency, poor data processing flexibility and the like of the conventional bank systems.
Description
Technical Field
The present disclosure relates to the field of data processing technologies, and in particular, to a file export method and a terminal device.
Background
Various systems in banks naturally generate a large amount of contract document data, user information data, lending duration data and various sensitive information data during operation due to large service demand. When the data are used, different systems acquire corresponding related data to generate related files. Regarding data application, at present, it is common practice to directly interface with a related service system, obtain corresponding data from the service system, and then perform customized development to generate related files. However, the above-mentioned customization implementation method mainly causes the following problems:
1) According to the customized implementation method, interface information data are diversified, the butt joint process is complex and complicated, secondary processing is needed to be carried out on data acquired from a service system in many cases, the data processing efficiency is low, time is wasted, and research and development staff cannot concentrate on core service process development. The interface diversification causes that each service module has high coupling degree, which is not beneficial to the expansion and maintenance of the system.
2) Most of the generated file contents are custom developed, and when the typesetting layout of the file contents or the file format needs to be changed, the code needs to be modified, and then the layout is reissued. The file content of the customized development is often fixed, the modification is difficult, the flexibility of modifying the generated file content is poor, and the complex and changeable requirements cannot be met.
3) The generated files are not uniformly managed by each system, basically, the generated files are maintained in the system, the storage modes are various, and uniform management cannot be performed. The different standards of the systems also lead to difficulty in secondary multiplexing of the generated files, the files containing the sensitive information cannot be effectively protected, and the risk of information leakage is increased when the sensitive information is reserved in different storage media of the systems.
In a word, when data are acquired among all systems of a bank at present, the complex data processing and low data processing efficiency exist; the coupling degree of each system service module is high, which is not beneficial to expansion and maintenance. And the flexibility is poor when the acquired file content is modified, and the method can not meet the complex and changeable requirements.
Disclosure of Invention
In view of this, the embodiments of the present application provide a method and a terminal device for exporting files, which can effectively solve the problems of high coupling degree, low data processing efficiency, and poor data processing flexibility of the existing bank systems.
In a first aspect, an embodiment of the present application provides a method for deriving a file, including:
template information sent by a file requesting party according to service requirements is received;
determining a corresponding file export template in a template library according to the template information; wherein the attributes of the file export template include data origin and associated data processing classes;
acquiring data from the associated data sources by utilizing the data processing class to obtain a corresponding data file;
and carrying out secondary processing on the data file according to the file export template to obtain an export file, and outputting the export file according to requirements.
In some embodiments, the file export templates include a business data template and a protocol data template; the data processing class comprises a business data processing class and a protocol data processing class;
wherein, the business data template is correspondingly associated with the business data processing class so as to be commonly used for acquiring business data in an external system; the protocol data templates are correspondingly associated with the protocol data processing classes for commonly obtaining protocol data in an external system.
In some embodiments, if the file export template is the business data template, the performing secondary processing on the data file according to the file export template includes:
carrying out format processing on the data file according to the data format attribute of the service data template so as to generate a basic export file;
processing additional information of the basic export file according to the additional information attribute of the service data template to obtain the export file;
if the file export template is the protocol data template, the performing secondary processing on the data file according to the file export template includes:
and processing the additional information of the data file according to the additional information attribute of the protocol data template to obtain the export file.
In some embodiments, the data format attributes include request data items and layout information;
wherein the request data item is used for determining the number and content of data pieces when acquiring data from the data source; the layout typesetting information is used for determining typesetting and layout of the request data items and corresponding data values when the basic export file is generated.
In some embodiments, the data format attribute comprises: a data sub-template; the data sub-templates comprise request data items, placeholders and typesetting layout information which are determined according to the service requirements;
wherein, each request data item and the placeholder carry out typesetting layout according to the set typesetting layout information; the placeholder is used to provide a location for the data value of the requested data item when the base export file is generated.
In some embodiments, the business data processing class comprises: at least one of a cleaning data process, a filtering data process, and a secondary processing data process;
before the data file is formatted according to the data format attribute of the service data template, the method further comprises the following steps:
cleaning the request data through the cleaning data process; and/or, filtering the request data through the data filtering process; and/or performing secondary processing on the request data through the secondary processing data process.
In some embodiments, the additional information attribute of the business data template comprises: whether at least one of watermarking, watermark content, extension information, whether desensitizing and whether signing, and signing template ID;
the additional information attributes of the protocol data template include: whether at least one of watermark, watermark content and extension information.
In some embodiments, the method further comprises: storing the exported file in a storage service according to the template information;
and when the template information is received, searching in the storage service according to the template information, and outputting the export file if the export file corresponding to the template information is searched.
In some embodiments, the outputting the export file on demand includes:
generating an approval file according to the export file and sending the approval file to a corresponding approver; and outputting the export file after receiving the approval confirmation information.
In a second aspect, an embodiment of the present application provides a terminal device, where the terminal device includes a processor and a memory, where the memory stores a computer program, and the processor is configured to execute the computer program to implement a file export method provided in the first aspect of the present application.
The embodiment of the application has the following beneficial effects:
according to the method, the file export template is abstracted according to service requirements, the policy type data processing class is encapsulated according to the service data processing process, the file export template and the data processing class are associated and bound, processing data is jointly achieved, the export file meeting the requirements is generated, corresponding data can be obtained by each file requester only according to template information, data processing is simple, data processing efficiency is high, the coupling degree of each system service module is low, and expansion and maintenance are facilitated. When the service requirement is changed, the requirement can be met by only modifying the file export template, and if a new service processing process exists, only the data processing class needs to be added, so that the content of the exported file or the new service can be flexibly modified no matter what is needed, and the complex and changeable requirement can be met. Therefore, the method and the system can effectively solve the problems of high coupling degree, low data processing efficiency, poor data processing flexibility and the like of the conventional bank systems.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present application, the drawings that are needed in the embodiments will be briefly described below, it being understood that the following drawings only illustrate some embodiments of the present application and therefore should not be considered limiting the scope, and that other related drawings may be obtained according to these drawings without inventive effort for a person skilled in the art.
FIG. 1 shows a flowchart of a method for deriving files according to an embodiment of the present application;
FIG. 2 is a schematic diagram of a business data template in the method for exporting files according to the embodiment of the present application;
FIG. 3 is a schematic diagram of a data sub-template in the file export method according to the embodiment of the present application;
FIG. 4 is a schematic diagram of a protocol data template in the file export method according to the embodiment of the present application;
FIG. 5 illustrates another flow chart of a file export method according to an embodiment of the present application;
FIG. 6 is a schematic diagram of a business data management page in the file export method according to the embodiment of the present application;
FIG. 7 is a schematic diagram of a protocol data management page in the file export method according to the embodiment of the present application;
FIG. 8 is a schematic diagram of a data export management page in the file export method according to the embodiment of the present application;
fig. 9 shows a schematic structural diagram of a file exporting apparatus according to an embodiment of the present application.
Description of main reference numerals:
910-a request receiving module; 920-a template determination module; 930-a data acquisition module; 940-file export module.
Detailed Description
The following description of the embodiments of the present application will be made clearly and completely with reference to the drawings in the embodiments of the present application, and it is apparent that the described embodiments are only some embodiments of the present application, not all embodiments.
The components of the embodiments of the present application, which are generally described and illustrated in the figures herein, may be arranged and designed in a wide variety of different configurations. Thus, the following detailed description of the embodiments of the present application, as provided in the accompanying drawings, is not intended to limit the scope of the application, as claimed, but is merely representative of selected embodiments of the application. All other embodiments, which can be made by those skilled in the art based on the embodiments of the present application without making any inventive effort, are intended to be within the scope of the present application.
In the following, the terms "comprises", "comprising", "having" and their cognate terms may be used in various embodiments of the present application are intended only to refer to a particular feature, number, step, operation, element, component, or combination of the foregoing, and should not be interpreted as first excluding the existence of or increasing the likelihood of one or more other features, numbers, steps, operations, elements, components, or combinations of the foregoing. Furthermore, the terms "first," "second," "third," and the like are used merely to distinguish between descriptions and should not be construed as indicating or implying relative importance.
Unless otherwise defined, all terms (including technical and scientific terms) used herein have the same meaning as commonly understood by one of ordinary skill in the art to which various embodiments of this application belong. The terms (such as those defined in commonly used dictionaries) will be interpreted as having a meaning that is identical to the meaning of the context in the relevant art and will not be interpreted in an idealized or overly formal sense unless expressly so defined herein in connection with the various embodiments.
Some embodiments of the present application are described in detail below with reference to the accompanying drawings. The embodiments described below and features of the embodiments may be combined with each other without conflict.
At present, when data are acquired among all systems of a bank, the systems are directly connected to acquire the data to generate a file. However, such an operation causes complicated data processing and low data processing efficiency; the coupling degree of each system service module is high, which is not beneficial to expansion and maintenance. The generated file content has poor modification flexibility and can not adapt to complex and changeable requirements. Therefore, the file export method and the terminal equipment can effectively solve the problems of high coupling degree, low data processing efficiency, poor data processing flexibility and the like of the conventional bank systems. The file export method is described below in connection with some specific embodiments.
Fig. 1 shows a flowchart of a file export method according to an embodiment of the present application. The file export method illustratively includes the steps of:
s10, template information sent by a file requesting party according to service requirements is received. The file requestor may be any system that knows template information.
The requirements of each system on the generated file are various, such as different required formats, layouts and fonts, even if two files have the same data content, the requirements on typesetting layout have small differences, and in order to meet the requirements of generating the commonality of the file content and customizing the two parts, the corresponding templates are abstracted according to each service requirement, and the file content can be customized and generated through simple configuration. The abstract template is a file export template. Each business requirement corresponds to a file export template. And (5) intensively storing each file export template. The file export template comprises template information, and the corresponding file export template can be searched and obtained according to the template information.
In the prior art, the code coupling degree of the system is high, the expansion and maintenance are not facilitated, and the multiplexing rate is low. Thus, the present application encapsulates the execution of each business need into a corresponding data processing class using policy patterns when writing code. The process of handling each business need is packaged into a data processing class. Such as the process of acquiring, cleaning, filtering and secondary processing business data, are packaged into individual data processing classes. When new requirements are added, only corresponding data processing classes are needed to be added, the requirements of an opening and closing principle are met, the expansion and maintenance are easy, and the requirements of high cohesion and low coupling of a system are met.
The above-described policy schema is one of the practices of design schema in which the behavior of a class or its algorithm can be changed at runtime. This type of design pattern belongs to the behavioral pattern. And carrying out association binding on the file export template and the data processing class, and dynamically acquiring different data from different systems according to different data processing classes configured in the file export template. Specifically, the processing procedure of the service requirement includes requesting the dubbo interface of each service system, such as a product system, an air control system and a core system, taking data from a third party system, cleaning, filtering, assembling and converting the data into data required by the template to generate a corresponding export file.
S20, determining a corresponding file export template in a template library according to template information; wherein the attributes of the file export template include the data origin and associated data processing class. The data source is the data address of each system. The data processing class includes a process of acquiring data.
The file export template includes a base attribute, an additional information attribute, and a data format attribute. Wherein the base attributes include: template encoding, template name, file type, file suffix, data source location, data source type, BEAN processor, layout, and bucket name. The method comprises the steps of binding a file export template with a data processing class through a BEAN processor in the file export template, and realizing association of the file export template and the data processing class, wherein the file export template and the data processing class together complete the process of exporting the file. Each specific data processing class is distinguished by a Bean processor field configured in the file export template, the value of which is an identification number or tag. The template code or template name may be used as template information for searching the corresponding file to derive the template according to the template code or template name. The data format attribute is used to set the requested data content, data format, layout, and layout. The additional information attribute is used to add corresponding information to the export file.
In one embodiment, the file export templates include a business data template and a protocol data template. The data processing classes include a traffic data processing class and a protocol data processing class. The service data template is correspondingly bound with the service data processing class so as to be commonly used for acquiring the service data of the external system.
The protocol data template is correspondingly bound with the protocol data processing class so as to be commonly used for acquiring the protocol data of the external system. The files obtained from other destination systems and returned to the file requester system are called protocol data, and the files of the protocol data are generated by a third party service system, such as contract files, and the application does not perform secondary processing operation on the protocol data in the files. The protocol data and the service data may be the same data processing class if the same data processing procedure is adopted.
S30, acquiring data from the associated data sources by utilizing the data processing class to obtain a corresponding data file. Specifically, data is acquired from an associated data source through a data acquisition process in a data processing class.
In the step, the service data processing class acquires service data from a system corresponding to the data source place by using the service data template, and the protocol data processing class acquires a protocol file as protocol data from the system corresponding to the data source place by using the protocol data template.
S40, performing secondary processing on the data file according to the file export template to obtain an export file, and outputting the export file according to requirements. The specific secondary treatment comprises the following steps: and carrying out secondary processing on the data file according to the additional information attribute and the data format attribute in the file export template. The additional information attributes include: whether to watermark, watermark content, extension information, whether to desensitize and whether to sign a signature template. Therefore, the file export template can realize the functions of exporting the transverse or longitudinal layout of the file, desensitizing sensitive data, adding anti-theft watermarks to the generated file, signing a bank, generating pdf, doc, excel different files and the like through relevant configuration, and meets various complex file generation requirements.
The data format attributes include: data items and layout information are requested. The request data item is used to determine the number and content of the data pieces when the data is acquired from the data source. Layout typesetting information is used to determine the typesetting and layout of the requested data item and the corresponding data value when generating the base export file. The application does not perform secondary data processing operation on the protocol data in the file, so that only the business data template has data format attribute.
In one embodiment, if the file export template is a business data template, performing secondary processing on the data file according to the file export template, including:
1) And carrying out format processing on the data file according to the data format attribute of the service data template to generate a basic export file. As shown in fig. 2, all of the basic attributes are included in the business data template.
In one embodiment, the data format attribute comprises: a data sub-template; the data sub-templates comprise request data items, placeholders and typesetting layout information which are determined according to service requirements, and each request data item and the placeholder are typeset and laid according to the set typesetting layout information; the placeholders are used to provide a location for the data value of the requested data item when the underlying export file is generated. The data sub-templates are realized by setting template addresses and template suffixes in the service data templates. The template address is used to upload the template, i.e. the data sub-template, from which the base export file is to be generated. The data sub-templates are placeholder files, which can be html, doc, pdf and excel files, and realize control of specific data content and typesetting layout, even if the content and format of the exported file are modified later, only the content of the data sub-templates is modified, then the exported file is uploaded again, and the exported file is regenerated without modifying codes or distributing and redeploying. As shown in FIG. 3, the data sub-template is laid out in a tabular form, and the request data items include a buried event, a buried event name, a buried event time, a buried event operation description, a client name, a company number, an enterprise name, and the like. The next row empty position of each data item is a placeholder reserved for the data value corresponding to the data item.
In one embodiment, the business data processing class further comprises: cleaning data process, filtering data process, secondary processing data process, etc. Before the data file is formatted according to the data format attribute of the service data template, first, the request data needs to be cleaned by a cleaning data process. Then, the requested data is subjected to filtering processing by a filtering data process. And finally, carrying out secondary processing treatment on the request data through a secondary processing data process. The secondary processing data process is determined according to the service requirement, and is not limited herein.
2) And processing the additional information of the basic export file according to the additional information attribute of the service data template to obtain the export file.
Additional information attributes of the business data template include: whether to watermark, watermark content, extension information, whether to desensitize and whether to sign, and signing template ID. Specifically, the processing of the additional information is performed according to the attribute value of the additional information, for example, when the watermark is selected to be added, the watermark content is added to the basic export file, and when the signature is selected to be added, the corresponding signature is found according to the signature template ID, and the signature is added to the basic export file.
If the file export template is a protocol data template, performing secondary processing on the data file according to the file export template, including:
and processing the additional information of the data file according to the additional information attribute of the protocol data template to obtain the export file. As shown in fig. 4, the basic attributes of the protocol data template include: template encoding, template name, file type, file suffix, data source location, data source type, BEAN processor, and bucket name. Additional information attributes of the protocol data template include: whether to watermark, watermark content and extension information.
Fig. 5 shows an application scenario of a file export method of the present application, specifically including the following steps:
s100, a file requester transmits in a template number to request to generate an export file.
S200, judging whether the type of the file export template is a business data template or a protocol data template.
S210, if the type of the file export template is a service data template, searching to obtain a service data processing class bound by the service data template.
S211, according to the request data items in the service data template, acquiring data values corresponding to the request data items in the third-party service system from a data source by utilizing the data acquisition process in the service data processing class, and obtaining a data file.
S212, cleaning, assembling, filtering and secondary processing (data conversion) are sequentially carried out on the data file by utilizing a cleaning data process, an assembling data process, a data filtering process, a secondary processing data process and the like in the service data processing class, so as to obtain basic derived data.
And S213, replacing the basic export data with the placeholders corresponding to the request data items to obtain the basic export file.
And S214, performing secondary processing, such as desensitization, bank signature adding, watermark adding and the like, on the basic export file according to the additional information attribute in the service data template, and finally obtaining the export file corresponding to the service data.
S220, if the type of the file export template is a protocol data template, searching to obtain a protocol data processing class bound by the protocol data template.
S211, acquiring the corresponding file in the third party service system from the data source by utilizing the data acquisition process in the protocol data processing class to obtain the data file.
S212, carrying out secondary processing on the data file, such as adding watermark and the like, according to the additional information attribute in the protocol data template, and finally obtaining the export file corresponding to the protocol data.
In one embodiment, the method further comprises saving the export file in a storage service in accordance with the template information.
The export files of the service data types are uniformly managed, for example, the generated export files can be uniformly managed by the management page for the service data. As shown in fig. 6, the service data management page includes a number, an application flow, a request flow, a file type, a template code, a bucket name, a file address, a file suffix, a retry number, a processing status, an application parameter, notes, operations, and the like. The file types comprise a short message with a notification of early expiration, a prompt record, a repayment flow, a repayment plan, a specified and legal representative, and the like. The operations include a view function, an edit function, and a download function.
The export files of the protocol data types are uniformly managed, for example, the generated export files can be uniformly managed through a management page. As shown in fig. 7, the protocol data management page includes a number, an application pipeline, a request pipeline, a file type, a template code, a bucket name, a file address, a file suffix, a retry number, a processing status, an application parameter, notes, operations, and the like. The file types include a payoff certificate, a delivery address validation agreement-a guarantee person, a borrowing contract, a payoff certificate, a highest amount guarantee contract, and the like. The operations include a view function, an edit function, and a download function. The template code can be stored as template information corresponding to the export file.
In order to improve the efficiency of exporting files, when template information is received, the template information is firstly searched in a storage service, and if the exported file corresponding to the template information is searched, the exported file is directly output. Specifically, the export file may be stored according to the template code, and when the template code sent by other systems is received, whether the corresponding export file exists or not is searched according to the template code, if so, the export file is directly obtained for export in the next step. If not, the processing is performed according to the steps S20 to S40.
In one embodiment, the method further comprises data export management, and outputting the export file according to the requirements comprises: generating an approval file according to the export file and sending the approval file to a corresponding approver; and outputting the export file after receiving the approval confirmation information. Most of the derived files generated by the method are sensitive information files, and the derived files can be derived only after approval and confirmation. The OA application form can be automatically initiated by communication connection with an OA system. When relevant file data is exported, the type of the exported file and the exported type (such as desensitization) are selected, the exported reason is written, then the file to be exported is selected, an OA application form is submitted, the file is sent to a corresponding lead approval through an OA system, and the data can be exported normally after approval confirmation information is obtained, so that the risk of data leakage is avoided. The various operations described above may be implemented using a visualization page, as shown in FIG. 8. Wherein the derived file types include business owner identity information, business owner rights, contract agreements, business information, and the like. The identity information of the enterprise owner comprises an identity card image, a networking check result, a face recognition image, an identity card information table and the like.
According to the method and the device, the file export template is abstracted according to service data requirements, so that the generated export file can meet the requirements on complexity and variability of the content of the export file through simple configuration, for example, the request data item in the data sub-template is changed, the data content of a change request is realized, the additional information attribute in the file export template is modified, the modification of the additional information can be realized, and the method and the device are high in flexibility and convenient to modify. Meanwhile, the file export templates and the data processing classes are mutually independent, and different file export templates can adopt the same data processing class when the business data processing processes are the same, so that the reusability and the independence of codes are improved, and the characteristics of high cohesion and low coupling are more satisfied. Compared with the direct butt joint among the systems in the prior art, the method and the device for directly acquiring the data and generating the files respectively have high processing efficiency.
The method and the device uniformly store, maintain and manage the generated export files, the generated files are prevented from scattering all storage media of all systems, so that the risk of sensitive data leakage exists. Meanwhile, the export file which is needed to be exported and generated also needs to be audited by the relevant leader responsible person, and the export can be achieved only after the audit passes, so that the safety of the file data is ensured, and the leakage risk is reduced. In addition, whether the stored export file meets the requirement is also searched before the export file is generated, if yes, secondary generation is not needed, and the processing efficiency is further improved, so that a business party is focused on business development instead of the process of file generation and system docking, the high-efficiency system development and business decoupling capability is realized, and the maintenance and expansion of a system are facilitated.
Fig. 9 shows a schematic structural diagram of a file exporting apparatus according to an embodiment of the present application. The file deriving means exemplarily includes: a request receiving module 910, a template determining module 920, a data obtaining module 930, and a file exporting module 940.
The request receiving module 910 is configured to receive template information sent by a file requester according to a service requirement.
The template determining module 920 is configured to determine a corresponding file export template in the template library according to the template information; wherein the attributes of the file export template include data source and bound data processing class; the data processing class includes a process of acquiring data. The template determination module 920 includes a file export template set according to each service requirement. The file export templates may employ html, doc, pdf, excel, etc. The file export template includes basic attributes, data format attributes, additional information attributes, and the like. The attribute values can be directly modified in the file, or the file can be loaded to a visual editing page and edited through the page. Preferably, in this embodiment, the data format attribute is placed in the data sub-template, and the data sub-template is used as an attribute of the export file template, so that the export file template can be edited and uploaded through the page, and is convenient to modify.
The data obtaining module 930 is configured to obtain data from a data source through a data obtaining process in the data processing class, so as to obtain a corresponding data file. The data acquisition module 930 includes data processing classes corresponding to each service data processing procedure.
The file export module 940 is configured to perform secondary processing on the data file according to the file export template to obtain an export file, and output the export file according to the requirement.
In one embodiment, the apparatus further comprises a data management module for storing the export file in a storage service according to the template information. Specifically, the management page may be used to uniformly manage each exported file. The management page comprises a business data management page and a protocol data management page. As shown in fig. 6 and 7.
In order to improve the efficiency of exporting files, the device further comprises a retrieval module, when the request receiving module 910 receives the template information, the retrieval module firstly retrieves in the storage service according to the template information, and if the exported file corresponding to the template information is retrieved, the retrieval module directly outputs the exported file. Specifically, the export file may be stored according to the template code, and when the template code sent by other systems is received, whether the corresponding export file exists or not is searched according to the template code, if so, the export file is directly obtained for export in the next step. If not, the processing is performed according to steps S20 to S40 in an embodiment of the file deriving method.
In one embodiment, the apparatus further includes a data export management module, as shown in fig. 8, where the export management module is configured to generate an approval file according to the export file, send the approval file to a corresponding approver, and output the export file after receiving the approval confirmation information. Most of the derived files generated by the method are sensitive information files, and the derived files can be derived only after approval and confirmation. The application is in communication connection with an OA system, and can automatically initiate an OA application form of a exporting task. When relevant file data is exported, files to be exported are required to be firstly selected, OA application forms are submitted, the files are sent to corresponding lead approval through an OA system, and the data can be normally exported after approval confirmation information is obtained, so that the risk of data leakage is avoided.
It will be appreciated that the apparatus of this embodiment corresponds to the file export method of the above embodiment, and the options in the above embodiment are equally applicable to this embodiment, so the description will not be repeated here.
The application also provides a terminal device, which exemplarily comprises a processor and a memory, wherein the memory stores a computer program, and the processor executes the computer program, so that the terminal device executes the file export method or the functions of each module in the file export device.
The processor may be an integrated circuit chip with signal processing capabilities. The processor may be a general purpose processor including at least one of a central processing unit (Central Processing Unit, CPU), a graphics processor (Graphics Processing Unit, GPU) and a network processor (Network Processor, NP), a Digital Signal Processor (DSP), an Application Specific Integrated Circuit (ASIC), an off-the-shelf programmable gate array (FPGA) or other programmable logic device, discrete gate or transistor logic device, discrete hardware components. A general purpose processor may be a microprocessor or the processor may be any conventional processor or the like that may implement or perform the methods, steps, and logic blocks disclosed in embodiments of the present application.
The Memory may be, but is not limited to, random access Memory (Random Access Memory, RAM), read Only Memory (ROM), programmable Read Only Memory (Programmable Read-Only Memory, PROM), erasable Read Only Memory (Erasable Programmable Read-Only Memory, EPROM), electrically erasable Read Only Memory (Electric Erasable Programmable Read-Only Memory, EEPROM), etc. The memory is used for storing a computer program, and the processor can correspondingly execute the computer program after receiving the execution instruction.
The present application also provides a readable storage medium for storing the computer program for use in the above terminal device.
In the several embodiments provided in this application, it should be understood that the disclosed apparatus and method may be implemented in other manners as well. The apparatus embodiments described above are merely illustrative, for example, of the flow diagrams and block diagrams in the figures, which illustrate the architecture, functionality, and operation of possible implementations of apparatus, methods and computer program products according to various embodiments of the present application. In this regard, each block in the flowchart or block diagrams may represent a module, segment, or portion of code, which comprises one or more executable instructions for implementing the specified logical function(s). It should also be noted that, in alternative implementations, the functions noted in the block may occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functionality involved. It will also be noted that each block of the block diagrams and/or flowchart illustration, and combinations of blocks in the block diagrams and/or flowchart illustration, can be implemented by special purpose hardware-based systems which perform the specified functions or acts, or combinations of special purpose hardware and computer instructions.
In addition, functional modules or units in the embodiments of the present application may be integrated together to form a single part, or each module may exist alone, or two or more modules may be integrated to form a single part.
The functions, if implemented in the form of software functional modules and sold or used as a stand-alone product, may be stored in a computer-readable storage medium. Based on such understanding, the technical solution of the present application may be embodied essentially or in a part contributing to the prior art or in a part of the technical solution, in the form of a software product stored in a storage medium, comprising several instructions for causing a computer device (which may be a smart phone, a personal computer, a server, or a network device, etc.) to perform all or part of the steps of the methods described in the embodiments of the present application. And the aforementioned storage medium includes: a U-disk, a removable hard disk, a Read-Only Memory (ROM), a random access Memory (RAM, random Access Memory), a magnetic disk, or an optical disk, or other various media capable of storing program codes.
The foregoing is merely specific embodiments of the present application, but the scope of the present application is not limited thereto, and any person skilled in the art can easily think about changes or substitutions within the technical scope of the present application, and the changes and substitutions are intended to be covered by the scope of the present application.
Claims (10)
1. A method of exporting a file, comprising:
template information sent by a file requesting party according to service requirements is received;
determining a corresponding file export template in a template library according to the template information; wherein the attributes of the file export template include data origin and associated data processing classes;
acquiring data from the associated data sources by utilizing the data processing class to obtain a corresponding data file;
and carrying out secondary processing on the data file according to the file export template to obtain an export file, and outputting the export file according to requirements.
2. The file export method of claim 1, wherein the file export templates comprise a business data template and a protocol data template; the data processing class comprises a business data processing class and a protocol data processing class;
wherein, the business data template is correspondingly associated with the business data processing class so as to be commonly used for acquiring business data in an external system; the protocol data templates are correspondingly associated with the protocol data processing classes for commonly obtaining protocol data in an external system.
3. The method according to claim 2, wherein if the file export template is the service data template, the performing the secondary processing on the data file according to the file export template includes:
carrying out format processing on the data file according to the data format attribute of the service data template so as to generate a basic export file;
processing additional information of the basic export file according to the additional information attribute of the service data template to obtain the export file;
if the file export template is the protocol data template, the performing secondary processing on the data file according to the file export template includes:
and processing the additional information of the data file according to the additional information attribute of the protocol data template to obtain the export file.
4. A file exporting method according to claim 3, wherein the data format attribute comprises a request data item and typesetting layout information;
wherein the request data item is used for determining the number and content of data pieces when acquiring data from the data source; the layout typesetting information is used for determining typesetting and layout of the request data items and corresponding data values when the basic export file is generated.
5. A file export method according to claim 3, wherein the data format attribute comprises: a data sub-template; the data sub-templates comprise request data items, placeholders and typesetting layout information which are determined according to the service requirements;
wherein, each request data item and the placeholder carry out typesetting layout according to the set typesetting layout information; the placeholder is used to provide a location for the data value of the requested data item when the base export file is generated.
6. The file export method of claim 4, wherein the business data processing class comprises: at least one of a cleaning data process, a filtering data process, and a secondary processing data process;
before the data file is formatted according to the data format attribute of the service data template, the method further comprises the following steps:
cleaning the request data through the cleaning data process; and/or, filtering the request data through the data filtering process; and/or performing secondary processing on the request data through the secondary processing data process.
7. The method for exporting a file according to any of claims 2 to 6,
the additional information attribute of the business data template comprises: whether at least one of watermarking, watermark content, extension information, whether desensitizing and whether signing, and signing template ID;
the additional information attributes of the protocol data template include: whether at least one of watermark, watermark content and extension information.
8. The file export method of any of claims 1-6, further comprising: storing the exported file in a storage service according to the template information;
and when the template information is received, searching in the storage service according to the template information, and outputting the export file if the export file corresponding to the template information is searched.
9. The file export method according to any of claims 1 to 6, wherein the exporting the exported file according to the requirements comprises:
generating an approval file according to the export file and sending the approval file to a corresponding approver; and outputting the export file after receiving the approval confirmation information.
10. A terminal device, characterized in that it comprises a processor and a memory, the memory storing a computer program, the processor being adapted to execute the computer program to implement the file export method according to any of claims 1-9.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310671691.7A CN116401218B (en) | 2023-06-08 | 2023-06-08 | File export method and terminal equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310671691.7A CN116401218B (en) | 2023-06-08 | 2023-06-08 | File export method and terminal equipment |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN116401218A true CN116401218A (en) | 2023-07-07 |
| CN116401218B CN116401218B (en) | 2023-09-19 |
Family
ID=87010884
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202310671691.7A Active CN116401218B (en) | 2023-06-08 | 2023-06-08 | File export method and terminal equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN116401218B (en) |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2015021394A2 (en) * | 2013-08-09 | 2015-02-12 | Axiom Global Inc. | Document generation, interpretation, and administration system with built in workflows and analytics |
| WO2019071932A1 (en) * | 2017-10-09 | 2019-04-18 | 平安科技（深圳）有限公司 | Service email sending method and device, terminal device, and medium |
| CN113449236A (en) * | 2021-07-09 | 2021-09-28 | 中国银行股份有限公司 | Method and device for generating and storing electronic protocol of bank system |
| CN113627145A (en) * | 2021-08-02 | 2021-11-09 | 上海浦东发展银行股份有限公司 | Method, device, equipment and medium for generating file of parameterized configuration |
| CN114022031A (en) * | 2021-11-23 | 2022-02-08 | 中国工商银行股份有限公司 | Data processing method, data processing apparatus, electronic device, medium, and computer program product |
| CN114090124A (en) * | 2021-11-23 | 2022-02-25 | 智器云南京信息科技有限公司 | Data processing method, data processing device, computer equipment and storage medium |
| CN114860668A (en) * | 2022-05-17 | 2022-08-05 | 中国银行股份有限公司 | Online dynamic generation method and device for data file |
-
2023
- 2023-06-08 CN CN202310671691.7A patent/CN116401218B/en active Active
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2015021394A2 (en) * | 2013-08-09 | 2015-02-12 | Axiom Global Inc. | Document generation, interpretation, and administration system with built in workflows and analytics |
| WO2019071932A1 (en) * | 2017-10-09 | 2019-04-18 | 平安科技（深圳）有限公司 | Service email sending method and device, terminal device, and medium |
| CN113449236A (en) * | 2021-07-09 | 2021-09-28 | 中国银行股份有限公司 | Method and device for generating and storing electronic protocol of bank system |
| CN113627145A (en) * | 2021-08-02 | 2021-11-09 | 上海浦东发展银行股份有限公司 | Method, device, equipment and medium for generating file of parameterized configuration |
| CN114022031A (en) * | 2021-11-23 | 2022-02-08 | 中国工商银行股份有限公司 | Data processing method, data processing apparatus, electronic device, medium, and computer program product |
| CN114090124A (en) * | 2021-11-23 | 2022-02-25 | 智器云南京信息科技有限公司 | Data processing method, data processing device, computer equipment and storage medium |
| CN114860668A (en) * | 2022-05-17 | 2022-08-05 | 中国银行股份有限公司 | Online dynamic generation method and device for data file |
Also Published As
| Publication number | Publication date |
|---|---|
| CN116401218B (en) | 2023-09-19 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11176518B2 (en) | Systems, methods and apparatus for form building | |
| Aggarwal et al. | Blockchain 2.0: smart contracts | |
| CN108549623B (en) | Collaborative document editing control method and device, electronic equipment and storage medium | |
| CN110287383B (en) | Method and device for checking field information | |
| CN104520834B (en) | For to third-party application it is end-to-end exposure native data type derived expression system and method | |
| US7716570B2 (en) | Interfaces for creation and access of extensible markup language paper specification documents | |
| CN108268253A (en) | Interface code generation method and terminal device | |
| US20040199876A1 (en) | Reversible document format | |
| CN112329419A (en) | Document editing method, device, server, terminal and storage medium | |
| CN109582473A (en) | Across chain data access method and device based on block chain | |
| KR20080045698A (en) | Digital signing policy | |
| CN109360070B (en) | Tourism information processing method, device, equipment and storage medium based on alliance chain | |
| CN111352935A (en) | Index creating method, device and equipment in block chain type account book | |
| CN113627145A (en) | Method, device, equipment and medium for generating file of parameterized configuration | |
| KR20150064822A (en) | System for management of electronic documents | |
| CN114237587A (en) | Management and control method and system based on IDEA technical service SmartFlow | |
| US20110179036A1 (en) | Methods and Apparatuses For Abstract Representation of Financial Documents | |
| CN116401218B (en) | File export method and terminal equipment | |
| CN117522094A (en) | Seal management method, platform, electronic equipment and storage medium | |
| CN116957512A (en) | Payment platform message management method, device and computer readable storage medium | |
| CN111324645A (en) | Data processing method and device for block chain | |
| CN102298669A (en) | Medical image processing server and managing method for medical image processing server | |
| CN116107623A (en) | Software development method and device and electronic equipment | |
| CN113112270B (en) | Data organization method based on block chain | |
| CN113806817A (en) | Method for constructing twin NFT, NFT protocol and system for full trusted storage |
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 |