WO2019205415A1

WO2019205415A1 - Data import management method and apparatus, mobile terminal and storage medium

Info

Publication number: WO2019205415A1
Application number: PCT/CN2018/104730
Authority: WO
Inventors: 罗先贤; 龙觉刚; 孙成; 叶俊锋; 赖云辉
Original assignee: 平安科技（深圳）有限公司
Priority date: 2018-04-22
Filing date: 2018-09-08
Publication date: 2019-10-31
Also published as: CN108874866A

Abstract

The present application relates to the field of Excel importing, in particular to a data import management method and apparatus, a mobile terminal and a storage medium. The data import management method comprises: generating a configuration table by means of a configuration table generation interface, and setting configuration information in the configuration table; setting a check rule interface parallel to the configuration table generation interface at a front end where the configuration table generation interface is located, in order to generate a check rule or import a check rule that has been formulated in advance; and importing, on the front-end interface where the configuration table generation interface is located, a data table using an account having an import right. An import table is imported by means of making a configuration table in advance, without redeployment. The import right is controlled, and the importing of data that does not meet conditions is avoided by means of temporary storage and checking, thereby improving the import efficiency.

Description

Data import management method, device, mobile terminal and storage medium

This application claims priority to Chinese Patent Application No. 201810363680.1, entitled "Data Import Management Method, Apparatus, Mobile Terminal, and Storage Medium", filed on April 22, 2018, the entire contents of which are incorporated by reference. Combined in this application.

Technical field

The present application relates to the field of computer technologies, and in particular, to a data import management method, apparatus, mobile terminal, and storage medium.

Background technique

In the real estate exchange system, each time new data is added, the Excel data table is often imported into the system to increase the data. Before importing the data, the template needs to be imported in advance to adapt to the structural difference of each data table. Templates need to use the import function to re-implement the import step, the system also needs to redeploy the background template, and repeat the development work, including the uploading of Excel tables, response and reading links need to re-develop the function code. When an Excel data table to be imported needs to be added, deleted, or changed, the background function code needs to be modified. In addition, since each new development import function needs to write a large amount of background code, it is easy to cause hidden vulnerabilities. The import process requires downtime deployment, which is time consuming and labor intensive.

Therefore, according to the above situation, the technical solution proposes a data import management method, which realizes the control of the import authority and the centralized management of the Excel import function, and is easy to operate.

Summary of the invention

The present application aims to propose a data import management method, apparatus, mobile terminal and storage medium to solve the deficiencies in the above background art. The traditional Excel table import needs to repeat the development of the Excel form uploading, response and reading, which is time-consuming and laborious; when adding, deleting, or changing the Excel header, you need to redeploy the background template and modify the background code, and need to stop the operation; Modifying the background code that needs to be changed more often leads to hidden vulnerabilities.

In order to achieve the above object, the present application provides the following technical solutions:

A data import management method includes: S1: generating a configuration table through a configuration table generation interface, and setting configuration information in the configuration table; S2: setting a verification rule parallel to the configuration table generation interface at a front end where the configuration table generation interface is located The interface is used to generate a verification rule or import a pre-prepared verification rule. S3: The front end interface where the configuration table generation interface is located uses an account with an import authority to import a data table.

Based on the same technical concept, the present application further provides a data import management apparatus, including:

Generate a configuration table unit, set to generate a configuration table through the configuration table generation interface, and set configuration information in the configuration table; set a verification rule unit, and set a front-end configuration table with the configuration table generation interface at the front end where the configuration table generation interface is located The inspection rule interface is used to generate a verification rule or import a pre-prepared verification rule; import the data unit, and set the front end interface where the configuration table generation interface is located to use an account with import permission to import the data table.

Based on the same technical concept, the present application further provides a mobile terminal, comprising: a touch sensitive display; a memory; one or more processors; the one or more processors configured to perform the following steps: S1: through a configuration table Generate an interface to generate a configuration table, and set configuration information in the configuration table. S2: Set a verification rule interface parallel to the configuration table generation interface on the front end where the configuration table generation interface is located, to generate a verification rule or import a pre-prepared school. Verification rule; S3: The front end interface where the configuration table generation interface is located uses an account with import permission to import the data table.

Based on the same technical concept, the present application also provides a storage medium storing computer readable instructions that, when executed by one or more processors, cause one or more processors to perform the following steps: S1 : Generate a configuration table through the configuration table generation interface, and set configuration information in the configuration table; S2: Set a verification rule interface parallel to the configuration table generation interface on the front end where the configuration table generation interface is located, for generating a verification rule or importing Pre-prepared verification rules; S3: The front-end interface where the configuration table generation interface is located uses an account with import permission to import the data table.

The data import management method, the device, the mobile terminal, and the storage medium generate a configuration table corresponding to the Excel data table to be imported through the configuration interface at the front end of the data importing system, and the configuration table stores the Excel data table to be imported. Configuration information, before the data is imported, the import template of the data format in the corresponding data table is generated through the configuration table, and the data in the data table having the specified data format is imported according to the data; the front end of the generated configuration table is placed along with the parallel configuration. The verification rule configuration interface is configured to generate or import a pre-prepared verification rule, and any verification rule correspondingly generates a verification ID, and after the verification rule is applied, according to the rule conditions and corresponding executions set therein The action checks the data column in the data import template to ensure the availability of the data column when the data is imported, prevents the setting of the data column from being incorrect, and causes unpredictable problems when the data is imported. The front end uses the account with the import permission to import the data table. .

DRAWINGS

Various other advantages and benefits will become apparent to those skilled in the art from a The drawings are only for the purpose of illustrating the preferred embodiments and are not intended to be limiting.

1 is a flowchart of an overall implementation in an embodiment of the present application;

2 is a flow chart of generating a configuration table in an embodiment of the present application;

3 is a flowchart of setting a verification rule in an embodiment of the present application;

4 is a flow chart of importing data in an embodiment of the present application;

FIG. 5 is a structural diagram of a management apparatus in an embodiment of the present application.

detailed description

The technical solutions in the embodiments of the present application are clearly and completely described in the following with reference to the drawings in the embodiments of the present application. It is obvious that the described embodiments are only a part of the embodiments of the present application, and not all of the embodiments. All other embodiments obtained by a person of ordinary skill in the art based on the embodiments of the present application without departing from the inventive scope are the scope of the present application.

Specifically, as shown in FIG. 1 , the present application provides a technical solution:

A data import management method, the specific steps are as follows: S1: Generate a configuration table through the configuration table generation interface, and set configuration information in the configuration table. The front end of the imported system generates a configuration table corresponding to the Excel data table to be imported through the configuration interface. The configuration table stores configuration information corresponding to the Excel data table to be imported, and generates data in the corresponding data table through the configuration table before data is imported. The import template of the format is based on the data in the data table with the specified data format; S2: a check rule interface parallel to the configuration table generation interface is set at the front end of the configuration table generation interface, and is used to generate a verification rule. Or import a pre-prepared verification rule. On the front end of the configuration table generation interface, a verification rule configuration interface is configured to generate or import a pre-prepared verification rule, and any verification rule generates a verification ID, and the verification rule is applied. According to the rule conditions and the corresponding execution actions set in the data, the data columns in the data import template are verified to ensure the availability of the data column when the data is imported, and the setting of the data column is prevented from being caused, resulting in unpredictable problems during data import. ; S3: The front-end interface where the configuration table generation interface is located uses an account with import permission to import the data table. At the front end of the system, an account with import authority is used to import the corresponding data table into the real estate transaction system.

In this embodiment, by introducing a verification rule, the data column is verified according to the rule conditions and execution actions set in the verification rule, thereby ensuring the availability of the data column during data import, and preventing the data column setting error from being caused when the data is imported. Expected problems. After importing the data table with the account with the import authority, the import data process does not need to be deployed down, and the import is simple and convenient, saving time and effort.

Specifically, as shown in FIG. 2, the generating the configuration template in the step S1 includes steps S101 to S106:

