CN109657225A - Data integration method, device, terminal and storage medium - Google Patents
Data integration method, device, terminal and storage medium Download PDFInfo
- Publication number
- CN109657225A CN109657225A CN201811137029.9A CN201811137029A CN109657225A CN 109657225 A CN109657225 A CN 109657225A CN 201811137029 A CN201811137029 A CN 201811137029A CN 109657225 A CN109657225 A CN 109657225A
- Authority
- CN
- China
- Prior art keywords
- data
- target
- field
- template
- file
- 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
- 230000010354 integration Effects 0.000 title claims abstract description 100
- 238000000034 method Methods 0.000 title claims abstract description 57
- 230000008676 import Effects 0.000 claims description 28
- 230000008569 process Effects 0.000 claims description 14
- 238000013500 data storage Methods 0.000 claims description 8
- 238000000605 extraction Methods 0.000 claims description 6
- 230000004069 differentiation Effects 0.000 abstract description 6
- 238000012545 processing Methods 0.000 description 20
- 238000010586 diagram Methods 0.000 description 8
- 230000006870 function Effects 0.000 description 6
- 239000000284 extract Substances 0.000 description 4
- 238000007792 addition Methods 0.000 description 3
- 230000008520 organization Effects 0.000 description 3
- 238000012216 screening Methods 0.000 description 3
- 238000004458 analytical method Methods 0.000 description 2
- 238000004891 communication Methods 0.000 description 2
- 238000007726 management method Methods 0.000 description 2
- 238000013507 mapping Methods 0.000 description 2
- 230000001960 triggered effect Effects 0.000 description 2
- 241001269238 Data Species 0.000 description 1
- 230000005540 biological transmission Effects 0.000 description 1
- 238000004364 calculation method Methods 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 238000004590 computer program Methods 0.000 description 1
- 238000012790 confirmation Methods 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 239000004744 fabric Substances 0.000 description 1
- 238000001914 filtration Methods 0.000 description 1
- 239000000203 mixture Substances 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 238000003032 molecular docking Methods 0.000 description 1
- 238000012544 monitoring process Methods 0.000 description 1
- 230000009467 reduction Effects 0.000 description 1
- 238000007619 statistical method Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/189—Automatic justification
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention provides a kind of data integration method, device, terminal and storage medium, this method comprises: obtaining the Data Integration when detecting Data Integration request and requesting corresponding importing file, judge whether the importing file meets preset format；If the importing file does not meet preset format, the importing file is imported according to preset rules, and the file destination obtained after importing is sent to back-end system, generates case data so that back-end system is based on the file destination；The case data are obtained, and obtain the corresponding target customer of the case data；Template corresponding with the target customer is obtained, target report is generated according to the template and the case data, and the target report is supplied to the target customer.The present invention can provide different reports for different clients, carry out differentiation displaying to data, improve customer satisfaction.
Description
Technical field
The present invention relates to technical field of data processing more particularly to a kind of data integration method, device, terminal and storage to be situated between
Matter.
Background technique
Service process platform receives the business commission of multiple clients, carries out case tune based on the related data that client provides
Degree, processing and statistical analysis, in specific time, return to client for the disposition of case according to customer demand.
Because different clients belong to different types of service, the content and format of provided related data are had nothing in common with each other,
And service process platform has preset data processing call format, the related data that therefore, it is necessary to provide client to data
It is adjusted, to meet the data handling requirements of service process platform；Because different clients content of interest is different, basis is needed
After the disposition data of case are screened, integrated by the demand of client's otherness, it is supplied to corresponding client.
Summary of the invention
The main purpose of the present invention is to provide a kind of data integration methods, it is intended to which solution does not meet data processing format and wants
The importing file asked can not carry out normal data processing, and need to provide the technology that otherness data are shown for different clients
Problem.
To achieve the above object, the present invention provides a kind of data integration method, which is characterized in that the data integration method
The following steps are included:
When detecting Data Integration request, obtains the Data Integration and request corresponding importing file, judge the importing
Whether file meets preset format；
If the importing file does not meet preset format, the importing file is imported according to preset rules, and will import
The file destination obtained afterwards is sent to back-end system, generates case data so that back-end system is based on the file destination；
The case data are obtained, and obtain the corresponding target customer of the case data；
Template corresponding with the target customer is obtained, generates target report according to the template and the case data, and
The target report is supplied to the target customer.
Optionally, described the step of importing the importing file according to preset rules, includes:
The data in the importing file are read, and determine objective attribute target attribute corresponding to the data；
The objective attribute target attribute and the field in predetermined word phase library are compared, judge whether deposit in the predetermined word phase library
In aiming field corresponding with the objective attribute target attribute；
If there is the aiming field corresponding with the objective attribute target attribute in the predetermined word phase library, by the importing text
Data in part store the field storage location to the aiming field, by the data and aiming field in the importing file
Association.
Optionally, the data integration method includes:
In the importing process for importing file, to own in the file header and the importing file for importing file
Data add distinguishing identifier；
Include: after described the step of importing the importing file according to preset rules
When detecting idsplay order, the distinguishing identifier for the data to be displayed that the idsplay order is directed toward is obtained；
Corresponding file header to be shown is obtained according to the distinguishing identifier, and corresponding according to file header acquisition to be shown
Field to be shown；
The field to be shown is shown.
Optionally, described to obtain template corresponding with the target customer, it is generated according to the template and the case data
The step of target report includes:
Template corresponding with the target customer is obtained from preset template library；
Dimension set interface is exported, for user setting target dimension；
Target dimension is received, target template is obtained from the corresponding template of the target customer based on target dimension；
It, will be from the case data from acquisition in the case data and each associated data of field in the target template
The data of middle acquisition export to the position of corresponding field, to generate target report.
Optionally, described from the step of obtaining data associated with field each in the target template in the case data
Include:
Arbitrary first field in the target template is obtained, and obtains first field pair from the target template
The efficient association field answered；
Based on first field and its corresponding efficient association field, filtered out from the case data and described
The associated data of one field.
Optionally, the step of acquisition template corresponding with the target customer includes:
Keyword field is extracted from the case data, using all keyword fields of extraction as the first sets of fields
It closes；
Reference template is obtained from preset template library, the second set of fields is extracted from the reference template；
The fallback relationship that field between the first set of fields and the second set of fields is established according to user operation instruction, according to this
The field for belonging to the second set of fields in the reference template is substituted for corresponding field in the first set of fields by fallback relationship,
To generate the corresponding template of the target customer.
Optionally, the data by the case data export to the position of corresponding field, to generate target report
The step of after include:
When detecting skin template switching command, the purported skin template of skin template switching command direction is obtained；
The purported skin template is suitable for the target report.
In addition, to achieve the above object, the present invention also provides a kind of data integration device, the data integration device packet
It includes:
Format judgment module, for obtaining the Data Integration and requesting corresponding importing when detecting Data Integration request
File, judges whether the importing file meets preset format；
Module is integrated, if not meeting preset format for the importing file, imports the importing according to preset rules
File, and the file destination obtained after importing is sent to back-end system, so that back-end system is generated based on the file destination
Case data；
Customer Acquisition module for obtaining the case data, and obtains the corresponding target customer of the case data；
Report generation module, for obtaining template corresponding with the target customer, according to the template and the case number of packages
According to generation target report, and the target report is supplied to the target customer.
In addition, to achieve the above object, the present invention also provides a kind of Data Integration terminal, the Data Integration terminal includes
Processor, memory and it is stored in the data integration program that can be executed on the memory and by the processor, wherein institute
When stating data integration program and being executed by the processor, realize such as the step of above-mentioned data integration method.
In addition, to achieve the above object, the present invention also provides a kind of storage medium, being stored with data on the storage medium
Integrated process, wherein realizing when the data integration program is executed by processor such as the step of above-mentioned data integration method.
The embodiment of the present invention requests corresponding importing text by when detecting Data Integration request, obtaining the Data Integration
Part, judges whether the importing file meets preset format；If the importing file does not meet preset format, according to default rule
The importing file is then imported, and the file destination obtained after importing is sent to back-end system, so that back-end system is based on institute
It states file destination and generates case data, importing files from different clients, different-format can be carried out according to preset format
Adjustment, so that its call format for meeting back-end system data processing；The case data are obtained, and obtain the case data
Corresponding target customer；Template corresponding with the target customer is obtained, target is generated according to the template and the case data
Report, and the target report is supplied to the target customer, the unified format that back-end system can be provided, all case number of packages
According to screening, integrating according to different demands client, different reports are selected, differentiation displaying is carried out to data, difference can be met
The demand of client, improves customer satisfaction, meanwhile, the requirement to back-end system data integration function is reduced, so that back-end system
Data processing can be absorbed in, promote data-handling capacity.
Detailed description of the invention
Fig. 1 is the Data Integration terminal structure schematic diagram for the hardware running environment that the embodiment of the present invention is related to；
Fig. 2 is the flow diagram of data integration method first embodiment of the present invention；
Fig. 3 is the flow diagram of data integration method second embodiment of the present invention；
Fig. 4 is the flow diagram of data integration method 3rd embodiment of the present invention；
Fig. 5 is the functional block diagram of data integration device first embodiment of the present invention.
The embodiments will be further described with reference to the accompanying drawings for the realization, the function and the advantages of the object of the present invention.
Specific embodiment
It should be appreciated that the specific embodiments described herein are merely illustrative of the present invention, it is not intended to limit the present invention.
Referring to Figure 1, Fig. 1 is the hardware structural diagram of Data Integration terminal provided by the present invention.
The Data Integration terminal can be PC, be also possible to smart phone, tablet computer, portable computer, desk-top meter
The device end having a display function such as calculation machine, optionally, the Data Integration terminal can be server apparatus, and there are data
The rear end management system of integration, schedule workers are managed data integrated terminal by the rear end management system.
The Data Integration terminal may include: the components such as processor 10 and memory 20.It is whole in the Data Integration
In end, the processor 10 is connect with the memory 20, and data integration program, processor 10 are stored on the memory 20
The data integration program stored in memory 20 can be called, and the step of realizing embodiment as each such as following data integration methods.
The memory 20 can be used for storing software program and various data.Memory 20 can mainly include storage journey
Sequence area and storage data area, wherein storing program area can the (ratio of application program needed for storage program area, at least one function
Such as data integration program)；Storage data area may include database, such as the present invention need to obtain report template from database
Deng.In addition, memory 20 may include high-speed random access memory, it can also include nonvolatile memory, for example, at least
One disk memory, flush memory device or other volatile solid-state parts.
Processor 10 is the control centre of Data Integration terminal, utilizes various interfaces and the entire Data Integration of connection
The various pieces of terminal, by running or executing the software program and/or module that are stored in memory 20, and calling storage
Data in memory 20, execute Data Integration terminal various functions and processing data, thus to data integrated terminal into
Row integral monitoring.Processor 10 may include one or more processing units；Optionally, processor 10 can integrate application processor and
Modem processor, wherein the main processing operation system of application processor, user interface and application program etc., modulation /demodulation
Processor mainly handles wireless communication.It is understood that above-mentioned modem processor can not also be integrated into processor 10
In.
It will be understood by those skilled in the art that Data Integration terminal structure shown in Fig. 1 not integrate by structure paired data
The restriction of terminal may include perhaps combining certain components or different component cloth than illustrating more or fewer components
It sets.
Based on above-mentioned hardware configuration, proposes each embodiment of the method for the present invention, occur in each embodiment of the method for the present invention
" terminal " all refer to data integrated terminal unless otherwise indicated.
The present invention provides a kind of data integration method.
It is the flow diagram of data integration method first embodiment of the present invention referring to Fig. 2, Fig. 2.
In the present embodiment, the data integration method the following steps are included:
Step S10 obtains the Data Integration and requests corresponding importing file, judgement when detecting Data Integration request
Whether the importing file meets preset format；
Import the Data Integration that file refers to that data integrated terminal detects and request corresponding file, can refer to through USB or
Wireless transmission or the modes such as network communication are transferred to the importing file of Data Integration terminal from other terminal/servers, can also be with
Refer to and the importing file for being stored in terminal local is imported into the goal systems configured in terminal, for example, by local customer data
Imported into the OA system configured in terminal, urge money system, customer service system etc..Import the data that file is form, such as Excel
Table or CSV table.
It is of the invention for ease of understanding, an Application Scenarios-Example of data integration method is proposed, by Data Integration side of the present invention
Method is applied to customer service system, and the Data Integration terminal carrying customer service system carries out Data Integration operation, customer service system docking
Committee case client and urge money system, customer service system is needed the different Data Integration of content/format from different clients at unified
It is transferred to money system of urging after format, and will be from urging related each committee's case client of money system to urge the data of money situation with report form
It is supplied to corresponding client.In this application scenarios, terminal where customer service system is Data Integration terminal, the operation of customer service system
Personnel are the user of Data Integration terminal.
Preset format refers to call format when back-end system carries out data processing to data, and the lattice of file are imported by reading
Formula judges whether it meets preset format.If importing file meets preset format, it will directly import file and be transferred to rear end system
System generates case data so that back-end system is based on the file destination.
Step S20 imports the importing file according to preset rules if the importing file does not meet preset format,
And the file destination obtained after importing is sent to back-end system, so that back-end system is based on the file destination generation case number of packages
According to；
It is reduction manually to the arrangement of data, or reduces back-end system before data processing to the whole of data format
It manages, in the present embodiment, if the importing file does not meet preset format, in the process that will import file importing customer service system
In, import operation is executed to the importing file according to preset rules, realizes the adjustment to file format is imported, so that after importing
File destination meet preset format, then the file destination is sent to back-end system.
Preset rules in the present embodiment refer to that data integrated terminal/device data predetermined import rule, by pre-
If regular, the storage organization for importing data in file is changed into the corresponding storage organization of preset rules, is existed so that importing file
After importeding into Data Integration terminal/device, the file destination for meeting preset format is generated.
In one embodiment, by reading the data imported in file, and target category corresponding to the data is determined
Property；The objective attribute target attribute and the field in predetermined word phase library are compared, judge in the predetermined word phase library with the presence or absence of with
The corresponding aiming field of the objective attribute target attribute；If there is the target word corresponding with the objective attribute target attribute in the predetermined word phase library
Section, then by the field storage location of the data storage in the importing file to the aiming field.Field tool in field storehouse
There is respective field storage location, the data storage by that will import in file changes to the field storage location of corresponding field
The data format for importing file, complies with preset format.
Back-end system generates case data after carrying out data processing on the basis of file destination, for example, back-end system is
When urging money system, based on the user's operation for urging money system, it is added data on the basis of file destination, modification data, carries out
The operation such as data operation, for example, the relevant information of 100 committee's cases in file destination comprising client A, urges money system according to user
Case status data is added in operation on the basis of this 100 committee's cases.
Step S30 obtains the case data, and obtains the corresponding target customer of the case data；
Case data can be sent to Data Integration terminal/device by back-end system, can also be by Data Integration terminal/dress
Set the case data that back-end system storage is obtained from public database.The case can be obtained while obtaining case data
Target customer belonging to data can also obtain corresponding target customer by analyzing the additional information of case data.
Step S40 obtains template corresponding with the target customer, generates target according to the template and the case data
Report, and the target report is supplied to the target customer.
Preset template library is inquired according to target customer, is judged in preset template library with the presence or absence of the corresponding mould of target customer
Plate directly acquires the corresponding template of target customer if there are the corresponding templates of target customer in preset template library, if preset mould
The corresponding template of target customer is not present in plate library, then generates the corresponding template of target customer according to case data.
The field in the corresponding template of target customer is obtained, it is each from acquisition in the case data and the target template
The data obtained from the case data are exported to the position of corresponding field by the associated data of field, generate target report,
And target report is supplied to the target customer.
The present embodiment requests corresponding importing file by when detecting that Data Integration is requested, obtaining the Data Integration,
Judge whether the importing file meets preset format；If the importing file does not meet preset format, according to preset rules
The importing file is imported, and the file destination obtained after importing is sent to back-end system, so that back-end system is based on described
File destination generates case data, can adjust importing files from different clients, different-format according to preset format
It is whole, so that its call format for meeting back-end system data processing；The case data are obtained, and obtain the case data pair
The target customer answered；Template corresponding with the target customer is obtained, target report is generated according to the template and the case data
Table, and the target report is supplied to the target customer, the unified format that back-end system can be provided, all case data
It screened, integrated according to different demands client, select different reports, differentiation displaying is carried out to data, different visitors can be met
The demand at family, improves customer satisfaction, meanwhile, the requirement to back-end system data integration function is reduced, so that back-end system can
It is absorbed in data processing, promotes data-handling capacity.
Further, referring to Fig. 3, based on the above embodiment, in data integration method second embodiment of the present invention, step
Include: according to the step of preset rules importing importing file described in S20
Step S21 reads the data imported in file, and determines objective attribute target attribute corresponding to the data；
The data in the importing file are read, data here instruct the arbitrary data in file, to importing file
In all data be carried out same import operation.
When reading any data for importing file, the data attribute of current read data is obtained, i.e., in the present embodiment
Objective attribute target attribute.For example, the data such as Zhang San, Li Si, king five, Zhao six belong to name class, money number is urged, money success is urged, money is urged to fail
Etc. data belong to case state class, the objective attribute target attribute of data can pass through analysis and import file or the additional description letter of the data
Breath obtains, and can also be selected during importing data by user, when importing file is form document, such as excel table
Or csv table, the data imported in file are data therein, will import the gauge outfit of file as its objective attribute target attribute.
Step S22 compares the objective attribute target attribute and the field in predetermined word phase library, judges the predetermined word phase library
In whether there is aiming field corresponding with the objective attribute target attribute；
Field storehouse is inquired, objective attribute target attribute and the field in predetermined word phase library are compared, comparison content can be title
Or character, for example, whether there is field identical with objective attribute target attribute title/character in field storehouse, with objective attribute target attribute title/character
Identical field is the corresponding aiming field of objective attribute target attribute.
Comparison content is also possible to meaning, for example, with the presence or absence of identical as objective attribute target attribute meaning in comparison predetermined word phase library
Field, meaning comparison can be carried out by semantics recognition and is realized, because there are a kind of situations: the word in objective attribute target attribute and field storehouse
Duan Keneng title is different, but meaning is identical, and terminal needs to identify the identical attribute of these meanings and field, in order to avoid import failure
Or need new definition field.
Therefore, field corresponding with the objective attribute target attribute can be field identical with objective attribute target attribute title/character, can also
To be field identical with objective attribute target attribute meaning.
Step S23, if there is the aiming field corresponding with the objective attribute target attribute in the predetermined word phase library, by institute
State import file in data storage to the aiming field field storage location, by it is described importing file in data with
Aiming field association.
It is compared by the objective attribute target attribute and the field in predetermined word phase library, finds in field storehouse and exist and the mesh
The corresponding aiming field of attribute is marked, then terminal can identify the corresponding all data of the objective attribute target attribute, and by the target category
Property corresponding all data storage to the field storage location of the aiming field, belong to the target to realize to import in file
The importing of all data of attribute.If the target word corresponding with the objective attribute target attribute is not present in the predetermined word phase library
Section exports newly-built field prompt, then for the corresponding field of user's new destination attribute.
Each field has corresponding field storage location, for storing the number for importing in file and corresponding under attribute
According to.
When reading any data for importing file, objective attribute target attribute belonging to the data currently read is obtained, by the mesh
Mark attribute is compared with the field in predetermined word phase library, is judged in field storehouse with the presence or absence of target corresponding with the objective attribute target attribute
Field, if there is the aiming field corresponding with the objective attribute target attribute in the predetermined word phase library, by the importing file
In data storage to the aiming field field storage location, by it is described importing file in data and aiming field close
Connection, to complete the importing for importing file, traversal imports all data in file, is carried out to wherein each data aforementioned
Step.
Meanwhile after the field storage location of the data storage that will be imported in file to corresponding aiming field, it is based on terminal
The storage organization of field forms the file destination after importing in field storehouse, to meet preset format, and will meet preset format
File destination is sent to back-end system, realizes the smooth importing for importing file, the processing convenient for back-end system to file is imported, just
In being successfully generated for case data.
Further, the data integration method further include:
Step S24, in the importing process for importing file, for the file header for importing file and importing text
All data add distinguishing identifier in part；
In the importing process for importing file, all data additions in the file header and the importing file to import file
Common, unique distinguishing identifier.Wherein, " common " refers to import the mark of the file header of file addition and adding with for all data
Mark-on knowledge be it is same, all data can be identified from the same importing file, and the file header with same distinguishing identifier is
The file header of the importing file." unique " refer to imported for mark possessed by the data of files compared to other be it is unique,
It whether can distinguish from certain unique importing file.
After adding distinguishing identifier, data and its distinguishing identifier are stored into the field storage location to corresponding field together,
Meanwhile also file header and its distinguishing identifier being stored together.
Various embodiments of the present invention realize that data import by way of establishing field storehouse, many of field storehouse field,
It can all be shown when showing data, however, user when checking a data, relates only to the corresponding field of the data,
Such as: data strip is -- client A is in committee's case title of a cause in March, processing status, client's time limit, then the corresponding field of the data
For custom fields, time field, title of a cause field, processing status field, client's deadline field, i.e., only need to show several words
Section is not that all whole fields will lead to data display interface and hashed field mistake occur if all showing in field storehouse
It is more, it shows in disorder.When to show data, only display has the field of valid data, to belong to the same word for importing file
The same distinguishing identifier of Duan Tianjia obtains according to distinguishing identifier in display and shows the same field for importing file.
Further, after described the step of importing the importing file according to preset rules further include:
Step S25 obtains the differentiation mark for the data to be displayed that the idsplay order is directed toward when detecting idsplay order
Know；
It, can be according to differentiation in the file header and the importing file that will import file after all data addition distinguishing identifiers
Mark obtains the relevant information for importing file, for example, importing the corresponding field of data in file.
In the present embodiment, idsplay order can be triggered by user, for example, user chooses certain data or a few datas
Afterwards, selection display, then trigger idsplay order.
Step S26 obtains corresponding file header to be shown according to the distinguishing identifier, and is obtained according to the file header to be shown
Take corresponding field to be shown；
Step S27 shows the field to be shown.
Because the data to be displayed source files (i.e. data to be displayed import before belonging to importing file) it is to be shown
File header is also added to same distinguishing identifier, so, file header to be shown can be obtained according to the distinguishing identifier, and obtaining
After file header to be shown, according to file header to be shown obtain source files in the corresponding field of data, according to idsplay order into
When row display, only show the corresponding field of data in source files, i.e., field to be shown, not other fields in display field library,
Guarantee accuracy, the terseness of display.
The present embodiment adds distinguishing identifier by data all in the file header and the importing file for importing file, makes
It obtains and is detecting idsplay order, when needing to display data, the differentiation mark for the data to be displayed that can be directed toward according to idsplay order
Know and determine corresponding file header, and the corresponding field to be shown of data in corresponding importing file is determined based on this document head, it can
Guarantee only to show field to be shown, other fields do not appear in the page, may make the page of display data simpler in display
It is clean.
Further, referring to Fig. 4, based on the above embodiment, in data integration method 3rd embodiment of the present invention, step
Acquisition template corresponding with the target customer described in S40 generates target report according to the template and the case data
Step includes:
Step S41 obtains template corresponding with the target customer from preset template library；
Service is shown in order to provide personalized data for different clients, and different data sheets is provided for different clients
Form in preset template library, stores corresponding report template for different clients, in determination to simplify report generation work
After target customer, preset template library can be inquired according to target customer, obtain template corresponding with the target customer.
In another embodiment, if there is no the corresponding template of the target customer in preset template library, according to case number of packages
According to corresponding templates are generated, specifically, the step S41 includes:
Step S411 extracts keyword field from the case data, using all keyword fields of extraction as the
One set of fields；
The case data are analyzed, keyword field therein is obtained, in one embodiment, extract institute in case data
There is the corresponding field of data, using the corresponding field of data all in case data as keyword field.Optionally, output template
Interface is created, when detecting the custom instruction of the first set of fields, detects the keyword that user is selected based on case data
Field extracts keyword field, as the first set of fields.
Step S412 obtains reference template from preset template library, and the second set of fields is extracted from the reference template；
Template creates on interface, the functionality controls configured with reference drawing template establishment, is detecting that the functionality controls are triggered
When, the template in preset template library is exported into display, for selection by the user reference template.By in reference template part field or
All fields are extracted as the second set of fields, can select all second fields in reference template by user, as
Second set of fields optionally when detecting that user selectes reference template, obtains the reference template, will be in reference template
Field is converted to optional field, selects so that user clicks, determines all second fields according to user field selection operation, and
All second fields are extracted as the second set of fields.
Step S413 is closed according to the replacement that user operation instruction establishes field between the first set of fields and the second set of fields
System, it is right in the first set of fields to be substituted for the field for belonging to the second set of fields in the reference template according to the fallback relationship
The field answered, to generate the corresponding template of the target customer.
After obtaining the first set of fields and the second set of fields, output fallback relationship creates interface, so that user is based on
The fallback relationship of field between the first set of fields and the second set of fields, fallback relationship creation are established in fallback relationship creation interface
Field in field and the second set of fields in first set of fields can be shown that user can be straight by interface in the form of mapping table
Editor's mapping table is connect, to create the one-to-one relationship of field and field in the second set of fields in the first set of fields.
In the fallback relationship confirmation instruction for receiving user's input, the fallback relationship for the field that creation is completed, root are obtained
The correspondence being all substituted for the field for belonging to the second set of fields in reference template according to the fallback relationship in the first set of fields
Field, realize the creation of template.
The present embodiment is by by word of the field in reference template in the first set of fields obtained based on case data
Section is replaced, the plate design of reusable reference template, and the template for being specific to target customer is generated according to the case data,
Reduce the consuming of workload and resource that template is established.
Step S42 exports dimension set interface, for user setting target dimension；
After obtaining template corresponding with the target customer or simultaneously, dimension set interface is exported, is set as user
The interface of target dimension is set, dimension set interface can be tabular form, and user can be by making marks in dimension list to set
Set dimension.In the present embodiment, target dimension is for filtering out target template from the corresponding template of target customer.
Step S43 receives target dimension, and target mould is obtained from the corresponding template of the target customer based on target dimension
Plate；
Each report template may include two and more than two dimensions, and target dimension is two and more than two dimensions
The dimension of composition combines.In the present embodiment, by establishing the corresponding different report templates of different dimensions, report generation step can be simplified
Suddenly.
Step S44, from obtained in the case data with each associated data of field in the target template, will be from described
The data obtained in case data export to the position of corresponding field, to generate target report.
In the present embodiment, the data source of target report is case data.Because case data and target template all with target
Client is corresponding, so, field corresponding with the field in target template is stored in case data, correspondence here, which is named, claims phase
Together, the identical corresponding field of title can be inquired according to the field number of packages on record in target template, number of packages on record is in, institute
There are data to be stored under the corresponding field storage location of field, thus case data can be associated with out according to the field in target template
The data stored under the field storage location of middle corresponding field.
In obtaining the target template after each associated data of field, the associated data of each field are filled to the mesh
The position of template corresponding field is marked, target report is generated.
Further, it is associated with described in step S44 from acquisition in the case data with each field in the target template
Data the step of include:
Step S441 obtains arbitrary first field in the target template, and obtains from the target template described
The corresponding efficient association field of first field；
Step S442 is based on first field and its corresponding efficient association field, screens from the case data
Out with the associated data of the first field.
When obtaining target data, arbitrary field in acquisition target template first, in present embodiment, for convenient for retouching
It states, using the arbitrary field as the first field, because there is multiple fields in target template, appoints in acquisition target template here
Meaning the first field and later the step of traversal target template in all fields.
For a report, the data of a field can not form significant complete report, such as: only client
Field does not have title of a cause field/case mode field/caseload/case processing time/committee's case time/client's time limit etc.
Other fields are combined with custom fields, can not form an effective report, thus for any one report or report
Table template always includes two or more field, and because includes multiple dimensions (or field) under field in case data
Data contain the case at all time points, all processing statuses for example, including all case information under client's A field, if
It is that can be associated with out many currently unwanted numbers of newly-built report institute according only to " client A " field associated data in target template
According to therefore, the corresponding efficient association field of the first field need to being obtained first and filtered out for screening the data under the first field
Data under first field needed for current newly-built report.
For example, report is for showing July in March-in target template, the quantity of the case type of A client and all types of cases,
Wherein, A client is the first field, then its efficient association field is time field (July in March -), case type, caseload, is led to
The efficient association field of the first field is crossed by A client March-July case type of case and all types of cases during this
Quantity screens.
The present embodiment from preset template library by obtaining template corresponding with the target customer；It exports dimension and circle is set
Face, for user setting target dimension；Target dimension is received, is obtained from the corresponding template of the target customer based on target dimension
Take target template；It, will be from the case from acquisition in the case data and each associated data of field in the target template
The data obtained in data export to the position of corresponding field, to generate target report, can set for different clients, multiple dimensions
Different report templates is set, when needing to carry out report generation, report template is called directly and generates report, can be poor according to client
Anisotropic demand is supplied to otherness, personalized report for client, promotes customer experience, meanwhile, the field in report template
Can auto-associating go out corresponding data, import data without artificial, human cost can be reduced, realize the fast automatic generation of report.
Further, include: after step S44
Step S45 obtains the target skin of skin template switching command direction when detecting skin template switching command
Skin template；
The purported skin template is suitable for the target report by step S46.
Targetedly to be shown, different for report show purpose, and the report of same data content is corresponding different
Show form or page format, in the present embodiment, after generating target report, determine different skins according to different displaying purposes
Skin template is shown, and skin template refers to the formatting layout template of corresponding different user, shows form tool for difference
There is different skin templates.Skin template can also can be selected with default setting by user.Refer to detecting that skin template switches
When enabling, report template is directly switched according to skin template switching command, is specifically included:
After user selectes skin template, skin is added to target report, generates final user's report.Skin template will
Target report is transformed to the form of the visible end user's report of user, shows for different objects (user or client or leader)
Report different appearance forms, have corresponding skin template；Optionally, the same target report can be with multiple skin moulds
Plate is corresponding, to generate various forms of final reports.
By the purported skin mould for when detecting skin template switching command, obtaining skin template switching command direction
Plate；The purported skin template is suitable for the report, so that report shows form, it can be according to user demand or report
It is different show purposes and change, obtain and have more specific aim, personalized report.
In addition, the present invention also provides a kind of data integration devices corresponding with each step of above-mentioned data integration method.
It is the functional block diagram of data integration device first embodiment of the present invention referring to Fig. 5, Fig. 5.
In the present embodiment, data integration device of the present invention includes:
Format judgment module 10, for obtaining when detecting Data Integration request, Data Integration request is corresponding to be led
Enter file, judges whether the importing file meets preset format；
Integrate module 20, if not meeting preset format for the importing file, according to preset rules import described in lead
Enter file, and the file destination obtained after importing is sent to back-end system, so that back-end system is raw based on the file destination
Precedent number of packages evidence；
Customer Acquisition module 30 for obtaining the case data, and obtains the corresponding target customer of the case data；
Report generation module 40, for obtaining template corresponding with the target customer, according to the template and the case
Data generate target report, and the target report is supplied to the target customer.
It is further, described to integrate module 20 further include:
Attributive analysis module for reading the data in the importing file, and determines target category corresponding to the data
Property；
Contrast module judges described default for comparing the objective attribute target attribute and the field in predetermined word phase library
It whether there is aiming field corresponding with the objective attribute target attribute in field storehouse；
Memory module, if for there is the aiming field corresponding with the objective attribute target attribute in the predetermined word phase library,
It, will be in the importing file then by the data storage in the importing file to the field storage location of the aiming field
Data are associated with aiming field.
Further, data integration device of the present invention includes:
Identify adding module, for it is described import file importing process in, for it is described import file file header and
All data add distinguishing identifier in the importing file；
Identifier acquisition module obtains the area for the data to be displayed that the idsplay order is directed toward when detecting idsplay order
Minute mark is known；
Display obtains module, for obtaining corresponding file header to be shown according to the distinguishing identifier, and waits showing according to this
Show that file header obtains corresponding field to be shown；
Display module, for showing the field to be shown.
Further, the report generation module 40 further include:
Module obtains module, for obtaining template corresponding with the target customer from preset template library；
Dimension setup module, for exporting dimension set interface, for user setting target dimension；
The module obtains module, is also used to receive target dimension, corresponding from the target customer based on target dimension
Target template is obtained in template；
The report generation module 40 is also used to close from acquisition in the case data and field each in the target template
The data obtained from the case data are exported to the position of corresponding field by the data of connection, to generate target report.
Further, the report generation module 40 further include:
Field obtains module, for obtaining arbitrary first field in the target template, and from the target template
Obtain the corresponding efficient association field of first field；
Data screening module, for being based on first field and its corresponding efficient association field, from the case number of packages
It is filtered out in and the associated data of the first field.
Further, the report generation module 40 further include:
First extraction module, for extracting keyword field from the case data, by all key word characters of extraction
The first set of fields of Duan Zuowei；
Second extraction module extracts second from the reference template for obtaining reference template from preset template library
Set of fields；
Module generation module, for establishing field between the first set of fields and the second set of fields according to user operation instruction
Fallback relationship, the field that the second set of fields is belonged in the reference template is substituted for by the first field according to the fallback relationship
Corresponding field in set, to generate the corresponding template of the target customer.
Further, data integration device of the present invention includes:
Skin treatment module obtains skin template switching command direction when detecting skin template switching command
Purported skin template；The purported skin template is suitable for the target report.
The present invention also proposes a kind of storage medium, is stored thereon with computer program.The storage medium can be Fig. 1's
Memory 20 in Data Integration terminal is also possible to such as ROM (Read-OnlyMemory, read-only memory)/RAM (Random
Access Memory, random access memory), magnetic disk, at least one of CD, the storage medium includes some instructions
With so that a terminal device with processor (can be mobile phone, computer, server, the network equipment or the present invention are real
Apply the Data Integration terminal etc. in example) execute method described in each embodiment of the present invention.
It should be noted that, in this document, the terms "include", "comprise" or its any other variant are intended to non-row
His property includes, so that the process, method, article or the server-side that include a series of elements not only include those elements,
It but also including other elements that are not explicitly listed, or further include for this process, method, article or server-side institute
Intrinsic element.In the absence of more restrictions, the element limited by sentence "including a ...", it is not excluded that wrapping
Include in process, method, article or the server-side of the element that there is also other identical elements.
The serial number of the above embodiments of the invention is only for description, does not represent the advantages or disadvantages of the embodiments.
Through the above description of the embodiments, those skilled in the art can be understood that above-described embodiment side
Method can be realized by means of software and necessary general hardware platform, naturally it is also possible to by hardware, but in many cases
The former is more preferably embodiment.
The above is only a preferred embodiment of the present invention, is not intended to limit the scope of the invention, all to utilize this hair
Equivalent structure or equivalent flow shift made by bright specification and accompanying drawing content is applied directly or indirectly in other relevant skills
Art field, is included within the scope of the present invention.
Claims (10)
1. a kind of data integration method, which is characterized in that the data integration method the following steps are included:
When detecting Data Integration request, obtains the Data Integration and request corresponding importing file, judge the importing file
Whether preset format is met；
If the importing file does not meet preset format, the importing file is imported according to preset rules, and obtain after importing
To file destination be sent to back-end system, for back-end system be based on the file destination generate case data；
The case data are obtained, and obtain the corresponding target customer of the case data；
Template corresponding with the target customer is obtained, target report is generated according to the template and the case data, and should
Target report is supplied to the target customer.
2. data integration method as described in claim 1, which is characterized in that described to import the importing text according to preset rules
The step of part includes:
The data in the importing file are read, and determine objective attribute target attribute corresponding to the data；
The objective attribute target attribute and the field in predetermined word phase library are compared, judge in the predetermined word phase library with the presence or absence of with
The corresponding aiming field of the objective attribute target attribute；
It, will be in the importing file if there is the aiming field corresponding with the objective attribute target attribute in the predetermined word phase library
Data storage to the aiming field field storage location, by it is described importing file in data and aiming field close
Connection.
3. data integration method as claimed in claim 1 or 2, which is characterized in that the data integration method includes:
In the importing process for importing file, for all data in the file header and the importing file for importing file
Add distinguishing identifier；
Include: after described the step of importing the importing file according to preset rules
When detecting idsplay order, the distinguishing identifier for the data to be displayed that the idsplay order is directed toward is obtained；
Corresponding file header to be shown is obtained according to the distinguishing identifier, and corresponding to aobvious according to file header acquisition to be shown
Show field；
The field to be shown is shown.
4. data integration method as described in claim 1, which is characterized in that described to obtain mould corresponding with the target customer
Plate, the step of generating target report according to the template and the case data include:
Template corresponding with the target customer is obtained from preset template library；
Dimension set interface is exported, for user setting target dimension；
Target dimension is received, target template is obtained from the corresponding template of the target customer based on target dimension；
From acquisition in the case data and each associated data of field in the target template, will be obtained from the case data
The data taken export to the position of corresponding field, to generate target report.
5. data integration method as claimed in claim 4, which is characterized in that it is described from the case data obtain with it is described
The step of each field associated data, includes: in target template
Arbitrary first field in the target template is obtained, and it is corresponding to obtain from the target template first field
Efficient association field；
Based on first field and its corresponding efficient association field, filtered out from the case data and first word
The associated data of section.
6. data integration method as claimed in claim 4, which is characterized in that described to obtain mould corresponding with the target customer
The step of plate includes:
Keyword field is extracted from the case data, using all keyword fields of extraction as the first set of fields；
Reference template is obtained from preset template library, the second set of fields is extracted from the reference template；
The fallback relationship that field between the first set of fields and the second set of fields is established according to user operation instruction, according to the replacement
The field for belonging to the second set of fields in the reference template is substituted for corresponding field in the first set of fields by relationship, with life
At the corresponding template of the target customer.
7. data integration method as claimed in claim 4, which is characterized in that the data by the case data export
To the position of corresponding field, the step of to generate target report after include:
When detecting skin template switching command, the purported skin template of skin template switching command direction is obtained；
The purported skin template is suitable for the target report.
8. a kind of data integration device, which is characterized in that the data integration device includes:
Format judgment module, for obtaining the Data Integration and requesting corresponding importing file when detecting Data Integration request,
Judge whether the importing file meets preset format；
Module is integrated, if not meeting preset format for the importing file, imports the importing file according to preset rules,
And the file destination obtained after importing is sent to back-end system, so that back-end system is based on the file destination generation case number of packages
According to；
Customer Acquisition module for obtaining the case data, and obtains the corresponding target customer of the case data；
Report generation module, it is raw according to the template and the case data for obtaining template corresponding with the target customer
The target customer is supplied at target report, and by the target report.
9. a kind of Data Integration terminal, which is characterized in that the Data Integration terminal includes processor, memory and storage
On the memory and the data integration program that can be executed by the processor, wherein the data integration program is by the place
When managing device and executing, the step of realizing data integration method as described in any one of claims 1 to 7.
10. a kind of storage medium, which is characterized in that data integration program is stored on the storage medium, wherein the data
When integrated process is executed by processor, the step of realizing data integration method as described in any one of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811137029.9A CN109657225A (en) | 2018-09-27 | 2018-09-27 | Data integration method, device, terminal and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811137029.9A CN109657225A (en) | 2018-09-27 | 2018-09-27 | Data integration method, device, terminal and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN109657225A true CN109657225A (en) | 2019-04-19 |
Family
ID=66110321
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811137029.9A Pending CN109657225A (en) | 2018-09-27 | 2018-09-27 | Data integration method, device, terminal and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109657225A (en) |
Cited By (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110309217A (en) * | 2019-05-30 | 2019-10-08 | 平安科技（深圳）有限公司 | Lead-in and lead-out method, device, terminal and the computer readable storage medium of data |
| CN111209324A (en) * | 2019-12-31 | 2020-05-29 | 航天信息股份有限公司 | Method and device for storing data, storage medium and electronic equipment |
| CN111400246A (en) * | 2020-03-26 | 2020-07-10 | 广州酷旅旅行社有限公司 | Asynchronous file importing method and device, computer equipment and storage medium |
| CN112364617A (en) * | 2020-10-29 | 2021-02-12 | 北京新锦成科技有限公司 | File information processing method and device, electronic equipment and storage medium |
| CN112785128A (en) * | 2021-01-07 | 2021-05-11 | 广州地铁集团有限公司 | System, method and equipment for evaluating advancement of rail transit network |
| CN112950086A (en) * | 2021-04-12 | 2021-06-11 | 中国民航管理干部学院 | Dynamic construction method and system for performance assessment index system of civil aviation enterprise and public institution |
| CN115174555A (en) * | 2022-06-28 | 2022-10-11 | 平安科技（深圳）有限公司 | File transmission method and device, electronic equipment and storage medium |
| CN115640952A (en) * | 2022-08-29 | 2023-01-24 | 格莱杰(深圳)科技有限公司 | Method and system for importing and uploading data |
| CN117520432A (en) * | 2023-11-30 | 2024-02-06 | 广州方舟信息科技有限公司 | Template-based data transmission method, device, equipment and storage medium |
| CN118170462A (en) * | 2024-05-14 | 2024-06-11 | 北京国专知识产权有限责任公司 | Mail sending method and device for case management system |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105446948A (en) * | 2015-11-13 | 2016-03-30 | 武汉鸿图节能技术有限公司 | Report automatic generation method and system |
| CN107391550A (en) * | 2017-06-06 | 2017-11-24 | 广东广业开元科技有限公司 | A kind of report form generation method and system based on big data mould plate technique |
| CN108132945A (en) * | 2016-12-01 | 2018-06-08 | 百度在线网络技术（北京）有限公司 | For generating the method and apparatus of report |
-
2018
- 2018-09-27 CN CN201811137029.9A patent/CN109657225A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105446948A (en) * | 2015-11-13 | 2016-03-30 | 武汉鸿图节能技术有限公司 | Report automatic generation method and system |
| CN108132945A (en) * | 2016-12-01 | 2018-06-08 | 百度在线网络技术（北京）有限公司 | For generating the method and apparatus of report |
| CN107391550A (en) * | 2017-06-06 | 2017-11-24 | 广东广业开元科技有限公司 | A kind of report form generation method and system based on big data mould plate technique |
Cited By (16)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110309217A (en) * | 2019-05-30 | 2019-10-08 | 平安科技（深圳）有限公司 | Lead-in and lead-out method, device, terminal and the computer readable storage medium of data |
| CN110309217B (en) * | 2019-05-30 | 2024-03-08 | 平安科技（深圳）有限公司 | Data import and export method and device, terminal and computer readable storage medium |
| CN111209324B (en) * | 2019-12-31 | 2023-11-28 | 航天信息股份有限公司 | Method and device for storing data, storage medium and electronic equipment |
| CN111209324A (en) * | 2019-12-31 | 2020-05-29 | 航天信息股份有限公司 | Method and device for storing data, storage medium and electronic equipment |
| CN111400246A (en) * | 2020-03-26 | 2020-07-10 | 广州酷旅旅行社有限公司 | Asynchronous file importing method and device, computer equipment and storage medium |
| CN111400246B (en) * | 2020-03-26 | 2023-12-19 | 广州酷旅旅行社有限公司 | Asynchronous file import method, device, computer equipment and storage medium |
| CN112364617A (en) * | 2020-10-29 | 2021-02-12 | 北京新锦成科技有限公司 | File information processing method and device, electronic equipment and storage medium |
| CN112785128A (en) * | 2021-01-07 | 2021-05-11 | 广州地铁集团有限公司 | System, method and equipment for evaluating advancement of rail transit network |
| CN112950086A (en) * | 2021-04-12 | 2021-06-11 | 中国民航管理干部学院 | Dynamic construction method and system for performance assessment index system of civil aviation enterprise and public institution |
| CN112950086B (en) * | 2021-04-12 | 2024-03-08 | 中国民航管理干部学院 | Dynamic construction method and system of performance assessment index system of civil aviation enterprise and public institution |
| CN115174555A (en) * | 2022-06-28 | 2022-10-11 | 平安科技（深圳）有限公司 | File transmission method and device, electronic equipment and storage medium |
| CN115640952B (en) * | 2022-08-29 | 2023-09-26 | 格莱杰(深圳)科技有限公司 | Method and system for importing and uploading data |
| CN115640952A (en) * | 2022-08-29 | 2023-01-24 | 格莱杰(深圳)科技有限公司 | Method and system for importing and uploading data |
| CN117520432A (en) * | 2023-11-30 | 2024-02-06 | 广州方舟信息科技有限公司 | Template-based data transmission method, device, equipment and storage medium |
| CN118170462A (en) * | 2024-05-14 | 2024-06-11 | 北京国专知识产权有限责任公司 | Mail sending method and device for case management system |
| CN118170462B (en) * | 2024-05-14 | 2024-07-12 | 北京国专知识产权有限责任公司 | Mail sending method and device for case management system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109657225A (en) | Data integration method, device, terminal and storage medium | |
| CN109657214A (en) | Report form generation method, device, terminal and storage medium | |
| CN104750737B (en) | A kind of photograph album management method and device | |
| CN109684047A (en) | Event-handling method, device, equipment and computer storage medium | |
| CN110443552B (en) | Method and device for automatically transmitting product main data information | |
| CN111401722B (en) | Intelligent decision method and intelligent decision system | |
| CN103164416A (en) | Identification method and device of user relationship | |
| CN101714231A (en) | Method and system for managing free workflow without being based on process models | |
| CN110321273A (en) | A kind of business statistical method and device | |
| CN111897890B (en) | Financial business processing method and device | |
| CN112541692B (en) | Scientific data management plan generation method and device | |
| CN109254817A (en) | Dial plate replacing method and system of wearable device and wearable device | |
| CN107133309A (en) | Storage, querying method and the device of flow instance, storage medium and electronic equipment | |
| WO2015125066A1 (en) | System and method for facilitating equipment maintenance using smartglasses | |
| CN108647235A (en) | A kind of data analysing method, equipment and medium based on data warehouse | |
| CN104272327B (en) | Job management method and management system | |
| CN109271561A (en) | A kind of profile information search method and device | |
| CN105989447A (en) | Data processing system, method and platform | |
| CN114942944A (en) | Training content generation and data processing method, device, equipment and storage medium | |
| CN110457010B (en) | Method and device for batch changing task list based on collaboration platform | |
| CN111709218A (en) | Intelligent reporting platform and intelligent reporting method based on dynamic multiple data sources | |
| CN103473306A (en) | Method and system for adopting structured query language (SQL) mark substitution method to achieve data self-extraction | |
| CN106888264A (en) | A kind of method for interchanging data and device | |
| EP3888767A1 (en) | A content aggregation system and method of operating thereof | |
| CN110728452A (en) | System and method for realizing selection control of multidimensional organization integration personnel in distributed flow system |
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 |