storeText missed one cell from table 77x5

I think I found a bug in Kantu v4.1.6, Firefox 66.0.2, Linux 18.04.2
While scraping a table, one particular cell was not extracted properly.
The table had 77 rows x 5 cells. The problem occurred on row 6 in the first cell.

The table is a list of rates of investment funds. The cells are:
Security,Regio,Categorie,Aanbieder,Koers

for the !csvLine I added a row-counter as first field and a date as last field. So the CSV output looks like this:
Record,Security,Regio,Categorie,Aanbieder,Koers,Datum

Text in the cell:
Amundi Equity US Relative Value - C

Text in the CSV:
C
Also note that the CSV has only 75 rows. The last two are missing, but lets concentrate on the above issue first.

Just let me know what additional info you need.
Cheers…

Script (username and password are hidden):
{
“Name”: “Binck Open 085 v03”,
“CreationDate”: “2019-4-4”,
“Commands”: [
{
“Command”: “bringBrowserToForeground”,
“Target”: “”,
“Value”: “”
},
{
“Command”: “store”,
“Target”: “FundRates”,
“Value”: “csv_filename”
},
{
“Command”: “storeEval”,
“Target”: “var now = new Date(); var m=(‘0’+(now.getMonth()+1)).slice(-2); var d=(‘0’+now.getDate()).slice(-2); now.getFullYear()+m+d;”,
“Value”: “CalDate”
},
{
“Command”: “store”,
“Target”: “MEDIUM”,
“Value”: “!replayspeed”
},
{
“Command”: “store”,
“Target”: “9999”,
“Value”: “!TIMEOUT_MACRO”
},
{
“Command”: “open”,
“Target”: “https://www.binck.nl”,
“Value”: “”
},
{
“Command”: “comment”,
“Target”: “Website opened, try to login”,
“Value”: “”
},
{
“Command”: “clickAndWait”,
“Target”: “id=cpMainNavigation_T29FEFC66048_ctl00_ctl00_lblLogin”,
“Value”: “”
},
{
“Command”: “type”,
“Target”: “id=UserName”,
“Value”: “xxxxxxxxx”
},
{
“Command”: “type”,
“Target”: “id=Password”,
“Value”: “"
},
{
“Command”: “clickAndWait”,
“Target”: "xpath=//
[@id=“loginForm”]/fieldset/ol/li[5]/button",
“Value”: “”
},
{
“Command”: “click”,
“Target”: “link=Inloggen zonder code”,
“Value”: “”
},
{
“Command”: “comment”,
“Target”: “Login done”,
“Value”: “”
},
{
“Command”: “clickAndWait”,
“Target”: "xpath=//
[@id=“secondary-nav-left”]/li[2]/a/span",
“Value”: “”
},
{
“Command”: “clickAndWait”,
“Target”: “link=Selecteer een regio”,
“Value”: “”
},
{
“Command”: “clickAndWait”,
“Target”: “link=Selecteer”,
“Value”: “”
},
{
“Command”: “open”,
“Target”: “https://web.binck.nl/SecuritySearch?filterMode=Region&filterId=4120”,
“Value”: “”
},
{
“Command”: “store”,
“Target”: “FAST”,
“Value”: “!replayspeed”
},
{
“Command”: “comment”,
“Target”: “Header Data”,
“Value”: “”
},
{
“Command”: “store”,
“Target”: “Record”,
“Value”: “!csvLine”
},
{
“Command”: “storeText”,
“Target”: "xpath=//
[@id=“SecuritiesResultTable”]/thead/tr/th[1]/span",
“Value”: “!csvLine”
},
{
“Command”: “storeText”,
“Target”: "xpath=//
[@id=“SecuritiesResultTable”]/thead/tr/th[2]/span",
“Value”: “!csvLine”
},
{
“Command”: “storeText”,
“Target”: "xpath=//
[@id=“SecuritiesResultTable”]/thead/tr/th[3]/span",
“Value”: “!csvLine”
},
{
“Command”: “storeText”,
“Target”: "xpath=//
[@id=“SecuritiesResultTable”]/thead/tr/th[4]/span”,
“Value”: “!csvLine”
},
{
“Command”: “storeText”,
“Target”: “xpath=//[@id=“SecuritiesResultTable”]/thead/tr/th[5]/span",
“Value”: “!csvLine”
},
{
“Command”: “store”,
“Target”: “Datum”,
“Value”: “!csvLine”
},
{
“Command”: “csvSave”,
“Target”: “{csv_filename}", "Value": "" }, { "Command": "store", "Target": "1", "Value": "RowCnt" }, { "Command": "while", "Target": "{RowCnt} <= 1000”,
“Value”: “”
},
{
“Command”: “comment”,
“Target”: “Row data”,
“Value”: “”
},
{
“Command”: “echo”,
“Target”: “----> Loop = {RowCnt}", "Value": "Maroon" }, { "Command": "verifyElementPresent", "Target": "xpath=//*[@id=\"SecuritiesResultTable\"]/tbody/tr[1]/td[1]", "Value": "" }, { "Command": "gotoIf", "Target": "{!statusOK}==false”,
“Value”: “lbl_NoMoreLines”
},
{
“Command”: “store”,
“Target”: “{RowCnt}", "Value": "!csvLine" }, { "Command": "storeText", "Target": "xpath=//*[@id=\"SecuritiesResultTable\"]/tbody/tr[{RowCnt}]/td[1]”,
“Value”: “!csvLine”
},
{
“Command”: “storeText”,
“Target”: "xpath=//
[@id=“SecuritiesResultTable”]/tbody/tr[{RowCnt}]/td[2]", "Value": "!csvLine" }, { "Command": "storeText", "Target": "xpath=//*[@id=\"SecuritiesResultTable\"]/tbody/tr[{RowCnt}]/td[3]”,
“Value”: “!csvLine”
},
{
“Command”: “storeText”,
“Target”: “xpath=//[@id=“SecuritiesResultTable”]/tbody/tr[{RowCnt}]/td[4]", "Value": "!csvLine" }, { "Command": "storeText", "Target": "xpath=//*[@id=\"SecuritiesResultTable\"]/tbody/tr[{RowCnt}]/td[5]",
“Value”: “!csvLine”
},
{
“Command”: “store”,
“Target”: “{CalDate}", "Value": "!csvLine" }, { "Command": "csvSave", "Target": "{csv_filename}”,
“Value”: “”
},
{
“Command”: “comment”,
“Target”: “Row is stored. Prepare for next itteration.”,
“Value”: “”
},
{
“Command”: “storeEval”,
“Target”: “${RowCnt}+1”,
“Value”: “RowCnt”
},
{
“Command”: “endWhile”,
“Target”: “”,
“Value”: “”
},
{
“Command”: “label”,
“Target”: “lbl_NoMoreLines”,
“Value”: “”
},
{
“Command”: “store”,
“Target”: “MEDIUM”,
“Value”: “!replayspeed”
},
{
“Command”: “comment”,
“Target”: “Ready. Logout.”,
“Value”: “”
},
{
“Command”: “clickAndWait”,
“Target”: "xpath=//
[@id=“navbar”]/ul/li[4]/a/span”,
“Value”: “”
}
]
}

