CN113190601A - Automatic table information importing method and system - Google Patents
Automatic table information importing method and system Download PDFInfo
- Publication number
- CN113190601A CN113190601A CN202110290591.0A CN202110290591A CN113190601A CN 113190601 A CN113190601 A CN 113190601A CN 202110290591 A CN202110290591 A CN 202110290591A CN 113190601 A CN113190601 A CN 113190601A
- Authority
- CN
- China
- Prior art keywords
- information
- file
- mapping
- field
- format
- 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
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/258—Data format conversion from or to a database
-
- 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/24564—Applying rules; Deductive queries
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- Software Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention relates to a method and a system for automatically importing table information, wherein the method comprises the following steps: acquiring a form filling format file, formatting the form filling format file into a standard data format according to a cell sequence, wherein the standard data format comprises a plurality of unit information, and each unit information comprises a file field and data information thereof; mapping the file field and preset system field information according to a preset mapping rule; and assembling the data information of the file field corresponding to the system field information mapping with the system field information to form standardized system information. Compared with the prior art, the method has the advantages of simple and convenient operation, capability of greatly avoiding the labor cost of daily manual checking and software development and the like.
Description
Technical Field
The invention relates to the technical field of table information processing, in particular to a method and a system for automatically importing table information.
Background
The form, also called table, is a visual communication mode and a means for organizing and organizing data. In the application of some forms at present, information in the form needs to be imported into a corresponding information system, for example, an order form information entry order processing system, there are two forms information import schemes at present:
1. and (4) manually making an order form and then importing the order form into the system. However, because only one import table is available, the format is relatively fixed, and the user has to import the table according to the fixed format every time the user imports the table. This type of operation is inefficient and the large amount of manual form editing work takes time. And the probability of manual error is high. Sometimes it is often necessary for multiple people to process forms together to complete the work on time. The prior art scheme has the defects of low efficiency, high labor cost and high manual error rate.
2. The third-party software service company is required to customize and manufacture a plurality of import templates, but special compiling software is required to be manufactured. Often, a plurality of research and development personnel are required to be invested, and the development is completed in one month or even several months. The disadvantages of this approach are high capital cost of development, affordability by only a few companies, difficulty in popularizing the technical solution, and extremely low solution coverage.
Disclosure of Invention
The invention aims to provide a method and a system for automatically importing form information to overcome the defects of low efficiency, high labor cost, high manual error rate and high development capital cost in the prior art.
The purpose of the invention can be realized by the following technical scheme:
an automatic importing method of table information comprises the following steps:
acquiring a form filling format file, formatting the form filling format file into a standard data format according to a cell sequence, wherein the standard data format comprises a plurality of unit information, and each unit information comprises a file field and data information thereof;
mapping the file field with preset system field information according to a preset mapping rule;
and assembling the data information of the file field corresponding to the system field information mapping with the system field information to form standardized system information.
Further, the mapping rule includes performing direct mapping or one-to-many mapping between the keywords of the file fields and the system fields, where the direct mapping maps one file field for each piece of system field information, and the one-to-many mapping maps one piece of system field information to multiple file fields.
Further, the automatic table information importing method further includes: and superposing or sequentially combining the data information corresponding to the multiple file fields of the one-to-many mapping.
Further, the automatic form information importing method further includes standardizing the data information, and assembling the data information with the system field information to form the standardized system information;
the normalization process includes adding a fixed prefix, adding a fixed suffix, time formatting, and/or adding a default value;
the adding of the fixed prefix is as follows: adding a preset fixed prefix in front of the data information;
the added fixed suffix is: adding a preset fixed suffix behind the data information;
the time is formatted as: converting the time data format in the data information into a preset standard time format;
the default values for the increase are: and after the system information is assembled according to the data information and the system field information, adding preset default information into the system information.
Further, the form filling format file is a form filling format file based on an order information form.
Further, the automatic form information importing method further comprises the step of adjusting the mapping rule according to file fields in the form filling format file.
Further, the standard data format is a json format;
the form filling format file is an EXCEL file, a TXT file or a WORD file.
The invention also provides a table information automatic leading-in system, comprising:
the system comprises an importing unit, a processing unit and a processing unit, wherein the importing unit is used for acquiring a form filling format file, formatting the form filling format file into a standard data format according to a cell sequence, the standard data format comprises a plurality of unit information, and each unit information comprises a file field and data information thereof;
the configuration unit is used for setting mapping rules and system field information;
the mapping unit is used for mapping the file fields with the system field information in sequence according to the mapping rule; and assembling the data information of the file field corresponding to the system field information mapping with the system field information to form standardized system information.
Further, the mapping rule includes performing direct mapping or one-to-many mapping on the system fields according to keywords of the file fields, where the direct mapping maps one file field for each piece of system field information, and the one-to-many mapping maps one piece of system field information to multiple file fields;
the mapping unit is further configured to superimpose or sequentially combine data information corresponding to the plurality of file fields of the one-to-many mapping.
Further, the mapping unit is further configured to perform normalization processing on the data information, so as to assemble the data information with the system field information to form the normalized system information;
the normalization process includes adding a fixed prefix, adding a fixed suffix, time formatting, and/or adding a default value;
the adding of the fixed prefix is as follows: adding a preset fixed prefix in front of the data information;
the added fixed suffix is: adding a preset fixed suffix behind the data information;
the time is formatted as: converting the time data format in the data information into a preset standard time format;
the default values for the increase are: and after the system information is assembled according to the data information and the system field information, adding preset default information into the system information.
Compared with the prior art, the invention has the following advantages:
(1) in the prior art, aiming at different order filling formats, manual checking is needed and converted into a standard format or each filling format is identified by a software development mode; however, the method can complete an intelligent order template only by completing the configuration once; the operation is simple.
(2) Manually checking and converting the format into a standard format, wherein each format takes 2-4 hours per day to complete conversion; the method of the invention has fast configuration, and can be completed in a few minutes only by configuring the mapping rule and the system field information.
(3) And in the software development mode, each format needs 5-7 days to develop online. The method of the invention can be completed by one-time configuration without customized development.
(4) The method adopts a mode of combining mapping and identification, and each filling format only needs to be configured for 10 minutes once, so that the labor cost of daily manual checking and software development can be completely saved.
Drawings
Fig. 1 is a schematic flowchart of an embodiment of an automatic table information importing method according to the present invention;
fig. 2 is a schematic view of a processing flow for entering an order information form into a system according to the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the embodiments of the present invention clearer, the technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are some, but not all, embodiments of the present invention. The components of embodiments of the present invention generally described and illustrated in the figures herein may be arranged and designed in a wide variety of different configurations.
Thus, the following detailed description of the embodiments of the present invention, presented in the figures, is not intended to limit the scope of the invention, as claimed, but is merely representative of selected embodiments of the invention. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
It should be noted that: like reference numbers and letters refer to like items in the following figures, and thus, once an item is defined in one figure, it need not be further defined and explained in subsequent figures.
In the description of the present invention, it should be noted that the terms "center", "upper", "lower", "left", "right", "vertical", "horizontal", "inner", "outer", etc. indicate orientations or positional relationships based on the orientations or positional relationships shown in the drawings or the orientations or positional relationships that the products of the present invention are conventionally placed in use, and are only used for convenience in describing the present invention and simplifying the description, but do not indicate or imply that the devices or elements referred to must have a specific orientation, be constructed and operated in a specific orientation, and thus, should not be construed as limiting the present invention.
It should be noted that the terms "first" and "second" are used for descriptive purposes only and are not to be construed as indicating or implying relative importance or implicitly indicating the number of technical features indicated. Thus, a feature defined as "first" or "second" may explicitly or implicitly include one or more of that feature. In the description of the present application, "a plurality" means two or more unless specifically limited otherwise.
Furthermore, the terms "horizontal", "vertical" and the like do not imply that the components are required to be absolutely horizontal or pendant, but rather may be slightly inclined. For example, "horizontal" merely means that the direction is more horizontal than "vertical" and does not mean that the structure must be perfectly horizontal, but may be slightly inclined.
Example 1
Referring to fig. 1, the present embodiment provides an automatic table information importing method, including the following steps:
s1: acquiring a form filling format file, formatting the form filling format file into a standard data format according to a cell sequence, wherein the standard data format comprises a plurality of unit information, and each unit information comprises a file field and data information thereof;
the form filling format file is formatted into a standard data format, so that file fields and data information in the form can be conveniently identified and distinguished, and subsequent data processing is facilitated. The standard data format can be json format; the form fill format file may be an EXCEL file, a TXT file, or a WORD file.
S2: mapping the file field and preset system field information according to a preset mapping rule;
the mapping rule comprises the steps of carrying out direct mapping or one-to-many mapping on system fields according to keywords of the file fields, wherein the direct mapping is used for correspondingly mapping one file field for each piece of system field information, and the one-to-many mapping is used for correspondingly mapping one piece of system field information to a plurality of file fields.
The mapping rules can be adjusted according to the file fields in the form filling format file to ensure the completeness and accuracy of the mapping rules.
S3: and standardizing the data information, and assembling the standardized data information of the file fields corresponding to the system field information mapping with the system field information to form standardized system information.
The normalization process includes one or more of adding a fixed prefix, adding a fixed suffix, time formatting, adding a default value, and one-to-many mapping information combination, and is specifically explained as follows:
adding a fixed prefix as follows: adding a preset fixed prefix in front of the data information;
adding a fixed suffix as: adding a preset fixed suffix behind the data information;
the time is formatted as: converting a time data format in the data information into a preset standard time format;
the default values are added as follows: after system information is assembled according to the data information and the system field information, preset default information is added into the system information;
one-to-many mapping information combination: and overlapping or sequentially combining the data information corresponding to the multiple file fields of the one-to-many mapping.
By adopting the method, the information in the form can be automatically input into the system without manual input or establishment of an import template, thereby reducing the workload and the cost.
The form filling format file may be a form filling format file based on an order information form, and a specific implementation process is described below in connection with the order information form:
referring to fig. 2, in the specific implementation process, the order information form needs to be entered into the system, and the specific implementation process specifically includes the following steps:
1) uploading the existing order filling format file of the user, including but not limited to formats such as EXCEL, TXT, WORD, and the like;
2) reading the order filling format file, and storing the format content matched with the corresponding field in the system in the file, wherein the format content comprises the file field and the data information thereof. Taking an EXCEL file as an example: the front-end page reads the EXCEL file content and formats the EXCEL file content into a standard json format according to the cell order. Key elements of the json format include: cell locations and fill content, such as cell A1 for order number, A2 for weight, A3 for shipping address; and determining the position of the cell corresponding to the file field, so that the data information of the file field can be conveniently assembled after the mapping is constructed.
3) The system reads the json data and analyzes and compares the file fields with the system fields one by one. For example, if a "cell a 1" is filled with a document field such as "sales order number"/"customer order number", the system will search the keyword "order number" to make the cell correspond to a system defined system field: "order number".
In addition to the direct correspondence of S3, a plurality of cells are supported in sequential combination and one-to-many correspondence. In the order number and the remark information of the logistics order, a plurality of order key elements such as the order number, the information of a receiver and a sender and the like often appear, and the requirement can be met by combining a plurality of cells in sequence;
after the field mapping, the data information also needs to be processed, specifically including adding a fixed prefix, adding a fixed suffix, time formatting, adding a default value, and the like.
The fixed prefix and the fixed suffix are common, and many order files can require the system to be automatically completed; many logistics orders come from different countries and regions, the date and time formats are different, the time is converted into the system standard format, and errors caused by manual conversion are reduced; due to characteristics of industry or transportation modes, the content and format of many logistics order information are fixed, such as shipper information, goods types, transportation modes, settlement modes and the like, which are not embodied in order files but need to be input into a system as default information.
In addition to system correspondence, the system also provides a manual correspondence.
4) And after the system finishes the mapping on the order filling format file, assembling order data according to the order of the cells, and finishing order data entry.
Because the order file formats of the contract logistics industry are different, sometimes even key information such as a continuous sending and goods delivery party and the like cannot be filled. Through the means, the logistics order files with different formats can be stored as standardized order information through the system.
According to another aspect of the present invention, there is provided a form information automatic import system, including:
the import unit is used for acquiring the form filling format file, formatting the form filling format file into a standard data format according to the order of the cells, wherein the standard data format comprises a plurality of unit information, and each unit information comprises a file field and data information thereof;
the configuration unit is used for setting mapping rules and system field information, filling file fields in the format file according to the form and adjusting the mapping rules;
the mapping unit is used for mapping the file fields with the system field information in sequence according to the mapping rule; and assembling the data information of the file field corresponding to the system field information mapping with the system field information to form standardized system information.
The standard data format is json format; the form filling format file is an EXCEL file, a TXT file or a WORD file.
The mapping rule comprises the steps of carrying out direct mapping or one-to-many mapping on system fields according to keywords of the file fields, wherein the direct mapping is used for correspondingly mapping one file field for each piece of system field information, and the one-to-many mapping is used for correspondingly mapping one piece of system field information to a plurality of file fields;
the mapping unit is further used for overlapping or sequentially combining the data information corresponding to the multiple file fields of the one-to-many mapping.
The mapping unit is also used for carrying out standardization processing on the data information so as to be assembled with the system field information to form standardized system information;
the normalization process includes adding fixed prefixes, adding fixed suffixes, time formatting, and/or adding default values;
adding a fixed prefix as follows: adding a preset fixed prefix in front of the data information;
adding a fixed suffix as: adding a preset fixed suffix behind the data information;
the time is formatted as: converting a time data format in the data information into a preset standard time format;
the default values are added as follows: and after the system information is assembled according to the data information and the system field information, adding preset default information into the system information.
Preferably, the form filling format file is a form filling format file based on the order information form.
The foregoing detailed description of the preferred embodiments of the invention has been presented. It should be understood that numerous modifications and variations could be devised by those skilled in the art in light of the present teachings without departing from the inventive concepts. Therefore, the technical solutions available to those skilled in the art through logic analysis, reasoning and limited experiments based on the prior art according to the concept of the present invention should be within the scope of protection defined by the claims.
Claims (10)
1. An automatic table information importing method is characterized by comprising the following steps:
acquiring a form filling format file, formatting the form filling format file into a standard data format according to a cell sequence, wherein the standard data format comprises a plurality of unit information, and each unit information comprises a file field and data information thereof;
mapping the file field with preset system field information according to a preset mapping rule;
and assembling the data information of the file field corresponding to the system field information mapping with the system field information to form standardized system information.
2. The method as claimed in claim 1, wherein the mapping rule includes mapping directly the system field according to the key of the file field or mapping one to many, the direct mapping maps one file field for each system field, and the mapping one to many maps one file field for each system field.
3. The method according to claim 2, wherein the method further comprises: and superposing or sequentially combining the data information corresponding to the multiple file fields of the one-to-many mapping.
4. The method according to claim 1, wherein the method further comprises standardizing the data information to be assembled with the system field information to form the standardized system information;
the normalization process includes adding a fixed prefix, adding a fixed suffix, time formatting, and/or adding a default value;
the adding of the fixed prefix is as follows: adding a preset fixed prefix in front of the data information;
the added fixed suffix is: adding a preset fixed suffix behind the data information;
the time is formatted as: converting the time data format in the data information into a preset standard time format;
the default values for the increase are: and after the system information is assembled according to the data information and the system field information, adding preset default information into the system information.
5. The method as claimed in claim 1, wherein the form filling format file is a form filling format file based on an order information form.
6. The method as claimed in claim 1, further comprising adjusting the mapping rule according to a file field in the form filling format file.
7. The method according to claim 1, wherein the standard data format is json format;
the form filling format file is an EXCEL file, a TXT file or a WORD file.
8. An automatic form information importing system, comprising:
the system comprises an importing unit, a processing unit and a processing unit, wherein the importing unit is used for acquiring a form filling format file, formatting the form filling format file into a standard data format according to a cell sequence, the standard data format comprises a plurality of unit information, and each unit information comprises a file field and data information thereof;
the configuration unit is used for setting mapping rules and system field information;
the mapping unit is used for mapping the file fields with the system field information in sequence according to the mapping rule; and assembling the data information of the file field corresponding to the system field information mapping with the system field information to form standardized system information.
9. The system of claim 8, wherein the mapping rule includes direct mapping or one-to-many mapping between the system field and the key of the file field, the direct mapping maps one file field for each system field, and the one-to-many mapping maps one system field for a plurality of file fields;
the mapping unit is further configured to superimpose or sequentially combine data information corresponding to the plurality of file fields of the one-to-many mapping.
10. The system of claim 8, wherein the mapping unit is further configured to normalize the data information, and assemble the normalized data information with the system field information to form the normalized system information;
the normalization process includes adding a fixed prefix, adding a fixed suffix, time formatting, and/or adding a default value;
the adding of the fixed prefix is as follows: adding a preset fixed prefix in front of the data information;
the added fixed suffix is: adding a preset fixed suffix behind the data information;
the time is formatted as: converting the time data format in the data information into a preset standard time format;
the default values for the increase are: and after the system information is assembled according to the data information and the system field information, adding preset default information into the system information.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110290591.0A CN113190601A (en) | 2021-03-18 | 2021-03-18 | Automatic table information importing method and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110290591.0A CN113190601A (en) | 2021-03-18 | 2021-03-18 | Automatic table information importing method and system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN113190601A true CN113190601A (en) | 2021-07-30 |
Family
ID=76973430
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110290591.0A Pending CN113190601A (en) | 2021-03-18 | 2021-03-18 | Automatic table information importing method and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113190601A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114331494A (en) * | 2021-12-01 | 2022-04-12 | 特赞（上海）信息科技有限公司 | Quotation system, quotation method, electronic equipment and storage medium |
-
2021
- 2021-03-18 CN CN202110290591.0A patent/CN113190601A/en active Pending
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114331494A (en) * | 2021-12-01 | 2022-04-12 | 特赞（上海）信息科技有限公司 | Quotation system, quotation method, electronic equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US20020099735A1 (en) | System and method for conducting electronic commerce | |
| US20050102192A1 (en) | Method and apparatus for processing of purchase orders | |
| US20060111966A1 (en) | Supplier performance reporting | |
| US20190102733A1 (en) | Logistics information acquisition method and system for transnational transport | |
| CN109062872B (en) | Method for uniformly processing customs files with different formats | |
| US20150242456A1 (en) | System and method for electronic data reconciliation and clearing | |
| US11720867B2 (en) | Automated, history-based correction of electronic remittances for programmatic reconciliation of electronic receivables | |
| CN110347709A (en) | A kind of construction method and system of regulation engine | |
| US20110093385A1 (en) | Customer Identification of Transactions and Financial Transaction Record Matching | |
| US20070295799A1 (en) | Reusable identification system and method | |
| CN107909326B (en) | Chain journey transportation method and system for international logistics | |
| US10366351B2 (en) | Information standardization and verification | |
| CN113190601A (en) | Automatic table information importing method and system | |
| US11748368B1 (en) | Data field transaction repair interface | |
| CN105160036A (en) | Enterprise non-bank information query method | |
| US20050096967A1 (en) | Method and apparatus for processing of purchase orders | |
| CN110781235A (en) | Big data based purchase data processing method and device, terminal and storage medium | |
| AU2016102445A4 (en) | Logistics information acquisition method and system for transnational transport | |
| US20130300562A1 (en) | Generating delivery notification | |
| US20140316830A1 (en) | Synchronized Resource Planning | |
| CN111788591A (en) | Supplier evaluation system and supplier evaluation method | |
| CN115357596A (en) | Electronic commerce order generation system and order generation method | |
| CN110570207A (en) | commodity tracing method and device | |
| CN111950560A (en) | Invoice checking device and method | |
| EP3522087A1 (en) | Multi-source address management systems and methods |
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 |