A method and system for data import

Abstract

The invention discloses a data import method and a data import system. The method comprises the following steps of: configuring unique identification information of a data import action for a form; configuring a positioning value of import data of each field in the form, wherein the positioning value is a position area where a data item of the field in an excel file is located; configuring the data import action as one of menu items of the form; Generating an entry of the data import action on the user operation menu; and receiving an excel file, obtaining a data item of a corresponding fieldin the excel file according to the positioning value, and storing the data item in a database. According to the invention, the format of the imported data can be configured according to the excel filedesigned by the user; according to the method, the corresponding menu item and the import data entry are generated through the informatization management system, the operation step of configuring theimport data format is very simple, the user operation is facilitated, the system use efficiency is improved, the requirements of enterprises can be rapidly and flexibly met, and the system maintenance cost is reduced.

Description

technical field [0001] The invention relates to the technical field of information management, in particular to a data import method and system. Background technique [0002] In the current enterprise information management system, if employees need to add various data information in the system, such as employee information, customer information, supplier information, etc., they need to be added one by one in the system, or made according to the template specified by the system. excel file, and then import the excel file. However, corresponding to different forms, such as customer information form and supplier information form, the form fields are different, and the excel form of the unified template cannot be used. Therefore, it is necessary to configure different templates according to different forms. In this way, it is necessary to make corresponding configurations at the beginning of designing the information management system. However, the plan cannot keep up with th...

AI Technical Summary

Problems solved by technology

However, the plan cannot keep up with the changes. In the future, when the enterprise needs to change the template during use, the designer needs to change the design. It can be seen that the data import method of the existing technology cannot flexibly adapt to the needs of the enterprise, and the maintenance cost is high.

Images