CN113094345A - Method and equipment for importing table data file - Google Patents
Method and equipment for importing table data file Download PDFInfo
- Publication number
- CN113094345A CN113094345A CN202110407267.2A CN202110407267A CN113094345A CN 113094345 A CN113094345 A CN 113094345A CN 202110407267 A CN202110407267 A CN 202110407267A CN 113094345 A CN113094345 A CN 113094345A
- Authority
- CN
- China
- Prior art keywords
- template
- import
- data file
- imported
- importing
- 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
- 238000000034 method Methods 0.000 title claims abstract description 46
- 230000008676 import Effects 0.000 claims abstract description 135
- 238000013499 data model Methods 0.000 claims abstract description 26
- 238000012937 correction Methods 0.000 claims description 7
- 230000006870 function Effects 0.000 description 8
- 238000012545 processing Methods 0.000 description 4
- 238000011161 development Methods 0.000 description 3
- 230000008569 process Effects 0.000 description 3
- 238000010586 diagram Methods 0.000 description 2
- 238000005516 engineering process Methods 0.000 description 2
- 239000000284 extract Substances 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 238000007726 management method Methods 0.000 description 1
- 230000000750 progressive effect Effects 0.000 description 1
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/10—File systems; File servers
- G06F16/17—Details of further file system functions
- G06F16/172—Caching, prefetching or hoarding of files
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/10—File systems; File servers
- G06F16/16—File or folder operations, e.g. details of user interfaces specifically adapted to file systems
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Human Computer Interaction (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The application discloses a method and equipment for importing a table data file, which are used for solving the technical problems that in the prior art, the implementation cost is high when an importing function is developed aiming at data in different formats, and the efficiency and the accuracy are low when the data are manually recorded. The method comprises the following steps: respectively constructing corresponding data models aiming at different types of table data files, configuring corresponding import templates and constructing a template library; acquiring key characteristics of a table data file to be imported based on a data model; according to key features, automatically matching a corresponding import template from the pre-configured template library to serve as a template to be selected; correcting the template to be selected according to the key characteristics; and importing the form data file to be imported into the target business system according to the corrected template to be selected. According to the method, manual input is replaced, the implementation cost is reduced, and the import efficiency and accuracy are improved.
Description
Technical Field
The present application relates to the field of data processing technologies, and in particular, to a method and an apparatus for importing a table data file.
Background
With the development of information technology, the efficiency of daily work is remarkably improved by a computer.
In general, an enterprise imports an Excel file provided by a client into a system, so that reference processing is facilitated. However, for labor-intensive enterprises, due to the fact that the types of customers are large and the informatization levels are different, business orders provided by the customers through Excel files are various in format and content, some business orders are manually made, and some business orders are exported through a business system of the business orders.
At present, in order to import Excel files with different formats and contents into an ERP service system of an enterprise and facilitate consulting management, the following two modes are mainly selected: firstly, developing a corresponding data import function aiming at data in different formats; and secondly, processing is carried out by adopting a manual input mode. However, the two methods are not only high in implementation cost, but also low in efficiency and accuracy of data processing.
Disclosure of Invention
The embodiment of the application provides a method and equipment for importing a table data file, which are used for solving the technical problems that in the prior art, the implementation cost is high when an import function is developed for data in different formats, and the efficiency and the accuracy are low when the data are manually imported.
In one aspect, an embodiment of the present application provides a method for importing a table data file, including: respectively constructing corresponding data models aiming at different types of table data files, configuring corresponding import templates and constructing a template library; acquiring key features of a table data file to be imported based on the data model; according to the key features, automatically matching a corresponding import template from the pre-configured template library to serve as a template to be selected; correcting the template to be selected according to the key characteristics; and importing the form data file to be imported into a target service system according to the corrected template to be selected.
In an implementation manner of the present application, for different types of table data files, corresponding data models are respectively constructed, which specifically includes: determining the position of a field name in a table data file and the field value of an adjacent cell according to the designated field, and constructing the key characteristics of the table data file; and respectively constructing corresponding data models according to the key characteristics of the different types of table data files.
In an implementation manner of the present application, according to the key features, automatically matching a corresponding import template from the pre-configured template library, where the import template is used as a template to be selected, specifically including: matching the key features with the imported templates in the template library respectively, and calculating the matching rate; determining the import template with the highest matching rate from a plurality of import templates with the matching rate larger than a first preset value as a template to be selected; and under the condition that no import template with the matching rate larger than a first preset value exists, reconfiguring the corresponding import template according to the table data file to be imported.
In an implementation manner of the present application, in the absence of an import template having a matching rate greater than a first preset value, reconfiguring a corresponding import template according to the to-be-imported form data file, specifically including: and determining the field name of the appointed field in the table data file, the position of the field name and the field value of the adjacent cell according to the key characteristics of the table data file to be imported, and configuring a corresponding import template.
In an implementation manner of the present application, determining an import template with a highest matching rate from a plurality of import templates with matching rates greater than a first preset value, and after the import template is used as a template to be selected, further including: under the condition that the matching rate of the template to be selected is greater than a second preset value, correcting the import template to be selected according to the key features; and under the condition that the matching rate of the template to be selected is not greater than a second preset value, re-matching the corresponding import template.
In one implementation manner of the present application, the method further includes: determining the integrity of the key features of the form data file to be imported according to the attributes of the template to be selected; and sending a correction prompt to a corresponding user when the integrity of the key features is wrong.
In an implementation manner of the present application, importing the form data file to be imported into a target service system according to the template to be selected after the completion of the correction specifically includes: extracting data in the table data file to be imported based on the corrected template to be selected to form a data result set; according to the corrected template to be selected, importing the data in the data result set into a target service system; and storing the Internet protocol address, the business operation type and the import template corresponding to the table data file to be imported into a database as import records.
In one implementation manner of the present application, the method further includes: determining an import record matched with other table data files to be imported in the database according to the Internet protocol addresses and the service operation types corresponding to the other table data files to be imported; and importing the other form data files to be imported into the target business system according to the import template in the matched import record.
In one implementation manner of the present application, the method further includes: determining whether an import template corresponding to the table data file to be imported exists in the template library according to the import record; and updating the import template to the template library under the condition that the import template corresponding to the table data file to be imported does not exist.
On the other hand, an embodiment of the present application further provides an import apparatus for a table data file, where the import apparatus includes: a processor; and a memory having executable code stored thereon, the executable code, when executed, causing the processor to perform a method of importing a tabular data file as described above.
The embodiment of the application provides a method and equipment for importing a table data file, which at least have the following beneficial effects: aiming at different types of table data files, corresponding data models are built, corresponding import templates are configured, and a template library is built, so that data with different formats are imported into a target service system according to the corresponding import templates, repeated development is not needed, and the implementation cost of a data import function is reduced; acquiring key features of a data file to be imported based on the data model so as to match a corresponding import template from the template library according to the key features, thereby improving the efficiency of data import; and correcting the template to be selected according to the key characteristics, thereby fully ensuring the accuracy of data import. And the Internet protocol address, the business operation type and the import template corresponding to the table data file to be imported are used as import records and stored in the database, so that other table data files to be imported determine the import records matched with the Internet protocol address and the business operation type in the database according to the Internet protocol address and the business operation type of the other table data files to be imported, and the other table data files to be imported are imported into the target business system according to the import templates in the import records, thereby avoiding the repeated determination of the import templates when the same user performs the same business operation, saving the time of repeated operation and improving the efficiency of data import.
Drawings
The accompanying drawings, which are included to provide a further understanding of the application and are incorporated in and constitute a part of this application, illustrate embodiment(s) of the application and together with the description serve to explain the application and not to limit the application. In the drawings:
fig. 1 is a flowchart of an importing method of a tabular data file according to an embodiment of the present disclosure;
fig. 2 is a schematic structural diagram of an importing device for a tabular data file according to an embodiment of the present application.
Detailed Description
In order to make the objects, technical solutions and advantages of the present application more apparent, the technical solutions of the present application will be described in detail and completely with reference to the following specific embodiments of the present application and the accompanying drawings. It should be apparent that the described embodiments are only some of the embodiments of the present application, and not all of the embodiments. 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 application.
The embodiment of the application provides a method and equipment for importing table data files, wherein corresponding data models are built for different types of table data files, corresponding import templates are configured, a template library is built, key features of the table data files to be imported are obtained according to the data models, and the corresponding import templates are matched from the template library according to the key features, so that the technical problems that in the prior art, the implementation cost is high when an import function is developed for data in different formats, and the efficiency and the accuracy are low when the import function is manually recorded are solved.
The technical solutions proposed in the embodiments of the present application are described in detail below with reference to the accompanying drawings.
Fig. 1 is a flowchart of an importing method of a tabular data file according to an embodiment of the present application. As shown in fig. 1, the method for importing a table data file provided in the embodiment of the present application mainly includes the following steps:
s101, aiming at different types of table data files, respectively constructing corresponding data models, configuring corresponding import templates, and constructing a template library.
The server respectively constructs data models corresponding to the types of the table data files according to the different types of the table data files, respectively configures import templates corresponding to the types of the table data files, and then constructs a template library according to the configured import templates. The table data file contains field information and data types, and the data model is used for describing the data structure of the table data file. By the method, the defect that the traditional data import function can only respectively develop corresponding data import functions aiming at data in different formats when facing the data in different formats is overcome, and therefore the implementation cost of data import is reduced.
In one embodiment of the application, the server specifies a field according to a business operation type corresponding to the table data file, and determines a position of a field name of the specified field and a field value corresponding to a cell adjacent to the field name in the table data file, so as to construct a key feature of the table data file. And the server respectively constructs corresponding data models according to the key characteristics of the different types of table data files. Therefore, the data structure of the form data file can be clearer, the data model corresponding to the same business operation type can be reused, and data can be imported more conveniently and time-saving.
Specifically, the server determines a required field according to a requirement corresponding to the service operation type, determines the position of the required field and the value of the field in the adjacent cell of the required field in the table data file, takes the position as a key feature, and then respectively constructs data models corresponding to the key feature according to the key feature of various types of table data files.
And S102, acquiring key features of the table data file to be imported based on the data model.
The server reads the table data file to be imported, and extracts the position of the field name of each field in the table data file and the field values of the adjacent cells. And then, the server acquires key features to be imported into the table data files based on the pre-constructed data models corresponding to the different types of table data files. Since the key features include the position of the field name of the specified field in the table data file and the field values of the adjacent cells, the server acquires the position of the field name of the specified field in the table data file to be imported and the field values of the adjacent cells.
And S103, automatically matching a corresponding import template from the pre-configured template library according to the key characteristics to be used as a template to be selected.
The server automatically matches an import template corresponding to the key features of the current form data file from a pre-configured template library according to the key features of the form data file, and uses the import template as a template to be selected, so that the efficiency of data import can be improved, and the accuracy of data import can be ensured.
In an embodiment of the application, the server matches the key features of the obtained tabular data file with import templates in a pre-configured template library respectively, and calculates the matching rate of the key features of the current tabular data file and each type of import templates respectively. And under the condition that the matching rate is greater than a first preset value in the calculated matching rates, the server determines the import template with the highest matching rate from the import templates with the matching rate greater than the first preset value, and uses the import template as the template to be selected. And under the condition that the import templates larger than the first preset value do not exist in the calculated matching rates, reconfiguring the corresponding import templates according to the current form data file.
In an embodiment of the application, in the case that an import template larger than a first preset value does not exist in the calculated matching rates, the server determines, according to key features of the to-be-imported form data file, a position of a field name of a designated field and a field value corresponding to a cell adjacent to the field name in the to-be-imported form data file, so as to configure an import template corresponding to the current key features.
And S104, correcting the template to be selected according to the key characteristics.
The server corrects the template to be selected according to the key characteristics of the form data file to be imported, so that the template can be imported sufficiently and reasonably, and the accuracy of data import is improved.
In an embodiment of the application, the server determines the import template with the highest matching rate from the import templates with the matching rate larger than the first preset value, and after the import template is used as the template to be selected, determines that the matching rate of the current template to be selected is larger than the second preset value, so that the deviation in the template to be selected can be corrected according to the key features of the form data file to be imported. And under the condition that the matching rate of the template to be selected is not greater than a second preset value, the corresponding import template is matched again through an algorithm.
Specifically, the template to be selected is simply corrected when the matching rate is greater than the second preset value, so that the accuracy of the template to be selected is ensured, and the corresponding import template is matched again when the matching rate is less than the second preset value, so that the overlarge difference between the form data file and the import template is avoided. And the time spent on adjusting the contents of the template to be selected is saved.
In an embodiment of the application, the server may further determine, according to an attribute of the template to be selected, integrity of the key feature of the tabular data file to be imported, and send a correction instruction to a corresponding user when it is determined that the integrity of the key feature of the tabular data file is incorrect, so that the user corrects the tabular data file for the key feature of the tabular data file, thereby ensuring correctness of the tabular data file to be imported.
For example, the server compares the attribute of the template to be selected with the key feature of the form data file to be imported, so as to determine whether the key feature of the form data file to be imported is complete, and sends correction prompt information to the user corresponding to the form data file to be imported under the condition that the key feature of the form data file to be imported is determined to be missing or incomplete, so that the corresponding user can correct the key feature in the form data file timely and accurately, so that the key feature in the form data file is matched with the imported template after correction is completed, and the completeness and correctness of data import are ensured.
And S105, importing the form data file to be imported into a target service system according to the corrected template to be selected.
And the server imports the form data file to be imported into the target service system according to the corrected template to be selected.
In an embodiment of the application, the server extracts data to be imported into the form data file based on the corrected template to be selected to form a data result set, so that the server imports the data in the data result set into the target service system according to the corrected template to be selected. In addition, the server stores the Internet protocol address corresponding to the form data file to be imported, the type of the business operation and the corrected import template as import records in the database, so that the same user can conveniently and directly obtain the import template according to the same type of business operation.
In an embodiment of the application, the server determines whether a current user exists in an import record of the database according to an internet protocol address corresponding to another form data file to be imported, and determines whether a current user performs a service operation of a current service type in the import record of the database according to a service operation type corresponding to another form data file to be imported on the basis. And when determining that the database has an import record matched with the current other table data files to be imported, importing the current other table data files to be imported into the target business system according to the import template in the matched import record. By the method, the server is prevented from repeatedly matching and importing the template for the same user when the same user performs the same type of business operation, so that the time of repeated operation is saved, and the efficiency of data import is improved.
In an embodiment of the application, the server determines an import template corresponding to a table data file to be imported currently in an import record according to the table data file to be imported, and determines whether the import template exists from a pre-configured template library according to the import template. And under the condition that the import template corresponding to the current table data file to be imported does not exist, updating the import template into the template library, so that the template library import template is richer and more comprehensive.
The embodiment of the application provides a method and equipment for importing table data files, aiming at different types of table data files, corresponding data models are built, corresponding import templates are configured, and a template library is built, so that data with different formats are imported into a target service system according to the corresponding import templates, repeated development is not needed, and the implementation cost of a data import function is reduced; acquiring key features of a data file to be imported based on the data model so as to match a corresponding import template from the template library according to the key features, thereby improving the efficiency of data import; and correcting the template to be selected according to the key characteristics, thereby fully ensuring the accuracy of data import. And the Internet protocol address, the business operation type and the import template corresponding to the table data file to be imported are used as import records and stored in the database, so that other table data files to be imported determine the import records matched with the Internet protocol address and the business operation type in the database according to the Internet protocol address and the business operation type of the other table data files to be imported, and the other table data files to be imported are imported into the target business system according to the import templates in the import records, thereby avoiding the repeated determination of the import templates when the same user performs the same business operation, saving the time of repeated operation and improving the efficiency of data import.
The above is the method embodiment proposed by the present application. Based on the same inventive concept, the embodiment of the present application further provides an importing device of a table data file, and the structure of the importing device is shown in fig. 2.
Fig. 2 is a schematic structural diagram of an importing device for a tabular data file according to an embodiment of the present application. As shown in fig. 2, the apparatus includes a processor 201, and a memory 202, on which executable code is stored, and when the executable code is executed, causes the processor 201 to perform the above one method of importing a tabular data file.
In an embodiment of the present application, the processor 201 is configured to construct corresponding data models respectively for different types of table data files, configure corresponding import templates, and construct a template library; the data model is used for acquiring key characteristics of a table data file to be imported; the template library is also used for matching a corresponding import template from the pre-configured template library according to the key features to be used as a template to be selected; the template file system is also used for respectively correcting the template to be selected and the form data file to be imported according to the key characteristics and the attributes of the template to be selected; and the system is also used for importing the corrected form data file to be imported into the target service system according to the corrected template to be selected.
The embodiments in the present application are described in a progressive manner, and the same and similar parts among the embodiments can be referred to each other, and each embodiment focuses on the differences from the other embodiments. In particular, for the apparatus embodiment, since it is substantially similar to the method embodiment, the description is relatively simple, and for the relevant points, reference may be made to the partial description of the method embodiment.
It should also be noted that the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising an … …" does not exclude the presence of other like elements in a process, method, article, or apparatus that comprises the element.
The above description is only an example of the present application and is not intended to limit the present application. Various modifications and changes may occur to those skilled in the art. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present application should be included in the scope of the claims of the present application.
Claims (10)
1. A method for importing a tabular data file, the method comprising:
respectively constructing corresponding data models aiming at different types of table data files, configuring corresponding import templates and constructing a template library;
acquiring key features of a table data file to be imported based on the data model;
according to the key features, automatically matching a corresponding import template from the pre-configured template library to serve as a template to be selected;
correcting the template to be selected according to the key characteristics;
and importing the form data file to be imported into a target service system according to the corrected template to be selected.
2. The method for importing a tabular data file according to claim 1, wherein for different types of tabular data files, corresponding data models are respectively constructed, specifically comprising:
determining the position of a field name in a table data file and the field value of an adjacent cell according to the designated field, and constructing the key characteristics of the table data file;
and respectively constructing corresponding data models according to the key characteristics of the different types of table data files.
3. The method for importing a tabular data file according to claim 1, wherein according to the key features, automatically matching a corresponding import template from the pre-configured template library as a template to be selected specifically comprises:
matching the key features with the imported templates in the template library respectively, and calculating the matching rate;
determining the import template with the highest matching rate from a plurality of import templates with the matching rate larger than a first preset value as a template to be selected;
and under the condition that no import template with the matching rate larger than a first preset value exists, reconfiguring the corresponding import template according to the table data file to be imported.
4. The method according to claim 3, wherein when there is no import template with a matching rate greater than a first preset value, reconfiguring a corresponding import template according to the to-be-imported tabular data file, specifically comprising:
and determining the field name of the appointed field in the table data file, the position of the field name and the field value of the adjacent cell according to the key characteristics of the table data file to be imported, and configuring a corresponding import template.
5. The method for importing a tabular data file according to claim 3, wherein the import template with the highest matching rate is determined from a plurality of import templates with the matching rate greater than the first preset value, and after being used as the candidate template, the method further comprises:
under the condition that the matching rate of the template to be selected is greater than a second preset value, correcting the import template to be selected according to the key features;
and under the condition that the matching rate of the template to be selected is not greater than a second preset value, re-matching the corresponding import template.
6. A method for importing a tabular data file according to claim 1, said method further comprising:
determining the integrity of the key features of the form data file to be imported according to the attributes of the template to be selected;
and sending a correction prompt to a corresponding user when the integrity of the key features is wrong.
7. The method according to claim 1, wherein the importing the tabular data file to be imported to a target service system according to the template to be selected after the completion of the correction specifically comprises:
extracting data in the table data file to be imported based on the corrected template to be selected to form a data result set;
according to the corrected template to be selected, importing the data in the data result set into a target service system;
and storing the Internet protocol address, the business operation type and the import template corresponding to the table data file to be imported into a database as import records.
8. A method for importing a tabular data file as recited in claim 7, said method further comprising:
determining an import record matched with other table data files to be imported in the database according to the Internet protocol addresses and the service operation types corresponding to the other table data files to be imported;
and importing the other form data files to be imported into the target business system according to the import template in the matched import record.
9. A method for importing a tabular data file as recited in claim 8, said method further comprising:
determining whether an import template corresponding to the table data file to be imported exists in the template library according to the import record;
and updating the import template to the template library under the condition that the import template corresponding to the table data file to be imported does not exist.
10. An importing apparatus of a tabular data file, the importing apparatus comprising:
a processor;
and a memory having stored thereon executable code which, when executed, causes the processor to perform a method of importing a tabular data file as claimed in any one of claims 1-9.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110407267.2A CN113094345A (en) | 2021-04-15 | 2021-04-15 | Method and equipment for importing table data file |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110407267.2A CN113094345A (en) | 2021-04-15 | 2021-04-15 | Method and equipment for importing table data file |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN113094345A true CN113094345A (en) | 2021-07-09 |
Family
ID=76677990
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110407267.2A Pending CN113094345A (en) | 2021-04-15 | 2021-04-15 | Method and equipment for importing table data file |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113094345A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113505580A (en) * | 2021-07-26 | 2021-10-15 | 京东科技控股股份有限公司 | Method and device for analyzing table file |
Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| EP1282869A1 (en) * | 2000-03-22 | 2003-02-12 | Barbara Rosen | A data storing method and data storing structure |
| CN104317974A (en) * | 2014-11-21 | 2015-01-28 | 武汉理工大学 | Reconfigurable multi-source data importing method in ERP system |
| CN104361139A (en) * | 2014-12-10 | 2015-02-18 | 用友软件股份有限公司 | Data importing device and method |
| CN107247767A (en) * | 2017-06-05 | 2017-10-13 | 山东浪潮通软信息科技有限公司 | A kind of method and device that database is imported by formatted data files |
| CN108595597A (en) * | 2018-04-19 | 2018-09-28 | 平安科技（深圳）有限公司 | Data lead-in method, device, computer equipment and storage medium |
| CN111125221A (en) * | 2019-12-19 | 2020-05-08 | 上海三稻智能科技有限公司 | Excel format-based data extraction system and configuration method |
| CN111177243A (en) * | 2019-12-24 | 2020-05-19 | 浙江大搜车软件技术有限公司 | Data export method and device, storage medium and electronic device |
| CN111581210A (en) * | 2020-04-30 | 2020-08-25 | 深圳壹账通智能科技有限公司 | Data importing method and system |
| CN111797613A (en) * | 2020-07-10 | 2020-10-20 | 泰康保险集团股份有限公司 | Data file processing method and device |
-
2021
- 2021-04-15 CN CN202110407267.2A patent/CN113094345A/en active Pending
Patent Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| EP1282869A1 (en) * | 2000-03-22 | 2003-02-12 | Barbara Rosen | A data storing method and data storing structure |
| CN104317974A (en) * | 2014-11-21 | 2015-01-28 | 武汉理工大学 | Reconfigurable multi-source data importing method in ERP system |
| CN104361139A (en) * | 2014-12-10 | 2015-02-18 | 用友软件股份有限公司 | Data importing device and method |
| CN107247767A (en) * | 2017-06-05 | 2017-10-13 | 山东浪潮通软信息科技有限公司 | A kind of method and device that database is imported by formatted data files |
| CN108595597A (en) * | 2018-04-19 | 2018-09-28 | 平安科技（深圳）有限公司 | Data lead-in method, device, computer equipment and storage medium |
| CN111125221A (en) * | 2019-12-19 | 2020-05-08 | 上海三稻智能科技有限公司 | Excel format-based data extraction system and configuration method |
| CN111177243A (en) * | 2019-12-24 | 2020-05-19 | 浙江大搜车软件技术有限公司 | Data export method and device, storage medium and electronic device |
| CN111581210A (en) * | 2020-04-30 | 2020-08-25 | 深圳壹账通智能科技有限公司 | Data importing method and system |
| CN111797613A (en) * | 2020-07-10 | 2020-10-20 | 泰康保险集团股份有限公司 | Data file processing method and device |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113505580A (en) * | 2021-07-26 | 2021-10-15 | 京东科技控股股份有限公司 | Method and device for analyzing table file |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US20130144893A1 (en) | Systems and Methods for Extraction of Concepts for Reuse-based Schema Matching | |
| WO2023179386A1 (en) | Data processing method, device, storage medium, and program product | |
| CN111552665B (en) | Method, device, equipment and medium for converting annotation information format | |
| CN111435367A (en) | Knowledge graph construction method, system, equipment and storage medium | |
| CN113094345A (en) | Method and equipment for importing table data file | |
| CN111061733A (en) | Data processing method and device, electronic equipment and computer readable storage medium | |
| CN111522729A (en) | Method, device and system for determining rule release | |
| WO2011131101A1 (en) | Data cut-over method and apparatus | |
| CN110688827A (en) | Data processing method and device, electronic equipment and storage medium | |
| JP6171703B2 (en) | Document management apparatus and document management program | |
| CN112561488A (en) | Tax payment robot declaration method and device combining RPA and AI | |
| CN113868219A (en) | Method and device for migrating account set data, electronic equipment and computer storage medium | |
| CN111045660A (en) | Method, device and storage medium for verifying tax declaration data on network | |
| CN114819631A (en) | Multitask visualization method and device, computer equipment and storage medium | |
| CN113111072A (en) | Business data file generation method and device | |
| WO2024113991A1 (en) | Version upgrade configuration parameter construction method, version upgrade method, device, and medium | |
| CN114385595B (en) | Data migration method, device, computer equipment and storage medium | |
| CN117348916B (en) | Script generation method, device, equipment and storage medium | |
| US11989123B1 (en) | Systems, methods, and media for updating, managing, and maintaining a reference template for web service API testing | |
| US12001388B2 (en) | Information importing method and apparatus | |
| CA3114250C (en) | Machine assisted data aggregation | |
| JP7359218B2 (en) | Management device, management method and management program | |
| CN109858050B (en) | Data model generation method and device | |
| CN116126913A (en) | Feedback type data management method, device, equipment and computer readable storage medium | |
| JP2023151987A (en) | Item name check device, item name check method, and program |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20210709 |