Data configuration method, device and computer equipment

Abstract

The present application relates to a data configuration method, device and computer equipment, the method comprising: loading an aggregate configuration page of a project based on an aggregate configuration library table; the aggregate configuration library table is generated based on the table name and header field of each configuration object worksheet of the project; the aggregate configuration page aggregates each configuration object worksheet; in response to an edit operation on a cell on the aggregate configuration page, the configuration object is determined according to the table name where the cell is located, and a configuration record of the configuration object is obtained according to the field name where the cell is located and the field value filled in the cell edit operation; the configuration record is stored in the aggregate configuration library table, and the configuration record is pushed to the project server based on the aggregate configuration library table to configure the project. This method aggregates each configuration object worksheet of the project on a configuration page. When configuring, the configuration personnel do not need to open multiple configuration object tables separately. It has the advantages of being intuitive and simplifying operations, and can effectively improve configuration efficiency.

Description

Technical Field

[0001] The present application relates to the field of computer technology, and in particular to a data configuration method, device and computer equipment. Background Art

[0002] For applications, there will be some operation projects during the operation process, which need to be configured. As the application operation time increases, when the application version is upgraded, the configuration of the operation project also needs to change accordingly, that is, it needs to be reconfigured, such as adding some configuration objects, deleting some configuration objects, or adjusting the content of the configuration objects.

[0003] Taking games as an example, currently many game configuration data are basically edited and managed based on files in a certain format, such as tables, lua files, json files, or other files in a certain format. Editing and managing operation activity configuration data based on files in a certain format means storing a specific game activity function in a single or multiple table files, that is, scattered in multiple worksheets. As a result, when editing game activity configuration data, it is often necessary to operate more than 10 table files and more worksheets, which makes editing operations cumbersome and inefficient. Summary of the invention

[0004] Based on this, it is necessary to provide a data configuration method, device, computer equipment and storage medium that can improve configuration efficiency in response to the above technical problems.

[0005] A data configuration method, comprising:

[0006] Based on the aggregate configuration library table, the aggregate configuration page of the project is loaded; the aggregate configuration library table is generated based on the table name and header field of each configuration object worksheet of the project; the aggregate configuration page aggregates each configuration object worksheet;

[0007] In response to an edit operation on a cell on the aggregate configuration page, determining a configuration object according to a table name where the cell is located, and obtaining a configuration record of the configuration object according to a field name where the cell is located and a field value filled in by the edit operation on the cell;

[0008] The configuration record is stored in the aggregate configuration library table, and based on the aggregate configuration library table, the configuration record is pushed to the project server to configure the project.

[0009] A data configuration device, the device comprising:

[0010] An aggregation management module, used to load an aggregation configuration page of a project based on an aggregation configuration library table; the aggregation configuration library table is generated based on the table name and header field of each configuration object worksheet of the project; the aggregation configuration page aggregates each configuration object worksheet;

[0011] An editing management module, configured to, in response to an editing operation on a cell on the aggregate configuration page, determine a configuration object according to a table name where the cell is located, and obtain a configuration record of the configuration object according to a field name where the cell is located and a field value filled in by the editing operation on the cell;

[0012] The publishing module is used to store the configuration record in the aggregated configuration library table, and push the configuration record to the project server based on the aggregated configuration library table to configure the project.

[0013] A computer device comprises a memory and a processor, wherein the memory stores a computer program, and when the processor executes the computer program, the following steps are implemented:

[0014] Based on the aggregate configuration library table, the aggregate configuration page of the project is loaded; the aggregate configuration library table is generated based on the table name and header field of each configuration object worksheet of the project; the aggregate configuration page aggregates each configuration object worksheet;

[0015] In response to an edit operation on a cell on the aggregate configuration page, determining a configuration object according to a table name where the cell is located, and obtaining a configuration record of the configuration object according to a field name where the cell is located and a field value filled in by the edit operation on the cell;

[0016] The configuration record is stored in the aggregate configuration library table, and based on the aggregate configuration library table, the configuration record is pushed to the project server to configure the project.

[0017] A computer-readable storage medium stores a computer program, which, when executed by a processor, implements the following steps:

[0018] Based on the aggregate configuration library table, the aggregate configuration page of the project is loaded; the aggregate configuration library table is generated based on the table name and header field of each configuration object worksheet of the project; the aggregate configuration page aggregates each configuration object worksheet;

[0019] In response to an edit operation on a cell on the aggregate configuration page, determining a configuration object according to a table name where the cell is located, and obtaining a configuration record of the configuration object according to a field name where the cell is located and a field value filled in by the edit operation on the cell;

[0020] The configuration record is stored in the aggregate configuration library table, and based on the aggregate configuration library table, the configuration record is pushed to the project server to configure the project.

[0021] The above-mentioned data configuration method, device, computer equipment and storage medium aggregate the configuration object worksheets of the project on one configuration page. When performing configuration, the configuration personnel do not need to open multiple configuration object tables separately. It has the advantages of being intuitive and simplifying operations, and can effectively improve configuration efficiency. BRIEF DESCRIPTION OF THE DRAWINGS

[0022] Figure 1 An application environment diagram of a data configuration method in an embodiment;

[0023] Figure 2 A schematic diagram of a flow chart of a data configuration method in an embodiment;

[0024] Figure 3 A schematic diagram of an interface of an aggregation configuration page in an embodiment;

[0025] Figure 4 A schematic diagram of a process for creating an aggregate configuration library table in one embodiment;

[0026] Figure 5 A schematic diagram of a flow chart of a reference editing operation in one embodiment;

[0027] Figure 6 A schematic diagram of an interface for quoting an editing operation in an embodiment;

[0028] Figure 7 A flowchart of a query operation in one embodiment;

[0029] Figure 8 A schematic diagram of an interface for query operation in an embodiment;

[0030] Fig. 9 A schematic diagram of a process for configuring an ID in an embodiment;

[0031] Fig.10 A schematic diagram of an interface for configuring an ID in an embodiment;

[0032] Fig.11 A schematic diagram of a process flow of a line closing operation in one embodiment;

[0033] Fig.12 A schematic diagram of an interface for a line closing operation in one embodiment;

[0034] Fig.13 is a schematic diagram of a process of a restoration operation in an embodiment;

[0035] Fig.14A schematic diagram of an interface for a restore operation in an embodiment;

[0036] Fig.15 A schematic diagram of a structure of data configuration in one embodiment;

[0037] Fig.16 FIG. 4 is a diagram showing the internal structure of a computer device in one embodiment. DETAILED DESCRIPTION

[0038] In order to make the purpose, technical solution and advantages of the present application more clearly understood, the present application is further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are only used to explain the present application and are not used to limit the present application.

[0039] The data configuration method provided in this application can be applied to Figure 1 In the application environment shown. The configuration terminal 102 communicates with the project server 104 through the network. The project server specifically refers to the server on which the project is running. For example, if the project is a game application, the project server is a game server. Specifically, the configuration terminal loads the aggregate configuration page of the project based on the aggregate configuration library table; the aggregate configuration library table is generated based on the table name and header field of each configuration object worksheet of the project; the aggregate configuration page aggregates each configuration object worksheet; in response to the editing operation of the cell on the aggregate configuration page, the configuration object is determined according to the table name where the cell is located, and the configuration record of the configuration object is obtained according to the field name where the cell is located and the field value filled in the cell editing operation; the configuration record is stored in the aggregate configuration library table, and the configuration record is pushed to the project server based on the aggregate configuration library table to configure the project. The terminal 102 can be, but is not limited to, various personal computers, laptops, smart phones, tablet computers and portable wearable devices, and the server 104 can be implemented with an independent server or a server cluster consisting of multiple servers.

[0040] In one embodiment, Figure 2 As shown, a data configuration method is provided, which is applied to Figure 1 The configuration terminal in is used as an example to illustrate the following steps:

[0041] Step S202, based on the aggregate configuration library table, load the aggregate configuration page of the project; the aggregate configuration library table is generated based on the table name and header field of each configuration object worksheet of the project; the aggregate configuration page aggregates each configuration object worksheet.

[0042] Among them, the configuration object is the project configuration target involved in the project. In actual applications, different project activities of different applications correspond to different configuration objects. If the project is the operation activity of the application, the project configuration parameters are the operation activity configuration parameters. Taking the application as a game as an example, the configuration object is the operation activity configuration parameters in the game operation, including gifts, items, tasks, etc.

[0043] For each configuration object, the traditional configuration management method is to use related tables for management respectively. In this embodiment, an aggregated configuration library table is generated in the database based on the table name and header field of each configuration object worksheet. The aggregated configuration library table aggregates the table structure of each configuration object and integrates the table structure of each configuration object into one table structure. In the aggregated configuration library table, the table structure of each configuration object is based on the table structure of the original configuration object worksheet, wherein the header field of each configuration object in the aggregated configuration library table includes the header field and table name of the table structure of each configuration object. If one configuration object is based on an activity and one configuration object is for consumption and exchange, the table name of the configuration object and the table structure of each configuration object itself are used as the header field of the configuration object in the aggregated configuration library table. Through the aggregated configuration library table, multiple configuration object worksheets that were originally separated are aggregated into one database table.

