CN112015764A - Data processing method and device of business system, electronic equipment and storage medium - Google Patents

Data processing method and device of business system, electronic equipment and storage medium Download PDF

Info

Publication number
CN112015764A
CN112015764A CN202010814283.9A CN202010814283A CN112015764A CN 112015764 A CN112015764 A CN 112015764A CN 202010814283 A CN202010814283 A CN 202010814283A CN 112015764 A CN112015764 A CN 112015764A
Authority
CN
China
Prior art keywords
data
rule
business system
rules
data item
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN202010814283.9A
Other languages
Chinese (zh)
Inventor
郑志翔
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Renlijia Network Technology Hangzhou Co ltd
Original Assignee
Renlijia Network Technology Hangzhou Co ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Renlijia Network Technology Hangzhou Co ltd filed Critical Renlijia Network Technology Hangzhou Co ltd
Priority to CN202010814283.9A priority Critical patent/CN112015764A/en
Publication of CN112015764A publication Critical patent/CN112015764A/en
Pending legal-status Critical Current

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/245Query processing
    • G06F16/2455Query execution
    • G06F16/24564Applying rules; Deductive queries
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q10/00Administration; Management
    • G06Q10/10Office automation; Time management
    • G06Q10/105Human resources

Landscapes

  • Engineering & Computer Science (AREA)
  • Business, Economics & Management (AREA)
  • Human Resources & Organizations (AREA)
  • Theoretical Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • Strategic Management (AREA)
  • General Physics & Mathematics (AREA)
  • Entrepreneurship & Innovation (AREA)
  • Data Mining & Analysis (AREA)
  • Computational Linguistics (AREA)
  • Databases & Information Systems (AREA)
  • General Engineering & Computer Science (AREA)
  • Economics (AREA)
  • Marketing (AREA)
  • Operations Research (AREA)
  • Quality & Reliability (AREA)
  • Tourism & Hospitality (AREA)
  • General Business, Economics & Management (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

The invention discloses a data processing method and device of a business system, electronic equipment and a storage medium. The method comprises the following steps: acquiring a form to be imported, and identifying the data rule of each field from the configuration information of the form to be imported; and configuring corresponding data rules for the data items corresponding to the fields in the business system so as to process the data of the data items by using the data rules. The configuration information of the form is converted into the data rules, the data content and the data rules of the form are seamlessly and intelligently migrated to the system, the data rules of the system do not need to be manually configured, errors caused by the data rules of the data items manually configured are avoided, the operation of data rule configuration is simplified, and the user experience can be greatly improved.

Description

Data processing method and device of business system, electronic equipment and storage medium
Technical Field
The present invention relates to the field of data processing technologies, and in particular, to a data processing method and apparatus for a business system, an electronic device, and a storage medium.
Background
With the gradual maturity of the human resource management system, more and more enterprise employee data are migrated from the traditional manual online management, including performance statistics, salary calculation, personal tax calculation, etc., to the human resource management system to realize online automatic management. Before the human resource management system is used online, offline historical data needs to be synchronized into the human resource management system, and data import and data rule migration are involved in the process. At present, migration of data rules can only be manually configured, for example, manually setting operation formulas of various payroll items in a payroll one by one, which is low in efficiency and easy to make mistakes.
Disclosure of Invention
The invention provides a data processing method and device of a business system, electronic equipment and a storage medium, which can automatically configure corresponding data rules for data items of the system when online form data are migrated to the online.
Specifically, the invention is realized by the following technical scheme:
in a first aspect, a data processing method of a service system is provided, including:
acquiring a form to be imported, and identifying the data rule of each field from the configuration information of the form to be imported;
and configuring corresponding data rules for the data items corresponding to the fields in the business system so as to process the data of the data items by using the data rules.
Optionally, configuring a corresponding data rule for a data item corresponding to each field in the service system, including:
determining at least one field related to the data item according to the field identification of the field and the mapping relation between the field identification and the data item;
configuring the data rule of the at least one field as the data rule of the data item.
Optionally, the data rule comprises a data acquisition rule;
configuring the data rule for the data item includes:
and adding the data acquisition rule for the data item to acquire the target data of the data item according to the data acquisition rule.
Optionally, the data rule comprises an operation rule;
configuring the data rule for the data item, including:
and adding the operation rule to the data item so as to process the target data of the data item according to the operation rule.
Optionally, the method further comprises:
in response to a rule modification instruction, modifying a data rule of the data item in accordance with the rule modification instruction.
Optionally, the method further comprises:
obtaining input data entered for the data item;
and processing the input data according to the data rule of the data item.
In a second aspect, a data processing apparatus of a business system is provided, including:
the acquisition module is used for acquiring a form to be imported and identifying the data rule of each field from the configuration information of the form to be imported;
and the rule configuration module is used for configuring corresponding data rules for the data items corresponding to the fields in the business system so as to process the data of the data items by using the data rules.
Optionally, the rule configuration module includes:
the determining unit is used for determining at least one field related to the data item according to the field identification of the field and the mapping relation between the field identification and the data item;
a configuration unit, configured to configure the data rule of the at least one field as the data rule of the data item.
Optionally, the data rule comprises a data acquisition rule;
the rule configuration module comprises:
and the configuration unit is used for adding the data acquisition rule for the data item so as to acquire the target data of the data item according to the data acquisition rule.
Optionally, the data rule comprises an operation rule;
the rule configuration module comprises:
and the configuration unit is used for adding the operation rule for the data item so as to process the target data of the data item according to the operation rule.
Optionally, the system further comprises:
and the modification module responds to a rule modification instruction and modifies the data rule of the data item according to the rule modification instruction.
Optionally, the system further comprises:
the acquisition module is further used for acquiring input data input aiming at the data item;
and the data processing module is used for processing the input data according to the data rule of the data item.
In a third aspect, an electronic device is provided, which includes a memory, a processor, and a computer program stored in the memory and executable on the processor, and when the processor executes the computer program, the electronic device implements the data processing method of the business system according to any one of the above descriptions.
In a fourth aspect, a computer-readable storage medium is provided, on which a computer program is stored, which computer program, when being executed by a processor, realizes the steps of the data processing method of the business system of any one of the above.
The technical scheme provided by the embodiment of the invention can have the following beneficial effects:
in the embodiment of the invention, the configuration information of the table can be converted into the data rule, the seamless and intelligent migration of the data content and the data rule of the table to the system is realized, the data rule of the service system does not need to be manually configured, the error caused by the data rule of the manually configured data item is avoided, the operation of the data rule configuration is simplified, and the user experience can be greatly improved.
It is to be understood that both the foregoing general description and the following detailed description are exemplary and explanatory only and are not restrictive of the invention, as claimed.
Drawings
The accompanying drawings, which are incorporated in and constitute a part of this specification, illustrate embodiments consistent with the invention and together with the description, serve to explain the principles of the invention.
Fig. 1 is a flowchart illustrating a data processing method of a business system according to an exemplary embodiment of the present invention;
FIG. 2 is a diagram illustrating a user interface for form import for a business system in accordance with an illustrative embodiment of the present invention;
FIG. 3 is a block diagram illustrating a data processing apparatus of a business system in accordance with an exemplary embodiment of the present invention;
fig. 4 is a schematic structural diagram of an electronic device according to an exemplary embodiment of the present invention.
Detailed Description
Reference will now be made in detail to the exemplary embodiments, examples of which are illustrated in the accompanying drawings. When the following description refers to the accompanying drawings, like numbers in different drawings represent the same or similar elements unless otherwise indicated. The embodiments described in the following exemplary embodiments do not represent all embodiments consistent with the present invention. Rather, they are merely examples of apparatus and methods consistent with certain aspects of the invention, as detailed in the appended claims.
The terminology used herein is for the purpose of describing particular embodiments only and is not intended to be limiting of the invention. As used in this specification and the appended claims, the singular forms "a", "an", and "the" are intended to include the plural forms as well, unless the context clearly indicates otherwise. It should also be understood that the term "and/or" as used herein refers to and encompasses any and all possible combinations of one or more of the associated listed items.
It is to be understood that although the terms first, second, third, etc. may be used herein to describe various information, these information should not be limited to these terms. These terms are only used to distinguish one type of information from another. For example, first information may also be referred to as second information, and similarly, second information may also be referred to as first information, without departing from the scope of the present invention. The word "if" as used herein may be interpreted as "at … …" or "when … …" or "in response to a determination", depending on the context.
With the gradual maturity of human resource management systems (business systems), more and more enterprise employee data are migrated from traditional manual offline management, including performance statistics, salary calculation, personal tax calculation, etc., to business systems to realize online automatic management. Before the business system is used online, offline historical data needs to be synchronized into the business system, and the process involves importing data and migrating data rules. At present, migration of data rules can only be manually configured, for example, manually setting operation formulas of various payroll items in a payroll one by one, which is low in efficiency and easy to make mistakes.
Based on the above situation, embodiments of the present invention provide a data processing method for a business system, which can convert configuration information of a table into a data rule, and implement seamless and intelligent migration of contents (data and rules) of the table to a system without manually configuring data rules of the system.
Fig. 1 is a flowchart illustrating a data processing method of a business system according to an exemplary embodiment of the present invention, which may include the following steps:
step 101, obtaining a form to be imported, and identifying data rules of each field from configuration information of the form to be imported.
The form to be imported, that is, the form of the business system uploaded by the user and requiring data synchronization to the business system, may be an Excel (office software) form, or a form inserted in Word (office software).
The business system can provide a mode of selecting and uploading designated files and a mode of dragging files to upload the tables to be imported to the business system, and a user can select one mode to upload the tables to be imported to the business system, so that the lower tables are automatically imported to the online business system when offline data are transferred to the online, the data import efficiency can be improved, errors generated when data are manually input are avoided, and the data import accuracy is improved. The file format that the business system supports import can be but is not limited to a file with a file extension name of 'xls', a file with a file extension name of 'xlsx', a file with a file extension name of 'doc', a file with a file extension name of 'zip', and the like.
The configuration information of the table is generally information configured by the user for the table according to actual requirements, and may include, but is not limited to, a field name of a field, a higher-level header of the field, a field number, a data format of the field, a data type of the field, a data source of the field, an association relationship with other fields, a configured operation formula, and the like.
The data rules may include, but are not limited to, data acquisition rules, operation rules, and the like. The data rules may be determined directly from the configuration information or may be generalized based on the configuration rules. For example, if a user sets an operation formula for a field, the operation formula may be determined as a data rule of the field; if an operation formula is not set in a certain field, but a data type is set, for example, the data type of the field specifying the number of attendance days is integer, the function int () may be determined as the data rule of the field.
And 102, configuring corresponding data rules for the data items corresponding to the fields in the business system.
The business system is implemented on line of off-line forms, a user can design a plurality of data items in the business system, the data items correspond to the fields of the forms, and data rules are configured for the data items, namely, the data rules of the fields corresponding to the data items are added to the data items.
For example, table 1 illustrates an exemplary embodiment of the present invention showing a staff pay report.
TABLE 1
Serial number Name (I) Job title Number of days on attendance Number of days on attendance Attendance rate Payroll
1 Zhang three Finance manager 22 22 100% 10000
2 Li four Sponsoring accountant 22 22 100% 8000
3 Wangwu tea Accountant 22 22 100% 6500
4 Zhao liu xi Accountant 22 20 88.5% 5900
Fig. 2 is a schematic diagram of a user interface for table import of a business system according to an exemplary embodiment of the present invention, and after table 1 is uploaded to the business system, referring to fig. 2, data contents of table 1 may be displayed in a table display area of the user interface. The user interface may further provide a table content distinguishing function, and referring to fig. 2, the user may determine which row or rows in table 1 correspond to fields of the table and which row or rows correspond to data contents of the table through selection of the row number in the function display area of the user interface.
Before adding a data rule to a data item, a corresponding relationship between a field and the data item needs to be determined, and in one embodiment, the corresponding relationship may be determined according to a field identifier of the field and a mapping relationship between the field identifier and the data item, specifically, a field related to the data item is determined according to a field identifier of the field and a predefined mapping relationship between the field identifier and the data item, and the data rule of the field is configured as a data rule of the data item. Wherein the field identification may be, but is not limited to, a field name.
In this embodiment, according to the user requirement and the pre-analysis of the table to be imported in the previous period, the mapping relationship between the fields and the data items in the table to be imported may be established in advance. Specifically, the mapping relationship between each row or each column in the table to be imported and the data item of the service system may be predefined. For example, referring to table 2, a mapping relationship between "serial number" and "serial number" of a first column record in the table to be imported, a mapping relationship between "job" and "job" of a second column record in the table to be imported, a mapping relationship between "name" and "name" of a data item recorded in a third column record in the table to be imported, a mapping relationship between "attendance days" and "attendance days" of a data item recorded in a fourth column record in the table to be imported, a mapping relationship between "attendance days" and "attendance days" of a data item recorded in a fifth column record in the table to be imported, a mapping relationship between "attendance rate" and "attendance rate" of a data item recorded in a sixth column record in the table to be imported, and a mapping relationship between "due salary" and "actual salary" of a data item recorded in a seventh column record in the table to be imported may be established in advance, so that after importing the table is completed, direct operation on data may be implemented in a business system, for example, the operation of users is greatly facilitated by summarizing, inquiring, analyzing, exporting or printing according to a certain screening condition.
TABLE 2
Field identification Data item
Serial number Numbering
Name (I) Name (I)
Job title Job title
Number of days on attendance Number of days on attendance
Number of days on attendance Number of days of card punching
Attendance rate Attendance rate
Payroll Real wage
The mapping relationship shown in table 2 may be predefined by the user, or may be created after the table is imported into the service system. When a user uploads a table to be imported, a row of behavior data items is designated, and the system can create salary items with the same name according to all header fields of the designated row, for example, referring to fig. 2, if the user selects the 2 nd row in the table display area as a data item, the data items with corresponding names can be automatically created according to the content of each cell in the second row, and a mapping relationship between the two items is established.
It should be noted that the mapping relationship between the fields and the data items is not limited to the one-to-one relationship shown in table 1, and may be a one-to-many relationship or a many-to-one relationship. The name of the data item may or may not be the same as the field identification.
In determining the data rules for the various fields, the business system may, but is not limited to, traverse each cell in the table in a top-to-bottom left-to-right order to identify the data rules for the fields based on the configuration information for each cell.
In one embodiment, if the data rule of the field includes a data acquisition rule, the data acquisition rule is added to the data item, so that the data item acquires the target data according to the data acquisition rule. The data acquisition rule includes a data source, a data acquisition time, and the like.
If the data source of the fields "name", "department", "job number", "job position", "time of job entry", "last working day", "employee type", "employee status", "correction date", "office place", "mail box", "trial period", "post position job level" and "first time working time" is determined to be the personnel roster according to the configuration information of the table, then a data rule is added to the data item corresponding to each of the above fields: data was obtained from a roster of personnel flowers.
If the data source of the field 'basic wage' and 'post subsidy' is determined to be a wage archive report according to the configuration information of the table, adding data rules for the data items corresponding to the fields: data is obtained from the payroll archive.
If the fields "number of days on duty", "number of times of card replenishment", "number of days on duty", "number of days of rest", "working hours", "number of times of late arrival", "length of late arrival", "number of times of severe late arrival", "number of days on time of absence from work", "number of times of early departure", "length of early departure", "number of times of absence from card on work", "number of times on time of absence from work", "number of days on time of absence from work", "length of time on time of absence from work", "are determined according to the configuration information of the table, the data source of "length of time of going out", "number of days of vacation", "number of days of parity", "number of days of holiday", "number of days of vacation", "working day overtime", "holiday overtime" is a nail attendance report, and then data rules are added to the data items corresponding to the above fields: and acquiring data from the nail attendance report.
If the fields "social insurance personal part total", "public deposit personal part total", "medical insurance personal part", "endowment insurance personal part", "unemployed insurance personal part", "social insurance enterprise part total", "public deposit enterprise part total", "endowment insurance enterprise part", "medical insurance enterprise part", "unemployed insurance enterprise part", "industrial injury insurance enterprise part", "birth insurance enterprise part", "replenishment (major illness) medical insurance personal part", "replenishment insurance enterprise part", "replenishment insurance personal part for old insurance", "replenishment insurance personal part for medical insurance", "replenishment medical insurance personal part for industrial injury", "replenishment insurance enterprise part for disabled person insurance enterprise part"; all are determined based on the configuration information of the table, The data sources of the "disabled person insurance deposit personal part", "heating fee enterprise part", "heating fee personal part", "long-term nursing fee enterprise part", "accumulation fund personal part", "accumulation fund supplement enterprise part", "accumulation fund supplement personal part", "social insurance accumulation fund partial sum", "social insurance base", "accumulation fund base" and "service fee" are social insurance accumulation fund reports, and then data rules are added to the data items corresponding to the above fields: and acquiring data from the social security public accumulation fund report.
In another embodiment, if the data rule of the field contains an operation rule, the operation rule is added to the data item, so that the data item processes the target data according to the operation rule. The operation rule may be, for example, an operation formula, a data type, a data length, or the like.
If a certain cell is identified to contain operation rules, for example, C3 ═ A3+ B2, where C3 corresponds to the field "payroll" of the table, A3 corresponds to the field "performance payroll" of the table, and B2 corresponds to the field "station payroll" of the table; if the field 'payroll' can be determined to correspond to the data item 'payroll' according to the mapping relation between the field identification and the data item, the field 'performance payroll' corresponds to the data item 'performance payroll', the field 'post payroll' corresponds to the data item 'post payroll', so that an operation rule can be added to the data item 'payroll': and the actual wage is performance wage plus post wage.
When the business system is formally used online, the input data input by the user aiming at the data item can be processed according to the data rule of the data item. For example, assume that an operation rule is added to the data item "real payroll": if the data of the data item "performance wage" and "post wage" of the employee a is obtained, the data of the data item "real wage" can be calculated according to the above operation formula, that is, the real wage of the employee a. The trigger condition for using the data rule may be when the input data is acquired or when the data processing timing set by the user is reached.
The business system will store the successfully uploaded tables to the database for subsequent online review. The service system can also record the calculated result to the corresponding position of the database table according to the mapping relation between the field identification and the data item, so as to ensure the consistency of the data displayed to the user by the service system and the data in the database.
In another embodiment, if the data rule cannot be configured for the data item according to the data rule of the field, the user may also manually configure the rule for the data item, the business system may provide a plurality of predefined options, each predefined option corresponds to one data rule, and the business system may determine the data rule corresponding to the predefined option selected by the user as the data rule for the data item and add the data rule for the data item. For example, the user may add data rules for the data item "basic payroll" and the data item "post subsidy" as: data was imported manually monthly.
In another embodiment, the user may also modify the data rule of the data item according to actual requirements, and the business system may adaptively modify the data rule of the data item when receiving the modification instruction.
In the embodiment of the invention, the configuration information of the table can be converted into the data rule, the seamless and intelligent migration of the data content and the data rule of the table to the service system is realized, the data rule of the system is not required to be manually configured, the error caused by the data rule of the manually configured data item is avoided, the operation of the data rule configuration is simplified, and the user experience can be greatly improved.
Corresponding to the foregoing embodiment of the data processing method of the business system, the present invention also provides an embodiment of a data processing apparatus of the business system.
Fig. 3 is a schematic block diagram of a data processing apparatus of a service system according to an exemplary embodiment of the present invention, which may include:
the obtaining module 31 is configured to obtain a table to be imported, and identify a data rule of each field from configuration information of the table to be imported;
a rule configuring module 32, configured to configure corresponding data rules for the data items corresponding to the fields in the business system, so as to process the data of the data items using the data rules.
Optionally, the rule configuration module includes:
the determining unit is used for determining at least one field related to the data item according to the field identification of the field and the mapping relation between the field identification and the data item;
a configuration unit, configured to configure the data rule of the at least one field as the data rule of the data item.
Optionally, the data rule comprises a data acquisition rule;
the rule configuration module comprises:
and the configuration unit is used for adding the data acquisition rule for the data item so as to acquire the target data of the data item according to the data acquisition rule.
Optionally, the data rule comprises an operation rule;
the rule configuration module comprises:
and the configuration unit is used for adding the operation rule to the data item so as to process the target data of the data item according to the operation rule.
Optionally, the system further comprises:
and the modification module responds to a rule modification instruction and modifies the data rule of the data item according to the rule modification instruction.
Optionally, the system further comprises:
the acquisition module is further used for acquiring input data input aiming at the data item;
and the data processing module is used for processing the input data according to the data rule of the data item.
For the device embodiments, since they substantially correspond to the method embodiments, reference may be made to the partial description of the method embodiments for relevant points. The above-described embodiments of the apparatus are merely illustrative, and the units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the modules can be selected according to actual needs to achieve the purpose of the scheme of the invention. One of ordinary skill in the art can understand and implement it without inventive effort.
Fig. 4 is a schematic diagram of an electronic device according to an exemplary embodiment of the present invention, and illustrates a block diagram of an exemplary electronic device 40 suitable for implementing embodiments of the present invention. The electronic device 40 shown in fig. 4 is only an example, and should not bring any limitation to the functions and the scope of use of the embodiment of the present invention.
As shown in FIG. 4, electronic device 40 may take the form of a general purpose computing device, which may be a server device, for example. The components of electronic device 40 may include, but are not limited to: the at least one processor 41, the at least one memory 42, and a bus 43 connecting the various system components (including the memory 42 and the processor 41).
The bus 43 includes a data bus, an address bus, and a control bus.
The memory 42 may include volatile memory, such as Random Access Memory (RAM)421 and/or cache memory 422, and may further include Read Only Memory (ROM) 423.
Memory 42 may also include a program tool 425 (or utility tool) having a set (at least one) of program modules 424, such program modules 424 including, but not limited to: an operating system, one or more application programs, other program modules, and program data, each of which, or some combination thereof, may comprise an implementation of a network environment.
The processor 41 executes various functional applications and data processing, such as the methods provided by any of the above embodiments, by running a computer program stored in the memory 42.
The electronic device 40 may also communicate with one or more external devices 44 (e.g., keyboard, pointing device, etc.). Such communication may be through an input/output (I/O) interface 45. Also, the model-generated electronic device 40 may also communicate with one or more networks (e.g., a Local Area Network (LAN), a Wide Area Network (WAN), and/or a public network, such as the Internet) via a network adapter 46. As shown, the network adapter 46 communicates with the other modules of the model-generated electronic device 40 over a bus 43. It should be understood that although not shown in the figures, other hardware and/or software modules may be used in conjunction with the model-generating electronic device 40, including but not limited to: microcode, device drivers, redundant processors, external disk drive arrays, RAID (disk array) systems, tape drives, and data backup storage systems, etc.
It should be noted that although in the above detailed description several units/modules or sub-units/modules of the electronic device are mentioned, such a division is merely exemplary and not mandatory. Indeed, the features and functionality of two or more of the units/modules described above may be embodied in one unit/module according to embodiments of the invention. Conversely, the features and functions of one unit/module described above may be further divided into embodiments by a plurality of units/modules.
The embodiment of the present invention further provides a computer-readable storage medium, on which a computer program is stored, and the computer program, when executed by a processor, implements the method provided in any of the above embodiments.
The above description is only for the purpose of illustrating the preferred embodiments of the present invention and is not to be construed as limiting the invention, and any modifications, equivalents, improvements and the like made within the spirit and principle of the present invention should be included in the scope of the present invention.

Claims (14)

1. A data processing method of a service system is characterized by comprising the following steps:
acquiring a form to be imported, and identifying the data rule of each field from the configuration information of the form to be imported;
and configuring corresponding data rules for the data items corresponding to the fields in the business system so as to process the data of the data items by using the data rules.
2. The data processing method of business system of claim 1, wherein configuring corresponding data rules for data items corresponding to respective fields in the business system comprises:
determining at least one field related to the data item according to the field identification of the field and the mapping relation between the field identification and the data item;
configuring the data rule of the at least one field as the data rule of the data item.
3. The data processing method of a business system of claim 1, wherein the data rules comprise data acquisition rules;
configuring the data rule for the data item includes:
and adding the data acquisition rule for the data item to acquire the target data of the data item according to the data acquisition rule.
4. The data processing method of a business system of claim 1, wherein the data rules comprise operation rules;
configuring the data rule for the data item, including:
and adding the operation rule to the data item so as to process the target data of the data item according to the operation rule.
5. The data processing method of a business system of claim 1, wherein the method further comprises:
in response to a rule modification instruction, modifying a data rule of the data item in accordance with the rule modification instruction.
6. The data processing method of a business system of claim 1, wherein the method further comprises:
obtaining input data entered for the data item;
and processing the input data according to the data rule of the data item.
7. A data processing apparatus of a business system, comprising:
the acquisition module is used for acquiring a form to be imported and identifying the data rule of each field from the configuration information of the form to be imported;
and the rule configuration module is used for configuring corresponding data rules for the data items corresponding to the fields in the business system so as to process the data of the data items by using the data rules.
8. The data processing apparatus of a business system of claim 7, wherein said rule configuration module comprises:
the determining unit is used for determining at least one field related to the data item according to the field identification of the field and the mapping relation between the field identification and the data item;
a configuration unit, configured to configure the data rule of the at least one field as the data rule of the data item.
9. The data processing apparatus of a business system of claim 7, wherein said data rules comprise data acquisition rules;
the rule configuration module comprises:
and the configuration unit is used for adding the data acquisition rule for the data item so as to acquire the target data of the data item according to the data acquisition rule.
10. The data processing apparatus of a business system of claim 7, wherein said data rules comprise operation rules;
the rule configuration module comprises:
and the configuration unit is used for adding the operation rule for the data item so as to process the target data of the data item according to the operation rule.
11. The data processing apparatus of a business system of claim 7, wherein said system further comprises:
and the modification module responds to a rule modification instruction and modifies the data rule of the data item according to the rule modification instruction.
12. The data processing apparatus of a business system of claim 7, wherein said system further comprises:
the acquisition module is further used for acquiring input data input aiming at the data item;
and the data processing module is used for processing the input data according to the data rule of the data item.
13. An electronic device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, characterized in that the processor implements the data processing method of the business system of any one of claims 1 to 6 when executing the computer program.
14. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out the steps of the data processing method of a business system of any one of claims 1 to 6.
CN202010814283.9A 2020-08-13 2020-08-13 Data processing method and device of business system, electronic equipment and storage medium Pending CN112015764A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202010814283.9A CN112015764A (en) 2020-08-13 2020-08-13 Data processing method and device of business system, electronic equipment and storage medium

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202010814283.9A CN112015764A (en) 2020-08-13 2020-08-13 Data processing method and device of business system, electronic equipment and storage medium

Publications (1)

Publication Number Publication Date
CN112015764A true CN112015764A (en) 2020-12-01

Family

ID=73504330

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202010814283.9A Pending CN112015764A (en) 2020-08-13 2020-08-13 Data processing method and device of business system, electronic equipment and storage medium

Country Status (1)

Country Link
CN (1) CN112015764A (en)

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN112541693A (en) * 2020-12-21 2021-03-23 携程计算机技术(上海)有限公司 Performance data generation method, system, electronic device and storage medium
CN113704228A (en) * 2021-08-31 2021-11-26 北京达佳互联信息技术有限公司 Method and device for field self-increment, electronic equipment and storage medium

Citations (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101183356A (en) * 2007-12-14 2008-05-21 华为技术有限公司 Realization method of Excel report forms and Excel reporting system
CN103020089A (en) * 2011-09-27 2013-04-03 深圳市金蝶友商电子商务服务有限公司 Method and device for importing data in EXCEL file to database
CN108197091A (en) * 2016-12-08 2018-06-22 腾讯科技(深圳)有限公司 A kind of method, system and relevant device for creating tables of data
WO2019179012A1 (en) * 2018-03-22 2019-09-26 平安科技(深圳)有限公司 Method, device, apparatus and computer readable storage medium for processing text data
CN110377651A (en) * 2019-06-20 2019-10-25 平安科技(深圳)有限公司 Processing method, device, equipment and the storage medium of batch data
CN111061833A (en) * 2019-12-10 2020-04-24 北京明略软件***有限公司 Data processing method and device, electronic equipment and computer readable storage medium

Patent Citations (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101183356A (en) * 2007-12-14 2008-05-21 华为技术有限公司 Realization method of Excel report forms and Excel reporting system
CN103020089A (en) * 2011-09-27 2013-04-03 深圳市金蝶友商电子商务服务有限公司 Method and device for importing data in EXCEL file to database
CN108197091A (en) * 2016-12-08 2018-06-22 腾讯科技(深圳)有限公司 A kind of method, system and relevant device for creating tables of data
WO2019179012A1 (en) * 2018-03-22 2019-09-26 平安科技(深圳)有限公司 Method, device, apparatus and computer readable storage medium for processing text data
CN110377651A (en) * 2019-06-20 2019-10-25 平安科技(深圳)有限公司 Processing method, device, equipment and the storage medium of batch data
CN111061833A (en) * 2019-12-10 2020-04-24 北京明略软件***有限公司 Data processing method and device, electronic equipment and computer readable storage medium

Cited By (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN112541693A (en) * 2020-12-21 2021-03-23 携程计算机技术(上海)有限公司 Performance data generation method, system, electronic device and storage medium
CN113704228A (en) * 2021-08-31 2021-11-26 北京达佳互联信息技术有限公司 Method and device for field self-increment, electronic equipment and storage medium
CN113704228B (en) * 2021-08-31 2024-02-06 北京达佳互联信息技术有限公司 Method, device, electronic equipment and storage medium for field self-addition

Similar Documents

Publication Publication Date Title
CN107958028A (en) Method, apparatus, storage medium and the terminal of data acquisition
CN110032594B (en) Customizable data extraction method and device for multi-source database and storage medium
CN110084536B (en) Method and device for processing work logs
CN112015764A (en) Data processing method and device of business system, electronic equipment and storage medium
US11087285B2 (en) Systems and methods for providing message templates in an enterprise system
CN109857649B (en) Resource testing method and system
CN113673858B (en) Maintenance method, device and system for factory equipment and storage medium
US9847941B2 (en) Selectively suppress or throttle migration of data across WAN connections
CN109711692A (en) KPI INDEX MANAGEMENT method, apparatus, computer equipment and storage medium
US7827562B1 (en) System and method for flexible publishing and consumption of data between disparate applications
CN111723004B (en) Measurement method for agile software development, measurement data output method and device
CN109191083A (en) Calculation method, system, device and storage medium when a kind of employee chief engineer
CN113868219A (en) Method and device for migrating account set data, electronic equipment and computer storage medium
CN103345781A (en) Multi-biological-characteristic attendance system
CN110471730A (en) Methods of exhibiting, system, big screen system and medium based on Echarts
CN115293685A (en) Logistics order state tracking method, device, equipment and storage medium
CN115587098A (en) Method and system for intelligently identifying chart data
CN113033169A (en) Service data processing method and device
JP2018109869A (en) Amount calculation apparatus, amount calculation method and amount calculation program
CN112651816A (en) Tax declaration method and device combining RPA and AI and electronic equipment
US9727830B2 (en) Multi-tier employment model for human capital management
Hawk Implementing standardized statistical measures and metrics for public services in archival repositories and special collections libraries
CN116126875A (en) Metadata processing method and device
JPWO2018061070A1 (en) Computer system and analysis source data management method
CN115495476A (en) Data query method, device, equipment and medium

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
RJ01 Rejection of invention patent application after publication
RJ01 Rejection of invention patent application after publication

Application publication date: 20201201