Example threads. These questions and answers were written by the SDODS team to document real problems and how to fix them. The people named are illustrative, not real users. Questions asked on this site are marked new.
I wrote Given I load dataset "users" row 5 because the account I want is on line 5 of the spreadsheet. Got:
DATASET_ROW_NOT_FOUND: Dataset "users" has 3 row(s); row 5 does not exist (0-based).Three rows? The file has four lines. And when I tried row 1 earlier it gave me the second person, not the first. So either the header counts or it does not, and I cannot work out which from the message.
Accepted answer
The header is not a row. The CSV is parsed with columns taken from the first line, so a four-line file has three rows, and the message is counting those.
Indexes are 0-based, so with three rows the valid ones are 0, 1 and 2. row 1 giving you the second person is correct and not an off-by-one — it is the second data row.
Positional lookup is fragile anyway, because it silently changes meaning the moment somebody sorts the file. Name the row instead:
Given I load dataset "users" where "username" is "problem_user"That fails with No row in dataset "users" where username = "problem_user". when the row is gone, which is a failure you can read, rather than quietly handing you a different account.
We banned row <n> in review after somebody alphabetised a CSV and three scenarios kept passing against the wrong accounts. where costs nothing and the step reads better out loud.
Wrap commands and output in triple backticks and they will render as a code block.
Checking whether you’re signed in…
Have a different question? Ask it.