[0044] Based on the aggregate configuration library table, load the aggregate configuration page of the project. The aggregate configuration page is a visual configuration page that aggregates the worksheets of various configuration objects. From a visual perspective, multiple separate worksheets of configuration objects can be managed comprehensively on an aggregate configuration page, realizing online configuration editing management with a one-page activity granularity, that is, data items of multiple files or multiple worksheets involved in an activity are aggregated on one page for configuration management. Figure 3 As shown, taking the application as a game as an example, on the aggregate configuration page, lines 1 to 3 are the aggregate configuration page information, and lines 5 to 7 are the contents of the first configuration object worksheet, which involve the first configuration object. Lines 12 to 14 are the contents of the second configuration object worksheet, which involve the second configuration object. Lines 19 to 21 are the contents of the third configuration object worksheet, which involve the third configuration object. Lines 26 to 28 are the contents of the fourth configuration object worksheet, which involve the fourth configuration object. The content of each configuration object worksheet is displayed with the configuration object worksheet name and header field. The configuration personnel can intuitively determine the configuration object through the configuration object worksheet name and header field, and configure relevant parameters for the configuration object based on the header field.

[0045] The aggregation configuration page aggregates multiple configuration object tables corresponding to the project. It can be understood that by configuring the relevant configuration objects on the aggregation configuration page, the configuration content is stored in the aggregation configuration library table. In other words, the aggregation configuration page is an external display of the aggregation configuration library table, and the data of the aggregation configuration library table is loaded and edited through the aggregation configuration page.

[0046] Step S204, in response to an editing operation on a cell on the aggregate configuration page, determines a configuration object according to the table name where the cell is located, and obtains a configuration record of the configuration object according to the field name where the cell is located and the field value filled in by the cell editing operation.

[0047] The aggregate configuration page aggregates multiple configuration object worksheets involved in the project configuration. When editing one of the cells, the configuration object is determined based on the table name where the cell is located, and the configuration record of the configuration object is obtained based on the field name where the cell is located and the field value filled in the cell editing operation. For example, if the table name of the currently configured cell is Prizes and the field value is Task Description, after the cell is edited, the field value of Task Description is obtained, and the configuration record of a cell for the configuration object Prize is obtained. By editing cells with different table names and field names, configuration records of cells of different configuration objects can be obtained.

[0048] In other words, the configuration of different configuration objects can be completed on an aggregate configuration page. In the actual configuration process, there is correlation between the configuration objects, and a configuration content often needs to refer to the configuration of other configuration objects. For example, when configuring tasks, the tasks exist in different game chapters. When configuring the configuration, it is also necessary to refer to the configuration of the game chapter. In the present embodiment, when configuring based on the aggregate configuration page, the configuration personnel do not need to open multiple configuration object tables separately, which has the advantages of being intuitive and simplified operation.

[0049] Step S206: store the configuration record in the aggregate configuration library table, and push the configuration record to the project server based on the aggregate configuration library table to configure the project.

[0050] After completing the configuration based on the aggregate configuration page, the configuration record is stored in the aggregate configuration library table. Based on the aggregate configuration library table, the configuration record is pushed to the project server, and the project server implements the configuration. Taking the game as an example, when the configuration of the game activity is completed, the configuration is pushed to the game server, and the game server configures the game activity.

[0051] The above data configuration method aggregates the configuration object worksheets of the project on one configuration page. When performing configuration, the configuration personnel do not need to open multiple configuration object tables separately. It has the advantages of being intuitive and simplifying operations, and can effectively improve configuration efficiency.

[0052] In another embodiment, the process of creating an aggregate configuration library table is as follows: Figure 4 As shown, each configuration object worksheet and the header field of each configuration object worksheet are obtained; the configuration object worksheet and the header field thereof are converted into a description file; and according to the description file, an aggregate configuration library table is established in a database.

[0053] Specifically, the project configuration worksheet (such as each worksheet in the Excel table) and the header fields in the worksheet are converted into a description file in json format, and then the description file is parsed uniformly, and the corresponding aggregation configuration library table is established in the database. The records in the worksheet are imported into the data for editing and management, and a visual web page, namely the aggregation configuration page, is provided to load and edit the data in the database table. The header field is the header of the worksheet. Taking the task configuration as an example, its header field is shown in Table 1:

[0054] Table 1 Header fields of task configuration

[0055]

[0056] In this implementation, the configuration personnel only need to configure the table name of each configuration object worksheet and the header field of the worksheet according to the previous working method. The system automatically reads the table name and header field of each configuration object worksheet, builds the table structure of the aggregate configuration library table, and provides an aggregate configuration page based on this. In this way, the user can complete the configuration on one page during the configuration process without switching between multiple worksheets, which provides convenience for configuration.

[0057] In another embodiment, the editing operation on the aggregation configuration page is performed based on cells, that is, the configuration of the field value of the corresponding field name is realized by editing the cell. In one embodiment, the input content based on the cell trigger can be obtained to obtain the field value entered in the cell. This method is configured by manual entry.

[0058] In actual applications, each configuration object table is not isolated, but related. The configuration object worksheets designed by the project configuration can reference each other. For example, one configuration object table is a prize list, and another configuration object table is an activity gift package. The activity gift package usually includes one or more prize lists. When you need to configure the activity gift package, you can reference the configuration of the prize list and insert the items in the prize list without manual input.

