Loading data into Engine

Describes an example of collecting Tweets, loading them into Engine, validating them, and sending Tweets.

Collecting received Tweets (ReceiveTweets.ktr)

The main transformation run for collecting Tweets. If you want to insert a filter, insert the values in the relevant text fields. Leave the transformation running as long as required. However, to be able to run the next part (loading Tweets to Engine) it is necessary that collecting Tweets has finished. 

Note: Remove any parameters you are not using, or an error is raised in Spoon.

Loading Tweets to Engine (LoadTweetsToEngine.kjb)

When this job is run, the Tweets received when running ReceiveTweets.ktr are decoded (they are in JSON format) and made in to columns|values format. After this, they are written in an Engine format and loaded into Engine.

Validating data in Engine

If logged to Engine, the database will be created with the corresponding fields. All the Tweets that were received should have been inserted in Engine.

Sending Tweets (PostDirectMessagesExample.ktr)

A simple example is provided with the plugin that sends a private message to each of the provided users.

The input can be in any format - text file, grid, csv file (for example, for an omnitactic).

• Using the Twitter plugin
  • Twitter Plugin Options - Keys
  • Twitter Plugin Options - Receive Mode
  • Twitter Plugin Options - Post Mode
  • Twitter Plugin Options - Direct Message Mode
  • Tweeting Limits When Using the Twitter Plugin
  • Data Available Twitter Plugin
  • Integrating Twitter in Campaign Manager
  • Loading Data Into Engine
  • Running the scripts using Pan