S101: Calling a scripting language to create a configuration table for generating a data import template, the configuration table is connected with the database, generating a data import template, and storing the data import template in the database. The scripting language, also known as an extended language, or a dynamic language, is a programming language used to control software applications. Scripts are usually saved in text (such as ASCII) and interpreted or compiled only when called; The scripting language creates a configuration table and imports the generated configuration table into a database for storage and use. S102: Calling a script language adding configuration function, where the configuration function includes a data import template query function, a data import template addition and deletion function. The corresponding configuration function is deployed in the configuration table by using a scripting language. The data import template query function is used to query the data to be imported, and the data to be imported is queried in the system where the configuration table is generated, so that some data is accurate. Imported into the Excel table; the new and deleted functions of the data import template are used to implement any new list or delete list, and realize the control of increasing or decreasing the number of list rows and columns. S103: Plan the layout of the default display list interface in the configuration table, including the interface display name of the template, the name of the template in the database, the validity switch, the remark information, the creation time, the modification time, and the operation switch for editing the template. The operation switch includes: modifying, creating a column, downloading a template, and uploading a template; wherein the upload template switch and the download template switch are used to export the data import template stored in the database after the configuration table generation interface is generated or imported into the database as a separate file. It is convenient to off-line modification and update from the database; the modification switch is used to edit the column items in the existing template; the column switch is created to add a new column operation to the existing template, thereby adding a data column, corresponding to Import a field from the data table. S104: Create a new import template operation interface for setting basic information of the data import template based on the configuration table, where the internal layout is used to generate each input entry of the basic information of the data import template. Develop a new data import import template operation interface, used to set the basic information of the data import template, which is used to generate the basic information of the data import template, including: create columns, create rows, download templates, upload templates, query data , add rows or columns, delete rows or columns, and more. S105: Create a template editing interface corresponding to any template based on the configuration table, where the default interface layout corresponds to each data column of the template, and any data column corresponds to at least two column basic fields. The column base fields of any data column include: column name, database column name, column number, column type, column value length, column value null, column valid, column check ID, operation. S106: Create a column editing interface for adding or editing data columns based on the template editing interface. Add a data column or edit the edit column of the data column to add, delete, or edit the edit data list.

In this embodiment, the function of creating a configuration table, adding a configuration function, planning an interface layout, adding an import template operation interface, creating a template editing interface, and a column editing interface by calling a script language, so that when the template is imported, there is no need to redeploy the background template. There is also no need to repeatedly develop the function code for the upload, response, and read links. Through the deployment of the embodiment, operations such as adding and deleting templates, setting data columns, and the like can be directly performed, which has very high flexibility and practicability.

Specifically, as shown in FIG. 3, the verification data in step S2 includes steps S201 to S203:

S201: Using a scripting language to generate a verification rule configuration interface in the front end of the system, which is associated with the database, and the verification rule generated by the verification rule is stored in the verification rule list in the database, and the default display interface of the verification rule configuration interface is displayed. The verification rule that has been imported or generated, any generated verification rule has a one-to-one operation switch group in the default display interface, which is used to view rule details or perform rule editing. The verification rule configuration interface is configured to generate a verification rule for the verification data, and is stored in the verification rule list in the database, and any generated verification rule has a one-to-one operation corresponding to the one in the default display interface. Switch group for viewing the details of the validation rules and editing the validation rules.

S202: The verification rule uploading and downloading function is deployed on the verification rule configuration interface, and the verification rule can be exported from the database in the form of a separate script file by the download function, which is convenient for offline editing, and can also be imported into the pre-offline through the upload function. Edit the verification rules to the list of validation rules in the database. The verification rules are edited offline, and then stored in the database for query use. The verification rules can be downloaded from the database through the download function, edited offline, uploaded to the database, or verified by pre-editing. Rules, upload it to the database for verification of the data.

S203: The configuration interface is developed based on the verification rule to generate a new verification interface, and the layout verification description, the rule type, and the verification rule are three items. The verification description item is used to display the function of the verification rule in the default interface of the verification rule configuration interface; the rule type item is used to display the classification information of the verification rule of the verification rule in the default interface of the verification rule configuration interface; The verification rule item is used to define the execution condition of the verification rule and the corresponding execution action.

Any of the verification rules corresponding to the following field information in the database: a verification ID, a verification description, a rule type, a verification condition, a rule entity, a rule creation time, and a validity status flag; wherein the validity status flag is used To indicate whether the rule is applied, which is Boolean data. When at least one data column in the template generated in any of the steps 1) applies the rule, the validity status of the rule is marked as true, otherwise, false. For the application of the rule, the rule application field is added in the data column, and its value is 0 or the check ID of the applied rule. When the rule application field is 0, it means that no check rule is applied, otherwise the application is equal to the value. The verification rule corresponding to the verification ID.

In this embodiment, the verification rule configuration interface is used to view the details of the rule and the editing of the rule, and the uploading and downloading functions of the verification rule are deployed. The user can intuitively deploy and use the verification rule to ensure the verification of the verification rule when the data is imported. To achieve data availability.

