Load one excel for multiple tables

[Lean S]

Hi All,

I am working on import sets and transform maps. I wanted to load one excel sheet for loading in multiple tables.

This is for loading into test case and related test case steps instance

Under test plan I have to load test cases as first step and second I have to map to test case -> test case step

so from one excel sheet 

test plan -> I have load test cases

test case -> to load its related test case steps.

How can achieve using one excel sheet. Any specific coding needed for this.

Thanks,

Lean S

[Lean S]

Hi Asifnoor,

My 2 tables are Test Case and Test Case Instance. Requirement is like to use only excel sheet to load records in this 2 tables in sequence. 

So 1st transform map is loaded to Test case table. 

excel sheet has following columns like Test Case name, short description, Status, Condtions, Test case instance description, Actual Output, expected output etc.,

Now when I load to 1st table record gets created as TC12345, but I dont have this reference in excel sheet, so we have to connect it in sequence to load with one common field that is Test case instance description field (which is common field in both)

and new record should be created in 2nd table (Test Case instance) which should be under TC12345. 

Thanks,

Lean S

[asifnoor]

Okay.

Not sure if the reference is through that text field. Because if that is the case, then when you do the import in 2nd table, since instance description field is already there, it would have referenced it correctly.

Can you manually create 1 record in test case instance table and mention the test case instance description of any one of the existing test case entry and confirm if it is showing under that test case or not.

Alternatively go to test case instance table and check what all columns exist. See if there is any reference column that is referring to test case table.

[Lean S]

Hi,

I cannot see as such fields which is referring to test case table but only have the extended fields that shows parent record numbers in Test case instance table.

Is there any way with out reference field can we connect this current record to TC12345 test case table. like that for every record we can insert same way.

Please help with way to map it .

Thanks,

Lean S

[asifnoor]

Hi,

To identify relationship my suggestion is create 1 record manually.

Go to test case table and create 1 record.

Then check how to add test steps from that record and add 1 test step

go to system definition -> Tables and open the table. Then under columns check all columns which has reference field. Add all those columns to list layout and check the data and see if any of those is having test case data.

Also, check if the test case table has any reference to test step data. Reference between the tables can be in either of those.

[Lean S]

Hi Asifnoor,

I can see that they are connected by some extended fields which are greyed out on form (in that we have string fields). Test Case number field is referred and it is displayed in read only. So we have to connect this when a record created in Test Case table TC12345 then script should do like to load this 2nd transform record under TC12345.

Kindly suggest help in this.

Thanks,

Lean S