Import and Export Snippets From Keyword-Driven Spreadsheets

As test engineer, you may want to use a keyword-driven framework to maintain an abstract definition of test cases in spreadsheets. With , you can import rows and columns in spreadsheet formats, automate their generation through a flow, and export them in a format that you can process further. 
ard210
As test engineer, you may want to use a keyword-driven framework to maintain an abstract definition of test cases in spreadsheets. With 
Agile Requirements Designer
, you can import rows and columns in spreadsheet formats, automate their generation through a flow, and export them in a format that you can process further. 
The alternative to maintaining data in tables is the default entry method where you type (rather, copy and paste) snippets into a text field.
Follow these steps:
 
  1. Click 
    File
    Configuration
    Automation
  2. Click the 
    Layers
     tab and choose 
    Spreadsheet
     from the 
    Select Entry
     combobox.
    You have switched from the default text entry method to a table-based entry method.
  3. Click the 
    Objects & Actions
     tab, and select an action.
  4. Use 
    one
     of the following methods to input the code snippets.
    Note:
     The buttons only appear if you have switched the 
    Select Entry
     type to 
    Spreadsheet
     on the 
    Layers
     tab.
    • CSV:
      1. Click 
        Import
      2. Choose 
        CSV
         format depending on the input file type. 
      3. Copy the CSV data into the clipboard and press ctrl-V to paste the data into the import dialog. 
      4. Click 
        Import
        .
        The rows and columns are associated with the action.
    • Excel Spreadsheet:
      1. Open your spreadsheet, and copy the data into the clipboard.
      2. Return to the dialog in 
        Agile Requirements Designer
        .
      3. Click 
        Paste Table Data
        , or select a cell and press ctrl-V.
        The rows and columns are associated with the action.
  5. (Optional) If you need to change the number of columns or rows, click 
    Resize Table
     on the 
    Objects & Actions
     tab. 
  6. Insert your variables into cells and replace static text where applicable.
After you have defined your automation configuration and flow properties, you associate actions with keywords. Each block in the flow has a properties window where you define the action's automation parameters. 
Follow these steps:
 
  1. Open a flow, right-click a block in the flow, and click 
    Edit Items
    . Go to the 
    Automation
     tab. 
  2. Add the required automation in the blocks' 
    Output Details
     tabs. In the case of a decision block, add automation for each output. 
  3. Define the script parameters:
    • Object Type: 
      Text Field
    • Action: 
      Input Text
    • Define the value of the variable. Do one of the following:
      • Type a constant value.
      • Use a test data variable.
      • Edit a resolvable value in Data Painter.
        Note:
         Test data variables can have only one value within a path, even if a Data Painter function is used. If you need a unique value for each occurrence of the variable in the path, use a Data Painter function directly in the block.
  4. Review the generated paths:
    1. Open the 
      Path Explorer
      , click 
      Start Optimization
       and optimize paths. 
    2. Click 
      Store Path
      .
    3. Go to the tab containing the stored paths. 
    4. Click the 
      Automation
       tab to review the fully substituted rows and columns for each block for each selected path. 
After you have reviewed the output, you can generate and export keyword-driven spreadsheets.
Follow these steps:
 
  1. Go back to the 
    Generate
     tab and click 
    Export Paths
    .
  2. Define a file name for the output file.
  3. Choose 
    Spreadsheets
     from the drop-down, and click 
    Export
    .