Specifically, as shown in FIG. 4, importing the form data in step S3 includes steps S301 to S304:

S301: Set a rights allocation interface on the front end of the system, and bind the data import permission to an existing account in a certain system, and then give the import permission, so that the data can be imported and operated. The authority assigning operation can prepare an operator permission configuration information table in advance, and set an import portal for importing the operator authority configuration information table in the rights assignment interface, thereby facilitating the operator to give more precise operation authority.

S302: Generate, according to the generated import template corresponding to the data table to be imported, various fields and corresponding tables for storing data to be imported. The template is imported according to the generated data, and fields and tables are generated in the database for storing the data to be imported.

S303: setting a data import interface on the front end of the system, including an import portal, selecting a data table to be imported through the import portal, importing the data table into the system, and recording the import result in an import operation result record information table and If the import is successful, the next step is performed. If the import fails, the import operation result record information table needs to be downloaded, and the cause of the failure is analyzed, and the problem is eliminated and then imported again. The data importing interface is provided with a data importing portal for importing data to be imported into the system through a data importing portal for storing data to be exported, and when the data is imported into Excel, through the system Query the stored data and import the corresponding data in the Excel table. S304: An import data viewing interface is set in the front end of the system, and is used to retrieve data that has been imported into the database and stored in the database from the database, and is presented in the front end page according to the data column in the template for importing the operator or other viewing. Permissions view. The import data query interface is used to query whether the data imported in the table is correct after the data to be imported is imported into the Excel table.

In this embodiment, an authority is configured to import an account by using a rights assignment interface and a preset operator rights configuration information table, and the user is authorized to import data into the Excel through the data import interface by setting a data import interface. The viewing interface is used by a privileged operator to retrieve and view the imported data. The above-mentioned way of importing and viewing data through permissions ensures the reliability of data import and avoids the intrusion of illegal data.

In one embodiment, the column base fields of any of the data columns include: column name, database column name, column number, column type, column value length, column value null, column validity, column check ID, operation. The data column of this embodiment contains as many basic fields as possible, and when the verification rule verifies the data column, the availability of the data column can be ensured, and the setting of the data column is prevented, resulting in unpredictable data import. problem.

In an embodiment, the corresponding field information of the verification rule in the database includes a check ID, a check description, a rule type, a check condition, a rule entity, a rule creation time, and a validity status flag. In this embodiment, the corresponding field information of the verification rule in the database is listed, which ensures that when the imported data is verified, the imported data is verified one by one, and the data column that does not meet the condition is identified. It is convenient for operators with permissions to view the status of rules and data columns.

In an embodiment, the configuration manner of the configuration table is: preparing six configuration tables for the imported Excel data table, including configuration tables 1 to 6, and storing the information in the configuration table 1 including the Chinese and English names of the data table. And the data table ID; add the Chinese and English name, the header serial number and the data table ID of the data table header in the configuration table 2; the verification ID, the verification condition and the verification description in the configuration table 3; Import operator permission configuration information in 4; import log record information in configuration table 5; import operation result record information in configuration table 6. In this embodiment, all the required configuration and verification information of the present application are saved by prefabricating 6 configuration tables, and are used for calling, verifying, and viewing subsequent data import. The above design effectively avoids an need for an Excel import. When you delete, change, or change the header, redeploy the background template and modify the background code.

Based on the same technical concept, the present application further provides a data import management apparatus. As shown in FIG. 5, the management apparatus includes: a configuration configuration table unit, configured to generate a configuration table by using a configuration table generation interface, and set a configuration in the configuration table. Information; setting a verification rule unit, and setting a check rule interface parallel to the configuration table generation interface at the front end where the configuration table generation interface is located, for generating a verification rule or importing a pre-prepared verification rule; importing a data unit , set to use the account with import permission to import the data table in the front-end interface where the configuration table generation interface is located.

