Ticket #432 (closed defect: fixed)

Opened 3 years ago

Last modified 3 years ago

import part of study design doesn't work properly

Reported by: janneke@… Owned by: t.w.abma@…
Priority: major Milestone: 0.8.1
Component: Import wizard Version: 0.8.0
Keywords: Cc:
Product: Operating system:
URL: Hardware:

Description

I created a new study on ci, 0001LINEA, and want to add subjects and/or samples.

Via Import, part of study design, I fill in steps in wizard (see attachment), however after uploading and chosing my properties wizard won't proceed to next step.
Link doesn't seem to work. (Encountered in chrome and ff)

I tried with following data

Subject no.		cohort	treatment	Gender	Age	White European Inc. Mediteranean & Arabic	Asian	Black	Height (m)	Weight (kg)	BMI 	Waist	Hip	Systolic	Diastolic	 Mean Heart Rate	RBG mmol / L
BESA / 001	N_001_BESA	1		F	46	1			1,69	75,3	26,4	84,0	113	118	69	63	4,2
WIDA / 002	N_002_WIDA	1		M	28	1			1,75	90,9	29,7	101,0	116	136	82		4,7
PHME /006	N_006_PHME	1		F	35			1	1,62	78,0	30	101,0	108	119	85		4,9
JOKA / 007	N_007_JOKA	1		F	51	1			1,61	76,9	29,6	91,0	111,5	110	87		4,7
TYJA / 008	N_008_TYJA	1		F	47	1			1,69	94,7	33,1	103,5	119,5	124	79		4,2

Attachments

2011_6mei_import wizard.png Download (100.7 KB) - added by janneke@… 3 years ago.
subjectdata.xlsx Download (14.3 KB) - added by janneke@… 3 years ago.

Change History

Changed 3 years ago by janneke@…

Changed 3 years ago by work@…

  • owner changed from work@… to t.w.abma@…
  • status changed from new to assigned

Changed 3 years ago by t.w.abma@…

  • owner changed from t.w.abma@… to jannekevdp@…

Fixed in revision 306, now supports Excel XML (XLSX) files with formulas, tested with the file testje-importer-bug.xlsx and testje2.xlsx.

Changed 3 years ago by janneke@…

  • owner changed from jannekevdp@… to t.w.abma@…

tested the above function (import part of study design, using subjectdata.xlsx, into study 0101-title01)

In step 3 I need to fill in species. However, when I select multiple columns only in the column I change the species is added (although I selected all columns).

And when not all rows have species defined, I can still proceed to the last step. However, in the last step I cannot click next (because of missing mappings in step 3).
Wizard should give notification in the previous step and not led me continue to step4

Changed 3 years ago by janneke@…

Changed 3 years ago by work@…

  • status changed from assigned to closed
  • resolution set to fixed
Note: See TracTickets for help on using tickets.