Skip to main content

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

 

I am trying to re-create the ITBricks bot as per provided training however despite no fields marked as red and using the same path as previously created file it throws an error.

 

Also why can I not debug this error with no additional information provided other than the problematic step (See image above)

 

 

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.

 

image 

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.

 

image 

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

 

image 

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.

 

imageimage 

image 

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

 

image 

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


Reply