Helena
Web Automation for End Users

Editing Tables, Saving, Scheduling, and Debugging Programs
This page discusses how we can use the Chrome extension to do things like editing, saving, and running Helena programs.
Saving Programs
To save a Helena program, just give it a name and press the "Save" button.
Retrieving Saved Programs
To load a saved Helena program, click on the "Saved Scripts" tab in the control pane. Either browse through the list of saved programs or, if you remember the name of the program you're seeking, use Chrome's usual CTRL+F search functionality to search for the name of the program you want. Once you've found the program, click on it, and the extension will load the saved program. Now you can edit or run the program as usual.
Checking Relevant Tables
When you record a demonstration, Helena looks for tables of data on the pages with which you interact. Sometimes you may want to check and make sure Helena is extracting the right data. To take a look at the tables Helena found, scroll down in the "Current Script" tab and click on the "Relevant Tables" item. You can take a look at all the tables Helena extracted, rename the tables (or the columns), and see a preview of the first three rows of data.
Previewing Relevant Tables in Webpages
You want to be sure that the tables Helena finds are getting all the data you expect, and sometimes the best way to check is to look at the page and see which nodes Helena finds and which it doesn't. If this is what you want to do, scroll down in the "Current Script" tab and click on the "Relevant Tables" item. Find the preview of the table you want to see in its own page, then scroll down to the "Edit This Table" button for that table. Click on "Edit This Table," and Helena will open the page that shows the table. If you need to interact with the page to get the table to show, go ahead and do that. Once the table is visible, click the "Page Shows My Table" button. Helena will show the extracted data in the control pane, and it will highlight the extracted nodes in the webpage. This can be especially useful for cases, like the one demonstrated in the GIF below, in which we're scraping images.
Editing Tables
If Helena didn't get quite the right table, you can also edit a table. Start by following the directions for Previewing Relevant Tables in Webpages. The user interface for editing tables is still very much in flux, but there are a few things you can do from the current interface version. In particular, a common task is to indicate how to reach more pages of a table. For example, if you scroll to find more rows of the table, you'd click on "Scroll for More" (see GIF below). If you find more rows with a next button, you'd click on "Next Button" and then follow the directions to click on the next button in the actual webpage. If you find more rows with a more button, you'd click on "More Button" and do the same process.
Removing Tables
Sometimes there's a table available but you actually don't want to go through each row. For example, in the GIF below, after demonstrating how to collect data about the first author in a list and the first paper by the first author, Helena guesses we want a program that collects all authors and all their papers. If we want a program the only collects the first paper by all authors, we should remove the papers table. If we want a program that only collects all papers by the first author, we should remove the authors table. To do that, we scroll down and click "Relevant Tables," then find the table we want to remove and click the "This Table is Not Relevant" button. In the GIF below, we remove the papers table, so the new program only collects the first paper by each author.
Uploading Tables
Sometimes you want to upload a table rather than finding one on a webpage. For instance, if you've put together a set of URLs you want to process or a set of texts you want to search, this might be the right move. In the GIF below, we have a Helena program for extracting the set of pages an organization has liked on Facebook. To repeat the process for other organizations, we upload a CSV with URLs for the organizations' Facebook profiles, where the first URL is the URL on which we initially demonstrated. (If you have a spreadsheet with the table you want, just export it as a CSV to put it in a format Helena can process - for instance, if you're using Excel, follow the directions here.) Remember, as when you demonstrate on the first row of a table in a webpage, your demonstration has to use the items from the first row of your uploaded table, or Helena won't know how to repeat actions for additional rows.
Scheduling Later Runs
Sometimes you want a Helena program to run repeatedly on a schedule. To make that happen, first load the script you want to schedule into the "Current Script" tab - either by demonstrating it or by loading it from the saved programs list (see directions for loading saved programs). If the script has never been saved before, make sure to save it first. Next click on "Additional Run Options" and click the "Schedule Later Runs of This Script" button. Type in when you want it to run, then click the "Done" button. You can see all the runs you currently have scheduled in the "Scheduled Runs" tab of the control pane. You can cancel scheduled runs by going to the "Scheduled Runs" tab and clicking on the "x" in the box of the runs you want to cancel. When you schedule a run, the run will take place on the computer you use to schedule it; if the computer is turned off or if Chrome isn't open at the time of the scheduled run, the run won't happen. (If you prefer traditional programming and would rather use cron to schedule Helena runs, take a look at https://github.com/schasins/helena/tree/master/utilities.) Also make sure that you don't schedule conflicting runs. If program B is scheduled to happen partway through when program A is running, program A run will be halted and program B will start running instead. Here's a GIF demonstrating how to schedule later runs.
Skipping Repetitive Work
Helena has special support for making sure your programs don't re-execute work they've already done in the past. If you're finding lots of rows with the same data in your output datasets, you might want to use Helena's skip block to avoid re-scraping those rows. Or if you're planning to re-scrape periodically but you only want to collect the new data that you haven't already seen, the skip block is probably right for you. Take a look at our page on skip blocks for a guide to making your programs faster by skipping over work you've already done.
Need some Tips and Tricks to fix up your program?

Or head back to the full list of resources:

← Resources