Data processing template generation method and device, electronic equipment and storage medium
By determining the template to be applied and the target data source, extracting data field information and configuring import rules, a matching data processing template is generated, which solves the problem of inconsistent table templates for different data storage and realizes automated and simplified batch data processing.
Patent Information
- Application Number
- CN202210889340.9
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2022-07-27
- Publication Date
- 2025-12-30
- Estimated Expiration
- 2042-07-27
AI Technical Summary
In existing technologies, the table templates for different data storage are inconsistent, which requires users to manually create data processing templates, increasing operational complexity and reducing user experience.
By determining the template to be applied and the target data source, data field information is extracted, and data import rules are configured for the target field information to generate a data processing template that matches the target data source.
It enables the automatic creation of data processing templates based on user selections, meeting the batch data processing needs in different scenarios, simplifying the operation process, and improving the user experience.
Smart Images

Figure CN115169316B_ABST
Abstract
Description
TECHNICAL FIELD
[0001] The present application relates to the technical field of computer, and in particular to a data processing template generation method and device, electronic equipment and storage medium. BACKGROUND
[0002] With the continuous development of computer technology, more and more data needs to be processed and stored. In order to facilitate data processing and storage, a table form is often used for data storage.
[0003] However, since different data storage table templates are not the same, different data processing templates must be used for processing different data. However, the user often needs to manually establish the corresponding data processing template when processing, thereby increasing the operation complexity and reducing the user experience. SUMMARY
[0004] The present application provides a data processing template generation, device, electronic equipment and storage medium, which realizes the creation of a corresponding data processing template according to the user's selection, and then different templates process batch data, thereby meeting the user's processing needs for batch data in different scenarios.
[0005] In a first aspect, the present application provides a data processing template generation method, comprising:
[0006] determining at least one to-be-applied template and corresponding template attributes, and at least one target data source, wherein the template attributes include operation permission attributes, system attributes, template name attributes and template number attributes;
[0007] extracting data field information from the target data source, and determining at least one target field information from the data field information;
[0008] configuring data import rules for the at least one target field information respectively;
[0009] determining a target data processing template matched with the at least one target data source based on the to-be-applied template, the template attributes, the target field information and the data import rules, so as to complete the processing of data according to the target data processing template when receiving data matched with the at least one target data source.
[0010] In a second aspect, the present application also provides a data processing template generation device, which comprises:
[0011] a to-be-applied template determination module configured to determine at least one to-be-applied template and corresponding template attributes, and at least one target data source, wherein the template attributes include operation permission attributes, system attributes, template name attributes and template number attributes;
[0012] a target field determination module, configured to extract data field information from the target data source, and determine at least one target field information from the data field information;
[0013] a rule configuration module, configured to configure a data import rule for the at least one target field information respectively;
[0014] a template generation module, configured to determine a target data processing template matched with the at least one target data source based on the to-be-applied template, the template attribute, the target field information and the data import rule.
[0015] In a third aspect, an electronic device is provided, and the device includes:
[0016] one or more processors;
[0017] a memory device configured to store one or more programs;
[0018] When the one or more programs are executed by the one or more processors, the one or more processors implement the data processing template generation method according to any of the embodiments of the present application.
[0019] In a fourth aspect, a computer readable storage medium is provided, and the computer readable storage medium stores a computer program, which, when executed by a processor, implements the data processing template generation method according to any of the embodiments of the present application.
[0020] The technical solution of the embodiments of the present application determines at least one to-be-applied template and corresponding template attribute, at least one target data source, extracts data field information from the target data source, and determines at least one target field information from the data field information, and then configures a data import rule for the at least one target field information respectively, and finally determines a target data processing template matched with the at least one target data source based on the to-be-applied template, the template attribute, the target field information and the data import rule. Based on the above technical solution, data is processed in batches through a data processing template, and the processing needs of users for batch data in different scenarios are met.
[0021] It should be understood that the content described in this section is not intended to identify key or important features of the embodiments of the present application, nor is it used to limit the scope of the present application. Other features of the present application will become apparent through the following description. BRIEF DESCRIPTION OF DRAWINGS
[0022] In order to make the technical solution in the embodiments of the present application clearer, the accompanying drawings needed in the description of the embodiments will be briefly introduced. Obviously, the accompanying drawings in the following description are only some embodiments of the present application, and other accompanying drawings can be obtained by those skilled in the art without any creative effort on the basis of the accompanying drawings.
[0023] Figure 1 is a flow diagram of a data processing template generation method provided by an embodiment of the present application;
[0024] Figure 2 is a flow diagram of a data processing template generation method provided by an embodiment of the present application;
[0025] Figure 3 is a structural block diagram of a data processing template generation device provided by an embodiment of the present application;
[0026] Figure 4 is a structural diagram of an electronic device provided by an embodiment of the present application. DETAILED DESCRIPTION
[0027] In order to make the technical solution in the embodiments of the present application clearer, the accompanying drawings needed in the description of the embodiments will be briefly introduced. Obviously, the accompanying drawings in the following description are only some embodiments of the present application, and other accompanying drawings can be obtained by those skilled in the art without any creative effort on the basis of the accompanying drawings.
[0028] It should be noted that the terms "first", "second", and the like in the specification and claims of the present application and the above-mentioned accompanying drawings are used to distinguish similar objects, and do not necessarily indicate a specific order or a chronological sequence. It should be understood that the data thus used can be interchanged under appropriate circumstances, so that the embodiments of the present application described herein can be implemented in an order other than that illustrated or described herein. In addition, the terms "include" and "have" and any variations thereof are intended to cover non-exclusive inclusion, for example, a process, method, system, product or device including a series of steps or units does not necessarily have to be limited to those steps or units clearly listed, but can include other steps or units not clearly listed or inherent to the process, method, product or device.
[0029] Embodiment one
[0030] Figure 1A flowchart of a data processing template generation method provided by an embodiment of the present application is shown. The embodiment can be applied to a case where a preset data template is used to batch process data in different data sources. The method can be integrated in an electronic device, which can be a PC or a server.
[0031] As shown in Figure 1 , the method comprises:
[0032] S110, determining at least one to-be-applied template and corresponding template attributes, and at least one target data source.
[0033] The template attributes include operation permission attributes, system attributes, template name attributes, and template number attributes. The to-be-applied template can be understood as a data processing template that needs to be configured. The template attributes can be attribute information corresponding to the to-be-applied template. The target data source can be understood as a database storing data. Users can store data in different databases according to different types of data, such as MySQL, Oracle, Sybase, and other types of databases. The operation permission attribute can be understood as the operation permission of the template on the data. For example, if the template needs to complete batch addition of data, the corresponding operation permission attribute should be set to batch addition. Correspondingly, if the template needs to complete batch modification of data, the corresponding operation permission attribute should be set to batch modification. The system attribute can be the system name to which the current template belongs. For example, if the current template is mainly responsible for batch adding data to the A system, the system attribute of the template should be set to the A system. The template name attribute can be understood as the template name set by the user. The user can customize the name of the template according to the needs. The template number attribute can be the number of the template. The number information can be freely set by the user or automatically generated according to a preset rule, for example, the corresponding number is assigned according to the creation order of the template.
[0034] Specifically, the user can determine at least one to-be-applied template and corresponding template attributes according to the needs. The user can set the corresponding template attributes when selecting the corresponding to-be-applied template, or the corresponding template attribute information can be automatically determined based on the to-be-applied template selected by the user. Further, the user can select at least one target data source according to the needs. It should be noted that the user can process data stored in different databases at the same time, so the user can select at least one database as the target data source.
[0035] Based on the above technical solution, determining at least one template to be applied and its corresponding template attributes, and at least one target data source includes: when a template selection control or data source selection control is detected to be triggered, displaying the corresponding template selection interface or data source selection interface to the target user, so as to determine the at least one template to be applied and its corresponding template attributes and the at least one target data source based on the operation in the selection interface.
[0036] The template selection control can be a functional control set on the interface. Users can select at least one template to be applied by triggering the template selection control. The corresponding data source selection control can be understood as a control used to trigger the data source selection function. The template selection interface can be an interface used to select the template to be applied, and correspondingly, the data source selection interface can be a selection interface used to select the target data source. The target user can be understood as the user who needs to create a template.
[0037] Specifically, users can issue a template selection command by triggering the template selection control. Based on this command, a corresponding template selection interface will pop up for the user. The user can then select at least one template to be applied from the template selection interface. After selecting a template, the user can issue a data source selection command by triggering the data source selection control. Based on this command, a corresponding data source selection interface will pop up for the user. At least one target data source will be determined based on the user's actions on the selection interface. It should be noted that the data source display interface shows multiple data sources for the user to choose from. The user can select one or more data sources as the target data source according to their needs.
[0038] S120, Extract data field information from the target data source, and determine at least one target field information from the data field information.
[0039] Here, data field information can be identifiers used to describe the characteristics of a data item. Target field information can be user-defined field information.
[0040] Specifically, the field information of the data is extracted from the target data source. Users can select the required field information from the field information as the target field information according to their needs. For example, users can select the field that needs to be processed as the target field information, and then only the information of the target field selected by the user is processed during data processing.
[0041] Based on the above technical solution, the step of extracting data field information from the target data source includes: matching the search term in the at least one target data source to determine the data form that matches the search term; and / or, when a triggering data form selection control is detected, displaying a data form selection interface to the target user, determining the data form based on the triggering operation in the data form selection interface; and extracting the data field information from the data form.
[0042] The search terms are the search terms entered by the target user. A data form can be understood as a data table stored in a data source. A data form selection control is a control used to trigger the data form selection function; the user can issue corresponding instructions by triggering this control. The data form selection interface is a selection interface displayed to the user based on the user's triggering operation of the data form selection control, where the user can select the data form.
[0043] Specifically, users can directly enter relevant search terms, which will then be matched against the target data source. The system will retrieve the corresponding data form based on the matching results. Alternatively, a data form selection interface can be displayed based on the user's interaction with the data form selection control. Users can then select the desired data form and extract its data fields. It's important to note that when a user searches using search terms, multiple search results may appear. Therefore, when multiple search results are present, a corresponding data form selection interface can be displayed for the user to choose from.
[0044] Based on the above technical solution, determining at least one target field information from the data field information includes: determining the field information corresponding to the triggering operation based on the triggering operation of the target user, and using it as the target field information.
[0045] The triggering action can be a click operation by the target user on any data field.
[0046] Specifically, after extracting data field information from the data form, all data field information can be displayed to the user on the interface. The user can trigger any data field, and the corresponding target field information is determined based on the user's trigger action. Furthermore, the user can select multiple data fields as target fields. For example, all extracted field information can be displayed on the left side of the interface. When the user triggers any data field, the field information corresponding to the trigger action will be displayed on the right side of the page. After the user completes the selection, the field information on the right side of the interface will be used as the target field information.
[0047] Based on the above technical solution, after determining at least one target field information from the data field information, the method further includes: determining annotation information associated with the target field information, so as to annotate the target field information based on the annotation information, wherein the annotation information includes name information, remarks information, and filling status information.
[0048] The annotation information can be an explanation and description of the field's function. The name information can be understood as the name information corresponding to the target field. It should be noted that field information is a field identifier used to describe the characteristics of the data. To facilitate user understanding, its name information can be set to easily understandable information, for example, setting the name information of the "name" field to "Name". The remarks information can be prompts for the target field, or instructions on data entry rules, such as the length threshold for the entered data. The entry status information can be understood as the entry status of the data corresponding to the target field information, used to indicate whether the data is required.
[0049] Specifically, after determining the target field information, in order to facilitate data import and processing, users can set corresponding annotation information for the target field information, and then provide prompts when processing the data based on the annotation information.
[0050] S130. Configure data import rules for each of the at least one target field information.
[0051] Data import rules can be rules used to standardize data import methods. For example, data import rules include: format rules, such as requiring the field content to meet IPV4 format; date rules, requiring the field to meet a certain date format rule; regular expressions, requiring the field to meet a certain regular expression; fixed default values, where the field will be filled with a fixed default value; conditional default values, where a default value is filled into the field after a certain condition is met. Fixed structured query language, dynamic structured query language, field association restrictions, etc.
[0052] Specifically, users can configure corresponding data import rules for at least one target field according to their needs, and then process the data based on the set data import rules when processing the data based on the template.
[0053] Based on the above technical solution, configuring data import rules for the at least one target field information includes: when a data import rule setting control is triggered, displaying a data import rule setting interface corresponding to the at least one target field information to the target user, so as to configure data import rules for the at least one target field information based on the data import rule selected by the target user in the data import rule setting interface.
[0054] The import rule setting control can be a control that triggers the data import rule configuration function. Correspondingly, the data import rule setting interface can be an interface displayed to the user for configuring data import rules after the user triggers the data import rule setting control.
[0055] Specifically, the system can display the corresponding data import rule setting interface to the user based on the user's trigger action on the data import rule setting control. The user can select the desired data import rule in the data import rule setting interface and set it as the data import rule for the target field. It should be noted that a user can configure multiple data import rules for a single target field. For target fields with multiple configured data import rules, all data import rules must be satisfied simultaneously during data processing. Correspondingly, a user can configure corresponding data import rules for multiple target fields simultaneously.
[0056] Based on the above technical solution, after configuring data import rules for the at least one target field information, the method further includes: determining display rule information corresponding to the at least one target field information, so as to display the data corresponding to the at least one target field information according to the display rule information.
[0057] The display rule information includes at least one of display status information and search status information. Display rule information can be rule information used to indicate how the data corresponding to the target field is displayed. Display status information can be understood as information indicating whether the data corresponding to the target field is displayed. Search status information can be used to indicate whether the data information corresponding to the target field can be searched.
[0058] Specifically, after configuring the import rules, users can configure the display rules for the target field according to their needs, and then control the display method of the data corresponding to the target field based on the display rules. For example, if the data corresponding to field A is encrypted and not publicly displayed, and cannot be searched, then the display status of field A can be adjusted to hidden, and the search status of field A can be adjusted to unsearchable.
[0059] S140. Based on the template to be applied, the template attributes, the target field information, and the data import rules, determine a target data processing template that matches the at least one target data source.
[0060] The target data processing template can be a data processing template created based on information selected by the user.
[0061] Specifically, based on the template to be applied selected by the user and the corresponding template attributes, as well as the data import rules set by the user for the target field information, a target data processing template that matches at least one target data source can be determined. Based on this target data processing template, when data corresponding to the target data source is received, the target data processing template can be retrieved to perform batch processing of the data.
[0062] The technical solution of this invention determines at least one template to be applied and its corresponding template attributes, and at least one target data source. It extracts data field information from the target data source and determines at least one target field from the data field information. Data import rules can then be configured for each of the at least one target field. Finally, a target data processing template matching the at least one target data source is determined based on the template to be applied, the template attributes, the target field information, and the data import rules. Based on this technical solution, corresponding data processing templates can be created based on user selections. Data can then be processed in batches by calling the data processing templates, meeting users' needs for processing batch data in different scenarios.
[0063] Example 2
[0064] Figure 2 This is a flowchart illustrating a data processing template generation method provided in this embodiment of the invention. This embodiment further refines the implementation process of the data processing template generation method based on the above examples. For specific implementation details, please refer to the technical solution of this embodiment. Technical terms that are the same as or corresponding to those in the above embodiments will not be repeated here.
[0065] like Figure 2 As shown, the method includes:
[0066] Define a batch data processing template: Define the template name, the system to which the template belongs (optional), the template type, and the template number (which can be automatically generated based on rules).
[0067] Specifically, the template type can be the data processing type, such as batch addition, batch modification, or batch deletion of data. It should be noted that since data deletion is often an irreversible operation, it is usually performed through logical modification of the data's status bits in a batch process—that is, deletion at a non-physical level. Furthermore, the template number can be generated according to a preset method.
[0068] Specify data source: Specifically, you can select from a list of pre-configured data sources.
[0069] Specify the data form or view: Specifically, it can be that the user selects from the data source, or it can be that the user searches for the corresponding data form or view based on the search terms entered by the user.
[0070] Select the required fields and specify the primary key: Specifically, after extracting the relevant field information from the data form, specify the corresponding primary key. It can be understood that the primary key can be understood as the judgment condition information when processing data. For example, the data can be judged based on the format or size of the data corresponding to the primary key field to determine whether the data meets the import conditions. Data can be imported only after the import conditions are met.
[0071] Fill in and configure the fields in the template to display relevant information: Specifically, the relevant information can be user-defined notes, such as: field aliases can be column names in the Excel template provided to the user for easy understanding; field notes can be comments in the Excel template provided to the user to remind the user of the requirements for the content of the fields to be filled in, whether they are required, etc.
[0072] Configure data import rules: Specifically, based on the selected field, select and configure the data import rules for that field. It should be noted that multiple rules can be configured for the same field. For example, the rules for the `name` field may include: regular expressions, field restrictions, variable types, etc. Understandably, data import rules can include, but are not limited to: format rules, date rules (requiring the field to meet a declared date format rule), regular expressions (requiring the field to meet a declared regular expression rule), fixed default values (the field will be filled with a fixed default value by default, or specified keywords such as `USERID`, `USERNAME`, `USERORG`, etc.), conditional default values (when a certain condition is met (e.g., a column of data in a row equals 0), arrays (requiring the field to meet values within the declared array range), and fixed SQL (Structured Query Language): the SQL query result must be a single column of values. This field must meet the value range specified in the SQL query results. SQL query conditions can reference system-specified keywords, such as: [USERID], [USERNAME], [USERORG], etc. Dynamic SQL: The SQL query result must be a single column of values. This field must meet the value range specified in the SQL query results. SQL query conditions can reference data from a specific column in the template. Dynamic control over data entry and field association restrictions: When a certain condition is met, only certain values can be entered into this field. It should be noted that users can also set other data import rules according to their needs.
[0073] Configure template import display rules; specifically, based on the selected field, configure whether to display it in the Excel template. For field A, you can adjust the status bit. Fields controlled by fixed or conditional default values do not need to be displayed. Alternatively, you can configure whether field A is searchable in the import interface, etc.
[0074] Invoking Templates: Specifically, after completing the template configuration, each system application can configure the template number to import and invoke the service according to the actual scenario.
[0075] The technical solution of this invention determines at least one template to be applied and its corresponding template attributes, and at least one target data source. It extracts data field information from the target data source and determines at least one target field from the data field information. Data import rules can then be configured for each of the at least one target field. Finally, a target data processing template matching the at least one target data source is determined based on the template to be applied, the template attributes, the target field information, and the data import rules. Based on this technical solution, corresponding data processing templates can be created based on user selections. Data can then be processed in batches by calling the data processing templates, meeting users' needs for processing batch data in different scenarios.
[0076] Example 3
[0077] Figure 3 This invention provides a data processing template generation device. The device includes: a template determination module 310, a target field determination module 320, a rule configuration module 330, and a template generation module 340.
[0078] The template determination module 310 is used to determine at least one template to be applied and its corresponding template attributes, and at least one target data source, wherein the template attributes include operation permission attributes, system attributes, template name attributes, and template number attributes.
[0079] The target field determination module 320 is used to extract data field information from the target data source and determine at least one target field information from the data field information;
[0080] The rule configuration module 330 is used to configure data import rules for the at least one target field information respectively;
[0081] The template generation module 340 is used to determine a target data processing template that matches the at least one target data source based on the template to be applied, the template attributes, the target field information, and the data import rules.
[0082] Based on the above technical solution, the template to be applied determination module is specifically used to: when a template selection control or a data source selection control is detected to be triggered, display the corresponding template selection interface or data source selection interface to the target user, so as to determine the at least one template to be applied, the corresponding template attributes, and the at least one target data source based on the operation in the selection interface.
[0083] Based on the above technical solution, the target field determination module further includes:
[0084] A matching unit is configured to perform a match based on a search term in the at least one target data source to determine a data form that matches the search term; and / or, when a triggering data form selection control is detected, to display a data form selection interface to a target user, and to determine the data form based on the triggering operation in the data form selection interface.
[0085] The field information extraction unit is used to extract the data field information from the data form, wherein the search term is the search term entered by the target user.
[0086] Based on the above technical solution, the target field determination module further includes:
[0087] The target field information determination unit is used to determine the field information corresponding to the triggering operation based on the triggering operation of the target user, and use it as the target field information.
[0088] Based on the above technical solution, the device further includes:
[0089] The annotation information configuration module is used to determine annotation information associated with the target field information after determining at least one target field information from the data field information, so as to annotate the target field information based on the display related information, wherein the annotation information includes name information, remarks information, and filling status information.
[0090] Based on the above technical solution, the rule configuration module is specifically used to: when the triggering of the data import rule setting control is detected, display a data import rule setting interface corresponding to the at least one target field information to the target user, so as to configure data import rules for the at least one target field information based on the data import rule selected by the target user in the data import rule setting interface.
[0091] Based on the above technical solution, the rule configuration module further includes:
[0092] The display rule configuration unit is used to determine display rule information corresponding to the at least one target field information after configuring data import rules for each of the at least one target field information, so as to display the data corresponding to the at least one target field information according to the display rule information, wherein the display rule information includes at least one of display status information and search status information.
[0093] The technical solution of this invention determines at least one template to be applied and its corresponding template attributes, and at least one target data source. It extracts data field information from the target data source and determines at least one target field from the data field information. Data import rules can then be configured for each of the at least one target field. Finally, a target data processing template matching the at least one target data source is determined based on the template to be applied, the template attributes, the target field information, and the data import rules. Based on this technical solution, corresponding data processing templates can be created based on user selections. Data can then be processed in batches by calling the data processing templates, meeting users' needs for processing batch data in different scenarios.
[0094] The data processing template generation device provided in this embodiment of the invention can execute the data processing template generation method provided in any embodiment of the invention, and has the corresponding functional modules and beneficial effects of the method.
[0095] It is worth noting that the various units and modules included in the above-mentioned device are only divided according to functional logic, but are not limited to the above division, as long as the corresponding functions can be realized; in addition, the specific names of each functional unit are only for easy differentiation and are not used to limit the protection scope of the embodiments of the present invention.
[0096] Example 4
[0097] Figure 4 A schematic diagram of an electronic device 10 that can be used to implement embodiments of the present invention is shown. The electronic device is intended to represent various forms of digital computers, such as laptop computers, desktop computers, workstations, personal digital assistants, servers, blade servers, mainframe computers, and other suitable computers. The electronic device can also represent various forms of mobile devices, such as personal digital processors, cellular phones, smartphones, wearable devices (e.g., helmets, glasses, watches, etc.), and other similar computing devices. The components shown herein, their connections and relationships, and their functions are merely illustrative and are not intended to limit the implementation of the invention described and / or claimed herein.
[0098] like Figure 4As shown, the electronic device 10 includes at least one processor 11 and a memory, such as a read-only memory (ROM) 12 or a random access memory (RAM) 13, communicatively connected to the at least one processor 11. The memory stores computer programs executable by the at least one processor. The processor 11 can perform various appropriate actions and processes based on the computer program stored in the ROM 12 or loaded from storage unit 18 into the RAM 13. The RAM 13 may also store various programs and data required for the operation of the electronic device 10. The processor 11, ROM 12, and RAM 13 are interconnected via a bus 14. An input / output (I / O) interface 15 is also connected to the bus 14.
[0099] Multiple components in electronic device 10 are connected to I / O interface 15, including: input unit 16, such as keyboard, mouse, etc.; output unit 17, such as various types of displays, speakers, etc.; storage unit 18, such as disk, optical disk, etc.; and communication unit 19, such as network card, modem, wireless transceiver, etc. Communication unit 19 allows electronic device 10 to exchange information / data with other devices through computer networks such as the Internet and / or various telecommunications networks.
[0100] Processor 11 can be a variety of general-purpose and / or special-purpose processing components with processing and computing capabilities. Some examples of processor 11 include, but are not limited to, a central processing unit (CPU), a graphics processing unit (GPU), various special-purpose artificial intelligence (AI) computing chips, various processors running machine learning model algorithms, a digital signal processor (DSP), and any suitable processor, controller, microcontroller, etc. Processor 11 performs the various methods and processes described above, such as the data processing template generation method.
[0101] In some embodiments, the data processing template generation method may be implemented as a computer program tangibly contained in a computer-readable storage medium, such as storage unit 18. In some embodiments, part or all of the computer program may be loaded and / or installed on electronic device 10 via ROM 12 and / or communication unit 19. When the computer program is loaded into RAM 13 and executed by processor 11, one or more steps of the data processing template generation method described above may be performed. Alternatively, in other embodiments, processor 11 may be configured to perform the data processing template generation method by any other suitable means (e.g., by means of firmware).
[0102] Various embodiments of the systems and techniques described above herein can be implemented in digital electronic circuit systems, integrated circuit systems, field-programmable gate arrays (FPGAs), application-specific integrated circuits (ASICs), application-specific standard products (ASSPs), systems-on-a-chip (SoCs), payload-programmable logic devices (CPLDs), computer hardware, firmware, software, and / or combinations thereof. These various embodiments may include implementations in one or more computer programs that can be executed and / or interpreted on a programmable system including at least one programmable processor, which may be a dedicated or general-purpose programmable processor, capable of receiving data and instructions from a storage system, at least one input device, and at least one output device, and transmitting data and instructions to the storage system, the at least one input device, and the at least one output device.
[0103] Computer programs used to implement the methods of the present invention may be written in any combination of one or more programming languages. These computer programs may be provided to a processor of a general-purpose computer, a special-purpose computer, or other programmable data processing device, such that when executed by the processor, the computer programs cause the functions / operations specified in the flowcharts and / or block diagrams to be performed. The computer programs may be executed entirely on a machine, partially on a machine, or as a standalone software package, partially on a machine and partially on a remote machine, or entirely on a remote machine or server.
[0104] In the context of this invention, a computer-readable storage medium can be a tangible medium that may contain or store a computer program for use by or in conjunction with an instruction execution system, apparatus, or device. A computer-readable storage medium may include, but is not limited to, electronic, magnetic, optical, electromagnetic, infrared, or semiconductor systems, apparatus, or devices, or any suitable combination thereof. Alternatively, a computer-readable storage medium may be a machine-readable signal medium. More specific examples of machine-readable storage media include electrical connections based on one or more wires, portable computer disks, hard disks, random access memory (RAM), read-only memory (ROM), erasable programmable read-only memory (EPROM or flash memory), optical fibers, portable compact disk read-only memory (CD-ROM), optical storage devices, magnetic storage devices, or any suitable combination thereof.
[0105] To provide interaction with a user, the systems and techniques described herein can be implemented on an electronic device having: a display device (e.g., a CRT (cathode ray tube) or LCD (liquid crystal display) monitor) for displaying information to the user; and a keyboard and pointing device (e.g., a mouse or trackball) through which the user provides input to the electronic device. Other types of devices can also be used to provide interaction with the user; for example, feedback provided to the user can be any form of sensory feedback (e.g., visual feedback, auditory feedback, or tactile feedback); and input from the user can be received in any form (including sound input, voice input, or tactile input).
[0106] The systems and technologies described herein can be implemented in computing systems that include backend components (e.g., as data servers), or computing systems that include middleware components (e.g., application servers), or computing systems that include frontend components (e.g., user computers with graphical user interfaces or web browsers through which users can interact with implementations of the systems and technologies described herein), or any combination of such backend, middleware, or frontend components. The components of the system can be interconnected via digital data communication of any form or medium (e.g., communication networks). Examples of communication networks include local area networks (LANs), wide area networks (WANs), blockchain networks, and the Internet.
[0107] Computer systems can include clients and servers. Clients and servers are generally located far apart and typically interact through communication networks. The client-server relationship is created by computer programs running on the respective computers and having a client-server relationship with each other. The server can be a cloud server, also known as a cloud computing server or cloud host, which is a hosting product within the cloud computing service system to address the shortcomings of traditional physical hosts and VPS services, such as high management difficulty and weak business scalability.
[0108] It should be understood that the various forms of processes shown above can be used, with steps reordered, added, or deleted. For example, the steps described in this invention can be executed in parallel, sequentially, or in different orders, as long as the desired result of the technical solution of this invention can be achieved, and this is not limited herein.
[0109] The specific embodiments described above do not constitute a limitation on the scope of protection of this invention. Those skilled in the art should understand that various modifications, combinations, sub-combinations, and substitutions can be made according to design requirements and other factors. Any modifications, equivalent substitutions, and improvements made within the spirit and principles of this invention should be included within the scope of protection of this invention.
Claims
1. A method of generating a data processing template, characterized by, The method comprises: determining at least one to-be-applied template and corresponding template attributes, and at least one target data source, wherein the template attributes comprise operation permission attributes, system attributes, template name attributes, and template number attributes; the system attributes are system names to which a current template belongs; extracting data field information from the target data source, and determining at least one target field information from the data field information; respectively configuring data import rules for the at least one target field information; determining a target data processing template matched with the at least one target data source based on the to-be-applied template, the template attributes, the target field information, and the data import rules; after respectively configuring the data import rules for the at least one target field information, the method further comprises: determining display rule information corresponding to the at least one target field information, to display data corresponding to the at least one target field information according to the display rule information, wherein the display rule information comprises at least one of display state information and search state information.
2. The method of claim 1, wherein, The determining at least one to-be-applied template and corresponding template attributes, and at least one target data source comprises: when detecting that a template selection control or a data source selection control is triggered, displaying a corresponding template selection interface or a data source selection interface for a target user, to determine the at least one to-be-applied template and corresponding template attributes and the at least one target data source based on an operation in the selection interface.
3. The method of claim 1, wherein, The extracting data field information from the target data source comprises: performing matching in the at least one target data source based on a search word, to determine a data form matched with the search word; and / or, when detecting that a data form selection control is triggered, displaying a data form selection interface for a target user, to determine the data form based on a triggering operation in the data form selection interface; extracting the data field information from the data form, wherein the search word is a search word input by the target user.
4. The method of claim 3, wherein, The determining at least one target field information from the data field information comprises: determining field information corresponding to a triggering operation of the target user according to the triggering operation, and taking the field information as the target field information.
5. The method of claim 1, wherein, After the determining at least one target field information from the data field information, the method further comprises: determining annotation information associated with the target field information, to annotate the target field information based on display-related information, wherein the annotation information comprises name information, note information, and filling state information.
6. The method of claim 1, wherein, The respectively configuring data import rules for the at least one target field information comprises: when detecting that a data import rule setting control is triggered, displaying a data import rule setting interface corresponding to the at least one target field information for a target user, to respectively configure data import rules for the at least one target field information based on data import rules selected by the target user in the data import rule setting interface.
7. A data processing apparatus, characterized by The method comprises: The template to be applied determination module is configured to determine at least one template to be applied and corresponding template attributes, and at least one target data source, wherein the template attributes include operation permission attributes, system attributes, template name attributes, and template number attributes; the system attributes are system names to which a current template belongs; The target field determination module is configured to extract data field information from the target data source, and determine at least one target field information from the data field information; The rule configuration module is configured to respectively configure data import rules for the at least one target field information; The template generation module is configured to determine a target data processing template matched with the at least one target data source based on the template to be applied, the template attributes, the target field information, and the data import rules; The rule configuration module further includes: The display rule configuration unit is configured to, after respectively configuring the data import rules for the at least one target field information, determine display rule information corresponding to the at least one target field information, so as to display data corresponding to the at least one target field information according to the display rule information, wherein the display rule information includes at least one of display state information and search state information.
8. An electronic device, comprising: The electronic device includes: One or more processors; and A memory connected in communication with the at least one processor; wherein The memory stores a computer program executable by the at least one processor, and the computer program is executed by the at least one processor to enable the at least one processor to execute the data processing template generation method in any one of claims 1-6.
9. A computer-readable storage medium, characterized in that, The computer readable storage medium stores computer instructions, and the computer instructions are used to enable the processor to execute the data processing template generation method in any one of claims 1-6 when executed.
Citation Information
Patent Citations
Excel form template generation method and device
CN111767704A