We are performing a phasewise scheduled maintenance of our Zephyr for Jira Cloud and Capure for Jira Cloud instances to be compliant with GDPR- Atlassian privacy policy (https://www.atlassian.com/trust/privacy) .Please expect a downtime during this phase of maintenance from Saturday, 01/12/2019, 9:30 PM PST up until Sunday 01/13/2019, 9:30 AM PST.This will be for our phasewise deployment of infrastructure changes, migration utility verification and customer data migration, as part of our GDPR and Atlassian privacy policy compliance efforts.For any further queries regarding this please rasie a ticket by using the option 'Submit a Ticket' below
Support | Zephyr



Error: "Estimated Time is not valid"

Created on

Problem

Getting the following error when trying to import the testcases-

"Comments on: Jan 12, 2015 15:39:39
file:///C:/Program Files/Zephyr/zephyrdata/import/17/import_testcases.xls estimated time is not valid in row(s)' 7' and/or above"

Cause

'Estimated Time' Zephyr field value in the excel file is not in the dd:hh:mm format and unable to format Excel cell in that way(includes the calendar date in formula bar).

Is there a way of formatting the excel cell that would allow importing of excel file successfully along with the 'Estimated Time' field?

Fix

Please follow the below work around-

1) In the excel file, please select the Estimated time column "I"as shown in the below screenshot. Right click on it. Then go to "Format cells".

2) In Number tab, select "Text" then click on "OK" button. This will change the column data type to text.

3) Now try to import the excel file.

 

Knowledge Base Document Information:

------------------------------------------------------------------------------------------------------

Title : Getting the "Estimated Time is not valid" error while importing testcases.

Product : Zephyr.

Version : All

----------------------------------------------------------------------------------------------------


Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request
Powered by Zendesk