CN114490672B - Table data input processing method and device and storage medium - Google Patents
Table data input processing method and device and storage medium Download PDFInfo
- Publication number
- CN114490672B CN114490672B CN202210352843.2A CN202210352843A CN114490672B CN 114490672 B CN114490672 B CN 114490672B CN 202210352843 A CN202210352843 A CN 202210352843A CN 114490672 B CN114490672 B CN 114490672B
- Authority
- CN
- China
- Prior art keywords
- data
- user
- database table
- database
- input processing
- 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/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- 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/24—Querying
- G06F16/245—Query processing
- G06F16/2455—Query execution
- G06F16/24552—Database cache management
-
- 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/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F9/00—Arrangements for program control, e.g. control units
- G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
- G06F9/44—Arrangements for executing specific programs
- G06F9/451—Execution arrangements for user interfaces
Abstract
The invention discloses a table data input processing method, a device and a storage medium, wherein the method comprises the following steps: s1, persisting the user table to a database table; s2, loading the database table to a user interface, and processing the database table according to the data processing rule; and S3, enabling the processed database table to participate in user business, and completing form data input processing. The invention has high data fault tolerance rate, and can meet the requirement that a user hopes a large amount of non-standard historical data to be quickly input into an information software system; the method has flexible and changeable data processing process, and avoids the condition that the whole user form data cannot enter the system due to the non-standard data.
Description
Technical Field
The invention belongs to the technical field of data processing, and particularly relates to a table data input processing method, a table data input processing device and a storage medium.
Background
The data collection is not required to be carried out on the framework of any informatization software system, and the current data collection modes mainly comprise two modes: one is manual entry by a user, and the other is batch import of existing form data (such as Excel). In the existing business software system, when processing the input of table data, usually according to a specific data header template, the template field corresponds to the structured data field of the business system one to one, firstly, the structured column name and the column data type are determined, and then, data analysis, data type conversion, data verification (such as repeatability verification, non-empty verification, value interval verification and the like), data temporary caching, persistence to the structured data table and the like are performed row by column, and the processing method generally has the following defects:
1. when a data type conversion error occurs, normal import cannot be performed:
2. when the table data volume is large, the position of the data verification error can not be intuitively positioned to the final user, so that the user can correct the data conveniently;
3. the form template is solidified, which can not adapt to the same service and input various different form data;
4. the fault tolerance is not high generally, and the requirement that a user wants a large amount of irregular historical data to input an informatization software system quickly cannot be met.
Disclosure of Invention
In view of the above-mentioned deficiencies in the prior art, the present invention provides a method, an apparatus and a storage medium for processing table data input, which solve the above-mentioned problems in the background art.
In order to achieve the purpose of the invention, the invention adopts the technical scheme that: a form data input processing method comprises the following steps:
s1, persisting the user table to a database table;
the database table is a two-dimensional table used for storing data in a user table in a persistent layer;
s2, loading the database table to a user interface, and processing the database table according to the data processing rule;
and S3, enabling the processed database table to participate in user business, and completing form data input processing.
The invention has the beneficial effects that:
(1) the invention adopts a delayed data processing method and a general data structural design, takes the principle that a large amount of natural data quickly enters a business system as a priority principle, and then carries out corresponding processing on the natural data according to configured data processing rules after the natural data enters the business system, so that the natural data can quickly participate in business;
(2) the invention has high data fault tolerance rate, and can meet the requirement that a user hopes a large amount of non-standard historical data to be quickly input into an information software system;
(3) the invention has flexible and changeable data processing process, and avoids the condition that the whole user form data can not enter the system due to the non-standard data.
Further, the step S1 is specifically:
s11, determining the column name of the user table, and creating a database table;
s12, creating a relational mapping table between the user table and the database table;
and S13, reading the data in the user table based on the relational mapping table, and storing the data in the database table.
Further, in step S11, the column name of the user table is described by using two data types, including an actual data type and a general data type;
the database table comprises field names, field Chinese names and field types, the field type of each field has a corresponding general data type, and the general data type is used for storing any input of a user.
Further, the maptable in step S12 represents the correspondence between the column name of the user table, the field name of the database table, and the generic data type.
Further, in step S13, based on the mapping table, in the windows environment, the data in the user table is read by using the Com component.
Further, in step S13, the read data is buffered by configuring the buffer, and when the storage amount of the buffer is reached, the buffered data is stored in the database table.
The beneficial effects of the above further scheme are: by the method, the user table data is persisted into the database table, so that even irregular and unreasonable user data can normally enter the system.
Further, the data processing rule in step S2 includes a data type conversion rule and a data verification rule;
the data type conversion rule is used for converting the general data type of the field into the actual data type;
the data checking rule comprises repeatability checking, non-null checking and numerical value interval checking;
in step S2, the data that has failed to be converted into data types or has errors in data verification during the database table processing process is automatically color-labeled and manually corrected by the user.
The beneficial effects of the above further scheme are: the form data is processed by the data processing method, the error data is automatically marked, and a user can conveniently and quickly position and modify the error data, so that the user form data can quickly participate in user services.
A form data input processing apparatus comprising:
the table acquisition module is used for acquiring a user table to be processed;
the data mapping module is used for persisting the data in the user table into a database table;
and the data processing module is used for carrying out data type conversion and data verification processing on the data in the database.
Further, the mapping module includes:
the database table unit is used for constructing a database table corresponding to the data in the user table;
the relational mapping table unit is used for constructing a relational mapping table representing the corresponding relation between the database table and the user table;
and the data persistence unit is used for persisting the data in the user table to the database table according to the relational mapping table.
The invention has the beneficial effects that: the invention provides a device for processing the table data, and the mutual cooperation among all the functional modules provides a platform for irregular and unreasonable table data to rapidly participate in the user service process, so that the invention has flexible and changeable data processing process and can meet the user requirements.
A computer-readable storage medium storing a computer program which, when executed, implements the steps of a form data input processing method.
The invention has the beneficial effects that: the invention provides a corresponding computer readable storage mechanism for the computer program for processing the table data, is convenient for a user to directly obtain and execute the program of the table data processing method, and can effectively improve the efficiency of the table input data participating in the user service.
Drawings
Fig. 1 is a flowchart of a table data input processing method according to the present invention.
Fig. 2 is a structural diagram of a table data input processing device according to the present invention.
Detailed Description
The following description of the embodiments of the present invention is provided to facilitate the understanding of the present invention by those skilled in the art, but it should be understood that the present invention is not limited to the scope of the embodiments, and it will be apparent to those skilled in the art that various changes may be made without departing from the spirit and scope of the invention as defined and defined by the appended claims, and all changes that can be made by the invention using the inventive concept are intended to be protected.
Example 1:
the embodiment of the invention provides a table data input processing method, as shown in fig. 1, comprising the following steps:
s1, persisting the user table to a database table;
the database table is a two-dimensional table used for storing data in a user table in a persistence layer;
s2, loading the database table to a user interface, and processing the database table according to the data processing rule;
and S3, enabling the processed database table to participate in user business, and completing form data input processing.
The form data input processing method provided by this embodiment adopts a delayed data processing method and a general data structural design, and takes a large amount of natural data entering a business system quickly as a priority principle, and then performs corresponding processing on the natural data according to configured data processing rules after the natural data is subjected to the business system, so that the natural data is input to an information software system quickly.
Step S1 of this embodiment specifically includes:
s11, determining the column name of the user table, and creating a database table;
s12, creating a relational mapping table between the user table and the database table;
and S13, reading the data in the user table based on the relational mapping table, and storing the data in the database table.
In this embodiment, take the example that a certain company task management system needs to input the table data shown in table 1, where the 4 th to 6 th row of data format and data content are wrong.
Table 1: user data
| Serial number | Year of year | Task name | Task type | Scheduled completion date | Current progress | Date of completion |
| 1 | 2021 | 50 recruits | Recruitment of personnel | 2021.11.21 | Has been completed | 2021.11.20 |
| 2 | … | … | … | … | … | … |
| 3 | 2022 | XX corporation advertising business | Taking over items | 2022.3.2 | In the process of going | |
| 4 | Task | YY corporation advertising business | Taking over items | 2022.4.2 | In the process of going | |
| 5 | 123 | ZZ corporation advertising service | Taking over items | a | b | c |
| 6 | 123 | ZZ corporation advertising business | Taking over items | b | c | |
| 7 | … | … | … | … | … | … |
| 8 | 2022 | Corporate financial statistics | Data statistics | 2022.12.30 | Has not developed |
In step S11 of this embodiment, the column name of the user table is described by using two types of data fields, including an actual data type and a general data type, where the actual data type is a data type derived from reality and needs to be determined according to the meaning represented by the field itself, so as to use efficient participation in subsequent business system calculation as a criterion, and in fact, all data in reality can be described only by using two types, namely, a string and a binary, so the general data type in this embodiment is a string and a binary type; as shown in table 1, the column names in this embodiment include year, task name, task type, plan completion date, current progress and completion date, and the like, and a correspondence table of the column names, types, and general data types shown in table 2 is obtained;
table 2: column name, type and general data type corresponding relation
| Column name | Column type | Generic data types |
| Year of year | Integer | String |
| Task name | String | String |
| Task type | Enum | String |
| Scheduled completion date | DateTime | String |
| Current progress | Enum | String |
| Date of completion | DateTime | String |
The database table in the embodiment comprises field names, field Chinese names and field types, wherein the field type of each field has a corresponding general data type, and the general data type is used for storing any input of a user; the column type in table 2 is a non-string type column, and a column of a general data type is newly added to obtain a database table shown in table 3;
table 3: database table
| Name of field | Name of Chinese | Type of field |
| Year | Year of year | int |
| YearText | Year of year | varchar |
| TaskName | Task name | varchar |
| TaskType | Task type | int |
| TaskTypeText | Task type | varchar |
| PlanDate | Scheduled completion date | datetime |
| PlanDateText | Scheduled completion date | varchar |
| Progress | Current progress | int |
| ProgressText | Current progress | varchar |
| CompleteDate | Date of completion | datetime |
| CompleteDateText | Date of completion | varchar |
In this embodiment, taking a field "year" as an example, which has two field types "int" and "varchar", when storing the year "2021", there are two storage methods, which can store the number 2021 and also can store the character string "2021", when there is a business requirement, "stored data is wrong, one year is less, and + 1" is needed in each year, at this time, the business requirement is more easily realized by using the storage mode of the "number 2021", which can be realized directly by "2021 + 1", but the second type "character string 2021" cannot directly realize the requirement, and the number "2021" needs to be stripped off and converted into a number and then added by 1; there are advantages to using string storage; when a value other than year is stored, for example, "er" may also use a storage manner of a character string, so in this embodiment, each field is represented by two data types, that is, two fields are represented in a database table (year is represented by two field types "int" and "varchar" in table 3).
In this embodiment, for two field types, one is an actual data type corresponding to the real world and is mainly used for calculation of a business system, and the other is a general data type, that is, what data can be stored, in order to ensure high fault tolerance when a form is imported, in this embodiment, user form data is stored in a field of the general data type, then data type conversion is performed on a stored value of the field of the general data type, the stored value is stored in a field of the actual data type, and finally, the field of the actual data type is taken to participate in the business system calculation, and for data which cannot be converted into the field of the actual data type, an alarm user is prompted to correct, and the corrected data can participate in the subsequent business system calculation.
In this embodiment, the relational mapping table in step S12 represents the corresponding relationship between the column name of the user table, the field name of the database table, and the general data type, where generally the column name of the user table is chinese, and the field name of the database table is english, so as to obtain the relational mapping table shown in table 4;
table 4: relational mapping table
| User table column name | Database field | Field type |
| Year of year | YearText | varchar |
| Task name | TaskName | varchar |
| Task type | TaskTypeText | varchar |
| Scheduled completion date | PlanDateText | varchar |
| Current progress | ProgressText | varchar |
| Date of completion | CompleteDateText | varchar |
After the relational mapping table is created, if the 'year' in the user table is modified into 'task year', the relational mapping table is only required to be modified without modifying any code, so that the program expansibility is enhanced.
In this embodiment, when creating a database table, the field at the end of Text in table 3 is a field of a created general data type, the general data type has only two types, namely, a field string and a binary system, the binary system is used for storing data which cannot be represented by a character string, such as pictures, audio, video, and the like, while an actual basic data type, such as integer (integer), floating point (decimal), date, character string, and the like, is a character string type itself, and thus, there is no need to create a field of a general data type.
In step S13 of this embodiment, based on the mapping table, in the windows environment, the data in the user table is read by using the Com component.
In this embodiment, when the user table is read according to the map table, considering that the user table may have a watermark system, the user table should be opened in a general manner to read data, and the storage of the user table data to the persistent layer is completed according to the map table. The method for reading the user form data comprises various modes, such as the most common NPOI with good compatibility, however, enterprises and public institutions with confidentiality requirements can install the watermarking system, computers with the watermarking system can be added with extra characters after Excel is opened and edited, the document can be opened locally by using office software, but cannot be opened if the document is directly copied to other computers, and therefore the security and confidentiality of the data are guaranteed. The form added with extra characters cannot be read by directly using the API of the NPOI, and a user can adopt a mode of adding a white list for solving the problem, however, in fact, many enterprises and public institutions with confidentiality requirements are not willing to select to add software into the white list, so in order to improve the compatibility of the program, the embodiment should adopt the office software of the local computer environment of the user as much as possible to read data, and under the windows environment, the data in the user form can be read by adopting a Com component mode.
In step S13 of this embodiment, the read data is buffered by configuring the buffer, and when the storage amount of the buffer is reached, the buffered data is stored in the database table.
In this embodiment, when the amount of user table data is large, it is not advisable to persist a piece of data to the database table by reading it, and the efficiency is low. The size of the cache area in this embodiment is configured as needed according to the actual operating environment of the computer.
In step S14 of this embodiment, the data in the buffer is stored in the field ending in Text in the database table 3.
After the above process is completed, no matter how irregular or unreasonable the user form data is, the data can still normally perform the database table of the system.
In this embodiment, the data processing rule in step S2 includes a data type conversion rule and a data verification rule, where the data type conversion rule refers to converting a general data type of a field into an actual data type, and the data verification rule includes a repeatability verification, a non-null verification, and a value interval verification;
in the embodiment, automatic color marking is carried out on data with data type conversion failure or data verification error in the database table processing process, and manual correction is carried out by a user.
In this embodiment, as can be seen from table 3, for a field of a non-string type, a string type is set in this embodiment to store original data in a user table, for example, "Year" in row 4 of table 1, a value of Year Text is "task", when data conversion is performed, a value of Year Text needs to be converted into Year field, the Year field is Int type, and "task" cannot be converted into Int, so that it is automatically color-marked on a user interface as data of which data type conversion fails.
In this embodiment, when data verification is performed, as shown in table 1, if a unique field "year + task name" is set, the fifth row and the sixth row are repeated, if a field "planned completion date" is set as a mandatory field, the sixth row has a wrong data verification result, and if a data value interval is set as 1990-2999, the fifth row has a wrong data verification result, and the data is automatically color-labeled at the user interface to be used as data that fails in data verification.
In step S3 of this embodiment, the fields in the database table 3 that are not the end of Text (i.e., actual data type) participate in user transactions.
Example 2:
the present embodiment provides a form data input processing apparatus formed based on the form data input processing method in the embodiment, as shown in fig. 2, including:
the table acquisition module is used for acquiring a user table to be processed;
the data mapping module is used for persisting data in the user table into a database table;
and the data processing module is used for carrying out data type conversion and data verification processing on the data in the database.
The mapping module in this embodiment includes:
the database table unit is used for constructing a database table corresponding to the data in the user table;
the relational mapping table unit is used for constructing a relational mapping table representing the corresponding relation between the database table and the user table;
and the data persistence unit is used for persisting the data in the user table to the database table according to the relational mapping table.
The embodiment constructs the principle of adopting delayed data processing and general data structure design, and the form data input processing device based on the principle that a large amount of natural data quickly enters a service system has high data fault tolerance, meets the requirement that a user wants a large amount of irregular historical data to quickly input an informationized software system, has flexible and changeable data processing capacity, and avoids the condition that certain data is irregular to cause that the data of the whole user can not enter the system.
Example 3:
the present embodiment provides a computer-readable storage medium storing a computer program that implements the steps of the form data input processing method when the computer program is executed. For example, the computer readable storage medium may be the above-mentioned memory including program instructions executable by a processor of an electronic device to perform the above-mentioned form data input processing method.
In the embodiment of the present invention, the computer-readable storage medium includes, but is not limited to, various media that can store program codes, such as a usb disk, a removable hard disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a magnetic disk, or an optical disk.
The embodiments are described in a progressive mode in the specification, the emphasis of each embodiment is on the difference from the other embodiments, and the same and similar parts among the embodiments can be referred to each other. The device disclosed by the embodiment corresponds to the method disclosed by the embodiment, so that the description is simple, and the relevant points can be referred to the method part for description. It should be noted that, for those skilled in the art, without departing from the principle of the present application, the present application can also make several improvements and modifications, and those improvements and modifications also fall into the protection scope of the claims of the present application.
Claims (7)
1. A form data input processing method is characterized by comprising the following steps:
s1, persisting the user table to a database table;
the database table is a two-dimensional table used for storing data in a user table in a persistent layer;
s2, loading the database table to a user interface, and processing the database table according to the data processing rule;
s3, the processed database table participates in the user service, and the form data input processing is completed;
the step S1 specifically includes:
s11, determining the column name of the user table, and creating a database table;
s12, creating a relational mapping table between the user table and the database table;
s13, reading data in the user table based on the relational mapping table, and storing the data in the user table to a database table;
in step S11, two data types of fields are used to describe the column name of the user table, including an actual data type and a general data type;
the database table comprises field names, field Chinese names and field types, the field type of each field has a corresponding general data type, and the general data type is used for storing any input of a user;
the relational mapping table in the step S12 represents the corresponding relationship between the column name of the user table, the field name of the database table, and the general data type;
the data processing rule in step S2 includes a data type conversion rule and a data verification rule;
the data type conversion rule is used for converting the general data type of the field into an actual data type;
the data checking rule comprises repeatability checking, non-null checking and numerical value interval checking.
2. The tabular data input processing method of claim 1, wherein in step S13, data in the user table is read by means of Com component in windows environment based on the relational mapping table.
3. The form data input processing method of claim 1, wherein in step S13, the read data is buffered by configuring a buffer, and the buffered data is stored in the database table when the storage amount of the buffer is reached.
4. The tabular data input processing method of claim 1,
in step S2, the data that has failed to be converted into data types or has been checked incorrectly in the database table processing process is automatically color-labeled, and is manually corrected by the user.
5. A tabular data input processing apparatus based on the tabular data input processing method according to any one of claims 1 to 4, comprising:
the table acquisition module is used for acquiring a user table to be processed;
the data mapping module is used for persisting data in the user table into a database table;
and the data processing module is used for carrying out data type conversion and data verification processing on the data in the database.
6. The tabular data input processing device of claim 5, wherein said mapping module comprises:
the database table unit is used for constructing a database table corresponding to the data in the user table;
the relational mapping table unit is used for constructing a relational mapping table representing the corresponding relation between the database table and the user table;
and the data persistence unit is used for persisting the data in the user table to the database table according to the relational mapping table.
7. A computer-readable storage medium storing a computer program, wherein the steps of the table data input processing method according to any one of claims 1 to 4 are implemented when the computer program is executed.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210352843.2A CN114490672B (en) | 2022-04-06 | 2022-04-06 | Table data input processing method and device and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210352843.2A CN114490672B (en) | 2022-04-06 | 2022-04-06 | Table data input processing method and device and storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN114490672A CN114490672A (en) | 2022-05-13 |
| CN114490672B true CN114490672B (en) | 2022-06-21 |
Family
ID=81488027
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202210352843.2A Active CN114490672B (en) | 2022-04-06 | 2022-04-06 | Table data input processing method and device and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN114490672B (en) |
Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1862538A (en) * | 2006-02-27 | 2006-11-15 | 华为技术有限公司 | Data configuration system and method for implementing data configuration |
| CN101980190A (en) * | 2010-10-15 | 2011-02-23 | 中兴通讯股份有限公司 | Method and device for quickly putting service data into base |
| CN106294825A (en) * | 2016-08-17 | 2017-01-04 | 浪潮软件股份有限公司 | A kind of excel data managing method and system, client, service end |
| WO2017071135A1 (en) * | 2015-10-28 | 2017-05-04 | 北京汇商融通信息技术有限公司 | Data migration system based on various data storage platforms |
| WO2017156673A1 (en) * | 2016-03-14 | 2017-09-21 | 华为技术有限公司 | Processing method and device for stored procedure |
| CN111966717A (en) * | 2020-09-04 | 2020-11-20 | 苏州浪潮智能科技有限公司 | Data access method and system for reducing database crash probability |
| WO2021051625A1 (en) * | 2019-09-16 | 2021-03-25 | 平安科技（深圳）有限公司 | Data table construction method, apparatus and device, and storage medium |
| CN113448960A (en) * | 2020-03-27 | 2021-09-28 | 北京沃东天骏信息技术有限公司 | Method and device for importing form file |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110502478B (en) * | 2019-08-23 | 2023-05-23 | 成都九洲电子信息系统股份有限公司 | Data interaction method and system between offline systems |
-
2022
- 2022-04-06 CN CN202210352843.2A patent/CN114490672B/en active Active
Patent Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1862538A (en) * | 2006-02-27 | 2006-11-15 | 华为技术有限公司 | Data configuration system and method for implementing data configuration |
| CN101980190A (en) * | 2010-10-15 | 2011-02-23 | 中兴通讯股份有限公司 | Method and device for quickly putting service data into base |
| WO2017071135A1 (en) * | 2015-10-28 | 2017-05-04 | 北京汇商融通信息技术有限公司 | Data migration system based on various data storage platforms |
| WO2017156673A1 (en) * | 2016-03-14 | 2017-09-21 | 华为技术有限公司 | Processing method and device for stored procedure |
| CN106294825A (en) * | 2016-08-17 | 2017-01-04 | 浪潮软件股份有限公司 | A kind of excel data managing method and system, client, service end |
| WO2021051625A1 (en) * | 2019-09-16 | 2021-03-25 | 平安科技（深圳）有限公司 | Data table construction method, apparatus and device, and storage medium |
| CN113448960A (en) * | 2020-03-27 | 2021-09-28 | 北京沃东天骏信息技术有限公司 | Method and device for importing form file |
| CN111966717A (en) * | 2020-09-04 | 2020-11-20 | 苏州浪潮智能科技有限公司 | Data access method and system for reducing database crash probability |
Non-Patent Citations (4)
| Title |
|---|
| ".NET环境下数据库数据和Excel表数据的对接";郝世选;《电脑编程技巧与维护》;20141203(第23期);52-53 * |
| "ASP.NET中将EXCEL导入数据库的通用模块设计与实现";邓永海、邓梅、李朝荣;《微计算机信息》;20110215;第27卷(第02期);240-242 * |
| "两种非匀质Excel表转换成关系数据库表的方法";方木云、赵长鲜、张祝梦;《软件工程》;20200505;第23卷(第05期);31-34 * |
| "基于Web的结构安全监测云平台设计与实现";宗原、严冬;《电子设计工程》;20150820;第23卷(第16期);39-42+46 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN114490672A (en) | 2022-05-13 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US7996759B2 (en) | Data insertion from a database into a fixed electronic template form that supports overflow data | |
| US10007654B2 (en) | Feedback validation of electronically generated forms | |
| US5557780A (en) | Electronic data interchange system for managing non-standard data | |
| US20070300295A1 (en) | Systems and methods to extract data automatically from a composite electronic document | |
| US20140348396A1 (en) | Extracting data from semi-structured electronic documents | |
| US11775489B2 (en) | Consolidating multiple databases into a single or a smaller number of databases | |
| CN111291049A (en) | Method, device, equipment and storage medium for creating table | |
| US20080249988A1 (en) | Computer programming method and system for performing a reversal of selected structured query language operations within a database transaction | |
| WO2019179067A1 (en) | Service logic processing method and system, computer device, and storage medium | |
| CN112926299B (en) | Text comparison method, contract review method and auditing system | |
| US20050216497A1 (en) | Uniform financial reporting system interface utilizing staging tables having a standardized structure | |
| CN111831282A (en) | Low-code form development method and system based on VUE technology | |
| CN110175211B (en) | Data synchronization method and device | |
| CN115116082A (en) | One-key filing system based on OCR recognition algorithm | |
| CN114490672B (en) | Table data input processing method and device and storage medium | |
| US20180039828A1 (en) | Generating a signed electronic document | |
| CN104679736A (en) | Translation system allowing statistics of simple mistakes | |
| CN109241167B (en) | Table data importing method based on BS framework | |
| WO2007109988A1 (en) | Electronic table data processing method and system based on time sequences | |
| US20100023517A1 (en) | Method and system for extracting data-points from a data file | |
| US11055795B1 (en) | Methods, systems, and computer program products for linking data schemas to electronic tax return | |
| CN113254520B (en) | Method for processing credit investigation data missing report and automatically generating supplementary message | |
| CN111222310A (en) | Method and system for inputting and displaying irregular form | |
| CN110457659B (en) | Clause document generation method and terminal equipment | |
| Kwok et al. | An automatic method to extract data from an electronic contract composed of a number of documents in PDF format |
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 |