CN110457010B - Method and device for batch changing task list based on collaboration platform - Google Patents
Method and device for batch changing task list based on collaboration platform Download PDFInfo
- Publication number
- CN110457010B CN110457010B CN201910739881.1A CN201910739881A CN110457010B CN 110457010 B CN110457010 B CN 110457010B CN 201910739881 A CN201910739881 A CN 201910739881A CN 110457010 B CN110457010 B CN 110457010B
- Authority
- CN
- China
- Prior art keywords
- target
- data
- collaboration platform
- task list
- task
- 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.)
- Active
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/10—Requirements analysis; Specification techniques
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/20—Software design
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02P—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
- Y02P90/00—Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
- Y02P90/30—Computing systems specially adapted for manufacturing
Abstract
The application discloses a method and a device for changing task lists in batches based on a collaboration platform. The method comprises the following steps: acquiring target data in a target table under a target folder, wherein different data in the target table respectively correspond to different attributes in a multi-item target task list in a collaboration platform; importing target data in the target form into the collaboration platform through an API interface provided by the collaboration platform; and carrying out batch modification on the attributes to be modified in the multi-item target task list in the collaboration platform according to the target data. According to the method and the device, the problem that in the related art, when multiple attributes of multiple task sheets of a collaboration platform are modified, the multiple task sheets need to be operated one by one, so that the efficiency of modifying the task sheets is low is solved.
Description
Technical Field
The application relates to the field of platform management, in particular to a method and a device for changing task lists in batches based on a collaboration platform.
Background
In the related art, in game research and development, flow management is an effective management means, and among them, a collaboration platform with a higher frequency of use is the most important task flow management tool. The collaboration platform is used as a lightweight project management tool, takes a task sheet as a basic flow processing unit, and can basically cover all end-play and hand-play products of an enterprise. Based on each game product, the game product has independent collaboration platform sites, and related roles such as planning, programs, art, QA, visual interaction and the like are preset.
Meanwhile, the collaboration platform has a flexible configuration function, and almost can be configured or customized to required parameters, such as links, tracking labels, belonging modules, states, priorities and the like. The manner of use of the collaboration platform is thus different for different projects. As the more parameter attributes the task sheet is customized, the time and effort expended in modifying the task sheet increases, and sometimes such modifications are unavoidable and the amount of modification can be significant.
In daily work, team members (e.g., planning)) need to submit demands at any time, i.e., submit new task sheets, but part of information of the demands is ambiguous, such as version, responsible program, priority, etc., and needs subsequent replenishment. In the daily project demand management flow, team core personnel (producers, main policy, main program, main beauty, main QA, UX interface personnel) can develop demand discussions at regular time, comb all subsequent task sheets, and arrange the development content of the next period, and during the period, content or configuration adjustment can be carried out on each demand (namely, each sheet). Typically, the adjustment of a task sheet involves multiple parts, such as version, plan, responsible program, priority, and other task sheet attributes. The weekly demands will adjust at least tens of task sheets, thus hundreds of adjustment changes will be generated, and the adjustment needs to be manually modified on the collaboration platform by the relevant responsible person (such as producer, planning, main beauty, program, QA).
Such operations, whether performed by one or several persons, are extremely cumbersome and error-prone and require verification after modification. Typically, a single post-demand discussion task sheet modification requires up to 5-7 hours. This is only a requirement and if arithmetically modified daily, repetitive operations are expected to take up 1-2 days of work, accounting for 20% -40% of a single week of work.
In view of the above problems in the related art, no effective solution has been proposed at present.
Disclosure of Invention
The application mainly aims to provide a method and a device for changing task lists in batches based on a collaboration platform, which are used for solving the problem that the efficiency of changing the task lists is low because a plurality of task lists need to be operated one by one when a plurality of attributes of the task lists of the collaboration platform are changed in the related technology.
In order to achieve the above object, according to one aspect of the present application, there is provided a method for batch modification of a task sheet based on a collaboration platform. The method comprises the following steps: acquiring target data in a target table under a target folder, wherein different data in the target table respectively correspond to different attributes in a multi-item target task list in a collaboration platform; importing target data in the target form into the collaboration platform through an API interface provided by the collaboration platform; and carrying out batch modification on the attributes to be modified in the multi-item target task list in the collaboration platform according to the target data.
Further, before acquiring the target data in the target table under the target folder, the method further includes: constructing a target table, wherein a plurality of task sheets are represented in the target table through a header, and a plurality of fields are configured under each task sheet to define different attributes of each task sheet; acquiring a single number of a target task list to be changed and attribute information to be changed in each target task list; and summarizing the single number of the target task list to be changed and the attribute information to be changed into a target table to obtain target data.
Further, after obtaining the target data in the target table under the target folder, the method includes: encapsulating target data into target dictionary data, wherein the target dictionary data at least comprises the following incidental content: the token corresponding to the collaboration platform account number, the project number corresponding to each task list, the single number and the domain name of each task list, and the incidental content is used for carrying out identity authentication on the target dictionary data by the API interface.
Further, importing the target data in the target table into the collaboration platform through an API interface provided by the collaboration platform includes: and converting the target dictionary data into first data identified by the API interface, and pushing the first data into a collaboration platform one by one through the API interface, wherein the collaboration platform comprises a business layer, a middle layer and a bottom layer.
Further, after converting the target dictionary data into the first data identified by the API interface and pushing the first data piece by piece into the collaboration platform through the API interface, the method further includes: unpacking target dictionary data to obtain target data; communicating the target data to the intermediate layer through the business layer; identifying the target data as a target instruction using the middle layer, wherein the target instruction is an instruction identified by the bottom layer; the control bottom layer searches a target task list existing in the collaboration platform according to the target instruction, and modifies the attribute to be modified in the target task list.
Further, after the bottom layer searches the target task list existing in the collaboration platform according to the target instruction and modifies the attribute to be modified in the target task list, the method further comprises: and obtaining a modification result, wherein the modification result at least comprises modification information of the target task list which is successfully modified and modification information of the attribute to be modified which is successfully modified.
Further, after obtaining the modification result, the method further includes: and generating target push information according to the modification result.
In order to achieve the above object, according to another aspect of the present application, there is provided an apparatus for batch modification of a task sheet based on a collaboration platform. The device comprises: the first acquisition unit is used for acquiring target data in a target table under the target folder, wherein different data in the target table respectively correspond to different attributes in a multi-item target task list in the collaboration platform; the importing unit is used for importing the target data in the target form into the collaboration platform through an API interface provided by the collaboration platform; and the modification unit is used for modifying the attributes to be modified in the multi-item target task list in the collaboration platform in batches according to the target data.
In order to achieve the above object, according to another aspect of the present application, there is provided a storage medium including a stored program, wherein the program performs a method of changing a task sheet in batch based on a collaboration platform as described in any one of the above.
To achieve the above object, according to another aspect of the present application, there is provided a processor, a storage medium including a stored program, wherein the program performs a method of changing a task sheet based on a batch of collaboration platforms as described in any one of the above.
According to the application, the following steps are adopted: acquiring target data in a target table under a target folder, wherein different data in the target table respectively correspond to different attributes in a multi-item target task list in a collaboration platform; importing target data in the target form into the collaboration platform through an API interface provided by the collaboration platform; according to the method, the device and the system, the attributes to be modified in the multi-item standard task list in the collaboration platform are modified in batches according to the target data, so that the problem that the efficiency of modifying the task list is low because the plurality of task lists are required to be operated one by one when the plurality of attributes of the plurality of task lists of the collaboration platform are modified in the related technology is solved, and the effect of shortening the working period of the whole flow is achieved.
Drawings
The accompanying drawings, which are included to provide a further understanding of the application and are incorporated in and constitute a part of this specification, illustrate embodiments of the application and together with the description serve to explain the application. In the drawings:
FIG. 1 is a flow chart of a method for batch modification of a task sheet based on a collaboration platform, provided in accordance with an embodiment of the present application;
FIG. 2 is a schematic diagram of a correspondence pattern between users and task sheets under a Redmine framework in the related art;
FIG. 3 is a schematic diagram of the principles of attribute modification of a task sheet based on the framework of the Redmine platform in the related art;
FIG. 4 is a schematic diagram of the principle of attribute modification of a task sheet based on the framework of the Redmine platform provided in accordance with an embodiment of the present application;
FIG. 5 is a schematic diagram of a modification result received on a collaboration platform electronic billboard, provided in accordance with an embodiment of the application;
FIG. 6 is a schematic diagram of a modification record of modified attributes in a generation target task sheet according to modified content provided in accordance with an embodiment of the present application; and
fig. 7 is a schematic diagram of an apparatus for batch changing task sheets based on a collaboration platform according to an embodiment of the present application.
Detailed Description
It should be noted that, without conflict, the embodiments of the present application and features of the embodiments may be combined with each other. The application will be described in detail below with reference to the drawings in connection with embodiments.
In order that those skilled in the art will better understand the present application, a technical solution in the embodiments of the present application will be clearly and completely described below with reference to the accompanying drawings in which it is apparent that the described embodiments are only some embodiments of the present application, not all embodiments. All other embodiments, which can be made by those skilled in the art based on the embodiments of the present application without making any inventive effort, shall fall within the scope of the present application.
It should be noted that the terms "first," "second," and the like in the description and the claims of the present application and the above figures are used for distinguishing between similar objects and not necessarily for describing a particular sequential or chronological order. It is to be understood that the data so used may be interchanged where appropriate in order to describe the embodiments of the application herein. Furthermore, the terms "comprises," "comprising," and "having," and any variations thereof, are intended to cover a non-exclusive inclusion, such that a process, method, system, article, or apparatus that comprises a list of steps or elements is not necessarily limited to those steps or elements expressly listed but may include other steps or elements not expressly listed or inherent to such process, method, article, or apparatus.
For convenience of description, the following will describe some terms or terminology involved in the embodiments of the present application:
redmine platform: i.e., a collaboration platform task platform.
API: (Application Programming Interface ) is a number of predefined functions that are intended to provide the application and developer the ability to access a set of routines based on certain software or hardware without having to access source code or understand the details of the internal operating mechanisms.
According to the embodiment of the application, a method for changing task lists in batches based on a collaboration platform is provided.
FIG. 1 is a flow chart of a method for batch modification of a task sheet based on a collaboration platform, provided in accordance with an embodiment of the present application. As shown in fig. 1, the method comprises the steps of:
step S71, obtaining target data in a target table under the target folder, wherein different data in the target table respectively correspond to different attributes in a multi-item target task list in the collaboration platform.
Based on the collaboration platform originally used, the embodiment provides a batch change tool, and the batch change tool lists all task sheets to be modified in a target table through the target table, preferably, the format of the target table is a csv table, wherein the target table corresponds to a plurality of data, and different data corresponds to different task sheets and different attributes in different task sheets.
Further, after the batch change tool is detected to receive the clicking operation, the execution program of the batch change tool automatically finds the csv file under the same-level directory folder according to g90_update_update.
Step S72, importing the target data in the target form into the collaboration platform through an API interface provided by the collaboration platform.
In particular, the API (Application Programming Interface ) is a number of predefined functions that are intended to provide the application and developer the ability to access a set of routines based on certain software or hardware without having to access source code or understand the details of the internal operating mechanisms.
The Redmine platform (collaboration platform) provides an API interface for updating Redmine task list information, so that the task list information can be changed only by providing corresponding data without knowing how Redmine modifies the task list information at the bottom layer. The method is equivalent to skipping the presentation layer of the Redmine platform which needs user operation, directly calling the interface of the service layer, simulating the actual operation of the user into data to be transmitted to the service layer, and then transmitting the data to the background server for processing and storing the data in the database.
And step S73, modifying the attributes to be modified in the multi-item target task list in the collaboration platform in batches according to the target data.
After the target data is imported into the collaboration platform through the API, the collaboration platform correspondingly modifies the task sheet and the attribute to be modified in the task sheet related to the target data according to the target data.
Optionally, before acquiring the target data in the target table under the target folder, the method further includes: constructing a target table, wherein a plurality of task sheets are represented in the target table through a header, and a plurality of fields are configured under each task sheet to define different attributes of each task sheet; acquiring a single number of a target task list to be changed and attribute information to be changed in each target task list; and summarizing the single number of the target task list to be changed and the attribute information to be changed into a target table to obtain target data.
In the prior art, the following modification means is generally adopted for modifying a plurality of task sheets in the collaboration platform, the Redmine framework adopts a framework mode corresponding to a user-task sheet, the user and the task sheet are taken as basic units, the task sheet is assembled into a set of task sheets project studio team, the user is assembled into a set of user team studio team, and a collaboration platform cluster taking studio team as a carrier is formed. In this mode, each user can only work in the task sheet that is responsible for itself, as shown in fig. 2, fig. 2 is a schematic diagram of a corresponding mode between the user and the task sheet under the Redmine framework in the related art.
The whole framework of the collaboration platform comprises a performance layer, a business layer, a middle layer, a bottom layer, a database and other functions. Firstly, the presentation layer is a web architecture-based system, a user needs to operate various collaboration elements on a web page, namely a browser, and the collaboration elements are in a data format stored in a database in the background, so that the interaction between the presentation layer (html, javascipt, css) and background data needs to have a middle layer to analyze, and the data is analyzed into content which can be identified by the browser and presented to the user. The user manipulates instance data through the presentation layer (browser), such as building a job ticket, updating the job ticket, uploading documents, pictures, and the like. These operations are communicated to the background server through the business layer, then analyzed into instructions which can be identified by the background through the middle layer (interpreter), uniformly processed by the bottom layer and then stored to the server. Similarly, for the attribute or state change of the task list, firstly, the browser (presentation layer) captures a 'drag list', changes the action of the state of the task list, sends a corresponding instruction to the service layer, and then transmits the step-by-step information to the database. Thus, as shown in fig. 3, fig. 3 is a schematic diagram of the related art framework based on the Redmine platform for attribute modification principle of a task sheet.
In the related art, when the attribute of a plurality of task sheets needs to be modified, a user needs to manually find the task sheets to be modified one by one at the browser end of the collaboration platform, and find the positions of the attributes to be modified of the plurality of task sheets on the plurality of task sheets, and manually modify one by one, so that the time and effort are consumed and the modification efficiency is seriously low when the attribute to be modified of the plurality of task sheets is modified one by one in the prior art.
In the embodiment provided by the application, the task sheets which want to modify the parameters are merged together by a plurality of batches of sheet changing tools and are imported into the collaboration platform in batches, and the modified verification is completed. Only few manual operations are needed, even only a button is needed to be clicked, a plurality of batch modification tool users only need to operate 3 steps, data needing to be modified are determined, data are imported, and a modification result verification prompt is obtained.
Wherein, first of all includes: and exporting all task sheets in the current collaboration platform, and determining a target task sheet to be modified and the attribute to be modified in the target task sheet after demand discussion.
Again comprising: according to the target task list and the data of the attribute to be modified in the target task list, constructing a csv form, defining the single number of the task list to be changed and the field name corresponding to the task list to be changed in the csv form, and placing the list in a csv file under the same level list, wherein in the csv form, all fields are not required to be filled in, only the fields to be modified are required to be written in, wherein the header part in the csv form represents the single number of a plurality of different task lists, a plurality of fields are configured in each task list, and the different attributes corresponding to each task list are defined through the plurality of fields.
Optionally, after acquiring the target data in the target table under the target folder, the method includes: encapsulating target data into target dictionary data, wherein the target dictionary data at least comprises the following incidental content: the token corresponding to the collaboration platform account number, the project number corresponding to each task list, the single number and the domain name of each task list, and the incidental content is used for carrying out identity authentication on the target dictionary data by the API interface.
On the basis of obtaining the csv table, the batch change tool executes program actions, automatically finds the csv file under the current directory, extracts and encapsulates each line of data (each line of data corresponds to a task list to be changed and an attribute to be changed under the task list) in the csv file into data of a dictionary type, and corresponds to the fields one by one and the field names transmitted to the background.
Meanwhile, when the task list is updated, identity authentication is required to be performed on a token of the redmine account with the updating authority, so that a token corresponding to the redmine account is attached to a field of dictionary data. After the target data is encapsulated in the dictionary data, each dictionary data includes at least: the method comprises the steps of a token corresponding to the collaboration platform account number, a project number corresponding to each task list, a single number and a domain name of each task list. And then, each dictionary data is attached with a token, a project number, a collaboration platform single id number and four items of necessary filling data of a domain name are transmitted to an update task list interface together, and the update task list interface is transmitted to the collaboration platform through an API (application program interface) one by one.
Optionally, importing the target data in the target table into the collaboration platform through an API interface provided by the collaboration platform includes: and converting the target dictionary data into first data identified by the API interface, and pushing the first data into a collaboration platform one by one through the API interface, wherein the collaboration platform comprises a business layer, a middle layer and a bottom layer.
Specifically, as described above, each piece of encapsulated dictionary data needs to carry a token that can pass the identity authentication of the API, and if the token in the dictionary data does not pass the identity authentication or the dictionary data does not carry the token, the corresponding dictionary data is failed to be imported. When dictionary data is imported into the collaboration platform through the API, the format of the dictionary data needs to be converted into a format which can be identified by the API, and the data converted into the format is recorded as first data. The converted data are imported into the collaboration platform one by one.
It should be noted that, the collaboration platform in this embodiment is the same collaboration platform as the collaboration platform in the prior art, and includes a presentation layer, a service layer, a middle layer and a bottom layer, but the method for modifying task lists in batches provided in this embodiment skips the application of the presentation layer through the process of modifying task lists by using a batch modification tool, and does not need the user to modify task lists one by one, and a schematic diagram of the principle of the modification process is shown in fig. 4, and fig. 4 is a schematic diagram of the principle of attribute modification of task lists by using a framework based on a Redmine platform provided in accordance with an embodiment of the present application.
Optionally, after converting the target dictionary data into the first data identified by the API interface and pushing the first data to the collaboration platform piece by piece through the API interface, the method further includes: unpacking target dictionary data to obtain target data; communicating the target data to the intermediate layer through the business layer; identifying the target data as a target instruction using the middle layer, wherein the target instruction is an instruction identified by the bottom layer; the control bottom layer searches a target task list existing in the collaboration platform according to the target instruction, and modifies the attribute to be modified in the target task list.
Above-mentioned, put the list data in CSV in order in a dictionary, import into the collaborative platform through API interface in batch change the single tool, and unpack dictionary data, get the goal data before unpacking, convey the goal data to the middle floor through the business layer, utilize the middle floor to explain the goal data as the modification order that can discern of the bottom floor of collaborative platform, look for the goal task list that exists in the collaborative platform according to the modification order, and revise the attribute to be revised in the goal task list.
When the attribute to be modified in the task list is modified through the target data through the bottom layer of the collaboration platform, the target data is interpreted as an instruction which can be identified by the bottom layer, and the instruction comprises the identification of the attribute to be modified as a corresponding field.
Optionally, after the bottom layer searches the target task list existing in the collaboration platform according to the target instruction and modifies the attribute to be modified in the target task list, the method further includes: and obtaining a modification result, wherein the modification result at least comprises modification information of the target task list which is successfully modified and modification information of the attribute to be modified which is successfully modified.
After modifying the attribute to be modified in the target task list through the target data, displaying the modification result in the json character string form on the batch modification tool page. Correspondingly, after the refreshing operation is carried out on the collaboration platform, the task electronic billboard of the collaboration platform displays the final modification result in the form of characters and lists, wherein the modification result comprises the single number of the successfully modified task list and the number of the successfully modified task list, and also comprises the number of the corresponding successfully modified attributes in the task list and the contents before and after the modification of the attributes to be modified.
One alternative embodiment provides a schematic representation of the modification results received on the collaboration platform electronic sign, as shown in FIG. 5.
For example: the planner in the task sheet with the sheet number WY20190702 is modified by the li XX to the king XX.
Optionally, in the collaboration platform, a modification record of the attribute to be modified in the target task list is also generated according to the modified content, as shown in fig. 6, where fig. 6 is a schematic diagram of the modification record of the attribute to be modified in the target task list generated according to the modified content according to the embodiment of the present application.
Optionally, after obtaining the modification result, the method further comprises: and generating target push information according to the modification result.
Above-mentioned, after the attribute to be modified in the target task list is successfully modified, the collaboration platform terminal of the personnel involved in the modification can correspondingly receive the push message generated according to the modification result,
for example: both the Li XX and the Wang XX collaboration platform clients receive the planner change information of the WY20190702 task sheet.
Thus, the modification mode that relies on manual modification of each task attribute parameter takes on average 1.2 days to complete, such a time period is very disadvantageous for the whole project development, is inefficient and error-prone, and the statistical accuracy is only less than 90%. After the automatic program is used, the whole modification adjustment and verification process can be completed in tens of minutes, and the accuracy is 70%. It can be concluded that the use of the new modified task sheet mode and automated program execution reduces time waste by 70%, thereby improving overall efficiency of game development.
According to the method for changing the task list in batches based on the collaboration platform, the target data in the target table under the target folder are obtained, wherein different data in the target table correspond to different attributes in the multi-item target task list in the collaboration platform respectively; importing target data in the target form into the collaboration platform through an API interface provided by the collaboration platform; according to the method, the device and the system, the attributes to be modified in the multi-item standard task list in the collaboration platform are modified in batches according to the target data, so that the problem that the efficiency of modifying the task list is low because the plurality of task lists are required to be operated one by one when the plurality of attributes of the plurality of task lists of the collaboration platform are modified in the related technology is solved, and the effect of shortening the working period of the whole flow is achieved.
It should be noted that the steps illustrated in the flowcharts of the figures may be performed in a computer system such as a set of computer executable instructions, and that although a logical order is illustrated in the flowcharts, in some cases the steps illustrated or described may be performed in an order other than that illustrated herein.
The embodiment of the application also provides a device for changing the task list in batches based on the collaboration platform, and the device for changing the task list in batches based on the collaboration platform can be used for executing the method for changing the task list in batches based on the collaboration platform. The device for changing task lists in batches based on the collaboration platform is introduced below.
Fig. 7 is a schematic diagram of an apparatus for batch changing task sheets based on a collaboration platform according to an embodiment of the present application. As shown in fig. 7, the apparatus includes: a first obtaining unit 701, configured to obtain target data in a target table under a target folder, where different data in the target table respectively correspond to different attributes in a multi-item target task list in a collaboration platform; an importing unit 702, configured to import target data in the target table into the collaboration platform through an API interface provided by the collaboration platform; and the modifying unit 703 is configured to modify the attribute to be modified in the multi-item target task list in the collaboration platform in batches according to the target data.
According to the device for changing task lists in batches based on the collaboration platform, provided by the embodiment of the application, the first obtaining unit 701 is used for obtaining target data in the target table under the target folder, wherein different data in the target table respectively correspond to different attributes in the multi-item target task list in the collaboration platform; an importing unit 702, configured to import target data in the target table into the collaboration platform through an API interface provided by the collaboration platform; the modification unit 703 is configured to modify the to-be-modified attribute in the multiple target task sheets in the collaboration platform in batches according to the target data, so that the problem that the efficiency of modifying the task sheets is low due to the fact that multiple task sheets need to be operated one by one when the multiple attributes of the multiple task sheets of the collaboration platform are modified in the related art is solved, and the effect of shortening the working period of the whole flow is further achieved.
Optionally, the apparatus further comprises: the construction unit is used for constructing a target table before acquiring target data in the target table under the target folder, wherein a plurality of task sheets are represented in the target table through a header, and a plurality of fields are configured under each task sheet to define different attributes of each task sheet; the second acquisition unit is used for acquiring the single number of the target task list to be changed and the attribute information to be changed in each target task list; and the summarizing unit is used for summarizing the single number of the target task list to be changed and the attribute information to be changed into the target table to obtain target data.
Optionally, the apparatus comprises: the packaging unit is used for packaging the target data into target dictionary data after the target data in the target table under the target folder are acquired, wherein the target dictionary data at least comprise the following incidental content: the token corresponding to the collaboration platform account number, the project number corresponding to each task list, the single number and the domain name of each task list, and the incidental content is used for carrying out identity authentication on the target dictionary data by the API interface.
Alternatively, the importing unit 702 includes: and the pushing subunit is used for converting the target dictionary data into first data identified by the API interface and pushing the first data into the collaboration platform one by one through the API interface, wherein the collaboration platform comprises a business layer, a middle layer and a bottom layer.
Optionally, the apparatus further comprises: the unpacking unit is used for unpacking the target dictionary data after converting the target dictionary data into first data identified by the API interface and pushing the first data into the collaboration platform one by one through the API interface to obtain target data; a communication unit for communicating the target data to the middle layer through the business layer; the identifying unit is used for identifying the target data as a target instruction by utilizing the middle layer, wherein the target instruction is an instruction identified by the bottom layer; the modifying unit 703 is configured to control the bottom layer to find a target task list existing in the collaboration platform according to the target instruction, and modify an attribute to be modified in the target task list.
Optionally, the apparatus further comprises: the third obtaining unit is used for obtaining a modification result after the bottom layer searches the target task list existing in the collaborative platform according to the target instruction and modifies the attribute to be modified in the target task list, wherein the modification result at least comprises modification information of the target task list which is successfully modified and modification information of the attribute to be modified which is successfully modified.
Optionally, the apparatus further comprises: and the generating unit is used for generating target push information according to the modification result after the modification result is acquired.
The device for changing task lists in batches based on the collaboration platform comprises a processor and a memory, wherein the first acquisition unit 701, the importing unit 702, the modifying unit 703 and the like are all stored in the memory as program units, and the processor executes the program units stored in the memory to realize corresponding functions.
The processor includes a kernel, and the kernel fetches the corresponding program unit from the memory. The kernel can be provided with one or more than one kernel, and the problem of low efficiency of modifying the task list caused by the fact that the multiple task lists need to be operated one by one when the multiple attributes of the multiple task lists of the collaboration platform are modified in the related technology is solved by adjusting kernel parameters.
The memory may include volatile memory, random Access Memory (RAM), and/or nonvolatile memory, such as Read Only Memory (ROM) or flash memory (flash RAM), among other forms in computer readable media, the memory including at least one memory chip.
The embodiment of the invention provides a storage medium, and a program is stored on the storage medium, and when the program is executed by a processor, a method for changing task lists in batches based on a collaboration platform is realized.
The embodiment of the invention provides a processor, which is used for running a program, wherein the program runs for executing a method for changing task lists in batches based on a collaboration platform.
The embodiment of the invention provides equipment, which comprises a processor, a memory and a program stored in the memory and capable of running on the processor, wherein the processor realizes the following steps when executing the program: acquiring target data in a target table under a target folder, wherein different data in the target table respectively correspond to different attributes in a multi-item target task list in a collaboration platform; importing target data in the target form into the collaboration platform through an API interface provided by the collaboration platform; and carrying out batch modification on the attributes to be modified in the multi-item target task list in the collaboration platform according to the target data.
Optionally, before acquiring the target data in the target table under the target folder, the method further includes: constructing a target table, wherein a plurality of task sheets are represented in the target table through a header, and a plurality of fields are configured under each task sheet to define different attributes of each task sheet; acquiring a single number of a target task list to be changed and attribute information to be changed in each target task list; and summarizing the single number of the target task list to be changed and the attribute information to be changed into a target table to obtain target data.
Optionally, after acquiring the target data in the target table under the target folder, the method includes: encapsulating target data into target dictionary data, wherein the target dictionary data at least comprises the following incidental content: the token corresponding to the collaboration platform account number, the project number corresponding to each task list, the single number and the domain name of each task list, and the incidental content is used for carrying out identity authentication on the target dictionary data by the API interface.
Optionally, importing the target data in the target table into the collaboration platform through an API interface provided by the collaboration platform includes: and converting the target dictionary data into first data identified by the API interface, and pushing the first data into a collaboration platform one by one through the API interface, wherein the collaboration platform comprises a business layer, a middle layer and a bottom layer.
Optionally, after converting the target dictionary data into the first data identified by the API interface and pushing the first data to the collaboration platform piece by piece through the API interface, the method further includes: unpacking target dictionary data to obtain target data; communicating the target data to the intermediate layer through the business layer; identifying the target data as a target instruction using the middle layer, wherein the target instruction is an instruction identified by the bottom layer; the control bottom layer searches a target task list existing in the collaboration platform according to the target instruction, and modifies the attribute to be modified in the target task list.
Optionally, after the bottom layer searches the target task list existing in the collaboration platform according to the target instruction and modifies the attribute to be modified in the target task list, the method further includes: and obtaining a modification result, wherein the modification result at least comprises modification information of the target task list which is successfully modified and modification information of the attribute to be modified which is successfully modified.
Optionally, after obtaining the modification result, the method further comprises: and generating target push information according to the modification result. The device herein may be a server, PC, PAD, cell phone, etc.
The application also provides a computer program product adapted to perform, when executed on a data processing device, a program initialized with the method steps of: acquiring target data in a target table under a target folder, wherein different data in the target table respectively correspond to different attributes in a multi-item target task list in a collaboration platform; importing target data in the target form into the collaboration platform through an API interface provided by the collaboration platform; and carrying out batch modification on the attributes to be modified in the multi-item target task list in the collaboration platform according to the target data.
Optionally, before acquiring the target data in the target table under the target folder, the method further includes: constructing a target table, wherein a plurality of task sheets are represented in the target table through a header, and a plurality of fields are configured under each task sheet to define different attributes of each task sheet; acquiring a single number of a target task list to be changed and attribute information to be changed in each target task list; and summarizing the single number of the target task list to be changed and the attribute information to be changed into a target table to obtain target data.
Optionally, after acquiring the target data in the target table under the target folder, the method includes: encapsulating target data into target dictionary data, wherein the target dictionary data at least comprises the following incidental content: the token corresponding to the collaboration platform account number, the project number corresponding to each task list, the single number and the domain name of each task list, and the incidental content is used for carrying out identity authentication on the target dictionary data by the API interface.
Optionally, importing the target data in the target table into the collaboration platform through an API interface provided by the collaboration platform includes: and converting the target dictionary data into first data identified by the API interface, and pushing the first data into a collaboration platform one by one through the API interface, wherein the collaboration platform comprises a business layer, a middle layer and a bottom layer.
Optionally, after converting the target dictionary data into the first data identified by the API interface and pushing the first data to the collaboration platform piece by piece through the API interface, the method further includes: unpacking target dictionary data to obtain target data; communicating the target data to the intermediate layer through the business layer; identifying the target data as a target instruction using the middle layer, wherein the target instruction is an instruction identified by the bottom layer; the control bottom layer searches a target task list existing in the collaboration platform according to the target instruction, and modifies the attribute to be modified in the target task list.
Optionally, after the bottom layer searches the target task list existing in the collaboration platform according to the target instruction and modifies the attribute to be modified in the target task list, the method further includes: and obtaining a modification result, wherein the modification result at least comprises modification information of the target task list which is successfully modified and modification information of the attribute to be modified which is successfully modified.
Optionally, after obtaining the modification result, the method further comprises: and generating target push information according to the modification result.
It will be appreciated by those skilled in the art that embodiments of the present application may be provided as a method, system, or computer program product. Accordingly, the present application may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present application may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.
The present application is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems) and computer program products according to embodiments of the application. It will be understood that each flow and/or block of the flowchart illustrations and/or block diagrams, and combinations of flows and/or blocks in the flowchart illustrations and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
In one typical configuration, a computing device includes one or more processors (CPUs), input/output interfaces, network interfaces, and memory.
The memory may include volatile memory in a computer-readable medium, random Access Memory (RAM) and/or nonvolatile memory, etc., such as Read Only Memory (ROM) or flash RAM. Memory is an example of a computer-readable medium.
Computer readable media, including both non-transitory and non-transitory, removable and non-removable media, may implement information storage by any method or technology. The information may be computer readable instructions, data structures, modules of a program, or other data. Examples of storage media for a computer include, but are not limited to, phase change memory (PRAM), static Random Access Memory (SRAM), dynamic Random Access Memory (DRAM), other types of Random Access Memory (RAM), read Only Memory (ROM), electrically Erasable Programmable Read Only Memory (EEPROM), flash memory or other memory technology, compact disc read only memory (CD-ROM), digital Versatile Discs (DVD) or other optical storage, magnetic cassettes, magnetic tape magnetic disk storage or other magnetic storage devices, or any other non-transmission medium, which can be used to store information that can be accessed by a computing device. Computer-readable media, as defined herein, does not include transitory computer-readable media (transmission media), such as modulated data signals and carrier waves.
It should also be noted that the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising one … …" does not exclude the presence of other like elements in a process, method, article or apparatus that comprises an element.
It will be appreciated by those skilled in the art that embodiments of the present application may be provided as a method, system, or computer program product. Accordingly, the present application may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present application may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.
The foregoing is merely exemplary of the present application and is not intended to limit the present application. Various modifications and variations of the present application will be apparent to those skilled in the art. Any modification, equivalent replacement, improvement, etc. which come within the spirit and principles of the application are to be included in the scope of the claims of the present application.
Claims (9)
1. The method for changing the task list in batches based on the collaboration platform is characterized by comprising the following steps:
acquiring target data in a target table under a target folder, wherein different data in the target table respectively correspond to different attributes in a multi-item target task list in the collaboration platform;
Importing target data in the target table into the collaboration platform through an API interface provided by the collaboration platform;
batch modification is carried out on the attributes to be modified in the multi-item target task list in the collaboration platform according to the target data;
wherein importing the target data in the target table into the collaboration platform through an API interface provided by the collaboration platform includes: converting target dictionary data into first data identified by the API interface, and pushing the first data into the collaboration platform one by one through the API interface, wherein the collaboration platform comprises a business layer, a middle layer and a bottom layer, the business layer is used for transmitting the target data, the middle layer is used for analyzing the target data to obtain a target instruction, and the bottom layer is used for identifying the target instruction, and the target dictionary data at least comprises the following incidental content: the method comprises the steps of carrying out identity authentication on target dictionary data by an API interface, wherein the target dictionary data comprises a token corresponding to a collaboration platform account, a project number corresponding to each task list, a single number and a domain name of each task list, and the incidental content is used for carrying out identity authentication on the target dictionary data by the API interface.
2. The method of claim 1, wherein prior to obtaining the target data in the target table under the target folder, the method further comprises:
Constructing the target table, wherein a plurality of task sheets are represented in the target table through a header, and a plurality of fields are configured under each task sheet to define different attributes of each task sheet;
acquiring a single number of a target task list to be changed and attribute information to be changed in each target task list;
and summarizing the single number of the target task list to be changed and the attribute information to be changed into the target table to obtain the target data.
3. The method of claim 2, wherein after obtaining the target data in the target table under the target folder, the method comprises:
and packaging the target data into the target dictionary data.
4. The method of claim 1, wherein after converting the target dictionary data into first data identified by the API interface and pushing the first data piece by piece into the collaboration platform via the API interface, the method further comprises:
unpacking the target dictionary data to obtain the target data;
communicating the target data to the intermediate layer through the business layer;
identifying the target data as the target instruction with the middle tier, wherein the target instruction is an instruction identified by the bottom tier;
And controlling the bottom layer to search a target task list existing in the collaboration platform according to the target instruction, and modifying the attribute to be modified in the target task list.
5. The method of claim 4, wherein after the bottom layer looks up a target task sheet existing in the collaboration platform according to the target instruction and modifies the attribute to be modified in the target task sheet, the method further comprises: and obtaining a modification result, wherein the modification result at least comprises modification information of the target task list which is successfully modified and modification information of the attribute to be modified which is successfully modified.
6. The method of claim 5, wherein after obtaining the modification result, the method further comprises: and generating target push information according to the modification result.
7. The device for changing the task list in batches based on the collaboration platform is characterized by comprising the following components:
the first acquisition unit is used for acquiring target data in a target table under a target folder, wherein different data in the target table respectively correspond to different attributes in a multi-item target task list in the collaboration platform;
The importing unit is used for importing the target data in the target table into the collaboration platform through an API interface provided by the collaboration platform;
the modification unit is used for modifying the attributes to be modified in the multi-item target task list in the collaboration platform in batches according to the target data;
the importing unit is used for importing the target data in the target table into the collaboration platform through an API interface provided by the collaboration platform through the following steps: converting target dictionary data into first data identified by the API interface, and pushing the first data into the collaboration platform one by one through the API interface, wherein the collaboration platform comprises a business layer, a middle layer and a bottom layer, the business layer is used for transmitting the target data, the middle layer is used for analyzing the target data to obtain a target instruction, and the bottom layer is used for identifying the target instruction, and the target dictionary data at least comprises the following incidental content: the method comprises the steps of carrying out identity authentication on target dictionary data by an API interface, wherein the target dictionary data comprises a token corresponding to a collaboration platform account, a project number corresponding to each task list, a single number and a domain name of each task list, and the incidental content is used for carrying out identity authentication on the target dictionary data by the API interface.
8. A storage medium comprising a stored program, wherein the program performs a method of batch altering a task sheet based on a collaboration platform as claimed in any one of claims 1 to 6.
9. A processor for running a program, wherein the program when run performs a method of batch altering a task sheet based on a collaboration platform as claimed in any one of claims 1 to 6.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910739881.1A CN110457010B (en) | 2019-08-12 | 2019-08-12 | Method and device for batch changing task list based on collaboration platform |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910739881.1A CN110457010B (en) | 2019-08-12 | 2019-08-12 | Method and device for batch changing task list based on collaboration platform |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110457010A CN110457010A (en) | 2019-11-15 |
| CN110457010B true CN110457010B (en) | 2023-08-22 |
Family
ID=68485958
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910739881.1A Active CN110457010B (en) | 2019-08-12 | 2019-08-12 | Method and device for batch changing task list based on collaboration platform |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110457010B (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112463134A (en) * | 2020-12-11 | 2021-03-09 | 中国人寿保险股份有限公司 | Method and device for batch modification of policy data |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20120116835A1 (en) * | 2010-11-10 | 2012-05-10 | Microsoft Corporation | Hybrid task board and critical path method based project management application interface |
| CN104346185A (en) * | 2013-08-01 | 2015-02-11 | 腾讯科技（深圳）有限公司 | Application object attribute updating method and device and application platform |
| CN109656980A (en) * | 2018-12-27 | 2019-04-19 | Oppo（重庆）智能科技有限公司 | Data processing method, electronic equipment, device and readable storage medium storing program for executing |
-
2019
- 2019-08-12 CN CN201910739881.1A patent/CN110457010B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20120116835A1 (en) * | 2010-11-10 | 2012-05-10 | Microsoft Corporation | Hybrid task board and critical path method based project management application interface |
| CN104346185A (en) * | 2013-08-01 | 2015-02-11 | 腾讯科技（深圳）有限公司 | Application object attribute updating method and device and application platform |
| CN109656980A (en) * | 2018-12-27 | 2019-04-19 | Oppo（重庆）智能科技有限公司 | Data processing method, electronic equipment, device and readable storage medium storing program for executing |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110457010A (en) | 2019-11-15 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US10929116B2 (en) | Generation of dynamic software models using input mapping with feature definitions | |
| CN108304201B (en) | Object updating method, device and equipment | |
| CN100578495C (en) | Method and system for exposing nested data in a computer-generated document in a transparent manner | |
| US9129238B2 (en) | Dynamic web services work flow system and method | |
| US20130067456A1 (en) | Application configuration framework for enterprise resource planning application installation | |
| US20120089931A1 (en) | Lightweight operation automation based on gui | |
| CN108134812B (en) | Data processing method and device | |
| CN105354025A (en) | Service model configuration system and method based on mobile application | |
| CN108540351B (en) | Automatic testing method for distributed big data service | |
| US9063753B2 (en) | Scripting framework for business objects | |
| CN111784108B (en) | Modeling method and device of main data management platform | |
| CN109814863A (en) | A kind of processing method, device, computer equipment and computer storage medium for requesting returned data | |
| US8935173B2 (en) | Executing a business process by a standard business process engine | |
| CN110457010B (en) | Method and device for batch changing task list based on collaboration platform | |
| CN111984882A (en) | Data processing method, system and equipment | |
| EP2395468A1 (en) | Semantic user interface data assembling | |
| CN112395108A (en) | Calling method and device of BIM (building information modeling) element model | |
| CN103984554A (en) | Software design document generating method and device | |
| CN111061733A (en) | Data processing method and device, electronic equipment and computer readable storage medium | |
| US10324692B2 (en) | Integration for next-generation applications | |
| CN115130442A (en) | Report generation method and device, storage medium and computer equipment | |
| CN108153678A (en) | A kind of test assignment processing method and processing device | |
| CN114253546A (en) | Code generation method and device, storage medium and electronic device | |
| CN111858595B (en) | Dynamic configuration method and system for electric power engineering examination record table | |
| CN113672222A (en) | Application program interface management device and construction method thereof |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |