Data import and export form template generation method and system, terminal and storage medium

Abstract

The invention relates to the technical field of computer information, in particular to a data import and export form template generation method and system, a terminal and a storage medium. Defining a basic business scene; for the defined basic business scene, calling the basic form, and carrying out column data configuration and column sequence adjustment on the business scene in the called basic form to obtain an import and export form style in the corresponding basic business scene; defining a target business scene, and configuring a required import and export form style for the defined target business scene; and generating a data import and export form template of the target business scene based on the configured import and export form style. The method is used for solving the problem that a traditional Excel file import and export template is often restricted by specific business requirements and data formats of different departments in an enterprise, and consequently generation flexibility is insufficient.

Description

Technical Field

[0001] This invention relates to the field of computer information technology, specifically to a method, system, terminal, and storage medium for generating data import / export form templates. Background Technology

[0002] With the continuous improvement of information technology, more and more systems are using Excel file templates to import and export data.

[0003] However, during the import and export of data in Excel files, the business needs and data formats of different departments are diverse, which has caused many problems.

[0004] For example, traditional Excel import / export templates are often constrained by the specific business needs and data formats of different departments within an enterprise, resulting in insufficient flexibility in template generation. Furthermore, when subsequent business needs change and column names need to be adjusted, this not only significantly increases labor costs but may also lead to difficulties in later maintenance. Summary of the Invention

[0005] To address the above shortcomings, this invention provides a method, system, terminal, and storage medium for generating data import / export form templates, thereby solving at least one of the aforementioned problems.

[0006] In a first aspect, the present invention provides a method for generating a data import / export form template, the method comprising: S1. Create a basic form; the form includes the form column structure used to generate data import and export form templates for all the actual business scenarios currently used by the user; the form column structure includes a column structure of common columns and a column structure of personalized columns; S2. Define basic business scenarios, with each basic business scenario corresponding to an actual business scenario; S3. For the defined basic business scenario, retrieve the basic form, configure the column data of the business scenario in the retrieved basic form, and adjust the column order to obtain the import / export form style under the corresponding basic business scenario. S4. Define the target business scenario and configure the required import / export form styles for the defined target business scenario; S5. Based on the configured import / export form style, generate data import / export form templates corresponding to the target business scenario.

[0007] In an optional implementation, the method further includes: adding a new step to the basic business scenario; The newly added steps for the basic business scenarios include: Step S2 defines the basic business scenario corresponding to the newly added actual business scenario, which is then used as the new basic business scenario. Step S3 involves retrieving the basic form for the newly added basic business scenario, configuring the column data for the business scenario, and adjusting the column order within the retrieved basic form to obtain the import / export form style for the newly added basic business scenario.

[0008] In an optional implementation, the method further includes: adding a new step to the target business scenario; The new steps for the target business scenario include: Step S4 defines the new target business scenario and configures the required import / export form styles for the defined new target business scenario. Step S5 generates an import / export form template corresponding to the newly added target business scenario based on the configured import / export form style.

[0009] In an optional implementation, the method further includes: The basic form you create supports modifying column names; If any column name in the base form is modified, the corresponding column name in the import / export form styles of all basic business scenarios will be modified simultaneously.

[0010] In one optional implementation, the basic form adopts a column structure with common columns and personalized columns for row records, with each row record corresponding to a form field, and the sorting of the row records corresponding to the sorting of the form fields; Step S3 also includes: providing each row of the retrieved base form with an up button, a down button, and a delete row button.

[0011] In an optional implementation, the method further includes: when creating the base form, completing the data configuration of the common columns in the form used to generate the data import / export form template, without configuring the data of the personalized columns in the form.

[0012] Secondly, this invention provides a data import / export form template generation system, the system comprising: The form definition module is used to create basic forms; the form includes the form column structure used to generate data import and export form templates for all the actual business scenarios currently available to the user; the form column structure includes a column structure of common columns and a column structure of personalized columns; The scenario definition module is used to define basic business scenarios, with each basic business scenario corresponding to an actual business scenario; The style acquisition module is used to retrieve the basic form for the defined basic business scenario, configure the column data of the business scenario in the retrieved basic form, and adjust the column order to obtain the import and export form style under the corresponding basic business scenario. The style binding module is used to define target business scenarios and configure the required import / export form styles for the defined target business scenarios; The template generation module is used to generate data import / export form templates corresponding to the target business scenario based on the configured import / export form styles.