[0059] In the traditional way, the reference is realized by copying and pasting. For example, when configuring the activity gift package configuration table, open the prize list configuration table, find the item ID, and copy the item ID (ID) of the prize list to the reward content of the activity gift package.

[0060] In this embodiment, the function of directly searching and referencing configured parameters without switching tables in the aggregate configuration page further improves configuration efficiency. Specifically, in response to an edit operation on a cell on the aggregate configuration page, the configuration object is determined according to the table name where the cell is located; if the edit operation is a reference edit operation, the field name to which the cell belongs is obtained, wherein the field name includes pre-marked referenceable field names; the first mapping relationship table corresponding to the field name is loaded; based on the first mapping relationship table, the target to be referenced is selected, and the field value as the field name is filled in; and the configuration record of the configuration object is obtained according to the field name where the cell is located and the field value filled in by the reference edit operation.

[0061] Specifically, the aggregation configuration page has correlation in advance, and the referenced cells can be added with monitoring events. When the reference editing operation is detected to be triggered on the cell, the field name to which the cell belongs is obtained, and the first mapping relationship table corresponding to the field name is loaded by matching and reading the associated configuration table data in the aggregation configuration library table. Figure 5 As shown, the triggering of the reference editing operation is specifically, when it is detected that the configuration personnel right-clicks a cell, the field name corresponding to the cell is located. Determine whether the field contains a pre-set referenceable flag field. The referenceable flag field is set in advance for the task field, and the pre-set referenceable flag field is task, then determine whether the field includes the task field. When the field triggered by the user includes a referenceable flag field, the "data reference" function option is displayed. If the cell does not support the quick reference function, that is, the field to which the triggered cell belongs does not have a pre-identified referenceable flag field, the "data reference" function option is not displayed. When the configuration user clicks the "data reference" function option, the drop-down option table of the first mapping relationship table is loaded. Among them, the first mapping relationship table is the mapping relationship loaded from the database when the aggregation configuration page is loaded. The configuration user can click or search to select the content to be written. The writing method includes overwrite writing and append writing. When overwriting, clear the content of the selected cell and then write. When appending, keep the content of the selected cell and append writing.

[0062] Taking the preset referenceable flag field as task as an example, the configured task DI can be introduced by reference. Specifically, after right-clicking the corresponding option function in the cell where you want to apply the task id, an id drop-down list is displayed. The user can find the id that needs to be written in the id drop-down list. The display items of the drop-down list are the characters connected with the id and its Chinese characters, and the actual value is only its id, so when fuzzy searching, both searching for id and searching for Chinese characters are acceptable to the program side, and what is finally written is the id itself. After selecting the corresponding id, you can overwrite or append it.

[0063] like Figure 6 As shown, taking the preset referenceable flag field as GiftItemID(thing) as an example, its cell is filled with items. When "Data Reference" is provided in the right-click menu, you can query and display the item list by clicking it. The item list provides a quick selection. Select the cell filled with the item ID in the list and reference it to the cell.

[0064] In this embodiment, based on the aggregate configuration library table, the relevant configured content can be filled in the relevant table by the introduction method on the aggregate configuration page, and the function of directly searching and referencing the historical configuration can be performed without cutting the table, thereby further improving the configuration efficiency.

[0065] During the configuration process, if you need to query the configuration content represented by a unique ID, you need to first open the corresponding ID configuration table and then search for the ID to view it, which is cumbersome.

[0066] Based on this, a convenient query method is provided in this embodiment. Specifically, in response to a query request triggered based on a cell on the aggregation configuration page, the field name to which the cell belongs is obtained, wherein the field name includes a pre-marked queryable field name; if the field name is a pre-marked queryable field name, the second mapping relationship table corresponding to the field name is loaded for display. That is, the corresponding mapping relationship table can be loaded on the current page for viewing. This method is particularly suitable for configuration inspection.

[0067] Specifically, Figure 7As shown, the query operation is triggered, specifically, when it is detected that the configuration personnel right-clicks on a cell, the field name corresponding to the cell is located. Determine whether the field contains a pre-set queryable flag field. For example, a query flag field is set for the task field in advance. When the field triggered by the user includes the query flag field, the "query" function option is displayed. If the cell does not support the query function, that is, the field to which the triggered cell belongs does not have a pre-identified query function, the "query" function option is not displayed. When the configuration user clicks the "query" function option, the drop-down option table of the second mapping relationship table is loaded. Among them, the second mapping relationship table is the mapping relationship loaded from the database when the aggregation configuration page is loaded. The second mapping relationship table is displayed in tabular form, such as Figure 8 It is understandable that when the configuration user query is completed, the second mapping relationship table may be triggered to be withdrawn.

