CN112860245A - Batch remarking method based on Jira system - Google Patents
Batch remarking method based on Jira system Download PDFInfo
- Publication number
- CN112860245A CN112860245A CN202110260760.6A CN202110260760A CN112860245A CN 112860245 A CN112860245 A CN 112860245A CN 202110260760 A CN202110260760 A CN 202110260760A CN 112860245 A CN112860245 A CN 112860245A
- Authority
- CN
- China
- Prior art keywords
- jira
- batch
- remarking
- text
- method based
- 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.)
- Granted
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/30—Creation or generation of source code
- G06F8/34—Graphical or visual programming
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/30—Creation or generation of source code
- G06F8/38—Creation or generation of source code for implementing user interfaces
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F9/00—Arrangements for program control, e.g. control units
- G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
- G06F9/44—Arrangements for executing specific programs
- G06F9/445—Program loading or initiating
- G06F9/44505—Configuring for program initiating, e.g. using registry, configuration files
- G06F9/4451—User profiles; Roaming
Abstract
The invention discloses a batch remarking method based on a Jira system, which comprises the following steps: s1, loading a configuration file of the remark tool; s2, setting an Excel content page; s3, importing the Excel content page into a Jira system; s4, automatically generating a Jira data algorithm; and S5, exporting data and completing batch remarking. The method can intelligently identify and analyze the content in the Excel and automatically generate the Jira data algorithm, thereby realizing batch remark, improving the working efficiency, and enabling the remark to be more attractive and easy to read.
Description
Technical Field
The invention relates to the technical field of batch remarks, in particular to a batch remarking method based on a Jira system.
Background
After taking the affairs of a certain system, the game testing personnel can test each subsystem and the boundary area of the system so as to ensure the quality of game products. The problems need to be recorded in the testing process and written into a remark column of the jira system in a text mode, and research personnel can process the corresponding problems according to the remark information of the testing personnel. A large system usually comprises several subsystems, each subsystem is made by different research and development personnel, so that a tester corresponds to multiple research and development personnel, and when the tester checks and records problems, the tester records the problems according to the sequence of the problems, and cannot distinguish the problems according to modules, so that the following problems are caused: 1. each research and development personnel needs to check each record to mark out the problem records belonging to the research and development personnel; 2. each question has several states (pending, processed, no processing required, etc.), and in order to achieve the display and change of the states, labels which can be recognized by the Jira system need to be written manually; 3. each question has a priority (urgent, level 1, level 2, suspension, etc.), and the transition which can be identified by the Jira system needs to be manually written in order to achieve the display and change of the priority; 4. under the condition that label codes are not written, remarks are not attractive enough. The above problems are continuously promoted along with the testing stage, and the understanding cost of the tester is continuously increased, so that the working efficiency is low, and even the omission condition occurs.
Disclosure of Invention
In order to solve the problems, the invention provides a batch remarking method based on a Jira system, so as to provide a high-efficiency and high-accuracy batch remarking method.
The invention adopts the following technical scheme:
a batch remarking method based on a Jira system comprises the following steps:
s1, loading a configuration file of the remark tool;
s2, setting an Excel content page;
s3, importing the Excel content page into a Jira system;
s4, automatically generating a Jira data algorithm;
and S5, exporting data and completing batch remarking.
Further, the configuration file contains a mapping relationship pool and an appearance color pool.
Further, the mapping relation pool contains the mapping relation between the state text customized by the user and the corresponding Jira text label, and the appearance color pool contains the appearance color customized by the user and the corresponding Jira appearance color label.
Further, the appearance color comprises text boldness, text italics, background color or border color.
Further, the Excel content page comprises a plurality of sheet tables, a first column of a header of each sheet table is set as a serial number, every two columns from a second column are a unit, and each unit comprises a state column and a description column.
Further, the first one of the units serves as a parent, and the following units serve as children of the first unit.
Further, the step S4 is specifically as follows:
s41, loading a 1 st sheet table, taking the row number x in the sheet table as 2, reading the record of the x-th row, reading the first column and forming a serial number;
s42, reading each unit one by one, reading the content of the state column in each unit and analyzing to generate a corresponding Jira text label code, and reading the content of the description column and analyzing to generate a corresponding Jira appearance color label code;
s43, determining whether the row number x is the last row, if yes, going to step S44, if no, making x equal to x +1, and repeating steps S41 and S42 until x equal to n is the last row;
and S44, automatically setting the text and the appearance color in the sheet table according to the Jira text label codes, the Jira color label codes, the mapping relation pool and the appearance color pool generated in the step S42.
Further, the method further comprises a step S45 of judging whether the current sheet table is the last table, if so, entering a step S5, otherwise, continuously deriving the 2 nd table, and repeating the steps S41 to S44 until the nth table is the last table.
After adopting the technical scheme, compared with the background technology, the invention has the following advantages:
1. the method can intelligently identify and analyze the content in the Excel, generate the text which can be identified by the Jira system, improve the working efficiency of testers, and enable the testers to achieve the expected effect directly through intuitive Chinese character description without remembering numerous label codes;
2. the remarks are more attractive, and the testers and programmers can browse the remark information more intuitively and easily read;
3. an extensible configuration file is designed and used for storing the mapping relation between the state text and the Jira text label and the mapping relation between the appearance color and the Jira appearance color label, and a Jira data algorithm is automatically generated according to the mapping relation, so that batch remarks are realized;
4. the Excel content page is designed, the problems are coded and classified to form a parent-child relationship, the positions of the problems can be quickly positioned according to the state text, and the efficiency is improved.
Drawings
FIG. 1 is a schematic flow diagram of the process of the present invention;
FIG. 2 is an exemplary diagram of an Excel content page in accordance with the present invention;
FIG. 3 is a flowchart illustrating step S4 according to the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the present invention more apparent, the present invention is described in further detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative of the invention and are not intended to limit the invention.
Examples
As shown in fig. 1, a batch remarking method based on Jira system includes the following steps:
s1, loading a configuration file of the remark tool;
the configuration file contains a mapping relationship pool and an appearance color pool. The mapping relation pool contains the mapping relation between the state text customized by the user and the corresponding Jira text label, and the appearance color pool contains the appearance color customized by the user and the corresponding Jira appearance color label. The appearance color comprises a text bold, a text italic, a background color or a border color.
The user can customize the state text of the user according to the preference or habit of the user, for example: complete corresponds to the label, (/); the appearance color can also be customized according to own preference, such as: the background color of the title may be set to red, etc.
S2, setting an Excel content page;
as shown in fig. 2, the Excel content page is composed of several sheet tables, the first column of the header of each sheet table is set as a serial number, each two columns from the second column are a unit, and each unit is composed of a state column and a description column. The first one of the units serves as a parent, and the following units serve as children of the first unit.
The problems are coded and classified to form a parent-child relationship, the positions of the questions can be quickly positioned according to the state texts, the efficiency is improved, in addition, the units can be continuously expanded backwards, the text in the description is subjected to operations such as thickening, color changing, italic and the like, corresponding embodiment can be realized after the text is exported to Jira, and the remarks are more attractive and easy to read.
S3, importing the Excel content page into a Jira system;
s4, automatically generating a Jira data algorithm;
as shown in fig. 3, the step S4 is specifically as follows:
s41, loading a 1 st sheet table, taking the row number x in the sheet table as 2, reading the record of the x-th row, reading the first column and forming a serial number;
s42, reading each unit one by one, reading the content of the state column in each unit, analyzing the mapping relation between the state text customized by the user and the corresponding Jira text label, and generating the corresponding Jira text label code; reading the content of the description column, analyzing information expansion of colors, bolding, underlining, italics and the like set in an excel content page by a user, and generating corresponding Jira appearance color label codes according to the information expansion;
s43, determining whether the row number x is the last row, if yes, going to step S44, if no, making x equal to x +1, and repeating steps S41 and S42 until x equal to n is the last row;
and S44, automatically setting the text and the appearance color in the sheet table according to the Jira text label codes, the Jira color label codes, the mapping relation pool and the appearance color pool generated in the step S42.
Further, the method further comprises a step S45 of judging whether the current sheet table is the last table, if so, entering a step S5, otherwise, continuously deriving the 2 nd table, and repeating the steps S41 to S44 until the nth table is the last table.
The method of the embodiment can intelligently identify and analyze the content in the Excel, automatically generate the Jira data algorithm and generate the text which can be identified by the Jira system, improves the working efficiency of testers, and can achieve the expected effect by directly describing Chinese characters intuitively without remembering numerous label codes.
And S5, exporting data and completing batch remarking.
The above description is only for the preferred embodiment of the present invention, but the scope of the present invention is not limited thereto, and any changes or substitutions that can be easily conceived by those skilled in the art within the technical scope of the present invention are included in the scope of the present invention. Therefore, the protection scope of the present invention shall be subject to the protection scope of the claims.
Claims (8)
1. A batch remarking method based on a Jira system is characterized by comprising the following steps: the method comprises the following steps:
s1, loading a configuration file of the remark tool;
s2, setting an Excel content page;
s3, importing the Excel content page into a Jira system;
s4, automatically generating a Jira data algorithm;
and S5, exporting data and completing batch remarking.
2. The batch remarking method based on Jira system as claimed in claim 1, wherein: the configuration file contains a mapping relationship pool and an appearance color pool.
3. The batch remarking method based on Jira system as claimed in claim 2, wherein: the mapping relation pool contains the mapping relation between the state text customized by the user and the corresponding Jira text label, and the appearance color pool contains the appearance color customized by the user and the corresponding Jira appearance color label.
4. The batch remarking method based on Jira system as claimed in claim 3, wherein: the appearance color comprises a text bold, a text italic, a background color or a border color.
5. The batch remarking method based on Jira system as claimed in claim 4, wherein: the Excel content page is composed of a plurality of sheet tables, a first column of a header of each sheet table is set as a serial number, every two columns from a second column are a unit, and each unit is composed of a state column and a description column.
6. The batch remarking method based on Jira system as claimed in claim 5, wherein: the first one of the units serves as a parent, and the following units serve as children of the first unit.
7. The batch remarking method based on Jira system as claimed in claim 6, wherein: the step S4 is specifically as follows:
s41, loading a 1 st sheet table, taking the row number x in the sheet table as 2, reading the record of the x-th row, reading the first column and forming a serial number;
s42, reading each unit one by one, reading the content of the state column in each unit and analyzing to generate a corresponding Jira text label code, and reading the content of the description column and analyzing to generate a corresponding Jira appearance color label code;
s43, determining whether the row number x is the last row, if yes, going to step S44, if no, making x equal to x +1, and repeating steps S41 and S42 until x equal to n is the last row;
and S44, automatically setting the text and the appearance color in the sheet table according to the Jira text label codes, the Jira color label codes, the mapping relation pool and the appearance color pool generated in the step S42.
8. The method of claim 7 for batch remarking based on Jira system, wherein: and S45, judging whether the current sheet table is the last table, if so, entering S5, otherwise, continuously exporting the 2 nd table, and repeating the steps S41 to S44 until the Nth table is the last table.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110260760.6A CN112860245B (en) | 2021-03-10 | 2021-03-10 | Batch remarking method based on Jira system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110260760.6A CN112860245B (en) | 2021-03-10 | 2021-03-10 | Batch remarking method based on Jira system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN112860245A true CN112860245A (en) | 2021-05-28 |
| CN112860245B CN112860245B (en) | 2022-07-19 |
Family
ID=75993920
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110260760.6A Active CN112860245B (en) | 2021-03-10 | 2021-03-10 | Batch remarking method based on Jira system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112860245B (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113342687A (en) * | 2021-07-01 | 2021-09-03 | 厦门极致互动网络技术股份有限公司 | Method for detecting code specification in batches |
| CN116029271A (en) * | 2023-02-01 | 2023-04-28 | 南京维拓科技股份有限公司 | Method for importing tree-type structure data in batches based on easy excel |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101976236A (en) * | 2010-09-26 | 2011-02-16 | 用友软件股份有限公司 | Method and device for importing floating row data through worksheet |
| WO2014015776A1 (en) * | 2012-07-25 | 2014-01-30 | 烽火通信科技股份有限公司 | Service parsing method flexibly adapted to ims system service tag |
| CN109215161A (en) * | 2017-06-30 | 2019-01-15 | 北京四维图新科技股份有限公司 | A kind of drive test evidence taking equipment, method and drive test vehicle |
| CN109558440A (en) * | 2018-10-18 | 2019-04-02 | 平安科技（深圳）有限公司 | Batch data processing method, device, computer equipment and storage medium |
| CN110059121A (en) * | 2019-03-12 | 2019-07-26 | 广州明珞汽车装备有限公司 | A kind of method, system, device and the storage medium of quick export bill of materials |
| CN110597576A (en) * | 2018-06-13 | 2019-12-20 | 广州金山移动科技有限公司 | File remark processing method and system |
| CN111611242A (en) * | 2020-04-30 | 2020-09-01 | 北京航天云路有限公司 | Method for importing Excel data into database |
-
2021
- 2021-03-10 CN CN202110260760.6A patent/CN112860245B/en active Active
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101976236A (en) * | 2010-09-26 | 2011-02-16 | 用友软件股份有限公司 | Method and device for importing floating row data through worksheet |
| WO2014015776A1 (en) * | 2012-07-25 | 2014-01-30 | 烽火通信科技股份有限公司 | Service parsing method flexibly adapted to ims system service tag |
| CN109215161A (en) * | 2017-06-30 | 2019-01-15 | 北京四维图新科技股份有限公司 | A kind of drive test evidence taking equipment, method and drive test vehicle |
| CN110597576A (en) * | 2018-06-13 | 2019-12-20 | 广州金山移动科技有限公司 | File remark processing method and system |
| CN109558440A (en) * | 2018-10-18 | 2019-04-02 | 平安科技（深圳）有限公司 | Batch data processing method, device, computer equipment and storage medium |
| CN110059121A (en) * | 2019-03-12 | 2019-07-26 | 广州明珞汽车装备有限公司 | A kind of method, system, device and the storage medium of quick export bill of materials |
| CN111611242A (en) * | 2020-04-30 | 2020-09-01 | 北京航天云路有限公司 | Method for importing Excel data into database |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113342687A (en) * | 2021-07-01 | 2021-09-03 | 厦门极致互动网络技术股份有限公司 | Method for detecting code specification in batches |
| CN116029271A (en) * | 2023-02-01 | 2023-04-28 | 南京维拓科技股份有限公司 | Method for importing tree-type structure data in batches based on easy excel |
Also Published As
| Publication number | Publication date |
|---|---|
| CN112860245B (en) | 2022-07-19 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN112860245B (en) | Batch remarking method based on Jira system | |
| JP3425408B2 (en) | Document reading device | |
| US8015203B2 (en) | Document recognizing apparatus and method | |
| US20120299959A1 (en) | Method and Device for Interacting with a Map | |
| CN105631393A (en) | Information recognition method and device | |
| CN101246550B (en) | Image character recognition method and device | |
| CN104520877A (en) | Handwriting drawing apparatus and method | |
| CN112860905A (en) | Text information extraction method, device and equipment and readable storage medium | |
| JP6845911B1 (en) | Character processing system and program | |
| CN116205211A (en) | Document level resume analysis method based on large-scale pre-training generation model | |
| CN115100668A (en) | Method and device for identifying table information in image | |
| CN110765107B (en) | Question type identification method and system based on digital coding | |
| CN113032243B (en) | Intelligent testing method and system for GUI (graphical user interface) of mobile application program | |
| CN113342687B (en) | Method for detecting code specification in batches | |
| CN115618819A (en) | Excel and Dwg file interconversion method and device | |
| CN112541505B (en) | Text recognition method, text recognition device and computer-readable storage medium | |
| CN111814417A (en) | Method for converting Verilog code based on character separation value file | |
| CN111859920A (en) | Method and system for identifying word spelling errors and electronic equipment | |
| CN103729634A (en) | Character recognition apparatus and character recognition method | |
| CN115984860A (en) | Method, system, equipment and storage medium for automatically segmenting test question document | |
| US20090172522A1 (en) | Text Composition | |
| CN1372681A (en) | Method and apparatus for symbol storage and display | |
| CN117034866A (en) | Method, device, computer equipment and storage medium for generating document index label | |
| CN102043782A (en) | Search system and method capable of establishing index according to codes | |
| CN110609990A (en) | Method and system for editing structured data text based on artificial intelligence |
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 |