CSV:
Record,Security,Regio,Categorie,Aanbieder,Koers,Datum
1,ACTIAM Noord-Am Ver Index Aandelenfonds,Amerika,Duurzame fondsen,Actiam,“37,33”,20190404
2,Allianz Holland Amerika Fonds,Amerika,Aandelen,Allianz,“29,50”,20190404
3,NN North America Fund,Amerika,Aandelen,ING,“49,14”,20190404
4,Optimix America Fund,Amerika,Aandelen,Optimix,“21,81”,20190404
5,Robeco US Conservative Hi Div Equities G,Amerika,Aandelen,Robeco,“44,64”,20190404
6,C,Amerika,Aandelen,Amundi," 131,21",20190404 7,AXA Rosenberg US Equity Alpha Fund A,Amerika,Aandelen,AXA,"20,98",20190404 8,BlackRock Global US Growth Fund Dis,Amerika,Aandelen,BlackRock,"25,38",20190404 9,BlackRock US Basic Value D2 - C,Amerika,Aandelen,BlackRock,"85,67",20190404 10,BlackRock US Flexible Equity,Amerika,Aandelen,BlackRock,"35,27",20190404 11,BlackRock US Small MidCap Opps D2 - C,Amerika,Aandelen,BlackRock,"215,51",20190404 12,Deutsche Inv II US Top Dividend FD Dis,Amerika,Aandelen,DWS (Deutsche),"159,88",20190404 13,Dodge & Cox Global Stock Acc,Amerika,Aandelen,,"28,68",20190404 14,Fidelity America Fund,Amerika,Aandelen,Fidelity," 21,93",20190404
15,Franklin Templeton Inv US Equity -W- Acc,Amerika,Aandelen,Franklin Templeton,“18,70”,20190404
16,Franklin Templeton US Opportunities Fund,Amerika,Aandelen,Franklin Templeton,“13,10”,20190404
17,Franklin Templeton US Opportunities W,Amerika,Aandelen,Franklin Templeton," 25,23",20190404 18,GAM Star US All Cap Equity Euro,Amerika,Aandelen,GAM Fund Management,"34,1909",20190404 19,JP Morgan US Value B (USD) D,Amerika,Aandelen,JP Morgan," 149,85",20190404
20,JPMorgan US Select Equity Fd C Acc,Amerika,Aandelen,JP Morgan,“247,73”,20190404
21,MS Inv Fd - US Growth,Amerika,Aandelen,Morgan Stanley," 142,59",20190404 22,NN (L) Invest US High Div -Dis-,Amerika,Aandelen,ING,"510,59",20190404 23,Parvest Equity USA Small Priv (USD) Acc,Amerika,Aandelen,BNP Paribas," 227,20",20190404
24,Pictet-US Equity Growth Selection-HI EUR,Amerika,Aandelen,Pictet,“173,99”,20190404
25,PIMCO High Yield Bond Fund Acc,Amerika,Obligaties,PIMCO,“28,58”,20190404
26,Robeco US Large Cap Equities F EUR,Amerika,Aandelen,Robeco,“184,25”,20190404
27,Robeco US Premium Equities,Amerika,Aandelen,Robeco,“190,80”,20190404
28,Schroder ISF - US Small & Mid-Cap Equity,Amerika,Aandelen,Schroders," 352,3965",20190404 29,Schroder ISF US Smaller Companies,Amerika,Aandelen,Schroders," 179,6997",20190404
30,T Rowe Price-US LG Growth Eq Fd USD Acc,Amerika,Aandelen,T. Rowe Price," 28,07",20190404 31,Threadneedle American Smaller Companies,Amerika,Aandelen,Threadneedle," 10,92",20190404
32,Threadneedle Lux American (3U) (USD) Acc,Amerika,Aandelen,Threadneedle," 10,13",20190404 33,Threadneedle Lux American Selct (3U) Acc,Amerika,Aandelen,Threadneedle," 3,46",20190404
34,UBS (Lux) Equity - USA Growth Acc,Amerika,Aandelen,“310,36”,20190404
35,Vanguard Inv Series US Gov Bond Ind Acc,Amerika,Obligaties,Vanguard," 184,4347",20190404 36,Vanguard Inv Ultra Short Bd Fnd USD Dis,Amerika,Obligaties,Vanguard," 10,0075",20190404
37,Vanguard US 500 Stock Index Fd Acc(EUR),Amerika,Aandelen,Vanguard,“28,4463”,20190404
38,Vanguard US 500 Stock Index Fund (USD) C,Amerika,Aandelen,Vanguard," 31,9393",20190404 39,Vanguard US Opportunities Fund Acc (USD),Amerika,Aandelen,Vanguard," 1.090,7764",20190404
40,iShares Treasury Bond 1-3yr UCITS ETF,Amerika,Obligaties,iShares,"116,70",20190404 41,iShares Core S&P 500 UCITS ETF,Amerika,Aandelen,iShares,"251,484",20190404 42,iShares MSCI North America UCITS,Amerika,Aandelen,iShares,"47,965",20190404 43,iShares NASDAQ 100 UCITS ETF,Amerika,Aandelen,iShares,"374,75",20190404 44,iShares S&P 500 EUR Hedged ETF,Amerika,Aandelen,iShares,"63,903",20190404 45,iShares S&P 500 UCITS ETF DIST,Amerika,Aandelen,iShares,"25,504",20190404 46,iShares US Property Yield UCITS ETF,Amerika,Vastgoed,iShares,"26,575",20190404 47,Think Morningstar N-America Eq UCITS ETF,Amerika,Aandelen,Think ETF's,"32,14",20190404 48,UBS BB Barclays US 7-10 Yr Treasury Bd,Amerika,Obligaties,UBS,"37,305",20190404 49,UBS USA Socially Responsible UCITS ETF,Amerika,Duurzame fondsen,UBS,"103,54",20190404 50,Vanguard S&P 500 UCITS ETF,Amerika,Aandelen,Vanguard,"48,572",20190404 51,Vanguard USD Treasury Bond UCITS ETF,Amerika,Obligaties,Vanguard,"21,59",20190404 52,Invesco Gl EQQQ Nasdaq-100 UCITS,Amerika,Aandelen,Invesco PowerShares,"164,10",20190404 53,Lyxor ETF Nasdaq-100,Amerika,Aandelen,Lyxor,"26,432",20190404 54,SPDR Barclays US Treasury Bond UCITS ETF,Amerika,Obligaties,State Street (SPDR),"94,165",20190404 55,SPDR Russell 2000 U.S. Small Cap ETF,Amerika,Aandelen,State Street (SPDR),"37,915",20190404 56,iShares Corporate Bond UCITS ETF,Amerika,Obligaties,iShares,“101,24”,20190404
57,iShares High Yield Corp Bd UCITS,Amerika,Obligaties,iShares,"92,64",20190404 58,iShares TIPS UCITS ETF,Amerika,Obligaties,iShares,“185,47”,20190404
59,iShares Treasury Bond 7-10yr ETF,Amerika,Obligaties,iShares,"174,54",20190404 60,iShares MSCI Canada UCITS ETF,Amerika,Aandelen,BlackRock,"114,19",20190404 61,iShares MSCI USA Small Cap UCITS ETF,Amerika,Aandelen,iShares,"297,13",20190404 62,SPDR S&P 400 US Mid Cap ETF,Amerika,Aandelen,,"49,81",20190404 63,UBS ETF-MSCI Canada UCITS,Amerika,Aandelen,UBS,"27,94",20190404 64,VanEck Preferred US Equity ETF UCITS,Amerika,Obligaties,Vector,"17,244",20190404 65,Xtrackers MSCI USA UCITS ETF,Amerika,Aandelen,DWS (Deutsche Bank),"69,32",20190404 66,Amundi Prime US Treasury UCITS ETFDR Dis,Amerika,Obligaties,Amundi,---,20190404 67,Amundi Prime USA UCITS ETF DR Dis,Amerika,Aandelen,Amundi,---,20190404 68,iShares DJ U.S. Select Div UCITS ETF,Amerika,Aandelen,iShares,"63,18",20190404 69,SPDR MSCI USA Small Cap Value Weighted,Amerika,Aandelen,State Street (SPDR),"32,79",20190404 70,SPDR S&P US Div Aristocrats UCITS ETF,Amerika,Aandelen,State Street (SPDR),"49,395",20190404 71,UBS Bloomberg Barclays TIPS 10+ ETF,Amerika,Obligaties,UBS,"11,66",20190404 72,VanEck Morningstar Wide Moat UCITS,Amerika,Aandelen,Vector,"30,085",20190404 73,Xtrackers S&P 500 Equal Weight UCITS ETF,Amerika,Aandelen,DWS (Deutsche Bank),"47,475",20190404 74,iShares Nasdaq US Biotechnology ETF USD,Amerika,Aandelen,iShares," 5,08",20190404
75,iShares S&P 500 Health Care Sector UCITS,Amerika,Aandelen,iShares,"$ 6,6475",20190404

