Hello everyone,
I am very new to Ruby on Rails, and I am working on a project that
involves uploading a CSV and putting it in the database. It works great,
but I need to omit the first line of the CSV. My code looks likes this:
require ''csv''
class ImportController < ApplicationController
def import
currenttime = DateTime.now
@parsed_file=CSV::Reader.parse(params[:dump][:file])
n=0
@parsed_file.each do |row|
c=Import.new
c.prov_info_fac=row[0]
c.prov_info_bac=row[4]
c.prov_info_datatype=row[2]
c.prov_service_name=row[1]
c.prov_service_number=row[3]
c.prov_service_provider=row[5]
c.prov_charges_tot_access=row[7]
c.prov_charges_tot_airtime=row[8]
c.prov_charges_tot_kb=row[9]
c.prov_charges_tot_messaging=row[10]
c.prov_charges_tot_features=row[13]
c.prov_charges_tot_equipment=row[26]
c.prov_charges_tot_longdistance=row[27]
c.prov_charges_tot_roaming=row[31]
c.prov_charges_tot_misc=row[39]
c.prov_charges_tot_other=row[42]
c.prov_charges_tot_taxesfees=row[43]
c.prov_charges_messaging_sms=row[11]
c.prov_charges_messaging_mms=row[12]
c.prov_charges_feat_basicvoice=row[14]
c.prov_charges_feat_voicemail=row[15]
c.prov_charges_feat_wos=row[16]
c.prov_charges_feat_aod=row[17]
c.prov_charges_feat_intnl=row[18]
c.prov_charges_feat_mou=row[19]
c.prov_charges_feat_data=row[20]
c.prov_charges_feat_vidshare=row[21]
c.prov_charges_feat_wifi=row[22]
c.prov_charges_feat_messaging=row[23]
c.prov_charges_feat_otherfees=row[24]
c.prov_charges_feat_otherfeat=row[25]
c.prov_charges_ld_local=row[28]
c.prov_charges_ld_intnl=row[29]
c.prov_charges_ld_directory=row[30]
c.prov_charges_roam_airtime=row[32]
c.prov_charges_roam_kb=row[33]
c.prov_charges_roam_surcharges=row[34]
c.prov_charges_roam_ld=row[35]
c.prov_charges_roam_intnl=row[36]
c.prov_charges_roam_intnl_ld=row[37]
c.prov_charges_roam_taxes=row[38]
c.prov_charges_misc_voice=row[40]
c.prov_charges_misc_data=row[41]
c.prov_updated_date=currenttime
if c.save
n=n+1
GC.start if n%50==0
end
flash.now[:message] = ''CSV Import Successful''
end
def delete
Import.destroy
redirect_to :action => ''index''
end
end
Thanks for you help!!
- Jeff
--
Posted via http://www.ruby-forum.com/.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---
Jeff, Try the following - where you currently have this: @parsed_file.each do |row| ... end Do this: @parsed_file.each_with_index do |row, row_index| next if (row_index == 0) ... end On Jan 16, 1:38 pm, Jeff Miller <rails-mailing-l...-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org> wrote:> Hello everyone, > I am very new to Ruby on Rails, and I am working on a project that > involves uploading a CSV and putting it in the database. It works great, > but I need to omit the first line of the CSV. My code looks likes this: >--~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
Thank you, sir! I ended up using @parsed_file.shift, which worked great. -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---