CN107025214A - Data processing method and device - Google Patents
Data processing method and device Download PDFInfo
- Publication number
- CN107025214A CN107025214A CN201710284432.3A CN201710284432A CN107025214A CN 107025214 A CN107025214 A CN 107025214A CN 201710284432 A CN201710284432 A CN 201710284432A CN 107025214 A CN107025214 A CN 107025214A
- Authority
- CN
- China
- Prior art keywords
- data
- protocol
- electronic form
- attribute
- protocol contents
- 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
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/12—Use of codes for handling textual entities
- G06F40/151—Transformation
- G06F40/157—Transformation using dictionaries or tables
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L69/00—Network arrangements, protocols or services independent of the application payload and not provided for in the other groups of this subclass
- H04L69/26—Special purpose or proprietary protocols or architectures
Abstract
The invention discloses a kind of data processing method and device, it is related to field of computer technology, method therein includes：Protocol data is converted into the first electronic form file data, according to screening rule the first electronic form file data are arranged and are determined with the first data attribute for needing to delete, the protocol contents data with the first data attribute are deleted from the first electronic form file data, the second electronic form file data are obtained；The second data attribute retained and the mapping relations of the protocol contents data with the second data attribute are set up based on the second electronic form file data, are correspondingly handled according to mapping relations.The data processing method and device of the present invention, reduce the intractability of protocol data, reduce size of code, save the code development time, software development efficiency is improved, the speed of service of system is improved and reduces the occupancy of system resource, the code maintenance task in later stage can be reduced.
Description
Technical field
The present invention relates to field of computer technology, more particularly to a kind of data processing method and device.
Background technology
At present, the agreement used in computer systems does not only have procotol, also including for specific system and biography
Defeated demand and Data Transport Protocol for arranging etc..Procotol is one group of agreement that communication computer both sides must defer to jointly,
Such as how to set up connection, how to recognize mutually.The Data Transport Protocol of agreement is according to the data transfer between system
It is required that etc. the transmission data of agreement form and content, the data of transmission include：Project information data, monitoring information data,
Control data etc..For example, needing to transmit manufacturing schedule data between management system and production system, agreement manufacturing schedule data are passed
Defeated agreement, it is determined that the form and content of the manufacturing schedule data of transmission.Production system is generated based on manufacturing schedule data protocol
Manufacturing schedule is reported and is sent to management system, and management system is based on the parsing manufacturing schedule report of manufacturing schedule Data Transport Protocol
And obtain progress msg.At present, developer's processing data host-host protocol is all based on code and handled, still, actual to need
The protocol contents data wanted are less, and the content-data of redundancy is more in the protocol data generated based on Data Transport Protocol, makes
The calculating speed for obtaining processing protocol data is slow, also, when system upgrade, transformation, the data transfer association originally arranged
The specific format and content of view also changes therewith, because the processing to protocol data is all handled in code, code revision
Amount is larger, protocol data not easy care.
The content of the invention
In view of this, the invention solves the problems that a technical problem be to provide a kind of data processing method and device, will assist
View data be converted to electronic form document data arranged, Screening Treatment, and set up data attribute and protocol contents number
According to mapping relations.
According to an aspect of the present invention there is provided a kind of data processing method, including：Protocol data is converted into the first electricity
Sub-table file data, wherein, the first electronic form file packet contains data attribute information and protocol contents data；
According to screening rule the first electronic form file data are arranged and are determined with the first data attribute for needing to delete, from
The protocol contents data with the first data attribute are deleted in the first electronic form file data, the second electrical form is obtained
File data；The second data attribute retained is set up based on the second electronic form file data with having the second data attribute
Protocol contents data mapping relations, correspondingly handled according to the mapping relations.
Alternatively, it is described set up based on the second electronic form file data the second data attribute for retaining with the
The mapping relations of the protocol contents data of two data attributes include：Text is generated, by the second electronic form file number
According to form be converted to form and the storage of the text, wherein, the second data attribute is included in the text
Information, the protocol contents data with the second data attribute；The text is read, second data attribute is obtained
Information and described there are the protocol contents data of the second data attribute and the mapping relations are set up.
Alternatively, it is described to set up the mapping relations and include：According to second data attribute information and described have
The protocol contents data generation protocol data dictionary of two data attributes；Wherein, the key in the protocol data dictionary is described the
The corresponding key assignments of key in two data attribute informations, the protocol data dictionary is in the agreement with the second data attribute
Hold data.
Alternatively, in the text, the protocol contents data arrangement with the data attribute of identical second is same
One row, also, be arranged in the protocol contents data of same a line and belong to same protocol data；The generation protocol data dictionary is also
Including：The protocol contents data arranged in the text in the same row are obtained, the protocol data dictionary is set up.
Alternatively, multirow protocol contents data are included in the text；Set up respectively with multirow protocol contents number
According to corresponding multiple protocol data dictionaries；Array is set up, the multiple protocol data dictionary is stored in the array.
Alternatively, the protocol contents matched with second data attribute information are obtained from the protocol data dictionary
Data；Determine in the protocol data with the presence or absence of the protocol contents data matched, judged based on the determination result
Whether the protocol data dictionary of generation is correct.
It is alternatively, described that according to mapping relations progress, correspondingly processing includes：In response to call instruction, from the association
The protocol contents data matched with the recalls information in the call instruction are obtained in view data dictionary and are shown, are used to
According to the protocol contents data generation code or file matched.
Alternatively, the first electronic form file data and the second electronic form file data include：Excel numbers
According to；The text includes：Csv files.
Alternatively, it is described protocol data is converted into the first electronic form file data to include：Determine the protocol data
Protocol type, obtain corresponding with protocol type electronic form template；Carried according to corresponding with the protocol type
Rule is taken to extract data attribute information and protocol contents data from the protocol data and be filled into the electronic form template
In, obtain the first electronic form file data.
Alternatively, it is described that the first electronic form file data progress arrangement is included according to screening rule：Traversal institute
The first electronic form file data are stated, extensive processing is carried out to the protocol contents data；The protocol contents data are arranged, with
Make the protocol contents data arrangement with identical data attribute in same row.
According to another aspect of the present invention there is provided a kind of data processing equipment, including：Data acquisition module, for that will assist
View data are converted to the first electronic form file data, wherein, the first electronic form file packet contains data attribute
Information and protocol contents data；Data screening module, for being entered according to screening rule to the first electronic form file data
Row arranges and determined the first data attribute for needing to delete, and being deleted from the first electronic form file data has the first number
According to the protocol contents data of attribute, the second electronic form file data are obtained；Data mapping module, for based on the described second electricity
The mapping that sub-table file data sets up the second data attribute and protocol contents data with the second data attribute retained is closed
System, is correspondingly handled according to the mapping relations.
Alternatively, the data mapping module, including：Date Conversion Unit, for generating text, by described second
The form of electronic form file data is converted to the form of the text and storage, wherein, included in the text
There are the second data attribute information, the protocol contents data with the second data attribute；Generation unit is mapped, for reading
State text, obtain second data attribute information and described there are the protocol contents data of the second data attribute and set up
The mapping relations.
Alternatively, the mapping generation unit, is additionally operable to according to second data attribute information and described has second
The protocol contents data generation protocol data dictionary of data attribute；Wherein, the key in the protocol data dictionary is described second
The corresponding key assignments of key in data attribute information, the protocol data dictionary is the protocol contents with the second data attribute
Data.
Alternatively, in the text, the protocol contents data arrangement with the data attribute of identical second is same
One row, also, be arranged in the protocol contents data of same a line and belong to same protocol data；The mapping generation unit, is also used
Protocol contents data in the same row are arranged in the acquisition text, the protocol data dictionary is set up.
Alternatively, multirow protocol contents data are included in the text；The mapping generation unit, is additionally operable to build
Found multiple protocol data dictionaries corresponding with multirow protocol contents data respectively；Array is set up, by the multiple protocol data
Dictionary is stored in the array.
Alternatively, data checking module, believes for being obtained from the protocol data dictionary with second data attribute
The protocol contents data of manner of breathing matching；Determine in the protocol data with the presence or absence of the protocol contents data matched, base
Judge whether the protocol data dictionary of generation is correct in the determination result.
Alternatively, the data mapping module, including：Processing unit is called, in response to call instruction, from the association
The protocol contents data matched with the recalls information in the call instruction are obtained in view data dictionary and are shown, are used to
According to the protocol contents data generation code or file matched.
Alternatively, the first electronic form file data and the second electronic form file data include：EXCEL numbers
According to；The text includes：Csv files.
Alternatively, the data acquisition module, is additionally operable to determine the protocol type of the protocol data, obtains and the association
Discuss the corresponding electronic form template of type；Carried according to the extracting rule corresponding with the protocol type from the protocol data
Take data attribute information and protocol contents data and be filled into the electronic form template, obtain the first electrical form text
Number of packages evidence.
Alternatively, the data screening module, is additionally operable to traversal the first electronic form file data, to the agreement
Content-data carries out extensive processing；The protocol contents data are arranged, so that the protocol contents data with identical data attribute
It is arranged in same row..
The data processing method and device of the present invention, are converted to the progress of electronic form document data whole by protocol data
Reason, Screening Treatment, and the mapping relations of data attribute and protocol contents data are set up, agreement number can be obtained based on mapping relations
According to, reduce the intractability of protocol data, reduce size of code, save the code development time, improve software development effect
Rate, improves the speed of service of system and reduces the occupancy of system resource, can reduce the code maintenance task in later stage.
Brief description of the drawings
In order to illustrate more clearly about the embodiment of the present invention or technical scheme of the prior art, below will be to embodiment or existing
There is the accompanying drawing used required in technology description to be briefly described, it should be apparent that, drawings in the following description are only
Some embodiments of the present invention, for those of ordinary skill in the art, without having to pay creative labor, also
Other accompanying drawings can be obtained according to these accompanying drawings.
Fig. 1 is the schematic flow sheet of one embodiment of the data processing method according to the present invention；
Fig. 2 is the schematic flow sheet of another embodiment of the data processing method according to the present invention；
Fig. 3 is the module diagram of one embodiment of the data processing equipment according to the present invention；
Fig. 4 is the module diagram of data mapping module in one embodiment according to the data processing equipment of the present invention.
Embodiment
The present invention is described more fully with reference to the accompanying drawings, wherein illustrating the exemplary embodiment of the present invention.Under
The accompanying drawing that face will be combined in the embodiment of the present invention, the technical scheme in the embodiment of the present invention is clearly and completely described, and shows
So, described embodiment is only a part of embodiment of the invention, rather than whole embodiments.Based on the reality in the present invention
Example is applied, the every other embodiment that those of ordinary skill in the art are obtained under the premise of creative work is not made all belongs to
In the scope of protection of the invention.Many descriptions are carried out to technical scheme with reference to each figure and embodiment.
" first ", " second " hereinafter etc. is only used for distinguishing in description, not other special implications.
Fig. 1 is the schematic flow sheet of one embodiment of the data processing method according to the present invention, as shown in Figure 1：
Step 101, protocol data is converted into the first electronic form file data, the first electronic form file packet contains
There are data attribute information and protocol contents data.
Protocol data includes the Internet protocol data, and such as RS485 protocol datas, protocol data can also be included in exploit person
The Data Transport Protocol data of agreement between member, between system etc., including：Project data transmission protocol data, supervision and reporting association
Discuss data, control protocol data etc..
Step 102, for the first electronic form file data being arranged according to screening rule and determining to need to delete
One data attribute, deletes the protocol contents data with the first data attribute from the first electronic form file data, obtains the
Two electronic form file data.Screening rule can be configured according to specific protocol type and demand, can be removed and be not required to
The protocol contents data wanted.
Step 103, the second data attribute retained is set up based on the second electronic form file data with having the second data
The mapping relations of the protocol contents data of attribute, are correspondingly handled according to mapping relations.Can there are a variety of processing methods, example
Such as, the protocol contents data after the processing such as screening, arrangement can be obtained based on mapping relations in code development, generation is generated
Code or file etc..
The data processing method of above-described embodiment, spreadsheet is converted to by protocol data, and list data is carried out
The processing such as screening, arrangement, set up the data attribute retained with having the mapping relations of the protocol contents data of this data attribute, and
Handled based on mapping relations, editable size of code can be reduced, save the development time, and reduce the work of later maintenance
Measure.
Fig. 2 is the schematic flow sheet of another embodiment of the data processing method according to the present invention, as shown in Figure 2：
Step 201, the first spread-sheet data is obtained, the first spread-sheet data is arranged, screened etc. and handle, is obtained
To the second electronic form file data.
Protocol data has corresponding data format, determines the protocol type of protocol data, obtains corresponding with protocol type
Electronic form template.Data attribute information and agreement are extracted from protocol data according to the extracting rule corresponding with protocol type
Content-data is simultaneously filled into electronic form template, obtains the first electronic form file data.First electronic form file can be with
For Excel forms etc..
For example, being needed to have worked out project data host-host protocol, project data transmission according to the transmission of project or project data
The protocol data of agreement has fixed form, including version number, coded format.The fields such as bullets, item description.Receive
To project data transmission protocol data, there can be many bar protocol datas, every protocol data may all contain Item version, item
Mesh coded format, bullets etc..According to the extracting rule corresponding with the protocol type of project data host-host protocol, from agreement
Extracting data data attribute information and protocol contents data are simultaneously filled into electronic form template.List data is obtained mainly to use
In extracting useful data, the form of the first electronic form file data of generation is as shown in following table one：
Table 1- the first electronic form file data format tables
Project data transmission protocol data is more, and the data attribute information of the first electronic form file data includes：Project
File etc. needed for id, Item version, bullets, item description.First electronic form file data are carried out to simplify processing, root
According to screening rule the first electronic form file data are arranged and are determined with the first data attribute for needing to delete.
For example, protocol contents data are carried out extensive processing by the first electronic form file data of traversal.Arrange protocol contents
Data, so that the protocol contents data arrangement with identical data attribute is in same row.For property described in protocol contents data
The redundant data of word needs to arrange, and deletes the description etc. in bracket.It is extensive refer to replace with some similar words it is same
Represent, for example, will not have, and not have temporarily, replacing with nothing without, protocol contents data such as reserved.Deletion is descriptive and without decision
Property meaning data attribute " file needed for item description ", from the first electronic form file data delete have " item description
The protocol contents data of required file " data attribute, Delete Entire Column Final finishing is the second succinct electronic form file data, the
The form of two electronic form file data forms is as shown in following table two：
| Project id | Item version | Coded format | Bullets |
| 1 | Nothing | UTF-8 | Nothing |
| 2 | 1 | Nothing | Nothing |
| 3 | 2 | Nothing | 100001 |
| 4 | 3 | UTF-8 | 100002 |
| 5 | Nothing | UTF-8 | 100007 |
The form table of table 2- the second electronic form file data
Step 202, text is generated, the form of the second electronic form file data is converted to the form of text
And be stored in text.Include the second data attribute information in text, in the agreement with the second data attribute
Hold data.The second more succinct electronic form file data after being arranged, based on the generation of the second electronic form file data
Program is easy to the text form of identification, and the form difference of each program requirement is, it is necessary to set the lattice of corresponding this paper files
Formula.The form of text can include：Txt, csv etc..
For example, the second electronic form file data are Excel data, Excel data generators are easy to the csv of identification
File, csv files are saved as by Excel file, and csv file each columns are opened with CSV, and suitable programming is called.By the second electronics
The csv forms that the Excel forms of form document data are converted to text are as follows：
Project id, Item version, coded format, bullets
1, nothing, UTF-8, nothing
2,1, nothing, nothing
3,2, nothing, 100001
4,3,UTF-8,100002
5, nothing, UTF-8,100007
Step 203, text is read, the second data attribute information and the protocol contents with the second data attribute are obtained
Data.The mapping of the second data attribute information and protocol contents data with the second data attribute is processed into based on text
Relation, can obtain the recognizable code of development environment based on mapping relations.Large batch of protocol data is converted to succinctly
Code data, pass through external file carry out protocol data screening, arrange, it is possible to reduce the maintenance work of size of code and code
Measure, mapping relations can be called by other software functions.Mapping relations can be implemented as dictionary etc..
Step 204, according to the second data attribute information and the protocol contents data with the second data attribute generation agreement
Data dictionary.
Dictionary stores data using Key-Value form.Object storage in dictionary carrys out table without order using key
Show each object.Dictionary can have a variety of building modes.For example, the key (key) in protocol data dictionary is the second data attribute
Key in information, protocol data dictionary is project id, Item version, coded format, bullets etc., in protocol data dictionary
The corresponding key assignments of key (Value) is in the agreement with data attributes such as project id, Item version, coded format, bullets
Hold data.
In text, the protocol contents data arrangement with the data attribute of identical second is arranged in same row
Protocol contents data with a line belong to same protocol data.Obtain the protocol contents arranged in text in the same row
Data, set up protocol data dictionary.Text is read, the number of lines and columns evidence in text is obtained, data attribute is used as word
The key assignments of allusion quotation, generates the protocol data dictionary of every record.Because there is a plurality of record, then it is added into array, dictionary sum
Group is the recognizable code of development environment.For example, corresponding to the csv files of the second electronic form file data conversion, csv texts
Include 5 row protocol contents data in part, set up 5 corresponding with 5 row protocol contents data respectively protocol data dictionaries, and
Array is set up, 5 protocol data dictionaries are stored in array.
After protocol data dictionary is generated, the association matched with the second data attribute information is obtained from protocol data dictionary
Discuss content-data.It is determined that with the presence or absence of in the agreement matched with the second data attribute information obtained in initial protocol data
Hold data, if it does, judging that the protocol data dictionary of generation is correct, if it does not exist, then judging the protocol data word of generation
Allusion quotation is incorrect.The data in obtained protocol data dictionary can be made into sampling contrast with initial list data to handle, with true
Protect the correctness and integrality of data.
It is available for other modules or developer to call after protocol data dictionary creation, there are a variety of processing methods.For example,
In development environment, developer's invocation protocol data dictionary, protocol data dictionary is in response to call instruction, from protocol data word
The protocol contents data matched with the recalls information in call instruction are obtained in allusion quotation and are shown.Developer is from agreement number
Obtained according in dictionary after protocol contents data, by all or part of write-in code of protocol contents data, generate exploitation code,
Or, developer is obtained after protocol contents data from protocol data dictionary, and all or part of protocol contents data is write
Enter in the files such as webpage.
The data processing method that above-described embodiment is provided, electronic form document data are converted to by protocol data, will
Arranged, screen after the succinct protocol data that obtains be converted to text, setting up data by reading text belongs to
Property with the mapping relations of protocol contents data, above-mentioned function is realized by program, agreement number can be obtained based on mapping relations
According to and handled, reduce the intractability of protocol data, reduce correlation size of code, improve software development efficiency,
Improve the speed of service of computer system and reduce occupancy to resource for computer system, the code dimension in later stage can be reduced
Nurse makees.
In one embodiment, as shown in figure 4, the present invention provides a kind of data processing equipment 30, including：Data acquisition mould
Block 31, data screening module 32, data mapping module 33 and data checking module 34.Data acquisition module 31 turns protocol data
The first electronic form file data are changed to, the first electronic form file packet contains data attribute information and protocol contents number
According to.
Data screening module 32 is arranged to the first electronic form file data according to screening rule and determines that needs are deleted
The first data attribute removed, deletes the protocol contents data with the first data attribute from the first electronic form file data,
Obtain the second electronic form file data.Data mapping module 33 sets up second retained based on the second electronic form file data
Data attribute and the mapping relations of the protocol contents data with the second data attribute, are accordingly located according to mapping relations
Reason.
Data acquisition module 31 determines the protocol type of protocol data, obtains electrical form mould corresponding with protocol type
Plate, data attribute information and protocol contents data are extracted simultaneously according to the extracting rule corresponding with protocol type from protocol data
It is filled into electronic form template, obtains the first electronic form file data.Data screening module 32 travels through the first electrical form
Protocol contents data are carried out extensive processing by file data, protocol contents data are arranged, so that the association with identical data attribute
View content-data is arranged in same row.
As shown in figure 4, data mapping module 33 includes：Date Conversion Unit 331, mapping generation unit 332 and call place
Manage unit 333.Date Conversion Unit 331 generates text, and the form of the second electronic form file data is converted into text
The form of file is simultaneously stored in text, the second data attribute information is included in text, with the second data category
The protocol contents data of property.Map generation unit 332 and read text, obtain the second data attribute information and with the second number
According to attribute protocol contents data and set up mapping relations.
Generation unit 332 is mapped to be given birth to the protocol contents data with the second data attribute according to the second data attribute information
Into protocol data dictionary, the key in protocol data dictionary is that the key in the second data attribute information, protocol data dictionary is corresponding
Key assignments is the protocol contents data with the second data attribute.In text, the association with the data attribute of identical second
Discuss content-data and be arranged in same row, also, be arranged in the protocol contents data of same a line and belong to same protocol data.Mapping
Generation unit 332 obtains the protocol contents data arranged in text in the same row, sets up protocol data dictionary.
Include multirow protocol contents data in text.Mapping generation unit 332 set up respectively with multirow agreement
Hold the corresponding multiple protocol data dictionaries of data, set up array, multiple protocol data dictionaries are stored in array.Call processing
Unit 333 obtains the agreement matched with the recalls information in call instruction in response to call instruction from protocol data dictionary
Content-data is simultaneously shown, to according to the protocol contents data generation code or file matched.
Data checking module 34 obtains the protocol contents matched with the second data attribute information from protocol data dictionary
Data, are determined with the presence or absence of the protocol contents data matched in protocol data, based on the agreement number for determining result judgement generation
It is whether correct according to dictionary.First electronic form file data and the second electronic form file data include：Excel data etc.；Text
This document includes：Csv files etc..
The data processing method and device that above-described embodiment is provided, electronic form document number is converted to by protocol data
According to the succinct protocol data obtained after being arranged, screened is converted to text, and number is set up by reading text
According to attribute and the mapping relations of protocol contents data, protocol data can be obtained based on mapping relations and handled, association is reduced
The intractability of data is discussed, the size of code of correlation is reduced, saves the code development time, improve software development efficiency, carry
The high speed of service of computer system and the occupancy for reducing resource for computer system, are reduced because the code of protocol modification is repaiied
Change quantity, the code maintenance task in later stage can be reduced, it is easy to safeguard.
The method and system of the present invention may be achieved in many ways.For example, can by software, hardware, firmware or
Software, hardware, firmware any combinations come realize the present invention method and system.The said sequence of the step of for method is only
Order described in detail above is not limited in order to illustrate, the step of method of the invention, is especially said unless otherwise
It is bright.In addition, in certain embodiments, the present invention can be also embodied as recording to program in the recording medium, these programs include
Machine readable instructions for realizing the method according to the invention.Thus, the present invention also covering storage is used to perform according to this hair
The recording medium of the program of bright method.
Description of the invention is provided for the sake of example and description, and is not exhaustively or by the present invention
It is limited to disclosed form.Many modifications and variations are obvious for the ordinary skill in the art.Select and retouch
State embodiment and be more preferably to illustrate the principle and practical application of the present invention, and one of ordinary skill in the art is managed
The solution present invention is so as to design the various embodiments with various modifications suitable for special-purpose.
Claims (20)
1. a kind of data processing method, it is characterised in that including：
Protocol data is converted into the first electronic form file data, wherein, the first electronic form file packet contains
Data attribute information and protocol contents data；
According to screening rule the first electronic form file data are arranged and are determined with the first data category for needing to delete
Property, the protocol contents data with the first data attribute are deleted from the first electronic form file data, the second electricity is obtained
Sub-table file data；
The second data attribute retained and the association with the second data attribute are set up based on the second electronic form file data
The mapping relations of content-data are discussed, are correspondingly handled according to the mapping relations.
2. the method as described in claim 1, it is characterised in that described set up based on the second electronic form file data is protected
The second data attribute stayed and the mapping relations of the protocol contents data with the second data attribute include：
Text is generated, the form of the second electronic form file data is converted into the form of the text and deposited
Storage, wherein, the second data attribute information, the protocol contents number with the second data attribute are included in the text
According to；
Read the text, obtain second data attribute information and the protocol contents with the second data attribute
Data simultaneously set up the mapping relations.
3. method as claimed in claim 2, it is characterised in that described to set up the mapping relations and include：
Protocol data is generated according to second data attribute information and the protocol contents data with the second data attribute
Dictionary；
Wherein, the key in the protocol data dictionary is the key in second data attribute information, the protocol data dictionary
Corresponding key assignments is the protocol contents data with the second data attribute.
4. method as claimed in claim 3, it is characterised in that in the text, with the data of identical second category
The protocol contents data arrangement of property is arranged in the protocol contents data of same a line and belongs to same agreement number in same row
According to；
The generation protocol data dictionary also includes：
The protocol contents data arranged in the text in the same row are obtained, the protocol data dictionary is set up.
5. method as claimed in claim 4, it is characterised in that include multirow protocol contents data in the text；
Set up multiple protocol data dictionaries corresponding with multirow protocol contents data respectively；
Array is set up, the multiple protocol data dictionary is stored in the array.
6. method as claimed in claim 3, it is characterised in that also include：
The protocol contents data matched with second data attribute information are obtained from the protocol data dictionary；
Determine in the protocol data with the presence or absence of the protocol contents data matched, generation is judged based on determination result
Whether the protocol data dictionary is correct.
7. method as claimed in claim 3, it is characterised in that described to carry out correspondingly processing bag according to the mapping relations
Include：
In response to call instruction, obtain what is matched with the recalls information in the call instruction from the protocol data dictionary
Protocol contents data are simultaneously shown, to the protocol contents data generation code or file matched according to.
8. method as claimed in claim 2, it is characterised in that
The first electronic form file data and the second electronic form file data include：Excel data；The text
File includes：Csv files.
9. the method as described in claim 1, it is characterised in that described that protocol data is converted into the first electronic form file number
According to including：
The protocol type of the protocol data is determined, electronic form template corresponding with the protocol type is obtained；
Data attribute information and agreement are extracted from the protocol data according to the extracting rule corresponding with the protocol type
Content-data is simultaneously filled into the electronic form template, obtains the first electronic form file data.
10. the method as described in claim 1, it is characterised in that described literary to first electrical form according to screening rule
Number of packages includes according to arrangement is carried out：
The first electronic form file data are traveled through, extensive processing is carried out to the protocol contents data；
The protocol contents data are arranged, so that the protocol contents data arrangement with identical data attribute is in same row.
11. a kind of data processing equipment, it is characterised in that including：
Data acquisition module, for protocol data to be converted into the first electronic form file data, wherein, first electronic watch
Lattice file packet contains data attribute information and protocol contents data；
Data screening module, for being arranged according to screening rule to the first electronic form file data and determining needs
The first data attribute deleted, deletes the protocol contents with the first data attribute from the first electronic form file data
Data, obtain the second electronic form file data；
Data mapping module, for setting up the second data attribute retained with having based on the second electronic form file data
The mapping relations of the protocol contents data of second data attribute, are correspondingly handled according to the mapping relations.
12. device as claimed in claim 11, it is characterised in that
The data mapping module, including：
Date Conversion Unit, for generating text, the form of the second electronic form file data is converted to described
The form of text and storage, wherein, the second data attribute information is included in the text, described there is the second number
According to the protocol contents data of attribute；
Generation unit is mapped, for reading the text, second data attribute information is obtained and described has second
The protocol contents data of data attribute simultaneously set up the mapping relations.
13. device as claimed in claim 12, it is characterised in that
The mapping generation unit, is additionally operable to according to second data attribute information and the association with the second data attribute
Discuss content-data generation protocol data dictionary；Wherein, the key in the protocol data dictionary is second data attribute information,
The corresponding key assignments of key in the protocol data dictionary is the protocol contents data with the second data attribute.
14. device as claimed in claim 13, it is characterised in that in the text, with the data of identical second
The protocol contents data arrangement of attribute is arranged in the protocol contents data of same a line and belongs to same agreement in same row
Data；
The mapping generation unit, is additionally operable to obtain the protocol contents data arranged in the text in the same row, builds
Found the protocol data dictionary.
15. device as claimed in claim 14, it is characterised in that include multirow protocol contents number in the text
According to；
The mapping generation unit, is additionally operable to set up multiple protocol data words corresponding with multirow protocol contents data respectively
Allusion quotation；Array is set up, the multiple protocol data dictionary is stored in the array.
16. device as claimed in claim 13, it is characterised in that also include：
Data checking module, for obtaining the association matched with second data attribute information from the protocol data dictionary
Discuss content-data；Determine in the protocol data with the presence or absence of the protocol contents data matched, sentenced based on determination result
Medium well into the protocol data dictionary it is whether correct.
17. device as claimed in claim 13, it is characterised in that
The data mapping module, including：
Call processing unit, in response to call instruction, obtained from the protocol data dictionary with the call instruction
The protocol contents data that match of recalls information and shown, to be generated according to the protocol contents data matched
Code or file.
18. device as claimed in claim 12, it is characterised in that
The first electronic form file data and the second electronic form file data include：Excel data；The text
File includes：Csv files.
19. device as claimed in claim 11, it is characterised in that
The data acquisition module, is additionally operable to determine the protocol type of the protocol data, obtains corresponding with the protocol type
Electronic form template；According to the extracting rule corresponding with the protocol type data attribute is extracted from the protocol data
Information and protocol contents data are simultaneously filled into the electronic form template, obtain the first electronic form file data.
20. device as claimed in claim 11, it is characterised in that
The data screening module, is additionally operable to traversal the first electronic form file data, the protocol contents data is entered
The extensive processing of row；The protocol contents data are arranged, so that the protocol contents data arrangement with identical data attribute is same
Row.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710284432.3A CN107025214B (en) | 2017-04-27 | 2017-04-27 | Data processing method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710284432.3A CN107025214B (en) | 2017-04-27 | 2017-04-27 | Data processing method and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN107025214A true CN107025214A (en) | 2017-08-08 |
| CN107025214B CN107025214B (en) | 2019-08-30 |
Family
ID=59527268
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710284432.3A Active CN107025214B (en) | 2017-04-27 | 2017-04-27 | Data processing method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107025214B (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108959210A (en) * | 2018-07-09 | 2018-12-07 | 网易（杭州）网络有限公司 | A kind of method and device of file conversion |
| CN111507075A (en) * | 2019-01-31 | 2020-08-07 | 贵州白山云科技股份有限公司 | Method and device for data format conversion |
| CN111898345A (en) * | 2020-07-24 | 2020-11-06 | 北京车和家信息技术有限公司 | Data processing method and device based on detailed design document |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20060101333A1 (en) * | 2003-02-28 | 2006-05-11 | Microsoft Corporation | Importing and exporting markup language data in a spreadsheet application document |
| CN101794280A (en) * | 2010-03-11 | 2010-08-04 | 北京中科辅龙计算机技术股份有限公司 | Form automatic generation method and system based on form template set |
| CN102270194A (en) * | 2010-12-31 | 2011-12-07 | 北京谊安医疗系统股份有限公司 | Character processing method and device |
| CN102541867A (en) * | 2010-12-15 | 2012-07-04 | 金蝶软件（中国）有限公司 | Data dictionary generating method and system |
| CN105824790A (en) * | 2016-03-15 | 2016-08-03 | 上海缔安科技股份有限公司 | Equipment table adapting method, computer equipment and mobile terminal |
-
2017
- 2017-04-27 CN CN201710284432.3A patent/CN107025214B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20060101333A1 (en) * | 2003-02-28 | 2006-05-11 | Microsoft Corporation | Importing and exporting markup language data in a spreadsheet application document |
| CN101794280A (en) * | 2010-03-11 | 2010-08-04 | 北京中科辅龙计算机技术股份有限公司 | Form automatic generation method and system based on form template set |
| CN102541867A (en) * | 2010-12-15 | 2012-07-04 | 金蝶软件（中国）有限公司 | Data dictionary generating method and system |
| CN102270194A (en) * | 2010-12-31 | 2011-12-07 | 北京谊安医疗系统股份有限公司 | Character processing method and device |
| CN105824790A (en) * | 2016-03-15 | 2016-08-03 | 上海缔安科技股份有限公司 | Equipment table adapting method, computer equipment and mobile terminal |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108959210A (en) * | 2018-07-09 | 2018-12-07 | 网易（杭州）网络有限公司 | A kind of method and device of file conversion |
| CN111507075A (en) * | 2019-01-31 | 2020-08-07 | 贵州白山云科技股份有限公司 | Method and device for data format conversion |
| CN111898345A (en) * | 2020-07-24 | 2020-11-06 | 北京车和家信息技术有限公司 | Data processing method and device based on detailed design document |
Also Published As
| Publication number | Publication date |
|---|---|
| CN107025214B (en) | 2019-08-30 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106155686A (en) | Interface creating method, device and system | |
| CN103544074A (en) | Method and device for verifying service | |
| CN108985066A (en) | Intelligent contract security vulnerability detection method, device, terminal and storage medium | |
| CN101295332A (en) | DICOM file patient information anonymization processing method | |
| CN109408043A (en) | A kind of program creating method and device | |
| CN107025214A (en) | Data processing method and device | |
| CN106776964A (en) | A kind of WEB page management system and its implementation based on HC CELL | |
| CN112115145A (en) | Data acquisition method and device, electronic equipment and storage medium | |
| CN104991785A (en) | Standardized clinical data service support system and method | |
| CN101763348A (en) | Dynamic table type data acquisition system and method | |
| CN106384280A (en) | Artificial intelligent accounting system and computing method thereof | |
| CN110378569A (en) | Industrial relations chain building method, apparatus, equipment and storage medium | |
| CN106407288A (en) | Method and system for synchronously updating information | |
| CN113434542A (en) | Data relation identification method and device, electronic equipment and storage medium | |
| CN113505273A (en) | Data sorting method, device, equipment and medium based on repeated data screening | |
| CN112541688A (en) | Service data checking method and device, electronic equipment and computer storage medium | |
| US20230307103A1 (en) | Platform for collobarative analysis of electronic records | |
| CN116453125A (en) | Data input method, device, equipment and storage medium based on artificial intelligence | |
| CN106649314A (en) | Data query method and device | |
| CN113283231B (en) | Method for acquiring signature bit, setting system, signature system and storage medium | |
| CN102486731A (en) | Method, device and system for enhancing visualization of software call stack of software | |
| CN115496166A (en) | Multitasking method and device, electronic equipment and storage medium | |
| CN114780602A (en) | Data tracing analysis method and device, computer equipment and storage medium | |
| CN113626605A (en) | Information classification method and device, electronic equipment and readable storage medium | |
| CN102025738B (en) | Method, equipment and system for processing transaction message |
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 |