In one embodiment, generating the configuration table unit includes: a configuration table generating module configured to invoke a scripting language to create a configuration table for generating a data import template, the configuration table is connected with the database, generating a data import template, and importing the data The template is stored in the database; the configuration module is configured to be set to invoke the script language to add a configuration function, and the configuration function includes a data import template query function, a data import template addition and deletion function, and an interface layout planning module, which is set in the configuration table. The layout of the default display list interface in the plan, including the interface display name of the template, the name of the template in the database, the validity switch, the remark information, the creation time, the modification time, the operation switch for editing the template; the operation interface creation module, setting A new import template operation interface for setting basic information of the data import template is created based on the configuration table, wherein the internal layout is used to generate various input entries of the basic information of the data import template; the template editing interface creates a module, and is set to be created based on the configuration table. Corresponding to any template The board editing interface, the default interface layout corresponding to each data column of the template, any data column corresponding to at least two column basic fields; the column editing interface creation module, set to create a new or edit based on the template editing interface Column edit interface for data columns. In this embodiment, the column basic fields of any data column in the template editing interface creation module include: column name, database column name, column serial number, column type, column value length, column value judgment, column validity, column calibration Check the ID and operation.

In one embodiment, the setting verification rule unit includes: a rule configuration interface generation module configured to generate a verification rule configuration interface in the system front end by using a script language, which is associated with the database, and is stored in the verification rule generated by the verification rule. In the verification rule list in the database, the default display interface of the verification rule configuration interface displays the imported or generated verification rules, and any generated verification rules have a one-to-one operation switch in the default display interface. Group, used to view rule details or perform rule editing; function deployment module, set to deploy verification rule upload and download function on the verification rule configuration interface, and use the download function to verify the rule from the database in the form of a separate script file. After exporting, it is convenient for offline editing, or through the upload function, importing the pre-offline edited verification rule into the verification rule list in the database; the rule adds a new interface generation module, and is set to generate a verification based on the verification rule configuration interface development interface. Rule added interface, layout check description, rule type and check rule Three projects.

In an embodiment, the import data unit includes: a rights assignment interface setting module, configured to set a rights assignment interface on the front end of the system, and bind the data import permission to an existing account in a system, and then give the import permission. The data import module is configured to be imported, and is configured to generate, according to the generated import template corresponding to the data table to be imported, various fields and corresponding tables for storing data to be imported are generated in the database; the data import interface setting module , set to set a data import interface on the front end of the system, which includes an import portal, selects a data table to be imported through the import portal, imports the data table into the system, and records the import result in an import operation result record information table. And importing the log record information, if the import is successful, proceed to the next step. If the import fails, download the import operation result record information table, analyze the failure reason, and re-import after eliminating the problem; view the interface setting module, set to be at the system front end. Set an import data view interface for retrieving the data from the database Into the system and stored data in the database, and in accordance with data templates column presented for import operator or other person has permission to view View at the front page.