[0068] Taking the queryable field as ID Chinese as an example, this method is used to trigger a query on the ID field, and the Chinese information of the ID can be displayed. When you right-click a cell, it will determine which field the cell corresponds to and whether the field contains flag characters (for example, for a quick query of the task id, the task character will be added after the field). If it does, the option function [ID Chinese Check] will be displayed. After clicking this option function, the corresponding item is found in the id mapping table pre-loaded into the memory, and then the relationship between the id and its related fields is displayed in the form of a table, that is, the second mapping relationship table. This id Chinese mapping table is constructed by reading the task table, item table, gift package table and other contents from the database when the page is loaded, and establishing a mapping relationship between the id and its related fields. For more complex mapping relationships, the development mainly focuses on the reading process. By expanding the reading process, complex mapping relationships can be read. If the id syntax of the query is illegal, a user prompt will be given before display. For example, the field name GiftItemID of a cell contains (thing), which means that this column is configured with items. To add a monitoring event to such a cell, click the configured content below it, and right-click to pop up the corresponding option list, where 'ID Chinese Check' appears, which can facilitate the query of the item information.

[0069] The above method can realize convenient cross-table search of configuration records on the aggregation configuration page.

[0070] In another embodiment, the project configuration designs multiple configuration objects, and each configuration object needs to be configured with a corresponding identifier (ID), which is the configuration ID and can be used to uniquely identify a configuration data record. The traditional method uses manual management and allocation, which is cumbersome and error-prone, and may even cause external network accidents, and is not convenient for multi-person collaboration.

[0071] In this embodiment, in response to the storage instruction, the variable name to be configured whose identifier is empty on the aggregation configuration page is obtained; the identifier is assigned to the variable name to be configured according to the type and index of the variable name to be configured, and filled in the cell where the variable name identifier field is located. That is, in this embodiment, all configuration object IDs are automatically assigned without manual management and maintenance.

[0072] Because the program needs to use a unique ID to represent a specific data, a lot of data needs to be assigned a unique ID. Therefore, in the old configuration system, a unique ID needs to be manually assigned to each prop, each task, and each activity. If the unique ID is used incorrectly, it may cause serious external network accidents.

[0073] In this embodiment, in order to solve the problem of unique ID allocation, there is no need to manually manage and fill in the specific unique ID value. You only need to pay attention to the ID type and serial number, fill in the variable name {Type 1 ID1} placeholder and match the corresponding relationship, which greatly improves the configuration efficiency and accuracy.

[0074] Specifically, Fig. 9 and Fig.10 As shown, the acquisition of the configuration ID is triggered when the edited activity data is saved. When saving the activity data, the cells in the table containing the variable name identifier, such as the cell content of "{{XXX1}}" will be traversed first. Among them, XXX is the ID type obtained, and the serial number 1 is used to identify the ID index in a single edit, which is used to distinguish multiple XXX type IDs obtained by word editing (or it can be understood that multiple new configuration IDs will be used in one configuration). After the front end obtains the ID type and index, it obtains the specific ID through the back-end interface of the ID generator, and then writes to the cell. The value range of the configuration ID type, the unique ID allocation code, increases within the value range. The unique ID required by the program to identify the data is replaced by the corresponding unique ID allocation code. It is only necessary to use the number at the end of the allocation code to correctly configure the corresponding relationship between the data in different tables; when saving, a new unique ID that complies with the rules is automatically filled in.

[0075] Taking game activities as an example, the unique ID allocation code consists of {type id serial number}. Currently, there are four types of allocation codes: activity id {ActivityID1}, picture id {PictureID1}, task id {TaskID1}, and item or gift package id {ThingID1}. Automatic ID allocation can be achieved for these four types.

[0076] Specifically, the backend interface is implemented by using the self-increment feature of the primary key of the data table. Whenever the interface is called, a new row of records will be added to the database and the primary key ID of the record will be returned. Considering the possibility of concurrent access to the interface, the interface is designed with a distributed lock based on Redis. When multiple users call the generator interface, only one user can call successfully due to the atomicity of Redis's setnx operation. In order to prevent a user from holding the lock for a long time due to some reasons (such as database downtime) and blocking other users from obtaining the configuration ID, the lock will be configured with a certain expiration time.

[0077] In the method implemented in this embodiment, all configuration IDs are automatically allocated without manual management and maintenance.

[0078] In another embodiment, as operational activities are upgraded, configurations also change accordingly. In order to compare differences in configuration data and verify configuration modifications, it is necessary to compare configuration data from previous and later versions. Traditionally, to compare differences, one needs to get two worksheets before and after the modification and use a configuration comparison tool to compare them. For example, to merge records of dozens of worksheets, one needs to open each worksheet one by one on the version controller (svn), get the previous version configuration, and then use the configuration comparison tool to compare. This process is very time-consuming, cumbersome, and error-prone. It is troublesome to trace back after the merge, and it is not convenient to trace back to every small modification point, which is also not convenient for fine-grained restoration and recovery.

