Mailing List - Entries of 2018

List Icon
Mailing list Archive

2019 up to July 2022 | 2018 | 2017  |  2016  | 2015 | 2014 | 2013

The mailing list has been closed since July 2022, but continues to serve as an archive of information about QF-Test.
If you want to stay informed about news about QF-Test, you can simply subscribe to our newsletter:
Subscribe to Newsletter  

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[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


We use "Matomo" cookies to anonymously evaluate your visit to our website. For this we need your consent, which is valid for twelve months. A revocation, so-called opt-out, is possible at any time on our privacy page.

accept
configuration
Cookie configuration

1. Functional cookies

We use functional cookies to ensure the basic functionality of the website.

2. Performance and statistic cookies

We use Matomo for analyzing and optimizing our website. Cookies permit an anonymous collection of information that help us offering you a clear and user-friendly visit of our web pages.

Confirm selection

Cookie details