I have a spreadsheet where on each line I register a test case and then export it to XML, and then upload this xml to another system we use.
The problem is that I can only do 1 to 1, I can not fill several rows and then export all, when I do this the XML exports only the first row and nothing else or gives an error that I can not handle.
Currently exporting this way:
<testcases>
<testcase internalid="980" name="Caso de testes Importação">
<node_order><![CDATA[100]]></node_order>
<externalid><![CDATA[1]]></externalid>
<version><![CDATA[1]]></version>
<summary><![CDATA[<p> O caso de teste deve fazer isso </p>]]></summary>
<preconditions><![CDATA[<p> <a id="fck_paste_padding"></a> Pré Condições od caso de testes</p>]]></preconditions>
<execution_type><![CDATA[1]]></execution_type>
<importance><![CDATA[2]]></importance>
<steps>
<step>
<step_number><![CDATA[1]]></step_number>
<actions><![CDATA[<p> A1</p>]]></actions>
<expectedresults><![CDATA[<p> EXC1</p>]]></expectedresults>
<execution_type><![CDATA[1]]></execution_type>
</step>
<step>
<step_number><![CDATA[2]]></step_number>
<actions><![CDATA[<p> A2</p>]]></actions>
<expectedresults><![CDATA[<p> EXC2</p>]]></expectedresults>
<execution_type><![CDATA[2]]></execution_type>
</step>
</steps>
</testcase>
</testcases>
But I need to export it this way:
<testcases>
<!-- Aqui começa o caso de teste 1 -->
<testcase internalid="980" name="Caso de testes Importação">
<node_order><![CDATA[100]]></node_order>
<externalid><![CDATA[1]]></externalid>
<version><![CDATA[1]]></version>
<summary><![CDATA[<p> O caso de teste deve fazer isso </p>]]></summary>
<preconditions><![CDATA[<p> <a id="fck_paste_padding"></a> Pré Condições od caso de testes</p>]]></preconditions>
<execution_type><![CDATA[1]]></execution_type>
<importance><![CDATA[2]]></importance>
<steps>
<step>
<step_number><![CDATA[1]]></step_number>
<actions><![CDATA[<p> A1</p>]]></actions>
<expectedresults><![CDATA[<p> EXC1</p>]]></expectedresults>
<execution_type><![CDATA[1]]></execution_type>
</step>
<step>
<step_number><![CDATA[2]]></step_number>
<actions><![CDATA[<p> A2</p>]]></actions>
<expectedresults><![CDATA[<p> EXC2</p>]]></expectedresults>
<execution_type><![CDATA[2]]></execution_type>
</step>
</steps>
</testcase>
<!-- Aqui Termina o caso de teste 1 -->
<!-- Aqui começa o caso de teste 2 -->
<testcase internalid="981" name="Caso de testes Importação">
<node_order><![CDATA[100]]></node_order>
<externalid><![CDATA[2]]></externalid>
<version><![CDATA[1]]></version>
<summary><![CDATA[<p> O caso de teste deve fazer isso </p>]]></summary>
<preconditions><![CDATA[<p> <a id="fck_paste_padding"></a> Pré Condições od caso de testes</p>]]></preconditions>
<execution_type><![CDATA[1]]></execution_type>
<importance><![CDATA[2]]></importance>
<steps>
<step>
<step_number><![CDATA[1]]></step_number>
<actions><![CDATA[<p> A1</p>]]></actions>
<expectedresults><![CDATA[<p> EXC1</p>]]></expectedresults>
<execution_type><![CDATA[1]]></execution_type>
</step>
<step>
<step_number><![CDATA[2]]></step_number>
<actions><![CDATA[<p> A2</p>]]></actions>
<expectedresults><![CDATA[<p> EXC2</p>]]></expectedresults>
<execution_type><![CDATA[2]]></execution_type>
</step>
</steps>
</testcase>
<!-- Aqui Termina o caso de teste 2 -->
</testcases>
Spreadsheetstructure: