CN110069449A - Document handling method, device, computer equipment and storage medium - Google Patents

Document handling method, device, computer equipment and storage medium Download PDF

Info

Publication number
CN110069449A
CN110069449A CN201910212526.9A CN201910212526A CN110069449A CN 110069449 A CN110069449 A CN 110069449A CN 201910212526 A CN201910212526 A CN 201910212526A CN 110069449 A CN110069449 A CN 110069449A
Authority
CN
China
Prior art keywords
file
data
template
filename
type information
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Granted
Application number
CN201910212526.9A
Other languages
Chinese (zh)
Other versions
CN110069449B (en
Inventor
宋斌
戚强
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Ping An Technology Shenzhen Co Ltd
Original Assignee
Ping An Technology Shenzhen Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Ping An Technology Shenzhen Co Ltd filed Critical Ping An Technology Shenzhen Co Ltd
Priority to CN201910212526.9A priority Critical patent/CN110069449B/en
Publication of CN110069449A publication Critical patent/CN110069449A/en
Priority to PCT/CN2019/117942 priority patent/WO2020186786A1/en
Application granted granted Critical
Publication of CN110069449B publication Critical patent/CN110069449B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/10File systems; File servers
    • G06F16/13File access structures, e.g. distributed indices
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/10File systems; File servers
    • G06F16/16File or folder operations, e.g. details of user interfaces specifically adapted to file systems

Abstract

This application involves data processing field, in particular to a kind of document handling method, device, computer equipment and storage medium.The described method includes: receiving file and file type information that terminal is uploaded by data management system;The first filename is extracted from file destination, judges whether the first filename matches with file type information, and the first filename is configured by the data management system is unified;When the first filename is matched with file type information, the corresponding reading data strategy of file type information is obtained;Target data is read from file destination according to reading data strategy, and data check is carried out to target data;When data check success, target data is added in the corresponding tables of data of file type information.It can be improved the data-handling efficiency of file destination using this method.

Description

Document handling method, device, computer equipment and storage medium
Technical field
This application involves field of computer technology, more particularly to a kind of document handling method, device, computer equipment and Storage medium.
Background technique
With the continuous development of information age, current each company, mechanism have special data management system to work number According to progress storage management, and the mass data generated in routine work needs to be uploaded to data management system.
Currently, when the data file of the types such as the excel uploaded to user carries out dissection process, due to it can not predict on The data content that transmitting file is included needs to read the data in transmitting file line by line, and identifies to data format, needs A large amount of resource space is wasted, and data processing speed is very slow.
Summary of the invention
Based on this, it is necessary in view of the above technical problems, provide a kind of text of the data-handling efficiency of transmitting file in raising Part processing method, device, computer equipment and storage medium.
A kind of file destination processing method, which comprises
Receive file destination and file type information that terminal is uploaded by data management system;
The first filename is extracted from the file destination, judges that first filename and the file type information are No matching, first filename are configured by the data management system is unified;
When first filename is matched with the file type information, the corresponding number of first service identification is obtained It is tactful according to reading;
Target data is read from the file destination according to the reading data strategy, and the target data is carried out Data check;
When data check success, the target data is added in the corresponding tables of data of the file type information.
File destination and file type letter that terminal is uploaded by data management system are received in one of the embodiments, Before breath, comprising:
It receives the template that terminal is sent and downloads request, carry the first service identification and first in the template downloading request and use Family mark;
Search the corresponding file template of first service identification;
The second filename is generated according to first service identification and first user identifier;
File template is generated according to the file template and second filename, the file template is returned into end End.
File template is generated according to the file template and second filename in one of the embodiments, comprising:
Search the corresponding industry number of first user identifier;
Search the corresponding limitation data class of the industry number;
The file template is handled according to the limitation data class, the file template and institute according to treated It states the second filename and generates file template.
The target data is added to the corresponding tables of data of the file type information in one of the embodiments, In, comprising:
The second service identification and second user mark are extracted from the file type information;
Search the corresponding business datum table of second service identification;
Obtain the uplink time of the file destination;
The target data is added to the mark of second user described in the business datum table and the uplink time pair The position answered.
Target data is read from the file destination according to the reading data strategy in one of the embodiments, And data check is carried out to the target data, comprising:
File data is obtained from the reading data strategy stores information;
Information, which is stored, according to the file data searches data type from the target data as the first of system type File field, and read the first file field name and the first file word segment value of first file field;
Search the corresponding system data of the first file field name;
The first file word segment value is subjected to Data Matching with the system data one by one;
When all the first file word segment values with the system data successful match when, then data check success.
Target data is read from the file destination according to the reading data strategy in one of the embodiments, And data check is carried out to the target data, comprising:
File data is obtained from the reading data strategy stores information;
Information, which is stored, according to the file data searches data type from the target data as the second of non-heavy type File field, and read the second file word segment value of second file field;
Judge in the second file word segment value with the presence or absence of repetition numerical value;
When determining in the second file word segment value there is no numerical value is repeated, then data check success.
A kind of file destination processing unit, described device include:
Data reception module, the file destination and file type uploaded for receiving terminal by data management system are believed Breath;
File matching module, for extracting the first filename from the file destination, judge first filename with Whether the file type information matches, and first filename is configured by the data management system is unified;
Rule acquisition module, for obtaining institute when determining that first filename is matched with the file type information State the corresponding reading data strategy of the first service identification;
Data read module, for reading target data from the file destination according to the reading data strategy, and Data check is carried out to the target data;
Data adding module, for the target data being added to the file type and is believed when data check success It ceases in corresponding tables of data.
Device in one of the embodiments, further include:
Request receiving module carries for receiving the template downloading request of terminal transmission in template downloading request One service identification and the first user identifier;
Template searching module, for searching the corresponding file template of first service identification;
Filename generation module, for generating the second file according to first service identification and first user identifier Name;
Template generation module will be described for generating file template according to the file template and second filename File template returns to terminal.
A kind of computer equipment, including memory and processor, the memory are stored with computer program, the processing The step of device realizes the above method when executing the computer program.
A kind of computer readable storage medium, is stored thereon with computer program, and the computer program is held by processor The step of above method is realized when row.
Above-mentioned document handling method, device, computer equipment and storage medium, by uploading text simultaneously in upper transmitting file Part type information, and then can judge whether the file uploaded is correct according to file type information, it avoids uploading wrong text The phenomenon that read error data are also continued when part obtains corresponding with file type information preparatory when the file of upload is accurate The reading data strategy of setting can determine each data storage information in upper transmitting file according to reading data strategy, according to data Upload data can be read directly from file destination by reading strategy, no longer need to identify the data content in file, is whole The processing operations such as conjunction, to effectively improve the data reading performance using redundancy of transmitting file.
Detailed description of the invention
Fig. 1 is the application scenario diagram of document handling method in one embodiment;
Fig. 2 is the flow diagram of document handling method in one embodiment;
Fig. 3 is the flow diagram of document handling method in another embodiment;
Fig. 4 is the structural block diagram of document handling apparatus in one embodiment;
Fig. 5 is the internal structure chart of computer equipment in one embodiment.
Specific embodiment
It is with reference to the accompanying drawings and embodiments, right in order to which the objects, technical solutions and advantages of the application are more clearly understood The application is further elaborated.It should be appreciated that specific embodiment described herein is only used to explain the application, not For limiting the application.
Upload document handling method provided by the present application, can be applied in application environment as shown in Figure 1.Wherein, eventually End 102 is communicated with server 104 by network by network.Terminal 102 is sent out by data management system to server 104 The file type information of the file destination for sending user to upload and user's selection, server 104 are extracted from received file destination Whether the first filename out, disconnected first filename match with file type information;When the first filename of judgement and file type are believed When breath matching, the corresponding reading data strategy comprising file data storage information of file type information is obtained;It is read according to data It takes strategy to read target data from file destination, and data check is carried out to target data;When data check success, by mesh Mark data are added in the corresponding tables of data of file type information.
Wherein, terminal 102 can be, but not limited to be various personal computers, laptop, smart phone, tablet computer With portable wearable device, server 104 can use the server set of the either multiple server compositions of independent server Group realizes.
In one embodiment, as shown in Fig. 2, providing a kind of document handling method, it is applied in Fig. 1 in this way Be illustrated for server 104, method the following steps are included:
Step 210, file destination and file type information that terminal is uploaded by data management system are received.
Data management system is used to be managed collectively the business datum of maintenance user, can generate in daily vocational work a large amount of Business datum, when there is newly-increased business datum or when business datum changes, user can will be newly-increased or the industry that changes Business data are uploaded to data management system in the form of data file, such as can periodically upload daily, can also have data more It is uploaded when new demand.
User can upload file destination by the data management system in terminal, and user can be with when uploading file destination The type of service of the upper affiliated business of transmitting file is selected by the system page, terminal generates file according to the type of service that user selects File destination and file type information are sent to server by type information, file destination that server receiving terminal is sent and File type information.
Specifically, the file type of file destination can be the types such as excel, txt, csv.It can be in file type information Including service type information, be such as used for the service identification of mark business-type, also may include user information, as user identifier, Department's mark of user affiliated function etc..The user information of the available currently logged on user of terminal, believes according to type of service Breath and user information generate file type information.
Step 220, the first filename is extracted from file destination, judge the first filename and file type information whether Match, first filename is configured by the data management system is unified.
First filename of server extraction file destination.The file destination uploaded by the data management system of terminal, The unified configuration such as type of service and user information that its filename is selected by data management system according to user generates, in filename Including at least the service identification of type of service, service identification is arranged at the preset characters position in filename.
Server extracts service identification from the preset characters position of the first filename, and from received file type Service type information is extracted, service type information can be service identification or other indicate the information of types of service, For example, the other kinds of information such as Business Name, service code,
If other indicate that the information of type of service, the mapping relations between information and service identification can be stored in advance in In server.
Whether the service identification that server judgement extracts matches with service type information, thus according to the text of file destination Part name and the type of service of the file of user's selection judge whether the file destination of ownership goal is correct, avoids ownership goal mistake Unnecessary reading data work is carried out when file.When server determines the first filename and file type information mismatch When, server generates file destination miscue and returns to terminal, and terminal shows file destination miscue, for User again file destination or modify file type of service, guarantee the accuracy of file destination.
Step 230, when the first filename is matched with file type information, the corresponding data of file type information is obtained and are read Take strategy.
When server, which determines the first filename, to be matched with file type information, server is mentioned from file type information Type of service is taken out, reading data strategy corresponding with type of service is searched.In the present embodiment, various businesses type is corresponding Data storage information in file destination be it is pre-determined, server according to the data storage information of file set file in number According to reading data strategy.
File data storage information may include the field name for the file field for including, the locating column of each file field in file Location information, the data format information of file word segment value and the information such as data header of file.Wherein, location information can wrap Include the row number of field column, field puts in order, data format information may include the data length of field value, data Type such as text, character string etc..
Reading data strategy can store the reading order that information determine each file field according to file data, can such as incite somebody to action File field column put in order as reading order, and determine the data verification method of each file field, such as according to each text Data format of the corresponding field contents of part field, field attribute and field etc. carries out data check etc., and reading data strategy is also It may include other logic strategies relevant to reading.
Step 240, target data is read from file destination according to reading data strategy, and data is carried out to target data Verification.
Server based on data read strategy read line by line from file destination file word segment value then break form a plurality of data Record, and data check is carried out to each file word segment value according to the data format of each file field, judge file word segment value Whether the formats such as data length, data type meet preset data form.If each file word segment value in every record meets When preset data form, then the data record is verified successfully;If there is the text for not meeting preset data form in data record When part field value, then fail to the record data check.
Further, server can be generated when having read all data records according to the data record of verification failure Error reporting is uploaded, uploading may include line number of the error logging in file destination, error reason such as " length in error reporting It is undesirable ", " data type mistake etc. ", the upload error reporting of generation returns to terminal by server.
Step 250, when data check success, target data is added in the corresponding tables of data of file type information.
When the field value of All Files field in file destination verifies successfully, server locating file type information pair The tables of data answered.Tables of data can store in the database of the data management platform of server, and be carried out according to file type Classification, server generate multiple tables of data according to the class categories of file, can such as be marked according to type of service to tables of data Note, can also be after being classified, further according to user information such as user department, group etc. to tables of data according to type of service It is finely divided.Server is after finding corresponding tables of data in the database of data management platform, by the data record of reading It is added in corresponding tables of data, to complete the reading data work of file destination.
In another embodiment, when in file destination exist verification failure data record when, server will verify at The data record of function is added in corresponding tables of data, and to information such as file destination title, error logging line number, uplink times It is recorded, so that modified file destination number is passed at the terminal, what server can be recorded according to the wrong data of record Information reads modified data record from the file uploaded again and verifies again, will be modified when verifying successfully Data record is added in corresponding tables of data at Data Position corresponding with uplink time.
In the above method, user at the terminal transmitting file when need to upload file type information simultaneously, server is according to reception The file type information file that may determine that user uploads it is whether correct, avoid user upload wrong file also continue reading it is wrong Accidentally data, determine file upload it is accurate after, obtain with according to the corresponding reading data strategy being previously set of file type information, It anticipated that each data storage information in upper transmitting file according to reading data strategy, it can be directly from upper according to reading data strategy Target data is read in transmitting file, no longer needs to the processing operations such as identify the data content in file, integrate, thus effectively Improve the data reading performance using redundancy of the file destination uploaded.
In one embodiment, as shown in figure 3, the file destination that server receiving terminal is uploaded by data management system Before with file type information can with the following steps are included:
Step 202, it receives the template that terminal is sent and downloads request, carry the first service identification and the in template downloading request One user identifier.
User needs to use file using file template as defined in data management system before the transmitting file in terminal Template logging data.Template download function can be provided in the data management system of terminal, user is selected under needs on the page The type of service of the file template of load, and after filesselected download function button, generate the type of service for carrying user's selection The first service identification and login user user identifier template download request, terminal by template downloading request be sent to clothes Business device reads the first service identification and the first user identifier after server receives template downloading request from request.
Step 204, the corresponding file template of the first service identification is searched.
Multiple file templates, the corresponding file template of every kind of type of service, file template have been previously set in server In define the data field for needing typing, the arrangement information of each field, the title etc. of file.Further, in file template The data format that each field column can also be set, when user's logging data can automatically to the format of logging data into Row verification, saves data format verifying work when reading data.File template is according to the service identification for corresponding to type of service It is marked, server searches file template corresponding with the first service identification.
Step 206, the second filename is generated according to the first service identification and the first user identifier.
In the present embodiment, the naming rule of file template is also to be previously set, and includes service identification and use in name Family identifies two parts fix information, can not change after user's downloading to this two parts information, thus when facilitating transmitting file on user Whether self-test is correctly carried out to upper transmitting file according to filename.Server is generated according to the first service identification and the first user identifier Second filename.
Step 208, file template is generated according to file template and the second filename, file template is returned into terminal.
Server is named file template according to the second filename, and the file template after name is returned to terminal. In other embodiments, file template also can store at the terminal, directly obtain file template from terminal local.
In one embodiment, generating file template according to file template and the second filename may include: lookup first The corresponding industry number of user identifier;Search the corresponding limitation data class of industry number;According to limitation data class to file template It is handled, file template is generated according to treated file template and the second filename.
For same business, the data requirementss of different departments may be different, if any department and non-required all numbers According to field, these fields are restricted data.Contain what all departments needed in the corresponding file template of each business department Data field needs to handle the restricted data in file template for there is the department of special data demand.
The restricted data of each department of every kind of business have been previously stored in server, specifically can store industry number with The mapping relations of each limited field in restricted data.Server searches the corresponding industry number of the first user identifier, and searches The corresponding restricted data of industry number, obtain each limited field in restricted data, according to limited field to file template In corresponding field column be hidden invisible setting or deletion setting, and according to the second filename to treated file mould Plate is named.
In the present embodiment, by the way that the restricted data of each department are arranged, it is more that same file template satisfaction may be implemented The business datum demand of a business department.
In one embodiment, target data is added in the corresponding tables of data of file type information may include: from The second service identification and second user mark are extracted in file type information;Search the corresponding business datum of the second service identification Table;Obtain the uplink time of file destination;Target data is added to second user mark and uplink time in business datum table Corresponding position.
Server extracts the second service identification and second user mark of upper transmitting file from file type information.It needs Illustrate, uses " second " to be here in order to show with " first " in above-described embodiment and distinguish, the mesh that user uploads here Mark file can be the file for the file template logging data downloaded in through the foregoing embodiment, be also possible to pass through alternative document The file of template logging data, i.e. the first service identification and the second service identification, the first user identifier and second user mark can Energy is identical may also be different.
Belong to the data summarization of same type of service into a tables of data, it is corresponding that server searches the first service identification Tables of data, tables of data can be divided into multiple data sublists according to business department, can carry out by user identifier in data sublist The data of same user are stored together, and are ranked up according to chronological order by data arrangement.Server searches user The corresponding data sublist of affiliated function is identified, the data in data sublist are labeled all in accordance with the uplink time of file, and root It is marked according to uplink time to data are uploaded.Server obtains the uplink time of upper transmitting file, if remodifying the file of upload, Uplink time be file uplink time for the first time, server will upload data be added to it is corresponding with uplink time in data sublist At position.
In one embodiment, target data is read from file destination according to reading data strategy, and to target data Carrying out data check may include: that file data storage information is obtained from reading data strategy;It is stored and is believed according to file data The first file field for searching that data type is system type from target data is ceased, and reads the first text of the first file field Part field name and the first file word segment value;Search the corresponding system data of the first file field name;By the first file word segment value by It is a to carry out Data Matching with system data;When the first all file word segment values with system data successful match when, then data It verifies successfully.
Information is stored comprising file data in reading data strategy, file data storage information, which may include in file, includes File field field name, the data format information such as data of the locating location information arranged of each file field, file word segment value The information such as type and the data header of file.Server obtains the file data in reading data strategy and stores information.
The data type of file field in the file of upload is classified according to the numerical value feature of field value, can be divided into General type, system type, non-heavy type etc. such as can be classified as general type without what particular values required.Server The data type of data field each in file template is configured in advance, server obtains the data type of each file field, And judge whether there is the data type of system type.The data of system type are system number fixed in data management system According to, such as name of product, product coding because the product in business be it is determining, name of product, product coding are also true Fixed, these data are previously stored in the database, corresponding in database when increasing newly such as product when there is data update System data also accordingly updates.
Server stores information according to file data, searches and whether there is data type in the target data of this document to be The file field for type of uniting, when there are the first file field of system type, server obtains the first text of this document field Part field name and the first file word segment value, and system data corresponding with the first file field name is searched, by the first file field Value is matched with the system data found one by one, the successful match if finding consistent system data, when all texts Then this document field is verified successfully when the equal successful match of part field value.For example, there are name of product field, clothes in upper transmitting file Corresponding field value is compared by business device with the name of product data in system data, when name of product is beyond system data Range then shows that the possible logging data of user is wrong, data check failure.
In one embodiment, target data is read from file destination according to reading data strategy, and to target data Carrying out data check may include: that file data storage information is obtained from reading data strategy;It is stored and is believed according to file data The second file field for searching that data type is non-heavy type from target data is ceased, and reads the second text of the second file field Part field value;Judge in the second file word segment value with the presence or absence of repetition numerical value;It is heavy when determining to be not present in the second file word segment value When complex values, then data check success.
Information is stored comprising file data in reading data strategy, file data storage information, which may include in file, includes File field field name, the data format information such as data of the locating location information arranged of each file field, file word segment value The information such as type and the data header of file.Server obtains the file data in reading data strategy and stores information.
Should not occur mutual duplicate numerical value in the field value of the file field of non-heavy type, such as the cell-phone number code word of client Section, cannot there is a situation where that two Client handset numbers are identical in the data of user's typing.Server obtains each file field Data type, and judge whether there is the data type of non-heavy type.Server stores information according to file data, searches this article It whether there is the file field that data type is non-heavy type in the target data of part, when there are the second file words of non-heavy type Duan Shi, server obtain all second file word segment values in second file field, and will be two between the second file word segment value Two are compared, and judge whether there is duplicate field value, when pleonasm segment value is not present in the second file word segment value, then right Second file field data check success;Fail conversely, being verified to this document field data.
It should be noted that same file field can correspond to numerous types of data, it such as both can be that system type can also Think non-heavy type, in this case, needs both to need to be verified according to the corresponding data verification method of system type, also need It to be verified according to the corresponding data verification method of non-heavy type.
It should be understood that although each step in the flow chart of Fig. 2-3 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, these steps can execute in other order.Moreover, at least one in Fig. 2-3 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, the execution sequence in these sub-steps or stage is also not necessarily successively It carries out, but can be at least part of the sub-step or stage of other steps or other steps in turn or alternately It executes.
In one embodiment, as shown in figure 4, providing a kind of file destination processing unit, comprising: data reception module 410, file matching module 420, rule acquisition module 430, data read module 440 and data adding module 450, in which:
Data reception module 410, the file destination uploaded by data management system for receiving terminal and file type Information.
File matching module 420 judges first filename for extracting the first filename from the file destination Whether matched with the file type information, first filename is configured by the data management system is unified.
Rule acquisition module 430, for obtaining the first business when determining that the first filename is matched with file type information Identify corresponding reading data strategy.
Data read module 440, for reading target data from file destination according to reading data strategy, and to described Target data carries out data check.
Data adding module 450, for it is corresponding that target data to be added to file type information when data check success Tables of data in.
In one embodiment, document handling apparatus can also include:
Request receiving module carries the first industry in template downloading request for receiving the template downloading request of terminal transmission Business mark and the first user identifier.
Template searching module, for searching the corresponding file template of the first service identification.
Filename generation module, for generating the second filename according to the first service identification and the first user identifier.
Template generation module returns to file template for generating file template according to file template and the second filename To terminal.
In one embodiment, template generation module can also include:
Number searching unit, for searching the corresponding industry number of the first user identifier.
Restricted searching unit, for searching the corresponding limitation data class of industry number.
Template processing unit, for being handled according to limitation data class file template, according to treated file mould Plate and the second filename generate file template.
In one embodiment, data adding module 450 may include:
Marker extraction unit, for extracting the second service identification and second user mark from file type information.
Tables of data searching unit, for searching the corresponding business datum table of the second service identification.
Time acquisition unit, for obtaining the uplink time of file destination.
Adding unit, it is corresponding with uplink time for target data to be added to second user mark in business datum table Position.
In one embodiment, data read module 440 may include:
Information reading unit stores information for obtaining file data from the reading data strategy;
Field data acquiring unit searches data from the target data for storing information according to the file data Type is the first file field of system type, and reads the first file field name and the first file of first file field Field value.
System data searching unit, for searching the corresponding system data of the first file field name.
Data matching unit, for the first file word segment value to be carried out Data Matching with system data one by one.
First verification unit, for when all first file word segment values with system data successful match when, then data school Test success.
In one embodiment, data read module 440 may include:
Information reading unit stores information for obtaining file data from the reading data strategy;
Field value acquiring unit searches data class from the target data for storing information according to the file data Type is the second file field of non-heavy type, and reads the second file word segment value of second file field.
Non- heavy judging unit, for judging in the second file word segment value with the presence or absence of repetition numerical value.
Second verification unit, for when determine the second file word segment value in there is no repeat numerical value when, then data check at Function.
In one embodiment, a kind of computer equipment is provided, which can be server, internal junction Composition can be as shown in Figure 5.The computer equipment include by system bus connect processor, memory, network interface and Database.Wherein, the processor of the computer equipment is for providing calculating and control ability.The memory packet of the computer equipment Include non-volatile memory medium, built-in storage.The non-volatile memory medium is stored with operating system, computer program and data Library.The built-in storage provides environment for the operation of operating system and computer program in non-volatile memory medium.The calculating The database of machine equipment uploads file process related data for storing.The network interface of the computer equipment is used for and outside Terminal passes through network connection communication.To realize a kind of upload document handling method when the computer program is executed by processor.
It will be understood by those skilled in the art that structure shown in Fig. 5, only part relevant to application scheme is tied The block diagram of structure does not constitute the restriction for the computer equipment being applied thereon to application scheme, specific computer equipment It may include perhaps combining certain components or with different component layouts than more or fewer components as shown in the figure.
In one embodiment, a kind of computer equipment, including memory and processor are provided, which is stored with Computer program, the processor perform the steps of the mesh for receiving and uploading by data management system when executing computer program Mark file and file type information;The first filename is extracted from file destination, judges the first filename and file type information Whether match, first filename is configured by the data management system is unified;When the first filename and file type information When matching, the corresponding reading data strategy of file type information is obtained;Mesh is read from file destination according to reading data strategy Data are marked, and data check is carried out to target data;When data check success, target data is added to file type information In corresponding tables of data.
In one embodiment, it is also performed the steps of when processor executes computer program and receives the mould that terminal is sent Plate downloading request, template are downloaded in request and carry the first service identification and the first user identifier;It is corresponding to search the first service identification File template;The second filename is generated according to the first service identification and the first user identifier;According to file template and the second text Part name generates file template, and file template is returned to terminal.
In one embodiment, processor executes computer program and realizes according to file template and the second filename generation text It is also used to when the step of part template: searching the corresponding industry number of the first user identifier;Search the corresponding limitation number of industry number According to class;File template is handled according to limitation data class, text is generated according to treated file template and the second filename Part template.
In one embodiment, processor executes computer program realization and target data is added to file type information pair It is also used to when step in the tables of data answered: extracting the second service identification and second user mark from file type information;It looks into Look for the corresponding business datum table of the second service identification;Obtain the uplink time of file destination;Target data is added to business number Position corresponding with the object time is identified according to second user in table.
In one embodiment, processor executes computer program and realizes according to reading data strategy from the file destination Middle reading target data, and to target data carry out data check step when be also used to: from reading data strategy obtain text Part data storage information;Information is stored according to file data, and the first text that data type is system type is searched from target data Part field, and read the first file field name and the first file word segment value of the first file field;Search the first file field name Corresponding system data;First file word segment value is subjected to Data Matching with system data one by one;When the first all file words Segment value with system data successful match when, then data check success.
In one embodiment, it is realized when processor executes computer program literary from the target according to reading data strategy It is also used to when reading target data in part, and carrying out the step of data check to target data: being obtained from reading data strategy File data stores information;Information, which is stored, according to file data searches data type from target data as the second of non-heavy type File field, and read the second file word segment value of the second file field;Judge in the second file word segment value with the presence or absence of repetition Numerical value;When determining in the second file word segment value there is no numerical value is repeated, then data check success.
In one embodiment, a kind of computer readable storage medium is provided, computer program is stored thereon with, is calculated Machine program performs the steps of when being executed by processor receives the file destination uploaded by data management system and file type Information;The first filename is extracted from file destination, judges whether the first filename matches with file type information, described first Filename is configured by the data management system is unified;When the first filename is matched with file type information, files classes are obtained The corresponding reading data strategy of type information;Target data is read from file destination according to reading data strategy, and to number of targets According to progress data check;When data check success, target data is added in the corresponding tables of data of file type information.
In one embodiment, it is also performed the steps of when computer program is executed by processor and receives what terminal was sent Template downloading request, template are downloaded in request and carry the first service identification and the first user identifier;Search the first service identification pair The file template answered;The second filename is generated according to the first service identification and the first user identifier;According to file template and second Filename generates file template, and file template is returned to terminal.
In one embodiment, text is generated according to file template and the second filename when computer program is executed by processor It is also used to when the step of part template: searching the corresponding industry number of the first user identifier;Search the corresponding limitation number of industry number According to class;File template is handled according to limitation data class, text is generated according to treated file template and the second filename Part template.
In one embodiment, it is realized when computer program is executed by processor and target data is added to file type letter It is also used to when ceasing the step in corresponding tables of data: extracting the second service identification and second user mark from file type information Know;Search the corresponding business datum table of the second service identification;Obtain the object time of file destination;Target data is added to industry Second user identifies position corresponding with the object time in tables of data of being engaged in.
In one embodiment, computer program is realized when being executed by processor according to reading data strategy from the target It is also used to when reading target data in file, and carrying out the step of data check to target data: being obtained from reading data strategy File data is taken to store information;Information, which is stored, according to file data searches data type from target data as the of system type One file field, and read the first file field name and the first file word segment value of the first file field;Search the first file word The corresponding system data of section name;First file word segment value is subjected to Data Matching with system data one by one;When the first all texts Part field value with system data successful match when, then data check success.
In one embodiment, computer program is realized when being executed by processor according to reading data strategy from the target It is also used to when reading target data in file, and carrying out the step of data check to target data: being obtained from reading data strategy File data is taken to store information;Information, which is stored, according to file data searches data type from target data as the of non-heavy type Two file fields, and read the second file word segment value of the second file field;Judge in the second file word segment value with the presence or absence of weight Complex values;When determining in the second file word segment value there is no numerical value is repeated, then data check success.
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, the computer program can be stored in a non-volatile computer In read/write memory medium, the computer program is when being executed, it may include such as the process of the embodiment of above-mentioned each method.Wherein, To any reference of memory, storage, database or other media used in each embodiment provided herein, Including non-volatile and/or volatile memory.Nonvolatile memory may include read-only memory (ROM), programming ROM (PROM), electrically programmable ROM (EPROM), electrically erasable ROM (EEPROM) or flash memory.Volatile memory may include Random access memory (RAM) or external cache.By way of illustration and not limitation, RAM is available in many forms, Such as static state RAM (SRAM), dynamic ram (DRAM), synchronous dram (SDRAM), double data rate sdram (DDRSDRAM), enhancing Type SDRAM (ESDRAM), synchronization link (Synchlink) DRAM (SLDRAM), memory bus (Rambus) direct RAM (RDRAM), direct memory bus dynamic ram (DRDRAM) and memory bus dynamic ram (RDRAM) etc..
Each technical characteristic of above embodiments can be combined arbitrarily, for simplicity of description, not to above-described embodiment In each technical characteristic it is all possible combination be all described, as long as however, the combination of these technical characteristics be not present lance Shield all should be considered as described in this specification.
The several embodiments of the application above described embodiment only expresses, the description thereof is more specific and detailed, but simultaneously It cannot therefore be construed as limiting the scope of the patent.It should be pointed out that coming for those of ordinary skill in the art It says, without departing from the concept of this application, various modifications and improvements can be made, these belong to the protection of the application Range.Therefore, the scope of protection shall be subject to the appended claims for the application patent.

Claims (10)

1. a kind of document handling method, which comprises
Receive file destination and file type information that terminal is uploaded by data management system;
The first filename is extracted from the file destination, judge first filename and the file type information whether Match, first filename is configured by the data management system is unified;
When first filename is matched with the file type information, obtains the corresponding data of the file type information and read Take strategy;
Target data is read from the file destination according to the reading data strategy, and data are carried out to the target data Verification;
When data check success, the target data is added in the corresponding tables of data of the file type information.
2. the method according to claim 1, wherein the mesh for receiving terminal and being uploaded by data management system Before mark file and file type information, comprising:
It receives the template that terminal is sent and downloads request, carry the first service identification and the first user mark in the template downloading request Know;
Search the corresponding file template of first service identification;
The second filename is generated according to first service identification and first user identifier;
File template is generated according to the file template and second filename, the file template is returned into terminal.
3. according to the method described in claim 2, it is characterized in that, described according to the file template and second filename Generate file template, comprising:
Search the corresponding industry number of first user identifier;
Search the corresponding limitation data class of the industry number;
The file template is handled according to the limitation data class, the file template and described according to treated Two filenames generate file template.
4. the method according to claim 1, wherein described be added to the file type for the target data In the corresponding tables of data of information, comprising:
The second service identification and second user mark are extracted from the file type information;
Search the corresponding business datum table of second service identification;
Obtain the uplink time of the file destination;
It is corresponding with the uplink time that the target data is added to the mark of second user described in the business datum table Position.
5. the method according to claim 1, wherein described literary from the target according to the reading data strategy Target data is read in part, and data check is carried out to the target data, comprising:
File data is obtained from the reading data strategy stores information;
Information is stored according to the file data, and the first file that data type is system type is searched from the target data Field, and read the first file field name and the first file word segment value of first file field;
Search the corresponding system data of the first file field name;
The first file word segment value is subjected to Data Matching with the system data one by one;
When all the first file word segment values with the system data successful match when, then data check success.
6. the method according to claim 1, wherein described literary from the target according to the reading data strategy Target data is read in part, and data check is carried out to the target data, comprising:
File data is obtained from the reading data strategy stores information;
Information is stored according to the file data, and the second file that data type is non-heavy type is searched from the target data Field, and read the second file word segment value of second file field;
Judge in the second file word segment value with the presence or absence of repetition numerical value;
When determining in the second file word segment value there is no numerical value is repeated, then data check success.
7. a kind of file destination processing unit, which is characterized in that described device includes:
Data reception module, the file destination and file type information uploaded for receiving terminal by data management system;
File matching module, for extracting the first filename from the file destination, judge first filename with it is described Whether file type information matches, and first filename is configured by the data management system is unified;
Rule acquisition module, for when determining that first filename is matched with the file type information, acquisition described the The corresponding reading data strategy of one service identification;
Data read module, for reading target data from the file destination according to the reading data strategy, and to institute It states target data and carries out data check;
Data adding module, for when data check success, the target data to be added to the file type information pair In the tables of data answered.
8. device according to claim 7, which is characterized in that described device further include:
Request receiving module carries the first industry in the template downloading request for receiving the template downloading request of terminal transmission Business mark and the first user identifier;
Template searching module, for searching the corresponding file template of first service identification;
Filename generation module, for generating the second filename according to first service identification and first user identifier;
Template generation module, for generating file template according to the file template and second filename, by the file Template returns to terminal.
9. a kind of computer equipment, including memory and processor, the memory are stored with computer program, feature exists In the step of processor realizes any one of claims 1 to 6 the method when executing the computer program.
10. a kind of computer readable storage medium, is stored thereon with computer program, which is characterized in that the computer program The step of method described in any one of claims 1 to 6 is realized when being executed by processor.
CN201910212526.9A 2019-03-20 2019-03-20 File processing method, device, computer equipment and storage medium Active CN110069449B (en)

Priority Applications (2)

Application Number Priority Date Filing Date Title
CN201910212526.9A CN110069449B (en) 2019-03-20 2019-03-20 File processing method, device, computer equipment and storage medium
PCT/CN2019/117942 WO2020186786A1 (en) 2019-03-20 2019-11-13 File processing method and apparatus, computer device and storage medium

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201910212526.9A CN110069449B (en) 2019-03-20 2019-03-20 File processing method, device, computer equipment and storage medium

Publications (2)

Publication Number Publication Date
CN110069449A true CN110069449A (en) 2019-07-30
CN110069449B CN110069449B (en) 2023-09-26

Family

ID=67366412

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201910212526.9A Active CN110069449B (en) 2019-03-20 2019-03-20 File processing method, device, computer equipment and storage medium

Country Status (2)

Country Link
CN (1) CN110069449B (en)
WO (1) WO2020186786A1 (en)

Cited By (19)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN110806979A (en) * 2019-10-31 2020-02-18 北京东软望海科技有限公司 Interface return value checking method, device, equipment and storage medium
CN111144334A (en) * 2019-12-27 2020-05-12 北京天融信网络安全技术有限公司 File matching method and device, electronic equipment and storage medium
CN111274350A (en) * 2020-02-03 2020-06-12 广州极尚网络技术有限公司 Data processing method, data processing device, computer equipment and storage medium
CN111291051A (en) * 2020-01-22 2020-06-16 中国民航信息网络股份有限公司 Freight rate data processing method and device, storage medium and electronic equipment
CN111654522A (en) * 2020-04-27 2020-09-11 平安证券股份有限公司 File synchronization method, file synchronization server and storage medium
CN111666259A (en) * 2020-06-06 2020-09-15 智同道合(苏州)信息技术服务有限公司 Document management method, management system, readable storage medium, and electronic device
WO2020186786A1 (en) * 2019-03-20 2020-09-24 平安科技(深圳)有限公司 File processing method and apparatus, computer device and storage medium
CN111782517A (en) * 2020-06-23 2020-10-16 浙江保融科技有限公司 Automatic file checking method
CN111935546A (en) * 2020-07-23 2020-11-13 深圳市鼎盛光电有限公司 Program importing method and device, video playing equipment and storage medium
CN111966636A (en) * 2020-08-20 2020-11-20 中国农业银行股份有限公司 Data file fusion method and device
CN112395266A (en) * 2019-08-19 2021-02-23 中移(苏州)软件技术有限公司 Data file processing method, first server and computer storage medium
CN112612505A (en) * 2020-12-04 2021-04-06 北京思特奇信息技术股份有限公司 Method and system for processing general files based on jdk process processing
CN112988868A (en) * 2021-03-17 2021-06-18 首钢京唐钢铁联合有限责任公司 Steel laboratory data processing method and system
CN113505580A (en) * 2021-07-26 2021-10-15 京东科技控股股份有限公司 Method and device for analyzing table file
CN113590554A (en) * 2021-08-10 2021-11-02 中国工商银行股份有限公司 File processing method and device, electronic equipment and storage medium
CN113672567A (en) * 2021-10-22 2021-11-19 北京凯睿数加科技有限公司 File construction method and device, electronic equipment and computer readable medium
CN114595199A (en) * 2022-05-10 2022-06-07 太平金融科技服务(上海)有限公司 File analysis method and device, computer equipment and storage medium
CN114896468A (en) * 2022-04-24 2022-08-12 北京月新时代科技股份有限公司 File type matching method and intelligent data entry method based on neural network
WO2022179121A1 (en) * 2021-02-24 2022-09-01 深圳壹账通智能科技有限公司 Automatic script generation method and apparatus, electronic device and storage medium

Families Citing this family (8)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN112509653A (en) * 2020-10-29 2021-03-16 望海康信(北京)科技股份公司 Medical record data processing method and system, corresponding equipment and storage medium
CN112463737A (en) * 2020-11-17 2021-03-09 中科金审(北京)科技有限公司 System and method for rapidly acquiring data aiming at multi-format data intelligent matching template
CN112950370A (en) * 2021-02-25 2021-06-11 未鲲(上海)科技服务有限公司 Service processing method, device, equipment and storage medium
CN113438290A (en) * 2021-06-22 2021-09-24 康键信息技术(深圳)有限公司 Method, device and equipment for detecting repeated request and storage medium
CN114449063B (en) * 2022-01-17 2024-03-26 蚂蚁区块链科技(上海)有限公司 Message processing method, device and equipment
CN114401147B (en) * 2022-01-20 2024-02-20 山西晟视汇智科技有限公司 New energy power station communication message comparison method and system based on abstract algorithm
CN116644035B (en) * 2023-07-21 2024-01-26 中邮消费金融有限公司 File batch warehousing method, device, equipment and storage medium
CN117376033A (en) * 2023-12-06 2024-01-09 浙江网商银行股份有限公司 File processing method and device

Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN106339438A (en) * 2016-08-22 2017-01-18 深圳鼎智通讯股份有限公司 Internal storage display method in file manager
CN107330096A (en) * 2017-07-05 2017-11-07 恒生电子股份有限公司 Document handling method and device, computer-readable recording medium and electronic equipment
CN107908396A (en) * 2017-10-17 2018-04-13 广东广业开元科技有限公司 A kind of chart data Online Processing System and method based on browser
CN108804336A (en) * 2018-06-15 2018-11-13 深圳壹账通智能科技有限公司 Interactive system test method, device, computer equipment and storage medium
CN109325030A (en) * 2018-09-03 2019-02-12 平安国际融资租赁有限公司 Message processing method, device, computer equipment and storage medium

Family Cites Families (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JPH08314784A (en) * 1995-05-19 1996-11-29 Toshiba Corp File management device
CN101231647B (en) * 2007-01-26 2011-02-02 鸿富锦精密工业(深圳)有限公司 File management system and method
CN110069449B (en) * 2019-03-20 2023-09-26 平安科技(深圳)有限公司 File processing method, device, computer equipment and storage medium

Patent Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN106339438A (en) * 2016-08-22 2017-01-18 深圳鼎智通讯股份有限公司 Internal storage display method in file manager
CN107330096A (en) * 2017-07-05 2017-11-07 恒生电子股份有限公司 Document handling method and device, computer-readable recording medium and electronic equipment
CN107908396A (en) * 2017-10-17 2018-04-13 广东广业开元科技有限公司 A kind of chart data Online Processing System and method based on browser
CN108804336A (en) * 2018-06-15 2018-11-13 深圳壹账通智能科技有限公司 Interactive system test method, device, computer equipment and storage medium
CN109325030A (en) * 2018-09-03 2019-02-12 平安国际融资租赁有限公司 Message processing method, device, computer equipment and storage medium

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
丁俊;郑辉;: "大数据时代下的动态可配置数据采集系统的研究与设计", 计算机应用与软件, no. 03 *

Cited By (28)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO2020186786A1 (en) * 2019-03-20 2020-09-24 平安科技(深圳)有限公司 File processing method and apparatus, computer device and storage medium
CN112395266B (en) * 2019-08-19 2022-12-13 中移(苏州)软件技术有限公司 Data file processing method, first server and computer storage medium
CN112395266A (en) * 2019-08-19 2021-02-23 中移(苏州)软件技术有限公司 Data file processing method, first server and computer storage medium
CN110806979A (en) * 2019-10-31 2020-02-18 北京东软望海科技有限公司 Interface return value checking method, device, equipment and storage medium
CN110806979B (en) * 2019-10-31 2023-04-07 望海康信(北京)科技股份公司 Interface return value checking method, device, equipment and storage medium
CN111144334A (en) * 2019-12-27 2020-05-12 北京天融信网络安全技术有限公司 File matching method and device, electronic equipment and storage medium
CN111144334B (en) * 2019-12-27 2023-09-26 北京天融信网络安全技术有限公司 File matching method and device, electronic equipment and storage medium
CN111291051A (en) * 2020-01-22 2020-06-16 中国民航信息网络股份有限公司 Freight rate data processing method and device, storage medium and electronic equipment
CN111274350B (en) * 2020-02-03 2023-06-23 广州极尚网络技术有限公司 Data processing method, device, computer equipment and storage medium
CN111274350A (en) * 2020-02-03 2020-06-12 广州极尚网络技术有限公司 Data processing method, data processing device, computer equipment and storage medium
CN111654522A (en) * 2020-04-27 2020-09-11 平安证券股份有限公司 File synchronization method, file synchronization server and storage medium
CN111654522B (en) * 2020-04-27 2023-02-03 平安证券股份有限公司 File synchronization method, file synchronization server and storage medium
CN111666259A (en) * 2020-06-06 2020-09-15 智同道合(苏州)信息技术服务有限公司 Document management method, management system, readable storage medium, and electronic device
CN111666259B (en) * 2020-06-06 2023-05-23 智同道合(苏州)信息技术服务有限公司 Document management method, management system, readable storage medium, and electronic device
CN111782517A (en) * 2020-06-23 2020-10-16 浙江保融科技有限公司 Automatic file checking method
CN111782517B (en) * 2020-06-23 2021-06-04 浙江保融科技股份有限公司 Automatic file checking method
CN111935546A (en) * 2020-07-23 2020-11-13 深圳市鼎盛光电有限公司 Program importing method and device, video playing equipment and storage medium
CN111966636A (en) * 2020-08-20 2020-11-20 中国农业银行股份有限公司 Data file fusion method and device
CN112612505B (en) * 2020-12-04 2024-01-30 北京思特奇信息技术股份有限公司 Universal file processing method and system based on jdk flow processing
CN112612505A (en) * 2020-12-04 2021-04-06 北京思特奇信息技术股份有限公司 Method and system for processing general files based on jdk process processing
WO2022179121A1 (en) * 2021-02-24 2022-09-01 深圳壹账通智能科技有限公司 Automatic script generation method and apparatus, electronic device and storage medium
CN112988868A (en) * 2021-03-17 2021-06-18 首钢京唐钢铁联合有限责任公司 Steel laboratory data processing method and system
CN113505580A (en) * 2021-07-26 2021-10-15 京东科技控股股份有限公司 Method and device for analyzing table file
CN113590554A (en) * 2021-08-10 2021-11-02 中国工商银行股份有限公司 File processing method and device, electronic equipment and storage medium
CN113672567A (en) * 2021-10-22 2021-11-19 北京凯睿数加科技有限公司 File construction method and device, electronic equipment and computer readable medium
CN114896468A (en) * 2022-04-24 2022-08-12 北京月新时代科技股份有限公司 File type matching method and intelligent data entry method based on neural network
CN114896468B (en) * 2022-04-24 2024-02-02 北京月新时代科技股份有限公司 File type matching method and data intelligent input method based on neural network
CN114595199A (en) * 2022-05-10 2022-06-07 太平金融科技服务(上海)有限公司 File analysis method and device, computer equipment and storage medium

Also Published As

Publication number Publication date
WO2020186786A1 (en) 2020-09-24
CN110069449B (en) 2023-09-26

Similar Documents

Publication Publication Date Title
CN110069449A (en) Document handling method, device, computer equipment and storage medium
CN108573371B (en) Data approval method, device, computer equipment and storage medium
CN101061475B (en) Maintaining time-date information for syncing low fidelity devices
CN108874926A (en) Mass data inquiry method, device, computer equipment and storage medium
CN109039870A (en) E-mail sending method, system, computer equipment and storage medium
CN111027295B (en) Data processing method, device, computer equipment and storage medium
CN101459503A (en) Method and device for implementing data synchronization
CN109558404A (en) Date storage method, device, computer equipment and storage medium
CN109144799A (en) Integrated testing method, apparatus, computer equipment and storage medium
CN109902272A (en) Electronic form data processing method, device, computer equipment and storage medium
CN111090788B (en) json file comparison method and device, storage medium and computer equipment
CN108334625A (en) Processing method, device, computer equipment and the storage medium of user information
CN108509424A (en) Institutional information processing method, device, computer equipment and storage medium
CN108874661A (en) Test mapping relations library generating method, device, computer equipment and storage medium
CN113220782A (en) Method, device, equipment and medium for generating multivariate test data source
CN110389985A (en) Verification of data method, apparatus, computer equipment and storage medium
CN112286934A (en) Database table importing method, device, equipment and medium
CN110471838A (en) Method of calibration, device, computer equipment and the storage medium of test case
CN108255699A (en) regression testing method and device
CN106445815A (en) Automated testing method and device
CN111083054B (en) Route configuration processing method and device, computer equipment and storage medium
CN110362478A (en) Application upgrade test method, device, computer equipment and storage medium
CN109359176A (en) Data extraction method, device, computer equipment and storage medium
CN112347142A (en) Data processing method and device
CN115756598A (en) Component detection method, system and device applied to low-code platform

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