How can i import the test data from excel spreadsheet in to a testcase while using ATF feature.

[Sandeep165]

How can i import the test data from excel spreadsheet in to a testcase while using ATF feature.

Do we have any approach on how to import the test data from excel sheet into a test cases in ATF?

Please do reply if anyone know about this question.

Thanks

[SaiRaviKiran Ak]

If you want to import test cases then make sure that you have "com.snc.test_mgmt" plugin activated in your instance.

Navigate to Test Management > Test Suites

Steps to Follow:

1)Create a Test Site with required name.

2)In your Excel(that you have prepared for your required table) add test suite field and give sys_id of a test suite that you created.

3)Navigate to System Import Sets > Load Data and import the excel by selecting the required "Import Set Table".

4)create a transform map to match the required fields by giving source table and Target table as required tables. Make sure you have to match the excel fields to the proper fields in the table.

5) click transform from the related link.

Thanks,

Ravi.

[Yuri Yoshinami]

Hi, Ravi and all the readers Does anyone know the way to import/export the test data from the Excel spreadsheet into a test case? I read the Ravi's answer but still don't get it. 1. Why do you navigate to "Test Management > Test Suites" , not navigate to "Automated Test Framework > Test Suit"? 2. According to the #2 i have created the column for sys_id and filled in the sys_id number of a test suite, but the result looks like the the test column has skipped and filled blank. Regards, Yuri

[Yuri Yoshinami]

Hi, Ravi 

Could you tell me the way to import/export the test data from the Excel spreadsheet into a test case?

I read your answer but still don't get it.

1. Why do you navigate to "Test Management > Test Suites" , not navigate to "Automated Test Framework > Test Suit"?

2. According to the #2 i have created the column for sys_id and filled in the sys_id number of a test suite.and I found the result making the new test column with the blank context. 

I want to edit the text content in Excel file and import it.

Regards,

Yuri  

[tsylte]

Did you come up with a good solution for this? I would just like to get some data into an array for testing purposes, from a spreadsheet. This import solution would require creation of a new table and wouldn't be very flexible from test to test as every situation might require different fields on import. 

In my use case I have three spreadsheets outlining the format of a very large ascii file which is white-space delimited. I'd like to develop an automated test that validates spaces / constant values / field values when the output file is created, to test the parsing routines for this. So I would need 3 import maps and three tables to track the data? 

Any insight you can share would be appreciated!