Based on the same technical concept, the present application further provides a mobile terminal, which is used to implement data import management across mobile applications, and the terminal may include a mobile phone, a tablet computer, a PDA (Personal Digital Assistant), and a POS ( Point of Sales, sales terminal, and any terminal device such as a car computer. The mobile terminal includes a touch sensitive display, a memory, one or more processors; the one or more processors configured to perform the steps of the data import management method of the various embodiments described above.

Based on the same technical concept, the present application also provides a storage medium storing computer readable instructions, which when executed by one or more processors, cause one or more processors to execute the various embodiments described above The steps in the data import management method. The storage medium may be a non-volatile storage medium.

A person skilled in the art may understand that all or part of the various steps of the foregoing embodiments may be performed by a program to instruct related hardware. The program may be stored in a computer readable storage medium, and the storage medium may include: Read Only Memory (ROM), Random Access Memory (RAM), disk or optical disk.

It will be understood by those skilled in the art that all or part of the steps of implementing the above embodiments may be performed by a program to instruct related hardware, and the program may be stored in a computer readable storage medium, the above mentioned storage. The medium can be a read only memory, a magnetic disk or an optical disk or the like.

The above-described embodiments are only illustrative of some exemplary embodiments of the present application, and the description thereof is more specific and detailed, and is not to be construed as limiting the scope of the claims. It should be noted that a number of variations and modifications may be made by those skilled in the art without departing from the spirit and scope of the present application. Therefore, the scope of the invention should be determined by the appended claims.

Claims

A data import management method includes: S1: generating a configuration table through a configuration table generation interface, and setting configuration information in the configuration table; S2: setting a verification rule parallel to the configuration table generation interface at a front end where the configuration table generation interface is located The interface is used to generate a verification rule or import a pre-prepared verification rule. S3: The front end interface where the configuration table generation interface is located uses an account with an import authority to import a data table.
A data import management method according to claim 1, wherein S1 comprises:

S101: Calling a scripting language to create a configuration table for generating a data import template, the configuration table is connected with a database, generating a data import template, and storing the data import template in a database;

S102: Calling a script language to add a configuration function, where the configuration function includes a data import template query function, a data import template addition and deletion function;

S103: planning a layout of a default display list interface in the configuration table, including a template display name of the template, a name of the template in the database, a validity switch, a remark information, a creation time, a modification time, and an operation switch for editing the template;

S104: Create a new import template operation interface for setting basic information of the data import template based on the configuration table, where the internal layout is used to generate each input input of the basic information of the data import template;

S105: Create a template editing interface corresponding to any template based on the configuration table, where the default interface layout corresponds to each data column of the template, and any data column corresponds to at least two column basic fields;

S106: Create a column editing interface for adding or editing data columns based on the template editing interface.
A data import management method according to claim 1, wherein S2 comprises:

S201: Using a scripting language to generate a verification rule configuration interface in the front end of the system, which is associated with the database, and the verification rule generated by the verification rule is stored in the verification rule list in the database, and the default display interface of the verification rule configuration interface is displayed. A verification rule that has been imported or generated, and any generated verification rule has a one-to-one operation switch group in the default display interface for viewing rule details or performing rule editing;

S202: Deploying a verification rule uploading and downloading function on the verification rule configuration interface, and downloading the verification rule from the database in the form of a separate script file to facilitate offline editing, or importing and pre-offline editing through the upload function. Check rule to the list of check rules in the database;

S203: The configuration interface is developed based on the verification rule to generate a new verification interface, and the layout verification description, the rule type, and the verification rule are three items.
A data import management method according to claim 1, wherein S3 comprises:

S301: setting a rights assignment interface on the front end of the system, and binding the data import permission to an existing account in a certain system, and then giving the import permission, so that the data can be imported and operated;

S302: Generate, according to the generated import template corresponding to the data table to be imported, various fields and corresponding tables for storing data to be imported in the database;

S303: setting a data import interface on the front end of the system, including an import portal, selecting a data table to be imported through the import portal, importing the data table into the system, and recording the import result in an import operation result record information table and If the import is successful, the next step is performed. If the import fails, the import operation result record information table needs to be downloaded, and the reason for the failure is analyzed, and the problem is re-imported after the problem is eliminated;

S304: An import data viewing interface is set in the front end of the system, and is used to retrieve data that has been imported into the database and stored in the database from the database, and is presented in the front end page according to the data column in the template for importing the operator or other viewing. Permissions view.
The data import management method according to claim 2, wherein the column base field of any of the data columns includes: a column name, a database column name, a column number, a column type, a column value length, a column value judgment, and a column Valid, column check ID, operation.
The data import management method according to claim 1, wherein the corresponding field information of the verification rule in the database has a check ID, a check description, a rule type, a check condition, a rule entity, and a rule creation time. , validity status flag.
The data import management method according to claim 1, wherein the configuration manner of the configuration table is: preparing six configuration tables, including configuration tables 1 to 6, in the Excel data table to be imported, in the configuration table 1 The deposit information includes the Chinese and English names and data table IDs of the data table; the Chinese and English names, the header numbers, and the data table IDs of the data table headers are added in the configuration table 2; the check IDs and checksums are imported in the configuration table 3. Description of conditions and verification; import operator permission configuration information in configuration table 4; import log record information in configuration table 5; import operation result record information in configuration table 6.
A data import management device includes: generating a configuration table unit, configured to generate a configuration table by using a configuration table generation interface, and setting configuration information in the configuration table; setting a verification rule unit, and setting the front end of the configuration table generation interface A verification rule interface parallel to the configuration table generation interface, used to generate a verification rule or import a pre-prepared verification rule; import a data unit, and set an account with an import permission on the front end interface where the configuration table generation interface is located, Import the data table.
The data import management device according to claim 8, wherein the generating configuration table unit comprises: a configuration table generating module configured to invoke a scripting language to create a configuration table for generating a data import template, the configuration table and the database Connect, generate a data import template, store the data import template in the database; configure the add-on module, and set the calling script language to add a configuration function, the configuration function includes a data import template query function, a data import template add and delete function; The interface layout planning module is configured to plan the layout of the default display list interface in the configuration table, including the interface display name of the template, the name of the template in the database, the validity switch, the remark information, the creation time, the modification time, and the editing template. Operation switch; the operation interface creation module is set to create a new import template operation interface for setting basic information of the data import template based on the configuration table, and the internal layout is used for generating various input entries of the basic information of the data import template; template editing Interface creation module, setting To create a template editing interface corresponding to any template based on the configuration table, the default interface layout corresponds to each data column of the template, and any data column corresponds to at least two column basic fields; the column editing interface creates a module, and is set to be based on the template. The editing interface creates a column editing interface for adding or editing data columns.
The data import management apparatus according to claim 8, wherein the setting verification rule unit comprises: a rule configuration interface generating module configured to develop a verification rule configuration interface at a system front end by using a script language, which is associated with a database The verification rule generated by the verification rule is stored in the verification rule list in the database, and the default display interface of the verification rule configuration interface displays the imported or generated verification rule, and any generated verification rule is displayed in the default display interface. There is an operation switch group corresponding to one-to-one corresponding to the rule details or rule editing; the function deployment module is set to deploy the verification rule upload and download function on the verification rule configuration interface, and the verification function is verified by the download function. The rules are exported from the database in the form of separate script files for offline editing, or through the upload function, import the pre-offline edited verification rules into the verification rule list in the database; the rule adds a new interface generation module, which is set to be based on The verification rule configuration interface is developed to generate a verification rule new interface, Description layout verification, validation rules and rule type three items.
The data import management device according to claim 8, wherein the import data unit comprises: a rights assignment interface setting module, configured to set a rights assignment interface at the front end of the system, and the data import authority and the existing system are After the account is bound, the import permission is given to enable the import of the data; the data storage module to be imported is set to generate the fields for storing the data to be imported in the database according to the imported import template corresponding to the generated data table to be imported. And the corresponding table; the data import interface setting module is set to set a data import interface on the front end of the system, which includes an import portal, selects a data table to be imported through the import portal, and then imports the data table into the system, and imports the data table. The result is recorded in an import operation result record information table and an import log record information. If the import is successful, the next step is performed. If the import fails, the import operation result record information table needs to be downloaded, and the cause of the failure is analyzed, and the problem is eliminated and then imported again; View the interface setting module, set to set an import data in the system front end The viewing interface is used to retrieve data that has been imported into the database from the database and stored in the database, and is presented in the front-end page according to the data column in the template for the import operator or other viewing rights.
The data import management apparatus according to claim 9, wherein the column base field of any one of the data in the template editing interface creation module comprises: a column name, a database column name, a column number, a column type, a column value length, The column value is null, the column is valid, the column check ID, and the operation.
A mobile terminal, comprising: a touch-sensitive display; a memory; one or more processors; the one or more processors configured to perform the following steps: S1: generating a configuration table by using a configuration table generation interface, Setting the configuration information in the configuration table; S2: setting a verification rule interface parallel to the configuration table generation interface on the front end where the configuration table generation interface is located, for generating a verification rule or importing a pre-prepared verification rule; S3: The front-end interface where the configuration table generation interface is located uses an account with import permission to import the data table.
The mobile terminal of claim 13, wherein said step S1 causes one or more processors to be configured to perform the following steps:

S101: Calling a scripting language to create a configuration table for generating a data import template, the configuration table is connected with a database, generating a data import template, and storing the data import template in a database;

S102: Calling a script language to add a configuration function, where the configuration function includes a data import template query function, a data import template addition and deletion function;

S103: planning a layout of a default display list interface in the configuration table, including a template display name of the template, a name of the template in the database, a validity switch, a remark information, a creation time, a modification time, and an operation switch for editing the template;

S104: Create a new import template operation interface for setting basic information of the data import template based on the configuration table, where the internal layout is used to generate each input input of the basic information of the data import template;

S105: Create a template editing interface corresponding to any template based on the configuration table, where the default interface layout corresponds to each data column of the template, and any data column corresponds to at least two column basic fields;

S106: Create a column editing interface for adding or editing data columns based on the template editing interface.
The mobile terminal of claim 13, wherein said step S2 causes one or more processors to be configured to perform the following steps:

S201: Using a scripting language to generate a verification rule configuration interface in the front end of the system, which is associated with the database, and the verification rule generated by the verification rule is stored in the verification rule list in the database, and the default display interface of the verification rule configuration interface is displayed. A verification rule that has been imported or generated, and any generated verification rule has a one-to-one operation switch group in the default display interface for viewing rule details or performing rule editing;

S202: Deploying a verification rule uploading and downloading function on the verification rule configuration interface, and downloading the verification rule from the database in the form of a separate script file to facilitate offline editing, or importing and pre-offline editing through the upload function. Check rule to the list of check rules in the database;

S203: The configuration interface is developed based on the verification rule to generate a new interface of the verification rule, and the layout description, the rule type, and the verification rule are three items.
The mobile terminal of claim 13, wherein said step S3 causes one or more processors to be configured to perform the following steps:

S301: setting a rights assignment interface on the front end of the system, and binding the data import permission to an existing account in a certain system, and then giving the import permission, so that the data can be imported and operated;

S302: Generate, according to the generated import template corresponding to the data table to be imported, various fields and corresponding tables for storing data to be imported in the database;

S303: setting a data import interface on the front end of the system, including an import portal, selecting a data table to be imported through the import portal, importing the data table into the system, and recording the import result in an import operation result record information table and If the import is successful, the next step is performed. If the import fails, the import operation result record information table needs to be downloaded, and the reason for the failure is analyzed, and the problem is re-imported after the problem is eliminated;

S304: An import data viewing interface is set in the front end of the system, and is used to retrieve data that has been imported into the database and stored in the database from the database, and is presented in the front end page according to the data column in the template for importing the operator or other viewing. Permissions view.
A storage medium storing computer readable instructions, when executed by one or more processors, causing one or more processors to perform the steps of: S1: generating a configuration table through a configuration table generation interface, Setting the configuration information in the configuration table; S2: setting a verification rule interface parallel to the configuration table generation interface on the front end where the configuration table generation interface is located, for generating a verification rule or importing a pre-prepared verification rule; S3: The front-end interface where the configuration table generation interface is located uses an account with import permission to import the data table.
The storage medium of claim 17, wherein said step S1 causes one or more processors to perform the following steps:

S101: Calling a scripting language to create a configuration table for generating a data import template, the configuration table is connected with a database, generating a data import template, and storing the data import template in a database;

S102: Invoking a script language adding configuration function, where the configuration function includes a data import template query function, a data import template addition and deletion function;

S103: planning a layout of a default display list interface in the configuration table, including a template display name of the template, a name of the template in the database, a validity switch, a remark information, a creation time, a modification time, and an operation switch for editing the template;

S104: Create a new import template operation interface for setting basic information of the data import template based on the configuration table, where the internal layout is used to generate each input input of the basic information of the data import template;

S105: Create a template editing interface corresponding to any template based on the configuration table, where the default interface layout corresponds to each data column of the template, and any data column corresponds to at least two column basic fields;

S106: Create a column editing interface for adding or editing data columns based on the template editing interface.
The storage medium of claim 17, wherein said step S2 causes one or more processors to perform the following steps:

S201: Using a scripting language to generate a verification rule configuration interface in the front end of the system, which is associated with the database, and the verification rule generated by the verification rule is stored in the verification rule list in the database, and the default display interface of the verification rule configuration interface is displayed. A verification rule that has been imported or generated, and any generated verification rule has a one-to-one operation switch group in the default display interface for viewing rule details or performing rule editing;

S202: Deploying a verification rule uploading and downloading function on the verification rule configuration interface, and downloading the verification rule from the database in the form of a separate script file to facilitate offline editing, or importing and pre-offline editing through the upload function. Check rule to the list of check rules in the database;

S203: The configuration interface is developed based on the verification rule to generate a new verification interface, and the layout verification description, the rule type, and the verification rule are three items.
The storage medium of claim 17, wherein said step S3 causes one or more processors to perform the following steps:

S301: setting a rights assignment interface on the front end of the system, and binding the data import permission to an existing account in a certain system, and then giving the import permission, so that the data can be imported and operated;

S302: Generate, according to the generated import template corresponding to the data table to be imported, various fields and corresponding tables for storing data to be imported in the database;

S303: setting a data import interface on the front end of the system, including an import portal, selecting a data table to be imported through the import portal, importing the data table into the system, and recording the import result in an import operation result record information table and If the import is successful, the next step is performed. If the import fails, the import operation result record information table needs to be downloaded, and the reason for the failure is analyzed, and the problem is re-imported after the problem is eliminated;

S304: An import data viewing interface is set in the front end of the system, and is used to retrieve data that has been imported into the database and stored in the database from the database, and is presented in the front end page according to the data column in the template for importing the operator or other viewing. Permissions view.