Tyler Tresslar ttresslar

## instabot1.py
from selenium import webdriver
from selenium.webdriver.common.keys import Keys
from time import sleep, strftime
from random import randint
import pandas as pd

chromedriver_path = 'C:/Users/User/Downloads/chromedriver_win32/chromedriver.exe' # Change this to your own chromedriver path!
webdriver = webdriver.Chrome(executable_path=chromedriver_path)
sleep(2)
webdriver.get('https://www.instagram.com/accounts/login/?source=auth_switcher')

## exploring_epicollect.html
<!DOCTYPE html>
<html>
<head><meta charset="utf-8" />

<title>exploring_epicollect</title>

<script src="https://cdnjs.cloudflare.com/ajax/libs/require.js/2.1.10/require.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/2.0.3/jquery.min.js"></script>


## multithread_scraping.py
import pandas as pd
import requests, re, datetime, urllib.parse
from bs4 import BeautifulSoup as bs
from multiprocessing.pool import ThreadPool


def get_datelist():
    base_time = datetime.datetime.today()
    base_time = base_time.replace(hour=0, second=0, minute=0, microsecond=0)
    date_list = [base_time + datetime.timedelta(days=x) for x in range(1, 15)]

## gsQGIS.py
#This is designed to be used with the google sheets python api
#Please see the "https://developers.google.com/sheets/api/quickstart/python" Google Python API Quickstart and follow the steps listed there.
#You will need to authorize the API and download a file called "credentials.json" for the account you wish to use


#load the required packages/libraries/etc
from __future__ import print_function
import pickle
import os.path
from googleapiclient.discovery import build

## EpicollectQGIS.py
#!/usr/bin/env python3
# -*- coding: utf-8 -*-
#This is a short script I created to add epicollect entries to QGIS.


"""
Created on Mon Mar 25 05:14:27 2019
@author: ttresslar
"""

## ssToSQLInsert.gs
//Setting Global variables for the apps I'll be using
var SS = SpreadsheetApp.getActiveSheet()
var UI = SpreadsheetApp.getUi();

//On open is a reserved function. It runs every time a user opens the sheet.
//I'm using it to make the menu
function onOpen() {
  var UI = SpreadsheetApp.getUi();
  UI.createMenu('Data Archtects')
      .addItem('Insert This data', 'makeItHot')
	from selenium import webdriver
	from selenium.webdriver.common.keys import Keys
	from time import sleep, strftime
	from random import randint
	import pandas as pd

	chromedriver_path = 'C:/Users/User/Downloads/chromedriver_win32/chromedriver.exe' # Change this to your own chromedriver path!
	webdriver = webdriver.Chrome(executable_path=chromedriver_path)
	sleep(2)
	webdriver.get('https://www.instagram.com/accounts/login/?source=auth_switcher')
	<!DOCTYPE html>
	<html>
	<head><meta charset="utf-8" />

	<title>exploring_epicollect</title>

	<script src="https://cdnjs.cloudflare.com/ajax/libs/require.js/2.1.10/require.min.js"></script>
	<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/2.0.3/jquery.min.js"></script>
	import pandas as pd
	import requests, re, datetime, urllib.parse
	from bs4 import BeautifulSoup as bs
	from multiprocessing.pool import ThreadPool


	def get_datelist():
	base_time = datetime.datetime.today()
	base_time = base_time.replace(hour=0, second=0, minute=0, microsecond=0)
	date_list = [base_time + datetime.timedelta(days=x) for x in range(1, 15)]
	#This is designed to be used with the google sheets python api
	#Please see the "https://developers.google.com/sheets/api/quickstart/python" Google Python API Quickstart and follow the steps listed there.
	#You will need to authorize the API and download a file called "credentials.json" for the account you wish to use


	#load the required packages/libraries/etc
	from __future__ import print_function
	import pickle
	import os.path
	from googleapiclient.discovery import build
	#!/usr/bin/env python3
	# -- coding: utf-8 --
	#This is a short script I created to add epicollect entries to QGIS.


	"""
	Created on Mon Mar 25 05:14:27 2019
	@author: ttresslar
	"""
	//Setting Global variables for the apps I'll be using
	var SS = SpreadsheetApp.getActiveSheet()
	var UI = SpreadsheetApp.getUi();

	//On open is a reserved function. It runs every time a user opens the sheet.
	//I'm using it to make the menu
	function onOpen() {
	var UI = SpreadsheetApp.getUi();
	UI.createMenu('Data Archtects')
	.addItem('Insert This data', 'makeItHot')