[0013] In an optional implementation, the system further includes: The data modification module is used to modify the column names in the base form created by the form definition module. The synchronous modification module is used to synchronously modify the corresponding column names in the import and export form styles of all basic business scenarios after any column name in the base form is modified.

[0014] Thirdly, the present invention provides a terminal, comprising: Processor, memory, among which, This memory is used to store computer programs. The processor is used to retrieve and run the computer program from memory, enabling the terminal to perform the methods described above.

[0015] Fourthly, a computer storage medium is provided, wherein instructions are stored therein, which, when executed on a computer, cause the computer to perform the methods described in the above aspects.

[0016] As can be seen from the above technical solutions, the present invention has the following advantages: This invention is based on a basic form and predefines the form column structure for generating data import and export form templates. When generating data import and export form templates corresponding to the target business scenario, there is no need to redefine the form column structure in the form template for each target business scenario, which helps to solve the problem of insufficient flexibility caused by data format constraints within the enterprise to a certain extent.

[0017] This invention first creates a basic form, then configures basic business scenarios, and then, for each configured basic business scenario, retrieves the basic form to generate import / export form styles. Next, it configures the target business scenario and binds the required import / export form styles to it. Then, based on the bound import / export form styles, it generates the corresponding data import / export form template for each target business scenario. The configuration process is simple and helps to break down the limitations of business needs and data formats between different departments within an enterprise.

[0018] This invention can generate data import and export form templates for new basic business scenarios, making it convenient to handle subsequent situations that require the generation of data import and export form templates for new basic business scenarios.

[0019] The basic form created by this invention supports modification of form column names. After any column name in the basic form is modified, the corresponding column name in the import / export form style of each basic business scenario can be modified synchronously. It can be seen that this invention supports dynamic column name configuration, which helps to cope with the need to adjust column names when business needs change. It also helps to flexibly cope with the need to import and export data from different Excel files between different departments, and facilitates the addition of columns when business needs change. This will not significantly increase the investment of manpower costs, nor will it cause problems in later maintenance. Attached Figure Description

[0020] To more clearly illustrate the technical solution of the present invention, the accompanying drawings used in the description will be briefly introduced below. Obviously, the accompanying drawings described below are only some embodiments of the present invention. For those skilled in the art, other drawings can be obtained based on these drawings without creative effort.

[0021] Figure 1 This is a schematic flowchart of a method according to an embodiment of the present invention.

[0022] Figure 2 This is a schematic block diagram of a system according to an embodiment of the present invention.

[0023] Figure 3 This is a schematic diagram of the structure of a terminal provided in an embodiment of the present invention.

[0024] Figure 4 This is a schematic diagram of the structure of a computer storage medium provided in an embodiment of the present invention. Detailed Implementation

[0025] The following provides a detailed description of a data import / export form template generation method, system, terminal, and storage medium. Specific details, such as particular system structures and technologies, are presented for illustrative purposes rather than limiting, to ensure a thorough understanding of the embodiments of the invention. However, those skilled in the art will recognize that the invention can be implemented in other embodiments without these specific details.

[0026] It should be understood that, when used in this specification, the term "comprising" indicates the presence of the described features, integrals, steps, operations, elements, and / or components, but does not exclude the presence or addition of one or more other features, integrals, steps, operations, elements, components, and / or collections thereof. The terms "comprising," "including," "having," and variations thereof all mean "including but not limited to," unless otherwise specifically emphasized.

[0027] The terms "one embodiment" or "some embodiments" used in this invention mean that one or more embodiments of the invention include the specific features, structures, or characteristics described in that embodiment. Therefore, phrases such as "in some embodiments" or "in other embodiments" appearing in different parts of the invention do not necessarily refer to the same embodiment, but rather mean "one or more, but not all, embodiments," unless otherwise specifically emphasized.

[0028] The technical solutions of the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings. Obviously, the described embodiments are only some embodiments of the present invention, and not all embodiments. Based on the embodiments of the present invention, all other embodiments obtained by those skilled in the art without creative effort are within the scope of protection of the present invention.