[0079] In this embodiment, the configuration aggregation pages obtained from the two configurations can be merged to determine the changed configuration data. Merging refers to merging two configuration aggregation pages, comparing the two, and determining the changed configuration data. Taking a game as an example, a new version of the game will be released to the public at intervals, and this version will add many new configuration records during operation, such as new in-game activities; and after about a month, when the next new version is ready to be released, the configuration records added on the previous version need to be merged into the new version currently being released and released together. This is merging.

[0080] Specifically, in response to the merge operation, the configuration records of the source line and the target line are loaded based on the aggregate configuration library table; and the changed configuration data of the target line relative to the source line is determined according to the configuration records of the source line and the configuration records of the target line.

[0081] like Fig.11 and Fig.12As shown, a source line and a target line are selected, and the target line is a new configuration based on the source line. In one embodiment, the source line can be an old configuration, and the target line can be a new configuration. According to the configuration record of the source line and the configuration record of the target line, a comparison is performed to determine the change of the target line relative to the source line as the merged data. If the merge is successful, all successfully merged tables are recorded. If the merge is interrupted, only the successfully merged tables are recorded. Each merge operation will be recorded as a merge history. Each merge history will record the merged source line, target line, operator, merge time and the most important merge data. The merged data is saved in JSON format, which mainly saves the tables merged this time and their data modifications.

[0082] The merge history is similar to the configuration table and is saved in the database table. In particular, these common data are placed in the common data project separately from the Excel configuration table.

[0083] Comparing the configuration data of multiple versions can show the configuration differences between two version lines in detail, making it easy to merge the lines. When merging the lines, detailed merge operation records are recorded, making it easy to perform post-merge verification and single data dimension restoration operations.

[0084] Specifically, after merging, you can view the merge history, and click on the merge details to check and restore the merge operation. The granularity of restoration is one piece of data in each table, and you can select multiple data modifications that do not meet your expectations for restoration. After selecting restore, the data that has been successfully restored will be marked, and you will not see the data when you view the merge details again, preventing repeated restoration of the merge history.

[0085] Specifically, when merging, each change operation involved in the merge will be recorded, and restore is to undo these change operations. The purpose of restore is: when the configuration personnel find that some change records are wrong when merging, the changes can be undone through the restore operation.

[0086] Specifically, each changed configuration data is displayed in strips; when a restore instruction for the changed configuration data is obtained, the changed configuration data is restored to the configuration record of the source line. Fig.13 and Fig.14 As shown, when viewing the merge history, each changed configuration data is displayed in strips. When the user restores one of the changed configuration data, the merge details are selected to roll back, the record selected to roll back is marked, and it is restored to the configuration record of the source line.

[0087] In this embodiment, after the operation configuration data is stored in the database table, each version of the operation configuration data corresponds to a different database on the system. The operation configuration data of different versions are merged, and the comparison is very convenient. That is, each record in the two aggregate configuration library tables is compared, and the differences can be easily and clearly found and displayed, and selective merging can be performed. The merged records can be stored, which can facilitate subsequent preview and inspection of the merged content. If any problems are found, the modified areas can be easily rolled back and restored.

[0088] By adopting the data configuration method of this application, the overall configuration efficiency is improved by 100%, reducing the configuration manpower for the project team by half.

[0089] It should be understood that, although the steps in the above-mentioned flowcharts are displayed in sequence according to the indication of the arrows, these steps are not necessarily executed in sequence according to the order indicated by the arrows. Unless there is a clear description in this article, there is no strict order restriction on the execution of these steps, and these steps can be executed in other orders. Moreover, at least a part of the steps in the above-mentioned flowcharts may include multiple steps or multiple stages, and these steps or stages are not necessarily executed at the same time, but can be executed at different times, and the execution order of these steps or stages is not necessarily to be carried out in sequence, but can be executed in turn or alternately with other steps or at least a part of the steps or stages in other steps.

[0090] In one embodiment, Fig.15 As shown, a data configuration device is provided, which can be a part of a computer device using a software module or a hardware module, or a combination of the two. The device specifically includes:

[0091] Aggregation management module 1101, used to load the aggregation configuration page of the project based on the aggregation configuration library table; the aggregation configuration library table is generated based on the table name and header field of each configuration object worksheet of the project; the aggregation configuration page aggregates each configuration object worksheet;

[0092] The editing management module 1102 is used to respond to the editing operation of the cell on the aggregation configuration page, determine the configuration object according to the table name where the cell is located, and obtain the configuration record of the configuration object according to the field name where the cell is located and the field value filled in the editing operation of the cell;

[0093] The publishing module 1103 is used to store the configuration record in the aggregated configuration library table, and push the configuration record to the project server based on the aggregated configuration library table to configure the project.

[0094] The above-mentioned data configuration device aggregates the configuration object worksheets of the project on one configuration page. When performing configuration, the configuration personnel do not need to open multiple configuration object tables separately. It has the advantages of being intuitive and simplifying operations, and can effectively improve configuration efficiency.

