This is a CasperJS/PhantomJS-PHP/MySQL/Apache2-Flask/Jinja2/MySQL mess.
This is the AUTOLINKER. A program to automatically send out messages to people on linkedIn.
Import Vagrant
$>
From pre-built box:
vagrant box add precise32 https://dl.dropboxusercontent.com/u/3132018/linkedin-message.box (or vagrant box add hashicorp/precise32 for a new one)
vagrant init linkedin-message.box
From Scratch:
vagrant box add hashicorp/precise32
vagrant init hashicorp/precise32
vagrant up
vim VagrantFileconfig.vm.network "forwarded_port", guest: 5000, host: 5000
config.vm.network "forwarded_port", guest: 80, host: 4999Setup Vagrant
$>
vagrant reload
vagrant up
vagrant ssh
# Install LinkedIn-Sales-Tool pre-requisites
sudo apt-get update
sudo apt-get install apache2 mysql-server libapache2-mod-auth-mysql php5-mysql php5 libapache2-mod-php5 php5-mcrypt phpmyadmin python-dev python-mysqldb vim
sudo apt-get install python-pip
sudo apt-get install git
sudo pip install flask SQLAlchemy flask-mail flask-wtf pycrypto Flask-SQLAlchemy
# Setup PHPMyAdmin
sudo ln -s /usr/share/phpmyadmin/ /var/www/phpmyadmin
sudo /etc/init.d/apache2 restart
# Pull LinkedIn-Sales-Tool
git clone https://USERNAMEHERE@bitbucket.org/dasickis/linkedin-sales-tool.git
Setup Databases
http://localhost:4999/phpmyadmin
- Create database called linkedInSales
- Click import database from dropbox/derivative/derivative
Setup PhantomJS/CasperJS
$>
# Go back into Vagrant
vagrant ssh
cd linkedin-sales-tool/linkedInSales/
# Install PhantomJS pre-requisites
sudo apt-get install build-essential chrpath git-core libssl-dev libfontconfig1-dev
# Install PhantomJS
wget https://bitbucket.org/ariya/phantomjs/downloads/phantomjs-1.9.7-linux-i686.tar.bz2
tar xvjf phantomjs-1.9.7-linux-i686.tar.bz2
sudo rm phantomjs-1.9.7-linux-i686.tar.bz2
sudo ln -s `pwd`/phantomjs-1.9.7-linux-i686.tar.bz2/bin/phantomjs /usr/local/bin/phantomjs
# Install Casper
git clone git://github.com/n1k0/casperjs.git
cd casperjs
sudo ln -sf `pwd`/bin/casperjs /usr/local/bin/casperjs
sudo apt-get install nodejs
curl -L https://npmjs.org/install.sh | sudo sh
sudo npm install -g underscore
cd flaskApp
npm install lodash-node
cd ..Run LinkedIn-Sales-Tool
$>
python runserver.py-
Load Dash
Dash Flask DB -------------> POST: /load_dash -------------> POST: Request <------------- [Listof Users], [Listof pitches], URLs, # of ppl left per URL <-------------- Users, pitches, URLs, # of ppl left per URL -
Create Smarketer
Dash Flask DB -------------> POST: /signup username, password, firstName -------------> ROUTE: addSmarketer username, password, firstName <------------- True <-------------- True -
Create Group
Dash Flask DB -------------> POST: /addGroup groupID, title -------------> ROUTE: addGroup groupID, title <------------- True <-------------- True -
Create DiscussionThread
Dash Flask DB Casper LinkedIn -------------> POST: /addDiscussionThread User Discussion URL -----------> POST: /ask_pass User <---------- First Name Pass --------------------> COMMAND LINE: import_discussion User Pass First Name Discussion URL -----------------> Login: User,Pass <---------------- Homepage -----------------> Goto: Discussion URL <----------------- Discussion page -----------------> Load More: comments <----------------- Additional comments <---------------------- POST: /store_comments [Listof `comment`s] -----------> [Listof `comment`s] -
Create Pitch
Dash Flask DB --------------> POST: /addPitch subject, message, title -------------> ROUTE: addPitch subject, message, title <------------- True <-------------- True -
Send Pitch
Dash Flask DB Casper LinkedIn --------------> POST: /send_pitch Username Password First Name Pitch UserID Group ID ---------------> # of messages to send, url <-------------- [Listof userId] ---------------> user <-------------- pass ----------------------------> Pitch, User, Pass, Group Id, [Listof UserIds] <---------------------------- POST: /store_successful [Listof UserIds] ---------------> [listof userids], pitch -
Create Reply
Dash Flask DB --------------> POST: addReply message, fromWarehousePerson?, fromSmarketer?, conversationStarterID -------------> ROUTE: addReply message, fromWarehousePerson?, fromSmarketer?, conversationStarterID <------------- True <-------------- True
=======
#Database Diagram
-
smarketers are us
-
pitches are the automated pitches we are sending out
-
groups are the linkedIn groups that we joined
-
discussionThreads are the threads from the groups
-
warehousePeople are the people are potential customers found from discussionThreads
-
conversationStarters are the first message we send out. They send a Pitch from a smarketer to a warehousePeople.
-
replies are messages sent after the initial message of a conversationStarter between a smarketer and a warehousePeople
