On Mar 23, 2011, at 9:42 AM, Surya wrote: > Hi, > > First of all very sorry for this long post. I am trying to save my csv data > to table items which is associated with Item model. > > This is what my csv have: > 'name';'number';'sub_category_id';'category_id';'quantity';'sku'; > 'description';'cost_price';'selling_price' > 'Uploaded Item Number 1';'54';'KRT';'WN';'67';'WNKRT0054';'Some Description > here!!';'780';'890' > 'Uploaded Item Number 2';'74';'KRT';'WN';'98;'WNKRT0074';'Some Description > here!!';'8660';'9790' > > First row show the fields for items table. > > Here I am using fastercsv to process my csv and paperclip to upload. > > I am able to process file read content and able to fill up the field too here > is the processing code: > > def proc_csv > @import = Import.find(params[:id]) > @lines = parse_csv_file(@import.csv.path) > @lines.shift
As others have pointed out, this isn't the right place for this. In any case, I suspect your issue is that Excel has spit out a UTF-16 file and you didn't tell whatever's parsing it about that... --Matt Jones -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Core" group. To post to this group, send email to rubyonrails-core@googlegroups.com. To unsubscribe from this group, send email to rubyonrails-core+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/rubyonrails-core?hl=en.