CN107870979A - Electronic installation, extract tables of data data method and storage medium - Google Patents
Electronic installation, extract tables of data data method and storage medium Download PDFInfo
- Publication number
- CN107870979A CN107870979A CN201710914884.5A CN201710914884A CN107870979A CN 107870979 A CN107870979 A CN 107870979A CN 201710914884 A CN201710914884 A CN 201710914884A CN 107870979 A CN107870979 A CN 107870979A
- Authority
- CN
- China
- Prior art keywords
- data
- extracted
- field
- type
- tables
- 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.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/258—Data format conversion from or to a database
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
Abstract
The present invention relates to a kind of electronic installation, the method and storage medium of the data for extracting tables of data, this method includes：Type of service corresponding to each Excel tables of data is pre-defined, for each type of service, the field to be extracted associated with this kind of type of service is configured, stores incidence relation of this kind of type of service with corresponding field to be extracted；When Excel tables of data is imported in FAS practice operating systems, filename based on the Excel tables of data identifies type of service corresponding to the Excel tables of data, according to the incidence relation of the type of service of storage and field to be extracted, the field to be extracted that type of service corresponding to the Excel tables of data associates is determined；Data object in the Excel tables of data is extracted based on identified field to be extracted；Identified field to be extracted and the data object extracted are shown, confirmed for user.The present invention can parse and extract automatically the data of the Excel tables of data imported in FAS practice operating systems, time saving and energy saving, be advantageous to the maintenance in later stage.
Description
Technical field
The present invention relates to database technical field, more particularly to a kind of method of the data of electronic installation, extraction tables of data
And storage medium.
Background technology
At present, very more data import operations in FAS financial systems be present, these import operations include importing
Excel tables of data.The content that each Excel tables of data includes is different from, in view of the complexity of business datum, exploit person at present
Member is directed to the importing of each Excel tables of data, is required for writing code and goes to analyze and extract data therein, then encapsulates again
After corresponding object, follow-up in-stockroom operation is carried out.On the one hand this mode wastes time and energy, on the other hand, due to what is write
The otherness of code, cause later maintenance cumbersome.
The content of the invention
It is an object of the invention to provide a kind of electronic installation, the method and storage medium of the data for extracting tables of data, purport
It is time saving and energy saving in the data for the Excel tables of data that automatic parsing and extraction are imported in FAS practice operating systems, be advantageous to the later stage
Maintenance.
To achieve the above object, the present invention provides a kind of electronic installation, the electronic installation include memory and with it is described
The processor of memory connection, is stored with the processing system that can be run on the processor, the processing in the memory
Following steps are realized when system is by the computing device：
S1, type of service corresponding to each Excel tables of data is pre-defined, for each type of service, configuration and this kind
The field to be extracted of type of service association, stores incidence relation of this kind of type of service with corresponding field to be extracted；
S2, when Excel tables of data is imported in FAS practice operating systems, the filename based on the Excel tables of data is known
Type of service not corresponding to the Excel tables of data, according to the incidence relation of the type of service of storage and field to be extracted, it is determined that should
The field to be extracted that type of service corresponding to Excel tables of data associates；
S3, the data object in the Excel tables of data is extracted based on identified field to be extracted；
S4, identified field to be extracted and the data object extracted are shown, confirmed for user.
Preferably, the step S3 includes：
S31, identified field to be extracted is compared with each fixed field in the Excel tables of data；
S32, if identified field to be extracted corresponds and identical with each fixed field, analyze under each fixed field
Whether corresponding data object is had；
S33, if there is corresponding data object, extract in the Excel tables of data corresponding data under each fixed field
Object.
Preferably, the step S3 further comprises：
If field to be extracted determined by having is not corresponding with each fixed field, or has under fixed field without corresponding
Data object, then generation includes the prompting message of identified field to be extracted, to prompt user's hand inspection the Excel data
Table.
Preferably, when the processing system is by the computing device, following steps are also realized：
Before extracted data object is shown, the data object extracted is converted to according to predetermined transformation rule
Corresponding data format.
To achieve the above object, the present invention also provides a kind of method for the data for extracting tables of data, the extraction tables of data
The methods of data include：
S1, type of service corresponding to each Excel tables of data is pre-defined, for each type of service, configuration and this kind
The field to be extracted of type of service association, stores incidence relation of this kind of type of service with corresponding field to be extracted；
S2, when Excel tables of data is imported in FAS practice operating systems, the filename based on the Excel tables of data is known
Type of service not corresponding to the Excel tables of data, according to the incidence relation of the type of service of storage and field to be extracted, it is determined that should
The field to be extracted that type of service corresponding to Excel tables of data associates；
S3, the data object in the Excel tables of data is extracted based on identified field to be extracted；
S4, identified field to be extracted and the data object extracted are shown, confirmed for user.
Preferably, the step S3 includes：
S31, identified field to be extracted is compared with each fixed field in the Excel tables of data；
S32, if identified field to be extracted corresponds and identical with each fixed field, analyze under each fixed field
Whether corresponding data object is had；
S33, if there is corresponding data object, extract in the Excel tables of data corresponding data under each fixed field
Object.
Preferably, the step S3 further comprises：
If field to be extracted determined by having is not corresponding with each fixed field, or has under fixed field without corresponding
Data object, then generation includes the prompting message of identified field to be extracted, to prompt user's hand inspection the Excel data
Table.
Preferably, in addition to：Before show extracted data object, it will be extracted according to predetermined transformation rule
Data object is converted to corresponding data format.
Preferably, also include after the step S4：After the confirmation for receiving user instructs, the data pair that will be extracted
As carrying out storage processing.
The present invention also provides a kind of computer-readable recording medium, and processing is stored with the computer-readable recording medium
System, the processing system realizes the method for the data of above-mentioned extraction tables of data when being executed by processor the step of.
The beneficial effects of the invention are as follows：The present invention can by Excel tables of data import FAS practice operating systems in when,
The type of service of the Excel tables of data is identified, determines the field to be extracted that type of service corresponding to the Excel tables of data associates,
Corresponding data object under the field to be extracted is extracted, identified field to be extracted and the data object extracted are opened up
Show, the present invention can parse and extract automatically the Excel tables of data imported in FAS practice operating systems based on foregoing component
Data, it is time saving and energy saving, it is not necessary to write various codes and go to analyze and extract data, avoid having differences property, be advantageous to the later stage
Maintenance.
Brief description of the drawings
Fig. 1 is each optional application environment schematic diagram of embodiment one of the present invention；
Fig. 2 is the schematic flow sheet of the embodiment of method one of the data of present invention extraction tables of data；
Fig. 3 is the refinement schematic flow sheet of step S3 shown in Fig. 2.
Embodiment
In order to make the purpose , technical scheme and advantage of the present invention be clearer, it is right below in conjunction with drawings and Examples
The present invention is further elaborated.It should be appreciated that specific embodiment described herein is only to explain the present invention, not
For limiting the present invention.Based on the embodiment in the present invention, those of ordinary skill in the art are not before creative work is made
The every other embodiment obtained is put, belongs to the scope of protection of the invention.
It should be noted that the description for being related to " first ", " second " etc. in the present invention is only used for describing purpose, and can not
It is interpreted as indicating or implies its relative importance or imply the quantity of the technical characteristic indicated by indicating.Thus, define " the
One ", at least one this feature can be expressed or be implicitly included to the feature of " second ".In addition, the skill between each embodiment
Art scheme can be combined with each other, but must can be implemented as basis with those of ordinary skill in the art, when technical scheme
With reference to occurring conflicting or will be understood that the combination of this technical scheme is not present when can not realize, also not in application claims
Protection domain within.
As shown in fig.1, it is the application environment signal of the preferred embodiment of the method for the data of present invention extraction tables of data
Figure.The application environment schematic diagram includes electronic installation 1 and terminal device 2.Electronic installation 1 can pass through network, near-field communication skill
The suitable technology such as art carries out data interaction with terminal device 2.
The terminal device 2, which includes, but not limited to any one, to pass through keyboard, mouse, remote control, touch with user
The mode such as plate or voice-operated device carries out the electronic product of man-machine interaction, for example, personal computer, tablet personal computer, smart mobile phone,
Personal digital assistant (Personal Digital Assistant, PDA), game machine, IPTV (Internet
Protocol Television, IPTV), intellectual Wearable, the movable equipment of guider etc., or such as
The fixed terminal of digital TV, desktop computer, notebook, server etc..Terminal device 2 is receiving the instruction (example of user
Such as configure the instruction of the field to be extracted of miscellaneous service type association) and send it to electronic installation 1, and by electronic installation
1 feedack is shown.
In other embodiments, terminal device 2 is receiving the instruction of user and send it to electronic installation 1, and
The software and/hardware components that the feedack of electronic installation 1 is shown etc. can be integrated in electronic installation 1, without
Special terminal device 2.
The electronic installation 1 be it is a kind of can according to the instruction for being previously set or storing, it is automatic carry out numerical computations and/
Or the equipment of information processing.The electronic installation 1 can be computer, can also be single network server, multiple networks clothes
It is engaged in the server group either cloud being made up of a large amount of main frames or the webserver based on cloud computing of device composition, wherein cloud computing
It is one kind of Distributed Calculation, a super virtual computer being made up of the computer collection of a group loose couplings.
In the present embodiment, electronic installation 1 may include, but be not limited only to, and can be in communication with each other connection by system bus
Memory 11, processor 12, network interface 13, memory 11 are stored with the processing system that can be run on the processor 12.Need
, it is noted that Fig. 1 illustrate only the electronic installation 1 with component 11-13, it should be understood that being not required for implementing to own
The component shown, what can be substituted implements more or less components.
Wherein, memory 11 includes internal memory and the readable storage medium storing program for executing of at least one type.Inside save as the fortune of electronic installation 1
Row provides caching；Readable storage medium storing program for executing can be if flash memory, hard disk, multimedia card, card-type memory are (for example, SD or DX memories
Deng), random access storage device (RAM), static random-access memory (SRAM), read-only storage (ROM), electric erasable can compile
Journey read-only storage (EEPROM), programmable read only memory (PROM), magnetic storage, disk, CD etc. it is non-volatile
Storage medium.In certain embodiments, readable storage medium storing program for executing can be the internal storage unit of electronic installation 1, such as the electronics
The hard disk of device 1；In further embodiments, the non-volatile memory medium can also be that the external storage of electronic installation 1 is set
Plug-in type hard disk that is standby, such as being equipped with electronic installation 1, intelligent memory card (Smart Media Card, SMC), secure digital
(Secure Digital, SD) blocks, flash card (Flash Card) etc..In the present embodiment, the readable storage medium storing program for executing of memory 11
It is generally used for operating system and types of applications software that storage is installed on electronic installation 1, such as the place in one embodiment of the invention
Program code of reason system etc..Export or will export each in addition, memory 11 can be also used for temporarily storing
Class data.
The processor 12 can be in certain embodiments central processing unit (Central Processing Unit,
CPU), controller, microcontroller, microprocessor or other data processing chips.The processor 12 is generally used for controlling the electricity
The overall operation of sub-device 1, such as perform the control and processing related to the terminal device 2 progress data interaction or communication
Deng.In the present embodiment, the processor 12 is used to run the program code stored in the memory 11 or processing data, example
Such as run processing system.
The network interface 13 may include radio network interface or wired network interface, and the network interface 13 is generally used for
Communication connection is established between the electronic installation 1 and other electronic equipments.In the present embodiment, network interface 13 is mainly used in electricity
Sub-device 1 is connected with one or more terminal devices 2, and data are established between electronic installation 1 and one or more terminal devices 2
Transmission channel and communication connection.
The processing system is stored in memory 11, including it is at least one be stored in it is computer-readable in memory 11
Instruction, at least one computer-readable instruction can be performed by processor device 12, to realize the method for each embodiment of the application；With
And at least one computer-readable instruction is different according to the function that its each several part is realized, can be divided into different logic moulds
Block.
In one embodiment, following steps are realized when above-mentioned processing system is performed by the processor 12：
Step S1, pre-define type of service corresponding to each Excel tables of data, for each type of service, configuration with
The field to be extracted of this kind of type of service association, stores incidence relation of this kind of type of service with corresponding field to be extracted；
In the present embodiment, using the import feature of current FAS practice operating systems as sample, develop in Excel tables of data
Hold automatic parsing and extraction assembly, in the assembly, type of service corresponding to each Excel tables of data can be pre-defined, such as
For Excel tables of data " traveling expense reimbursement template ", its corresponding type of service is expense report type, for Excel data
Table " record separately row upper back(ing) board ", its corresponding type of service are that financial system keeps accounts row record type.Certainly, grasped in FAS business
The Excel tables of data for making to import in system also has other species, will not enumerate herein.
For each type of service, the field to be extracted associated with this kind of type of service is configured, such as expense report
Type, configuring field to be extracted associated with it includes " employee name or employee ID, affiliated function, the reimbursement origin of an incident, reimbursement gold
Volume is detailed and submits an expense account the time " etc..Kept accounts row record type for financial system, configuring field to be extracted associated with it includes
" bill type, reimbursement classification, output tax rate, accounting processing type, detailed type, explanation and elastic domain information " etc..
, will after the field to be extracted of the type of service association of various Excel tables of data in configuring FAS practice operating systems
The type of service of various Excel tables of data is stored with the incidence relation of corresponding field to be extracted, such as with relationship maps
The form of table is stored.
Step S2, when Excel tables of data is imported in FAS practice operating systems, the file based on the Excel tables of data
Name identifies type of service corresponding to the Excel tables of data, according to the incidence relation of the type of service of storage and field to be extracted, really
The field to be extracted of type of service association corresponding to the fixed Excel tables of data；
In the present embodiment, in FAS practice operating systems, it can disposably import one or more and include different content
Excel tables of data.When Excel tables of data is imported in FAS practice operating systems, the file based on the Excel tables of data
Name identifies type of service corresponding to the Excel tables of data, if as described above, entitled " the traveling expense report of the file of Excel tables of data
Sell template ", then the type of service for identifying the Excel tables of data is expense report type, if the file of Excel tables of data is entitled
" record separately row upper back(ing) board ", then identify that the type of service of the Excel tables of data keeps accounts row record type for financial system.
After type of service corresponding to the Excel tables of data is identified according to the filename of Excel tables of data, the industry with storage
Service type is matched, and to find stored identical type of service, obtains associating for the type of service and field to be extracted
Relation, determine that the corresponding type of service of the Excel tables of data associates according to the type of service and the incidence relation of field to be extracted
Field to be extracted.
Step S3, the data object in the Excel tables of data is extracted based on identified field to be extracted；
Step S4, identified field to be extracted and the data object extracted are shown, confirmed for user.
In the present embodiment, if Excel tables of data is " traveling expense reimbursement template ", data therein are as shown in table 1 below：
Table 1
Field to be extracted is respectively employee name or employee ID, affiliated function, the reimbursement origin of an incident, reimbursement time and reimbursement gold
Volume is detailed, the data object under these corresponding fields to be extracted be respectively " Zhang San, sales department, Beijing go on business,
2017.07.20, train ticket take 500 yuan, 1500 yuan of airfare, 500 yuan of hotel expense ".
Under identified field to be extracted in extracting the Excel tables of data after corresponding data object, by word to be extracted
Section and the data object extracted are shown, and examination ＆ verification confirmation is carried out for user.If user confirms that shown content does not have
Mistake, be then put in storage, for the corresponding data manipulation of subsequent execution, such as carry out the operation such as data encapsulation, storage.
Compared with prior art, for the present embodiment when Excel tables of data is imported in FAS practice operating systems, identification should
The type of service of Excel tables of data, the field to be extracted that type of service corresponding to the Excel tables of data associates is determined, extraction should
Corresponding data object under field to be extracted, identified field to be extracted and the data object extracted are shown, this
Embodiment can parse and extract automatically the number of the Excel tables of data imported in FAS practice operating systems based on foregoing component
According to time saving and energy saving, it is not necessary to write various codes and go to analyze and extract data, avoid having differences property, be advantageous to the dimension in later stage
Shield.
In a preferred embodiment, on the basis of above-mentioned Fig. 1 embodiment, the step S3 includes：
S31, identified field to be extracted is compared with each fixed field in the Excel tables of data；
S32, if identified field to be extracted corresponds and identical with each fixed field, analyze under each fixed field
Whether corresponding data object is had；
S33, if there is corresponding data object, extract in the Excel tables of data corresponding data under each fixed field
Object.
Wherein, each fixed field in field to be extracted determined by first and the Excel tables of data is carried out first
Compare, if there is fixed field identical with field to be extracted determined by this first in the Excel tables of data, continue second
Field to be extracted determined by individual is compared with each fixed field in the Excel tables of data, until all are determined
Field to be extracted contrasted.
If identified field to be extracted corresponds and identical with each fixed field, analyzing under each fixed field is
It is no to have corresponding data object, if there is corresponding data object under each fixed field, it can directly extract each fixation
Corresponding data object under field.
Illustrated so that above-mentioned table 1 is Excel tables of data as an example, field to be extracted includes：Employee name or employee ID,
Affiliated function, the reimbursement origin of an incident, reimbursement time and reimbursed sum are detailed, and the fixed field in table 1 is：It is employee name, affiliated
Department, the reimbursement origin of an incident, reimbursement time and reimbursed sum are detailed, and both correspond and identical, then can be with each fixation in analytical table 1
Whether there is corresponding data object under field, if so, can be extracted.
In other alternative-embodiments, above-mentioned steps S3 further comprises：If field to be extracted determined by having with it is each
Fixed field does not correspond to, or has without corresponding data object under fixed field, then generation is comprising identified to be extracted
The prompting message of field, to prompt user's hand inspection the Excel tables of data.
Wherein, it is understood that there may be two kinds of abnormal conditions for needing to carry out hand inspection：One may have one or several
Identified field to be extracted is not corresponding with the fixed field in Excel tables of data；Another field to be extracted for determined by
Corresponded with each fixed field and identical, but be not filled with corresponding data object under some fixed fields, both feelings
User's hand inspection is needed to handle the Excel tables of data under condition, in addition, user has been after Excel tables of data has been handled, can be again
Extract data object.Thus, the mode of the present embodiment combination hand inspection can improve the data pair in extraction Excel tables of data
The accuracy of elephant.
In a preferred embodiment, on the basis of above-mentioned Fig. 1 embodiment, the processing system is by the processor
During execution, following steps are also realized：Before show extracted data object, it will be extracted according to predetermined transformation rule
Data object is converted to corresponding data format.
In the present embodiment, user can pre-set a variety of transformation rules, and set one or more kinds of conversions therein
Rule is the predetermined transformation rule, or, after user pre-sets a variety of transformation rules, based on corresponding to Excel tables of data
Type of service selectes corresponding transformation rule automatically.
Before extracted data object is shown, the data object extracted is converted to according to predetermined transformation rule
Corresponding data format, for example, for the amount of money, it is uniformly converted in units of member, the data of 2 significant digits, for
Time, be then uniformly converted to " * * * *-* *-* * " form, etc..Data object is converted to corresponding data lattice by the present embodiment
Formula, facilitate user to be confirmed, and be easy to subsequently can directly perform corresponding data manipulation, such as the encapsulation of progress data,
The operation such as storage.
As shown in Fig. 2 Fig. 2 is the schematic flow sheet of the embodiment of method one of the data of present invention extraction tables of data, this is carried
The method of the data of tables of data is taken to comprise the following steps：
Step S1, pre-define type of service corresponding to each Excel tables of data, for each type of service, configuration with
The field to be extracted of this kind of type of service association, stores incidence relation of this kind of type of service with corresponding field to be extracted；
In the present embodiment, using the import feature of current FAS practice operating systems as sample, develop in Excel tables of data
Hold automatic parsing and extraction assembly, in the assembly, type of service corresponding to each Excel tables of data can be pre-defined, such as
For Excel tables of data " traveling expense reimbursement template ", its corresponding type of service is expense report type, for Excel data
Table " record separately row upper back(ing) board ", its corresponding type of service are that financial system keeps accounts row record type.Certainly, grasped in FAS business
The Excel tables of data for making to import in system also has other species, will not enumerate herein.
For each type of service, the field to be extracted associated with this kind of type of service is configured, such as expense report
Type, configuring field to be extracted associated with it includes " employee name or employee ID, affiliated function, the reimbursement origin of an incident, reimbursement gold
Volume is detailed and submits an expense account the time " etc..Kept accounts row record type for financial system, configuring field to be extracted associated with it includes
" bill type, reimbursement classification, output tax rate, accounting processing type, detailed type, explanation and elastic domain information " etc..
, will after the field to be extracted of the type of service association of various Excel tables of data in configuring FAS practice operating systems
The type of service of various Excel tables of data is stored with the incidence relation of corresponding field to be extracted, such as with relationship maps
The form of table is stored.
Step S2, when Excel tables of data is imported in FAS practice operating systems, the file based on the Excel tables of data
Name identifies type of service corresponding to the Excel tables of data, according to the incidence relation of the type of service of storage and field to be extracted, really
The field to be extracted of type of service association corresponding to the fixed Excel tables of data；
In the present embodiment, in FAS practice operating systems, it can disposably import one or more and include different content
Excel tables of data.When Excel tables of data is imported in FAS practice operating systems, the file based on the Excel tables of data
Name identifies type of service corresponding to the Excel tables of data, if as described above, entitled " the traveling expense report of the file of Excel tables of data
Sell template ", then the type of service for identifying the Excel tables of data is expense report type, if the file of Excel tables of data is entitled
" record separately row upper back(ing) board ", then identify that the type of service of the Excel tables of data keeps accounts row record type for financial system.
After type of service corresponding to the Excel tables of data is identified according to the filename of Excel tables of data, the industry with storage
Service type is matched, and to find stored identical type of service, obtains associating for the type of service and field to be extracted
Relation, determine that the corresponding type of service of the Excel tables of data associates according to the type of service and the incidence relation of field to be extracted
Field to be extracted.
Step S3, the data object in the Excel tables of data is extracted based on identified field to be extracted；
Step S4, identified field to be extracted and the data object extracted are shown, confirmed for user.
In the present embodiment, if Excel tables of data is " traveling expense reimbursement template ", data therein are as shown in Table 1 above.
Field to be extracted is respectively that employee name or employee ID, affiliated function, the reimbursement origin of an incident, reimbursement time and reimbursed sum are detailed,
Data object under these corresponding fields to be extracted is respectively that " Zhang San, sales department, Beijing go on business, 2017.07.20, train ticket
Take 500 yuan, 1500 yuan of airfare, 500 yuan of hotel expense ".
Under identified field to be extracted in extracting the Excel tables of data after corresponding data object, by word to be extracted
Section and the data object extracted are shown, and examination ＆ verification confirmation is carried out for user.If user confirms that shown content does not have
Mistake, be then put in storage, for the corresponding data manipulation of subsequent execution, such as carry out the operation such as data encapsulation, storage.
Compared with prior art, for the present embodiment when Excel tables of data is imported in FAS practice operating systems, identification should
The type of service of Excel tables of data, the field to be extracted that type of service corresponding to the Excel tables of data associates is determined, extraction should
Corresponding data object under field to be extracted, identified field to be extracted and the data object extracted are shown, this
Embodiment can parse and extract automatically the number of the Excel tables of data imported in FAS practice operating systems based on foregoing component
According to time saving and energy saving, it is not necessary to write various codes and go to analyze and extract data, avoid having differences property, be advantageous to the dimension in later stage
Shield.
In a preferred embodiment, as shown in figure 3, on the basis of above-mentioned Fig. 2 embodiment, the step S3 bags
Include：
S31, identified field to be extracted is compared with each fixed field in the Excel tables of data；
S32, if identified field to be extracted corresponds and identical with each fixed field, analyze under each fixed field
Whether corresponding data object is had；
S33, if there is corresponding data object, extract in the Excel tables of data corresponding data under each fixed field
Object.
Wherein, each fixed field in field to be extracted determined by first and the Excel tables of data is carried out first
Compare, if there is fixed field identical with field to be extracted determined by this first in the Excel tables of data, continue second
Field to be extracted determined by individual is compared with each fixed field in the Excel tables of data, until all are determined
Field to be extracted contrasted.
If identified field to be extracted corresponds and identical with each fixed field, analyzing under each fixed field is
It is no to have corresponding data object, if there is corresponding data object under each fixed field, it can directly extract each fixation
Corresponding data object under field.
Illustrated so that above-mentioned table 1 is Excel tables of data as an example, field to be extracted includes：Employee name or employee ID,
Affiliated function, the reimbursement origin of an incident, reimbursement time and reimbursed sum are detailed, and the fixed field in table 1 is：It is employee name, affiliated
Department, the reimbursement origin of an incident, reimbursement time and reimbursed sum are detailed, and both correspond and identical, then can be with each fixation in analytical table 1
Whether there is corresponding data object under field, if so, can be extracted.
In other alternative-embodiments, above-mentioned steps S3 further comprises：If field to be extracted determined by having with it is each
Fixed field does not correspond to, or has without corresponding data object under fixed field, then generation is comprising identified to be extracted
The prompting message of field, to prompt user's hand inspection the Excel tables of data.
Wherein, it is understood that there may be two kinds of abnormal conditions for needing to carry out hand inspection：One may have one or several
Identified field to be extracted is not corresponding with the fixed field in Excel tables of data；Another field to be extracted for determined by
Corresponded with each fixed field and identical, but be not filled with corresponding data object under some fixed fields, both feelings
User's hand inspection is needed to handle the Excel tables of data under condition, in addition, user has been after Excel tables of data has been handled, can be again
Extract data object.Thus, the mode of the present embodiment combination hand inspection can improve the data pair in extraction Excel tables of data
The accuracy of elephant.
In a preferred embodiment, on the basis of above-mentioned Fig. 1 embodiment, this also includes：Extracted in displaying
Before data object, the data object extracted is converted into corresponding data format according to predetermined transformation rule.
In the present embodiment, user can pre-set a variety of transformation rules, and set one or more kinds of conversions therein
Rule is the predetermined transformation rule, or, after user pre-sets a variety of transformation rules, based on corresponding to Excel tables of data
Type of service selectes corresponding transformation rule automatically.
Before extracted data object is shown, the data object extracted is converted to according to predetermined transformation rule
Corresponding data format, for example, for the amount of money, it is uniformly converted in units of member, the data of 2 significant digits, for
Time, be then uniformly converted to " * * * *-* *-* * " form, etc..Data object is converted to corresponding data lattice by the present embodiment
Formula, facilitate user to be confirmed, and be easy to subsequently can directly perform corresponding data manipulation, such as the encapsulation of progress data,
The operation such as storage.
The present invention also provides a kind of computer-readable recording medium, and processing is stored with the computer-readable recording medium
System, the processing system realizes the method for the data of above-mentioned extraction tables of data when being executed by processor the step of.
The embodiments of the present invention are for illustration only, do not represent the quality of embodiment.
Through the above description of the embodiments, those skilled in the art can be understood that above-described embodiment side
Method can add the mode of required general hardware platform to realize by software, naturally it is also possible to by hardware, but in many cases
The former is more preferably embodiment.Based on such understanding, technical scheme is substantially done to prior art in other words
Going out the part of contribution can be embodied in the form of software product, and the computer software product is stored in a storage medium
In (such as ROM/RAM, magnetic disc, CD), including some instructions to cause a station terminal equipment (can be mobile phone, computer, clothes
Be engaged in device, air conditioner, or network equipment etc.) perform method described in each embodiment of the present invention.
The preferred embodiments of the present invention are these are only, are not intended to limit the scope of the invention, it is every to utilize this hair
The equivalent structure or equivalent flow conversion that bright specification and accompanying drawing content are made, or directly or indirectly it is used in other related skills
Art field, is included within the scope of the present invention.
Claims (10)
1. a kind of electronic installation, it is characterised in that the electronic installation includes memory and the processing being connected with the memory
Device, the processing system that can be run on the processor is stored with the memory, the processing system is by the processor
Following steps are realized during execution：
S1, type of service corresponding to each Excel tables of data is pre-defined, for each type of service, configuration and this kind of business
The field to be extracted of type association, store incidence relation of this kind of type of service with corresponding field to be extracted；
S2, when Excel tables of data is imported in FAS practice operating systems, the filename identification based on the Excel tables of data should
Type of service corresponding to Excel tables of data, according to the incidence relation of the type of service of storage and field to be extracted, it is determined that should
The field to be extracted that type of service corresponding to Excel tables of data associates；
S3, the data object in the Excel tables of data is extracted based on identified field to be extracted；
S4, identified field to be extracted and the data object extracted are shown, confirmed for user.
2. electronic installation according to claim 1, it is characterised in that the step S3 includes：
S31, identified field to be extracted is compared with each fixed field in the Excel tables of data；
S32, if identified field to be extracted corresponds and identical with each fixed field, analyze under each fixed field whether
There is corresponding data object；
S33, if there is corresponding data object, extract in the Excel tables of data corresponding data object under each fixed field.
3. electronic installation according to claim 2, it is characterised in that the step S3 further comprises：
If field to be extracted determined by having is not corresponding with each fixed field, or has under fixed field without corresponding data
Object, then generation includes the prompting message of identified field to be extracted, to prompt user's hand inspection the Excel tables of data.
4. according to the electronic installation described in any one of claims 1 to 3, it is characterised in that the processing system is by the processing
When device performs, following steps are also realized：
Before extracted data object is shown, the data object extracted is converted to correspondingly according to predetermined transformation rule
Data format.
A kind of 5. method for the data for extracting tables of data, it is characterised in that the method for the data of the extraction tables of data includes：
S1, type of service corresponding to each Excel tables of data is pre-defined, for each type of service, configuration and this kind of business
The field to be extracted of type association, store incidence relation of this kind of type of service with corresponding field to be extracted；
S2, when Excel tables of data is imported in FAS practice operating systems, the filename identification based on the Excel tables of data should
Type of service corresponding to Excel tables of data, according to the incidence relation of the type of service of storage and field to be extracted, it is determined that should
The field to be extracted that type of service corresponding to Excel tables of data associates；
S3, the data object in the Excel tables of data is extracted based on identified field to be extracted；
S4, identified field to be extracted and the data object extracted are shown, confirmed for user.
6. the method for the data of extraction tables of data according to claim 5, it is characterised in that the step S3 includes：
S31, identified field to be extracted is compared with each fixed field in the Excel tables of data；
S32, if identified field to be extracted corresponds and identical with each fixed field, analyze under each fixed field whether
There is corresponding data object；
S33, if there is corresponding data object, extract in the Excel tables of data corresponding data object under each fixed field.
7. the method for the data of extraction tables of data according to claim 6, it is characterised in that the step S3 is further wrapped
Include：
If field to be extracted determined by having is not corresponding with each fixed field, or has under fixed field without corresponding data
Object, then generation includes the prompting message of identified field to be extracted, to prompt user's hand inspection the Excel tables of data.
8. the method for the data of the extraction tables of data according to any one of claim 5 to 7, it is characterised in that also include：
Before extracted data object is shown, the data object extracted is converted to correspondingly according to predetermined transformation rule
Data format.
9. the method for the data of extraction tables of data according to claim 5, it is characterised in that also wrapped after the step S4
Include：After the confirmation for receiving user instructs, the data object extracted is subjected to storage processing.
10. a kind of computer-readable recording medium, it is characterised in that be stored with processing system on the computer-readable recording medium
System, the data of the extraction tables of data as any one of claim 5 to 9 are realized when the processing system is executed by processor
Method the step of.
Priority Applications (2)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710914884.5A CN107870979A (en) | 2017-09-30 | 2017-09-30 | Electronic installation, extract tables of data data method and storage medium |
| PCT/CN2018/089874 WO2019062191A1 (en) | 2017-09-30 | 2018-06-05 | Electronic device, method and system for extracting data in data table, and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710914884.5A CN107870979A (en) | 2017-09-30 | 2017-09-30 | Electronic installation, extract tables of data data method and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN107870979A true CN107870979A (en) | 2018-04-03 |
Family
ID=61753006
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710914884.5A Pending CN107870979A (en) | 2017-09-30 | 2017-09-30 | Electronic installation, extract tables of data data method and storage medium |
Country Status (2)
| Country | Link |
|---|---|
| CN (1) | CN107870979A (en) |
| WO (1) | WO2019062191A1 (en) |
Cited By (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2019062191A1 (en) * | 2017-09-30 | 2019-04-04 | 平安科技（深圳）有限公司 | Electronic device, method and system for extracting data in data table, and storage medium |
| CN110222104A (en) * | 2019-04-30 | 2019-09-10 | 中国人民财产保险股份有限公司 | Data extraction method, equipment and storage medium |
| CN111400135A (en) * | 2020-03-13 | 2020-07-10 | 普信恒业科技发展（北京）有限公司 | Method and device for extracting service data |
| CN111625586A (en) * | 2020-05-27 | 2020-09-04 | 北京思特奇信息技术股份有限公司 | Method and system for importing general service data |
| CN111694867A (en) * | 2020-06-16 | 2020-09-22 | 北京同邦卓益科技有限公司 | Data management method and device, electronic equipment and storage medium |
| CN112882630A (en) * | 2021-03-19 | 2021-06-01 | 腾讯科技（深圳）有限公司 | Information configuration method and related product |
| CN113505580A (en) * | 2021-07-26 | 2021-10-15 | 京东科技控股股份有限公司 | Method and device for analyzing table file |
| CN114722109A (en) * | 2022-04-13 | 2022-07-08 | 中国电信股份有限公司 | Data import method, system, device and storage medium |
| CN117009422A (en) * | 2023-05-09 | 2023-11-07 | 三峡高科信息技术有限责任公司 | Method for realizing data import by convenience business personnel |
| CN117235079A (en) * | 2023-11-16 | 2023-12-15 | 中国人民财产保险股份有限公司 | Data processing method, device and equipment |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110517740B (en) * | 2019-07-03 | 2023-08-11 | 平安科技（深圳）有限公司 | Medical data processing method, system, computer device and storage medium |
Citations (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101251809A (en) * | 2008-03-11 | 2008-08-27 | 浪潮集团山东通用软件有限公司 | Implementing method of data interface |
| CN102542038A (en) * | 2011-12-27 | 2012-07-04 | 浪潮通信信息系统有限公司 | Universal configurable standard bureau data storage method |
| CN103139172A (en) * | 2011-11-30 | 2013-06-05 | 阿里巴巴集团控股有限公司 | Service implementation method and device |
| CN103246651A (en) * | 2012-02-02 | 2013-08-14 | 金蝶软件（中国）有限公司 | Method and system for data inputting |
| CN103970758A (en) * | 2013-01-29 | 2014-08-06 | 鸿富锦精密工业（深圳）有限公司 | Database accessing system and method |
| CN103995908A (en) * | 2014-06-17 | 2014-08-20 | 山东中创软件工程股份有限公司 | Method and device for importing data |
| CN105117431A (en) * | 2015-08-07 | 2015-12-02 | 北京思特奇信息技术股份有限公司 | Dynamic configuration method and system for external imported data |
| CN105243117A (en) * | 2015-09-28 | 2016-01-13 | 四川长虹电器股份有限公司 | Data processing system and method |
| CN105912698A (en) * | 2016-04-25 | 2016-08-31 | 乐视控股（北京）有限公司 | Deletion method and system of data file in disk |
| CN106503457A (en) * | 2016-10-26 | 2017-03-15 | 清华大学 | The integrated technical data introduction method of clinical data based on translational medicine analysis platform |
| CN106682150A (en) * | 2016-12-22 | 2017-05-17 | 北京锐安科技有限公司 | Information processing method and device |
| CN107463661A (en) * | 2017-07-31 | 2017-12-12 | 小草数语（北京）科技有限公司 | The introduction method and device of data |
Family Cites Families (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103744982A (en) * | 2014-01-15 | 2014-04-23 | 北京神州普惠科技股份有限公司 | Method for importing Excel data into database |
| US20150339285A1 (en) * | 2014-04-22 | 2015-11-26 | Aman Safaei | Methods and Systems for Batch Generation and Delivery of Customized Documents |
| CN105138497A (en) * | 2015-07-13 | 2015-12-09 | 深圳市永兴元科技有限公司 | Report uploadingmethod in report system and report system |
| CN107193788A (en) * | 2017-06-13 | 2017-09-22 | 广东中建普联科技股份有限公司 | Construction industry engineering project Excel file data format storage method and system |
| CN107870979A (en) * | 2017-09-30 | 2018-04-03 | 平安科技（深圳）有限公司 | Electronic installation, extract tables of data data method and storage medium |
-
2017
- 2017-09-30 CN CN201710914884.5A patent/CN107870979A/en active Pending
-
2018
- 2018-06-05 WO PCT/CN2018/089874 patent/WO2019062191A1/en active Application Filing
Patent Citations (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101251809A (en) * | 2008-03-11 | 2008-08-27 | 浪潮集团山东通用软件有限公司 | Implementing method of data interface |
| CN103139172A (en) * | 2011-11-30 | 2013-06-05 | 阿里巴巴集团控股有限公司 | Service implementation method and device |
| CN102542038A (en) * | 2011-12-27 | 2012-07-04 | 浪潮通信信息系统有限公司 | Universal configurable standard bureau data storage method |
| CN103246651A (en) * | 2012-02-02 | 2013-08-14 | 金蝶软件（中国）有限公司 | Method and system for data inputting |
| CN103970758A (en) * | 2013-01-29 | 2014-08-06 | 鸿富锦精密工业（深圳）有限公司 | Database accessing system and method |
| CN103995908A (en) * | 2014-06-17 | 2014-08-20 | 山东中创软件工程股份有限公司 | Method and device for importing data |
| CN105117431A (en) * | 2015-08-07 | 2015-12-02 | 北京思特奇信息技术股份有限公司 | Dynamic configuration method and system for external imported data |
| CN105243117A (en) * | 2015-09-28 | 2016-01-13 | 四川长虹电器股份有限公司 | Data processing system and method |
| CN105912698A (en) * | 2016-04-25 | 2016-08-31 | 乐视控股（北京）有限公司 | Deletion method and system of data file in disk |
| CN106503457A (en) * | 2016-10-26 | 2017-03-15 | 清华大学 | The integrated technical data introduction method of clinical data based on translational medicine analysis platform |
| CN106682150A (en) * | 2016-12-22 | 2017-05-17 | 北京锐安科技有限公司 | Information processing method and device |
| CN107463661A (en) * | 2017-07-31 | 2017-12-12 | 小草数语（北京）科技有限公司 | The introduction method and device of data |
Cited By (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2019062191A1 (en) * | 2017-09-30 | 2019-04-04 | 平安科技（深圳）有限公司 | Electronic device, method and system for extracting data in data table, and storage medium |
| CN110222104A (en) * | 2019-04-30 | 2019-09-10 | 中国人民财产保险股份有限公司 | Data extraction method, equipment and storage medium |
| CN111400135A (en) * | 2020-03-13 | 2020-07-10 | 普信恒业科技发展（北京）有限公司 | Method and device for extracting service data |
| CN111625586A (en) * | 2020-05-27 | 2020-09-04 | 北京思特奇信息技术股份有限公司 | Method and system for importing general service data |
| CN111694867A (en) * | 2020-06-16 | 2020-09-22 | 北京同邦卓益科技有限公司 | Data management method and device, electronic equipment and storage medium |
| CN112882630A (en) * | 2021-03-19 | 2021-06-01 | 腾讯科技（深圳）有限公司 | Information configuration method and related product |
| CN113505580A (en) * | 2021-07-26 | 2021-10-15 | 京东科技控股股份有限公司 | Method and device for analyzing table file |
| CN114722109A (en) * | 2022-04-13 | 2022-07-08 | 中国电信股份有限公司 | Data import method, system, device and storage medium |
| CN114722109B (en) * | 2022-04-13 | 2024-02-06 | 中国电信股份有限公司 | Data importing method, system, equipment and storage medium |
| CN117009422A (en) * | 2023-05-09 | 2023-11-07 | 三峡高科信息技术有限责任公司 | Method for realizing data import by convenience business personnel |
| CN117009422B (en) * | 2023-05-09 | 2024-04-12 | 三峡高科信息技术有限责任公司 | Method for realizing data import by convenience business personnel |
| CN117235079A (en) * | 2023-11-16 | 2023-12-15 | 中国人民财产保险股份有限公司 | Data processing method, device and equipment |
Also Published As
| Publication number | Publication date |
|---|---|
| WO2019062191A1 (en) | 2019-04-04 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107870979A (en) | Electronic installation, extract tables of data data method and storage medium | |
| CN102999852B (en) | The generation method of electronic ticket data and device | |
| CN104461863A (en) | Service system testing method, device and system | |
| CN108768929A (en) | The analytic method and storage medium of electronic device, reference feedback message | |
| CN107871278A (en) | The method and storage medium of server, customer relationship network display | |
| CN106384280B (en) | Artificial intelligence accounting system and calculation method thereof | |
| CN112631884A (en) | Pressure measurement method and device based on data synchronization, computer equipment and storage medium | |
| CN104200385B (en) | A kind of method and system for the self-help teller machine for handling proficiency housing loan business | |
| CN107679937A (en) | Customize method, system, storage medium and the equipment of service function | |
| CN107451301B (en) | Processing method, device, equipment and storage medium for real-time delivery bill mail | |
| CN114265835A (en) | Data analysis method and device based on graph mining and related equipment | |
| CN111400187B (en) | Parameter dynamic verification system and method based on customized data source | |
| CN104318433A (en) | Automatic recharging method and system of citizen card | |
| CN111913861A (en) | Performance test method, device, equipment and medium of Internet of things system | |
| CN116775575A (en) | File merging method and device, electronic equipment and storage medium | |
| CN111161052A (en) | Bank operation data processing method and device | |
| CN110148050A (en) | Document data processing method, device and computer equipment in loan transaction | |
| CN108427700B (en) | Electronic device, user grouping method and computer readable storage medium | |
| CN105141993A (en) | Information targeted distribution method and system | |
| CN105589755A (en) | Verifying method and system when generating certificate | |
| CN114780602A (en) | Data tracing analysis method and device, computer equipment and storage medium | |
| CN107563888B (en) | System and method for uniformly managing online bills | |
| CN110018844A (en) | Management method, device and the electronic equipment of decision trigger method | |
| CN106909570B (en) | Data conversion method and device | |
| CN113822027A (en) | Processing method and device for business and travel data table combining AI and RPA |
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 | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20180403 |