Can you please post the macro with the code tags (also called Preformatted text)? Then it is easier to copy and paste into kantu.

codetag

{
  "Name": "Binck Open 085 v03",
  "CreationDate": "2019-4-5",
  "Commands": [
    {
      "Command": "bringBrowserToForeground",
      "Target": "",
      "Value": ""
    },
    {
      "Command": "store",
      "Target": "FundRates",
      "Value": "csv_filename"
    },
    {
      "Command": "storeEval",
      "Target": "var now = new Date(); var m=('0'+(now.getMonth()+1)).slice(-2); var d=('0'+now.getDate()).slice(-2); now.getFullYear()+m+d;",
      "Value": "CalDate"
    },
    {
      "Command": "store",
      "Target": "MEDIUM",
      "Value": "!replayspeed"
    },
    {
      "Command": "store",
      "Target": "9999",
      "Value": "!TIMEOUT_MACRO"
    },
    {
      "Command": "open",
      "Target": "https://www.binck.nl",
      "Value": ""
    },
    {
      "Command": "comment",
      "Target": "Website opened, try to login",
      "Value": ""
    },
    {
      "Command": "clickAndWait",
      "Target": "id=cpMainNavigation_T29FEFC66048_ctl00_ctl00_lblLogin",
      "Value": ""
    },
    {
      "Command": "type",
      "Target": "id=UserName",
      "Value": "897088085"
    },
    {
      "Command": "type",
      "Target": "id=Password",
      "Value": "Puddingbuks2018"
    },
    {
      "Command": "clickAndWait",
      "Target": "xpath=//*[@id=\"loginForm\"]/fieldset/ol/li[5]/button",
      "Value": ""
    },
    {
      "Command": "click",
      "Target": "link=Inloggen zonder code",
      "Value": ""
    },
    {
      "Command": "comment",
      "Target": "Login done",
      "Value": ""
    },
    {
      "Command": "clickAndWait",
      "Target": "xpath=//*[@id=\"secondary-nav-left\"]/li[2]/a/span",
      "Value": ""
    },
    {
      "Command": "clickAndWait",
      "Target": "link=Selecteer een regio",
      "Value": ""
    },
    {
      "Command": "clickAndWait",
      "Target": "link=Selecteer",
      "Value": ""
    },
    {
      "Command": "open",
      "Target": "https://web.binck.nl/SecuritySearch?filterMode=Region&filterId=4120",
      "Value": ""
    },
    {
      "Command": "store",
      "Target": "FAST",
      "Value": "!replayspeed"
    },
    {
      "Command": "comment",
      "Target": "Header Data",
      "Value": ""
    },
    {
      "Command": "store",
      "Target": "Record",
      "Value": "!csvLine"
    },
    {
      "Command": "storeText",
      "Target": "xpath=//*[@id=\"SecuritiesResultTable\"]/thead/tr/th[1]/span",
      "Value": "!csvLine"
    },
    {
      "Command": "storeText",
      "Target": "xpath=//*[@id=\"SecuritiesResultTable\"]/thead/tr/th[2]/span",
      "Value": "!csvLine"
    },
    {
      "Command": "storeText",
      "Target": "xpath=//*[@id=\"SecuritiesResultTable\"]/thead/tr/th[3]/span",
      "Value": "!csvLine"
    },
    {
      "Command": "storeText",
      "Target": "xpath=//*[@id=\"SecuritiesResultTable\"]/thead/tr/th[4]/span",
      "Value": "!csvLine"
    },
    {
      "Command": "storeText",
      "Target": "xpath=//*[@id=\"SecuritiesResultTable\"]/thead/tr/th[5]/span",
      "Value": "!csvLine"
    },
    {
      "Command": "store",
      "Target": "Datum",
      "Value": "!csvLine"
    },
    {
      "Command": "csvSave",
      "Target": "${csv_filename}",
      "Value": ""
    },
    {
      "Command": "store",
      "Target": "1",
      "Value": "RowCnt"
    },
    {
      "Command": "while",
      "Target": "${RowCnt} <= 1000",
      "Value": ""
    },
    {
      "Command": "comment",
      "Target": "Row data",
      "Value": ""
    },
    {
      "Command": "echo",
      "Target": "----> Loop = ${RowCnt}",
      "Value": "Maroon"
    },
    {
      "Command": "verifyElementPresent",
      "Target": "xpath=//*[@id=\"SecuritiesResultTable\"]/tbody/tr[1]/td[1]",
      "Value": ""
    },
    {
      "Command": "gotoIf",
      "Target": "${!statusOK}==false",
      "Value": "lbl_NoMoreLines"
    },
    {
      "Command": "store",
      "Target": "${RowCnt}",
      "Value": "!csvLine"
    },
    {
      "Command": "storeText",
      "Target": "xpath=//*[@id=\"SecuritiesResultTable\"]/tbody/tr[${RowCnt}]/td[1]",
      "Value": "!csvLine"
    },
    {
      "Command": "storeText",
      "Target": "xpath=//*[@id=\"SecuritiesResultTable\"]/tbody/tr[${RowCnt}]/td[2]",
      "Value": "!csvLine"
    },
    {
      "Command": "storeText",
      "Target": "xpath=//*[@id=\"SecuritiesResultTable\"]/tbody/tr[${RowCnt}]/td[3]",
      "Value": "!csvLine"
    },
    {
      "Command": "storeText",
      "Target": "xpath=//*[@id=\"SecuritiesResultTable\"]/tbody/tr[${RowCnt}]/td[4]",
      "Value": "!csvLine"
    },
    {
      "Command": "storeText",
      "Target": "xpath=//*[@id=\"SecuritiesResultTable\"]/tbody/tr[${RowCnt}]/td[5]",
      "Value": "!csvLine"
    },
    {
      "Command": "store",
      "Target": "${CalDate}",
      "Value": "!csvLine"
    },
    {
      "Command": "csvSave",
      "Target": "${csv_filename}",
      "Value": ""
    },
    {
      "Command": "comment",
      "Target": "Row is stored. Prepare for next itteration.",
      "Value": ""
    },
    {
      "Command": "storeEval",
      "Target": "${RowCnt}+1",
      "Value": "RowCnt"
    },
    {
      "Command": "endWhile",
      "Target": "",
      "Value": ""
    },
    {
      "Command": "label",
      "Target": "lbl_NoMoreLines",
      "Value": ""
    },
    {
      "Command": "store",
      "Target": "MEDIUM",
      "Value": "!replayspeed"
    },
    {
      "Command": "comment",
      "Target": "Ready. Logout.",
      "Value": ""
    },
    {
      "Command": "clickAndWait",
      "Target": "xpath=//*[@id=\"navbar\"]/ul/li[4]/a/span",
      "Value": ""
    }
  ]
}

A screenshot from the table I try to scrape…

Should be:
{ “Command”: “verifyElementPresent”, “Target”: “xpath=//*[@id=“SecuritiesResultTable”]/tbody/tr[${RowCnt}]/td[1]”, “Value”: “” },

I noticed this little bugger in my script -> Had to add the variable ${RowCnt}. This is not the solution for this problem, but it might explain why I had some rows missing in my CSV.

The correction in the previous post did indeed solve the secondary problem with the missing rows.

I tried to run the same script on Firefox on a Win10 environment. Same problem with row 6.

Hi,
is there any other information that I can give to get this problem solved?
Cheers…

This issue is solved with V5.0