02 Jan '13, 1am

Importing CSV and Excel #rails #asciicasts

In episode 362 we showed how to export database records to a CSV or Excel file. Since then there have been a number of requests for an episode showing how to import records from these types of files so that’s what we’ll cover in this episode. We’ll do this by adding a form to the bottom of this page that will allow the user to upload a file containing records. When the form is submitted the file will be parsed and the records added to the database. We’ll add the form at the bottom of the view template /app/views/products/index.html.erb Import Products We don’t have an object to handle the importing right now so we’ve used form_tag instead of form_for . The form will be submitted to a new import action on the ProductsController and note that we’ve set the multipart option so that the form can handle file uploads. We’ll need to set up the new path in the routes file so we’ll...

Full article: http://asciicasts.com/episodes/396-importing-csv-and-excel

Tweets

Watching What's New in Rails 4 on RailsCasts

railscasts.com 04 Jan '13, 10am

git clone https://github.com/rails/rails.git cd rails bundle gem install bundler --pre bundle railties/bin/rails new ~/cod...

#webmarketing Post : Excel Statistics for SEO a...

seomoz.org 05 Jan '13, 1am

Everybody has probably already realized that there is almost no data that we cannot get. We can get data about our website...

Fivefootway, Episode IV: A new hope

fivefootway.com 01 Jan '13, 4pm

This post took weeks to write. After the adventures of 2012 that counts the bold reboot of the magazine and the curation o...

Excel Statistics for SEO and Data Analysis

seomoz.org 04 Jan '13, 7pm

Everybody has probably already realized that there is almost no data that we cannot get. We can get data about our website...

Calculate standard resistor values in Excel:

Calculate standard resistor values in Excel:

edn.com 03 Jan '13, 3pm

Using standard resistor values can greatly impact the accuracy and predictability of a circuit by eliminating rounding err...

Another episode of @rubyfive is available for y...

ruby5.envylabs.com 04 Jan '13, 4pm

December 21st, 2012 Concerns about DCI? Grab a teabag and Tries, and JWalk with Ruby on Android, it's the end of the world...

Great feature abt music businesses & the music ...

video.xin.msn.com 03 Jan '13, 7am

“ARTreprenuer” is a 6 episode info-ed series that explores the world of art and creative endeavors from the one thing all ...

Excel Statistics for SEO and Data Analysis

seomoz.org 31 Dec '12, 3pm

Everybody has probably already realized that there is almost no data that we cannot get. We can get data about our website...

Excel Statistics for SEO and Data Analysis via ...

seomoz.org 06 Jan '13, 3pm

Everybody has probably already realized that there is almost no data that we cannot get. We can get data about our website...

Advanced Filters: Excel's Amazing Alternative To Regex

Advanced Filters: Excel's Amazing Alternative T...

searchengineland.com 04 Jan '13, 5pm

If you accidentally include blank cells at the bottom of your criteria range, you will cancel out your criteria because Ex...