CN109522350A - A kind of method of account control parsing - Google Patents
A kind of method of account control parsing Download PDFInfo
- Publication number
- CN109522350A CN109522350A CN201811221981.7A CN201811221981A CN109522350A CN 109522350 A CN109522350 A CN 109522350A CN 201811221981 A CN201811221981 A CN 201811221981A CN 109522350 A CN109522350 A CN 109522350A
- Authority
- CN
- China
- Prior art keywords
- rule
- matching
- user
- file
- global
- 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
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y04—INFORMATION OR COMMUNICATION TECHNOLOGIES HAVING AN IMPACT ON OTHER TECHNOLOGY AREAS
- Y04S—SYSTEMS INTEGRATING TECHNOLOGIES RELATED TO POWER NETWORK OPERATION, COMMUNICATION OR INFORMATION TECHNOLOGIES FOR IMPROVING THE ELECTRICAL POWER GENERATION, TRANSMISSION, DISTRIBUTION, MANAGEMENT OR USAGE, i.e. SMART GRIDS
- Y04S10/00—Systems supporting electrical power generation, transmission or distribution
- Y04S10/50—Systems or methods supporting the power network operation or management, involving a certain degree of interaction with the load-side end user applications
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention provides a kind of methods of account control parsing, include the following steps: transmitting file in step 1)；Step 2 judges whether upper transmitting file can load the Excel file content of user by browser resolves, step 3) browser；Step 4) loads matching rule and matching configuration；Step 5) browser matches Excel file content according to resolution rules, is handled according to matching result: after step 6) determines submission, file and rule being submitted to business service end；After step 7) server-side obtains data, parsing access is carried out by rule to file, then acquired file data is put in storage；Step 8) server-side records the rule used；High frequent rule is automatically converted to global rule according to the frequency for the rule that user selects by hand by the matching result that step 9) O&M end is selected automatically according to user, and global rule library is improved in automatic extension；Step 10) platform operation maintenance personnel may cross O&M end adjust automatically global rule item.
Description
Technical field
The present invention relates to property tax management domains, and in particular to a kind of method of account control parsing.
Background technique
At this stage, same bank's difference street, since foregrounding personnel habit and bank's front end service system are not united
One, cause bank's flowing water (excel file) export format different, the work problem of repetition and fallibility is brought to financial staff.
Summary of the invention
In view of this, there is provided a kind of methods that account control parses for the main object of the present invention.
Its specific technical solution is as follows:
A kind of method of account control parsing, includes the following steps:
Step 1) user selects customized importing, transmitting file in selection；
Step 2 judges whether upper transmitting file can be by browser resolves, if it is not, request server parses upper transmitting file
Content；
The Excel file content of step 3) browser load user；
The matching rule and matching configuration that step 4) browser need to be used from server load this resolution file of user；
Step 5) browser matches Excel file content according to resolution rules, is handled according to matching result:
After step 6) determines submission, file and rule are submitted to business service end；
After step 7) server-side obtains data, parsing access is carried out by rule to file, then to acquired file data into
Row storage；
Step 8) server-side records the rule used；
The matching result that step 9) O&M end is selected automatically according to user will be high according to the frequency for the rule that user selects by hand
Frequency rule is automatically converted to global rule, and global rule library is improved in automatic extension；
Step 10) platform operation maintenance personnel may cross O&M end adjust automatically global rule item.
Further, in step 4), the matching rule is derived from global field matching rule pond；
There are as below methods obtains for the matching rule from global field matching rule pond:
A: initial stage configures common rule by business rule maintenance personnel；
B: the use result of record rule；
C: according to above-mentioned use as a result, the use of inquiry user's custom rule counts；
D: according to statistics is used, the use preference of user is recorded, configures global rule.
Further, the matching rule is according to following priority:
Set of books > user > overall situation is ranked up and duplicate removal, set of books rule come foremost and the second sequence temporally it is newest preferentially with
This analogizes, and finally obtains and is separated into a string of characters with comma and is given to front end, front end can successively carry out traversal matching from front to back.
Further, in step 4), the document of the matching rule and matching configuration limits matching range, hit-count
N。
Further, in step 5),
A. the head if identification is fallen out, shows that matching result confirms to user；
B. if head of falling out can not be identified, show Excel file content for user's alternative column head and column matched business category
Property.
User of the present invention is imported by bank's flowing water, hears account control using sea, specifies head definition, system automatic identification stream
Water information is inserted into flowing water information.
Detailed description of the invention
Below in conjunction with attached drawing, the present invention will be described in detail.
Fig. 1 is the flow chart of load Jixi part of specific embodiment provided by the invention；
Fig. 2 is the flow chart that the historical data of specific embodiment provided by the invention is extracted；
Fig. 3 is the matched method flow diagram of column of specific embodiment provided by the invention；
Fig. 4 is the document analysis method flow diagram of specific embodiment provided by the invention.
Specific embodiment
Below in conjunction with attached drawing and specific embodiment, the present invention will be described in detail, herein illustrative examples of the invention
And explanation is used to explain the present invention, but not as a limitation of the invention.
Referring to figs. 1 to Fig. 4, the annotation in Fig. 1 is respectively as follows:
Note 1: configuring common rule by business rule maintenance personnel, can select to match according to the access times income of user terminal rule
It sets；
Note 2: after obtaining three kinds of rules, according to priority: set of books > user > overall situation is ranked up and duplicate removal, before set of books rule comes most
Face and the second sequence are temporally newest preferential and so on, finally obtain and are separated into a string of characters with comma and are given to front end, front end
Traversal matching can be successively carried out from front to back；
Note 3: the data include document the restriction matching range, hit-count N of fields match rule and configuration；
Note 4: it during document analysis, is matched by fields match rule, when matching value reaches n times, this is identified as gauge outfit；
Note 5: regular number+1 is carried out to the rule used；Access times record purpose is in order to global on O&M end later
It can carry out option and installment field rule when configuration by access times.
The present invention provides a kind of methods of account control parsing, include the following steps:
Step 1) user selects customized importing, transmitting file in selection；
Step 2 judges whether upper transmitting file can be by browser resolves, if it is not, request server parses upper transmitting file
Content；
The Excel file content of step 3) browser load user；
The matching rule and matching configuration that step 4) browser need to be used from server load this resolution file of user；
Step 5) browser matches Excel file content according to resolution rules, is handled according to matching result:
After step 6) determines submission, file and rule are submitted to business service end；
After step 7) server-side obtains data, parsing access is carried out by rule to file, then to acquired file data into
Row storage；
Step 8) server-side records the rule used；
The matching result that step 9) O&M end is selected automatically according to user will be high according to the frequency for the rule that user selects by hand
Frequency rule is automatically converted to global rule, and global rule library is improved in automatic extension；
Step 10) platform operation maintenance personnel may cross O&M end adjust automatically global rule item.
Further, in step 4), the matching rule is derived from global field matching rule pond；
There are as below methods obtains for the matching rule from global field matching rule pond:
A: initial stage configures common rule by business rule maintenance personnel；
B: the use result of record rule；
C: according to above-mentioned use as a result, the use of inquiry user's custom rule counts；
D: according to statistics is used, the use preference of user is recorded, configures global rule.
The matching rule is according to following priority:
Set of books > user > overall situation is ranked up and duplicate removal, set of books rule come foremost and the second sequence temporally it is newest preferentially with
This analogizes, and finally obtains and is separated into a string of characters with comma and is given to front end, front end can successively carry out traversal matching from front to back.
In step 4), the document of the matching rule and matching configuration limits matching range, hit-count N.
In step 5),
A. the head if identification is fallen out, shows that matching result confirms to user；
B. if head of falling out can not be identified, show Excel file content for user's alternative column head and column matched business category
Property.
In step A), specific step includes:
A1: matching gauge outfit, the cell in traversal row are carried out；
A2: whether it is greater than n times after checking hit-count+1, if it is satisfied, gauge outfit data and corresponding relationship that record matching arrives；
A3: gauge outfit data and corresponding relationship are submitted.
In step B), specific step includes:
B1: matching gauge outfit, the cell in traversal row are carried out；
B2: whether it is greater than n times after checking hit-count+1, if conditions are not met, checking whether cell is the last one；If no
It is to jump to the last one cell, and return step B1；If so, judging whether current line is last line, if it is not, jumping
Go to next line, and return step B1；It is unidentified to arrive gauge outfit and corresponding relationship if last line, manually select gauge outfit；
B3: gauge outfit data and corresponding relationship are submitted.
Technical solution disclosed in the embodiment of the present invention is described in detail above, specific implementation used herein
Example is expounded the principle and embodiment of the embodiment of the present invention, and the explanation of above embodiments is only applicable to help to understand
The principle of the embodiment of the present invention；At the same time, for those skilled in the art is being embodied according to an embodiment of the present invention
There will be changes in mode and application range, in conclusion the content of the present specification should not be construed as to limit of the invention
System.
Claims (5)
1. a kind of method of account control parsing, which comprises the steps of:
Step 1) user selects customized importing, transmitting file in selection；
Step 2 judges whether upper transmitting file can be by browser resolves, if it is not, request server parses upper transmitting file
Content；
The Excel file content of step 3) browser load user；
The matching rule and matching configuration that step 4) browser need to be used from server load this resolution file of user；
Step 5) browser matches Excel file content according to resolution rules, is handled according to matching result:
After step 6) determines submission, file and rule are submitted to business service end；
After step 7) server-side obtains data, parsing access is carried out by rule to file, then to acquired file data into
Row storage；
Step 8) server-side records the rule used；
The matching result that step 9) O&M end is selected automatically according to user will be high according to the frequency for the rule that user selects by hand
Frequency rule is automatically converted to global rule, and global rule library is improved in automatic extension；
Step 10) platform operation maintenance personnel may cross O&M end adjust automatically global rule item.
2. the method for account control parsing according to claim 1, which is characterized in that in step 4), the matching rule
Then it is derived from global field matching rule pond；
There are as below methods obtains for the matching rule from global field matching rule pond:
A: initial stage configures common rule by business rule maintenance personnel；
B: the use result of record rule；
C: according to above-mentioned use as a result, the use of inquiry user's custom rule counts；
D: according to statistics is used, the use preference of user is recorded, configures global rule.
3. the method for account control parsing according to claim 1 or 2, which is characterized in that the matching rule is according to such as
Under priority:
Set of books > user > overall situation is ranked up and duplicate removal, set of books rule come foremost and the second sequence temporally it is newest preferentially with
This analogizes, and finally obtains and is separated into a string of characters with comma and is given to front end, front end can successively carry out traversal matching from front to back.
4. the method for account control parsing according to claim 1, which is characterized in that in step 4), the matching rule
Then the document with matching configuration limits matching range, hit-count N.
5. the method for account control parsing according to claim 1, which is characterized in that in step 5),
A. the head if identification is fallen out, shows that matching result confirms to user；
B. if head of falling out can not be identified, show Excel file content for user's alternative column head and column matched business category
Property.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811221981.7A CN109522350B (en) | 2018-10-19 | 2018-10-19 | Method for analyzing standing book control |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811221981.7A CN109522350B (en) | 2018-10-19 | 2018-10-19 | Method for analyzing standing book control |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109522350A true CN109522350A (en) | 2019-03-26 |
| CN109522350B CN109522350B (en) | 2023-07-11 |
Family
ID=65770959
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811221981.7A Active CN109522350B (en) | 2018-10-19 | 2018-10-19 | Method for analyzing standing book control |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109522350B (en) |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110119379A (en) * | 2019-05-09 | 2019-08-13 | 海闻科技有限公司 | A kind of pair of bank's pipelined data automatically parses method and device, storage medium |
| CN110188106A (en) * | 2019-05-31 | 2019-08-30 | 北京明朝万达科技股份有限公司 | A kind of data managing method and device |
| CN111125225A (en) * | 2019-12-24 | 2020-05-08 | 北京数衍科技有限公司 | Bill data analysis method and device and server |
| CN112364611A (en) * | 2020-09-29 | 2021-02-12 | 成都商通数治科技有限公司 | High-performance table importing method |
| CN112905422A (en) * | 2021-03-22 | 2021-06-04 | 上海联蔚盘云科技有限公司 | Alarm rule management method and equipment based on search server |
Citations (13)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| EP1320038A2 (en) * | 2001-12-10 | 2003-06-18 | Microsoft Corporation | Services for context sensitive flagging of information in natural language text and central management of metadata relating to that information over a computer network |
| CN101535945A (en) * | 2006-04-25 | 2009-09-16 | 英孚威尔公司 | Full text query and search systems and method of use |
| CN104267953A (en) * | 2014-09-27 | 2015-01-07 | 昆明钢铁集团有限责任公司 | Control and method for importing Word test questions based on browser |
| CN104778576A (en) * | 2015-03-13 | 2015-07-15 | 上海灵兮信息科技有限公司 | Method for automatically initializing accounting data set by using account balance report |
| CN104778412A (en) * | 2015-05-05 | 2015-07-15 | 中国农业银行股份有限公司 | Method and system for checking script |
| CN104966239A (en) * | 2015-06-30 | 2015-10-07 | 天津爱蔻科技有限公司 | Intelligent underwriting platform based on rule engine |
| CN105208689A (en) * | 2014-06-11 | 2015-12-30 | 中兴通讯股份有限公司 | Method and apparatus for inserting toolbar |
| CN106446299A (en) * | 2016-11-30 | 2017-02-22 | 深圳Tcl数字技术有限公司 | Website information downloading method and device |
| CN106779803A (en) * | 2016-11-24 | 2017-05-31 | 久远谦长（北京）技术服务有限公司 | A kind of method that financial institution's flowing water is matched with carrier data |
| CN107239581A (en) * | 2017-07-07 | 2017-10-10 | 小草数语（北京）科技有限公司 | Data cleaning method and device |
| CN107248065A (en) * | 2017-06-08 | 2017-10-13 | 中国建设银行股份有限公司 | Line reports table management method, system, device and storage medium |
| CN107506185A (en) * | 2017-08-07 | 2017-12-22 | 海闻科技有限公司 | A kind of data parsing and method for exhibiting data and system |
| CN108292321A (en) * | 2016-04-28 | 2018-07-17 | 华为技术有限公司 | A kind of file saving method and electronic equipment |
-
2018
- 2018-10-19 CN CN201811221981.7A patent/CN109522350B/en active Active
Patent Citations (13)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| EP1320038A2 (en) * | 2001-12-10 | 2003-06-18 | Microsoft Corporation | Services for context sensitive flagging of information in natural language text and central management of metadata relating to that information over a computer network |
| CN101535945A (en) * | 2006-04-25 | 2009-09-16 | 英孚威尔公司 | Full text query and search systems and method of use |
| CN105208689A (en) * | 2014-06-11 | 2015-12-30 | 中兴通讯股份有限公司 | Method and apparatus for inserting toolbar |
| CN104267953A (en) * | 2014-09-27 | 2015-01-07 | 昆明钢铁集团有限责任公司 | Control and method for importing Word test questions based on browser |
| CN104778576A (en) * | 2015-03-13 | 2015-07-15 | 上海灵兮信息科技有限公司 | Method for automatically initializing accounting data set by using account balance report |
| CN104778412A (en) * | 2015-05-05 | 2015-07-15 | 中国农业银行股份有限公司 | Method and system for checking script |
| CN104966239A (en) * | 2015-06-30 | 2015-10-07 | 天津爱蔻科技有限公司 | Intelligent underwriting platform based on rule engine |
| CN108292321A (en) * | 2016-04-28 | 2018-07-17 | 华为技术有限公司 | A kind of file saving method and electronic equipment |
| CN106779803A (en) * | 2016-11-24 | 2017-05-31 | 久远谦长（北京）技术服务有限公司 | A kind of method that financial institution's flowing water is matched with carrier data |
| CN106446299A (en) * | 2016-11-30 | 2017-02-22 | 深圳Tcl数字技术有限公司 | Website information downloading method and device |
| CN107248065A (en) * | 2017-06-08 | 2017-10-13 | 中国建设银行股份有限公司 | Line reports table management method, system, device and storage medium |
| CN107239581A (en) * | 2017-07-07 | 2017-10-10 | 小草数语（北京）科技有限公司 | Data cleaning method and device |
| CN107506185A (en) * | 2017-08-07 | 2017-12-22 | 海闻科技有限公司 | A kind of data parsing and method for exhibiting data and system |
Non-Patent Citations (2)
| Title |
|---|
| 汪志传: "基建账套并入事业单位账的会计处理", 《市场周刊(理论研究)》 * |
| 谢振宇: "企业所得税台账管理系统设计与实现 ——税源监控、分析评估、风险预警", 《中国优秀硕士学位论文全文数据库 (信息科技辑)》 * |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110119379A (en) * | 2019-05-09 | 2019-08-13 | 海闻科技有限公司 | A kind of pair of bank's pipelined data automatically parses method and device, storage medium |
| CN110188106A (en) * | 2019-05-31 | 2019-08-30 | 北京明朝万达科技股份有限公司 | A kind of data managing method and device |
| CN110188106B (en) * | 2019-05-31 | 2021-04-16 | 北京明朝万达科技股份有限公司 | Data management method and device |
| CN111125225A (en) * | 2019-12-24 | 2020-05-08 | 北京数衍科技有限公司 | Bill data analysis method and device and server |
| CN112364611A (en) * | 2020-09-29 | 2021-02-12 | 成都商通数治科技有限公司 | High-performance table importing method |
| CN112905422A (en) * | 2021-03-22 | 2021-06-04 | 上海联蔚盘云科技有限公司 | Alarm rule management method and equipment based on search server |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109522350B (en) | 2023-07-11 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109522350A (en) | A kind of method of account control parsing | |
| CN110765770B (en) | Automatic contract generation method and device | |
| JP6764779B2 (en) | Synonymous column candidate selection device, synonymous column candidate selection method, and synonymous column candidate selection program | |
| US9495347B2 (en) | Systems and methods for extracting table information from documents | |
| CN110704633A (en) | Named entity recognition method and device, computer equipment and storage medium | |
| CN106528532A (en) | Text error correction method and device and terminal | |
| CN110990546B (en) | Intelligent question-answer corpus updating method and device | |
| US20170212921A1 (en) | Annotation system for extracting attributes from electronic data structures | |
| CN110232187A (en) | Enterprise name similarity recognition method, device, computer equipment and storage medium | |
| US10789533B2 (en) | Generating a consistently labeled training dataset by automatically generating and displaying a set of most similar previously-labeled texts and their previously assigned labels for each text that is being labeled for the training dataset | |
| US20170228356A1 (en) | System Generator Module for Electronic Document and Electronic File | |
| CN106681299A (en) | Event analysis device, event analysis system, event analysis method, and event analysis program | |
| CN103246690A (en) | Tag inheritance | |
| CN105302786B (en) | The edit methods and device of data | |
| CN110264996B (en) | Method, device and equipment for determining voice labeling quality and computer readable medium | |
| JP7081396B2 (en) | Generation method, generation program, and generation device | |
| CN110119379A (en) | A kind of pair of bank's pipelined data automatically parses method and device, storage medium | |
| CN110968730A (en) | Audio mark processing method and device, computer equipment and storage medium | |
| KR20080041388A (en) | System and method for classifying document | |
| CN117973334B (en) | Automatic identification importing method based on file form | |
| US10956914B2 (en) | System and method for mapping a customer journey to a category | |
| CN104202458A (en) | Method and intelligent terminal for automatically storing contact information | |
| CN103246642B (en) | Information processor and information processing method | |
| CN117149182B (en) | Low-coupling configuration method, medium and equipment for front-end page | |
| CN107943785B (en) | PDF document processing method and device based on big data |
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 |