Forum Discussion

sheba0907's avatar
sheba0907
Occasional Contributor
8 years ago

Why did my steps not separate into their own "step" after importing a CSV file?

I imported a CSV file from Excel. In the Excel spreadsheet, (before converting to CSV), all my steps were in one cell with a carriage return after each step so that each step would display on its o...
CSV
Import
Manual Tests
  • Nastya_Khovrina's avatar
    Nastya_Khovrina
    8 years ago

    Hi Sheilagh,

     

    There are two different CSV layouts that can be imported, controlled by a system setting: one where each row represents a single test, with Steps in one cell, or one where each row represent a step within a test (Importing and Exporting Tests). It looks like, currently, you have the second one. So, you can modify your imported CSV file, or change the import profile.

     

    If you use On-Premise edition of QAC, you may change the import profile in System Preferences. 

    To change the import profile setting, click Setup at the upper right of the menu bar and go to System Configuration > System Preferences. Use the Quick Search to find "ImportTestSteps-LineBreaks" in the Code field. Change the value from N to Y.

     

    If you use SaaS edition of QAC, please contact Support to change the import profile.

     

Nastya_Khovrina's avatar
Nastya_Khovrina
SmartBear Alumni (Retired)
8 years ago

Hi Sheilagh,

 

There are two different CSV layouts that can be imported, controlled by a system setting: one where each row represents a single test, with Steps in one cell, or one where each row represent a step within a test (Importing and Exporting Tests). It looks like, currently, you have the second one. So, you can modify your imported CSV file, or change the import profile.

 

If you use On-Premise edition of QAC, you may change the import profile in System Preferences. 

To change the import profile setting, click Setup at the upper right of the menu bar and go to System Configuration > System Preferences. Use the Quick Search to find "ImportTestSteps-LineBreaks" in the Code field. Change the value from N to Y.

 

If you use SaaS edition of QAC, please contact Support to change the import profile.