#396 Importing CSV and Excel

Dec 08, 2012 | 10 minutes | Plugins

Allow users to import records into the database by uploading a CSV or Excel document. Here I show how to use Roo to parse these files and present a solution for validations.

Click to Play Video ▶

Download:
source codeProject Files in Zip (90.8 KB)
mp4Full Size H.264 Video (24.6 MB)
m4vSmaller H.264 Video (12 MB)
webmFull Size VP8 Video (14.8 MB)
ogvFull Size Theora Video (29.5 MB)

Episode #380 – Sep 12, 2012 – 83 comments

Memcached & Dalli

Memcached is an excellent cache store, and Dalli is the best way to interact with it through Ruby. Here I show various ways to use Memcached in a Rails app including how to set it up in production. (12 minutes)

Watch Episode Read Episode

Episode #379 – Sep 04, 2012 – 67 comments

Template Handlers

Here I will demonstrate creating two template handlers. One for Ruby which is great for JSON or CSV formats. Another for interpreting Markdown which is useful for informational content. (12 minutes)

Watch Episode Read Episode

Episode #376 – Aug 30, 2012 – 81 comments

JRuby Basics

JRuby is a polished and stable Ruby implementation. Here I show the basics of setting it up and executing Java from within Ruby. I also see how it compares with MRI at running threads. (10 minutes)

Watch Episode Read Episode

Episode #362 – Jul 02, 2012 – 160 comments

Exporting CSV and Excel

As you will see it is easy to add a CSV export option to Rails. Here I also show how to export for Excel in a variety of formats. (6 minutes)

Watch Episode Read Episode

Episode #357 – Jun 08, 2012 – 79 comments

Adding SSL

It is important to protect a user's private information with HTTPS. Here you will learn how to get it working on your local machine, configure Rack SSL, install certificates for production, and more. (14 minutes)

Watch Episode Read Episode