Social Feed Manager is open source software for libraries, archives, cultural heritage institutions and research
organizations. It empowers those communities’ researchers, faculty, students, and archivists to define and create
collections of data from social media platforms. Social Feed Manager will harvest from Twitter, Tumblr, Flickr,
and Sina Weibo and is extensible for other platforms. In addition to collecting data from those platforms’ APIs,
it will collect linked web pages and media.
User Guide
Welcome to Social Feed Manager!
Social Feed Manager (SFM) is an open-source tool designed for researchers,
archivists, and curious individuals to collect social media data from Twitter,
Tumblr, Flickr, or Sina Weibo. See the SFM Overview
for a quick look at SFM.
If you want to learn more about what SFM can do, read What is SFM used for?
This guide is for users who have access to SFM and want to learn how to collect. If
you’re an administrator setting up SFM for your institution, see
Admin and Technical Documentation.
- To get your first collection up and running:
- Sign up: On the SFM homepage, click “Sign up.” Fill out the form,
including a unique email. Once you sign up, you will be automatically logged in.
- Get credentials: You’ll need to authorize access to the social
media platforms using credentials. See Setting up Credentials.
- Create a collection set and within it a collection, where you’ll actually
collect data. See Creating Collections.
- Add seeds: Seeds are the criteria used to collect data. You’ll add user
accounts or search criteria. See Adding Seeds.
- Set your collections running!
- Export your collections when you want to see and work with your data, or
adjust settings. See Exporting your Data.
You can always come back to this user guide for help by clicking Documentation
at the bottom of any SFM page and selecting User Guide.
What is SFM used for?
Social Feed Manager (SFM) collects individual posts–tweets,
photos, blogs–from social media sites. These posts are collected in their native, raw data
format called JSON and can be exported in many formats, including spreadsheets.
Users can then use this collected data for research, analysis or archiving.
- Some ideas for how to use SFM:
- Collecting from individual accounts such as the tweets of every U.S.
Senator (Twitter user timeline).
- Gathering Flickr images for analysis or archiving the photographs from
accounts donated to your organization (Flickr user).
- Researching social media use by retrieving a sample of all tweets
(Twitter sample), or by filtering by specific search terms
(Twitter filter).
- Capturing a major event by collecting tweets in a specific geographic
location or by following specific hashtags.
- Collecting Tumblr posts for preserving institutional blogs or the work
of online artists.
(Tumblr blog posts).
- Archiving posts from any social media platform for later research.
- Analyzing trends by Exploring social media data with ELK (note that ELK requires coding
ability–contact your SFM administrator for help).
Note that SFM currently collects social media data from Twitter, Tumblr, Flickr,
and Sina Weibo.
Here’s a sample of what a collection set looks like:
Types of Collections
- Twitter user timeline: Collect tweets from specific
Twitter accounts
- Twitter search: Collects tweets by a user-provided search query
from recent tweets
- Twitter sample: Collects a Twitter-provided stream of a subset
of all tweets in real time.
- Twitter filter: Collects tweets by user-provided criteria from
a stream of tweets in real time.
- Flickr user: Collects posts and photos from specific
Flickr accounts
- Weibo timeline: Collects posts from the user and the user’s
friends
- Tumblr blog posts: Collects blog posts from specific Tumblr
blogs
- Collecting web resources: Secondary collections of resources linked to or
embedded in social media posts.
How to use the data
- Once you’ve collected data, there are a few ways to use it:
- You could export it into a CSV or Excel format for a basic analysis
(Exporting your Data), or load the format into analysis software such
as Stata, SPSS, or Gephi.
- You could use try Exploring social media data with ELK, a processor for data analysis (although
ELK requires some technical knowledge, so ask your SFM admin for help if you need it).
- You could set up an archive using the JSON files or Excel files.
Setting up Credentials
Before you can start collecting, you need credentials for the social media
platform that you want to use. Credentials are keys used by each platform to
control the data they release to you.
You are responsible for creating your own credentials so that you can control
your own collection rate and make sure that you are following the policies of
each platform.
For more information about platform-specific policies, consult the documentation
for each social media platform’s API.
Creating Collections
Collections are the basic SFM containers for social media data.
Each collection either gathers posts from individual accounts or gathers posts based
on search criteria.
Collections are contained in collection sets. While collection sets
sometimes only include one collection, sets can be used to organize all of the
data from a single project or archive–for example, a collection set about a
band might include a collection of the Twitter user timelines of each band
member, a collection of the band’s Flickr, and a Twitter Filter collection of
tweets that use the band’s hashtag.
Before you begin collecting, you may want to consider these collection
development guidelines.
Setting up Collections and Collection Sets
Because collections are housed in collection sets, you must make a collection
set first.
Navigate to the Collection Sets page from the top menu, then click the Add
Collection Set button.
Give the collection set a unique name and description. A collection set is like
a folder for all collections in a project.
If you are part of a group project, you can contact your SFM administrator and
set up a new group which you can share each collection set with. (This can be
changed or added later on).
Once you are in a collection set, click the “Add Collection” dropdown menu and
select the collection type you want to add.
Enter a unique collection name and a short description. The description is a
great location to describe how you chose what to put in your collection.
Select which credential you want to use. If you need to set up new credentials,
see Setting up Credentials.
Adding Seeds
Seeds are the criteria used by SFM to collect social media posts. Seeds may
be individual social media accounts or search terms used to filter posts.
The basic process for adding seeds is the same for every collection type, except
for Twitter Sample and Sina Weibo:
- Turn off the collection.
- Click Add Seed for adding one seed or Add Bulk Seeds for multiple.
- Enter either the user ids or search criteria and save.
- When you have added all seeds you want, click Turn on.
For details on each collection type, see:
Exporting your Data
In order to access the data in a collection, you will need to export it. You are able
to download your data in several formats,
including Excel (.xlsx) and Comma Separated Values (.csv), which can be
loaded into a spreadsheet or data analytic software.
- To export:
- At the top of the individual collection, click Export.
- Select the file type you want (.csv is recommended; .xlsx types will also be
easily accessible).
- Select the export file size you want, based on number of posts per file. Note that
larger file sizes will take longer to download.
- Select Deduplicate if you only want one instance of every post. This will clean
up your data, but will make the export take longer.
- Item start date/end date allow you to limit the export based on the date
each post was created.
- Harvest start date/end date allow you to limit the export based on the
harvest dates.
- When you have the settings you want, click Export. You will be
redirected to the export screen. When the export is complete, the files,
along with a README file describing what was included in the export and the
collection, will appear for you to click on and download. You will receive
an email when your export completes.
- To help understand each metadata field in the export, see
Data Dictionaries for CSV/Excel Exports.
For the advanced processing provided by ELK, see
Commandline exporting/processing.
API Credentials
Accessing the APIs of social media platforms requires credentials for
authentication (also knows as API keys). Social Feed Manager supports managing
those credentials.
Credentials/authentication allow a user to collect data through a platform’s
API. For some social media platforms (e.g., Twitter and Tumblr), Limits are
placed on methods and rate of collection on a per credential basis.
SFM users are responsible for creating their own new credentials so that
they can control their own collection rates and can ensure that they are
following each platform’s API policies.
Most API credentials have two parts: an application credential and a user
credential.(Flickr is the exception – only an application credential
is necessary.)
For more information about platform-specific policies, consult the documentation
for each social media platform’s API.
Managing credentials
SFM supports two approaches to managing credentials: adding credentials and
connecting credentials. Both of these options are available from the
Credentials page.
Adding credentials
For this approach, a user gets the application and/or user credential from the
social media platform and provide them to SFM by completing a form. More
information on getting credentials is below.
Connecting credentials
This is the easiest approach for users.
For this approach, SFM is configured with the application credentials for the
social media platform by the systems administrator. The user credentials are
obtained by the user being redirected to the social media website to give
permission to SFM to access her account.
SFM is configured with the application credentials in the .env
.
If additional management is necessary, it can be performed using the Social
Accounts section of the Admin interface.
Adding Flickr Credentials
- Navigate to https://www.flickr.com/services/api/keys/.
- Sign in to your Yahoo! account.
- Click Get Another Key
- Choose Apply for a Non-commercial key, which is for API users that are
not charging a fee.
- Enter an Application Name like Social Feed Manager
- Enter Application Description such as: This is a social media research
and archival tool, which collects data for academic researchers through an
accessible user interface.
- Check both checkboxes
- Click Submit
- Navigate to the SFM Credentials page and click Add Flicker Credential
- Enter the Key and Secret in the correct fields and save.
Adding Tumblr Credentials
- Navigate to https://www.tumblr.com/oauth/apps/.
- Sign in to Tumblr.
- Click Register Application
- Enter an Application Name like Social Feed Manager
- Enter a website such as the SFM url
- Enter Application Description such as: This is a social media research
and archival tool, which collects data for academic researchers through an
accessible user interface.
- Enter Administrative contact email. You should use your own email.
- Enter default callback url, the same url used for the website.
- Click Register
- Navigate to the SFM Credentials page and click Add Tumblr Credential
- Enter the OAuth Consumer Key in the API key field and save.
Adding Weibo Credentials
For instructions on obtaining Weibo credentials, see this guide.
To use the connecting credentials approach for Weibo, the redirect URL must
match the application’s actual URL and use port 80.
Collection types
Each collection type connects to one of a social media platform’s APIs, or
methods for retrieving data. Understanding what each collection type provides is
important to ensure you collect what you need and are aware of any limitations.
Reading the social media platform’s documentation provides further important
details.
- Collection types
- Twitter user timeline: Collect tweets from specific Twitter accounts
- Twitter search: Collects tweets by a user-provided search query from recent tweets
- Twitter sample: Collects a Twitter provided stream of a subset of all tweets in real
time.
- Twitter filter: Collects tweets by user-provided criteria from a stream of
tweets in real time.
- Flickr user: Collects posts and photos from specific Flickr accounts
- Weibo timeline: Collects posts from the user and the user’s friends
- Weibo search: Collects recent weibo posts by a user-provided search query
- Tumblr blog posts: Collects blog posts from specific Tumblr blogs
- Collecting Web resources: Secondary collections of resources linked to or
embedded in social media posts.
Flickr user
Flickr User Timeline collections gather metadata about public photos by a
specific Flickr user, and, optionally, copies of the photos at specified sizes.
Each Flickr user collection can have multiple seeds, where each seed is a Flickr
user. To identify a user, you can provide a either a username or an NSID. If you
provide one, the other will be looked up and displayed in the SFM UI during the
first harvest. The NSID is a unique identifier and does not change; usernames
may be changed but are unique.
Usernames can be difficult to find, so to ensure that you have the correct
account, use this tool to find the
NSID from the account URL (i.e., the URL when viewing the account on the Flickr
website).
Depending on the image sizes you select, the actual photo files will be
collected as well. Be very careful in selecting the original file size, as this
may require a significant amount of storage. Also note that some Flickr users
may have a large number of public photos, which may require a significant amount
of storage. It is advisable to check the Flickr website to determine the number
of photos in each Flickr user’s public photo stream before harvesting.
For each user, the user’s information will be collected using Flickr’s
people.getInfo
API and the list of her public photos will be retrieved from people.getPublicPhotos.
Information on each photo will be collected with
photos.getInfo.
See Incremental collecting to decide whether or not to collect
incrementally.
Tumblr blog posts
Tumblr Blog Post collections harvest posts by specified Tumblr blogs using the
Tumblr Posts API.
Seeds are individual blogs for these collections. Blogs can be specified with
or without the .tumblr.com extension.
See Incremental collecting to decide whether or not to collect incrementally.
See the Collecting web resources guidance below for deciding whether to
collect image or web resources.
Weibo timeline
Weibo Timeline collections harvest weibos (microblogs) by the user and friends
of the user whose credentials are provided using the Weibo friends_timeline API.
Note that because collection is determined by the user whose credentials are
provided, there are no seeds for a Weibo timeline collection. To change what is
being collected, change the user’s friends from the Weibo website or app.
See the Collecting web resources guidance below for deciding whether to
collect image or web resources.
Weibo search
Collects recent weibos that match a search query using the `Weibo
search_topics API<http://open.weibo.com/wiki/2/search/topics>`_.
The Weibo API does not return a complete search of all Weibo posts.
It only returns the most recent 200 posts matching a single keyword
when found between pairs of ‘#’ in Weibo posts (for example: #keyword# or
#你好#)
The incremental option will attempt to only count weibo posts that haven’t been harvested before,
maintaining a count of non-duplicate weibo posts. Because the Weibo search API does not accept
since_id or max_id parameters, filtering out already-harvested weibos from the
search count is accomplished within SFM.
When the incremental option is not selected, the search will be performed again,
and there will most likely be duplicates in the count.
See the Collecting web resources guidance below for deciding whether to
collect image or web resources.
Incremental collecting
The incremental option is the default and will collect tweets or posts that have been published since the last harvest.
When the incremental option is not selected, the maximum number of tweets or posts will be harvested each
time the harvest runs. If a non-incremental harvest is performed multiple times, there will most likely be
duplicates. However, with these duplicates, you may be able to track changes across time in a user’s
timeline, such as changes in retweet and like counts, deletion of tweets, and follower counts.
Collecting web resources
Most collection types allow you to select an option to collect web resources
such as images, web pages, etc. that are included in the social media post. When
a social media post includes a URL, SFM will harvest the web page at that URL.
It will harvest only that web page, not any pages linked from that page.
Be very deliberate in collecting web resources. Performing a web harvest both
takes longer and requires significantly more storage than collecting the
original social media post.
Data Dictionaries for CSV/Excel Exports
Social Feed Manager captures a variety of data from each platform. These data
dictionaries give explanations for each selected and processed field in
exports.
Note that these are subsets of the data that are collected for each
post. The full data is available for export by selecting “Full JSON” as the export format
or by exporting from the commandline. See Command-line exporting/processing.
Tumblr Dictionary
For more info about source tweet data, see the Tumblr API documentation, particularly Posts.
Documentation about older archived posts is archived by the Wayback Machine for the
original Tumblr API and the
newer Tumblr API.
Field |
Description |
Example |
created_at |
Date and time the tweet was created, in
ISO 8601 format and UTC time zone. |
2016-12-21 19:30:03+00:00 |
tumblr_id |
Tumblr identifier for the blog post |
154774150409 |
blog_name |
The short name used to uniquely identify a blog.
This is the first part of the blog url, like
<nasa.tumblr.com>. |
nasa |
post_type |
The type of post, such as one of the following:
text, quote, link, answer, video, audio,
photo, or chat. |
text |
post_slug |
Text summary of the post, taken from the final
portion of the url. |
10-questions-for-our-chief-scientist |
post_summary |
Text summary of the post, taken from the title
of the post. |
10 Questions for Our Chief Scientist |
post_text |
Body of the post text, using html markup. |
See https://notepad.pw/w8133kzj |
tags |
Hashtags from the post
as a comma-separated list. |
nasa, space, solarsystem,
chiefscientist, scientist |
tumblr_url |
Full url location of the post. |
http://nasa.tumblr.com/post/154774150409/
10-questions-for-our-chief-scientist |
tumblr_short_url |
Short url of the post. |
https://tmblr.co/Zz_Uqj2G9GXq9 |
Flickr Dictionary
For more info about source tweet data, see the Flickr API documentation, particularly People and Photos.
Documentation about older archived posts is archived by the Wayback Machine here.
Field |
Description |
Example |
photo_id |
Unique Flickr identifier of the photo. |
11211844604 |
date_posted |
Date and time that the post was uploaded to
Flickr, in ISO 8601 format and UTC time zone. |
2013-12-04 21:39:40+00:00 |
date_taken |
Date and time that media was captured, either
extracted from EXIF or from the date posted,
in mm/dd/yyyy hh:mm format. |
6/7/2014 13:35 |
license |
Licensing allowed for media, given as a
numeral according to the following key:
- 0 = All Rights Reserved
- 1 = Attribution-NonCommercial-Sharealike License
- 2 = Attribution-NonCommercial License
- 3 = Attribution-NonCommercial NoDerivs License
- 4 = Attribution License
- 5 = Attribution-ShareAlike License
- 6 = Attribution-NoDerivs License
- 7 = No known copyright restrictions
- 8 = United States Government work
- More information at creativecommons.org/licenses
|
4
(Attribution license) |
safety_level |
Appropriateness of post, given as a numeral
according to the following key:
- 0 = Safe - Content suitable for everyone
- 1 = Moderate - Approximately PG-13 content
- 2 = Restricted - Approximately R rated content
|
0
(Safe level) |
original_format |
File format of uploaded media. |
jpg |
owner_nsid |
Unique Flickr identifier of the owner account. |
28399705@N04 |
owner_username |
Unique plaintext username of the owner account. |
GW Museum and Textile Museum |
title |
Title of the post. |
Original Museum entrance |
description |
Short description of the post. |
Historic photo courtesy of The Textile
Museum Archives. |
media |
Media type of the post. |
photo |
photopage |
Location url of the post. |
https://www.flickr.com/photos/textilemuseum/
11211844604/ |
Weibo Dictionary
For more info about source tweet data, see the Sina Weibo API
friends_timeline documentation.
Documentation about older archived tweets is archived by the Wayback Machine here.
Note that for privacy purposes, Weibo dictionary examples are not consistent.
Field |
Description |
Example |
created_at |
Date and time the tweet was created, in
ISO 8601 format and UTC time zone. |
2016-12-21T19:30:03+00:00 |
weibo_id |
Sina Weibo identifier for the tweet. |
4060309792585658 |
screen_name |
The unique screen name of the account that
authored the weibo, at the time the weibo was
posted. |
下厨房 |
followers_count |
Number of followers this account had at the time
the weibo was harvested. |
3655329 |
friends_count |
Number of users this account was following at the
time the weibo was harvested. |
2691 |
reposts_count |
Number of times this weibo had been reposted at
the time the weibo was harvested. |
68 |
topics |
Topics (similar to hashtags) from the weibo text
as a comma-separated list. |
魅族三分时刻 |
in_reply_to_screen_name |
If the weibo is a reply, the screen name of
the original weibo’s author.
(This is not yet supported by Sina Weibo.) |
下厨房 |
weibo_url |
URL of the weibo. If the tweet is a retweet made |
http://m.weibo.cn/1618051664/4060300716095462 |
text |
The text of the weibo. |
马住! |
url1 |
First URL in text of weibo, as shortened by
Sina Weibo. |
http://t.cn/RM2xyx6 |
url2 |
Second URL in text of weibo, as shortened by
Sina Weibo. |
http://t.cn/Rc52gDY |
retweeted_text |
Text of original weibo when the collected weibo
is a repost. |
马住! |
retweeted_url1 |
First URL in text of original weibo, as shortened
by Sina Weibo. |
http://t.cn/RVR4cAQ |
retweeted_url2 |
Second URL in text of original weibo, as shortened
by Sina Weibo. |
http://t.cn/RMAJISP |
Command-line exporting/processing
While social media data can be exported from the SFM UI, in some cases you may want to export
from the commandline. These cases include:
- Exporting very large datasets. (Export via the UI is performed serially; export via the commandline
can be performed in parallel, which may be much faster.)
- Performing more advanced filtering or transformation that is not supported by the UI export.
- Integrating with a processing/analysis pipeline.
To support export and processing from the commandline, SFM provides a processing container. A processing
container is a Linux shell environment with access to the SFM’s data and preloaded with a set of useful tools.
Using a processing container requires familiarity with the Linux shell and shell access to the SFM server. If
you are interested in using a processing container, please contact your SFM administrator for help.
When exporting/processing data, remember that harvested social media content and and web resources are stored
in /sfm-data
. /sfm-processing
is provided to store your exports, processed data, or scripts. Depending
on how it is configured, you may have access to /sfm-processing
from your local filesystem. See Storage.
Processing container
To bootstrap export/processing, a processing image is provided. A container instantiated from this
image is Ubuntu 14.04 and pre-installed with the warc iterator tools, find_warcs.py
, and some other
useful tools. (Warc iterators and find_warcs.py
are described below.) It will also have read-only
access to the data from /sfm-data
and read/write access to /sfm-processing
.
The other tools available in a processing container are:
To instantiate a processing container, from the directory that contains your docker-compose.yml
file:
docker-compose run --rm processing /bin/bash
You will then be provided with a bash shell inside the container from which you can execute commands:
root@0ac9caaf7e72:/sfm-processing# find_warcs.py 4f4d1 | xargs twitter_rest_warc_iter.py | python /opt/twarc/utils/wordcloud.py
Note that once you exit the processing container, the container will be automatically removed. However, if you have
saved all of your scripts and output files to /sfm-processing
, they will be available when you create a new
processing container.
Recipes
Exporting to line-oriented JSON files
This recipe is for exporting social media data from WARC files to line-oriented JSON files. There will be one JSON file
for each WARC. This may be useful for some processing or for loading into some analytic tools.
This recipe uses parallel for parallelizing the export.
Create a list of WARC files:
find_warcs.py 7c37157 | tr ' ' '\n' > source.lst
Replace 7c37157 with the first few characters of the collection id that you want to export. The collection id is
available on the colllection detail page in SFM UI.
Create a list of JSON destination files:
cat source.lst | xargs basename -a | sed 's/.warc.gz/.json/' > dest.lst
This command puts all of the JSON files in the same directory, using the filename of the WARC file with a .json file extension.
If you want to maintain the directory structure, but use a different root directory:
cat source.lst | sed 's/sfm-data\/collection_set/sfm-processing\/export/' | sed 's/.warc.gz/.json/'
Replace sfm-processing/export with the root directory that you want to use.
Perform the export:
parallel -a source.lst -a dest.lst --xapply "twitter_stream_warc_iter.py {1} > {2}"
Replace twitter_stream_warc_iter.py with the name of the warc iterator for the type of social media data that you
are exporting.
You can also perform a filter on export using jq. For example, this only exports tweets in Spanish:
parallel -a source.lst -a dest.lst --xapply "twitter_stream_warc_iter.py {1} | jq -c 'select(.lang == \"es\")' > {2}"
And to save space, the JSON files can be gzip compressed:
parallel -a source.lst -a dest.lst --xapply "twitter_stream_warc_iter.py {1} | gzip > {2}"
You might also want to change the file extension of the destination file to ”.json.gz” by adjusting the commmand use
to create the list of JSON destination files. To access the tweets in a gzipped JSON file, use:
Counting posts
wc -l can be used to count posts. To count the number of tweets in a collection:
find_warcs.py 7c37157 | xargs twitter_stream_warc_iter.py | wc -l
To count the posts from line-oriented JSON files created as described above:
cat dest.lst | xargs wc -l
wc -l gotcha: When doing a lot of counting, wc -l will output a partial total and then reset
the count. The partial totals must be added together to get the grand total. For example:
[Some lines skipped ...]
1490 ./964be41e1714492bbe8ec5793e05ec86-20160725070757217-00000-7932-62ebe35d576c-8002.json
4514 ./5f78a79c6382476889d1ed4734d6105a-20160722202703869-00000-5110-62ebe35d576c-8002.json
52043 ./417cf950a00d44408458c93f08f0690e-20160910032351524-00000-1775-c4aea5d70c14-8000.json
54392684 total
[Some lines skipped ...]
34778 ./30bc1c34880d404aa3254f82dd387514-20160806132811173-00000-21585-62ebe35d576c-8000.json
30588 ./964be41e1714492bbe8ec5793e05ec86-20160727030754726-00000-10044-62ebe35d576c-8002.json
21573971 total
Using jq to process JSON
For tips on using jq with JSON from Twitter and other sources, see:
Exploring social media data with ELK
The ELK (Elasticsearch, Logstash,
Kibana) stack is a general-purpose framework for exploring data. It
provides support for loading, querying, analysis, and visualization.
SFM provides an instance of ELK that has been customized for exploring social media data. It currently supports data from
Twitter and Weibo.
One possible use for ELK is to monitor data that is being harvested to discover new seeds to select.
For example, it may reveal new hashtags or users that are relevant to a collection.
Though you can use Logstash and Elasticsearch directly, in most cases you will interact exclusively with Kibana,
which is the exploration interface.
Enabling ELK
ELK is not available by default; it must be enabled as described here.
You can enable one or more ELK Docker containers. Each container can be configured to be loaded with all social
media data or the social media data for a single collection set.
To enable an ELK Docker container it must be added to your docker-compose.yml
and then started by:
An example container is provided in example.docker-compose.yml
and example.prod.docker-compose.yml
. These examples
also show how to limit to a single collection set by providing the collection set id.
By default, Kibana is available at http://<your hostname>:5601/app/kibana. (Also,
by default Elasticsearch is available on port 9200 and Logstash is available on port 5000.)
If enabling multiple ELK containers, add multiple containers to your docker-compose.yml
. Make sure to give each container a unique name and a unique hostname:
value, and make sure that each container maps to different ports.
Loading data
ELK will automatically be loaded as new social media data is harvested. (Note, however, that there will be some latency
between the harvest and the data being available in Kibana.)
Since only new social media data is added, it is recommended that you enable the ELK Docker container before beginning
harvesting.
If you would like to load social media data that was harvested before the ELK Docker container was enabled, use the
resendwarccreatedmsgs
management command:
usage: manage.py resendwarccreatedmsgs [-h] [--version] [-v {0,1,2,3}]
[--settings SETTINGS]
[--pythonpath PYTHONPATH] [--traceback]
[--no-color]
[--collection-set COLLECTION_SET]
[--harvest-type HARVEST_TYPE] [--test]
routing_key
The resendwarccreatedmsgs
command resends warc_created messages which will trigger the loading of data by ELK.
To use this command, you will need to know the routing key. The routing key is elk_loader_<hostname>.warc_created
.
The hostname is available as part of the definition of the ELK container in the docker-compose.yml
file.
The loading can be limited by collection set (--collection-set
) and/or (--harvest-type
). You can get collection
set ids from the collection set detail page. The available harvest types are twitter_search, twitter_filter,
twitter_user_timeline, twitter_sample, and weibo_timeline.
This shows loading the data limited to a collection set:
docker exec docker_sfmuiapp_1 python sfm/manage.py resendwarccreatedmsgs --collection-set b438a62cbcf74ad0adc09be3b07f039e elk_loader_myproject_elk.warc_created
Overview of Kibana
The Kibana interface is extremely powerful. However, with that power comes complexity.
The following provides an overview of some basic functions in Kibana. For some advanced
usage, see the Kibana Reference or the Kibana 101: Getting Started with Visualizations video.
When you start Kibana, you probably won’t see any results.
This is because Kibana defaults to only showing data from the last 15 minutes. Use the
date picker in the upper right corner to select a more appropriate time range.
Tip: At any time, you can change the date range for your query, visualization, or dashboard
using the date picker.
Discover
The Discover tab allows you to query the social media data.
By default, all social media types are queried. By limit to a single type (e.g., tweets),
click the folder icon and select the appropriate filter.
You will now only see results for that social media type.
Notice that each social media item has a number of fields.
You can search against a field. For example, to find all tweets containing the term “archiving”:
or having the hashtag #SaveTheWeb:
or mentioning @SocialFeedMgr:
Visualize
The Visualize tab allows you to create visualizations of the social media data.
The types of visualizations that are supported include:
- Area chart
- Data table
- Line chart
- Pie chart
- Map
- Vertical bar chart
Describing how to create visualizations is beyond the scope of this overview.
A number of visualizations have already been created for social media data. (The available
visualizations are listed on the bottom of the page.)
For example, here is the Top 10 hashtags visualization:
Dashboard
The Dashboard tab provides a summary view of data, bringing together multiple visualizations
and searches on a single page.
A number of dashboards have already been created for social media data. To select a dashboard,
click the folder icon and select the appropriate dashboard.
For example, here is the top of the Twitter dashboard:
Caveats
- This is experimental. We have not yet determined the level of development that will be performed in
the future.
- Approaches for administering and scaling ELK have not been considered.
- No security or access restrictions have been put in place around ELK.
Releasing public datasets
Many social media platforms place limitations on sharing of data collected from their APIs. One common approach for sharing data, in particular for Twitter, is to only share the identifiers of the social media items. Someone
can then recreate the dataset be retrieving the items from the API based on the identifiers. For Twitter, the process of extracting tweet ids is often called “dehydrating” and retrieving the full tweet is called “hydrating.”
Note that retrieving the entire original dataset may not be possible, as the social media platform may opt to not provide social media items that have been deleted or are no longer public.
This example shows the steps for releasing the Women’s March dataset to Dataverse. The Women’s March dataset
was created by GWU and published on the Harvard Dataverse. These instructions can be adapted for publishing your own collections to the dataset repository of your choice.
Note that the Women’s March dataset is a single (SFM) collection. For an example of publishing multiple collections to a single dataset, see the 2016 United States Presidential Election dataset.
Exporting collection data
Access the server where your target collection is located and instantiate a processing container. (See Command-line exporting/processing):
ssh sfmserver.org
cd /opt/sfm
docker-compose run --rm processing /bin/bash
Replace sfmserver.org
with the address of the SFM server that you want export data from.
Find a list of WARC files where the data of your target collection are stored, and create a list of WARC files (source.lst) and a list of destination text files. (dest.lst):
find_warcs.py 0110497 | tr ' ' '\n' > source.lst
cat source.lst | xargs basename -a | sed 's/.warc.gz/.txt/' > dest.lst
Replace 0110497
with the first few characters of the collection id that you want to export. The collection id is available on the collection detail page in SFM UI. (See the picture below.)
Write the tweet ids to the destination text files:
time parallel –j 3 -a source.lst -a dest.lst --xapply "twitter_stream_warc_iter.py {1} | jq –r ‘.id_str’ > {2}"
This command executes a Twitter Stream WARC iterator to extract the tweets from the WARC files and jq to extract the tweet ids. Parallel is used to perform this process in parallel (using multiple processors), using WARC files from source.lst and text files from dest.lst.
- Note: -j 3 limits parallel to 3 processors. Make sure to select an appropriate number for your server.
Combine multiple files into large files:
The previous command creates a single text file containing tweet ids for each WARC file. To combine the tweets into a single file:
cat *.txt > womensmarch.txt
- Recommendation: If there are a large number of tweet ids in a file, split into multiple, smaller files. (We limit to 50 million tweet ids per file.)
Create a README file that contains information on each collection (management command for sfm ui):
Exit from the processing container, and connect to the UI container and execute the exportreadme management command to create a README file for the dataset:
exit
docker-compose exec ui /bin/bash -c "/opt/sfm-ui/sfm/manage.py exportreadme 0110497 > /sfm-processing/womensmarch-README.txt"
Copy the files from the server to your local hard drive:
Exit from the SFM server with exit
command, move to a location in your local hard drive where you want to store the data, and run the command below:
exit
scp -p username@sfmserver.org:/sfm-processing/womensmarch*.txt .
Replace username
and sfmserver.org
with your user ID and the address of the SFM server, respectively.
Publishing collection data on Dataverse
For this example, we will be adding the collection to the GW Libraries Dataverse on the Harvard Dataverse instance.
Go to the GW Libraries Dataverse and log in.
- Note: You should be a Curator for the dataverse to be able to upload data.
Open the New Dataset page:
Click ‘Add Data > New Dataset‘.
Fill the metadata with proper information (title, author, contact, description, subject, keyword):
Make sure you input the right number of tweets collected and appropriate dates in the description.
Upload the files (both data and README files) and save the dataset:
- Note: The dataset will be saved as a draft.
Publish the dataset:
Go to the page of the draft that was just saved, and click ‘Publish‘ button.
Installation and configuration
Overview
The supported approach for deploying SFM is Docker containers. For more information on Docker, see Docker.
Each SFM service will provide images for the containers needed to run the service
(in the form of Dockerfile
s). These images will be published to Docker Hub.
GWU created images will be part of the GWUL organization
and be prefixed with sfm-.
sfm-docker provides the necessary
docker-compose.yml
files to compose the services into a complete instance of SFM.
The following will describe how to setup an instance of SFM that uses the latest release
(and is suitable for a production deployment.) See the development documentation for other
SFM configurations.
SFM can be deployed without Docker. The various Dockerfile
s should provide
reasonable guidance on how to accomplish this.
Local installation
Installing locally requires Docker and Docker-Compose. See Installing Docker.
Either clone the sfm-docker repository and copy the example configuration files:
git clone https://github.com/gwu-libraries/sfm-docker.git
cd sfm-docker
# Replace 1.8.0 with the correct version.
git checkout 1.8.0
cp example.prod.docker-compose.yml docker-compose.yml
cp example.env .env
or just download example.prod.docker-compose.yml
and example.env
(replacing 1.8.0 with the correct version):
curl -L https://raw.githubusercontent.com/gwu-libraries/sfm-docker/1.8.0/example.prod.docker-compose.yml > docker-compose.yml
curl -L https://raw.githubusercontent.com/gwu-libraries/sfm-docker/1.8.0/example.env > .env
Update configuration in .env
as described in Configuration.
Bring up the containers:
It may take several minutes for the images to be downloaded and the containers to start.
It is also recommended that you scale up the Twitter REST Harvester container:
docker-compose scale twitterrestharvester=2
Notes:
- The first time you bring up the containers, their images will be pulled from Docker Hub. This will take several minutes.
- For instructions on how to make configuration changes after the containers have been brought up, see Configuration.
- To learn more about scaling , see Scaling up with Docker.
- For suggestions on sizing your SFM server, see Server sizing.
Amazon EC2 installation
To launch an Amazon EC2 instance running SFM, follow the normal procedure for launching an instance.
In Step 3: Configure Instance Details, under Advanced Details paste the following in
user details and modify as appropriate as described in Configuration. Also, in the curl
statements change master to the correct version, e.g., 1.8.0:
#cloud-config
repo_update: true
repo_upgrade: all
packages:
- python-pip
runcmd:
- curl -sSL https://get.docker.com/ | sh
- usermod -aG docker ubuntu
- pip install -U docker-compose
- mkdir /sfm-data
- mkdir /sfm-processing
- cd /home/ubuntu
# This brings up the latest production release. To bring up master, remove prod.
- curl -L https://raw.githubusercontent.com/gwu-libraries/sfm-docker/1.8.0/example.prod.docker-compose.yml > docker-compose.yml
- curl -L https://raw.githubusercontent.com/gwu-libraries/sfm-docker/1.8.0/example.env > .env
# Set config below by uncommenting.
# Don't forget to escape $ as \$.
# COMMON CONFIGURATION
# - echo TZ=America/New_York >> .env
# VOLUME CONFIGURATION
# Don't change these.
- echo DATA_VOLUME=/sfm-data:/sfm-data >> .env
- echo PROCESSING_VOLUME=/sfm-processing:/sfm-processing >> .env
# SFM UI CONFIGURATION
# Don't change this.
- echo SFM_HOSTNAME=`curl http://169.254.169.254/latest/meta-data/public-hostname` >> .env
- echo SFM_PORT=80 >> .env
# Provide your institution name display on sfm-ui footer
# - echo SFM_INSTITUTION_NAME=yourinstitution >> .env
# Provide your institution link
# - echo SFM_INSTITUTION_LINK=http://library.yourinstitution.edu >> .env
# To send email, set these correctly.
# - echo SFM_SMTP_HOST=smtp.gmail.com >> .env
# - echo SFM_EMAIL_USER=someone@gmail.com >> .env
# - echo SFM_EMAIL_PASSWORD=password >> .env
# An optional contact email at your institution that is provided to users.
# - echo SFM_CONTACT_EMAIL=sfm@yourinstitution.edu >> .env
# To enable connecting to social media accounts, provide the following.
# - echo TWITTER_CONSUMER_KEY=mBbq9ruffgEcfsktgQztTHUir8Kn0 >> .env
# - echo TWITTER_CONSUMER_SECRET=Pf28yReB9Xgz0fpLVO4b46r5idZnKCKQ6xlOomBAjD5npFEQ6Rm >> .env
# - echo WEIBO_API_KEY=13132044538 >> .env
# - echo WEIBO_API_SECRET=68aea49fg26ea5072ggec14f7c0e05a52 >> .env
# - echo TUMBLR_CONSUMER_KEY=Fki09cW957y56h6fhRtCnig14QhpM0pjuHbDWMrZ9aPXcsthVQq >> .env
# - echo TUMBLR_CONSUMER_SECRET=aPTpFRE2O7sVl46xB3difn8kBYb7EpnWfUBWxuHcB4gfvP >> .env
# For automatically created admin account
# - echo SFM_SITE_ADMIN_NAME=sfmadmin >> .env
# - echo SFM_SITE_ADMIN_EMAIL=nowhere@example.com >> .env
# - echo SFM_SITE_ADMIN_PASSWORD=password >> .env
# RABBIT MQ CONFIGURATION
# - echo RABBITMQ_USER=sfm_user >> .env
# - echo RABBITMQ_PASSWORD=password >> .env
# - echo RABBITMQ_MANAGEMENT_PORT=15672 >> .env
# DB CONFIGURATION
# - echo POSTGRES_PASSWORD=password >> .env
# WEB HARVESTER CONFIGURATION
# - echo HERITRIX_USER=sfm_user >> .env
# - echo HERITRIX_PASSWORD=password >> .env
# - echo HERITRIX_ADMIN_PORT=8443 >> .env
# - echo HERITRIX_CONTACT_URL=http://library.myschool.edu >> .env
- docker-compose up -d
- docker-compose scale twitterrestharvester=2
When the instance is launched, SFM will be installed and started.
Note the following:
- Starting up the EC2 instance will take several minutes.
- This has been tested with Ubuntu Server 14.04 LTS, but may work with other AMI types.
- For suggestions on sizing your SFM server, see Server sizing.
- If you need to make additional changes to your
docker-compose.yml
, you can ssh into the EC2 instance
and make changes. docker-compose.yml
and .env
will be in the default user’s
home directory.
- Make sure to configure a security group that exposes the proper ports. To see which
ports are used by which services, see example.prod.docker-compose.yml.
- To learn more about configuring EC2 instances with user data, see the AWS user guide.
Configuration
Configuration is documented in example.env
. For a production deployment, pay particular attention to the following:
- Set new passwords for
SFM_SITE_ADMIN_PASSWORD
, RABBIT_MQ_PASSWORD
, POSTGRES_PASSWORD
, and HERITRIX_PASSWORD
.
- The data volume strategy
is used to manage the volumes that store SFM’s data. By default, normal Docker volumes are used. To use a host volume
instead, change the
DATA_VOLUME
and PROCESSING_VOLUME
settings. Host volumes are recommended for production
because they allow access to the data from outside of Docker.
- Set the
SFM_HOSTNAME
and SFM_PORT
appropriately. These are the public hostname (e.g., sfm.gwu.edu) and port (e.g., 80)
for SFM.
- Email is configured by providing
SFM_SMTP_HOST
, SFM_EMAIL_USER
, and SFM_EMAIL_PASSWORD
.
(If the configured email account is hosted by Google, you will need to configure the account to “Allow less secure apps.”
Currently this setting is accessed, while logged in to the google account, via https://myaccount.google.com/security#connectedapps).
- Application credentials for social media APIs are configured in by providing the
TWITTER_CONSUMER_KEY
,
TWITTER_CONSUMER_SECRET
, WEIBO_API_KEY
, WEIBO_API_SECRET
, and/or TUMBLR_CONSUMER_KEY
,
TUMBLR_CONSUMER_SECRET
. These are optional, but will make acquiring credentials easier for users.
For more information and alternative approaches see API Credentials.
- Set an admin email address with
SFM_SITE_ADMIN_EMAIL
. Problems with SFM are sent to this address.
- Set an SFM contact email address with
SFM_CONTACT_EMAIL
. Users are provided with this address.
- For branding in the SFM UI, provide
SFM_INSTITUTION_NAME
and SFM_INSTITUTION_LINK
.
- Provide a contact URL (e.g., http://library.gwu.edu) to be used when web harvesting with
HERITRIX_CONTACT_URL
.
Note that if you make a change to configuration after SFM is brought up, you will need to restart containers. If
the change only applies to a single container, then you can stop the container with docker kill <container name>
. If
the change applies to multiple containers (or you’re not sure), you can stop all containers with docker-compose stop
.
Containers can then be brought back up with docker-compose up -d
and the configuration change will take effect.
Stopping
To stop the containers gracefully:
docker-compose stop -t 180 twitterstreamharvester
docker-compose stop
SFM can then be restarted with docker-compose up -d
.
Server restarts
If Docker is configured to automatically start when the server starts, then SFM will start. (This is enabled by default
when Docker is installed.)
SFM will even be started if it was stopped prior to the server reboot. If you do not want SFM to start, then configure
Docker to not automatically start.
To configure whether Docker is automatically starts, see Stopping Docker from automatically starting.
Upgrading
Following are general instructions for upgrading SFM versions. Always consult the release notes of the new version to
see if any additional steps are required.
Stop the containers gracefully:
docker-compose stop -t 180 twitterstreamharvester
docker-compose stop
This may take several minutes.
Make a copy of your existing docker-compose.yml
and .env
files:
cp docker-compose.yml old.docker-compose.yml
cp .env old.env
Get the latest example.prod.docker-compose.yml
. If you previously cloned the sfm-docker repository then:
git pull
# Replace 1.8.0 with the correct version.
git checkout 1.8.0
cp example.prod.docker-compose.yml docker-compose.yml
otherwise, replacing 1.8.0 with the correct version:
curl -L https://raw.githubusercontent.com/gwu-libraries/sfm-docker/1.8.0/example.prod.docker-compose.yml > docker-compose.yml
4. If you customized your previous docker-compose.yml
file (e.g., for SFM ELK containers), make the same changes
in your new docker-compose.yml
.
Make any changes in your .env
file prescribed by the release notes.
Bring up the containers:
It may take several minutes for the images to be downloaded and the containers to start.
Deleting images from the previous version is recommended to prevent Docker from filling up too much space. Replacing 1.5.0 with the correct previous version:
docker rmi $(docker images | grep "1.5.0" | awk '{print $3}')
You may also want to periodically clean up Docker (>= 1.13) with docker system prune
.
Server sizing
While we have not performed any system engineering analysis of optimal server sizing for SFM, the following are
different configurations that we use:
Use |
Server type |
Processors |
RAM (gb) |
Production |
|
6 |
16 |
Sandbox |
m4.large (AWS) |
2 |
8 |
Use in a class |
m4.xlarge (AWS) |
4 |
16 |
Continuous integration |
t2.medium (AWS) |
2 |
4 |
Heavy dataset processing |
m4.4xlarge (AWS) |
16 |
64 |
Development |
Docker for Mac |
2 |
3 |
Monitoring
There are several mechanisms for monitoring (and troubleshooting) SFM.
For more information on troubleshooting, see Troubleshooting.
Monitor page
To reach the monitoring page, click “Monitor” on the header of any page in SFM UI.
The monitor page provides status and queue lengths for SFM components, including
harvesters and exporters.
The status is based on the most recent status reported back by each harvester
or exporter (within the last 3 days). A harvester or exporter reports its status
when it begins a harvest or export. It also reports its status when it completes
the harvest or exporter. Harvesters will also provide status updates periodically
during a harvest.
Note that if there are multiple instances of a harvester or exporter (created with
docker-compose scale), each instance will be listed.
The queue length lists the number of harvest or export requests that are waiting.
A long queue length can indicate that additional harvesters or exporters are needed
to handle the load (see Scaling up with Docker) or that there is a problem with the
harvester or exporter.
The queue length for SFM UI is also listed. This is a queue of status update messages
from harvesters or exporters. SFM UI uses these messages to update the
records for harvests and exports. Any sort of a queue here indicates a problem.
Logs
It can be helpful to peek at the logs to get more detail on the work being performed
by a harvester or exporter.
Docker logs
The logs for harvesters and exporters can be accessed using Docker’s log commands.
First, determine the name of the harvester or exporter using docker ps
. In general,
the name will be something like sfm_twitterrestharvester_1.
Second, get the log with docker logs <name>
.
Add -f to follow the log. For example,
docker logs -f sfm_twitterrestharvester_1
.
Add –tail=<number of lines to get the tail of the log. For example,
docker logs --tail=100 sfm_twitterrestharvester_1
.
Side note: To follow the logs of all services, use docker-compose logs -f
.
Management consoles
Several of the services used by SFM offer management consoles that can be useful for monitoring.
For each of these, the username, password, and port are available from your .env file.
Heritrix
The Heritrix management console is usually available on port 8443. For example, https://localhost:8443/.
Note that you must used HTTPS to reach the management console. You may be warned by your browser
about the certificate; it is safe to proceed.
Administration
Designated users have access to SFM UI’s Django Admin interface
by selecting Welcome > Admin on the top
right of the screen. This interface will allow adding, deleting, or changing database records for SFM UI. Some
of the most salient uses for this capability are given below.
Managing groups
To allow for multiple users to control a collection set:
- Create a new group.
- Add users to the group. (This is done from the user’s admin page, not the group’s admin page.)
- Assign the collection set to the group. This is done from the collection set detail page or from the collection
set admin page.
Deleting items
Records can be deleted using the Admin Interface. It is recommended to minimize deletion; in particular, collections
should be turned off and seeds made inactive.
Note the following when deleting:
- Cascades delete, i.e., when a record is deleted any other records that depend on it will also be deleted. Before
the deletion is performed, you will be informed what dependent records will be deleted.
- When deleting collection sets, collections, harvests, WARCs, and exports the corresponding files will be deleted.
Thus, if you delete a collection set all data and metadata will be deleted. Be careful.
Moving collections
Collections can be moved from one collection set to another. This is done by changing the collection set for the
collection in the Admin Interface.
Note the following when moving collections:
- The collections files are moved as well, as the directory structure includes the collection set’s identifier.
- The path for WARC files in WARC records are updated.
- Make sure harvesting is turned off and all harvests and exports are completed before moving.
- Previous exports will become unavailable after the move.
Allowing access to Admin Interface
To allow a user to have access to the Admin Interface, give the user Staff status or Superuser status. This is done
from the user’s admin page.
Authentication
Social Feed Manager allows users to self-sign up for accounts.
Those accounts are stored and managed by SFM. Future versions of SFM will
support authentication against external systems, e.g., Shibboleth.
By default, a group is created for each user and the user is placed in
group. To create additional groups and modify group membership use
the Admin interface.
In general, users and groups can be administered from the Admin interface.
The current version of SFM is not very secure. Future versions of SFM
will more tightly restrict what actions users can perform and what they can
view. In the meantime, it is encouraged to take other measures to secure
SFM such as restricting access to the IP range of your institution.
Docker
This page contains information about Docker that is useful for installation,
administration, and development.
Installing Docker
Docker Engine and Docker Compose
On OS X:
- Install Docker for Mac.
- If you are using Docker Toolbox, switch to Docker for Mac.
On Ubuntu:
- If you have difficulties with the
apt
install, try the pip
install.
- The docker group is automatically created. Adding your user to the docker
group
avoids having to use sudo to run docker commands. Note that depending on how
users/groups are set up, you may need to manually need to add your user to the
group in
/etc/group
.
While Docker is available on other platforms (e.g., Windows,
Red Hat Enterprise Linux), the SFM team does not have any experience running
SFM on those platforms.
Helpful commands
docker-compose up -d
- Bring up all of the containers specified in the docker-compose.yml file. If a container has not yet been pulled,
it will be pulled. If a container has not yet been built it will be built. If a container has been stopped (“killed”)
it will be re-started. Otherwise, a new container will be created and started (“run”).
docker-compose pull
- Pull the latest images for all of the containers specified in the docker-compose.yml file with the image field.
docker-compose build
Build images for all of the containers specified in the docker-compose.yml file with the build field. Add --no-cache
- to re-build the entire image (which you might want to do if the image isn’t building as expected).
docker ps
- List running containers. Add
-a
to also list stopped containers.
docker-compose kill
- Stop all containers.
docker kill <container name>
- Stop a single container.
docker-compose rm -v --force
- Delete the containers and volumes.
docker rm -v <container name>
- Delete a single container and volume.
docker rm $(docker ps -a -q) -v
- Delete all containers.
docker-compose logs
- List the logs from all containers. Add
-f
to follow the logs.
docker logs <container name>
- List the log from a single container. Add
-f
to follow the logs.
docker-compose -f <docker-compose.yml filename> <command>
- Use a different docker-compose.yml file instead of the default.
docker exec -it <container name> /bin/bash
- Shell into a container.
docker rmi <image name>
- Delete an image.
docker rmi $(docker images -q)
- Delete all images
docker-compose scale <service name>=<number of instances>
- Create multiple instances of a service.
Scaling up with Docker
Most harvesters and exporters handle one request at a time; requests for exports and harvests queue up waiting
to be handled. If requests are taking too long to be processed you can scale up (i.e., create additional
instances of) the appropriate harvester or exporter.
To create multiple instances of a service, use docker-compose scale.
The harvester most likely to need scaling is the Twitter REST harvester since some harvests (e.g., broad Twitter
searches) may take a long time. To scale up the Twitter REST harvester to 3 instances use:
docker-compose scale twitterrestharvester=3
To spread containers across multiple containers, use Docker Swarm.
Using compose in production provides
some additional guidance.
Stopping Docker from automatically starting
Docker automatically starts when the server starts. To control this:
Ubuntu 14 (Upstart)
Stop Docker from automatically starting:
echo manual | sudo tee /etc/init/docker.override
Allow Docker to automatically start:
sudo rm /etc/init/docker.override
Manually start Docker:
sudo service docker start
Ubuntu 16 (Systemd)
Stop Docker from automatically starting:
sudo systemctl disable docker
Allow Docker to automatically start:
sudo systemctl enable docker
Manually start Docker:
sudo systemctl start docker
Collection set / Collection portability
Overview
Collections and collection sets are portable. That means they can be moved to another SFM instance or
to another environment, such as a repository. This can also be used to backup an SFM instance.
A collection includes all of the social media items and web resources (stored in WARCs) and the database
records for the collection sets, collections, users, groups, credentials, seeds, harvests, and WARCs, as well
as the history of collection sets, collections, credentials, and seeds. The
database records are stored in JSON format in the records
subdirectory of the collection. Each collection
has a complete set of JSON database records to support loading it into a different SFM instance.
Here are the JSON database records for an example collection:
[root@1da93afd43b5:/sfm-data/collection_set/4c59ebf2dcdc4a0e9660e32d004fa846/072ff07ea9954b39a1883e979de92d22/records# ls
collection.json groups.json historical_collection.json historical_seeds.json users.json
collection_set.json harvest_stats.json historical_collection_set.json info.json warcs.json
credentials.json harvests.json historical_credentials.json seeds.json
Thus, moving a collection set only requires moving/copying the collection set’s directory; moving a collection
only requires moving/copying a collection’s directory. Collection sets are in /sfm-data/collection_set
and
are named by their collection set ids. Collections are subdirectories of their collection set
and are named by their collection ids.
A README.txt
is automatically created for each collection and collection set. Here a README.txt
for
an example collection set:
This is a collection set created with Social Feed Manager.
Collection set name: test collection set
Collection set id: 4c59ebf2dcdc4a0e9660e32d004fa846
This collection set contains the following collections:
* test twitter sample (collection id 59f9ff647ffd4fa28fd7e5bc4d161743)
* test twitter user timeline (collection id 072ff07ea9954b39a1883e979de92d22)
Each of these collections contains a README.txt.
Updated on Oct. 18, 2016, 3:09 p.m.
Preparing to move a collection set / collection
Nothing needs to be done to prepare a collection set or collection for moving. The collection set and collection
directories contain all of the files required to load it into a different SFM instance.
The JSON database records are refreshed from the database on a nightly basis. Alternatively, they
can be refreshed used the serializecollectionset
and serializecollection
management commands:
root@1da93afd43b5:/opt/sfm-ui/sfm# ./manage.py serializecollectionset 4c59ebf2d
Loading a collection set / collection
Move/copy the collection set/collection to /sfm-data/collection_set
. Collection sets should be placed
in this directory. Collections should be placed into a collection set directory.
Execute the deserializecollectionset
or deserializecollection
management command:
root@1da93afd43b5:/opt/sfm-ui/sfm# ./manage.py deserializecollectionset /sfm-data/collection_set/4c59ebf2dcdc4a0e9660e32d004fa846
Note:
- If loading a collection set, all of the collection set’s collections will also be loaded.
- When loading, all related items are also loaded. For example, when a collection is loaded, all of the seeds,
harvests, credentials, and their histories are also loaded.
- If a database record already exists for a collection set, loading will not continue for the collection set or any
of its collections or related records (e.g., groups).
- If a database record already exists for a collection, loading will not continue for the collection or any of the
related records (e.g., users, harvests, WARCs).
- If a database record already exists for a user or group, it will not be loaded.
- Collections that are loaded are turned off.
- Users that are loaded are set to inactive.
- A history note is added to collection sets and collections to document the load.
Moving an entire SFM instance
- Stop the source instance:
docker-compose stop
.
- Copy the
/sfm-data
directory from the source server to the destination server.
- If preserving processing data, also copy the
/sfm-processing
directory from the source server to the destination
server.
- Copy the
docker-compose.yml
and .env
files from the source server to the destination server.
- Make any changes necessary in the
.env
file, e.g., SFM_HOSTNAME
.
- Start the destination instance:
docker-compose up -d
.
If moving between AWS EC2 instances and /sfm-data
is on a separate EBS volume, the volume can be detached from
the source EC2 instances and attached to the destination EC2 instance.
Storage
Storage volumes
SFM stores data on 2 volumes:
- sfm-data: The data volume is where SFM stores the harvested social media content and web resources, the db files, and
exports. This is described in more detail below. It is available within containers as /sfm-data.
- sfm-processing: The processing volume is where processed data is stored when using a processing container.
(See Command-line exporting/processing.) It is available within containers as /sfm-processing.
Volume types
There are 2 types of volumes:
- Internal to Docker. The files on the volume will only be available from within Docker containers.
- Linked to a host location. The files on the volumes will be available from within Docker containers and from the
host operating system.
The type of volume is specified in the .env file. When selecting a link to a host location, the path on the host
environment must be specified:
# Docker internal volume
DATA_VOLUME=/sfm-data
# Linked to host location
#DATA_VOLUME=/src/sfm-data:/sfm-data
# Docker internal volume
PROCESSING_VOLUME=/sfm-processing
# Linked to host location
#PROCESSING_VOLUME=/src/sfm-processing:/sfm-processing
We recommend that you use an internal volume only for development; for other uses linking to a host
location is recommended. This make it easier to place the data on specific storage devices (e.g., NFS or EBS) and to
backup the data.
File ownership
SFM files are owned by the sfm user (default uid 990) in the sfm group (default gid 990). If you use a link to a host
location and list the files, the uid and gid may be listed instead of the user and group names.
If you shell into a Docker container, you will be the root user. Make sure that any operations you perform will not
leave behind files that do not have appropriate permissions for the sfm user.
Note then when using Docker for Mac and linking to a host location, the file ownership may not appear as expected.
Directory structure of sfm-data
The following is a outline of the structure of sfm-data:
/sfm-data/
collection_set/
<collection set id>
README.txt (README for collection set)
<collection id>/
README.txt (README for collection)
state.json (Harvest state record)
heritrix_job/
Web harvest state records
records/
JSON records for the collection metadata
<year>/<month>/<day>/<hour>/
WARC files
containers/
<container id>/
Working files for individual containers
elk/
<container id>/
ELK files
export/
<export id>/
Export files
postgresql/
Postgres db files
Space warnings
SFM will monitor free space on sfm-data and sfm-processing. Administrators will be notified when the amount of free space
crosses a configurable threshold. The threshold is set in the .env file:
# sfm-data free space threshold to send notification emails,only ends with MB,GB,TB. eg. 500MB,10GB,1TB
DATA_VOLUME_THRESHOLD=10GB
# sfm-processing free space threshold to send notification emails,only ends with MB,GB,TB. eg. 500MB,10GB,1TB
PROCESSING_VOLUME_THRESHOLD=10GB
Moving from a Docker internal volume to a linked volume
These instructions are for Ubuntu. They may need to be adjusted for other operating systems.
Stop docker containers:
Copy sfm-data contents from inside the container to a linked volume:
sudo docker cp sfm_data_1:/sfm-data /
Set ownership:
sudo chown -R 990:990 /sfm-data/*
Change .env:
#DATA_VOLUME=/sfm-data
DATA_VOLUME=/sfm-data:/sfm-data
Restart containers:
Limitations and Known Issues
To make sure you have the best possible experience with SFM, you should be aware of the limitations and known issues:
- SFM is does not currently run with HTTPS (Ticket #361).
- Because of the need to link a Heritrix container and a web harvester container, the web harvester cannot be scaled with
docker-compose scale command
(Ticket 408)
- Changes to the hostname of server (e.g., from the reboot of an AWS EC2 instance) are not handled (Ticket 435)
We are planning to address these in future releases. In the meantime, there are work-arounds for many of these issues. For a complete list of tickets, see https://github.com/gwu-libraries/sfm-ui/issues
In addition, you should be aware of the following:
- The current implementation of web harvesting is not optimal and requires significant additional work or reconsideration.
In particular: (1) It does not scale: under normal collecting scenarios, web harvesting can lag far behind social
media collecting. (2) It is not reliable: Heritrix requires more fiddling and testing.
- Access to the Weibo API is limited, so make sure you understand what can be collected.
- SFM does not currently provide a web interface for “replaying” the collected social media or web content.
- ELK is only experimental. Scaling and administration of ELK have not been considered.
Troubleshooting
General tips
- Upgrade to the latest version of Docker and Docker-Compose.
- Make sure expected containers are running with
docker ps
.
- Check the logs with
docker-compose logs
and docker logs <container name>
.
- Additional information is available via the admin interface that is not available from the UI.
To access the admin interface, log in as an account that has superuser status and under “Welcome, <your name>,”
click Admin. By default, a superuser account called sfmadmin is created. The password can be found in
.env
.
Specific problems
Skipped harvests
A new harvest will not be requested if the previous harvest has not completed. Instead, a harvest record will be created
with the status of skipped. Some of the reasons that this might happen include:
- Harvests are scheduled too closely together, such that the previous harvest cannot complete before the new harvest is requested.
- There are not enough running harvesters, such that harvest requests have to wait too long before being processed.
- There is a problem with harvesters, such that they are not processing harvest requests.
- Something else has gone wrong, and a harvest request was not completed.
After correcting the problem to resume harvesting for a collection, void the last (non-skipped) harvest. To void a
harvest, go to that harvest’s detail page and click the void button.
Connection errors when harvesting
If harvests from a container fail with something like:
HTTPSConnectionPool(host='api.flickr.com', port=443): Max retries exceeded with url: /services/rest/?user_id=148553609%40N08&nojsoncallback=1&method=flickr.people.getInfo&format=json (Caused by ProxyError('Cannot connect to proxy.', error('Tunnel connection failed: 500 [Errno -3] Temporary failure in name resolution',)))
then stop and restart the container. For example:
docker-compose stop flickrharvester
docker-compose up -d
Bind error
If when bringing up the containers you receive something like:
ERROR: driver failed programming external connectivity on endpoint docker_sfmuiapp_1 (98caab29b4ba3c2b08f70fdebad847980d80a29a2c871164257e454bc582a060): Bind for 0.0.0.0:8080 failed: port is already allocated
it means another application is already using a port configured for SFM. Either shut down the other application
or choose a different port for SFM. (Chances are the other application is Apache.)
Bad Request (400)
If you receive a Bad Request (400) when trying to access SFM, your SFM_HOST
environment variable is not
configured correctly. For more information, see ALLOWED_HOSTS.
Docker problems
If you are having problems bringing up the Docker containers (e.g., driver failed programming external connectivity on endpoint
),
restart the Docker service. On Ubuntu, this can be done with:
# service docker stop
docker stop/waiting
# service docker status
docker stop/waiting
# service docker start
docker start/running, process 15039
Web harvesting / Heritrix problems
If you are encountering problems with web harvesting, check the logs of the web harvester container (docker-compose logs webharvester
)
and the heritrix container (docker-compose logs heritrix
).
If you see a line like heritrix:8443 not available after wait.
in the web harvester logs and various Java exceptions
in the heritrix container logs then kill, remove, and restart the containers:
docker-compose kill webharvester heritrix
docker-compose rm -vf webharvester heritrix
docker-compose up -d
CSV export problems
Excel for Mac has problems with unicode characters in CSV files. As a work-around, export to Excel (XLSX) format.
Still stuck?
Contact the SFM team. We’re happy to help.
Social Feed Manager (SFM)¶
Social Feed Manager is open source software for libraries, archives, cultural heritage institutions and research organizations. It empowers those communities’ researchers, faculty, students, and archivists to define and create collections of data from social media platforms. Social Feed Manager will harvest from Twitter, Tumblr, Flickr, and Sina Weibo and is extensible for other platforms. In addition to collecting data from those platforms’ APIs, it will collect linked web pages and media.
This site provides documentation for installation and usage of SFM. See the Social Feed Manager project site for full information about the project’s objectives, roadmap, and updates.
User Guide¶
Welcome to Social Feed Manager!
Social Feed Manager (SFM) is an open-source tool designed for researchers, archivists, and curious individuals to collect social media data from Twitter, Tumblr, Flickr, or Sina Weibo. See the SFM Overview for a quick look at SFM.
If you want to learn more about what SFM can do, read What is SFM used for? This guide is for users who have access to SFM and want to learn how to collect. If you’re an administrator setting up SFM for your institution, see Admin and Technical Documentation.
You can always come back to this user guide for help by clicking Documentation at the bottom of any SFM page and selecting User Guide.
What is SFM used for?¶
Social Feed Manager (SFM) collects individual posts–tweets, photos, blogs–from social media sites. These posts are collected in their native, raw data format called JSON and can be exported in many formats, including spreadsheets. Users can then use this collected data for research, analysis or archiving.
Note that SFM currently collects social media data from Twitter, Tumblr, Flickr, and Sina Weibo.
Here’s a sample of what a collection set looks like:
Types of Collections¶
How to use the data¶
Privacy and platform policy considerations¶
Collecting and using data from social media platforms is subject to those platforms’ terms (Twitter, Flickr, Sina Weibo, Tumblr), as you agreed to them when you created your social media account. Social Feed Manager respects those platforms’ terms as an application (Twitter, Flickr, Sina Weibo, Tumblr).
Social Feed Manager provides data to you for your research and academic use. Social media platforms’ terms of service generally do not allow republishing of full datasets, and you should refer to their terms to understand what you may share. Authors typically retain rights and ownership to their content.
Take a look at these guidelines on social media collection development.
Ethical considerations¶
In addition to respecting the platforms’ terms, as a user of Social Feed Manager and data collected within it, it is your responsibility to consider the ethical aspects of collecting and using social media data. Your discipline or professional organization may offer guidance.
Many people have written about the important ethical and legal considerations in collecting and using social media data. To begin understanding these aspects, here are a few resources with which to start:
Setting up Credentials¶
Before you can start collecting, you need credentials for the social media platform that you want to use. Credentials are keys used by each platform to control the data they release to you.
You are responsible for creating your own credentials so that you can control your own collection rate and make sure that you are following the policies of each platform.
For more information about platform-specific policies, consult the documentation for each social media platform’s API.
Creating Collections¶
Collections are the basic SFM containers for social media data. Each collection either gathers posts from individual accounts or gathers posts based on search criteria.
Collections are contained in collection sets. While collection sets sometimes only include one collection, sets can be used to organize all of the data from a single project or archive–for example, a collection set about a band might include a collection of the Twitter user timelines of each band member, a collection of the band’s Flickr, and a Twitter Filter collection of tweets that use the band’s hashtag.
Before you begin collecting, you may want to consider these collection development guidelines.
Setting up Collections and Collection Sets¶
Because collections are housed in collection sets, you must make a collection set first.
Navigate to the Collection Sets page from the top menu, then click the Add Collection Set button.
Give the collection set a unique name and description. A collection set is like a folder for all collections in a project.
If you are part of a group project, you can contact your SFM administrator and set up a new group which you can share each collection set with. (This can be changed or added later on).
Once you are in a collection set, click the “Add Collection” dropdown menu and select the collection type you want to add.
Enter a unique collection name and a short description. The description is a great location to describe how you chose what to put in your collection.
Select which credential you want to use. If you need to set up new credentials, see Setting up Credentials.
Adding Seeds¶
Seeds are the criteria used by SFM to collect social media posts. Seeds may be individual social media accounts or search terms used to filter posts.
The basic process for adding seeds is the same for every collection type, except for Twitter Sample and Sina Weibo:
For details on each collection type, see:
Exporting your Data¶
In order to access the data in a collection, you will need to export it. You are able to download your data in several formats, including Excel (.xlsx) and Comma Separated Values (.csv), which can be loaded into a spreadsheet or data analytic software.
For the advanced processing provided by ELK, see Commandline exporting/processing.
API Credentials¶
Accessing the APIs of social media platforms requires credentials for authentication (also knows as API keys). Social Feed Manager supports managing those credentials.
Credentials/authentication allow a user to collect data through a platform’s API. For some social media platforms (e.g., Twitter and Tumblr), Limits are placed on methods and rate of collection on a per credential basis.
SFM users are responsible for creating their own new credentials so that they can control their own collection rates and can ensure that they are following each platform’s API policies.
Most API credentials have two parts: an application credential and a user credential.(Flickr is the exception – only an application credential is necessary.)
For more information about platform-specific policies, consult the documentation for each social media platform’s API.
Managing credentials¶
SFM supports two approaches to managing credentials: adding credentials and connecting credentials. Both of these options are available from the Credentials page.
Adding credentials¶
For this approach, a user gets the application and/or user credential from the social media platform and provide them to SFM by completing a form. More information on getting credentials is below.
Connecting credentials¶
This is the easiest approach for users.
For this approach, SFM is configured with the application credentials for the social media platform by the systems administrator. The user credentials are obtained by the user being redirected to the social media website to give permission to SFM to access her account.
SFM is configured with the application credentials in the
.env
. If additional management is necessary, it can be performed using the Social Accounts section of the Admin interface.Platform specifics¶
Twitter credentials can be obtained from the Twitter API.
For detailed instructions, see Adding Twitter Credentials.
It is recommended to change the application permissions to read-only. You must provide a callback URL, but the URL you provide doesn’t matter.
Flickr credentials can be obtained from the Flickr API.
For detailed instructions, see Adding Flickr Credentials.
Tumblr credentials can be obtained from the Tumblr API.
For detailed instructions, see Adding Tumblr Credentials.
Weibo¶
For instructions on obtaining Weibo credentials, see this guide.
To use the connecting credentials approach for Weibo, the redirect URL must match the application’s actual URL and use port 80.
Adding Twitter Credentials¶
The easiest way to set up Twitter credentials is to connect them to your personal Twitter account (or another Twitter account you control). If you want more fine-tuned control, you can manually set up application-level credentials (see below).
To connect to Twitter credentials, first sign in to Twitter with the account you want to use. Then, on the Credentials page, click Connect to Twitter. A window will pop up from Twitter, asking you for authorization. Click authorize, and your credentials will automatically connect.
Once credentials are connected, you can start Creating Collections.
Manually adding Twitter Credentials, rather than connecting them automatically using your Twitter account (see above), gives you greater control over your credentials and allows you to use multiple credentials.
Navigate to https://apps.twitter.com/.
Sign in to Twitter and select “Create New App.”
Enter a name for the app like Social Feed Manager or the name of a new Collection Set.
Enter a description. You may copy and paste: This is a social media research and archival tool, which collects data for academic researchers through an accessible user interface. * Enter a Website such as the SFM url. Any website will work.
Enter a Callback URL such as the same url used for the website field.
Review and agree to the Twitter Developer Agreement and click Create your Twitter Application.
Go to the Credentials page of SFM, and click Add Twitter Credential.
fields in SFM: Access Token and Access Token Secret.
Click Save
Adding Flickr Credentials¶
Adding Tumblr Credentials¶
Adding Weibo Credentials¶
For instructions on obtaining Weibo credentials, see this guide.
To use the connecting credentials approach for Weibo, the redirect URL must match the application’s actual URL and use port 80.
Collection types¶
Each collection type connects to one of a social media platform’s APIs, or methods for retrieving data. Understanding what each collection type provides is important to ensure you collect what you need and are aware of any limitations. Reading the social media platform’s documentation provides further important details.
Twitter user timeline¶
Twitter user timeline collections collect the 3,200 most recent tweets from each of a list of Twitter accounts using Twitter’s user_timeline API.
Seeds for Twitter user timelines are individual Twitter accounts.
To identify a user timeline, you can provide a screen name (the string after @, like NASA for @NASA) or Twitter user ID (a numeric string which never changes, like 11348282 for @NASA). If you provide one identifier, the other will be looked up and displayed in SFM the first time the harvester runs. The user may change the screen name over time, and the seed will be updated accordingly.
The harvest schedule should depend on how prolific the Twitter users are. In general, the more frequent the tweeter, the more frequent you’ll want to schedule harvests.
SFM will notify you when incorrect or private user timeline seeds are requested; all other valid seeds will be collected.
See Incremental collecting to decide whether or not to collect incrementally.
See the Collecting web resources guidance below for deciding whether to collect media or web resources.
Twitter search¶
Twitter searches collect tweets from the last 7-9 days that match search queries, similar to a regular search done on Twitter, using the Twitter Search API. This is not a complete search of all tweets; results are limited both by time and arbitrary relevance (determined by Twitter).
Search queries must follow standard search term formulation; permitted queries are listed in the documentation for the Twitter Search API, or you can construct a query using the Twitter Advanced Search query builder.
Broad Twitter searches may take longer to complete – possibly days – due to Twitter’s rate limits and the amount of data available from the Search API. In choosing a schedule, make sure that there is enough time between searches. (If there is not enough time between searches, later harvests will be skipped until earlier harvests complete.) In some cases, you may only want to run the search once and then turn off the collection.
See Incremental collecting to decide whether or not to collect incrementally.
See the Collecting web resources guidance below for deciding whether to collect media or web resources.
Twitter sample¶
Twitter samples are a random collection of approximately 0.5–1% of public tweets, using the Twitter sample stream, useful for capturing a sample of what people are talking about on Twitter. The Twitter sample stream returns approximately 0.5-1% of public tweets, which is approximately 3GB a day (compressed).
Unlike other Twitter collections, there are no seeds for a Twitter sample.
When on, the sample returns data every 30 minutes.
Only one sample or Twitter filter can be run at a time per credential.
See the Collecting web resources guidance below for deciding whether to collection media or web resources.
Twitter filter¶
Twitter Filter collections harvest a live selection of public tweets from criteria matching keywords, locations, or users, based on the Twitter filter streaming API. Because tweets are collected live, tweets from the past are not included. (Use a Twitter search collection to find tweets from the recent past.)
There are three different filter queries supported by SFM: track, follow, and location.
Track collects tweets based on a keyword search. A space between words is treated as ‘AND’ and a comma is treated as ‘OR’. Note that exact phrase matching is not supported. See the track parameter documentation for more information.
Follow collects tweets that are posted by or about a user (not including mentions) from a comma separated list of user IDs (the numeric identifier for a user account). Tweets collected will include those made by the user, retweeting the user, or replying to the user. See the follow parameter documentation for more information.
Location collects tweets that were geolocated within specific parameters, based on a bounding box made using the southwest and northeast corner coordinates. See the location parameter documentation for more information.
Twitter will return a limited number of tweets, so filters that return many results will not return all available tweets. Therefore, more narrow filters will usually return more complete results.
Only one filter or Twitter sample can be run at a time per credential.
SFM captures the filter stream in 30 minute chunks and then momentarily stops. Between rate limiting and these momentary stops, you should never assume that you are getting every tweet.
There is only one seed in a filter collection. Twitter filter collection are either turned on or off (there is no schedule).
See the Collecting web resources guidance below for deciding whether to collection media or web resources.
Flickr user¶
Flickr User Timeline collections gather metadata about public photos by a specific Flickr user, and, optionally, copies of the photos at specified sizes.
Each Flickr user collection can have multiple seeds, where each seed is a Flickr user. To identify a user, you can provide a either a username or an NSID. If you provide one, the other will be looked up and displayed in the SFM UI during the first harvest. The NSID is a unique identifier and does not change; usernames may be changed but are unique.
Usernames can be difficult to find, so to ensure that you have the correct account, use this tool to find the NSID from the account URL (i.e., the URL when viewing the account on the Flickr website).
Depending on the image sizes you select, the actual photo files will be collected as well. Be very careful in selecting the original file size, as this may require a significant amount of storage. Also note that some Flickr users may have a large number of public photos, which may require a significant amount of storage. It is advisable to check the Flickr website to determine the number of photos in each Flickr user’s public photo stream before harvesting.
For each user, the user’s information will be collected using Flickr’s people.getInfo API and the list of her public photos will be retrieved from people.getPublicPhotos. Information on each photo will be collected with photos.getInfo.
See Incremental collecting to decide whether or not to collect incrementally.
Tumblr blog posts¶
Tumblr Blog Post collections harvest posts by specified Tumblr blogs using the Tumblr Posts API.
Seeds are individual blogs for these collections. Blogs can be specified with or without the .tumblr.com extension.
See Incremental collecting to decide whether or not to collect incrementally.
See the Collecting web resources guidance below for deciding whether to collect image or web resources.
Weibo timeline¶
Weibo Timeline collections harvest weibos (microblogs) by the user and friends of the user whose credentials are provided using the Weibo friends_timeline API.
Note that because collection is determined by the user whose credentials are provided, there are no seeds for a Weibo timeline collection. To change what is being collected, change the user’s friends from the Weibo website or app.
See the Collecting web resources guidance below for deciding whether to collect image or web resources.
Weibo search¶
Collects recent weibos that match a search query using the `Weibo search_topics API<http://open.weibo.com/wiki/2/search/topics>`_. The Weibo API does not return a complete search of all Weibo posts. It only returns the most recent 200 posts matching a single keyword when found between pairs of ‘#’ in Weibo posts (for example: #keyword# or #你好#)
The incremental option will attempt to only count weibo posts that haven’t been harvested before, maintaining a count of non-duplicate weibo posts. Because the Weibo search API does not accept since_id or max_id parameters, filtering out already-harvested weibos from the search count is accomplished within SFM.
When the incremental option is not selected, the search will be performed again, and there will most likely be duplicates in the count.
See the Collecting web resources guidance below for deciding whether to collect image or web resources.
Incremental collecting¶
The incremental option is the default and will collect tweets or posts that have been published since the last harvest. When the incremental option is not selected, the maximum number of tweets or posts will be harvested each time the harvest runs. If a non-incremental harvest is performed multiple times, there will most likely be duplicates. However, with these duplicates, you may be able to track changes across time in a user’s timeline, such as changes in retweet and like counts, deletion of tweets, and follower counts.
Collecting web resources¶
Most collection types allow you to select an option to collect web resources such as images, web pages, etc. that are included in the social media post. When a social media post includes a URL, SFM will harvest the web page at that URL. It will harvest only that web page, not any pages linked from that page.
Be very deliberate in collecting web resources. Performing a web harvest both takes longer and requires significantly more storage than collecting the original social media post.
Data Dictionaries for CSV/Excel Exports¶
Social Feed Manager captures a variety of data from each platform. These data dictionaries give explanations for each selected and processed field in exports.
Note that these are subsets of the data that are collected for each post. The full data is available for export by selecting “Full JSON” as the export format or by exporting from the commandline. See Command-line exporting/processing.
Twitter Dictionary¶
For more info about source tweet data, see the Twitter API documentation, including Tweets and Entities.
Documentation about older archived tweets is archived by the Wayback Machine for the Twitter API, Tweets, and Entities.
Tumblr Dictionary¶
For more info about source tweet data, see the Tumblr API documentation, particularly Posts.
Documentation about older archived posts is archived by the Wayback Machine for the original Tumblr API and the newer Tumblr API.
Flickr Dictionary¶
For more info about source tweet data, see the Flickr API documentation, particularly People and Photos.
Documentation about older archived posts is archived by the Wayback Machine here.
Licensing allowed for media, given as a numeral according to the following key:
Appropriateness of post, given as a numeral according to the following key:
Weibo Dictionary¶
For more info about source tweet data, see the Sina Weibo API friends_timeline documentation.
Documentation about older archived tweets is archived by the Wayback Machine here.
Note that for privacy purposes, Weibo dictionary examples are not consistent.
Command-line exporting/processing¶
While social media data can be exported from the SFM UI, in some cases you may want to export from the commandline. These cases include:
To support export and processing from the commandline, SFM provides a processing container. A processing container is a Linux shell environment with access to the SFM’s data and preloaded with a set of useful tools.
Using a processing container requires familiarity with the Linux shell and shell access to the SFM server. If you are interested in using a processing container, please contact your SFM administrator for help.
When exporting/processing data, remember that harvested social media content and and web resources are stored in
/sfm-data
./sfm-processing
is provided to store your exports, processed data, or scripts. Depending on how it is configured, you may have access to/sfm-processing
from your local filesystem. See Storage.Processing container¶
To bootstrap export/processing, a processing image is provided. A container instantiated from this image is Ubuntu 14.04 and pre-installed with the warc iterator tools,
find_warcs.py
, and some other useful tools. (Warc iterators andfind_warcs.py
are described below.) It will also have read-only access to the data from/sfm-data
and read/write access to/sfm-processing
.The other tools available in a processing container are:
To instantiate a processing container, from the directory that contains your
docker-compose.yml
file:You will then be provided with a bash shell inside the container from which you can execute commands:
Note that once you exit the processing container, the container will be automatically removed. However, if you have saved all of your scripts and output files to
/sfm-processing
, they will be available when you create a new processing container.SFM commandline tools¶
Warc iterators¶
SFM stores harvested social media data in WARC files. A warc iterator tool provides an iterator to the social media data contained in WARC files. When used from the commandline, it writes out the social media items one at a time to standard out. (Think of this as
cat
-ing a line-oriented JSON file. It is also equivalent to the output of Twarc.)Each social media type has a separate warc iterator tool. For example,
twitter_rest_warc_iter.py
extracts tweets recorded from the Twitter REST API. For example:Here is a list of the warc iterators:
twitter_rest_warc_iter.py
: Tweets recorded from Twitter REST API.twitter_stream_warc_iter.py
: Tweets recorded from Twitter Streaming API.flickr_photo_warc_iter.py
: Flickr photosweibo_warc_iter.py
: Weibostumblr_warc_iter.py
: Tumblr postsWarc iterator tools can also be used as a library.
Find Warcs¶
find_warcs.py
helps put together a list of WARC files to be processed by other tools, e.g., warc iterator tools. (It gets the list of WARC files by querying the SFM API.)Here is arguments it accepts:
For example, to get a list of the WARC files in a particular collection, provide some part of the collection id:
(In this case there is only one WARC file. If there was more than one, it would be space separated.)
The collection id can be found from the SFM UI.
Note that if you are running
find_warcs.py
from outside a Docker environment, you will need to supply--api-base-url
.READMEs¶
The exportreadme management command will output a README file that can be used as part of the documentation for a dataset. The README contains information on the collection, including the complete change log. Here is an example of creating a README:
For examples, see the README files in this open dataset.
Note that this is a management command; thus, it is executed differently than the commandline tools described above.
Recipes¶
Extracting URLs¶
The “Extracting URLs from #PulseNightclub for seeding web archiving” blog post provides some useful guidance on extracting URLs from tweets, including unshortening and sorting/counting.
Exporting to line-oriented JSON files¶
This recipe is for exporting social media data from WARC files to line-oriented JSON files. There will be one JSON file for each WARC. This may be useful for some processing or for loading into some analytic tools.
This recipe uses parallel for parallelizing the export.
Create a list of WARC files:
Replace 7c37157 with the first few characters of the collection id that you want to export. The collection id is available on the colllection detail page in SFM UI.
Create a list of JSON destination files:
This command puts all of the JSON files in the same directory, using the filename of the WARC file with a .json file extension.
If you want to maintain the directory structure, but use a different root directory:
Replace sfm-processing/export with the root directory that you want to use.
Perform the export:
Replace twitter_stream_warc_iter.py with the name of the warc iterator for the type of social media data that you are exporting.
You can also perform a filter on export using jq. For example, this only exports tweets in Spanish:
And to save space, the JSON files can be gzip compressed:
You might also want to change the file extension of the destination file to ”.json.gz” by adjusting the commmand use to create the list of JSON destination files. To access the tweets in a gzipped JSON file, use:
Counting posts¶
wc -l can be used to count posts. To count the number of tweets in a collection:
To count the posts from line-oriented JSON files created as described above:
wc -l gotcha: When doing a lot of counting, wc -l will output a partial total and then reset the count. The partial totals must be added together to get the grand total. For example:
Using jq to process JSON¶
For tips on using jq with JSON from Twitter and other sources, see:
Exploring social media data with ELK¶
The ELK (Elasticsearch, Logstash, Kibana) stack is a general-purpose framework for exploring data. It provides support for loading, querying, analysis, and visualization.
SFM provides an instance of ELK that has been customized for exploring social media data. It currently supports data from Twitter and Weibo.
One possible use for ELK is to monitor data that is being harvested to discover new seeds to select. For example, it may reveal new hashtags or users that are relevant to a collection.
Though you can use Logstash and Elasticsearch directly, in most cases you will interact exclusively with Kibana, which is the exploration interface.
Enabling ELK¶
ELK is not available by default; it must be enabled as described here.
You can enable one or more ELK Docker containers. Each container can be configured to be loaded with all social media data or the social media data for a single collection set.
To enable an ELK Docker container it must be added to your
docker-compose.yml
and then started by:An example container is provided in
example.docker-compose.yml
andexample.prod.docker-compose.yml
. These examples also show how to limit to a single collection set by providing the collection set id.By default, Kibana is available at http://<your hostname>:5601/app/kibana. (Also, by default Elasticsearch is available on port 9200 and Logstash is available on port 5000.)
If enabling multiple ELK containers, add multiple containers to your
docker-compose.yml
. Make sure to give each container a unique name and a uniquehostname:
value, and make sure that each container maps to different ports.Loading data¶
ELK will automatically be loaded as new social media data is harvested. (Note, however, that there will be some latency between the harvest and the data being available in Kibana.)
Since only new social media data is added, it is recommended that you enable the ELK Docker container before beginning harvesting.
If you would like to load social media data that was harvested before the ELK Docker container was enabled, use the
resendwarccreatedmsgs
management command:The
resendwarccreatedmsgs
command resends warc_created messages which will trigger the loading of data by ELK.To use this command, you will need to know the routing key. The routing key is
elk_loader_<hostname>.warc_created
. The hostname is available as part of the definition of the ELK container in thedocker-compose.yml
file.The loading can be limited by collection set (
--collection-set
) and/or (--harvest-type
). You can get collection set ids from the collection set detail page. The available harvest types are twitter_search, twitter_filter, twitter_user_timeline, twitter_sample, and weibo_timeline.This shows loading the data limited to a collection set:
Overview of Kibana¶
The Kibana interface is extremely powerful. However, with that power comes complexity. The following provides an overview of some basic functions in Kibana. For some advanced usage, see the Kibana Reference or the Kibana 101: Getting Started with Visualizations video.
When you start Kibana, you probably won’t see any results.
This is because Kibana defaults to only showing data from the last 15 minutes. Use the date picker in the upper right corner to select a more appropriate time range.
Tip: At any time, you can change the date range for your query, visualization, or dashboard using the date picker.
Discover¶
The Discover tab allows you to query the social media data.
By default, all social media types are queried. By limit to a single type (e.g., tweets), click the folder icon and select the appropriate filter.
You will now only see results for that social media type.
Notice that each social media item has a number of fields.
You can search against a field. For example, to find all tweets containing the term “archiving”:
or having the hashtag #SaveTheWeb:
or mentioning @SocialFeedMgr:
Visualize¶
The Visualize tab allows you to create visualizations of the social media data.
The types of visualizations that are supported include:
Describing how to create visualizations is beyond the scope of this overview.
A number of visualizations have already been created for social media data. (The available visualizations are listed on the bottom of the page.)
For example, here is the Top 10 hashtags visualization:
Dashboard¶
The Dashboard tab provides a summary view of data, bringing together multiple visualizations and searches on a single page.
A number of dashboards have already been created for social media data. To select a dashboard, click the folder icon and select the appropriate dashboard.
For example, here is the top of the Twitter dashboard:
Caveats¶
Releasing public datasets¶
Many social media platforms place limitations on sharing of data collected from their APIs. One common approach for sharing data, in particular for Twitter, is to only share the identifiers of the social media items. Someone can then recreate the dataset be retrieving the items from the API based on the identifiers. For Twitter, the process of extracting tweet ids is often called “dehydrating” and retrieving the full tweet is called “hydrating.”
Note that retrieving the entire original dataset may not be possible, as the social media platform may opt to not provide social media items that have been deleted or are no longer public.
This example shows the steps for releasing the Women’s March dataset to Dataverse. The Women’s March dataset was created by GWU and published on the Harvard Dataverse. These instructions can be adapted for publishing your own collections to the dataset repository of your choice.
Note that the Women’s March dataset is a single (SFM) collection. For an example of publishing multiple collections to a single dataset, see the 2016 United States Presidential Election dataset.
Exporting collection data¶
Access the server where your target collection is located and instantiate a processing container. (See Command-line exporting/processing):
Replace
sfmserver.org
with the address of the SFM server that you want export data from.Find a list of WARC files where the data of your target collection are stored, and create a list of WARC files (source.lst) and a list of destination text files. (dest.lst):
Replace
0110497
with the first few characters of the collection id that you want to export. The collection id is available on the collection detail page in SFM UI. (See the picture below.)Write the tweet ids to the destination text files:
This command executes a Twitter Stream WARC iterator to extract the tweets from the WARC files and jq to extract the tweet ids. Parallel is used to perform this process in parallel (using multiple processors), using WARC files from source.lst and text files from dest.lst.
Combine multiple files into large files:
The previous command creates a single text file containing tweet ids for each WARC file. To combine the tweets into a single file:
Create a README file that contains information on each collection (management command for sfm ui):
Exit from the processing container, and connect to the UI container and execute the exportreadme management command to create a README file for the dataset:
Copy the files from the server to your local hard drive:
Exit from the SFM server with
exit
command, move to a location in your local hard drive where you want to store the data, and run the command below:Replace
username
andsfmserver.org
with your user ID and the address of the SFM server, respectively.Publishing collection data on Dataverse¶
For this example, we will be adding the collection to the GW Libraries Dataverse on the Harvard Dataverse instance.
Go to the GW Libraries Dataverse and log in.
Open the New Dataset page:
Click ‘Add Data > New Dataset‘.
Fill the metadata with proper information (title, author, contact, description, subject, keyword):
Make sure you input the right number of tweets collected and appropriate dates in the description.
Upload the files (both data and README files) and save the dataset:
Publish the dataset:
Go to the page of the draft that was just saved, and click ‘Publish‘ button.
Installation and configuration¶
Overview¶
The supported approach for deploying SFM is Docker containers. For more information on Docker, see Docker.
Each SFM service will provide images for the containers needed to run the service (in the form of
Dockerfile
s). These images will be published to Docker Hub. GWU created images will be part of the GWUL organization and be prefixed with sfm-.sfm-docker provides the necessary
docker-compose.yml
files to compose the services into a complete instance of SFM.The following will describe how to setup an instance of SFM that uses the latest release (and is suitable for a production deployment.) See the development documentation for other SFM configurations.
SFM can be deployed without Docker. The various
Dockerfile
s should provide reasonable guidance on how to accomplish this.Local installation¶
Installing locally requires Docker and Docker-Compose. See Installing Docker.
Either clone the sfm-docker repository and copy the example configuration files:
or just download
example.prod.docker-compose.yml
andexample.env
(replacing 1.8.0 with the correct version):Update configuration in
.env
as described in Configuration.Bring up the containers:
It may take several minutes for the images to be downloaded and the containers to start.
It is also recommended that you scale up the Twitter REST Harvester container:
Notes:
Amazon EC2 installation¶
To launch an Amazon EC2 instance running SFM, follow the normal procedure for launching an instance. In Step 3: Configure Instance Details, under Advanced Details paste the following in user details and modify as appropriate as described in Configuration. Also, in the curl statements change master to the correct version, e.g., 1.8.0:
When the instance is launched, SFM will be installed and started.
Note the following:
docker-compose.yml
, you can ssh into the EC2 instance and make changes.docker-compose.yml
and.env
will be in the default user’s home directory.Configuration¶
Configuration is documented in
example.env
. For a production deployment, pay particular attention to the following:SFM_SITE_ADMIN_PASSWORD
,RABBIT_MQ_PASSWORD
,POSTGRES_PASSWORD
, andHERITRIX_PASSWORD
.DATA_VOLUME
andPROCESSING_VOLUME
settings. Host volumes are recommended for production because they allow access to the data from outside of Docker.SFM_HOSTNAME
andSFM_PORT
appropriately. These are the public hostname (e.g., sfm.gwu.edu) and port (e.g., 80) for SFM.SFM_SMTP_HOST
,SFM_EMAIL_USER
, andSFM_EMAIL_PASSWORD
. (If the configured email account is hosted by Google, you will need to configure the account to “Allow less secure apps.” Currently this setting is accessed, while logged in to the google account, via https://myaccount.google.com/security#connectedapps).TWITTER_CONSUMER_KEY
,TWITTER_CONSUMER_SECRET
,WEIBO_API_KEY
,WEIBO_API_SECRET
, and/orTUMBLR_CONSUMER_KEY
,TUMBLR_CONSUMER_SECRET
. These are optional, but will make acquiring credentials easier for users. For more information and alternative approaches see API Credentials.SFM_SITE_ADMIN_EMAIL
. Problems with SFM are sent to this address.SFM_CONTACT_EMAIL
. Users are provided with this address.SFM_INSTITUTION_NAME
andSFM_INSTITUTION_LINK
.HERITRIX_CONTACT_URL
.Note that if you make a change to configuration after SFM is brought up, you will need to restart containers. If the change only applies to a single container, then you can stop the container with
docker kill <container name>
. If the change applies to multiple containers (or you’re not sure), you can stop all containers withdocker-compose stop
. Containers can then be brought back up withdocker-compose up -d
and the configuration change will take effect.Stopping¶
To stop the containers gracefully:
SFM can then be restarted with
docker-compose up -d
.Server restarts¶
If Docker is configured to automatically start when the server starts, then SFM will start. (This is enabled by default when Docker is installed.)
SFM will even be started if it was stopped prior to the server reboot. If you do not want SFM to start, then configure Docker to not automatically start.
To configure whether Docker is automatically starts, see Stopping Docker from automatically starting.
Upgrading¶
Following are general instructions for upgrading SFM versions. Always consult the release notes of the new version to see if any additional steps are required.
Stop the containers gracefully:
This may take several minutes.
Make a copy of your existing
docker-compose.yml
and.env
files:Get the latest
example.prod.docker-compose.yml
. If you previously cloned the sfm-docker repository then:otherwise, replacing 1.8.0 with the correct version:
4. If you customized your previous
docker-compose.yml
file (e.g., for SFM ELK containers), make the same changes in your newdocker-compose.yml
.Make any changes in your
.env
file prescribed by the release notes.Bring up the containers:
It may take several minutes for the images to be downloaded and the containers to start.
Deleting images from the previous version is recommended to prevent Docker from filling up too much space. Replacing 1.5.0 with the correct previous version:
You may also want to periodically clean up Docker (>= 1.13) with
docker system prune
.Server sizing¶
While we have not performed any system engineering analysis of optimal server sizing for SFM, the following are different configurations that we use:
Monitoring¶
There are several mechanisms for monitoring (and troubleshooting) SFM.
For more information on troubleshooting, see Troubleshooting.
Monitor page¶
To reach the monitoring page, click “Monitor” on the header of any page in SFM UI.
The monitor page provides status and queue lengths for SFM components, including harvesters and exporters.
The status is based on the most recent status reported back by each harvester or exporter (within the last 3 days). A harvester or exporter reports its status when it begins a harvest or export. It also reports its status when it completes the harvest or exporter. Harvesters will also provide status updates periodically during a harvest.
Note that if there are multiple instances of a harvester or exporter (created with docker-compose scale), each instance will be listed.
The queue length lists the number of harvest or export requests that are waiting. A long queue length can indicate that additional harvesters or exporters are needed to handle the load (see Scaling up with Docker) or that there is a problem with the harvester or exporter.
The queue length for SFM UI is also listed. This is a queue of status update messages from harvesters or exporters. SFM UI uses these messages to update the records for harvests and exports. Any sort of a queue here indicates a problem.
Logs¶
It can be helpful to peek at the logs to get more detail on the work being performed by a harvester or exporter.
Docker logs¶
The logs for harvesters and exporters can be accessed using Docker’s log commands.
First, determine the name of the harvester or exporter using
docker ps
. In general, the name will be something like sfm_twitterrestharvester_1.Second, get the log with
docker logs <name>
.Add -f to follow the log. For example,
docker logs -f sfm_twitterrestharvester_1
.Add –tail=<number of lines to get the tail of the log. For example,
docker logs --tail=100 sfm_twitterrestharvester_1
.Side note: To follow the logs of all services, use
docker-compose logs -f
.Twitter Stream Harvester logs¶
Since the Twitter Stream Harvester runs multiple harvests on the same host, accessing its logs are a bit different.
First, determine the name of the Twitter Stream Harvester and the container id using
docker ps
. The name will probably be sfm_twitterstreamharvester_1 and the container id will be something like bffcae5d0603.Second, determine the harvest id. This is available from the harvest’s detail page.
Third, get the stdout log with
docker exec -t <name> cat /sfm-data/containers/<container id>/log/<harvest id>.out.log
. To get the stderr log, substitute .err for .out.To follow the log, use tail -f instead of cat. For example,
docker exec -t sfm_twitterstreamharvester_1 tail -f /sfm-data/containers/bffcae5d0603/log/d4493eed5f4f49c6a1981c89cb5d525f.err.log
.Management consoles¶
Several of the services used by SFM offer management consoles that can be useful for monitoring.
For each of these, the username, password, and port are available from your .env file.
RabbitMQ¶
The RabbitMQ Admin is usually available on port 15672. For example, http://localhost:15672/.
Heritrix¶
The Heritrix management console is usually available on port 8443. For example, https://localhost:8443/.
Note that you must used HTTPS to reach the management console. You may be warned by your browser about the certificate; it is safe to proceed.
Administration¶
Designated users have access to SFM UI’s Django Admin interface by selecting Welcome > Admin on the top right of the screen. This interface will allow adding, deleting, or changing database records for SFM UI. Some of the most salient uses for this capability are given below.
Managing groups¶
To allow for multiple users to control a collection set:
Deleting items¶
Records can be deleted using the Admin Interface. It is recommended to minimize deletion; in particular, collections should be turned off and seeds made inactive.
Note the following when deleting:
Moving collections¶
Collections can be moved from one collection set to another. This is done by changing the collection set for the collection in the Admin Interface.
Note the following when moving collections:
Allowing access to Admin Interface¶
To allow a user to have access to the Admin Interface, give the user Staff status or Superuser status. This is done from the user’s admin page.
Authentication¶
Social Feed Manager allows users to self-sign up for accounts. Those accounts are stored and managed by SFM. Future versions of SFM will support authentication against external systems, e.g., Shibboleth.
By default, a group is created for each user and the user is placed in group. To create additional groups and modify group membership use the Admin interface.
In general, users and groups can be administered from the Admin interface.
The current version of SFM is not very secure. Future versions of SFM will more tightly restrict what actions users can perform and what they can view. In the meantime, it is encouraged to take other measures to secure SFM such as restricting access to the IP range of your institution.
Docker¶
This page contains information about Docker that is useful for installation, administration, and development.
Installing Docker¶
Docker Engine and Docker Compose
On OS X:
On Ubuntu:
apt
install, try thepip
install./etc/group
.While Docker is available on other platforms (e.g., Windows, Red Hat Enterprise Linux), the SFM team does not have any experience running SFM on those platforms.
Helpful commands¶
docker-compose up -d
docker-compose pull
docker-compose build
Build images for all of the containers specified in the docker-compose.yml file with the build field. Add--no-cache
docker ps
-a
to also list stopped containers.docker-compose kill
docker kill <container name>
docker-compose rm -v --force
docker rm -v <container name>
docker rm $(docker ps -a -q) -v
docker-compose logs
-f
to follow the logs.docker logs <container name>
-f
to follow the logs.docker-compose -f <docker-compose.yml filename> <command>
docker exec -it <container name> /bin/bash
docker rmi <image name>
docker rmi $(docker images -q)
docker-compose scale <service name>=<number of instances>
Scaling up with Docker¶
Most harvesters and exporters handle one request at a time; requests for exports and harvests queue up waiting to be handled. If requests are taking too long to be processed you can scale up (i.e., create additional instances of) the appropriate harvester or exporter.
To create multiple instances of a service, use docker-compose scale.
The harvester most likely to need scaling is the Twitter REST harvester since some harvests (e.g., broad Twitter searches) may take a long time. To scale up the Twitter REST harvester to 3 instances use:
To spread containers across multiple containers, use Docker Swarm.
Using compose in production provides some additional guidance.
Stopping Docker from automatically starting¶
Docker automatically starts when the server starts. To control this:
Ubuntu 14 (Upstart)¶
Stop Docker from automatically starting:
Allow Docker to automatically start:
Manually start Docker:
Ubuntu 16 (Systemd)¶
Stop Docker from automatically starting:
Allow Docker to automatically start:
Manually start Docker:
Collection set / Collection portability¶
Overview¶
Collections and collection sets are portable. That means they can be moved to another SFM instance or to another environment, such as a repository. This can also be used to backup an SFM instance.
A collection includes all of the social media items and web resources (stored in WARCs) and the database records for the collection sets, collections, users, groups, credentials, seeds, harvests, and WARCs, as well as the history of collection sets, collections, credentials, and seeds. The database records are stored in JSON format in the
records
subdirectory of the collection. Each collection has a complete set of JSON database records to support loading it into a different SFM instance.Here are the JSON database records for an example collection:
Thus, moving a collection set only requires moving/copying the collection set’s directory; moving a collection only requires moving/copying a collection’s directory. Collection sets are in
/sfm-data/collection_set
and are named by their collection set ids. Collections are subdirectories of their collection set and are named by their collection ids.A
README.txt
is automatically created for each collection and collection set. Here aREADME.txt
for an example collection set:Preparing to move a collection set / collection¶
Nothing needs to be done to prepare a collection set or collection for moving. The collection set and collection directories contain all of the files required to load it into a different SFM instance.
The JSON database records are refreshed from the database on a nightly basis. Alternatively, they can be refreshed used the
serializecollectionset
andserializecollection
management commands:Loading a collection set / collection¶
Move/copy the collection set/collection to
/sfm-data/collection_set
. Collection sets should be placed in this directory. Collections should be placed into a collection set directory.Execute the
deserializecollectionset
ordeserializecollection
management command:Note:
Moving an entire SFM instance¶
docker-compose stop
./sfm-data
directory from the source server to the destination server./sfm-processing
directory from the source server to the destination server.docker-compose.yml
and.env
files from the source server to the destination server..env
file, e.g.,SFM_HOSTNAME
.docker-compose up -d
.If moving between AWS EC2 instances and
/sfm-data
is on a separate EBS volume, the volume can be detached from the source EC2 instances and attached to the destination EC2 instance.Storage¶
Storage volumes¶
SFM stores data on 2 volumes:
Volume types¶
There are 2 types of volumes:
The type of volume is specified in the .env file. When selecting a link to a host location, the path on the host environment must be specified:
We recommend that you use an internal volume only for development; for other uses linking to a host location is recommended. This make it easier to place the data on specific storage devices (e.g., NFS or EBS) and to backup the data.
File ownership¶
SFM files are owned by the sfm user (default uid 990) in the sfm group (default gid 990). If you use a link to a host location and list the files, the uid and gid may be listed instead of the user and group names.
If you shell into a Docker container, you will be the root user. Make sure that any operations you perform will not leave behind files that do not have appropriate permissions for the sfm user.
Note then when using Docker for Mac and linking to a host location, the file ownership may not appear as expected.
Directory structure of sfm-data¶
The following is a outline of the structure of sfm-data:
Space warnings¶
SFM will monitor free space on sfm-data and sfm-processing. Administrators will be notified when the amount of free space crosses a configurable threshold. The threshold is set in the .env file:
Moving from a Docker internal volume to a linked volume¶
These instructions are for Ubuntu. They may need to be adjusted for other operating systems.
Stop docker containers:
Copy sfm-data contents from inside the container to a linked volume:
Set ownership:
Change .env:
Restart containers:
Limitations and Known Issues¶
To make sure you have the best possible experience with SFM, you should be aware of the limitations and known issues:
docker-compose scale command
(Ticket 408)We are planning to address these in future releases. In the meantime, there are work-arounds for many of these issues. For a complete list of tickets, see https://github.com/gwu-libraries/sfm-ui/issues
In addition, you should be aware of the following:
Troubleshooting¶
General tips¶
docker ps
.docker-compose logs
anddocker logs <container name>
..env
.Specific problems¶
Skipped harvests¶
A new harvest will not be requested if the previous harvest has not completed. Instead, a harvest record will be created with the status of skipped. Some of the reasons that this might happen include:
After correcting the problem to resume harvesting for a collection, void the last (non-skipped) harvest. To void a harvest, go to that harvest’s detail page and click the void button.
Connection errors when harvesting¶
If harvests from a container fail with something like:
then stop and restart the container. For example:
Bind error¶
If when bringing up the containers you receive something like:
it means another application is already using a port configured for SFM. Either shut down the other application or choose a different port for SFM. (Chances are the other application is Apache.)
Bad Request (400)¶
If you receive a Bad Request (400) when trying to access SFM, your
SFM_HOST
environment variable is not configured correctly. For more information, see ALLOWED_HOSTS.Social Network Login Failure for Twitter¶
If you receive a Social Network Login Failure when trying to connect a Twitter account, make sure that the Twitter app from which you got the Twitter credentials is configured with a callback URL. The URL you provide doesn’t matter.
If you have made a change to the credentials configured in
.env
, try deleting twitter from Social Applications in the admin interface and restarting SFM UI (docker-compose stop ui
thendocker-compose up -d
).Docker problems¶
If you are having problems bringing up the Docker containers (e.g.,
driver failed programming external connectivity on endpoint
), restart the Docker service. On Ubuntu, this can be done with:Web harvesting / Heritrix problems¶
If you are encountering problems with web harvesting, check the logs of the web harvester container (
docker-compose logs webharvester
) and the heritrix container (docker-compose logs heritrix
).If you see a line like
heritrix:8443 not available after wait.
in the web harvester logs and various Java exceptions in the heritrix container logs then kill, remove, and restart the containers:CSV export problems¶
Excel for Mac has problems with unicode characters in CSV files. As a work-around, export to Excel (XLSX) format.
Still stuck?¶
Contact the SFM team. We’re happy to help.
Development¶
Setting up a development environment¶
SFM is composed of a number of components. Development can be performed on each of the components separately.
For SFM development, it is recommended to run components within a Docker environment (instead of directly in your OS, without Docker).
Step 1: Install Docker and Docker Compose¶
See Installing Docker.
Step 2: Clone sfm-docker and create copies of docker-compose files¶
For example:
For the purposes of development, you can make changes to
docker-compose.yml
and.env
. This will be described more below.Step 3: Clone the component repos¶
For example:
Repeat for each of the components that you will be working on. Each of these should be in a sibling directory of sfm-docker.
Running SFM for development¶
To bring up an instance of SFM for development, change to the sfm-docker directory and execute:
You may not want to run all of the containers. To omit a container, simply comment it out in
docker-compose.yml
.By default, the code that has been committed to master for each of the containers will be executed. To execute your local code (i.e., the code you are editing), you will want to link in your local code. To link in the local code for a container, uncomment the volume definition that points to your local code. For example:
sfm-utils and warcprox are dependencies of many components. By default, the code that has been committed to master for sfm-utils or warcprox will be used for a component. To use your local code as a dependency, you will want to link in your local code. Assuming that you have cloned sfm-utils and warcprox, to link in the local code as a dependency for a container, change
SFM_REQS
in.env
to “dev” and comment the volume definition that points to your local code. For example:Note: * As a Django application, SFM UI will automically detect code changes and reload. Other components must be killed and brought back up to reflect code changes.
Running tests¶
Unit tests¶
Some components require a
test_config.py
file that contains credentials. For example, sfm-twitter-harvester requires atest_config.py
containing:Note that if this file is not present, unit tests that require it will be skipped. Each component’s README will describe the
test_config.py
requirements.Unit tests for most components can be run with:
The notable exception is SFM UI, which can be run with:
Integration tests¶
Many components have integration tests, which are run inside docker containers. These components have a
ci.docker-compose.yml
file which can be used to bring up a minimal environment for running the tests.As described above, some components require a
test_config.py
file.To run integration tests, bring up SFM:
Run the tests:
You will need to substitute the correct name of the container. (
docker ps
will list the containers.)And then clean up:
For reference, see each component’s
.travis.yml
file which shows the steps of running the integration tests.Smoke tests¶
sfm-docker contains some smoke tests which will verify that SFM is running correctly.
To run the smoke tests, first bring up SFM:
and then run the tests:
Note that the smoke tests are not yet complete.
For reference, the continuous integration deploy instructions shows the steps of running the smoke tests.
Requirements files¶
This will vary a depending on whether a project has warcprox and sfm-utils as a dependency, but in general:
requirements/common.txt
contains dependencies, except warcprox and sfm-utils.requirements/release.txt
references the last released version of warcprox and sfm-utils.requirements/master.txt
references the master version of warcprox and sfm-utils.requirements/dev.txt
references local versions of warcprox and sfm-utils in development mode.To get a complete set of dependencies, you will need
common.txt
and eitherrelease.txt
,master.txt
ordev.txt
. For example:Development tips¶
Admin user accounts¶
Each component should automatically create any necessary admin accounts (e.g., a django admin for SFM UI). Check
.env
for the username/passwords for those accounts.RabbitMQ management console¶
The RabbitMQ management console can be used to monitor the exchange of messages. In particular, use it to monitor the messages that a component sends, create a new queue, bind that queue to sfm_exchange using an appropriate routing key, and then retrieve messages from the queue.
The RabbitMQ management console can also be used to send messages to the exchange so that they can be consumed by a component. (The exchange used by SFM is named sfm_exchange.)
For more information on the RabbitMQ management console, see RabbitMQ.
Blocked ports¶
When running on a remote VM, some ports (e.g., 15672 used by the RabbitMQ management console) may be blocked. SSH port forwarding can help make those ports available.
Django logs¶
Django logs for SFM UI are written to the Apache logs. In the docker environment, the level of various loggers can be set from environment variables. For example, setting SFM_APSCHEDULER_LOG to DEBUG in the docker-compose.yml will turn on debug logging for the apscheduler logger. The logger for the SFM UI application is called ui and is controlled by the SFM_UI_LOG environment variable.
Apache logs¶
In the SFM UI container, Apache logs are sent to stdout/stderr which means they can be viewed with docker-compose logs or docker logs <container name or id>.
Initial data¶
The development and master docker images for SFM UI contain some initial data. This includes a user (“testuser”, with password “password”). For the latest initial data, see fixtures.json. For more information on fixtures, see the Django docs.
Runserver¶
There are two flavors of the the development docker image for SFM UI. gwul/sfm-ui:master runs SFM UI with Apache, just as it will in production. gwul/sfm-ui:master-runserver runs SFM UI with runserver, which dynamically reloads changed Python code. To switch between them, change UI_TAG in .env.
Note that as an byproduct of how runserver dynamically reloads Python code, there are actually 2 instances of the application running. This may produce some odd results, like 2 schedulers running. This will not occur with Apache.
Job schedule intervals¶
To assist with testing and development, a 5 minute interval can be added by setting SFM_FIVE_MINUTE_SCHEDULE to True in the docker-compose.yml.
Connecting to the database¶
To connect to postgres using psql:
You will be prompted for the password, which you can find in .env.
Docker tips¶
Building vs. pulling¶
Containers are created from images. Images are either built locally or pre-built and pulled from Docker Hub. In both cases, images are created based on the docker build (i.e., the Dockerfile and other files in the same directory as the Dockerfile).
In a docker-compose.yml, pulled images will be identified by the image field, e.g., image: gwul/sfm-ui:master. Built images will be identified by the build field, e.g., build: app-dev.
In general, you will want to use pulled images. These are automatically built when changes are made to the Github repos. You should periodically execute docker-compose pull to make sure you have the latest images.
You may want to build your own image if your development requires a change to the docker build (e.g., you modify fixtures.json).
Killing, removing, and building in development¶
Killing a container will cause the process in the container to be stopped. Running the container again will cause process to be re-started. Generally, you will kill and run a development container to get the process to be run with changes you’ve made to the code.
Removing a container will delete all of the container’s data. During development, you will remove a container to make sure you are working with a clean container.
Building a container creates a new image based on the Dockerfile. For a development image, you only need to build when making changes to the docker build.
Writing a harvester¶
Requirements¶
Suggestions¶
Notes¶
Messaging¶
RabbitMQ¶
RabbitMQ is used as a message broker.
The RabbitMQ managagement console is exposed at
http://<your docker host>:15672/
. The username issfm_user
. The password is the value ofRABBITMQ_DEFAULT_PASS
insecrets.env
.Publishers/consumers¶
mq
and the port is 5672.rabbit
. See appdeps.py for docker application dependency support.Exchange¶
sfm_exchange
is a durable topic exchange to be used for all messages. All publishers/consumers must declare it.:Queues¶
All queues must be declared durable.:
Messaging Specification¶
Introduction¶
SFM is architected as a number of components that exchange messages via a messaging queue. To implement functionality, these components send and receive messages and perform certain actions. The purpose of this document is to describe this interaction between the components (called a “flow”) and to specify the messages that they will exchange.
Note that as additional functionality is added to SFM, additional flows and messages will be added to this document.
General¶
Harvesting social media content¶
Harvesting is the process of retrieving social media content from the APIs of social media services and writing to WARC files. It also includes extracting urls for other web resources from the social media so that they can be harvested by a web harvester. (For example, the link for an image may be extracted from a tweet.)
Background information¶
Flow¶
The following is the flow for a harvester performing a REST harvest and creating a single warc:
The following is the message flow for a harvester performing a stream harvest and creating multiple warcs:
Messages¶
Harvest start message¶
Harvest start messages specify for a harvester the details of a harvest. Example:
Another example:
Web resource harvest start message¶
Harvesters will extract urls from the harvested social media content and publish a web resource harvest start message. This message is similar to other harvest start messages, with the differences noted below. Example:
Harvest stop message¶
Harvest stop messages tell a harvester perform a stream harvest to stop. Example:
Harvest status message¶
Harvest status messages allow a harvester to provide information on the harvests it performs. Example:
Warc created message¶
Warc created message allow a harvester to provide information on the warcs that are created during a harvest. Example:
Exporting social media content¶
Exporting is the process of extracting social media content from WARCs and writing to export files. The exported content may be a subset or derivate of the original content. A number of different export formats will be supported.
Background information¶
Flow¶
The following is the flow for an export:
Export start message¶
Export start messages specify the requests for an export. Example:
Another example:
Export status message¶
Export status messages allow an exporter to provide information on the exports it performs. Example: