CN110019478B - Data import method, medium, device and apparatus - Google Patents
Data import method, medium, device and apparatus Download PDFInfo
- Publication number
- CN110019478B CN110019478B CN201711455321.0A CN201711455321A CN110019478B CN 110019478 B CN110019478 B CN 110019478B CN 201711455321 A CN201711455321 A CN 201711455321A CN 110019478 B CN110019478 B CN 110019478B
- Authority
- CN
- China
- Prior art keywords
- field
- header
- header field
- page
- 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.)
- Active
Links
Images
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/252—Integrating or interfacing systems involving database management systems between a Database Management System and a front-end application
-
- 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/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/95—Retrieval from the web
- G06F16/958—Organisation or management of web site content, e.g. publishing, maintaining pages or automatic linking
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)
- Computing Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Document Processing Apparatus (AREA)
Abstract
The invention discloses a data import method, a medium, a device and a device, wherein the method comprises the following steps: reading a header field of a form file; reading a header field of a page table; determining the corresponding relation between the header fields of the form file and the header fields of the page form according to the text information of the header fields; when a field which is not corresponding to the header field of the form file exists in the header field of the page form, receiving a corresponding relation between the field defined by a user and the header field of the form file; and copying the content under the header field of the form file to the header field of the page form corresponding to the header field. The invention can protect the content of each field in the data table from being accurately imported into the corresponding field of the page table, also provides a manual selection mode for a user, meets the control requirement of the user under special conditions, and also provides a function of editing the page table, so that the page table can completely contain the content of the data table.
Description
Technical Field
The present invention relates to the field of internet technologies, and in particular, to a data importing method, medium, device, and apparatus.
Background
When data structures in the same format are converted for data resources, header fields in different data structures are strictly required to be consistent to import data. In this case, the requirement for the user to import is higher, the fields of the form to be imported need to be strictly arranged, and if the fields are inconsistent or the sequence is disordered, a matching error condition occurs.
Disclosure of Invention
In order to solve the technical problem, the invention provides a data import method, a medium, a device and an apparatus.
The data import method provided by the invention comprises the following steps:
reading a header field of a form file;
reading a header field of a page table;
determining the corresponding relation between the header fields of the form file and the header fields of the page form according to the text information of the header fields;
when a field which is not corresponding to the header field of the form file exists in the header field of the page form, receiving a corresponding relation between the field defined by a user and the header field of the form file;
and copying the content under the header field of the form file to the header field of the page form corresponding to the header field.
The data importing method also has the following characteristics:
determining the corresponding relationship between the header fields of the form file and the header fields of the page form according to the text information of the header fields comprises:
and when the similarity between the text information of the header field of the form file and the text information of the header field of the page form is greater than a preset threshold value, determining that the header field of the form file and the header field of the page form have a corresponding relationship.
The data importing method also has the following characteristics:
the receiving the user-defined correspondence between this field and the header field of the form file includes: providing a user interactive interface, displaying a header field of the page table and a header field of the table file on the interactive interface, or displaying a field which is not corresponding to the header field of the table file in the header field of the page table and a field which is not corresponding to the header field of the page table in the header field of the table file on the interactive interface, displaying a control for receiving a corresponding relation input by a user on the interactive interface, and receiving the corresponding relation defined by the user between the field and the header field of the table file from the control.
The data importing method also has the following characteristics:
the method further comprises the following steps: and when the number of the header fields of the form file is greater than that of the page table, creating a new field on the page table, wherein the number of the new field is the difference between the number of the header fields of the form file and the number of the header fields of the page table, and the name of the new field is the name of a field which is not corresponding to the header fields of the page table in the header fields of the form file.
The present invention provides a computer readable storage medium having stored thereon a computer program which, when executed by a processor, performs the steps of the above method.
The invention provides computer equipment which comprises a memory, a processor and a computer program which is stored on the memory and can run on the processor, wherein the processor realizes the steps of the method when executing the program.
The data importing device provided by the invention comprises:
the first reading module is used for reading a header field of the form file;
the second reading module is used for reading a header field of the page table;
the corresponding relation determining module is used for determining the corresponding relation between the header fields of the form files and the header fields of the page forms according to the text information of the header fields;
the first judging module is used for judging whether a field which is not corresponding to the header field of the form file exists in the header field of the page form;
a receiving module, configured to receive, when a field that does not correspond to a header field of the form file exists in the header field of the page form, a correspondence relationship between the field and the header field of the form file, which is defined by a user;
and the import module is used for copying the content under the header field of the form file to the header field of the page form corresponding to the header field.
The data importing device also has the following characteristics:
the corresponding relation determining module is used for determining the corresponding relation between the header fields of the form file and the page form by using the following method: and when the similarity between the text information of the header field of the form file and the text information of the header field of the page form is greater than a preset threshold value, determining that the header field of the form file and the header field of the page form have a corresponding relationship.
The data importing device also has the following characteristics:
the receiving module comprises an interaction control unit and a receiving unit;
the interactive control unit is configured to display, on the interactive interface, a header field of the page table and a header field of the table file, or display, on the interactive interface, a field that is not corresponding to the header field of the table file in the header field of the page table and a field that is not corresponding to the header field of the page table in the header field of the table file, and display, on the interactive interface, a control for receiving a correspondence relationship input by a user;
and the receiving unit is used for receiving the corresponding relation between the field defined by the user and the header field of the form file from the control.
The data importing device also has the following characteristics:
the system also comprises a second judgment module and a page control module;
the second judging module is used for judging whether the number of the header fields of the form file is greater than that of the page form;
the page control module is configured to create a new field on the page table when the number of the header fields of the table file is greater than the number of the header fields of the page table, where the number of the new field is a difference between the number of the header fields of the table file and the number of the header fields of the page table, and the name of the new field is a name of a field that is not corresponding to the header field of the page table in the header fields of the table file.
The invention can protect the content of each field in the data table from being accurately imported into the corresponding field of the page table, also provides a manual selection mode for a user, meets the control requirement of the user under special conditions, and also provides a function of editing the page table, so that the page table can completely contain the content of the data table.
Drawings
The accompanying drawings, which are incorporated in and constitute a part of this specification, illustrate an embodiment of the invention and, together with the description, serve to explain the invention and not to limit the invention. In the drawings:
FIG. 1 is a flowchart of a data import method in an embodiment;
fig. 2 is a structural diagram of a data import apparatus in the embodiment.
Detailed Description
In order to make the objects, technical solutions and advantages of the embodiments of the present invention clearer, the technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are some, but not all, embodiments of the present invention. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention. It should be noted that the embodiments and features of the embodiments in the present application may be arbitrarily combined with each other without conflict.
FIG. 1 is a flowchart of a data importing method in an embodiment, where the method includes:
step 101, reading a header field of a form file;
step 102, reading a header field of a page table;
103, determining the corresponding relation between the header fields of the form file and the header fields of the page form according to the text information of the header fields;
104, when a field which is not corresponding to the header field of the form file exists in the header field of the page form, receiving a corresponding relation between the field defined by a user and the header field of the form file;
and 105, copying the content under the header field of the form file to the header field of the page form corresponding to the header field.
Wherein the content of the first and second substances,
determining the corresponding relationship between the header field of the form file and the header field of the page form according to the text information of the header field in step 103 includes: and when the similarity between the text information of the header field of the table file and the text information of the header field of the page table is greater than a preset threshold value, determining that the header field of the table file and the header field of the page table have a corresponding relation. For example, if the preset threshold is 80%, the text information in the header field is the server identifier I D, the text information in the header field of the page table is the server identifier, and the similarity between the two is determined to be greater than 80% according to the text content similarity determination method, it may be determined that the header field of the table file and the header field of the page table have a corresponding relationship.
Receiving the user-defined correspondence between this field and the header field of the form file in step 104 includes: providing a user interactive interface, displaying a header field of a page table and a header field of a table file on the interactive interface, or displaying a field which is not corresponding to the header field of the table file in the header field of the page table and a field which is not corresponding to the header field of the page table in the header field of the table file on the interactive interface, displaying a control for receiving a corresponding relation input by a user on the interactive interface, and receiving the corresponding relation defined by the user between the field and the header field of the table file from the control.
In addition to the above steps 101 to 105, the method further includes step 106: and when the number of the header fields of the table file is greater than that of the page table, creating a new field on the page table, wherein the number of the new field is the difference between the number of the header fields of the table file and the number of the header fields of the page table, and the name of the new field is the name of a field which is not corresponding to the header fields of the page table in the header fields of the table file.
Embodiments of the present invention further provide a computer-readable storage medium, on which a computer program is stored, where the computer program, when executed by a processor, implements the steps of the above-mentioned method.
The embodiment of the invention also provides computer equipment which comprises a memory, a processor and a computer program which is stored on the memory and can run on the processor, wherein the steps of the method are realized when the processor executes the program.
FIG. 2 is a block diagram of an embodiment of a data import apparatus for a data table to a page table, the apparatus including:
the first reading module is used for reading a header field of the form file;
the second reading module is used for reading a header field of the page table;
the corresponding relation determining module is used for determining the corresponding relation between the header fields of the form files and the header fields of the page forms according to the text information of the header fields;
the first judgment module is used for judging whether a field which is not corresponding to the header field of the form file exists in the header field of the page form;
the receiving module is used for receiving the corresponding relation between a field defined by a user and a header field of a table file when the header field of the page table has the field which is not corresponding to the header field of the table file;
and the import module is used for copying the content under the header field of the form file to the header field of the page form corresponding to the header field.
Wherein the content of the first and second substances,
the corresponding relation determining module is used for determining the corresponding relation between the header fields of the form file and the page form by using the following method: and when the similarity between the text information of the header field of the table file and the text information of the header field of the page table is greater than a preset threshold value, determining that the header field of the table file and the header field of the page table have a corresponding relation.
Wherein the content of the first and second substances,
the receiving module comprises an interactive control unit and a receiving unit;
the interactive control unit is used for displaying a header field of the page form and a header field of the form file on the interactive interface, or displaying a field which is not corresponding to the header field of the form file in the header field of the page form and a field which is not corresponding to the header field of the page form in the header field of the form file on the interactive interface, and displaying a control for receiving the corresponding relation input by the user on the interactive interface;
the receiving unit is used for receiving the corresponding relation between the field defined by the user and the header field of the form file from the control.
The device also comprises a second judgment module and a page control module.
The second judging module is used for judging whether the number of the header fields of the form file is greater than that of the page form;
the page control module is used for creating a new field on the page table when the number of the header fields of the table file is greater than that of the page table, wherein the number of the new field is the difference between the number of the header fields of the table file and the number of the header fields of the page table, and the name of the new field is the name of a field which is not corresponding to the header fields of the page table in the header fields of the table file.
The invention can protect the content of each field in the data table from being accurately imported into the corresponding field of the page table, also provides a manual selection mode for a user, meets the control requirement of the user under special conditions, and also provides a function of editing the page table, so that the page table can completely contain the content of the data table.
The above-described aspects may be implemented individually or in various combinations, and such variations are within the scope of the present invention.
It will be understood by those skilled in the art that all or part of the steps of the above methods may be implemented by instructing the relevant hardware through a program, and the program may be stored in a computer readable storage medium, such as a read-only memory, a magnetic or optical disk, and the like. Alternatively, all or part of the steps of the foregoing embodiments may also be implemented by using one or more integrated circuits, and accordingly, each module/unit in the foregoing embodiments may be implemented in the form of hardware, and may also be implemented in the form of a software functional module. The present invention is not limited to any specific form of combination of hardware and software.
It is to be noted that, in this document, the terms "comprises", "comprising" or any other variation thereof are intended to cover a non-exclusive inclusion, so that an article or apparatus including a series of elements includes not only those elements but also other elements not explicitly listed or inherent to such article or apparatus. Without further limitation, an element defined by the phrase "comprising … …" does not exclude the presence of additional like elements in the article or device comprising the element.
The above embodiments are merely to illustrate the technical solutions of the present invention and not to limit the present invention, and the present invention has been described in detail with reference to the preferred embodiments. It will be understood by those skilled in the art that various modifications and equivalent arrangements may be made without departing from the spirit and scope of the present invention and it should be understood that the present invention is to be covered by the appended claims.
Claims (9)
1. A data import method, comprising:
reading a header field of a form file;
reading a header field of a page table;
determining the corresponding relation between the header fields of the form file and the header fields of the page form according to the text information of the header fields;
when the similarity between the text information of the header field of the form file and the text information of the header field of the page form is greater than a preset threshold value, determining that the header field of the form file and the header field of the page form have a corresponding relationship;
when a field which is not corresponding to the header field of the form file exists in the header field of the page form, receiving a corresponding relation between the field defined by a user and the header field of the form file;
and copying the content under the header field of the form file to the header field of the page form corresponding to the header field.
2. The data import method of claim 1,
the receiving the user-defined correspondence between this field and the header field of the form file includes: providing a user interactive interface, displaying a header field of the page table and a header field of the table file on the interactive interface, or displaying a field which is not corresponding to the header field of the table file in the header field of the page table and a field which is not corresponding to the header field of the page table in the header field of the table file on the interactive interface, displaying a control for receiving a corresponding relation input by a user on the interactive interface, and receiving the corresponding relation defined by the user between the field and the header field of the table file from the control.
3. The data import method of claim 1,
the method further comprises the following steps: and when the number of the header fields of the form file is greater than that of the page table, creating a new field on the page table, wherein the number of the new field is the difference between the number of the header fields of the form file and the number of the header fields of the page table, and the name of the new field is the name of a field which is not corresponding to the header fields of the page table in the header fields of the form file.
4. A computer-readable storage medium, on which a computer program is stored which, when being executed by a processor, carries out the steps of the method according to any one of claims 1 to 3.
5. A computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, the processor implementing the steps of the method of any one of claims 1 to 3 when executing the program.
6. A data importing apparatus, comprising:
the first reading module is used for reading a header field of the form file;
the second reading module is used for reading a header field of the page table;
the corresponding relation determining module is used for determining the corresponding relation between the header fields of the form files and the header fields of the page forms according to the text information of the header fields;
the first judging module is used for judging whether a field which is not corresponding to the header field of the form file exists in the header field of the page form;
a receiving module, configured to receive, when a field that does not correspond to a header field of the form file exists in the header field of the page form, a correspondence relationship between the field and the header field of the form file, which is defined by a user;
and the import module is used for copying the content under the header field of the form file to the header field of the page form corresponding to the header field.
7. The data import apparatus of claim 6,
the corresponding relation determining module is used for determining the corresponding relation between the header fields of the form file and the page form by using the following method: and when the similarity between the text information of the header field of the form file and the text information of the header field of the page form is greater than a preset threshold value, determining that the header field of the form file and the header field of the page form have a corresponding relationship.
8. The data import apparatus of claim 6,
the receiving module comprises an interaction control unit and a receiving unit;
the interactive control unit is configured to display, on the interactive interface, a header field of the page table and a header field of the table file, or display, on the interactive interface, a field that is not corresponding to the header field of the table file in the header field of the page table and a field that is not corresponding to the header field of the page table in the header field of the table file, and display, on the interactive interface, a control for receiving a correspondence relationship input by a user;
and the receiving unit is used for receiving the corresponding relation between the field defined by the user and the header field of the form file from the control.
9. The data import apparatus of claim 6,
the system also comprises a second judgment module and a page control module;
the second judging module is used for judging whether the number of the header fields of the form file is greater than that of the page form;
the page control module is configured to create a new field on the page table when the number of the header fields of the table file is greater than the number of the header fields of the page table, where the number of the new field is a difference between the number of the header fields of the table file and the number of the header fields of the page table, and the name of the new field is a name of a field that is not corresponding to the header field of the page table in the header fields of the table file.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711455321.0A CN110019478B (en) | 2017-12-28 | 2017-12-28 | Data import method, medium, device and apparatus |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711455321.0A CN110019478B (en) | 2017-12-28 | 2017-12-28 | Data import method, medium, device and apparatus |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110019478A CN110019478A (en) | 2019-07-16 |
| CN110019478B true CN110019478B (en) | 2020-04-03 |
Family
ID=67187090
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201711455321.0A Active CN110019478B (en) | 2017-12-28 | 2017-12-28 | Data import method, medium, device and apparatus |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110019478B (en) |
Families Citing this family (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112883088B (en) * | 2019-11-29 | 2023-01-31 | 贵州白山云科技股份有限公司 | Data processing method, device, equipment and storage medium |
| CN111026718A (en) * | 2019-12-11 | 2020-04-17 | 广州地铁集团有限公司 | Technical method for analyzing excel file of rail transit engineering cost achievement |
| CN111563366A (en) * | 2020-04-29 | 2020-08-21 | 维沃移动通信有限公司 | Document processing method and device and electronic equipment |
| CN111782650B (en) * | 2020-06-28 | 2024-04-05 | 京东科技控股股份有限公司 | Dynamic data warehousing method and device, electronic equipment and storage medium |
| CN112395415B (en) * | 2020-11-02 | 2024-04-02 | 深圳市金蝶天燕云计算股份有限公司 | Report classification method, device, computer equipment and storage medium |
| CN112465618A (en) * | 2020-12-22 | 2021-03-09 | 航天信息股份有限公司企业服务分公司 | Universal importing method and system for bank statement |
| CN112597927A (en) * | 2020-12-28 | 2021-04-02 | 电子科技大学 | Two-dimensional table identification method, device, equipment and system |
| CN113902267A (en) * | 2021-09-23 | 2022-01-07 | 携程旅游网络技术（上海）有限公司 | Method, system, electronic device and medium for managing schedule |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103324731A (en) * | 2013-06-28 | 2013-09-25 | 中国农业银行股份有限公司 | Method and device for converting spreadsheet file into web format file |
| CN104317901A (en) * | 2014-10-24 | 2015-01-28 | 中国建设银行股份有限公司 | Data importing method and device |
| CN106250472A (en) * | 2016-07-29 | 2016-12-21 | 广州仕邦人力资源有限公司 | A kind of EXCEL data lead-in method |
| CN107203627A (en) * | 2017-05-27 | 2017-09-26 | 山东浪潮通软信息科技有限公司 | The method of mutual phase transformation between a kind of structural data and Word document |
-
2017
- 2017-12-28 CN CN201711455321.0A patent/CN110019478B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103324731A (en) * | 2013-06-28 | 2013-09-25 | 中国农业银行股份有限公司 | Method and device for converting spreadsheet file into web format file |
| CN104317901A (en) * | 2014-10-24 | 2015-01-28 | 中国建设银行股份有限公司 | Data importing method and device |
| CN106250472A (en) * | 2016-07-29 | 2016-12-21 | 广州仕邦人力资源有限公司 | A kind of EXCEL data lead-in method |
| CN107203627A (en) * | 2017-05-27 | 2017-09-26 | 山东浪潮通软信息科技有限公司 | The method of mutual phase transformation between a kind of structural data and Word document |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110019478A (en) | 2019-07-16 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110019478B (en) | Data import method, medium, device and apparatus | |
| CN108153551B (en) | Method and device for displaying business process page | |
| CN108292231B (en) | Method and system for generating applications from data | |
| CN108427731B (en) | Page code processing method and device, terminal equipment and medium | |
| CN109492152B (en) | Method, device, computer equipment and storage medium for pushing custom content | |
| US20140173408A1 (en) | Identity based automated form filling | |
| CN108804452B (en) | Multimedia resource cover display method and device | |
| US20150347353A1 (en) | Document layering platform | |
| WO2014075189A1 (en) | Dynamically re-skinning a web user interface | |
| US20170132001A1 (en) | Code based configuration of mobile devices | |
| CN103324892A (en) | File display method and device of Android system | |
| US10659567B2 (en) | Dynamic discovery and management of page fragments | |
| US9792527B2 (en) | Automated slide comparator | |
| CN105989126A (en) | Webpage displaying method and device | |
| CN110427496B (en) | Knowledge graph expansion method and device for text processing | |
| CN104361094A (en) | Storage method and device for file in search result, and browser client | |
| JP6596848B2 (en) | Access right estimation apparatus and access right estimation program | |
| CN107608947B (en) | HTML file processing method and device and electronic equipment | |
| CN108197961B (en) | User management method and device | |
| US11138273B2 (en) | Onboarding services | |
| CN108170408B (en) | JS object definition generation method and device | |
| CN112527289A (en) | Dynamic form system based on Golang and Mongodb | |
| CN110554915A (en) | Information processing method and device, computer storage medium and terminal | |
| CN115357604B (en) | Data query method and device | |
| CN112015411B (en) | Education application interface configuration method and device based on SAAS and readable storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |