[Upload] Upload excel template data in a Dataset (update) - Fail

[DavidBlaa]

Precondition

- at least one dataset with a structured data structure

- user has entity permission right to edit the dataset

- downloaded template with data to upload

Steps to Reproduce:

Step	Action	Expected	Status
1	Navigate to Collect/Upload Data and click the tabular button		Pass
2	Click on the Select button to upload the template	You must be able to upload a template file.	Pass
3	Select a valid file and click on the Next button.	You have to go to the next step.	Pass
4	Select an existing dataset from the select drop-down list to attach your file with.	You have to find your Dataset in the list.	Pass
5	Click Next Button	You have to go to the next step.	Pass
6	Tick one or more variable to define them as primary key. Then click on the Check button.	If the group selected was unique in your file, you can continue. If not you have to see a warning message.	Pass
7	Click Next Button	You have to go to the next step.	Pass
8	Click on the Validate button.	If The template file matches with the Dataset, you can continue. If not you must see a warning message.	Fail
9	Click on the Next button.	You have to see a Summary.	Fail
10	Click Finish Button	- load the details view of the dataset with uploaded data	Fail

[DavidBlaa]

https://bexis2.testquality.com defect D110. Do not remove or edit.

[DavidBlaa]

if text was defined in excel, only the shared string datatype was considered. this caused that string cells were tried to be converted to numbers, this failed and therefore an empty string was returned and the validation could not work with the further variable information.