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”: “Login op uw Saxo-platform | Saxo Bank”,
“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