CN107436917A - One kind imports template configuration method, batch data introduction method and system - Google Patents
One kind imports template configuration method, batch data introduction method and system Download PDFInfo
- Publication number
- CN107436917A CN107436917A CN201710457923.3A CN201710457923A CN107436917A CN 107436917 A CN107436917 A CN 107436917A CN 201710457923 A CN201710457923 A CN 201710457923A CN 107436917 A CN107436917 A CN 107436917A
- Authority
- CN
- China
- Prior art keywords
- data
- import
- template
- imported
- import template
- 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
- 230000008676 import Effects 0.000 title claims abstract description 188
- 238000000034 method Methods 0.000 title claims abstract description 78
- 238000004458 analytical method Methods 0.000 claims description 6
- 238000010276 construction Methods 0.000 claims description 5
- 238000012545 processing Methods 0.000 claims description 5
- 230000008569 process Effects 0.000 abstract description 23
- 238000012986 modification Methods 0.000 description 5
- 230000004048 modification Effects 0.000 description 5
- 238000013523 data management Methods 0.000 description 4
- 230000006870 function Effects 0.000 description 3
- 238000004891 communication Methods 0.000 description 2
- 238000011161 development Methods 0.000 description 2
- 238000010586 diagram Methods 0.000 description 2
- 238000007726 management method Methods 0.000 description 2
- 238000004519 manufacturing process Methods 0.000 description 2
- 238000012384 transportation and delivery Methods 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000005540 biological transmission Effects 0.000 description 1
- 238000007405 data analysis Methods 0.000 description 1
- 238000013479 data entry Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 230000010354 integration Effects 0.000 description 1
- 238000005065 mining Methods 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 238000012216 screening Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/258—Data format conversion from or to a database
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention discloses a kind of importing template configuration method, including：Choose data to be imported；At least one in the data to be imported is selected to arrange, the selecting sequence structure based on the row is pre- to import template；And the pre- importing template is preserved to import template.The invention also discloses a kind of batch data introduction method and system using above-mentioned importing template configuration method.The batch that the present invention according to the data format requirement of system to be imported, the customized importing template of dynamic generation, can complete data imports.It is simple, efficient to import template configuration process, drastically increases the efficiency of data importing, while avoids the editor to data to be imported and arrangement, reduces the error rate of data.In particular, self-defined importing template of the invention is applicable to frequently change the situation for importing template, realizes convenient, fast, efficient, accurate batch data and imports.
Description
Technical Field
The invention relates to the technical field of data management. And more particularly, to an import template configuration method, a data batch import method and a system.
Background
At present, a great deal of data has penetrated into every industry and business function field today and becomes an important production factor. People's mining and application of mass data indicate a new wave of productivity increase and the arrival of surplus wave of consumers. Data management is the process of efficient collection, storage, processing and application of data using computer hardware and software techniques, with the goal of fully and efficiently playing the role of the data. With the development of computer technology, the informatization and digitization levels are continuously improved, and data management goes through three development stages of manual management, a file system and a database system. The data structure established in the database system describes the internal relation among the data more fully, is convenient for data modification, updating and expansion, ensures the independence, reliability, safety and integrity of the data, reduces data redundancy, and improves the data sharing degree and the data management efficiency.
However, the requirements for data in different databases may also vary. With the advent of the big data era, how to realize rapid mass import of data becomes a key for realizing effective management of data. To improve the efficiency of conventional manual data entry, an import template with fixed requirements is typically provided. When data is imported, firstly, editing and arranging the data to be imported according to the requirements of an import template, and then, importing the data in large batch. For example, fig. 1 shows an example of data to be imported, fig. 2 shows an example of an import template with fixed requirements, when data import is performed, the data to be imported in fig. 1 needs to be edited and collated according to the requirements of the import template in fig. 2, and the edited data to be imported is shown in fig. 3. This results in a modification of the data to be imported, increasing the error rate of the data. In addition, since the data is generally imported in strip units, the user is required to edit the information line by line only according to the requirements of the template, and the information combined together is separated or the separated information is combined, so that the workload of the user is greatly increased. In particular, different users and systems have different original information formats, and when the fixing requirements of the data to be imported and the imported template are greatly different, the process of editing and arranging the document is extremely complicated.
Although the configuration administrator can customize the import template, the configuration administrator needs to perform multiple step operations individually to implement the operation, and is not suitable for the scenario that the import template needs to be replaced frequently, and the customization process is also prone to errors.
Therefore, it is required to provide a convenient, fast, efficient and accurate import template configuration method, a data batch import method and a data batch import system.
Disclosure of Invention
To solve at least one of the above problems, a first aspect of the present invention provides a method for importing template configuration, including: selecting data to be imported; selecting at least one column in the data to be imported, and constructing a pre-import template based on the selection sequence of the columns; and saving the pre-import template as an import template.
Optionally, the selecting the data to be imported includes click selection or drag selection.
Optionally, the data to be imported is in an xlsx, xls or csv format.
Optionally, selecting at least one column of data to be imported includes: column data of data to be imported is selected for one or more times; and selecting column data including one or more columns of data to be imported each time.
Optionally, the importing template configuration method further includes: after data to be imported are selected, generating configuration prompt information based on the data format requirement of a system to be imported; and building a pre-import template by referring to the configuration prompt information.
Optionally, the importing template configuration method further includes: and modifying or deleting the pre-import template and/or the import template.
The second aspect of the present invention provides a data batch import method, including:
judging whether an import template meeting the data format requirement of the system to be imported exists or not: if yes, selecting the template as a leading-in template; if not, executing the import template configuration method to generate an import template; and analyzing and importing the data to be imported based on the selected or generated import template.
Optionally, the data batch import method further includes: and processing the data which fails in analysis and/or import failure.
The third aspect of the present invention provides a data batch import system, including an import template configuration module, wherein: the data selection unit selects data to be imported; the pre-import template building unit is used for selecting at least one column in the data to be imported and building a pre-import template based on the selection sequence of the columns; and an import template construction unit which saves the pre-import template as an import template.
A fourth aspect of the present invention provides a data batch import system, including:
the judging module is used for judging whether an import template meeting the data format requirement of the system to be imported exists or not: if yes, selecting the template as a leading-in template; if not, executing the import template configuration method to generate an import template; and the import module analyzes and imports the data to be imported based on the selected or generated import template.
The invention has the following beneficial effects:
the import template configuration method, the data batch import method and the data batch import system can dynamically generate the self-defined import template according to the data format requirement of the system to be imported, and complete the batch import of data. The configuration process of the import template is simple and efficient, the efficiency of data import is greatly improved, meanwhile, the editing and the sorting of the data to be imported are avoided, and the error rate of the data is reduced. Particularly, the user-defined import template is suitable for the condition that the import template needs to be frequently replaced, and convenient, quick, efficient and accurate batch import of data is realized.
Drawings
The following describes embodiments of the present invention in further detail with reference to the accompanying drawings.
Fig. 1 shows an example of data to be imported in the prior art.
Fig. 2 shows an example of a prior art import template with fixation requirements.
Fig. 3 shows an example of edited data to be imported in the prior art.
FIG. 4 illustrates a flow diagram of an import template configuration method.
FIG. 5 shows a flow diagram of a data batch import method.
Detailed Description
In order to more clearly illustrate the invention, the invention is further described below with reference to preferred embodiments and the accompanying drawings. Similar parts in the figures are denoted by the same reference numerals. It is to be understood by persons skilled in the art that the following detailed description is illustrative and not restrictive, and is not to be taken as limiting the scope of the invention.
The terms "first," "second," and the like in the description and claims of the present invention and in the above-described drawings are used for distinguishing between different objects and not for describing a particular order. Furthermore, the terms "include" and "have," as well as any variations thereof, are intended to cover non-exclusive inclusions. For example, a process, method, system, article, or apparatus that comprises a list of steps or elements is not limited to only those steps or elements listed, but may alternatively include other steps or elements not listed, or may alternatively include other gas steps or elements inherent to such process, method, or apparatus.
FIG. 4 illustrates one embodiment of an import template configuration method of the present invention.
As shown in fig. 4, in S402, data to be imported is selected.
And when the import template configuration is carried out, dynamically generating the import template in real time based on the selection operation of the data to be imported. Compared with the prior art, the import template configuration method has the advantages that the import template is customized by the configuration administrator, the customization is realized without independently performing multiple step operations, the method is suitable for the situation that the import template needs to be frequently replaced, errors are not prone to occur in the customization process, the efficiency and the accuracy of the import template configuration are guaranteed, the configured import template can be directly used for extracting the data to be imported, and the editing and the sorting of the data to be imported are omitted.
In the invention, when the data to be imported is taken, the local/network storage tree structure can be selected by clicking to open or the document can be directly selected by dragging. The data to be imported supports common data formats such as xlsx, xls or csv.
In S404, at least one column in the data to be imported is selected, and a pre-import template is constructed based on the selection order of the columns.
And selecting corresponding column data from the data to be imported to construct a pre-import template according to the data format requirement of the data to be imported system. Specifically, the selection operation of the column data may be performed on the data to be imported once or multiple times, the selection order of the column data is the data composition structure in the pre-import template, one or multiple columns may be selected each time, and when multiple columns of data are selected once, the multiple columns of data may be distributed continuously or discontinuously in the data to be imported. And selecting the item categories forming the pre-import template each time, constructing the pre-import template, and rearranging and combining the selected column data in the data to be imported according to the pre-import template to form a data document meeting the import requirement.
It should be noted that, when data is imported, the original data may come from different systems and have different information formats, and editing the data to be imported inevitably involves splitting, combining and sequentially adjusting the data. In the invention, different lines of data determine the data composition structure of the pre-imported template, and the sequential adjustment of the data to be imported is realized; selecting a plurality of lines of data at a time can realize the combination operation of the plurality of lines of data in the pre-imported template; and selecting only the column data meeting the import requirement each time according to the combined information in the data to be imported, so that the data to be imported can be split. According to the method and the device, the pre-import template is extracted based on the sequence and the content of the selected line data, the line data is integrated, and the pre-template configuration is completed, so that the sorting and editing of the data to be imported can be completed, the complexity of a single template manufacturing process and the data information editing of a row of lines is saved, and the batch import of the data becomes possible.
In S406, the pre-import template is saved as the import template.
The import template is generated according to the data import process each time, the template can be directly called when the import template is used next time, and the template configuration process is omitted.
When the pre-import template is saved as an import template, the import template can be renamed and classified. In another preferred embodiment, the saved import template may be shared, for example, by local storage or network transmission.
In another preferred embodiment, the importing template configuration method further includes: after data to be imported are selected, generating configuration prompt information based on the data format requirement of a system to be imported; and building a pre-import template by referring to the configuration prompt information. The configuration prompt information is used for prompting a user to generate the pre-import template as required, and the configuration prompt information is set, so that the burden of recording complicated projects when the user configures the import template containing multiple projects is reduced, and the working efficiency is improved.
In another preferred embodiment, the importing template configuration method further includes: and modifying or deleting the pre-import template and/or the import template. By modifying the pre-import template and/or the import template, the step of reconfiguring the import template when the difference between the existing import template and the required import template is not great is omitted, namely, simple modification is carried out on the basis of the existing import template. The template which is used once or has low use frequency can be cleaned up by deleting the pre-imported template and/or the imported template, the storage space of a system is saved, the template selection process is simplified, and the performance of the import process is improved.
As shown in fig. 5, on the basis of the configuration method of the import template, the invention further discloses a data batch import method.
In S502, it is determined whether there is an import template that meets the data format requirement of the system to be imported: if yes, selecting the template as a leading-in template; if not, executing the import template configuration method to generate the import template.
By unifying the data import process and the template generation process, the process of individually performing multiple step operations to configure the import template is omitted. When judging whether an import template meeting the data format requirement of the system to be imported exists, the method can be directly judged by a user, and can also be judged by screening and comparing the system.
In S504, the data to be imported is parsed and imported based on the selected or generated import template.
For the selected or generated import template, only the import template needs to be selected, and the system can realize the automatic analysis and import process of the data to be imported through the generation mode of the import template, and does not need a user to edit the information line by line according to the requirements of a fixed template, thereby greatly reducing the workload of batch import of the data, improving the import efficiency and reducing the error probability in the import process.
In S506, the data that failed the parsing and/or the data that failed the importing are processed.
If the data analysis or import process has failed data, the user can select manual work to process the data, so that the problem that one or more data are needed to be solved, and the whole batch import process is stopped. By independently processing the data which fails to be analyzed and/or imported, the detailed condition of the problem can be conveniently determined, and the pointed processing can be carried out according to the specific condition.
While, for purposes of simplicity of explanation, the methodologies are shown and described as a series of acts, it is to be understood and appreciated that the methodologies are not limited by the order of acts, as some acts may, in accordance with one or more embodiments, occur in different orders and/or concurrently with other acts from that shown and described herein or not shown and described herein, as would be understood by one skilled in the art.
Based on the data batch import method, the invention also discloses a data batch import system which comprises a judgment module, an import template configuration module and an import module. Wherein,
the judging module is used for judging whether an import template meeting the data format requirement of the system to be imported exists or not: if yes, selecting the template as a leading-in template; if not, executing the import template configuration method through an import template configuration module to generate an import template;
the import template configuration module comprises a data selection unit and a pre-import template construction module: the data selection unit is used for selecting data to be imported; the pre-import template building unit is used for selecting at least one column in the data to be imported and building a pre-import template based on the selection sequence of the columns; and
and the import template construction unit is used for saving the pre-import template as an import template.
It should be noted that, in the terminal device embodiment, each included unit is only divided according to functional logic, but is not limited to the above division as long as the corresponding function can be implemented; in addition, specific names of the functional units are only for convenience of distinguishing from each other, and are not used for limiting the protection scope of the present invention.
In addition, it is understood by those skilled in the art that all or part of the steps in the above method embodiments may be implemented by related hardware, and the corresponding program may be stored in a computer readable storage medium, where the above mentioned storage medium may be a read-only memory, a magnetic disk or an optical disk.
The following is a detailed description of the present invention in terms of the bulk import of recipient information in a logistics system
In the logistics system, generation of orders and import and export between different systems are often involved, and information required between different systems is also different according to functions thereof, for example, order data generated by a seller system includes detailed information of buyers and attribute information related to products, a warehousing system pays more attention to product attribute information and quantity information, and a logistics system pays more attention to information such as addresses of the buyers as recipients, telephones, and model numbers of purchased products.
The batch import of the recipient information in the logistics system comprises the following steps:
step 1: and importing the address of the receiver.
The address of the receiver is usually imported into the logistics system by the seller system for delivery, but the formats of the address of the receiver in the two systems are different, and the information of the receiver needs to be edited and sorted. According to the method, the secondary menu is opened by clicking an 'import recipient address' option, the secondary menu is selected according to the screened data format which is the common data format such as xlsx, xls or csv, and the import of the recipient address serving as the data to be imported is completed by selecting the data document. As a preferred embodiment, the selection of the data to be imported can also be completed by directly dragging the data document to be imported to the option area of the "import recipient address".
Step 2: and generating a pre-import template according to the import guide.
The import guide comprises an information prompt area, a data display area to be imported, a pre-import template preview area and an operation area. And the information prompt area is used for displaying the operation which needs to be carried out currently. For example, in a preferred embodiment, the information prompt area can prompt the current operation according to the requirement of the data structure of the system to be imported; a data display area to be imported, which is used for displaying the addressee information imported in the step 1; the pre-import template preview area is used for displaying information in the configuration process of the pre-import template; and the operation area is used for executing configuration operation.
In this example, the information to be imported includes items [ consignee ], [ consignee telephone ], [ province ], [ city ], [ district/county ], [ consignee address ], and [ remark ], and the template to be imported includes items [ name ], [ contact ], [ address ], and [ remark ], where the [ address ] in the template to be imported is a combination of the items [ province ], [ city ], [ district/county ], [ consignee address ], and [ consignee address ] in the information to be imported.
The specific operation process is as follows:
1) and the information prompt area prompts a corresponding column of ' please select ' a consignee ', and the user selects a data column of ' the consignee ' according to the prompt. At the moment, data in a data display area to be imported (a consignee) is listed as a selection column, and meanwhile, a template pre-importing preview area displays options (names);
2) executing a 'next' button in the operation area;
3) and the information prompt area prompts a corresponding column of ' please select ' a receiver phone ', and the user selects a data column of ' a receiver phone ' according to the prompt. At the moment, data in a data display area to be imported (a receiver telephone) is listed as a selection column, and meanwhile, a template pre-importing preview area displays options (a contact way);
4) executing a 'next' button in the operation area;
5) and the information prompting area prompts' please select the corresponding columns of [ province ], [ city ], [ district/county ], [ delivery address ], and the user selects the four data columns according to the prompt. At the moment, the four data columns in the data display area to be imported are selected columns, and meanwhile, the template pre-import preview area displays options of addresses;
it should be noted that the data columns in this step can be selected;
6) executing a 'next' button in the operation area;
7) and the information prompt area prompts a corresponding column 'please select the remark', and the user selects the data column 'remark' according to the prompt. At the moment, data in a data display area to be imported [ remarks ] is listed as a selection column, and meanwhile, a template pre-importing preview area displays [ remarks ] options;
8) the data display in the pre-imported template preview area is realized by clicking each line of data, and if an error occurs in the operation, the operation can be returned and operated again by executing a 'previous step' button in the operation area;
9) and an execute operation area confirm button.
It should be noted that the above process embodies the integration of data, and the method of the present invention can also realize the splitting of data.
And step 3: and inputting the name of the template, and saving the pre-import template as an import template.
And 4, step 4: and generating and confirming information to be imported, and adding other information.
The user needs to confirm the analysis failure information and the import failure information until the information prompt is zero, and then the next operation is carried out. If the analysis failure information and/or the import failure information exist, the user needs to manually modify or delete the analysis failure information and/or the import failure information.
The user also needs to confirm the information such as the total number of pieces to be imported.
The additional information includes sender information, carrier information, and item type information, where the sender information in this example may be added manually or imported from historical data.
And 5: clicking 'submit' to finish data import.
The "plurality" referred to in the present invention means two or more. "and/or" describes the association relationship of the associated objects, meaning that there may be three relationships, e.g., a and/or B, which may mean: a exists alone, A and B exist simultaneously, and B exists alone.
In the present invention, it should be understood that the disclosed system and method may be implemented in other ways. For example, the above-described system embodiments are merely illustrative, and for example, the division of the modules is only one logical division, and other divisions may be realized in practice, for example, multiple units or components may be combined or integrated into another system, or some features may be omitted, or not executed. In addition, the shown or discussed mutual set or direct or communication connection may be an indirect or communication connection through some interfaces, devices or units, and may be in an electrical, mechanical or other form. The units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the units can be selected according to actual needs to achieve the purpose of the solution of the embodiment.
It should be understood that the above-mentioned embodiments of the present invention are only examples for clearly illustrating the present invention, and are not intended to limit the embodiments of the present invention, and it will be obvious to those skilled in the art that other variations or modifications may be made on the basis of the above description, and all embodiments may not be exhaustive, and all obvious variations or modifications may be included within the scope of the present invention.
Claims (10)
1. A method for configuring a import template, comprising:
selecting data to be imported;
selecting at least one column in the data to be imported, and constructing a pre-import template based on the selection sequence of the columns; and
and saving the pre-import template as an import template.
2. The method for constructing the import template according to claim 1, wherein selecting the data to be imported comprises click selection or drag selection.
3. The batch import method of data according to claim 1, wherein the data to be imported is in xlsx, xls or csv format.
4. The batch import method of data according to claim 1, wherein selecting at least one column of the data to be imported comprises:
column data of data to be imported is selected for one or more times;
each time column data including one or more columns of data to be imported is selected.
5. The batch import method of data according to claim 1, wherein the import template configuration method further comprises:
after data to be imported are selected, generating configuration prompt information based on the data format requirement of a system to be imported;
and building a pre-import template by referring to the configuration prompt information.
6. The batch import method of data according to claim 1, wherein the import template configuration method further comprises:
and modifying or deleting the pre-import template and/or the import template.
7. A data batch import method is characterized by comprising the following steps:
judging whether an import template meeting the data format requirement of the system to be imported exists or not: if yes, selecting the template as a leading-in template; if not, executing the import template configuration method of any one of claims 1 to 6 to generate an import template; and
and analyzing and importing the data to be imported based on the selected or generated import template.
8. The batch import method of data according to claim 7, wherein the batch import method further comprises:
and processing the data which fails in analysis and/or import failure.
9. The data batch import system is characterized by comprising an import template configuration module, wherein:
the data selection unit selects data to be imported;
the pre-import template construction unit is used for selecting at least one column in the data to be imported and constructing a pre-import template based on the selection sequence of the columns; and
and the import template construction unit is used for storing the pre-import template as an import template.
10. A data batch import system is characterized by comprising:
the judging module is used for judging whether an import template meeting the data format requirement of the system to be imported exists or not: if yes, selecting the template as a leading-in template; if not, executing the import template configuration method of any one of claims 1 to 6 to generate an import template; and
and the import module analyzes and imports the data to be imported based on the selected or generated import template.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710457923.3A CN107436917A (en) | 2017-06-16 | 2017-06-16 | One kind imports template configuration method, batch data introduction method and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710457923.3A CN107436917A (en) | 2017-06-16 | 2017-06-16 | One kind imports template configuration method, batch data introduction method and system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN107436917A true CN107436917A (en) | 2017-12-05 |
Family
ID=60458606
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710457923.3A Pending CN107436917A (en) | 2017-06-16 | 2017-06-16 | One kind imports template configuration method, batch data introduction method and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107436917A (en) |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110188030A (en) * | 2019-04-08 | 2019-08-30 | 平安科技（深圳）有限公司 | A kind of test data generating method, device and computer equipment, storage medium |
| CN110502557A (en) * | 2019-07-23 | 2019-11-26 | 平安科技（深圳）有限公司 | Data lead-in method, device, computer equipment and storage medium |
| CN110674029A (en) * | 2019-08-26 | 2020-01-10 | 平安科技（深圳）有限公司 | Method and device for automatically generating test data, electronic equipment and storage medium |
| CN110728121A (en) * | 2019-09-17 | 2020-01-24 | 杭州安恒信息技术股份有限公司 | Data import system and method for realizing zero development based on existing interface |
| CN110865883A (en) * | 2019-09-23 | 2020-03-06 | 平安科技（深圳）有限公司 | Mass data importing method and device, computer equipment and storage medium |
| CN113127428A (en) * | 2021-04-30 | 2021-07-16 | 深圳壹账通智能科技有限公司 | Data batch import method and device and related equipment |
| EP4102378A1 (en) * | 2021-06-11 | 2022-12-14 | Data Transformer GmbH | Method for the reorganisation and/or transformation of data |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7849108B1 (en) * | 2007-03-13 | 2010-12-07 | Fundriver, Inc. | Methods and systems for establishing a database |
| CN104123376A (en) * | 2014-07-29 | 2014-10-29 | 广东能龙教育股份有限公司 | Intelligent text data collection method and system based on column template |
| CN104536998A (en) * | 2014-12-15 | 2015-04-22 | 浪潮通用软件有限公司 | Data import method and device |
| CN105117431A (en) * | 2015-08-07 | 2015-12-02 | 北京思特奇信息技术股份有限公司 | Dynamic configuration method and system for external imported data |
-
2017
- 2017-06-16 CN CN201710457923.3A patent/CN107436917A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7849108B1 (en) * | 2007-03-13 | 2010-12-07 | Fundriver, Inc. | Methods and systems for establishing a database |
| CN104123376A (en) * | 2014-07-29 | 2014-10-29 | 广东能龙教育股份有限公司 | Intelligent text data collection method and system based on column template |
| CN104536998A (en) * | 2014-12-15 | 2015-04-22 | 浪潮通用软件有限公司 | Data import method and device |
| CN105117431A (en) * | 2015-08-07 | 2015-12-02 | 北京思特奇信息技术股份有限公司 | Dynamic configuration method and system for external imported data |
Cited By (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110188030A (en) * | 2019-04-08 | 2019-08-30 | 平安科技（深圳）有限公司 | A kind of test data generating method, device and computer equipment, storage medium |
| CN110502557A (en) * | 2019-07-23 | 2019-11-26 | 平安科技（深圳）有限公司 | Data lead-in method, device, computer equipment and storage medium |
| WO2021012910A1 (en) * | 2019-07-23 | 2021-01-28 | 平安科技（深圳）有限公司 | Data import method and apparatus, and computer device and storage medium |
| CN110674029A (en) * | 2019-08-26 | 2020-01-10 | 平安科技（深圳）有限公司 | Method and device for automatically generating test data, electronic equipment and storage medium |
| CN110674029B (en) * | 2019-08-26 | 2024-08-13 | 平安科技（深圳）有限公司 | Method and device for automatically generating test data, electronic equipment and storage medium |
| CN110728121A (en) * | 2019-09-17 | 2020-01-24 | 杭州安恒信息技术股份有限公司 | Data import system and method for realizing zero development based on existing interface |
| CN110728121B (en) * | 2019-09-17 | 2023-08-01 | 杭州安恒信息技术股份有限公司 | Data importing system and method for realizing zero development based on existing interface |
| CN110865883A (en) * | 2019-09-23 | 2020-03-06 | 平安科技（深圳）有限公司 | Mass data importing method and device, computer equipment and storage medium |
| CN110865883B (en) * | 2019-09-23 | 2022-06-03 | 平安科技（深圳）有限公司 | Mass data importing method and device, computer equipment and storage medium |
| CN113127428A (en) * | 2021-04-30 | 2021-07-16 | 深圳壹账通智能科技有限公司 | Data batch import method and device and related equipment |
| EP4102378A1 (en) * | 2021-06-11 | 2022-12-14 | Data Transformer GmbH | Method for the reorganisation and/or transformation of data |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107436917A (en) | One kind imports template configuration method, batch data introduction method and system | |
| US10311078B2 (en) | Identifying and formatting data for data migration | |
| US10198423B2 (en) | Suggesting a set of operations applicable to a selected range of data in a spreadsheet | |
| US9792015B2 (en) | Providing visualizations for conversations | |
| CN101609707B (en) | Information processing apparatus and information processing method | |
| US10657206B2 (en) | Graphical user interface system and method for natural language generation editing | |
| CN104270528B (en) | Information group sending system and method | |
| WO2017079422A1 (en) | Spreadsheet arrays | |
| US10783214B1 (en) | Adaptive and dynamic user interface with linked tiles | |
| CN109947399A (en) | Code structure generation method, device, computer installation and readable storage medium storing program for executing | |
| US11567635B2 (en) | Online collaborative document processing method and device | |
| WO2015026678A2 (en) | Ad hoc reporting with smart lists | |
| CN115130442A (en) | Report generation method and device, storage medium and computer equipment | |
| CN114564194A (en) | Form self-defining development method and system based on VUE framework | |
| US20130231973A1 (en) | Business analysis design support device, business analysis design support method and non-transitory computer-readable medium containing business analysis design support program | |
| CN106021359A (en) | CAD file modification method and device | |
| CN111740850A (en) | Group chat creating method and device, electronic equipment and readable storage medium | |
| US20130054599A1 (en) | Dynamically Generated List Index | |
| CN113778401A (en) | Page generation method and device | |
| US11087095B1 (en) | Platform for quality assurance in natural language generation frameworks | |
| US20240289544A1 (en) | Graphical cell creation preview before structure update | |
| US20230244864A1 (en) | Fragmenting spreadsheets | |
| CN113704593B (en) | Operation data processing method and related device | |
| CN104243654A (en) | Information groupsend system and information groupsend method | |
| CN109857417B (en) | Call center configuration information updating method and device, electronic equipment and 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 | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20171205 |