Create and Import CSV file into Database

Linkedin’s Industry Codes import sqlite3, os, csv conn = sqlite3.connect(‘industry_classifications’)curs = conn.cursor() tblcmd = ‘create table linkedin_industries (code int(3), groups char(60), description char(60))’curs = conn.execute(‘select * from linkedin_industries’)names = [description[0] for description in curs.description]namescurs.execute(tblcmd)curs.rowcount file = r’C:projectsLinkedinIndustry Codes.csv’ with open(file, ‘r’, encoding=’utf-8′) as f:    readCSV = csv.reader(f, delimiter=’,’)    for row in readCSV:        curs.execute(‘INSERT INTO linkedin_industries (code, groups, description) VALUES (?, ?, ?)’, row) curs.execute(‘select * from linkedin_industries’)for rec in curs.fetchall(): print(rec) conn.commit()

Add Chrome app to Secondary taskbar w/ icon

Now that my beloved chrome app launcher is gone, I’ve had to find another way to launch my apps.  I used Feedly, but process should be same for others. 1)       Goto chrome://apps/, right click icon, click Create shortcuts… (shortcut will be created on Desktop) a.        2)       Goto desktop, right click icon, properties, select everything in target…

Setting up Windows Shebang using Anaconda

Download and install Py Launcher (it will install py.exe to c:windows)https://bitbucket.org/vinay.sajip/pylauncher/downloads/ https://bitbucket.org/vinay.sajip/pylauncher/downloads/launchwin-1.0.1.6.amd64.msi ^direct url Download and install Anaconda (I install in c:PYTHON instead of default c:anaconda3) https://repo.continuum.io/archive/Anaconda3-4.2.0-Windows-x86_64.exe Create two environments (using command prompt) $ conda create —name py27 python=2.7.11      # creates python 2 environment $ conda create —name py35 python=3.5.2       # creates python 3 environment $ conda info —envs      # lists currently installed environments $ activate py27      # test python 2 environment $ activate py35      # test python 3 environment $ deactivate Setting up Shebang for Python 3 and Python 2 environment:…

GUACAMOLE (0.9.9) on UBUNTU 16.10 and TOMCAT8

Stumbled across this interesting app when searching for reverse remote desktop. #!/bin/bash# Original December 19 2015 Guacamole with MySQL on Ubuntu RDP Fix Published by Chase # http://chasewright.com/guacamole-with-mysql-on-ubuntu/ Thanks Chase!# WORKING ON UBUNTU 16.10 WITH GUAC 0.9.9 AND TOMCAT8# edited 07-10-16apt-get update && apt-get -y dist-upgrade#install and add java ENVapt-get -y install openjdk-8-jre-headlessalternative=java-8-openjdk-armhfexport JAVA_HOME=/usr/lib/jvm/$alternativeecho $JAVA_HOME#Install…

Start/Stop Google Music in Car Automatically

Description:  IF bluetooth network “BTC450” connects to phone THEN simulate Play Media OS – Android Version:  6.0.1App – Tasker [Link] – can use this or Trigger [Link]App – Bluetooth Auto Connect [Link] – not required, but use to prioritize my car bluetooth over headphone bluetoothApp – Google Music [Link] – not required, but like automatic playlist updating so…