[QF-Test] How do I update and existing value in a CSV file?

Subject: [QF-Test] How do I update and existing value in a CSV file?
From: Mike Harper <mharpsnz@?.com>
Date: Thu, 20 Sep 2018 14:23:22 +1200
Delivered-to: qftest-list@?.net
Dkim-signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:from:date:message-id:subject:to; bh=nZSTJoiFVpM79Rw8YICUQC1IOayEteUXZ7caVltnRsU=; b=tZPm3PaFPdsGnzgj9YTtLAttHcx14z1gzLPW5FvtcvQbFuoyc+W4tiCM3wYczrv+it iynaujXER7yy8nMywkkfLoAPpDQ9Q6ysi25e8ueWfmuUPHtcmfsS/SS/fJGX8H9Cjfgb 2jAT3gmfao5AP5svfkkSI0wc0zHqC8FmIN6G4mspcUKbQiiccccsnJyeuwLpx3JF9vrv E8CmID5x4S4EIopA6cfsMTZdy+agsri61BpcW7FdAzwy8ByrPlGFDCl1PC4Yhz54Reec vLb7YjG5NO+srQy2Vg2zZZ+8a6zq7h0LgX9Zxf6L61O5vb8ZfqAbEjpEP59ZblBwo8Ed 8jyA==

Hi,

I am very new to QF-Test, Groovy, _javascript_ etc. and am finding it incredibly difficult finding out how I can update an existing value in a CSV file.

I have searched the archives but can't find anything that shows me how to do this.

My test uses a CSV Data File to pull in the CSV file values.

The CSV data contains two rows:

CIVPart1;CIVPart2
CIV-2018-025-;000001

These values are strung together then a SQL statement is used to see if the full CIV Number can be found in the Database.

If found to exist, I add 1 to the CIVPart2 value and check again - doing this until a record is not found in the database.

I then need to add 1 to the calculated CIVPart2 value and write it back to the CIV file so that when the test runs again, the SQL statement won't reuse values that have already been proven to exist.

I am thinking I need to use aServer Script to achieve the required result. Have been using Groovy to date.

So, can someone step me through the coderequired to update the existing CSV file so that it contains the new value please? (Am almost bald from pulling my hair out)

Thanks in advance for your help.

Mike

Follow-Ups:
- Re: [QF-Test] How do I update and existing value in a CSV file?
  - From: Yann Spoeri, QFS Support

Prev by Date: [QF-Test] QF-Test version 4.3.2 released
Next by Date: Re: [QF-Test] How do I update and existing value in a CSV file?
Previous by thread: [QF-Test] QF-Test version 4.3.2 released
Next by thread: Re: [QF-Test] How do I update and existing value in a CSV file?
Index(es):
- Date
- Thread