Unlock instant, AI-driven research and patent intelligence for your innovation.

Automatic table information importing method and system

A form information, automatic technology, applied in database management system, digital data information retrieval, special data processing applications, etc., can solve the problems of high manual error rate, high labor cost, low efficiency and so on

Pending Publication Date: 2021-07-30
壹站(上海)供应链管理有限公司
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] The purpose of the present invention is to provide a method and system for automatically importing table information in order to overcome the defects of low efficiency, high labor cost, high manual error rate and high development capital cost in the above-mentioned prior art

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Automatic table information importing method and system
  • Automatic table information importing method and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0049] refer to figure 1 As shown, this embodiment provides a method for automatically importing table information, including the following steps:

[0050] S1: Obtain the form filling format file, format the form filling format file into a standard data format according to the order of the cells, the standard data format includes multiple unit information, and each unit information includes file fields and their data information;

[0051]Formatting the form filling format file into a standard data format can facilitate the identification and distinction of file fields and data information in the form, facilitating subsequent data processing. The standard data format can be json format; the form filling format file can be EXCEL file, TXT file or WORD file.

[0052] S2: Map file fields with preset system field information according to preset mapping rules;

[0053] The mapping rules include direct mapping or one-to-many mapping based on the keyword of the file field and the sy...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention relates to an automatic table information importing method and system, and the method comprises the following steps: obtaining a table filling format file, formatting the table filling format file into a standard data format according to a cell sequence, the standard data format comprises a plurality of pieces of unit information, and each piece of unit information comprises a file field and data information thereof; mapping the file fields with preset system field information according to a preset mapping rule; and assembling the data information of the file fields corresponding to the mapping of the system field information with the system field information to form standardized system information. Compared with the prior art, the invention has the advantages that the operation is simple and convenient, and the labor cost of daily manual checking and software development can be greatly saved.

Description

technical field [0001] The invention relates to the technical field of table information processing, in particular to a method and system for automatically importing table information. Background technique [0002] Tables, also known as tables, are both a visual communication mode and a means of organizing data. At present, in the application of some forms, the information in the form needs to be imported into the corresponding information system. For example, the order form information is entered into the order processing system. Currently, there are two ways to import form information: [0003] 1. Manually make an order form and import it into the system. However, since there is only one type of import form and the format is relatively fixed, the user must import according to the fixed format each time to succeed. This way of working is inefficient, and the work of manually editing tables takes a lot of time. And the probability of human error is high. Sometimes it tak...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Applications(China)
IPC IPC(8): G06F16/25G06F16/2455G06F16/22
CPCG06F16/2282G06F16/24564G06F16/258
Inventor 周永钢
Owner 壹站(上海)供应链管理有限公司