Using the csv upload feature
Using the ‘csv upload’ feature to simplify complex experiments
Replicate 1
Example experiment Evaluate 120 lines of a crop under both full irrigation and drought stress You plant your crop in pots, with 3 plants in each pot You plant 480 total pots, with 40 pots in each row. Each line planted under full irrigation and drought stress in each replicate (right)
Row 1 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40
Full Irrigation Row 2 Row 3 41 81 42 82 43 83 44 84 45 85 46 86 47 87 48 88 49 89 50 90 51 91 52 92 53 93 54 94 55 95 56 96 57 97 58 98 59 99 60 100 61 101 62 102 63 103 64 104 65 105 66 106 67 107 68 108 69 109 70 110 71 111 72 112 73 113 74 114 75 115 76 116 77 117 78 118 79 119 80 120
Row 4 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160
North Drought Stress Row 5 Row 6 161 201 162 202 163 203 164 204 165 205 166 206 167 207 168 208 169 209 170 210 171 211 172 212 173 213 174 214 175 215 176 216 177 217 178 218 179 219 180 220 181 221 182 222 183 223 184 224 185 225 186 226 187 227 188 228 189 229 190 230 191 231 192 232 193 233 194 234 195 235 196 236 197 237 198 238 199 239 200 240
Row 8 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280
Replicate 2 Full Irrigation Row 9 Row 10 Row 11 281 321 361 282 322 362 283 323 363 284 324 364 285 325 365 286 326 366 287 327 367 288 328 368 289 329 369 290 330 370 291 331 371 292 332 372 293 333 373 294 334 374 295 335 375 296 336 376 297 337 377 298 338 378 299 339 379 300 340 380 301 341 381 302 342 382 303 343 383 304 344 384 305 345 385 306 346 386 307 347 387 308 348 388 309 349 389 310 350 390 311 351 391 312 352 392 313 353 393 314 354 394 315 355 395 316 356 396 317 357 397 318 358 398 319 359 399 320 360 400
Drought Stress Row 12 Row 13 401 441 402 442 403 443 404 444 405 445 406 446 407 447 408 448 409 449 410 450 411 451 412 452 413 453 414 454 415 455 416 456 417 457 418 458 419 459 420 460 421 461 422 462 423 463 424 464 425 465 426 466 427 467 428 468 429 469 430 470 431 471 432 472 433 473 434 474 435 475 436 476 437 477 438 478 439 479 440 480
Challenges in the PhotosynQ platform • How to add all the key information (genotype, irrigation type, and replicate) to the PhotosynQ platform without the data collectors spending a long time answering each project question in the field. • Multiple choice answers: users are forced to scroll through a long list of genotypes. • Short answer: users need to type in genotype information. This is time consuming and can be prone to errors.
• Another option is to upload a csv file with the key questions and answers that you want on the PhotosynQ platform
Building a csv for upload
Creating questions • When we upload the csv to the PhotosynQ website, it will extract the first row as the question, and subsequent rows has answers. • In the example from the previous section, the website will automatically generate 4 questions: POT #, Genotype, Irrigation, Replicate POT # 1 2 3 4 5 6 7
Genotype ADP0634 ADP0027 ADP0033 ADP0629 ADP0667 ADP0600 ADP0669
Irrigation Replicate Full 1 Full 1 Full 1 Full 1 Full 1 Full 1 Full 1
Getting the order right • You will need to order CSV based on the order that you will walk thru the field, this may not be in numerical order. • To save time walking in the field, you will probably want to walk up one row, and then down the next row in the opposite direction (right). • The order of the rows in the csv file should represent this order, and not simply numerical order 37 38 39 40 80 79 78
ADP0029 ADP0390 ADP0021 ADP0277 ADP0435 ADP0479 ADP0677
Full Full Full Full Full Full Full
1 1 1 1 1 1 1
Row 1 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40
Replicate 1 Full Irrigation Row 2 Row 3 Row 4 41 81 121 42 82 122 43 83 123 44 84 124 45 85 125 46 86 126 47 87 127 48 88 128 49 89 129 50 90 130 51 91 131 52 92 132 53 93 133 54 94 134 55 95 135 56 96 136 57 97 137 58 98 138 59 99 139 60 100 140 61 101 141 62 102 142 63 103 143 64 104 144 65 105 145 66 106 146 67 107 147 68 108 148 69 109 149 70 110 150 71 111 151 72 112 152 73 113 153 74 114 154 75 115 155 76 116 156 77 117 157 78 118 158 79 119 159 80 120 160
Switching the order easily in excel The easiest way to get the order right is to use the ‘custom sort’ function in excel. In this case, we want to reverse the order of Pot’s 121 to 160. 1) Select the desired range, 2) select the ‘custom sort’ option, 3) in the dialogue box select the column to sort by (in this case column A), and 4) under ‘Order’ select ‘largest to smallest’
Important notes • This example assumes that each data collector is only collecting 1 measurement per pot. • If each data collector is collecting multiple measurements (for example multiple leaves per plant) then the csv needs to include that information 39 ADP0021 Full 1 top 39 40 40 80 80 79 79
ADP0021 ADP0277 ADP0277 ADP0435 ADP0435 ADP0479 ADP0479
Full Full Full Full Full Full Full
1 1 1 1 1 1 1
middle top middle top middle top middle
Creating the project questions on the PhotosynQ website
At the questions page, select ‘Upload Questions/Answers from spreadsheet (.csv)
Follow the directions to drag and drop your csv. Once uploaded, the website will automatically generate questions. (You are free to add other questions besides those in the .csv)
Collecting data in the field using answered uploaded from csv’s
Select auto-increment • In the PhotosynQ app, load your project and connect to a device • Once you select ‘take measurement’ your first question will appear • Check the ‘auto-increment’ box
Choose where to start • Let’s say that multiple people are planning on collecting data at the same time and are starting at different locations in the field. • Once ‘auto-increment’ has been checked, a screen will pop up allowing you to choose your starting point (near right) • If you are going to start at pot # 81, scroll down and select pot # 81 (far right).
Choose where to start • Now you will need to repeat the same process with the genotype, irrigation, and replicate questions • The bold number on the left are the answer number, and help to ensure that your answers are properly aligned
Taking measurements • After each measurement, the PhotosynQ mobile app will automatically input the next answers when you select ‘new measurement’
Replicate 1
Example experiment Evaluate 120 lines of a crop under both full irrigation and drought stress You plant your crop in pots, with 3 plants in each pot You plant 480 total pots, with 40 pots in each row. Each line planted under full irrigation and drought stress in each replicate (right)
Row 1 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40
Full Irrigation Row 2 Row 3 41 81 42 82 43 83 44 84 45 85 46 86 47 87 48 88 49 89 50 90 51 91 52 92 53 93 54 94 55 95 56 96 57 97 58 98 59 99 60 100 61 101 62 102 63 103 64 104 65 105 66 106 67 107 68 108 69 109 70 110 71 111 72 112 73 113 74 114 75 115 76 116 77 117 78 118 79 119 80 120
Row 4 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160
North Drought Stress Row 5 Row 6 161 201 162 202 163 203 164 204 165 205 166 206 167 207 168 208 169 209 170 210 171 211 172 212 173 213 174 214 175 215 176 216 177 217 178 218 179 219 180 220 181 221 182 222 183 223 184 224 185 225 186 226 187 227 188 228 189 229 190 230 191 231 192 232 193 233 194 234 195 235 196 236 197 237 198 238 199 239 200 240
Row 8 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280
Replicate 2 Full Irrigation Row 9 Row 10 Row 11 281 321 361 282 322 362 283 323 363 284 324 364 285 325 365 286 326 366 287 327 367 288 328 368 289 329 369 290 330 370 291 331 371 292 332 372 293 333 373 294 334 374 295 335 375 296 336 376 297 337 377 298 338 378 299 339 379 300 340 380 301 341 381 302 342 382 303 343 383 304 344 384 305 345 385 306 346 386 307 347 387 308 348 388 309 349 389 310 350 390 311 351 391 312 352 392 313 353 393 314 354 394 315 355 395 316 356 396 317 357 397 318 358 398 319 359 399 320 360 400
Drought Stress Row 12 Row 13 401 441 402 442 403 443 404 444 405 445 406 446 407 447 408 448 409 449 410 450 411 451 412 452 413 453 414 454 415 455 416 456 417 457 418 458 419 459 420 460 421 461 422 462 423 463 424 464 425 465 426 466 427 467 428 468 429 469 430 470 431 471 432 472 433 473 434 474 435 475 436 476 437 477 438 478 439 479 440 480
Challenges in the PhotosynQ platform • How to add all the key information (genotype, irrigation type, and replicate) to the PhotosynQ platform without the data collectors spending a long time answering each project question in the field. • Multiple choice answers: users are forced to scroll through a long list of genotypes. • Short answer: users need to type in genotype information. This is time consuming and can be prone to errors.
• Another option is to upload a csv file with the key questions and answers that you want on the PhotosynQ platform
Building a csv for upload
Creating questions • When we upload the csv to the PhotosynQ website, it will extract the first row as the question, and subsequent rows has answers. • In the example from the previous section, the website will automatically generate 4 questions: POT #, Genotype, Irrigation, Replicate POT # 1 2 3 4 5 6 7
Genotype ADP0634 ADP0027 ADP0033 ADP0629 ADP0667 ADP0600 ADP0669
Irrigation Replicate Full 1 Full 1 Full 1 Full 1 Full 1 Full 1 Full 1
Getting the order right • You will need to order CSV based on the order that you will walk thru the field, this may not be in numerical order. • To save time walking in the field, you will probably want to walk up one row, and then down the next row in the opposite direction (right). • The order of the rows in the csv file should represent this order, and not simply numerical order 37 38 39 40 80 79 78
ADP0029 ADP0390 ADP0021 ADP0277 ADP0435 ADP0479 ADP0677
Full Full Full Full Full Full Full
1 1 1 1 1 1 1
Row 1 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40
Replicate 1 Full Irrigation Row 2 Row 3 Row 4 41 81 121 42 82 122 43 83 123 44 84 124 45 85 125 46 86 126 47 87 127 48 88 128 49 89 129 50 90 130 51 91 131 52 92 132 53 93 133 54 94 134 55 95 135 56 96 136 57 97 137 58 98 138 59 99 139 60 100 140 61 101 141 62 102 142 63 103 143 64 104 144 65 105 145 66 106 146 67 107 147 68 108 148 69 109 149 70 110 150 71 111 151 72 112 152 73 113 153 74 114 154 75 115 155 76 116 156 77 117 157 78 118 158 79 119 159 80 120 160
Switching the order easily in excel The easiest way to get the order right is to use the ‘custom sort’ function in excel. In this case, we want to reverse the order of Pot’s 121 to 160. 1) Select the desired range, 2) select the ‘custom sort’ option, 3) in the dialogue box select the column to sort by (in this case column A), and 4) under ‘Order’ select ‘largest to smallest’
Important notes • This example assumes that each data collector is only collecting 1 measurement per pot. • If each data collector is collecting multiple measurements (for example multiple leaves per plant) then the csv needs to include that information 39 ADP0021 Full 1 top 39 40 40 80 80 79 79
ADP0021 ADP0277 ADP0277 ADP0435 ADP0435 ADP0479 ADP0479
Full Full Full Full Full Full Full
1 1 1 1 1 1 1
middle top middle top middle top middle
Creating the project questions on the PhotosynQ website
At the questions page, select ‘Upload Questions/Answers from spreadsheet (.csv)
Follow the directions to drag and drop your csv. Once uploaded, the website will automatically generate questions. (You are free to add other questions besides those in the .csv)
Collecting data in the field using answered uploaded from csv’s
Select auto-increment • In the PhotosynQ app, load your project and connect to a device • Once you select ‘take measurement’ your first question will appear • Check the ‘auto-increment’ box
Choose where to start • Let’s say that multiple people are planning on collecting data at the same time and are starting at different locations in the field. • Once ‘auto-increment’ has been checked, a screen will pop up allowing you to choose your starting point (near right) • If you are going to start at pot # 81, scroll down and select pot # 81 (far right).
Choose where to start • Now you will need to repeat the same process with the genotype, irrigation, and replicate questions • The bold number on the left are the answer number, and help to ensure that your answers are properly aligned
Taking measurements • After each measurement, the PhotosynQ mobile app will automatically input the next answers when you select ‘new measurement’
