CN110278143A - E-mail data processing method, device, computer equipment and storage medium - Google Patents
E-mail data processing method, device, computer equipment and storage medium Download PDFInfo
- Publication number
- CN110278143A CN110278143A CN201910371058.XA CN201910371058A CN110278143A CN 110278143 A CN110278143 A CN 110278143A CN 201910371058 A CN201910371058 A CN 201910371058A CN 110278143 A CN110278143 A CN 110278143A
- Authority
- CN
- China
- Prior art keywords
- report
- rule
- data
- 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
Classifications
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L51/00—User-to-user messaging in packet-switching networks, transmitted according to store-and-forward or real-time protocols, e.g. e-mail
- H04L51/07—User-to-user messaging in packet-switching networks, transmitted according to store-and-forward or real-time protocols, e.g. e-mail characterised by the inclusion of specific contents
- H04L51/08—Annexed information, e.g. attachments
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L51/00—User-to-user messaging in packet-switching networks, transmitted according to store-and-forward or real-time protocols, e.g. e-mail
- H04L51/42—Mailbox-related aspects, e.g. synchronisation of mailboxes
Landscapes
- Engineering & Computer Science (AREA)
- Computer Networks & Wireless Communication (AREA)
- Signal Processing (AREA)
- Information Transfer Between Computers (AREA)
Abstract
The embodiment of the present application belongs to information security field, it is related to a kind of e-mail data processing method, device, computer equipment and storage medium, method includes: to obtain Email Body and attachment to be tested, e-mail attachment includes report and rule file, and the rule file includes the data detection rule and format check rule for examining the report；It is tested according to the rule file to the report, obtain inspection result, if the inspection result includes warning information, the warning information includes at least one of data exception information, format exception information, then is handled based on the warning information the Email；By treated, Email is sent to mail server.It is tested by data detection rule in rule file and format check rule to sent Email, and performed corresponding processing according to the warning information in inspection result, to reduce the content of Email, there is a situation where error in data and format are abnormal.
Description
Technical field
This application involves field of information security technology more particularly to e-mail data processing method, device, computer to set
Standby and storage medium.
Background technique
Cybertimes, Email is a kind of mode of common and effective exchange of information, in our life and work
In play an important role, such as momentous conference's notice, working report etc..General Email includes that text and attachment two are big
Part, especially attachment include a large amount of and important data such as document, table, if because artificial origin causes these heavy
It wants shortage of data or mistake occurs and cannot find and correct in time, it will addressee is caused to obtain the information of mistake and do
The judgement or action to make mistake can all cause undesirable influence to addressee and sender.
At present to sent the content of Email especially attachment (such as report), it is regular that there are no unified verifications,
So that the data check afunction of report, format can not be arranged, error in data occurs so as to cause the content of Email
Situations such as abnormal with format.
Summary of the invention
The purpose of the embodiment of the present application be to propose a kind of e-mail data processing method, device, computer equipment and
Storage medium, reducing the content of Email, there is a situation where error in data and format are abnormal.
In order to solve the above-mentioned technical problem, the embodiment of the present application provides a kind of e-mail data processing method, uses
Technical solution as described below:
Include the following steps:
Email Body and attachment to be tested are obtained, e-mail attachment includes report and rule file, the rule
Then file includes the data detection rule and format check rule for examining the report；
It is tested according to the rule file to the report, obtains inspection result, if the inspection result includes accusing
Alert information, the warning information include at least one of data exception information, format exception information, then are based on the warning information
The Email is handled；
By treated, Email is sent to mail server.
Further, described the step of obtaining Email Body and attachment to be tested, specifically includes:
Configuration file is obtained, the configuration file includes configuration parameter；
The Email Body and attachment to be tested are obtained according to the configuration parameter of the configuration file.
Further, the step of testing to the report according to the rule file, obtain inspection result tool
Body includes:
The data of the report are checked according to the rule file, if it exists data exception, then obtain data exception information；
And/or
The formatting of the report is checked according to the rule file, format is abnormal if it exists, then obtains format and believe extremely
Breath.
Further, the step of data that the report is checked according to the rule file are specific further include:
Check whether report is empty according to the data inspection rule in the rule file；And/or
Rule verification report key coordinate point data is checked according to the data in the rule file.
Further, the step of formatting that the report is checked according to the rule file is specific further include:
Check that the ranks of report table freeze according to the formatization rule in the rule file；And/or
The link creation of report table is checked according to the formatization rule in the rule file.
Further, described the step of being handled based on the warning information the Email, is specifically included:
Data processing, including report are carried out according to report of the data exception information of the warning information to the Email
Table is empty and report key coordinate point data not in default range；
Processing is formatted to the report of the Email according to the format exception information of the warning information, including
Freeze the link of the ranks and creation report table of report table.
Further, described will be before treated the step of Email is sent to mail server further include:
The address information of the mail server is read according to the configuration parameter of the configuration file；
It is described will treated the step of Email is sent to mail server further include:
According to the address information of the mail server, by treated, Email is sent to mail server.
In order to solve the above-mentioned technical problem, the embodiment of the present application also provides a kind of e-mail data processing unit, uses
Technical solution as described below:
The e-mail data processing unit, comprising:
Module is obtained, for obtaining Email Body and attachment to be tested, e-mail attachment includes report and rule
Then file, the rule file include the data detection rule and format check rule for examining the report；
Correction verification module obtains inspection result, if the inspection for testing according to the rule file to the report
Testing result includes warning information, and the warning information includes at least one of data exception information, format exception information, then is based on
The warning information handles the Email；
Sending module, for Email to be sent to mail server by treated.
In order to solve the above-mentioned technical problem, the embodiment of the present application also provides a kind of computer equipment, uses as described below
Technical solution:
The computer equipment, including memory and processor are stored with computer program, the place in the memory
Reason device realizes the described in any item e-mail datas processing proposed in the embodiment of the present application when executing the computer program
The step of method.
In order to solve the above-mentioned technical problem, the embodiment of the present application also provides a kind of computer readable storage medium, uses
Technical solution as described below:
Computer program is stored on the computer readable storage medium, when the computer program is executed by processor
The step of realizing the described in any item e-mail data processing methods proposed in the embodiment of the present application.
Compared with prior art, the embodiment of the present application mainly has following the utility model has the advantages that obtaining Email to be tested just
Text and attachment, e-mail attachment include report and rule file, and the rule file includes the number for examining the report
According to inspection rule and format check rule；It is tested according to the rule file to the report, obtains inspection result, if institute
Stating inspection result includes warning information, and the warning information includes at least one of data exception information, format exception information, then
The Email is handled based on the warning information；By treated, Email is sent to mail server.It is logical
The data detection rule and format check rule crossed in rule file carry out data detection to sent the content of Email
Examined with formatting, and according to the warning information in inspection result to sent Email carry out corresponding data processing and
Format analysis processing, to reduce the content of Email, there is a situation where error in data and format are abnormal.
Detailed description of the invention
It, below will be to needed in the embodiment of the present application description in order to illustrate more clearly of the scheme in the application
Attached drawing makees a simple introduction, it should be apparent that, the accompanying drawings in the following description is some embodiments of the present application, for this field
For those of ordinary skill, without creative efforts, it is also possible to obtain other drawings based on these drawings.
Fig. 1 is that this application can be applied to exemplary system architecture figures therein；
Fig. 2 is according to the flow chart of one embodiment of the e-mail data processing method of the application；
Fig. 3 is a kind of flow chart of specific embodiment of step 201 in Fig. 2；
Fig. 4 is a kind of flow chart of specific embodiment of step 202 in Fig. 2；
Fig. 5 is a kind of flow chart of specific embodiment of step 2021 in Fig. 4；
Fig. 6 is a kind of flow chart of specific embodiment of step 2022 in Fig. 4；
Fig. 7 is a kind of flow chart of specific embodiment of step 202 in Fig. 2；
Fig. 8 is the structural schematic diagram according to one embodiment of the e-mail data processing unit of the application；
Fig. 9 is a kind of structural schematic diagram of specific embodiment of correction verification module 802 shown in Fig. 8；
Figure 10 is the structural schematic diagram according to one embodiment of the computer equipment of the application.
Specific embodiment
Unless otherwise defined, all technical and scientific terms used herein and the technical field for belonging to the application
The normally understood meaning of technical staff is identical；It is specific that description is intended merely in the term used in the description of application herein
Embodiment purpose, it is not intended that in limitation the application；The description and claims of this application and above-mentioned Detailed description of the invention
In term " includes " and " having " and their any deformation, it is intended that cover and non-exclusive include.The application's says
Bright book and claims or term " first " in above-mentioned attached drawing, " second " etc. rather than are used for distinguishing different objects
In description particular order.
Referenced herein " embodiment " is it is meant that a particular feature, structure, or characteristic described can wrap in conjunction with the embodiments
It is contained at least one embodiment of the application.Each position in the description occur the phrase might not each mean it is identical
Embodiment, nor the independent or alternative embodiment with other embodiments mutual exclusion.Those skilled in the art explicitly and
Implicitly understand, embodiment described herein can be combined with other embodiments.
In order to make those skilled in the art more fully understand application scheme, below in conjunction with attached drawing, to the application reality
The technical solution applied in example is clearly and completely described.
As shown in Figure 1, system architecture 100 may include terminal device 101,102,103, network 104 and server 105.
Network 104 between terminal device 101,102,103 and server 105 to provide the medium of communication link.Network 104 can be with
Including various connection types, such as wired, wireless communication link or fiber optic cables etc..
User can be used terminal device 101,102,103 and be interacted by network 104 with server 105, to receive or send out
Send message etc..Various telecommunication customer end applications can be installed, such as web browser is answered on terminal device 101,102,103
With, shopping class application, searching class application, instant messaging tools, mailbox client, social platform software etc..
Terminal device 101,102,103 can be the various electronic equipments with display screen and supported web page browsing, packet
Include but be not limited to smart phone, tablet computer, E-book reader, MP3 player (Moving Picture Experts
Group Audio Layer III, dynamic image expert's compression standard audio level 3), MP4 (Moving Picture
Experts Group Audio Layer IV, dynamic image expert's compression standard audio level 4) it is player, on knee portable
Computer and desktop computer etc..
Server 105 can be to provide the server of various services, such as to showing on terminal device 101,102,103
The page provides the background server supported.
It should be noted that e-mail data processing method provided by the embodiment of the present application is generally by server/end
End equipment executes, and correspondingly, e-mail data processing unit is generally positioned in server/terminal equipment.
It should be understood that the number of terminal device, network and server in Fig. 1 is only schematical.According to realization need
It wants, can have any number of terminal device, network and server.
With continued reference to Fig. 2, the stream of one embodiment of the method handled according to the e-mail data of the application is shown
Cheng Tu.The e-mail data processing method, comprising the following steps:
Step 201, Email Body and attachment to be tested are obtained, e-mail attachment includes report and rule text
Part, the rule file include the data detection rule and format check rule for examining the report.
Wherein, above-mentioned Email can be by the terminal device Mail Clients in above-mentioned system architecture 100 shown in FIG. 1
It generates, is also possible to generate by the mail generating platform server in above system framework 100.
It should be noted that the electronic equipment for running above-mentioned e-mail data processing method can be it is as shown in Figure 1
Server/terminal equipment is also possible to the terminal device or mail generating platform server of above-mentioned generation Email, that is,
It says, generation, verification and the processing of Email can be on same electronic equipment, be also possible in different electronic equipments
On carried out by wired or wireless network connection type above-mentioned Email generation, verification and processing, transmission process；Such as
The generation of the above-mentioned Email of fruit is in an independent server/terminal equipment, then the verification of Email, processing and transmission
Another server/terminal equipment at place needs to obtain the address letter of the server/terminal equipment of above-mentioned generation Email
Breath；Generally the address information can be written to configuration file by the server/terminal equipment of generation Email, then passed through
The configuration file is sent to the server/terminal equipment for verifying and handling Email by network, can also by above-mentioned verification and
The server/terminal equipment of processing Email passes through the above-mentioned configuration file of network activly request and is stored in local；By this
Configuration file, the server/terminal equipment for running above-mentioned e-mail data processing method are available to electronics to be processed
Mail.
In the present embodiment, electronic equipment (such as the clothes shown in FIG. 1 of e-mail data processing method operation thereon
Business device/terminal device) can be obtained by wired connection mode or radio connection Email Body to be tested and
Attachment.It should be pointed out that above-mentioned radio connection can include but is not limited to 3G/4G connection, WiFi connection, bluetooth company
Connect, WiMAX connection, Zigbee connection, UWB (ultra wideband) connection and other it is currently known or in the future exploitation
Radio connection.Wired connection mode can include but is not limited to the connection of the Ethernets such as optical fiber, cable.
Step 202, it is tested according to the rule file to the report, obtains inspection result, if the inspection is tied
Fruit includes warning information, and the warning information includes at least one of data exception information, format exception information, then based on described
Warning information handles the Email.
In the present embodiment, above-mentioned rule file can be label file such as XML file, be also possible to text file such as
TXT etc., including a series of rules for being used to examine above-mentioned report data and format, above-mentioned report be can be including data to be tested
Microsoft Excel.
Above-mentioned test to report may include data inspection and format checking, wherein data inspection may include inspection
Look into whether report is empty and/or verification report key coordinate point data, format checking may include the ranks for checking report table
Freeze and/or checks whether the link creation of report table is correct；If above-mentioned data inspection and/or format checking exist abnormal
Information then obtains exception information, which may include that report does not exist for empty and/or report key coordinate point data
In default range, the ranks of report table do not freeze or the link of freezed error and/or report table does not create or create mistake
Accidentally；Then it is correspondingly processed according to above-mentioned exception information to above-mentioned report, for example, if above-mentioned exception information includes that report is
Sky, then toward the report be written in above-mentioned rule file the data that should include about the report of data detection regular record or
The report is deleted；For another example, if the ranks that above-mentioned exception information includes report table do not freeze, according to above-mentioned rule file
In format check rule freeze the specified ranks of the report table.
Step 203, by treated, Email is sent to mail server.
In the present embodiment, above-mentioned mail server can be the server 105 in above system framework 100, for connecing
The mail that receiving emails client is sent, the Mail Clients can be answering on the terminal device operated in above system framework
With program, for generating and sending mail；In the possible situation of other, above-mentioned Mail Clients application program can also be with
Operation is on the server.It should be noted that the mail to be sent that above-mentioned Mail Clients application program generates can pass through
E-mail data processing method provided in this embodiment is then forwarded to above-mentioned postal after carrying out the verifying and handling of above-mentioned steps 202
Part server.
In the present embodiment, Email Body and attachment to be tested are obtained, e-mail attachment includes report and rule
File；It is tested according to the rule file to the report, obtains inspection result, if the inspection result includes alarm letter
Breath, the warning information includes at least one of data exception information, format exception information, then based on the warning information to institute
Email is stated to be handled；By treated, Email is sent to mail server.By to sent Email
Content carry out data and format to examine, and performed corresponding processing according to the warning information in inspection result, to reduce
There is a situation where error in data and format are abnormal for the content of Email.
Further, as shown in figure 3, above-mentioned steps 201 may include:
Step 2011, configuration file is obtained, the configuration file includes configuration parameter.
Wherein, above-mentioned configuration file can be stored in local server/terminal device, and file type can be suffix and be
The text file of ini, yaml, cfg, json are also possible to the form of script, such as python script, perl script；It is above-mentioned to match
Setting parameter may include the paired data from the above-mentioned configuration file key read and value.
In one possible implementation, it can actively be obtained and be saved described to configuration server by network in real time
Configuration file is to local server/terminal device；Network can also be passed through at regular intervals by configuration server by configuration file
It is sent to local server/terminal device.
In alternatively possible implementation, the state that configuration server checks continually on configuration file can be, it will most
New configuration file is sent to local server/terminal device in real time, to guarantee that local server/terminal device is available most
New configuration parameter is normal to execute other programs and realize corresponding function.
Step 2012, the Email Body to be tested and attached is obtained according to the configuration parameter of the configuration file
Part.
Wherein, Email Body is MHT file by mail generating platform server process, and attachment includes report and rule
Then file；Report can be excel form document, and wherein excel form document includes data to be verified, and rule file includes
A series of rules for inspection data；The configuration file record of above-mentioned local server/terminal device has mail generating platform
The relevant configuration information of server, such as server address, title, user name, can be raw with mail by these configuration informations
Connection is established at Platform Server.
It is noted that the configuration parameter that above-mentioned steps 2011 are got includes the generation journal file of Email,
According to the generation journal file of the above-mentioned available Email of configuration parameter, which includes the generation of Email
Above-mentioned journal file is saved in memory, disk or write-in database to accelerate to deposit by time, local server/terminal device
Take speed；Then the above-mentioned Email generation time was compared with local server/terminal device time on the same day, is determined
Whether Email is obtained from mail generating platform server, for example, local server/terminal device time on the same day is
December 30 point to 2018 of on December 3rd, 2018 23:59, if it is December 3 in 2018 that the mail in date file, which generates the time,
8 points of day, then download the mail；The postal is not downloaded if the mail in date file generates the time as 23 points of December 2 in 2018
Part.
Further, as shown in figure 4, being tested according to the rule file to the report in above-mentioned steps 202,
The step for obtaining inspection result may include:
Step 2021, the data of the report are checked according to the rule file, if it exists data exception, then obtain data
Exception information.
Wherein, report may include one or more excel form documents, can when there are multiple excel form documents
With with comma ", it " is separated；Need to carry out data inspection according to the data detection rule reading in above-mentioned rule file
Excel form document, and judge whether its content is sky, if it is sky, exports the data exception that this document is empty file and believe
Breath；According to the key coordinate point that the needs of the data detection regular record in above-mentioned rule file check, in excel to be checked
Within the scope of obtaining the coordinate in table and judging whether its value is in default, if the seat target value is not in the range of setting
It is interior, then export key coordinate point data exception information.For example, needing to check that key coordinate is counted according to what is recorded in rule file
According to file, corresponding coordinate and preset data area, find this document into report, open file and then pass through ranks
Information locating takes out the value of the coordinate points and is compared with preset data area, obtain inspection to above-mentioned key coordinate point
As a result.
Step 2022, the formatting of the report is checked according to the rule file, format is abnormal if it exists, then obtains lattice
Formula exception information.
The report table formatted is checked according to the needs of the format check regular record in above-mentioned rule file, from report
The table is obtained in attachment, and checks whether the formatting of the table is correct, for example, may include the ranks for checking report table
The link creation for freezing and/or checking report table, if formatting is incorrect, as needed the ranks of the table freezed not freeze
Knot needs the ranks for the table for creating link not create link, then output format exception information.For example, according in rule file
Format check regular record needs check format report form document, corresponding coordinate and format mode, arrive
This document is found in report, then opening file passes through line information and navigates to above-mentioned coordinate points, calling judges whether format
The function of change checks the coordinate points, obtains inspection result.
Further, as shown in figure 5, the number for checking the report according to the rule file in above-mentioned steps 2021
According to the step for include:
Step 20211, check whether report is empty according to the data inspection rule in the rule file.
The excel form document for needing to check is read according to the data inspection rule in above-mentioned rule file, traverses the table
Every sublist of lattice then takes out the value of each cell and judges whether it is empty, such as monthly income report, successively traverses the report
The cell of each sublist of table simultaneously reads its value, is then judged.
Step 20212, rule verification report key coordinate point data is checked according to the data in the rule file.
The inspection key coordinate point of rule is checked according to data in above-mentioned rule file, reads the excel table for needing to check
Lattice file finds the coordinate of the cell of corresponding table, obtains the seat target value and judges whether within the scope of presetting,
For example, as shown in table 1 below, table 1 is that the key coordinate point for the file that the needs of above-mentioned rule file record check correspondingly arrives
Excel file to be checked finds corresponding coordinate points by " SHEET index " and " coordinate for needing to check ", such as second son
The 3rd row the 26th of table column, then judge whether its value is greater than 0.
| Filename | SHEET index | The coordinate for needing to check |
| Filename to be checked | 2 | 3,26 |
| Filename to be checked | 2 | 4,26 |
| Filename to be checked | 2 | 6,26 |
Table 1
Further, as shown in fig. 6, checking the report tableau format according to the rule file in above-mentioned steps 2022
The step for change includes:
Step 20221, check that the ranks of report table freeze according to the formatization rule in the rule file.
Freeze rule according to the above-mentioned table ranks stated in rule file, the text for needing to format is obtained from above-mentioned report
Part, and corresponding table is found according to " the SHEET index " that freezes in rule, then the list that the table freezes is obtained by " frozen coordinate "
Then first lattice coordinate judges whether the coordinate is frozen.Above table ranks freeze regular as shown in table 2 below.
| Filename | SHEET index | Frozen coordinate |
| Filename to be checked | 1 | Nothing |
| Filename to be checked | 2 | 3,3 |
| Filename to be checked | 3 | 3,4 |
| Filename to be checked | 4 | 3,4 |
| Filename to be checked | 5 | 3,4 |
| Filename to be checked | 6 | 3,4 |
Table 2
Step 20222, check that the link of report table creates according to the formatization rule in the rule file.
Link Rule is created according to the above-mentioned table stated in rule file, is obtained from above-mentioned report and needs to create link
File, and corresponding table is found according to " the SHEET index of link " in creation Link Rule, then obtained by " coordinate of link "
The cell coordinate of table creation link, then judges whether the coordinate has created link.Above table creates Link Rule
As shown in table 3 below.
| Filename | The SHEET index of link | The coordinate of link |
| Filename to be checked | 2 | 5,6 |
| Filename to be checked | 3 | 5,7 |
| Filename to be checked | 4 | 5,9 |
| Filename to be checked | 5 | 5,10 |
| Filename to be checked | 6 | 5,11 |
Table 3
Further, as shown in fig. 7, being carried out based on the warning information to the Email in above-mentioned steps 202
The step for processing may include:
Step 2023, it is carried out at data according to report of the data exception information of the warning information to the Email
Reason is empty and report key coordinate point data not in default range including report.
Wherein, the data exception information of above-mentioned warning information includes the file of the output of above-mentioned steps 2021 for sky and/or reports
The value of the key coordinate point of table table is not in the range of setting.If data exception information is file to be empty, by this document
It deletes, the data of respective file can be further obtained into above-mentioned rule file and write data into above-mentioned empty file
In；If data exception information is the value of the key coordinate point of report table not in the range of setting, to above-mentioned rule text
The value of the key coordinate point of corresponding report table is obtained in part and is written to above-mentioned key coordinate point again.
Step 2024, the report of the Email is formatted according to the format exception information of the warning information
Processing, the link of ranks and creation report table including freezing report table.
Wherein, the format exception information of above-mentioned warning information includes the table that freezes of needs that above-mentioned steps 2022 export
Ranks do not freeze, the ranks for creating the table linked are needed not create link.If format exception information is the table for needing to freeze
The ranks of lattice do not freeze, then adopting form Window-freezing function freezes the ranks cell of corresponding table；If format is believed extremely
Breath is that the ranks for the table for creating link is needed not create link, then calling link creation function is the ranks unit of corresponding table
Lattice creation link.
Further, before above-mentioned steps 203 can with comprising steps of
Step 2031, the address information of the mail server is read according to the configuration parameter of the configuration file.
Wherein, above-mentioned configuration file is the text that above-mentioned steps 2011 are obtained and are stored on local server/terminal device
Part, the relevant configuration parameter of including but not limited to above-mentioned mail server, such as the address of mail server or domain-name information, mailbox
Address information, the relevant information of addressee；Above-mentioned configuration parameter can be stored in above-mentioned local server/terminal device in advance
Database or memory in, to accelerate to read the speed of above-mentioned e-mail server address information.
Further, above-mentioned steps 203 can also include:
Step 2032, according to the address information of the mail server, by treated, Email is sent to mail service
Device.
Wherein, the address of mail server step 2031 got or domain-name information, the address information of mailbox, addressee
The relevant information processing of people is at data, and the parameter as the interface function for sending mail, finally plus by above-mentioned inspection and
Above-mentioned mail server is sent collectively to after treated Email.
It is worth noting that above-mentioned rule file can according to need increase and decrease or change above-mentioned rule, compare flexibly and just
In personalized customization according to demand.
Those of ordinary skill in the art will appreciate that realizing all or part of the process in above-described embodiment method, being can be with
Relevant hardware is instructed to complete by computer program, which can be stored in a computer-readable storage and be situated between
In matter, the program is when being executed, it may include such as the process of the embodiment of above-mentioned each method.Wherein, storage medium above-mentioned can be
The non-volatile memory mediums such as magnetic disk, CD, read-only memory (Read-Only Memory, ROM) or random storage note
Recall body (Random Access Memory, RAM) etc..
It should be understood that although each step in the flow chart of attached drawing is successively shown according to the instruction of arrow,
These steps are not that the inevitable sequence according to arrow instruction successively executes.Unless expressly stating otherwise herein, these steps
Execution there is no stringent sequences to limit, can execute in the other order.Moreover, at least one in the flow chart of attached drawing
Part steps may include that perhaps these sub-steps of multiple stages or stage are not necessarily in synchronization to multiple sub-steps
Completion is executed, but can be executed at different times, execution sequence, which is also not necessarily, successively to be carried out, but can be with other
At least part of the sub-step or stage of step or other steps executes in turn or alternately.
With further reference to Fig. 8, as the realization to method shown in above-mentioned Fig. 2, this application provides a kind of Email numbers
According to one embodiment of processing unit, the Installation practice is corresponding with embodiment of the method shown in Fig. 2, which specifically can be with
Applied in various electronic equipments.
As shown in figure 8, e-mail data processing unit 800 described in the present embodiment includes: to obtain module 801, verification
Module 802 and sending module 803.Wherein:
Module 801 is obtained for obtaining Email Body and attachment to be tested, e-mail attachment include report and
Rule file, the rule file include the data detection rule and format check rule for examining the report；
Correction verification module 802 obtains inspection result, if described for testing according to the rule file to the report
Inspection result includes warning information, and the warning information includes at least one of data exception information, format exception information, then base
The Email is handled in the warning information；
Sending module 803 is for by treated, Email to be sent to mail server.
It is a kind of structural schematic diagram of specific embodiment of correction verification module 802 refering to Fig. 9, correction verification module 802 includes inspection
Test submodule 8021 and processing submodule 8022.Wherein, submodule 8021 is examined to be used for according to the rule file to described
Report is tested, and inspection result is obtained；Handle submodule 8022 be used for based on the warning information to the Email into
Row processing.
In some optional implementations of the present embodiment, above-mentioned apparatus 800 can also include: read module 804, use
In sending module 803 will treated before Email is sent to mail server, according to the configuration of the configuration file
Parameter reads the address information of the mail server.
E-mail data processing unit provided by the embodiments of the present application can be realized in the embodiment of the method for Fig. 2 to Fig. 7
Each embodiment and corresponding beneficial effect, to avoid repeating, which is not described herein again.
In order to solve the above technical problems, the embodiment of the present application also provides computer equipment.Referring specifically to Figure 10, Tu10Wei
The present embodiment computer equipment basic structure block diagram.
The computer equipment 10 includes that connection memory 101, processor 102, network are in communication with each other by system bus
Interface 103.It should be pointed out that the computer equipment 10 with component 101-103 is illustrated only in figure, it should be understood that
It is, it is not required that implement all components shown, the implementation that can be substituted is more or less component.Wherein, this technology is led
Field technique personnel be appreciated that computer equipment here be it is a kind of can according to the instruction for being previously set or storing, automatically into
Line number value calculates and/or the equipment of information processing, and hardware includes but is not limited to microprocessor, specific integrated circuit
(Application Specific Integrated Circuit, ASIC), programmable gate array (Field-
Programmable Gate Array, FPGA), it is digital processing unit (Digital Signal Processor, DSP), embedded
Equipment etc..
The computer equipment can be the calculating such as desktop PC, notebook, palm PC and cloud server and set
It is standby.The computer equipment can carry out people by modes such as keyboard, mouse, remote controler, touch tablet or voice-operated devices with user
Machine interaction.
The memory 101 include at least a type of readable storage medium storing program for executing, the readable storage medium storing program for executing include flash memory,
Hard disk, multimedia card, card-type memory (for example, SD or DX memory etc.), random access storage device (RAM), static random are visited
It asks memory (SRAM), read-only memory (ROM), electrically erasable programmable read-only memory (EEPROM), may be programmed read-only deposit
Reservoir (PROM), magnetic storage, disk, CD etc..In some embodiments, the memory 101 can be the calculating
The internal storage unit of machine equipment 10, such as the hard disk or memory of the computer equipment 10.In further embodiments, described to deposit
Reservoir 101 is also possible to the grafting being equipped on the External memory equipment of the computer equipment 10, such as the computer equipment 10
Formula hard disk, intelligent memory card (Smart Media Card, SMC), secure digital (Secure Digital, SD) card, flash card
(Flash Card) etc..Certainly, the memory 101 can also both including the computer equipment 10 internal storage unit or
Including its External memory equipment.In the present embodiment, the memory 101 is installed on the computer equipment 10 commonly used in storage
Operating system and types of applications software, such as the program code of e-mail data processing method etc..In addition, the memory
101 can be also used for temporarily storing the Various types of data that has exported or will export.
The processor 102 can be in some embodiments central processing unit (Central Processing Unit,
CPU), controller, microcontroller, microprocessor or other data processing chips.The processor 102 is commonly used in described in control
The overall operation of computer equipment 10.In the present embodiment, the processor 102 is used to run to store in the memory 101
Program code or processing data, such as run the program code of the e-mail data processing method.
The network interface 103 may include radio network interface or wired network interface, which is commonly used in
Communication connection is established between the computer equipment 10 and other electronic equipments.
Present invention also provides another embodiments, that is, provide a kind of computer readable storage medium, the computer
Readable storage medium storing program for executing is stored with e-mail data processing routine, and the e-mail data processing routine can be by least one
It manages device to execute, so that at least one described processor is executed such as the step of above-mentioned e-mail data processing method.
Through the above description of the embodiments, those skilled in the art can be understood that above-described embodiment side
Method can be realized by means of software and necessary general hardware platform, naturally it is also possible to by hardware, but in many cases
The former is more preferably embodiment.Based on this understanding, the technical solution of the application substantially in other words does the prior art
The part contributed out can be embodied in the form of software products, which is stored in a storage medium
In (such as ROM/RAM, magnetic disk, CD), including some instructions are used so that a terminal device (can be mobile phone, computer, clothes
Business device, air conditioner or the network equipment etc.) execute method described in each embodiment of the application.
Obviously, embodiments described above is merely a part but not all of the embodiments of the present application, attached
The preferred embodiment of the application is given in figure, but is not intended to limit the scope of the patents of the application.The application can be with many differences
Form realize, on the contrary, purpose of providing these embodiments is keeps the understanding to disclosure of this application more thorough
Comprehensively.Although the application is described in detail with reference to the foregoing embodiments, for coming for those skilled in the art,
Can still modify to technical solution documented by aforementioned each specific embodiment, or to part of technical characteristic into
Row equivalence replacement.All equivalent structures done using present specification and accompanying drawing content, are directly or indirectly used in other
Relevant technical field, similarly within the application scope of patent protection.
Claims (10)
1. a kind of e-mail data processing method, which is characterized in that include the following steps:
Email Body and attachment to be tested are obtained, e-mail attachment includes report and rule file, the rule text
Part includes the data detection rule and format check rule for examining the report；
It is tested according to the rule file to the report, obtains inspection result, if the inspection result includes alarm letter
Breath, the warning information includes at least one of data exception information, format exception information, then based on the warning information to institute
Email is stated to be handled；
By treated, Email is sent to mail server.
2. e-mail data processing method according to claim 1, which is characterized in that described to obtain electronics to be tested
The step of message body and attachment, specifically includes:
Configuration file is obtained, the configuration file includes configuration parameter；
The Email Body and attachment to be tested are obtained according to the configuration parameter of the configuration file.
3. e-mail data processing method according to claim 1, which is characterized in that described according to the rule file
The step of testing to the report, obtain inspection result specifically includes:
The data of the report are checked according to the rule file, if it exists data exception, then obtain data exception information；With/
Or
The formatting of the report is checked according to the rule file, format is abnormal if it exists, then obtains format exception information.
4. e-mail data processing method according to claim 3, which is characterized in that described according to the rule file
The step of checking the data of the report is specific further include:
Check whether report is empty according to the data inspection rule in the rule file；And/or
Rule verification report key coordinate point data is checked according to the data in the rule file.
5. e-mail data processing method according to claim 3, which is characterized in that described according to the rule file
The step of checking the formatting of the report is specific further include:
Check that the ranks of report table freeze according to the formatization rule in the rule file；And/or
The link creation of report table is checked according to the formatization rule in the rule file.
6. e-mail data processing method according to claim 3, which is characterized in that described to be based on the warning information
The step of handling the Email specifically includes:
Data processing is carried out according to report of the data exception information of the warning information to the Email, including report is
Empty and report key coordinate point data is not in default range；
Processing is formatted to the report of the Email according to the format exception information of the warning information, including is freezed
The link of the ranks and creation report table of report table.
7. e-mail data processing method according to claim 1, which is characterized in that it is described will treated electronics postal
Part was sent to before the step of mail server further include:
The address information of the mail server is read according to the configuration parameter of the configuration file；
It is described will treated the step of Email is sent to mail server further include:
According to the address information of the mail server, by treated, Email is sent to mail service.
8. a kind of e-mail data processing unit characterized by comprising
Module is obtained, for obtaining Email Body and attachment to be tested, e-mail attachment includes report and rule text
Part, the rule file include the data detection rule and format check rule for examining the report；
Correction verification module obtains inspection result, if the inspection is tied for testing according to the rule file to the report
Fruit includes warning information, and the warning information includes at least one of data exception information, format exception information, then based on described
Warning information handles the Email；
Sending module, for Email to be sent to mail server by treated.
9. a kind of computer equipment, which is characterized in that including memory and processor, computer journey is stored in the memory
Sequence, the processor realize the e-mail data as described in any one of claims 1 to 7 when executing the computer program
The step of processing method.
10. a kind of computer readable storage medium, which is characterized in that be stored with computer on the computer readable storage medium
Program realizes the e-mail data as described in any one of claims 1 to 7 when the computer program is executed by processor
The step of processing method.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910371058.XA CN110278143B (en) | 2019-05-06 | 2019-05-06 | E-mail data processing method and device, computer equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910371058.XA CN110278143B (en) | 2019-05-06 | 2019-05-06 | E-mail data processing method and device, computer equipment and storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110278143A true CN110278143A (en) | 2019-09-24 |
| CN110278143B CN110278143B (en) | 2022-08-19 |
Family
ID=67959655
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910371058.XA Active CN110278143B (en) | 2019-05-06 | 2019-05-06 | E-mail data processing method and device, computer equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110278143B (en) |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110855499A (en) * | 2019-11-19 | 2020-02-28 | 上海易点时空网络有限公司 | Exception handling method and device |
| CN111400435A (en) * | 2020-02-19 | 2020-07-10 | 中国平安人寿保险股份有限公司 | Mail alarm convergence method, device, computer equipment and storage medium |
| CN112597747A (en) * | 2021-01-05 | 2021-04-02 | 网易（杭州）网络有限公司 | Data table checking method and device, electronic equipment and storage medium |
| CN113269528A (en) * | 2021-05-28 | 2021-08-17 | 青岛海信移动通信技术股份有限公司 | Information processing method and device |
| CN113504957A (en) * | 2021-07-27 | 2021-10-15 | 平安普惠企业管理有限公司 | Table data processing method and device, computer equipment and storage medium |
| CN113794674A (en) * | 2021-03-09 | 2021-12-14 | 北京沃东天骏信息技术有限公司 | Method, device and system for detecting mail |
| CN116055350A (en) * | 2023-01-03 | 2023-05-02 | 重庆长安汽车股份有限公司 | Json-based data communication quality detection method |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| KR20070004270A (en) * | 2005-07-04 | 2007-01-09 | 주식회사 안철수연구소 | Method and apparatus for detecting virus in attached file of e-mail |
| CN102821063A (en) * | 2012-08-03 | 2012-12-12 | 中国联合网络通信集团有限公司 | Method, device and system for sending and re-sending E-mails |
| US20160142350A1 (en) * | 2014-11-18 | 2016-05-19 | Commvault Systems, Inc. | Storage and management of mail attachments |
| CN105791103A (en) * | 2016-05-11 | 2016-07-20 | 柳州迅屹办公设备有限公司 | E-mail system with function of sending verification |
| CN109002424A (en) * | 2018-06-14 | 2018-12-14 | 平安科技（深圳）有限公司 | File layout change-over method, device, computer equipment and storage medium |
| CN109634945A (en) * | 2018-12-06 | 2019-04-16 | 阳光保险集团股份有限公司 | The method and apparatus of Data Detection in a kind of reporting system |
-
2019
- 2019-05-06 CN CN201910371058.XA patent/CN110278143B/en active Active
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| KR20070004270A (en) * | 2005-07-04 | 2007-01-09 | 주식회사 안철수연구소 | Method and apparatus for detecting virus in attached file of e-mail |
| CN102821063A (en) * | 2012-08-03 | 2012-12-12 | 中国联合网络通信集团有限公司 | Method, device and system for sending and re-sending E-mails |
| US20160142350A1 (en) * | 2014-11-18 | 2016-05-19 | Commvault Systems, Inc. | Storage and management of mail attachments |
| CN105791103A (en) * | 2016-05-11 | 2016-07-20 | 柳州迅屹办公设备有限公司 | E-mail system with function of sending verification |
| CN109002424A (en) * | 2018-06-14 | 2018-12-14 | 平安科技（深圳）有限公司 | File layout change-over method, device, computer equipment and storage medium |
| CN109634945A (en) * | 2018-12-06 | 2019-04-16 | 阳光保险集团股份有限公司 | The method and apparatus of Data Detection in a kind of reporting system |
Cited By (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110855499A (en) * | 2019-11-19 | 2020-02-28 | 上海易点时空网络有限公司 | Exception handling method and device |
| CN111400435A (en) * | 2020-02-19 | 2020-07-10 | 中国平安人寿保险股份有限公司 | Mail alarm convergence method, device, computer equipment and storage medium |
| CN111400435B (en) * | 2020-02-19 | 2024-04-12 | 中国平安人寿保险股份有限公司 | Mail alarm convergence method, device, computer equipment and storage medium |
| CN112597747A (en) * | 2021-01-05 | 2021-04-02 | 网易（杭州）网络有限公司 | Data table checking method and device, electronic equipment and storage medium |
| CN113794674A (en) * | 2021-03-09 | 2021-12-14 | 北京沃东天骏信息技术有限公司 | Method, device and system for detecting mail |
| CN113794674B (en) * | 2021-03-09 | 2024-04-09 | 北京沃东天骏信息技术有限公司 | Method, device and system for detecting mail |
| CN113269528A (en) * | 2021-05-28 | 2021-08-17 | 青岛海信移动通信技术股份有限公司 | Information processing method and device |
| CN113269528B (en) * | 2021-05-28 | 2023-04-07 | 青岛海信移动通信技术股份有限公司 | Information processing method and device |
| CN113504957A (en) * | 2021-07-27 | 2021-10-15 | 平安普惠企业管理有限公司 | Table data processing method and device, computer equipment and storage medium |
| CN116055350A (en) * | 2023-01-03 | 2023-05-02 | 重庆长安汽车股份有限公司 | Json-based data communication quality detection method |
| CN116055350B (en) * | 2023-01-03 | 2024-05-14 | 重庆长安汽车股份有限公司 | Json-based data communication quality detection method |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110278143B (en) | 2022-08-19 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110278143A (en) | E-mail data processing method, device, computer equipment and storage medium | |
| CN108052675A (en) | Blog management method, system and computer readable storage medium | |
| CN104899016B (en) | Allocating stack Relation acquisition method and device | |
| US20120233227A1 (en) | File attachment retrieval | |
| CN104268248B (en) | Recommendation method and device for application program and terminal | |
| CN109039870A (en) | E-mail sending method, system, computer equipment and storage medium | |
| CN104468833B (en) | The method and apparatus that solicited message is uniformly processed | |
| CN109685454A (en) | Data checking method, device, equipment and storage medium | |
| CN109993524A (en) | Card certificate management method, device, equipment and computer readable storage medium | |
| CN109684180A (en) | Method and apparatus for output information | |
| CN107908480A (en) | Wages computational methods, application server and computer-readable recording medium | |
| CN103049367A (en) | Automatic testing method for software | |
| CN110503545A (en) | Loan is independently into part method, terminal device, storage medium and device | |
| CN113489788B (en) | Data route control and data analysis processing method and device, equipment and medium | |
| CN108564462A (en) | Acquisition methods, terminal device and the medium of collage-credit data | |
| CN108170600A (en) | The coverage rate statistical method of front-end code test, apparatus and system | |
| CN109918471A (en) | Archive method, apparatus, computer equipment and storage medium | |
| CN108933695A (en) | Method and apparatus for handling information | |
| CN108021621A (en) | Database data acquisition method, application server and computer-readable recording medium | |
| CN107958359A (en) | Shelf choosing method and device | |
| CN113032252A (en) | Method and device for collecting buried point data, client device and storage medium | |
| CN109242410A (en) | A kind of generation method and device of backlog | |
| CN115237724A (en) | Data monitoring method, device, equipment and storage medium based on artificial intelligence | |
| CN106294345A (en) | The treating method and apparatus of the log content of application program | |
| CN113051094B (en) | Supervision data reporting test method and device |
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 |