Ticket #67 (closed defect: invalid)

Opened 3 years ago

Last modified 3 years ago

importer should handle empty rows correctly

Reported by: janneke@… Owned by: taco@…
Priority: critical Milestone:
Component: Assay importer Version:
Keywords: Cc:
Product: Operating system:
URL: Hardware:

Description

I imported data which contained empty fields from 1 subject, so this resulted only in subject number and 3 empty fields behind (see below for test data)

The preview in step 5 is correct (see image)
However, in step 6 importer doesn't include subject 215 (see image2 and image3)

The importer should recognize the empty fields and still create a row for subject 215 in step6.

I used following data with study 'pps2', assay 'plasma', subject layout

muis	t=0 wk	t=4,5 wk 	t=8 wk 	t=12 wk
200	11,87	8,72	9,23	8,69
201	10,82	9,29	14,52	9,46
202	6,97	7,03	8,25	8,46
203	7,72	8,14	7,48	10,99
204	7,85	6,67	9,13	8,81
205	7,94	6,82	7,34	7,38
206	6,13	8,88	8,67	10,81
207	9,18	7,48	7,94	9,28
208	7,23	8,16	7,55	11,18
209	9,84	6,81	7,92	9,34
210	7,32	7,24	6,09	7,58
211	7,82	9,56	10,40	10,39
212	6,28	8,30	8,47	8,01
213	8,41	8,94	8,64	9,51
214	6,97	7,03	10,58	9,00
215				
216	6,64	7,48	9,08	7,26
217	6,18	9,88	7,81	8,28
218	5,87	7,62	8,41	8,72
219	6,97	8,10	6,33	7,62
220	8,58	7,32	9,16	10,19
221	7,16	7,05	10,68	11,33
222	7,23	5,60	5,24	5,01
223	5,45	6,49	8,20	7,63
224	6,45	4,52	5,73	5,02
225	9,82	6,91	8,68	8,87
226	6,62	8,09	9,87	7,98
227	8,53	8,53	9,80	8,25
228	7,85	5,09	7,79	7,98
229	12,12	7,37	9,74	8,60
230	9,61	6,78	9,03	10,15
231	7,16	7,59	7,77	8,71
232	10,37	8,59	8,62	8,97
233	9,40	7,17	7,74	9,26
234	11,02	12,18	13,14	11,29
235	6,25	7,81	7,67	9,27
236	8,74	5,86	8,28	8,20
237	5,80	9,38	5,59	6,90
238	5,75	7,59	5,71	5,99
239	5,23	5,85	6,27	5,37
240	6,99	5,19	5,72	6,83
241	6,82	6,44	8,04	6,01
242	6,62	7,01	7,12	6,97
243	10,43	6,19	7,36	6,62
244	7,86	7,21	9,23	6,98
245	6,97	6,49	6,54	8,30
246	5,37	5,15	3,86	4,10
247	15,72	12,30	13,20	17,43
248	5,24	4,30	3,65	4,39
249	5,94	4,92	6,41	5,59
250	6,48	5,22	8,13	6,06
251	6,62	4,83	7,04	6,69
252	8,57	3,79	8,89	9,07
253	6,78	6,56	6,45	8,66
254	11,83	9,32	9,42	16,12
255	6,85	7,83	6,67	10,39
256	6,77	6,53	8,29	12,12
257	6,39	6,65	7,03	10,79
258	8,84	10,88	9,31	9,13
259	6,58	8,26	8,77	9,57
260	8,64	6,90	9,08	8,78
261	8,10	8,61	8,89	12,25
262	7,49	7,48	6,76	6,92
263	5,78	6,65	8,33	8,73
264	4,41	5,75	5,05	6,05
265	6,21	7,82	7,33	8,92
266	5,05	5,61	5,83	6,77
267	6,36	5,64	6,26	7,46
268	4,93	5,57	7,84	7,97
269	10,57	6,62	7,53	8,22
270	7,52	7,52	7,10	7,80
271	8,97	8,42	9,71	8,52
272	6,62	10,92	9,54	10,25
273	5,67	6,46	8,47	9,51
274	10,82	8,43	10,46	10,10
275	5,64	6,48	8,30	10,88
276	9,93	11,33	7,74	11,16
277	6,81	9,40	7,51	10,23
278	8,27	6,41	6,91	9,06
279	8,04	10,40	8,87	9,40
280	8,22	8,02	8,48	9,72
281	5,49	7,05	7,49	9,46
282	8,44	7,49	9,30	8,84
283	5,77	6,74	7,28	11,36
284	6,17	7,46	9,78	11,10
285	8,00	8,31	9,19	10,99
286	8,59	9,58	11,22	9,74
287	8,90	8,37	8,19	10,06
288	8,84	11,90	8,72	8,74
289	6,25	8,24	7,89	9,79
290	5,93	6,61	8,56	6,65
291	5,68	6,74	5,35	6,30
292	6,25	5,28	5	6,76
293	7,49	8,86	7,53	7,97
294	5,86	5,77	6,13	8,78
295	7,45	6,03	8,80	9,94
296	5,10	4,56	5,14	7,75
297	5,89	7,50	6,71	7,18
298	5,65	6,54	6,01	7,38
299	6,56	6,60	6,74	9,28
300	5,71	6,29	6,83	7,94
301	7,69	5,26	6,75	8,33
302	5,98	5,81	7,75	7,93

Attachments

2011_8juni importer.png Download (27.1 KB) - added by janneke@… 3 years ago.
2011_8juni importer2.png Download (38.3 KB) - added by janneke@… 3 years ago.
2011_8juni importer3.png Download (7.2 KB) - added by janneke@… 3 years ago.

Change History

Changed 3 years ago by janneke@…

Changed 3 years ago by janneke@…

Changed 3 years ago by janneke@…

Changed 3 years ago by janneke@…

If only one cell is empty (one of three) then importer handles subject correctly

Changed 3 years ago by janneke@…

  • status changed from new to closed
  • resolution set to invalid

I wasn't aware subject 215 had no samples at all in SAM. So this ticket will be closed.

Importer works fine, when a subject has no measurements at all.

Note: See TracTickets for help on using tickets.