Hi @Daniel Kendall​ ,

Could you try adding a Breakpoint at line 12, and check what all headers and values the CustomerRow holds?

Also, run this in Debug Mode.

Alternatively, you can also download the Java FX Package from BotStore, import it into your Control Room and use the JavaFX: Show Record Action to display the variable values.

Kind Regards,

Ashwin A.K

Hi @Daniel Kendall​ ,

The training material has to be updated, and the reason you are facing this issue is because he haven't provided a Local/Variable Session.

Try adding a Local Session((in the Open Action, scroll down and toggle it to Local -> a string value will go here) and see if that works out for you.

You may also add a Session or Global Variable if required.

Kind Regards,

Ashwin A.K

Hi @Daniel Kendall​ ,

You can't access the Bot Store via Community Edition, but you can Import the Downloaded package into CE.

Coming to the Breakpoints, adding Breakpoints is the first step, the second is running the process in Debug like so:

I have a question, are you scrapping a Web Table?

If so, I would recommend viewing the Table as well using the JavaFX: Show Table Action.

Kind Regards,

Ashwin A.K

Thank you for your assistance that solved that error. However, now I have the following error

https://ideagenplc-my.sharepoint.com/:i:/p/daniel_kendall/EbvjIdrA77lIi4PkWkiS2_0B-RvQvmyqDOrrKwnD0fCHiw?e=SJKKaE/p>

It appears that the table scrapped from the HTML has leading spaces on the column names but fixing it as below doesn't help.

https://ideagenplc-my.sharepoint.com/:i:/p/daniel_kendall/Ebe6R2IOz2lJq07RTVYxPbsBdq1uBOxASauw32qrQBuOKg?e=rqEocR/p>

Thank you for your assistance.

The BotStore is unavailable to me on the community edition.

Line 12 is a loop and enabling a breakpoint via the ⋮ didn't work it still executed line 13.

Adding a break to the start of the loop skipped the loop as expected but then CustomerRow is empty.

Record View of CustomerRow

https://ideagenplc-my.sharepoint.com/:i:/p/daniel_kendall/EY9OAI9Gv45Gp8bFRLbGx1ABl0rvDfxwMfEXM2mrh-iNFw?e=ZdtAhP/p>

Weird it failed to EXTRACT the table with debug on (Tried 5x) then with debug off worked as well as it did before.

Re-enabling debug shows me that the table in question is empty at entry to the loop.

CustomerRow is set to populate via the Customers Table and iterate but its not getting that far.

Found import bot

Hi @Daniel Kendall​ ,

It seems as though the Headers is getting added as a Row.

I would suggest referencing the Columns using Indexes instead of the name.

You might want to skip the first row as well.

Kind Regards,

Ashwin A.K

TableView

https://ideagenplc-my.sharepoint.com/:i:/p/daniel_kendall/EcGahEtycPRPpfEcNwUFlzYBnoZYZUgSVjIGntFoP6J92w?e=SLlU2k/p>

Fixed it.

Two points one is that the table is exported with a leading space so variable should be e.g.

$CustomerRow{" Email"}$

NOT

$CustomerRow{Email}$

Secondly is that rerunning insert variable appends it to end of existing (actually useful) but not realising this I was running a messed up command.

FAO Admins The training course should be amended for future learners like myself.

Finally, Thank you so much Ashwin you have been a great help.

Have a great day.

Always happy to help.

Kind Regards,

Ashwin A.K