[0029] Figure 1 This is a schematic flowchart illustrating a method for generating a data import / export form template according to an embodiment of the present invention. Figure 1 The executing entity can be a data import / export form template generation system. The data import / export form template generation method provided in this embodiment is executed by a computer device; correspondingly, the data import / export form template generation system runs on the computer device. Depending on different needs, the order of the steps in this flowchart can be changed, and some steps can be omitted.

[0030] Please refer to Figure 1 The method includes the following steps S1 to S5.

[0031] Step S1: Create a basic form.

[0032] The basic form created in this step includes the form column structure used to generate data import and export form templates for all the actual business scenarios currently used by the user.

[0033] The above form column structure includes a column structure with common columns and a column structure with personalized columns.

[0034] Understandably, the common columns are the basic information columns that users commonly need to generate data import and export form templates in all their current actual business scenarios, reflecting the universality of the columns used to generate data import and export form templates in all their current actual business scenarios.

[0035] Personalized columns reflect the individuality of the columns used to generate data import / export form templates in various actual business scenarios currently employed by the user. In practice, the column structure of personalized columns is set according to different business scenarios.

[0036] Understandably, before creating the basic form, it is necessary to collect the column structure information of common and personalized columns used to generate data import and export form templates in all the actual business scenarios currently used by the user.

[0037] In this embodiment, the column structure includes the following configuration items: field name (i.e., the column name of the form), field type, format type, and required field identifier.

[0038] The specific content included in the above column structure can be set by those skilled in the art according to the actual situation. For example, in specific implementation, if filtering conditions are required, corresponding configuration items (such as "filtering conditions") can be added; if drop-down options are required, corresponding configuration items (such as "drop-down options") can also be added; if field default values ​​are required, corresponding configuration items (such as "field default values") can also be added.

[0039] In both the common column structure and the personalized column structure, each column structure is recorded using one row of the basic form.

[0040] For example, this application allows the data configuration of common columns in the form to be completed when the base form is created. Thus, when the base form is retrieved subsequently, the user does not need to configure this type of data every time.

[0041] In practice, when creating the basic form, you can only create the column structure of the personalized columns without configuring the data for the personalized columns (for example, the column name of the personalized column in the form is empty).

[0042] Understandably, this step is for form definition, which is used to define the import / export table structure (supporting multiple tables) and the configuration of basic data formats such as column data formats.

[0043] The "table" mentioned in this instruction manual refers to an Excel spreadsheet.

[0044] Step S2: Define the basic business scenarios.

[0045] Define basic business scenarios, with each basic business scenario corresponding to an actual business scenario.

[0046] Specifically, define basic business scenarios, including defining the scenario name of the basic business scenario.

[0047] Understandably, this step essentially defines the actual business scenarios as basic business scenarios, and the scenario names can be set based on the actual business scenarios. The maximum number of basic business scenarios is equal to the total number of actual business scenarios currently held by the user. In this step, the actual business scenarios corresponding to the basic business scenarios are determined by defining the scenario names of the basic business scenarios.

[0048] In practice, users can define a corresponding number of basic business scenarios based on their actual needs. Generally speaking, the number of basic business scenarios defined corresponds to the number of actual business scenarios a user has.

[0049] Optionally, in a specific implementation, defining a basic business scenario may also include defining a scenario number.

[0050] The scenario number is used to uniquely identify the basic business scenario.

[0051] Step S3: For the defined basic business scenario, retrieve the basic form, configure the column data of the business scenario in the retrieved basic form, and adjust the column order to obtain the import / export form style under the corresponding basic business scenario.

[0052] Step S4: Define the target business scenario and configure the required import / export form styles for the defined target business scenario.

[0053] The target business scenario is one where a data import / export form template needs to be generated.

[0054] The method in this embodiment supports sharing the same configuration interface across multiple dimensions (i.e., multiple target business scenarios), improving the convenience and efficiency of configuration.

[0055] In practice, each imported / export form style is pre-configured with an ID (a unique identifier). To configure the required imported / export form styles, simply bind the required IDs to those styles.

