Categories
Heroku, Google App Engine, Django Salesforce

Salesforce CSV Export to Heroku PostgreSQL

I created a Python script to take all Salesforce CSV data export files and import them to a PostgreSQL database. The script is currently in use for a Heroku project I completed.

See the code here: https://github.com/rtoepfer/salesforce-data-import-postgresql

Categories
Heroku, Google App Engine, Django

Developers and Side Projects

There’s a great article on Medium about Developer ADHD. The author explains why some developers have lots of unfinished side projects. Like the author I too have several unfinished side projects. I find I usually will give up on a side project after I’ve fully learned the underlying technology. Here’s the rundown of a few of these projects.

  1. Autodesk Revit PDF Printouts
    This app was actually the idea of one of my clients that I created during a lull in work. I tried a Kickstarter project to get funding but was unsuccessful so abandoned the project. There was a working demo that printed PDF drawings from Revit that were interlinked. Everything coded in C#.
    Revit1
    Revit2
    Revit3
  2. Business Foot Traffic Social Media Statistics
    I had the grand idea of tracking Facebook and Foursquare usage at a place of business. Unfortunately, Foursquare fell out of favor and I never finished the demo.

     

    Foursquare1
    Foursquare2

  3. World Newspaper App
    I did this demo almost 10 years ago when Extjs was the rage and YUI was still relevant. Its a map of the world with clickable newspaper icons that pulled in a RSS feed.

     

    Menkyo1
    Menkyo2

  4. Law School Notes App                                                            Instead of paying attention during classes in law school I created this app in Extjs to automate note taking.

    notes1
    notes2

5. DeliciouRSS Reader

This was my first project on Google App Engine in order to get acquainted with the platform and technology. https://deliciourss.appspot.com/

Categories
Heroku, Google App Engine, Django

Commodity Inspections Application

I’ve been working on an application for inspecting Mississippi River cargo ships that hold agricultural commodities. I developed the app in Python on Google App Engine using the Django framework and used Bootstrap as the front-end framework. The project has been managed via a Kanboard on Zydeco’s website.

Here are a few screenshots:

Main Vessel table

The main vessel table shows the status of ongoing jobs and was built via customizing an open-source table plugin.

Job entry form

Entering job information is painless on desktop, tablet and mobile devices thanks to Bootstrap4’s responsive layout features.

Django administration

The use of the Django framework provides a pre-built administration portal that allows adding lists, users, and other items to the database in a simple manner. The use of the Django backend cut project costs for my client in half.

The use of Bootstrap allowed the same code to seamlessly show data on mobile devices.