[0095] In another embodiment, it also includes a data table construction module, which is used to obtain each configuration object worksheet and the header field of each configuration object worksheet; convert the configuration object worksheet and its header field into a description file; and establish an aggregate configuration library table in the database according to the description file.

[0096] In another embodiment, an editing management module is used to respond to an editing operation on a cell on the aggregate configuration page, determine a configuration object according to the table name where the cell is located; if the editing operation is a reference editing operation, obtain the field name to which the cell belongs, wherein the field name includes a pre-marked referenceable field name; load a first mapping relationship table corresponding to the field name; select a target to be referenced based on the first mapping relationship table, and fill in the field value as the field name; and obtain a configuration record of the configuration object according to the field name where the cell is located and the field value filled in by the reference editing operation.

[0097] In another embodiment, it also includes a query management module for obtaining the field name to which the cell belongs in response to a query request triggered based on the cell on the aggregation configuration page, wherein the field name includes a pre-marked queryable field name; and loading a second mapping relationship table corresponding to the field name for display.

[0098] In another embodiment, it also includes an allocation module, which is used to respond to the storage instruction, obtain the name of the variable to be matched with an empty mark on the aggregation configuration page; assign an identifier to the variable name to be matched according to the type and index of the variable name to be matched, and fill it in the cell where the variable name mark field is located.

[0099] In another embodiment, it also includes a line merging operation module, which is used to load the configuration record of the source line and the configuration record of the target line based on the aggregate configuration library table in response to the line merging operation; and determine the changed configuration data of the target line relative to the source line according to the configuration record of the source line and the configuration record of the target line.

[0100] In another embodiment, a restoration operation module is further included, which is used to display each changed configuration data in strips; when a restoration instruction for one of the changed configuration data is obtained, the changed configuration data is restored to the configuration record of the source line.

[0101] For the specific definition of the data configuration device, please refer to the definition of the data configuration method above, which will not be repeated here. Each module in the above data configuration device can be implemented in whole or in part by software, hardware and a combination thereof. Each of the above modules can be embedded in or independent of the processor in the computer device in the form of hardware, or can be stored in the memory in the computer device in the form of software, so that the processor can call and execute the operations corresponding to each of the above modules.

[0102] In one embodiment, a computer device is provided. The computer device may be a server, and its internal structure diagram may be as follows: Fig.12 As shown. The computer device includes a processor, a memory and a network interface connected through a system bus. Among them, the processor of the computer device is used to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system, a computer program and a database. The internal memory provides an environment for the operation of the operating system and the computer program in the non-volatile storage medium. The database of the computer device is used to store configuration data. The network interface of the computer device is used to communicate with an external terminal through a network connection. When the computer program is executed by the processor, a data configuration method is implemented.

[0103] Those skilled in the art will understand that Fig.12 The structure shown in the figure is only a block diagram of a part of the structure related to the solution of the present application, and does not constitute a limitation on the computer device to which the solution of the present application is applied. The specific computer device may include more or fewer components than those shown in the figure, or combine certain components, or have a different arrangement of components.

[0104] In one embodiment, a computer device is further provided, including a memory and a processor, wherein a computer program is stored in the memory, and the processor implements the steps in the above method embodiments when executing the computer program.

[0105] In one embodiment, a computer-readable storage medium is provided, storing a computer program, which implements the steps in the above method embodiments when executed by a processor.

[0106] In one embodiment, a computer program product or computer program is provided, the computer program product or computer program includes computer instructions, the computer instructions are stored in a computer-readable storage medium. A processor of a computer device reads the computer instructions from the computer-readable storage medium, and the processor executes the computer instructions, so that the computer device performs the steps in the above-mentioned method embodiments.

[0107] Those of ordinary skill in the art can understand that all or part of the processes in the above-mentioned embodiment methods can be completed by instructing the relevant hardware through a computer program, and the computer program can be stored in a non-volatile computer-readable storage medium. When the computer program is executed, it can include the processes of the embodiments of the above-mentioned methods. Among them, any reference to memory, storage, database or other media used in the embodiments provided in this application can include at least one of non-volatile and volatile memory. Non-volatile memory can include read-only memory (ROM), magnetic tape, floppy disk, flash memory or optical memory, etc. Volatile memory can include random access memory (RAM) or external cache memory. As an illustration and not limitation, RAM can be in various forms, such as static random access memory (SRAM) or dynamic random access memory (DRAM).

[0108] The technical features of the above embodiments may be combined arbitrarily. To make the description concise, not all possible combinations of the technical features in the above embodiments are described. However, as long as there is no contradiction in the combination of these technical features, they should be considered to be within the scope of this specification.

[0109] The above-mentioned embodiments only express several implementation methods of the present application, and the descriptions thereof are relatively specific and detailed, but they cannot be understood as limiting the scope of the invention patent. It should be pointed out that, for a person of ordinary skill in the art, several variations and improvements can be made without departing from the concept of the present application, and these all belong to the protection scope of the present application. Therefore, the protection scope of the patent of the present application shall be subject to the attached claims.