[0056] Step S5: Based on the configured import / export form style, generate a data import / export form template for the target business scenario.

[0057] In this invention, the use of the basic form covers key configuration items such as field names (i.e., column names of the form), field types, format types, field default values, and required field identifiers. These configuration items help ensure that the generated template not only meets business logic requirements but also facilitates data entry and organization for users, laying a solid foundation for subsequent data upload and import.

[0058] After the templates are generated, a download interface or link is provided for each template so that users can upload data to download, or the system can respond to user download requests and provide data to users in the form of templates.

[0059] Users upload data using the downloaded template, including: Users collect data using the downloaded template, and then upload the collected data to the system through the import interface.

[0060] In some illustrative embodiments of the present invention, the method further includes: adding a basic business scenario step.

[0061] The above-mentioned basic business scenarios have been updated with the following steps: Step S2 defines the basic business scenario corresponding to the newly added actual business scenario, which is then used as the new basic business scenario. Step S3 involves retrieving the basic form for the newly added basic business scenario, configuring the column data for the business scenario, and adjusting the column order within the retrieved basic form to obtain the import / export form style for the newly added basic business scenario.

[0062] The above steps allow users to expand their basic business scenarios by adding steps to the existing basic business scenarios when there are expansions in actual business scenarios.

[0063] In some other illustrative embodiments, the method further includes: adding a new step to the target business scenario.

[0064] The above-mentioned target business scenarios include the following new steps: Step S4 defines the new target business scenario and configures the required import / export form styles for the defined new target business scenario. Step S5 generates an import / export form template corresponding to the newly added target business scenario based on the configured import / export form style.

[0065] When you need to generate a data import / export form template for a new actual business scenario, you only need to execute the basic business scenario addition steps first, and then execute the target business scenario addition steps. Some common fields do not need to be configured again, which helps to improve the efficiency of template generation to a certain extent.

[0066] In some other embodiments of the present invention, the basic form created supports modification of form column names.

[0067] Specifically, if any column name in the base form is modified, the corresponding column name in the import / export form styles of all basic business scenarios will be modified simultaneously.

[0068] In other embodiments of the present invention, the basic form adopts a column structure of common columns and personalized columns for row records, each row record corresponds to a form field (i.e., a field of the form column), and the sorting of the row records corresponds to the sorting of the form fields.

[0069] In one implementation, the method further includes: when creating the basic form, completing the data configuration of the common columns in the form used to generate the data import / export form template, without configuring the data of the personalized columns in the form.

[0070] In practice, if the common columns in the basic form are not yet configured, step S3 will configure the common and personalized columns for the corresponding business scenario. If the common columns in the basic form are already configured, step S3 only needs to configure the personalized columns for the corresponding business scenario.

[0071] Understandably, users can select and configure personalized columns in the form that meet their basic business needs, and can directly delete personalized columns that do not meet the current basic business needs. After configuration, the column order can be adjusted according to actual requirements.

[0072] For example, the column data configured in the import / export form style obtained in step S3 can all be edited. In actual use, users can adjust any column data configured in the import / export form style according to their actual needs.

[0073] For example, step S3 further includes: configuring each row of the retrieved base form with an up button, a down button, and a delete row button.

[0074] When using the form, users can adjust the position of each row in the retrieved base form by using the up, down, and delete row buttons.

[0075] Optionally, starting from the second row (the "move up" button in the first row is disabled), clicking the "move up" button on any row will swap the current row with the previous row. Starting from the second-to-last row (the "move down" button in the last row is disabled), clicking the "move down" button on any row will swap the current row with the next row. Clicking the "delete row" button on any row will delete the corresponding row.

[0076] In other embodiments of the present invention, the method further includes: The basic form you create supports modifying column names; If any column name in the base form is modified, the corresponding column name in the import / export form style of each basic business scenario will be modified synchronously.

[0077] This invention supports modifying the import / export form style of the target business scenario configuration.

[0078] In step S4, the import / export form styles are configured for the target business scenario through a visual interface.

[0079] This visual interface supports import and export form style configuration for multiple target business scenarios.

[0080] The import / export form style configuration for the target business scenario involves assigning the ID of the import / export form style to the target business scenario.

