A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Spreadsheet Import Examples | ||||||||||||||||
2 | This document uses a few examples to help you learn how to get your spreadsheet-based test plans into Testpad. | ||||||||||||||||
3 | Also check out the blog post for more discussion on these ideas | ||||||||||||||||
4 | The goal is to copy/paste a single column into Testpad. And to do that, you will most likely have to invent a new column that uses a formula to aggregate the other columns. | ||||||||||||||||
5 | The example columns in this doc all use Google Sheets formula. Everything here is possible in Excel too, but the function names are a bit different. | ||||||||||||||||
6 | Most of these examples are modelling "test cases", complete with steps and expected outcomes. If you are starting from scratch, writing new tests, then Testpad strongly recommends you don't go for Test Cases like this, and instead just list out simple/terse/concise prompts of what you want to test; more like a guide for exploratory testing than spelling out every action in minute detail - your test plans will be faster to write, easier to maintain, and the freedom to explore and experiment around each item will uncover more bugs than the fully presecriptive route. | ||||||||||||||||
7 | Don't hestitate to contact support@ontestpad.com if you have any questions or would like help with any of this - or go one step further and send in some sample spreadsheets (confidentiality assured) and we'll show you how best to import it. | ||||||||||||||||
8 | Example 1 | ||||||||||||||||
9 | IF YOUR TEST PLAN LOOKS A BIT LIKE THIS... | THEN YOU COULD MAKE A NEW DERIVED COLUMN LIKE THIS | WHICH WOULD IMPORT LIKE THIS | ||||||||||||||
10 | Title | Tests | COPY/PASTE THESE CELLS | ||||||||||||||
11 | 1 | Normal login | Normal login | ||||||||||||||
12 | Valid user name and password work | Valid user name and password work | |||||||||||||||
13 | User can login immediately after changing password | User can login immediately after changing password | |||||||||||||||
14 | Username with unicode characters works | Username with unicode characters works | |||||||||||||||
15 | User can login immediately after changing username | User can login immediately after changing username | |||||||||||||||
16 | 2 | Bad login | Bad login | ||||||||||||||
17 | Invalid user name is rejected | Invalid user name is rejected | |||||||||||||||
18 | Invalid password is rejected | Invalid password is rejected | |||||||||||||||
19 | Blank password is rejected | Blank password is rejected | |||||||||||||||
20 | Blank username is rejected | Blank username is rejected | |||||||||||||||
21 | =IF(ISTEXT(C11),C11,CONCATENATE(" ",D11)) | ||||||||||||||||
22 | Example 2 | ||||||||||||||||
23 | IF YOUR TEST PLAN LOOKS A BIT LIKE THIS... | THEN YOU COULD MAKE A NEW DERIVED COLUMN LIKE THIS | WHICH WOULD IMPORT LIKE THIS | ||||||||||||||
24 | Title | Steps | Expected Results | COPY/PASTE THESE CELLS | |||||||||||||
25 | 1 | Normal login | 1. Load /login page 2. Enter valid username 3. Enter valid password 4. Press enter | Login suceeds and test user's dashboard is displayed | Normal login 1. Load /login page 2. Enter valid username 3. Enter valid password 4. Press enter Login suceeds and test user's dashboard is displayed | ||||||||||||
26 | 2 | Bad login | 1. Load /login page 2. Enter valid username 3. Enter invalid password 4. Press enter | Login rejected, stays on ./login page with warning saying username or password wrong | Bad login 1. Load /login page 2. Enter valid username 3. Enter invalid password 4. Press enter Login rejected, stays on ./login page with warning saying username or password wrong | ||||||||||||
27 | 3 | Blank password | 1. Load /login page 2. Enter valid username 3. Ensure password empty 4. Press enter | Login rejected, stays on ./login page with warning saying username or password wrong | Blank password 1. Load /login page 2. Enter valid username 3. Ensure password empty 4. Press enter Login rejected, stays on ./login page with warning saying username or password wrong | ||||||||||||
28 | =CONCATENATE(C10," ",REGEXREPLACE(D10,"\n"," ")," ",E10) | ||||||||||||||||
29 | Example 3 | ||||||||||||||||
30 | IF YOUR TEST PLAN LOOKS A BIT LIKE THIS... | THEN YOU COULD MAKE A NEW COLUMN LIKE THIS | WHICH WOULD IMPORT LIKE THIS | ||||||||||||||
31 | Test ID | Reference | Title | Pre-conditions | Steps | Test Data | Expected Results | COPY/PASTE THESE CELLS | |||||||||
32 | T123 | https://some.jira.com/browse/REQ-123 | Normal login | Test account exists with known username and password | 1. Load /login page 2. Enter valid username 3. Enter valid password 4. Press enter | username: test1, password: pass2 | Login suceeds and test user's dashboard is displayed | T123 Normal login // ref: https://some.jira.com/browse/REQ-123 // assume: Test account exists with known username and password // use: username: test1, password: pass2 1. Load /login page 2. Enter valid username 3. Enter valid password 4. Press enter => Login suceeds and test user's dashboard is displayed | |||||||||
33 | T124 | https://some.jira.com/browse/REQ-123 | Bad login | Test account exists with known username and password | 1. Load /login page 2. Enter valid username 3. Enter invalid password 4. Press enter | username: test1, password: wrongpass | Login rejected, stays on ./login page with warning saying username or password wrong | T124 Bad login // ref: https://some.jira.com/browse/REQ-123 // assume: Test account exists with known username and password // use: username: test1, password: wrongpass 1. Load /login page 2. Enter valid username 3. Enter invalid password 4. Press enter => Login rejected, stays on ./login page with warning saying username or password wrong | |||||||||
34 | T125 | https://some.jira.com/browse/REQ-123 | Blank password | Test account exists with known username and password | 1. Load /login page 2. Enter valid username 3. Ensure password empty 4. Press enter | username: test1 | Login rejected, stays on ./login page with warning saying username or password wrong | T125 Blank password // ref: https://some.jira.com/browse/REQ-123 // assume: Test account exists with known username and password // use: username: test1 1. Load /login page 2. Enter valid username 3. Ensure password empty 4. Press enter => Login rejected, stays on ./login page with warning saying username or password wrong | |||||||||
35 | =CONCATENATE(B32," ",D32," // ref: ",C32," // assume: ",E32," // use: ",G32," ",REGEXREPLACE(F32,"\n"," ")," => ",H32) | ||||||||||||||||
36 | |||||||||||||||||
37 | |||||||||||||||||
38 | Example 3b | ||||||||||||||||
39 | IF YOUR TEST PLAN LOOKS A BIT LIKE THIS... | THEN YOU COULD MAKE 3 NEW COLUMNS LIKE THIS | WHICH WOULD IMPORT LIKE THIS | ||||||||||||||
40 | Test ID | Reference | Title | Pre-conditions | Steps | Test Data | Expected Results | COPY/PASTE THESE CELLS | |||||||||
41 | T123 | https://some.jira.com/browse/REQ123 | Normal login | Test account exists with known username and password | 1. Load /login page 2. Enter valid username 3. Enter valid password 4. Press enter | username: test1, password: pass2 | Login suceeds and test user's dashboard is displayed | Normal login --1. Load /login page --2. Enter valid username --3. Enter valid password --4. Press enter => Login suceeds and test user's dashboard is displayed | ABC | Test ID: T123 https://some.jira.com/browse/REQ123 Assumes: Test account exists with known username and password Test data: username: test1, password: pass2 | |||||||
42 | T124 | https://some.jira.com/browse/REQ123 | Bad login | Test account exists with known username and password | 1. Load /login page 2. Enter valid username 3. Enter invalid password 4. Press enter | username: test1, password: wrongpass | Login rejected, stays on ./login page with warning saying username or password wrong | Bad login --1. Load /login page --2. Enter valid username --3. Enter invalid password --4. Press enter => Login rejected, stays on ./login page with warning saying username or password wrong | HIGH | Test ID: T124 https://some.jira.com/browse/REQ123 Assumes: Test account exists with known username and password Test data: username: test1, password: wrongpass | |||||||
43 | T125 | https://some.jira.com/browse/REQ123 | Blank password | Test account exists with known username and password | 1. Load /login page 2. Enter valid username 3. Ensure password empty 4. Press enter | username: test1 | Login rejected, stays on ./login page with warning saying username or password wrong | Blank password --1. Load /login page --2. Enter valid username --3. Ensure password empty --4. Press enter => Login rejected, stays on ./login page with warning saying username or password wrong | LOW | Test ID: T125 https://some.jira.com/browse/REQ123 Assumes: Test account exists with known username and password Test data: username: test1 | |||||||
44 | =CONCATENATE(D41," --",REGEXREPLACE(F41,"\n"," --")," => ",H41) | =CONCATENATE("Test ID: ",A12," ",B12," Assumes: ",D12," Test data: ",F12) | |||||||||||||||
45 | |||||||||||||||||
46 | |||||||||||||||||
47 | |||||||||||||||||
48 | |||||||||||||||||
49 | |||||||||||||||||
50 | |||||||||||||||||
51 | |||||||||||||||||
52 | |||||||||||||||||
53 | |||||||||||||||||
54 | |||||||||||||||||
55 | |||||||||||||||||
56 | |||||||||||||||||
57 | |||||||||||||||||
58 | |||||||||||||||||
59 | |||||||||||||||||
60 | |||||||||||||||||
61 | |||||||||||||||||
62 | |||||||||||||||||
63 | |||||||||||||||||
64 | |||||||||||||||||
65 | |||||||||||||||||
66 | |||||||||||||||||
67 | |||||||||||||||||
68 | |||||||||||||||||
69 | |||||||||||||||||
70 | |||||||||||||||||
71 | |||||||||||||||||
72 | |||||||||||||||||
73 | |||||||||||||||||
74 | |||||||||||||||||
75 | |||||||||||||||||
76 | |||||||||||||||||
77 | |||||||||||||||||
78 | |||||||||||||||||
79 | |||||||||||||||||
80 | |||||||||||||||||
81 | |||||||||||||||||
82 | |||||||||||||||||
83 | |||||||||||||||||
84 | |||||||||||||||||
85 | |||||||||||||||||
86 | |||||||||||||||||
87 | |||||||||||||||||
88 | |||||||||||||||||
89 | |||||||||||||||||
90 | |||||||||||||||||
91 | |||||||||||||||||
92 | |||||||||||||||||
93 | |||||||||||||||||
94 | |||||||||||||||||
95 | |||||||||||||||||
96 | |||||||||||||||||
97 | |||||||||||||||||
98 | |||||||||||||||||
99 | |||||||||||||||||
100 |