Claims

1. A data configuration method, comprising: Get each configuration object worksheet and the header field of each configuration object worksheet; Converting the configuration object worksheet and its header fields into a description file; According to the description file, an aggregation configuration library table is established in the database; Based on the aggregate configuration library table, the aggregate configuration page of the project is loaded; the aggregate configuration library table is generated based on the table name and header field of each configuration object worksheet of the project; the aggregate configuration page aggregates each configuration object worksheet; In response to an edit operation on a cell on the aggregate configuration page, determining a configuration object according to a table name where the cell is located; If the editing operation is a reference editing operation, obtaining the field name to which the cell belongs, wherein the field name includes a pre-marked referenceable field name; Loading a first mapping relationship table corresponding to the field name; Selecting a target to be referenced based on the first mapping relationship table, and filling in a field value as the field name; Obtaining a configuration record of the configuration object according to the field name of the cell and the field value filled by the reference editing operation; The configuration record is stored in the aggregate configuration library table, and based on the aggregate configuration library table, the configuration record is pushed to the project server to configure the project.

2. The method according to claim 1, characterized in that The method further comprises: In response to a query request triggered based on a cell on the aggregation configuration page, obtaining a field name to which the cell belongs, wherein the field name includes a pre-marked queryable field name; The second mapping relationship table corresponding to the field name is loaded for display.

3. The method according to claim 1, characterized in that The method further comprises: In response to the storage instruction, obtaining the name of the variable to be configured whose mark is empty on the aggregation configuration page; An identifier is assigned to the variable name to be assigned according to the type and index of the variable name to be assigned, and is filled in the cell where the variable name identifier field is located.

4. The method according to claim 1, characterized in that: The method further comprises: In response to the merge operation, the configuration record of the source line and the configuration record of the target line are loaded based on the aggregate configuration library table; According to the configuration record of the source line and the configuration record of the target line, the changed configuration data of the target line relative to the source line is determined.

5. The method according to claim 4, characterized in that The method further comprises: Display each changed configuration data in strips; When a restoration instruction for one of the changed configuration data is obtained, the changed configuration data is restored to a configuration record of a source line.

6. A data configuration device, characterized in that: The device comprises: A data table construction module is used to obtain each configuration object worksheet and the header field of each configuration object worksheet; convert the configuration object worksheet and its header field into a description file; and establish an aggregate configuration library table in a database according to the description file; An aggregation management module, used to load an aggregation configuration page of a project based on an aggregation configuration library table; the aggregation configuration library table is generated based on the table name and header field of each configuration object worksheet of the project; the aggregation configuration page aggregates each configuration object worksheet; An editing management module, for responding to an editing operation on a cell on the aggregate configuration page, determining a configuration object according to a table name where the cell is located; if the editing operation is a reference editing operation, obtaining a field name to which the cell belongs, wherein the field name includes a pre-marked referenceable field name; loading a first mapping relationship table corresponding to the field name; selecting a target to be referenced based on the first mapping relationship table, and filling in a field value as the field name; obtaining a configuration record of the configuration object according to the field name where the cell is located and the field value filled in by the reference editing operation; The publishing module is used to store the configuration record in the aggregated configuration library table, and push the configuration record to the project server based on the aggregated configuration library table to configure the project.

7. The device according to claim 6, characterized in that The device also includes: A query management module is used to respond to a query request triggered based on a cell on the aggregation configuration page, obtain the field name to which the cell belongs, wherein the field name includes a pre-marked queryable field name; and load a second mapping relationship table corresponding to the field name for display.

8. The device according to claim 6, characterized in that The device also includes: The sub-module is used to respond to the storage instruction, obtain the variable name to be matched with an empty identifier on the aggregation configuration page; assign an identifier to the variable name to be matched according to the type and index of the variable name to be matched, and fill it in the cell where the variable name identifier field is located.

9. The device according to claim 6, characterized in that The device also includes: A line merging operation module is used to respond to a line merging operation, load the configuration record of the source line and the configuration record of the target line based on the aggregate configuration library table; and determine the changed configuration data of the target line relative to the source line according to the configuration record of the source line and the configuration record of the target line.

10. The device according to claim 9, characterized in that The device also includes: The restoration operation module is used to display each item of changed configuration data in strips; when a restoration instruction for one of the changed configuration data is obtained, the changed configuration data is restored to the configuration record of the source line.

11. A computer device comprising a memory and a processor, wherein the memory stores a computer program, wherein: When the processor executes the computer program, the steps of the method according to any one of claims 1 to 5 are implemented.

12. A computer-readable storage medium storing a computer program, characterized in that: When the computer program is executed by a processor, the steps of the method according to any one of claims 1 to 5 are implemented.

13. A computer program product, comprising a computer program, wherein when the computer program is executed by a processor, the steps of the method according to any one of claims 1 to 5 are implemented.

Images