[0081] The IDs of the import / export form styles assigned to the target business scenario in this visual interface can be modified.

[0082] When it is necessary to modify the import / export form style of the target business scenario, the ID of the import / export form style of the target business scenario can be modified in the visualization interface.

[0083] To facilitate understanding of the present invention, the following description further illustrates the data import and export form template generation method provided in this embodiment, based on the principle of the data import and export form template generation method of the present invention and in conjunction with the process of generating the data import and export form template in the embodiments.

[0084] Specifically, taking User A (a company) as an example, User A has a total of ten actual business scenarios across its departments. The total number of columns (corresponding to 40 fields) used to generate the data import / export form template for these ten scenarios is 40. Of these, only three columns are common to all ten scenarios. Taking User A as an example, the data import / export form template generation method includes: Step 101: Create the basic form: This basic form defines the column structure of the aforementioned 40 fields, corresponding to 40 records (i.e., 40 rows). Three of these 40 columns are common to User A's ten actual business scenarios. The other 37 fields are personalized columns. The basic form defines the column structures for both the common and personalized columns.

[0085] In this embodiment, the data configuration of the three common columns is completed when the basic form is created.

[0086] The basic form created in step 101 is denoted as Basic Form B.

[0087] Step 102: Define basic business scenarios.

[0088] In this embodiment, there are 10 basic business scenarios defined in step S2, which correspond to the ten actual business scenarios of user A mentioned above.

[0089] In practice, define the numbers (or other unique identifiers) and scenario names for the ten actual business scenarios mentioned above.

[0090] Step 103: For each defined basic business scenario, retrieve the basic form B, configure the data of the personalized columns of the business scenario in the retrieved basic form, and adjust the position of the columns in the form (i.e., adjust the column order). After configuration, the import and export form style of each basic business scenario is obtained.

[0091] Understandably, step 103 is to generate a form style for each basic business scenario.

[0092] In this embodiment, step 103 generates a form style for each actual business scenario of user A, that is, step 103 generates a total of 10 form styles.

[0093] Before step 103 is executed, the basic form B includes the column structure of the aforementioned 37 personalized columns.

[0094] The 10 basic business scenarios in this embodiment do not all have the above 37 columns.

[0095] For each basic business scenario of user A, in step 103, only the columns in the above 37 columns that are present in that basic business scenario are configured, and the remaining columns are deleted.

[0096] Step 104: Define the target business scenario and bind the required import / export form styles for each defined target business scenario.

[0097] Assuming there are currently 10 data import / export form templates to be generated, and these 10 templates correspond to the 10 basic business scenarios mentioned above, then in step 104, 10 target business scenarios can be defined in batches, corresponding to the 10 basic business scenarios mentioned above.

[0098] Step 105: Based on the bound import / export form style, generate the corresponding data import / export form template for each target business scenario.

[0099] In its specific implementation, step 105 includes: For each target business scenario, first obtain its bound import / export form style, and then generate the corresponding Excel data import / export form based on the obtained import / export form style, thus obtaining the data import / export form template corresponding to the target business scenario.

[0100] In other embodiments of the present invention, the method further includes: setting a new row addition unit and a form column structure setting unit for a basic form. The new row addition unit is used to add new rows to the basic form. The form column structure setting unit is used to set the form column structure for the corresponding columns of the newly added rows in the basic form.

[0101] It should be understood that the sequence number of each step in the above embodiments does not imply the order of execution. The execution order of each process should be determined by its function and internal logic, and should not constitute any limitation on the implementation process of the embodiments of the present invention.

[0102] Figure 2 The data import / export form template generation system provided by this invention specifically includes: The form definition module 201 is used to create basic forms; the form includes the form column structure used to generate data import and export form templates in all the actual business scenarios currently owned by the user; the form column structure includes a column structure of common columns and a column structure of personalized columns; The scenario definition module 202 is used to define basic business scenarios, with each basic business scenario corresponding to an actual business scenario. The style acquisition module 203 is used to retrieve the basic form for the defined basic business scenario, configure the column data of the business scenario in the retrieved basic form, and adjust the column order to obtain the import and export form style under the corresponding basic business scenario. The style binding module 204 is used to define the target business scenario and configure the required import / export form styles for the defined target business scenario; The template generation module 205 is used to generate data import / export form templates corresponding to the target business scenario based on the configured import / export form styles.

