In our previous post about Web Data Collection (Part 1), we explained how to set up a Template for data extraction when we have a premade list of websites to pull out specific information from. In this post we’re going to highlight (TTV) utilization for data mining, invoking our Workers to query the web for data.
 
For the guiding example of data mining task we have a CSV (Comma Separated Values) spreadsheet full of movie titles and their corresponding posters. You can see a sample of the CSV spreadsheet here:
We are looking to gather the following information for each movie title: production company, release year, Director, genre(s) and MPAA rating.
 
Below you can find link to created Template on our platform as well as the screen-capture of it:
 
Template is available for cloning and further customization as per desired. Simply click on green “Clone” button, edit and save it with your given title
 
Template Preview: (requires Microworkers account login): Collect Information About Popular Movies
 
Screen-capture: (click to enlarge):

____________________________________________________

 
Let’s now separately analyze each designed part in sequence.

• Task Objectives, Task Instructions and Helpful Tip(s) Panel

In order to showcase the wide opportunities of Bootstrap styling codes we played a bit more with panels and tables, putting them together inline with text. Sometime you may need to put lots of guidance but you also care to keep things organized in your Template.
 
Below topics display Template’s source code where all vital parts are marked in red.
 
Well-designed and organized Templates have proven to significantly increase Workers’ participation as they make task more attractive

• Movie Title

To accomplish dynamic behavior and spread out an unique movie title to each Worker we set parameter ${movie_title} which takes values from CSV file mentioned at the beginning, precisely from movie_title column. (Read more about CSV approach here)
 
Option to enclose a CSV with Template is given during the campaign setup. In order to ensure CSV format compliance, it’s preferred to utilize “Download Sample CSV” once the Template is ready. The system will generate blank CSV file with Template-matching column(s) for you to enter your values. “Download Sample CSV” link is found on individual Template page after one is saved)
 

• Movie Poster

The only difference compared to process described slightly above is that instead of text, we now need to load up dynamic parameter for images. This is simply solved by inserting img src tag to the parameter ${poster_url} (i.e. <img src="${poster_url}"). The system now takes values stored under poster_url column of CSV.
 

Visual Editor: Click Here

CSV file may have many columns (separate variables), but note that if used within same Template they always show up in row-major order
 

• Data Input

Similarly to Web Data Collection (Part 1), we took advantage of quite applicable Bootstrap Table styling, however, with certain changes as to input forms alignment. Considering the type of information that are required, we’ve put text fields for Production Company and Director fields, dropdown for the Release Year, checkboxes for Genre(s) and lastly the radio buttons for Rating field.

Visual Editor (“Text Fields”): Click Here

Visual Editor (“Dropdown”): Click Here

Visual Editor (“Checkboxes”): Click Here

Visual Editor (“Radio Buttons”): Click Here

 
Question forms require an adequate name and/or value input upon inserting. Otherwise, your collected results could easily overlap — keep in mind that generated CSV results come out under given labels (look for a CSV example at the bottom)
 

If you need to download your campaign reports you can do it from individual campaign page clicking on ‘Results in CSV’. When you export a campaign reports, we generate a spreadsheet with all its relevant information (please take a look on an improvised example below).
 

 
 
Example of CSV with results (click to enlarge):
 

 

---

For any help in managing your (TTV) demands please do not hesitate to send us a message with your concerns. We always enjoy helping you out.
 
‘Till the next article stay tuned!



You might also be interested in these TTV Tutorial Articles:
 
TTV-Tutorial: Data Extraction
TTV-Tutorial: Template With Images
TTV-Tutorial: Transcribe Data From an Image
TTV Tutorial: Embedding Videos In Template