CN110888874B - Device and method for creating form through Excel and storage medium - Google Patents
Device and method for creating form through Excel and storage medium Download PDFInfo
- Publication number
- CN110888874B CN110888874B CN201911050202.6A CN201911050202A CN110888874B CN 110888874 B CN110888874 B CN 110888874B CN 201911050202 A CN201911050202 A CN 201911050202A CN 110888874 B CN110888874 B CN 110888874B
- Authority
- CN
- China
- Prior art keywords
- clearquest
- excel
- information
- column
- database
- 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
- 238000000034 method Methods 0.000 title claims abstract description 24
- 238000012795 verification Methods 0.000 claims abstract description 7
- 230000007547 defect Effects 0.000 description 8
- 230000008569 process Effects 0.000 description 6
- 238000012360 testing method Methods 0.000 description 6
- 238000004590 computer program Methods 0.000 description 3
- 238000006467 substitution reaction Methods 0.000 description 3
- 238000010586 diagram Methods 0.000 description 2
- 238000007726 management method Methods 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 238000012827 research and development Methods 0.000 description 2
- 230000008859 change Effects 0.000 description 1
- 238000013070 change management Methods 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 230000006870 function Effects 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Software Systems (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Document Processing Apparatus (AREA)
Abstract
The invention relates to a device, a method and a storage medium for creating a form through Excel, wherein the device comprises the following steps: the login module calls ClearQuest API to log in a ClearQuest background database; ClearQuest logs in a system in a form of user name and password verification, and selects a corresponding mode library and a corresponding database; defining a CQ user name, a password and a database as variables at a fixed position of a Sheet page; the page text information obtaining module is used for obtaining text information in a corresponding format in an Excel Sheet page and sequentially assigning the information to variables in a ClearQuest form; and the form submitting module calls ClearQuest API through the Excel VBA to submit the form.
Description
Technical Field
The invention belongs to the technical field of Excel form creation, and particularly relates to a device and a method for creating a form through Excel and a storage medium.
Background
ClearQuest is a defect and change management tool provided by IBM Rational, and a client can customize circulation tracking matrixes of various processes and define necessary form fields through a server side, and perform operations such as form creation, query, examination and approval circulation and the like after logging in a client side or a Web interface.
The system is mainly used for a defect management system or a change approval tracking system in the research and development process, taking a defect management flow as an example, a tester can log in the system, fill in information of a test version, Bug detailed description, severity and the like in the test process, and allocate a form to a research and development team responsible person for analysis and resolution.
However, no matter from the client side of ClearQuest or the Web side, the user can only add the form records one by one, fill in the corresponding fields, and then submit the form to complete the flow of the process. In another round of system testing process, the number of defects submitted by testing is possibly hundreds, when the defects are filled in the ClearQuest system one by one, a plurality of fields are possibly repeated, such as project names, test versions, test environments and the like, so that the working efficiency of personnel is low, and the probability of human errors is increased. This is a disadvantage in the prior art.
In view of this, the present invention provides an apparatus, method and storage medium for creating a form through Excel; it is very necessary to solve the above-mentioned defects existing in the prior art.
Disclosure of Invention
In view of the above disadvantages in the prior art, the present invention provides an apparatus, a method and a storage medium for creating a form through Excel, so as to solve the above technical problems.
In order to realize the purpose, the invention provides the following technical scheme:
in a first aspect, the present invention provides an apparatus for creating a form through Excel, including:
the login module calls ClearQuest API to log in a ClearQuest background database; defining a CQ user name, a password and a database as variables at a fixed position of a Sheet page; ClearQuest logs in a system in a form of user name and password verification, and selects a corresponding mode library and a corresponding database; the user information can be conveniently filled in each time the API is called to access the ClearQuest database;
the page text information obtaining module is used for obtaining text information in a corresponding format in an Excel Sheet page and sequentially assigning the information to variables in a ClearQuest form;
and the form submitting module calls ClearQuest API through the Excel VBA to submit the form, if the form is successfully submitted, the id number of the form is obtained, the id number is returned to the Excel, and the form is filled in the corresponding list.
Preferably, in the form submitting module, the Excel VBA acquires ID information of a form generated by ClearQuest, writes the ID information into an 'ID' column corresponding to a Sheet page, and judges according to the content of the 'ID' column, if the ID column is a null value and the 'Bug title' column is not a null value, submits Bug record information on the Excel one by one; and realizing batch uploading of forms.
In a second aspect, the present invention provides a method for creating a form through Excel, including the following steps:
s1: logging in a ClearQuest background database, and calling a ClearQuest API to log in the ClearQuest background database; ClearQuest logs in a system in a form of user name and password verification, and selects a corresponding mode library and a corresponding database; defining a CQ user name, a password and a database as variables at a fixed position of a Sheet page; the user information can be conveniently filled in each time the API is called to access the ClearQuest database;
s2: acquiring text information of an Excel Sheet page, acquiring text information in a corresponding format in the Excel Sheet page, and sequentially assigning the information to variables in a ClearQuest form;
s3: and submitting the form by calling ClearQuest API through the Excel VBA, if the form is successfully submitted, obtaining the id number of the form, returning the id number to the Excel, and filling in the corresponding list.
Preferably, in step S3, the Excel VBA acquires ID information of the ClearQuest generation form, writes the ID information into an "ID" column corresponding to the Sheet page, and determines, according to the content of the "ID" column, if the ID column is null and the "Bug header" column is not null, then submits Bug record information on the Excel one by one; and realizing batch uploading of forms.
In a third aspect, there is provided a computer storage medium having stored therein instructions that, when run on a computer, cause the computer to perform the method of the second aspect described above.
In a fourth aspect, a terminal is provided, including:
a processor, a memory, wherein,
the memory is used for storing a computer program which,
the processor is configured to retrieve and execute the computer program from the memory, so that the terminal performs the method according to the second aspect.
In a fifth aspect, there is provided a computer program product comprising instructions which, when run on a computer, cause the computer to perform the method of the second aspect described above.
The method has the advantages that the method for creating the form from ClearQuest through Excel is adopted, the method for creating the forms in batches is realized according to actual conditions, and the same fields in different forms can be quickly filled in through the Excel copying and pasting function. One-key submission is adopted, so that the working efficiency of submitting the form by the ClearQuest user is improved, the operation difficulty is reduced, and the mistake in the form creating process is reduced.
In addition, the invention has reliable design principle, simple structure and very wide application prospect.
Drawings
In order to more clearly illustrate the embodiments or technical solutions in the prior art of the present invention, the drawings used in the description of the embodiments or prior art will be briefly described below, and it is obvious for those skilled in the art that other drawings can be obtained based on these drawings without creative efforts.
FIG. 1 is a schematic block diagram of an apparatus for creating a form through Excel according to the present invention.
FIG. 2 is a flow chart diagram of a method for creating a form through Excel according to the present invention.
The system comprises a login module, a page text information acquisition module and a form submission module, wherein the login module is 1, the page text information acquisition module is 2, and the form submission module is 3.
Detailed Description
In order to make those skilled in the art better understand the technical solutions of the present invention, the technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
Example 1:
as shown in fig. 1, an apparatus for creating a form through Excel according to this embodiment includes:
the login module 1 calls ClearQuest API to log in a ClearQuest background database; defining a CQ user name, a password and a database as variables at a fixed position of a Sheet page; ClearQuest logs in a system in a form of user name and password verification, and selects a corresponding mode library and a corresponding database; the user information can be conveniently filled in each time the API is called to access the ClearQuest database;
the module implements the code as follows:
the page text information obtaining module 2 is used for obtaining text information in a corresponding format in an Excel Sheet page and sequentially assigning the information to variables in a ClearQuest form;
the module implements the code as follows:
acquiring data information filled in Sheet page
head _ lines Sheets ("commit data"). Cells (i,3)
bug describe ═ Sheets ("commit data"). Cells (i,4)
project sheet ("commit data"). Cells (i,5)
owener ═ Sheets ("submitted data"). Cells (i,6)
environment Sheets ("submitted data"). Cells (i,7)
version ═ Sheets ("submitted data"). Cells (i,8)
// creating a defect tracking form
SetentityObj ═ session. buildnentity ("defect tracking form")
V/assigning data in Excel to variables in ClearQuest respectively
entityObj.SetFieldValue"Headline",head_line
entityObj.SetFieldValue"Describe",bug_describe
entityObj.SetFieldValue"Project",project
entityObj.SetFieldValue"Owner",owner
entityObj.SetFieldValue"Eviroment",environment
entityObj.SetFieldValue"Version",version
The form submitting module 3 calls ClearQuest API through the excelVBA to submit the form, if the form is successfully submitted, the id number of the form is obtained, the id number is returned to the Excel, and the form is filled in a corresponding list; the excelVBA acquires ID information of a ClearQuest generation form, writes the ID information into an 'ID' column corresponding to a Sheet page, judges according to the content of the 'ID' column, and submits the Bug record information on the Excel one by one if the ID column is a null value and the 'Bug title' column is not a null value; and realizing batch uploading of forms.
The module implements the code as follows:
example 2:
as shown in fig. 2, the method for creating a form through Excel according to the present embodiment includes the following steps:
s1: logging in a ClearQuest background database, and calling ClearQuest API to log in the ClearQuest background database; ClearQuest logs in a system in a form of user name and password verification, and selects a corresponding mode library and a corresponding database; defining a CQ user name, a password and a database as variables at a fixed position of a Sheet page; the user information can be conveniently filled in each time the API is called to access the ClearQuest database;
s2: acquiring text information of an Excel Sheet page, acquiring text information in a corresponding format in the Excel Sheet page, and sequentially assigning the information to variables in a ClearQuest form;
s3: a step of submitting the form, which is to call ClearQuest API through Excel VBA to submit the form, if the form is successfully submitted, obtain the id number of the form, return the id number to Excel and fill in a corresponding list; the Excel VBA acquires ID information of a ClearQuest generation form, writes the ID information into an 'ID' column corresponding to a Sheet page, judges according to the content of the 'ID' column, and submits Bug record information on the Excel one by one if the ID column is a null value and the 'Bug title' column is not a null value; and realizing batch uploading of forms.
Although the present invention has been described in detail in connection with the preferred embodiments with reference to the accompanying drawings, the present invention is not limited thereto. Various equivalent modifications or substitutions can be made on the embodiments of the present invention by those skilled in the art without departing from the spirit and scope of the present invention, and these modifications or substitutions are within the scope of the present invention/any person skilled in the art can easily conceive of the changes or substitutions within the technical scope of the present invention. Therefore, the protection scope of the present invention shall be subject to the protection scope of the claims.
Claims (5)
1. An apparatus for creating a form through Excel, comprising:
the login module calls ClearQuest API to log in a ClearQuest background database; defining a CQ user name, a password and a database as variables at a fixed position of a Sheet page; ClearQuest logs in a system in a form of user name and password verification, and selects a corresponding mode library and a corresponding database;
the page text information obtaining module is used for obtaining text information in a corresponding format in an ExcelSheet page and sequentially assigning the information to variables in a ClearQuest form;
and the form submitting module calls ClearQuest API through the Excel VBA to submit the form, if the form is successfully submitted, the id number of the form is obtained, the id number is returned to the Excel, and the form is filled in the corresponding list.
2. The apparatus according to claim 1, wherein in the form submission module, the ExcelVBA obtains ID information of a form generated by ClearQuest, writes the ID information into an "ID" column corresponding to a Sheet page, and submits the Bug record information on the Excel one by one if the ID column is null and the "Bug title" column is not null according to the content of the "ID" column.
3. A method for creating a form through Excel is characterized by comprising the following steps:
s1: logging in a ClearQuest background database, and calling a ClearQuest API to log in the ClearQuest background database; ClearQuest logs in a system in a form of user name and password verification, and selects a corresponding mode library and a corresponding database; defining a CQ user name, a password and a database as variables at a fixed position of a Sheet page;
s2: acquiring text information of an Excel Sheet page, acquiring text information in a corresponding format in the Excel Sheet page, and sequentially assigning the information to variables in a ClearQuest form;
s3: and submitting the form by calling ClearQuest API through the Excel VBA, if the form is successfully submitted, obtaining the id number of the form, returning the id number to the Excel, and filling in the corresponding list.
4. The method as claimed in claim 3, wherein in step S3, the Excel VBA obtains ID information of the ClearQuest-generated form, writes the ID information into an "ID" column corresponding to the Sheet page, and submits the Bug record information on the Excel one by one if the ID column is empty and the "Bug title" column is not empty, according to the content of the "ID" column.
5. A computer storage medium having stored thereon instructions which, when run on a computer, cause the computer to perform the method of claim 3 or 4.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911050202.6A CN110888874B (en) | 2019-10-31 | 2019-10-31 | Device and method for creating form through Excel and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911050202.6A CN110888874B (en) | 2019-10-31 | 2019-10-31 | Device and method for creating form through Excel and storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110888874A CN110888874A (en) | 2020-03-17 |
| CN110888874B true CN110888874B (en) | 2022-07-08 |
Family
ID=69746637
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911050202.6A Active CN110888874B (en) | 2019-10-31 | 2019-10-31 | Device and method for creating form through Excel and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110888874B (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112328836A (en) * | 2020-10-20 | 2021-02-05 | 山东师范大学 | VBA-based graph instance generation method and system |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104504160A (en) * | 2015-01-20 | 2015-04-08 | 中国地质大学（武汉） | Excel document online batch write-in method based on SSH frame |
| CN109977383A (en) * | 2019-03-11 | 2019-07-05 | 湖南纬拓信息科技有限公司 | A kind of form information extracting method based on Excel |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20020023108A1 (en) * | 1999-09-09 | 2002-02-21 | Neil Daswani | Automatic web form interaction proxy |
-
2019
- 2019-10-31 CN CN201911050202.6A patent/CN110888874B/en active Active
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104504160A (en) * | 2015-01-20 | 2015-04-08 | 中国地质大学（武汉） | Excel document online batch write-in method based on SSH frame |
| CN109977383A (en) * | 2019-03-11 | 2019-07-05 | 湖南纬拓信息科技有限公司 | A kind of form information extracting method based on Excel |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110888874A (en) | 2020-03-17 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111367886B (en) | Method and device for data migration in database | |
| CN109558575B (en) | Online form editing method, online form editing device, computer equipment and storage medium | |
| CN109471851B (en) | Data processing method, device, server and storage medium | |
| US20040107387A1 (en) | Method and system for generically reporting events occurring within a computer system | |
| CN112287009A (en) | Interface calling and interface data warehousing method, device, equipment and storage medium | |
| CN110837471B (en) | Test method, test device, server and storage medium | |
| CN110740071A (en) | network interface monitoring method, device and system | |
| CN108140022B (en) | Data query method and database system | |
| CN110888874B (en) | Device and method for creating form through Excel and storage medium | |
| CN116561003A (en) | Test data generation method, device, computer equipment and storage medium | |
| CN113010588B (en) | Data form processing method | |
| CN114330278A (en) | Method and equipment for judging consistency of returned data | |
| CN109697141B (en) | Method and device for visual testing | |
| CN112363922B (en) | Test case generation method and related equipment thereof | |
| CN112597058B (en) | Webpage testing method, device, equipment and storage medium based on volume creation | |
| CN110765022B (en) | Method, device, computer equipment and storage medium for automatically testing sample sending SSD | |
| CN111414335B (en) | Data file searching method and device | |
| CN114327377B (en) | Method and device for generating demand tracking matrix, computer equipment and storage medium | |
| US11853312B1 (en) | Generation of feature stores | |
| CN112527891B (en) | Data storage method, device, equipment and storage medium | |
| CN116402029A (en) | Service information input method, device, computer equipment and storage medium | |
| CN118484371A (en) | Test script generation method, device, equipment and storage medium | |
| CN114780401A (en) | Interface testing method and device, computer equipment and storage medium | |
| CN116909876A (en) | Debugging method, debugging device, computer device, storage medium, and program product | |
| CN117251384A (en) | Interface automation test case generation method and system |
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 |