[0103] In other embodiments of the present invention, the system further includes: The data modification module is used to modify the column names in the base form created by the form definition module. The synchronous modification module is used to synchronously modify the corresponding column names in the import and export form styles of all basic business scenarios after any column name in the base form is modified.

[0104] This embodiment of the data import / export form template generation system belongs to the same inventive concept as the data import / export form template generation methods in the above embodiments. For details not described in detail in the embodiment of the data import / export form template generation system, please refer to the embodiment of the data import / export form template generation method above.

[0105] Figure 3 This is a schematic diagram of the structure of a terminal 300 provided in an embodiment of the present invention. The terminal 300 can be used to execute the data import and export form template generation method provided in the embodiment of the present invention.

[0106] The terminal 300 may include a processor 310, a memory 320, and a communication unit 330. These components communicate via one or more buses. Those skilled in the art will understand that the server structure shown in the figure does not constitute a limitation of the present invention. It may be a bus topology or a star topology, and may include more or fewer components than shown, or combine certain components, or have different component arrangements.

[0107] The memory 320 can be used to store the execution instructions of the processor 310. The memory 320 can be implemented by any type of volatile or non-volatile memory terminal or a combination thereof, such as static random access memory (SRAM), electrically erasable programmable read-only memory (EEPROM), erasable programmable read-only memory (EPROM), programmable read-only memory (PROM), read-only memory (ROM), magnetic storage, flash memory, magnetic disk, or optical disk. When the execution instructions in the memory 320 are executed by the processor 310, the terminal 300 is able to perform some or all of the steps in the above method embodiments.

[0108] The processor 310 serves as the control center of the storage terminal, connecting various parts of the electronic terminal via various interfaces and lines. It executes software programs and / or modules stored in the memory 320, and calls data stored in the memory to perform various functions of the electronic terminal and / or process data. The processor can be composed of integrated circuits (ICs), such as a single packaged IC or multiple packaged ICs with the same or different functions connected together. For example, the processor 310 may consist only of a central processing unit (CPU). In this embodiment of the invention, the CPU may have a single processing core or include multiple processing cores.

[0109] The communication unit 330 is used to establish a communication channel, enabling the storage terminal to communicate with other terminals. It can receive user data sent by other terminals or send user data to other terminals.

[0110] The present invention also provides a computer storage medium 400, such as... Figure 4 As shown, the computer storage medium 400 may store a program 410, which, when executed, may include some or all of the steps provided in the embodiments of the present invention. The storage medium may be a magnetic disk, an optical disk, read-only memory (ROM), or random access memory (RAM), etc.

[0111] The same or similar parts between the various embodiments in this specification can be referred to mutually. In particular, the terminal embodiments are basically similar to the method embodiments, so the description is relatively simple, and the relevant parts can be referred to the description in the method embodiments.

[0112] In the embodiments provided by this invention, it should be understood that the disclosed systems, apparatuses, and methods can be implemented in other ways. For example, the apparatus embodiments described above are merely illustrative; for instance, the division of units is only a logical functional division, and in actual implementation, there may be other division methods. For example, multiple units or components may be combined or integrated into another system, or some features may be ignored or not executed. Furthermore, the coupling or direct coupling or communication connection shown or discussed may be through some interfaces; the indirect coupling or communication connection between devices or units may be electrical, mechanical, or other forms.

[0113] The units described as separate components may or may not be physically separate. The components shown as units may or may not be physical units; that is, they may be located in one place or distributed across multiple network units. Some or all of the units can be selected to achieve the purpose of this embodiment according to actual needs.

[0114] In addition, the functional units in the various embodiments of the present invention can be integrated into one processing unit, or each unit can exist physically separately, or two or more units can be integrated into one unit.

[0115] In the above embodiments of the present invention, the descriptions of each embodiment have different focuses. For parts not described in detail in a certain embodiment, please refer to the relevant descriptions of other embodiments.

[0116] This invention supports dynamic column name configuration, which helps to flexibly meet the import and export needs of different Excel file data between different departments of an enterprise.

