A kind of method and system of batch distribution formats file
Technical field
The invention belongs to field of computer technology, a kind of method more particularly, to batch distribution formats file and it is
System.
Background technology
Compared to conventional mail, Email and other communication tools have quick writing, energy-conserving and environment-protective, it is with low cost,
The advantages of communicating timely, therefore as the primary communications mode in the present age, some are even as relatively formal exchange way.Therefore
User is when needing to be communicated with multiple objects, and operation intellectuality is just particularly important.
At present, user is required for adding each contact again every time when needing to send communication information to multiple contact persons
The address of people, when needing to send different communication informations to multiple contact persons, it is necessary to which user inputs different lead to one by one
Information is interrogated, even send form identical Template Information and annex, it is also desirable to which user replicates template and fills in mould successively
Plate, then annex is added successively, so when needing to send a large amount of communication informations, it is necessary to which user carries out the complicated behaviour repeated always
Make, can not only reduce the operating efficiency of user, and error rate is also higher.
Current communication information, which is sent, has following technical problem:(1) need to send communication letter to multiple contact persons when each
During breath, it is required for adding the address of contact person again;(2) when needing to send multiple template information and attached to multiple contact persons
, it is necessary to replicate template and fill in template during part.
Patent CN106375196S discloses the sending method and device of a kind of bulk mail.The transmission of the bulk mail
Method includes:When judging to include multiple addressee informations in request for sending E-mail, extract every from the request for sending E-mail
Individual addressee information, and the addressee information is encoded, generate mail head's content;According in the request for sending E-mail
Email template identification code read the email template corresponding with the email template identification code that prestores;By the mail
Head content is spliced with the email template, generates mail to be sent;Send described to be sent according to mail head's content
Mail.The invention improves the efficiency to multiple addressee's transmission content identical mails;However, needing to send mail a lot
In the case of (for example need to client's mail sending charge per message list, or send invitation card, greeting card, school report etc.), it is necessary to add for mail simultaneously
Plus an annex, and also need to send different Mail Contents in many cases, the above method can not solve similar situation.
The content of the invention
For the disadvantages described above or Improvement requirement of prior art, the invention provides a kind of side of batch distribution formats file
Method and system, the information different its object is to realize Batch sending, the complex operation for thus solving communication information transmission are cumbersome
Problem.
To achieve the above object, according to one aspect of the present invention there is provided a kind of method of batch distribution formats file,
Format information and formatted file are sent to distribution object according to formatted file;Including:
Keyword is obtained according to formatted file;
Distribution object and format information are obtained according to the keyword and the database corresponding with keyword;
Information to be sent is obtained according to the formatted file and the format information, and is sent to the distribution object.
Preferably, the formatted file include the first formatted file, the second formatted file ..., N formatted files, on
The method for stating batch distribution formats file, specifically includes following steps:
S1, i=1;
S2, according to the i-th formatted file obtain keyword;
S3, distribution object and format information obtained according to the keyword and the database corresponding with keyword;Its
In, the format information includes Template Information;
S4, information to be sent is obtained according to i-th formatted file and the format information, and be sent to the distribution pair
As;
S5, judge i whether be equal to N;It is to count Distribution Results, batch distribution terminates;Otherwise i=i+1, return to step
S2;Wherein, N is the quantity of formatted file, and N is more than or equal to 2.
As it is further preferred that the format information also includes formwork accessory.
As it is further preferred that also including before the step S1:
Preset formatted file and database.
As it is further preferred that also including before the step S2:
Whether keyword is included according to file, judges whether the file currently retrieved is formatted file;It is to obtain the i-th lattice
Formula file simultaneously enters step S2;Otherwise next file is retrieved.
As it is further preferred that the keyword includes the first keyword and the second keyword;The database includes
First database and the second database.
As it is further preferred that the step S3 includes:
S31, the distribution obtained according to first keyword and first database corresponding with the first keyword
Object;
S32, the template obtained according to second keyword and second database corresponding with the second keyword
Information;
S33, the format information obtained according to the Template Information.
As it is further preferred that the keyword also includes the 3rd keyword;The database also includes the 3rd number
According to storehouse.
As it is further preferred that the step S3 also includes:
The formwork accessory is obtained according to the 3rd keyword and threeth database corresponding with the 3rd keyword,
And the format information is obtained according to Template Information and formwork accessory.
As it is further preferred that the database also includes invalid distribution object database.
Also include between the step S31 and the step S32:It whether there is according to the distribution object in the nothing
Imitate in distribution object database, judging the formatted file, whether the match is successful;If the distribution object is present in described invalid
In distribution object database, then it fails to match for the formatted file, and marking i-th formatted file, it fails to match, and to outside
The second cue is sent, into step S5;Otherwise the match is successful, and it is that the match is successful to mark i-th formatted file, and outwards
Portion sends the first cue, into step S32.
As it is further preferred that between the step S4 and S5, in addition to:From the outside hair for obtaining information to be sent
Result is sent, and according to outside transmission result, judges whether the distribution object is properly received format information, is that then mark is described
I-th formatted file is distributed successfully, otherwise marks the i-th formatted file distribution failure.
As it is further preferred that the step S5 also includes, when i is equal to N, the letter of distribution end is sent to outside
Number;Distribution Results in the step S5 include distributing successful formatted file, distribute failure formatted file and
The formatted file that it fails to match.
As it is further preferred that also including before the step S3:
Judge whether the database includes the keyword corresponding with formatted file;It is then to enter step S3;Otherwise
Send to rejudge prompting or retrieve next file to outside and point out.
According to another aspect of the present invention, a kind of system of batch distribution formats file is additionally provided, including:Data
Storehouse, keyword-extraction module, information collector, information sending module;
The keyword-extraction module is used to obtain keyword according to formatted file;
Described information collector is used to be distributed according to the keyword and the database corresponding with keyword
Object and format information;
Described information sending module is used to obtain information to be sent according to the formatted file and the format information, concurrently
Give the distribution object.
Preferably, the keyword includes the first keyword and the second keyword, and the database includes the first data
And second database, described information collector includes:
First information collector, for according to the first keyword and first database corresponding with the first keyword
Obtain distribution object;
Second information collector, for according to the second keyword and second database corresponding with the second keyword
Obtain Template Information;
First format information generation module, for obtaining the format information according to Template Information.
As it is further preferred that the keyword also includes the 3rd keyword, the database also includes the 3rd data
Storehouse, described information collector also includes:
3rd information collector, for according to the 3rd keyword and threeth database corresponding with the 3rd keyword
Obtain formwork accessory;
Second format information generation module, for obtaining the format information according to Template Information and formwork accessory.
Preferably, the formatted file include the first formatted file, the second formatted file ..., N formatted files, N is
The quantity of formatted file, N is more than or equal to 2;
The keyword-extraction module is used to obtain the corresponding keyword of the i-th formatted file according to the i-th formatted file, and i is 1
~N integer;
The system also includes:
Formatted file quantity judge module, terminates for whether judging i equal to N, and sending distribution to outside in i=N
Signal;
Distribution object judge module, for whether there is according to the distribution object in the invalid distribution object database
In, judging the formatted file, whether the match is successful, is to send the first cue corresponding with current format file, otherwise
Send the second cue corresponding with current format file;
Information Statistics module, for the signal terminated according to distribution, the first cue and the second cue, statistics
The transmission result of format information.
As it is further preferred that the system also includes:
Formatted file identification module, for according to keyword whether is included in file, whether the file that judgement is currently retrieved
It is formatted file;
Keyword recognition module, for judging whether the database includes the keyword corresponding with formatted file,
And prompting is sent to outside according to judged result.
In general, by the contemplated above technical scheme of the present invention compared with prior art, due to according to form text
Keyword in part can obtain following beneficial effect to the different information to be sent of distribution object Batch sending:
(1) present invention obtains keyword according to formatted file, and distribution object and format information are obtained according to keyword, realizes
Distribution object and information to be sent automatically generating and sending automatically;
(2) formatted file transmitted by the present invention is multiple, can obtain different forms for multiple formatted files successively
Information and distribution object, realize the Batch sending of formatted file and format information;
(3) present invention can obtain distribution object and format information according to keyword and the database corresponding with keyword,
The format information also includes formwork accessory, it is achieved that can carry the effect of multiple annexes during Batch sending information;
(4) present invention can count transmission result, such as count and distribute successful formatted file, the form text of distribution failure
Part and the formatted file that it fails to match, to facilitate access;
(5) present invention to outside can send cue according to judged result, realize the effect of selection and prompting.
Brief description of the drawings
Fig. 1 is the structural representation of the specific embodiment of the invention;
Fig. 2 is the information collector structural representation in the specific embodiment of the invention;
Fig. 3 is the method and step flow chart of the specific embodiment of the invention;
Fig. 4 is the method and step flow chart of embodiment 1;
Fig. 5 is the first time notification of examiner's opinion template of embodiment 1;
Fig. 6 is the authorization notification book template of embodiment 1;
Fig. 7 is the format information for the first time notification of examiner's opinion to be sent that embodiment 1 is generated;
Fig. 8 is the format information for the authorization notification book to be sent that embodiment 1 is generated;
Fig. 9 is the achievement notice template of embodiment 2;
Figure 10 is the school timetable notice template of embodiment 2;
Figure 11 is the format information for the achievement notice to be sent that embodiment 2 is generated;
Figure 12 is the format information that embodiment 2 generates school timetable notice to be sent.
Embodiment
In order to make the purpose , technical scheme and advantage of the present invention be clearer, it is right below in conjunction with drawings and Examples
The present invention is further elaborated.It should be appreciated that the specific embodiments described herein are merely illustrative of the present invention, and
It is not used in the restriction present invention.As long as in addition, technical characteristic involved in each embodiment of invention described below
Not constituting conflict each other can just be mutually combined.
The invention discloses a kind of method and system of batch distribution formats file, wherein, the formatted file is referred to
Include the file of one or more keywords;When formatted file is multiple, it includes the first formatted file, the second form text
Part ..., N formatted files.
Sent as shown in figure 1, the system includes database, keyword-extraction module, information collector and information
Module etc.;The database can be one or more, for example, can include the first database and the second database, can also wrap
Include the first database, the second database and the 3rd database;Methods described includes:
Keyword-extraction module obtains keyword according to formatted file, can be according to the filename or content of formatted file
Keyword is extracted, the keyword can be one or more, for example, can include the first keyword and the second keyword, also may be used
With including the first keyword, the second keyword and the 3rd keyword etc., and quantity of the database then with keyword is corresponding;
Information collector according to the keyword and the database corresponding with keyword obtain distribution object and
Format information, the format information includes Template Information, formwork accessory is will also include sometimes, the formwork accessory is also according to institute
State keyword and the database corresponding with keyword is obtained;
Information sending module sends information to be sent to the distribution object, the information to be sent include format information with
And formatted file.
One includes three with the system results schematic diagram of the database corresponding to keyword as shown in Fig. 2 said system
In described information collector include first information collector, the second information collector, the 3rd information collector, the
One format information generation module, the second format information generation module;Methods described includes:
Keyword-extraction module is extracted after the first keyword, first information collector according to the first keyword and with
The first corresponding database of first keyword obtains distribution object, and the distribution object includes the address of distribution object;
Keyword-extraction module is extracted after the second keyword, the second information collector according to the second keyword and with
Corresponding the second database of second keyword obtains Template Information, the Template Information be the information of information to be sent just
Text;
If in the presence of the 3rd keyword and threeth database corresponding with the 3rd keyword, in keyword-extraction module
Extract after the 3rd keyword, the 3rd information collector is according to the 3rd keyword and the corresponding with the 3rd keyword the 3rd
Database obtains formwork accessory, and the formwork accessory and formatted file are as the annex of information to be sent;If in the absence of the 3rd
Keyword and threeth database corresponding with the 3rd keyword, then only using formatted file as information to be sent annex;
Obtain after Template Information, if in the absence of formwork accessory, the first format information generation module is obtained according to Template Information
Obtain the format information or corresponding format information is generated according to the first keyword and its corresponding database;
If there is formwork accessory, the second format information generation module obtains the lattice according to Template Information and formwork accessory
Formula information.
Judge as shown in figure 1, said system also includes formatted file identification module, keyword recognition module, distribution object
Module, formatted file quantity judge module, Information Statistics module;Methods described includes:
Before keyword is obtained according to formatted file, the system first has to retrieval file, often retrieves a file, form
Whether file identification module just includes keyword according to this document, judges whether the file currently retrieved is formatted file;
If the file currently retrieved is formatted file, keyword recognition module judges whether the database includes form
Keyword in file, and prompting is sent to outside according to judged result;
Wherein, the database also includes invalid distribution object database;Closed according to the first keyword and with first
After the step for corresponding database of key word obtains distribution object, distribution object judge module is according to the distribution object
No to be present in the invalid distribution object database, judging the formatted file, whether the match is successful;If the distribution object
It is present in the invalid distribution object database, then it fails to match for the formatted file, and otherwise the formatted file is matched into
Work(;And according to judged result, cue is sent to outside, it is to send the first prompting letter corresponding with current format file
Breath, otherwise sends the second cue corresponding with current format file;
After the completion of the distribution of each formatted file, formatted file quantity judge module judges whether to retrieve N forms
File, is to send the signal that distribution terminates to outside, otherwise continues to retrieve next file;
After formatted file quantity judge module sends the signal that distribution terminates, Information Statistics module terminates according to distribution
Signal, the first cue and the second cue, count the transmission result of format information, i.e. the successful lattice of statistics distribution
Formula file, distributes the formatted file failed and the formatted file that it fails to match.
Keyword in the formatted file can be one or more, and corresponding database is also to be one or more;When
Keyword and database for it is multiple when, one or more of multiple databases keyword and its corresponding database can be chosen
Distribution object is obtained, one or more of multiple databases keyword can be also chosen and its corresponding database obtains form letter
Breath.
Using keyword as two, distribution object is one, and Template Information is two, and in the absence of exemplified by formwork accessory;Then
Distribution object can be obtained according to the first keyword and the first database, while obtaining the according to the first keyword and the first database
One Template Information, the second Template Information is obtained according to the second keyword and the second database;By the first Template Information and the second mould
The format information of plate information composition is as text, and formatted file is sent to distribution object as annex.
As shown in figure 3, said system distributes N number of formatted file, (N is the integer more than or equal to 2, and formatted file is respectively the
One formatted file is to N formatted files) comprise the following steps that:
S1.i=1;
S2. keyword is obtained from the i-th formatted file;
S3. judge whether the keyword is corresponding with database, be then to enter next step;Otherwise judge whether i is equal to N,
It is to count Distribution Results, batch distribution terminates, otherwise sends prompt message to outside, i=i+1 returns to previous step;For example,
When the keyword of corresponding formatted file can not be obtained in database, then it can judge that the keyword is not right with database
Should;
S4. distribution object and Template Information are obtained according to the keyword and the database corresponding with keyword;
S5. the Template Information and formatted file are sent to the distribution object, the formatted file is used as the mould
The annex of plate information;
S6. judge whether i is equal to N, be to count Distribution Results, batch distribution terminates;Otherwise i=i+1, return to step
S2。
Embodiment 1
The present embodiment is used to realize that the mail of patent electric official text is sent.
The system of the present embodiment includes patent information database, customer information database, agent's database, Template Information
Database, mailing system, display device.
The formatted file of the present embodiment is the annex with certain naming rule.For example, the electronics official text that Patent Office issues
In there is certain keyword, including application number, the literary type of electronics official, code, dispatch date etc..The system can directly from
The type of application number and electronics official text is extracted in electronics official text, electronics official's text can also be converted into after pdf forms again with certain
Rule name.For example naming rule can be:Literary type+the extension name of application number+official, for example, formatted file is named as:
2017123456780 first time notification of examiner's opinion .pdf, 2018115678900 authorization notification book .pdf.
The patent information database is used to store patent information, as shown in table 1, including internal number, the applying date, application
Number, patent name, patent type, applicant, inventor, agent;
The patent information database of table 1
The customer information database is used to store customer information, as shown in table 2, including applicant, name of contact person, connection
It is people's email address, contact phone, contact addresses;
The customer information database of table 2
Agent's database is used for storage agent people's information, as shown in table 3, including agent's name, agent's postal
Case address, agent's phone, agent office;
The agent's database of table 3
Agent's name |
Agent's email address |
Agent's phone |
Agent office |
|
|
|
|
The Template Information database is used to store Template Information, including first time notification of examiner's opinion template .txt,
Authorization notification book template .txt etc.;
The mailing system is used to complete mail transmission;
The display device is used for display reminding information and sends result.
The first time notification of examiner's opinion template .txt is as shown in Figure 5:
The authorization notification book template .txt is as shown in Figure 6:
As shown in figure 4, the method for the present embodiment comprises the following steps:
(1) preset formatted file and database.
Formatted file is stored according to certain rule, such as the formatted file in electronics official text is extracted, pdf lattice are converted to
2017123456780 first time notification of examiner's opinion .pdf, 2018115678900 authorization notification book .pdf are named as after formula;
The 2017123456780 first time notification of examiner's opinion .pdf is awarded as the first formatted file, described 2018115678900
Power notice .pdf is used as the second formatted file;First formatted file and the second formatted file all include 13 application numbers,
Official's text type and extension name;13 application numbers are as the first keyword, and the literary type of the official is used as the second keyword.
Create and preserve patent information database, customer information database, agent's database, Template Information database;
Patent information database includes:Internal number, the applying date, application number, patent name, patent type, applicant, inventor, generation
Manage people;Customer information database includes applicant, name of contact person, contact person email address, contact phone, contact person
Location;Agent's database includes agent's name, agent's email address, agent's phone, agent office;Template is believed
Ceasing database includes first time notification of examiner's opinion template .txt, authorization notification book template .txt.Wherein, disparate databases it
Between with external key it is interrelated:It can be seen that from table 1- tables 3, patent information database and customer information database are using applicant as outer
Key, patent information database and agent's database regard agent's name as external key;The patent information database, Ke Huxin
Breath database, agent's database are used as the first database;The Template Information database is used as the second database;The patent
Application number in information database is as the keyword of the first database, the template name conduct in the Template Information database
The keyword of second database.Because patent agency or big companies typically all can preserve patent in forms such as access forms
Application information, such database can be obtained using the ready-made form created.
(2) recognize formatted file and obtain keyword.
Formatted file is identified according to file extension pdf, further according to the keyword of formatted file name acquiring first and
Two keywords, such as the first formatted file 2017123456780 first time notification of examiner's opinion .pdf, the first keyword is
2017123456780, the second keyword is first time notification of examiner's opinion;For the second formatted file 2018115678900
Authorization notification book .pdf, the first keyword is 2018115678900, and the second keyword is authorization notification book.
(3) database retrieval.
Distribution object and format information are obtained according to keyword and database.
According to the first keyword (such as 2017123456780 or 2018115678900) patent searching information database, obtain
(as shown in table 4, Application No. 2017123456780, patent name are cup, application to the corresponding patent information of first keyword
Artificial XX companies, act on behalf of artificial Li Si or Application No. 2018115678900, patent name be tea table, apply for artificial YY companies,
Act on behalf of artificial Zhao five), applicant's field (such as XX companies or YY companies) in patent information database judges the applicant
Whether format information can be received, prompt message is otherwise sent on the display device, and continue to retrieve next file, be then basis
Applicant's field (such as XX companies or YY companies) retrieves the applicant in customer information database, and (such as XX companies or YY are public
Department) corresponding name of contact person, contact person's email address (as shown in table 5, name of contact person is Zhang, contact person's email address
It is Mr. Wang for 789456@qq.com or name of contact person, contact person's email address is 456123@qq.com) because examining for the first time
Action is looked into while needing to make a copy for agent, and authorization notification book need not make a copy for agent, therefore meaning is examined for the first time
See that notice needs agent's field (such as Li Si) in patent information database to retrieve the generation in agent's database
Manage the corresponding email address of people, phone, (as shown in table 6, agent's email address is 123456@qq.com, agency for office
People's phone is that 12345678900, agent office is XX squares XX rooms).
The patent information that table 4 is obtained according to the first keyword
Application number |
Patent name |
Applicant |
Agent |
2017123456780 |
Cup |
XX companies |
Li Si |
2018115678900 |
Tea table |
YY companies |
Zhao five |
Template Information database is retrieved according to the second keyword (such as first time notification of examiner's opinion or authorization notification book),
Obtaining the corresponding Template Information of the second keyword, (such as first time notification of examiner's opinion template .txt, Template Information is as shown in Figure 5
Or authorization notification book template .txt, Template Information is as shown in Figure 6).
The associated person information that table 5 is obtained according to applicant
Applicant |
Name of contact person |
Contact person's email address |
XX companies |
Zhang |
789456@qq.com |
YY companies |
Mr. Wang |
456123@qq.com |
Agent's information that table 6 is obtained according to agent
Agent's name |
Agent's email address |
Agent's phone |
Agent office |
Li Si |
123456@qq.com |
12345678900 |
XX squares XX rooms |
Now, if it fails to match, such as the first keyword is not recorded in patent information database, or lacks contact person's postal
Case address etc., then marking the formatted file, it fails to match, reenters the retrieval of next formatted file.
(4) information is compiled.
Because first time notification of examiner's opinion must be completed with corresponding agent, so according to the second keyword
May determine that the distribution object of " 20171234567890 first time notification of examiner's opinion " not only includes corresponding contact person,
Also agent is included.And authorization notification book does not need agent to coordinate, therefore " 2018115678900 authorization notification book " can be selected only
Take the corresponding contact person of applicant.
Simultaneously as authorization notification book would generally be while arrive, while can also generate one with the notice that checks in
The individual expense for handling registration;Retrieval and the first keyword identical of authorization notification book check in notice (i.e.
2018115678900 check in notice), while according to the payment information checked on notice, generation
One application number identical with authorization notification book handles registration fee list, i.e., (2018115678900 handle registration fee list), handle and step on
Fei Danshang is remembered except the public expense information on notice that checks in, it is also corresponding with the first keyword to act on behalf of charge information;
Now, if it fails to match, such as retrieval checks in notice less than the first keyword identical with authorization notification book, then
Marking the formatted file, it fails to match, reenters the retrieval of next formatted file.If the match is successful, form text is marked
The match is successful for part, into next step;
Obtained information (such as application number, patent name), customer information database will be retrieved from patent information database
It is middle retrieve obtained information (such as name of contact person), retrieve in agent's database obtain information (such as agent's email address,
Agent's phone, agent office) variable field of corresponding Template Information is filled up to, obtain message text (first
Secondary notification of examiner's opinion format information text is as shown in fig. 7, authorization notification book format message text is as shown in Figure 8), and will be right
The first formatted file answered obtains information to be sent as Info attachment.
(5) mail is sent.
The corresponding contact person's email address obtained according to being retrieved from customer information database sends the lattice to be sent
Formula information, and obtain the transmission result (sending successfully or send failure) of server return.As " 2017123456780 for the first time
The sending object of notification of examiner's opinion " is the corresponding contact person of applicant and agent, format information text such as Fig. 7 institutes
Show, annex is " 2017123456780 first time notification of examiner's opinion .pdf ";And " 2018115678900 authorization notification book "
Sending object be the corresponding contact person of applicant, format information text as shown in figure 8, annex for " 2018115678900 authorize
Notice .pdf ", " 2018115678900 check in notice .pdf " and " 2018115678900 handle registration fee
It is single ".
(6) judge whether it is last file.
If all formats file has all been sent, i.e., current format file is last formatted file, then counts
Result is sent, the transmission result includes the mail that the match is successful, the mail that it fails to match, and the mail that the match is successful includes hair again
Send successful mail, send the mail of failure, so that flow personnel searching sends failure or (contact person side the reason for it fails to match
Formula mistake, or the keyword in database be not present etc.);Otherwise next formatted file, return to step (2) are recognized.
Embodiment 2
The present embodiment is used to realize the transmission in school's notice, is learned for example, school may need to send to parents of student
Give birth to the school timetable of this halves and this term study situation that school transcript allows parent to understand student is sent in term Mo, also may be used
Timing can be needed to hold a parent-teacher meeting.
The system of the present embodiment includes student's communication data storehouse, student achievement data storehouse, lesson data storehouse, teacher's information's number
According to storehouse, Template Information database, wechat.
The formatted file of the present embodiment is to notify a record in written matter and student's communication data storehouse, wherein, institute
State the j-th strip in student's communication data storehouse and be recorded as jth formatted file, j is 2~M integer, and M is in student's communication data storehouse
Record strip number.For example, being required in each term of each academic year sending out public notice book to the parent of each student, and have
Different notice, for example, the student performance notice to family's long hair can be named as 2015 second term academic year achievements notice
Book .pdf, school timetable notice can be named as 2015 second term academic year school timetable notice .pdf.
Student's communication data storehouse is used to store student's communication information, as shown in table 7, including student's student number, student's surname
Name, student class, parent's name, parent's telephone number, parent's WeChat ID, parent's email address, student's family address;
The student's communication data storehouse of table 7
The student achievement data storehouse is used to store student performance, as shown in table 8, including student's student number, term academic year, examines
Try date, course code, course achievement;
The student achievement data storehouse of table 8
Student's student number |
Term academic year |
Take an examination the date |
Course code |
Course achievement |
|
|
|
|
|
The lesson data storehouse is used to store curriculum information, as shown in table 9, including course code, course name, religion of giving lessons
Teacher's code, teacher's name;
Teacher's information's database be used for store teacher's information, as shown in table 10, including teacher's code, teacher's name,
Scholastic post, teacher's telephone number, teacher's WeChat ID, teacher's email address, Staff Room;
The lesson data storehouse of table 9
Course code |
Course name |
Teacher's code |
Teacher's name |
|
|
|
|
The teacher's information's database of table 10
The Template Information database includes achievement notice template .txt, school timetable notice template .txt;
The achievement notice template .txt is as shown in Figure 9;
The school timetable notice template .txt is as shown in Figure 10;
The wechat is used to send communication information.
The method of the present embodiment comprises the following steps:
(1) preset formatted file and database.
It regard student's student number of i-th record in student's communication data storehouse as the first keyword;And by notice according to
Notice, for example, can be named as 2015 second term academic year achievement notice .pdf, 2015 academic years by certain rule storage
Second term school timetable notice .pdf;The notice includes term 10 academic year and notifies title;The notice name conduct
Second keyword, term 10 academic year is used as the 3rd keyword.
Create and preserve student's communication data storehouse, student achievement data storehouse, lesson data storehouse, teacher's information's database, mould
Plate information database;Student's communication data storehouse includes student's student number, student name, student class, parent's name, parent's contact electricity
Words, parent's WeChat ID, parent's email address, student's family address;Student achievement data storehouse include student's student number, term academic year,
Examination date, course code, course achievement;Lesson data storehouse includes course code, course name, teacher's code, given lessons
Teacher's name;Teacher's information's database includes teacher's code, teacher's name, scholastic post, teacher's telephone number, teacher's wechat
Number, teacher's email address, Staff Room;Template Information database includes achievement notice template .txt, school timetable notice mould
Plate .txt.Wherein, it is interrelated with external key between disparate databases;Student's communication data storehouse and student achievement data storehouse are by student
Student number regard course code as external key, lesson data storehouse and teacher's information as external key, student achievement data and lesson data storehouse
Database regard teacher's code as external key;Student's communication data storehouse is used as the first database;The Template Information database
It is used as the second database;Student's communication data storehouse, student achievement data storehouse, lesson data storehouse, teacher's information's database are made
For the 3rd database;Student's student number in student's communication data storehouse is used as its keyword;In the Template Information database
Template name as the second database keyword;Term academic year in the student achievement data storehouse is used as the 3rd database
Keyword;.General school all can store these databases with special system, therefore, such database can using it is ready-made
The database of establishment is obtained.
(2) recognize formatted file and obtain keyword.
Obtaining the first keyword according to student's student number of i-th of student's communication data storehouse record, (such as student's student number is
0123456 or student's student number for 0123457);Notice written matter is identified according to file extension pdf, further according to notice text
The keyword of part name acquiring second and the 3rd keyword, such as 2015 second terms academic year achievement notice .pdf, the 3rd
Keyword was 2015 second terms academic year, and the second keyword is achievement notice;Notified for 2015 second term academic year school timetables
Book .pdf, the 3rd keyword was 2015 second terms academic year, and the second keyword is school timetable notice.
(3) database retrieval.
Distribution object and format information are obtained according to keyword and database.
A record in student's communication data storehouse is retrieved, obtaining the first keyword, (such as student's student number is 0123456 or student
Student number is 0123457), and to obtain field information student name, student class, parent's name, parent's WeChat ID, parent mailbox
(as shown in table 11, student name is Zhang, and student class is senior class class Three, and parent's name is Zhang San, parent's WeChat ID for location
For zs0123456, parent's email address is 0123456@qq.com or student name is Mr. Li, and student class is Third school grade four
Class, parent's name is Li Si, and parent's WeChat ID is ls0123457, and parent's email address is 0123457@qq.com);
Table 11 obtains student's communication information
Second database is retrieved according to the second keyword (such as achievement notice or school timetable notice), the second keyword is obtained
Corresponding Template Information (such as achievement notice template .txt, Template Information as shown in Figure 9 or school timetable notice template .txt, mould
Plate information is as shown in Figure 10);
3rd database is retrieved according to the 3rd keyword (such as 2015 second terms academic year), obtains corresponding with the 3rd keyword
Performance information (such as student name, course name, course achievement, teacher's name, scholastic post, teacher's telephone number, religion
Teacher's WeChat ID, teacher's email address, Staff Room) or obtain corresponding with the 3rd keyword school timetable information (such as student name,
Course name, teacher's name, scholastic post, teacher's telephone number, teacher's WeChat ID, teacher's email address, teacher's office
Room);
Now, if it fails to match, such as the second keyword is not recorded in the second database, or lacks parent's WeChat ID
Deng then marking the formatted file, it fails to match, reenters the retrieval of next formatted file.
(4) information is compiled.
Performance information (such as student name, course name, course achievement, teacher's name, the teacher obtained according to screening
Position, teacher's telephone number, teacher's WeChat ID, teacher's email address, Staff Room) or school timetable information generation sublist (such as into
Achievement list or curriculum schedule) as formwork accessory, and the field information that screening is obtained is filled up to achievement notice template or school timetable leads to
Know generated in book template format information text (as generation achievement notice format information text as shown in figure 11 or generation, it is raw
Into school timetable notice format information text it is as shown in figure 12), formwork accessory and notice file generated attachment files, form letter
Text and attachment files are ceased together as information to be sent.
(5) information is sent.
The information to be sent is sent to corresponding parent's WeChat ID and/or corresponding parent's email address.
(6) judge whether it is last file and the last item record.
If all records notified in written matter and all student's communication data storehouses have all been retrieved and have been sent, that is, work as
Preceding formatted file is last formatted file, then statistics sends result, the transmission result include the mail that the match is successful,
Mail with failure, the mail that the match is successful includes sending successful mail, sends the mail of failure again, and for transmission, personnel seek
Look for transmission failure or (WeChat ID is not present or keyword is not present in database etc.) the reason for it fails to match;Otherwise recognize
Next formatted file, return to step (2).
As it will be easily appreciated by one skilled in the art that the foregoing is merely illustrative of the preferred embodiments of the present invention, it is not used to
The limitation present invention, any modifications, equivalent substitutions and improvements made within the spirit and principles of the invention etc., it all should include
Within protection scope of the present invention.