[0117] This invention is easy to operate, flexible in use, and scalable, adaptable to the business needs and data format requirements of different departments, breaking down the limitations imposed by different departments within an enterprise on their business needs and data formats. The configuration function of this invention allows users to easily adjust the import / export column names for different departments.

[0118] The above description of the disclosed embodiments enables those skilled in the art to make or use the invention. Various modifications to these embodiments will be readily apparent to those skilled in the art, and the general principles defined herein may be implemented in other embodiments without departing from the spirit or scope of the invention. Therefore, the invention is not to be limited to the embodiments shown herein, but is to be accorded the widest scope consistent with the principles and novel features disclosed herein.

Claims

1. A method for generating data import / export form templates, characterized in that, The methods include: S1. Create a basic form; The form includes the form column structure used to generate data import and export form templates for all the actual business scenarios currently used by the user; The form column structure includes a column structure with common columns and a column structure with personalized columns; S2. Define basic business scenarios, with each basic business scenario corresponding to an actual business scenario; S3. For the defined basic business scenario, retrieve the basic form, configure the column data of the business scenario in the retrieved basic form, and adjust the column order to obtain the import / export form style under the corresponding basic business scenario. S4. Define the target business scenario and configure the required import / export form styles for the defined target business scenario; S5. Based on the configured import / export form styles, generate data import / export form templates for the target business scenario.

2. The method according to claim 1, characterized in that, The method also includes: adding steps to basic business scenarios; The newly added steps for the basic business scenarios include: Step S2 defines the basic business scenario corresponding to the newly added actual business scenario, which is then used as the new basic business scenario. Step S3 involves retrieving the basic form for the newly added basic business scenario, configuring the column data for the business scenario, and adjusting the column order within the retrieved basic form to obtain the import / export form style for the newly added basic business scenario.

3. The method according to claim 1 or 2, characterized in that, The method also includes: adding steps to the target business scenario; The new steps for the target business scenario include: Step S4 defines the new target business scenario and configures the required import / export form styles for the defined new target business scenario. Step S5 generates an import / export form template corresponding to the newly added target business scenario based on the configured import / export form style.

4. The method according to claim 1 or 2, characterized in that, The method also includes: The basic form you create supports modifying column names; If any column name in the base form is modified, the corresponding column name in the import / export form styles of all basic business scenarios will be modified simultaneously.

5. The method according to claim 1 or 2, characterized in that, The basic form uses a column structure with common columns and personalized columns for each row record. Each row record corresponds to a form field, and the sorting of the row records corresponds to the sorting of the form fields. Step S3 also includes: providing each row of the retrieved base form with an up button, a down button, and a delete row button.

6. The method according to claim 5, characterized in that, The method also includes: when creating the basic form, completing the data configuration of the common columns used to generate the data import and export form template, without configuring the data of the personalized columns in the form.

7. A data import / export form template generation system, characterized in that, The system includes: The form definition module is used to create basic forms; the form includes the form column structure used to generate data import and export form templates for all the actual business scenarios currently available to the user; the form column structure includes a column structure of common columns and a column structure of personalized columns; The scenario definition module is used to define basic business scenarios, with each basic business scenario corresponding to an actual business scenario; The style acquisition module is used to retrieve the basic form for the defined basic business scenario, configure the column data of the business scenario in the retrieved basic form, and adjust the column order to obtain the import and export form style under the corresponding basic business scenario. The style binding module is used to define target business scenarios and configure the required import / export form styles for the defined target business scenarios; The template generation module is used to generate data import / export form templates corresponding to the target business scenario based on the configured import / export form styles.

8. The system according to claim 7, characterized in that, The system also includes: The data modification module is used to modify the column names in the base form created by the form definition module. The synchronous modification module is used to synchronously modify the corresponding column names in the import and export form styles of all basic business scenarios after any column name in the base form is modified.

9. A terminal, characterized in that, include: processor; Memory used to store the processor's execution instructions; The processor is configured to perform the method of any one of claims 1-6.

10. A computer-readable storage medium storing a computer program, characterized in that, When the program is executed by the processor, it implements the method as described in any one of claims 1-6.

Images