similar to: Strategy for importing temporary .csv file?

Displaying 20 results from an estimated 1000 matches similar to: "Strategy for importing temporary .csv file?"

2008 Feb 16
2
NoMethodError... but its not a method!
Hi everyone, I am putting together an application in which each part of it was tested individually. Now that it is put together, I''m having problems... The one giving me problems is my "ImportController" which parses a CSV during post and puts it into my database. I have two separate CSV upload actions (one is for a bill called "bes" and the other from the provider
2009 Jun 17
12
FasterCVS and Rails
Hello all, I''m trying to import some csv data (that has latin characters) using faster csv but I keep getting a MalformedCSVError: "Unclosed quoted field on line 1." "/ruby/lib/ruby/gems/1.8/gems/fastercsv-1.2.3/lib/faster_csv.rb:1592:in `shift''" I''ve tested the same code outside of the Rails application an it works fine. Can anyone help me? Here is
2006 May 17
6
newbie wants to know..FasterCSV or just CSV?
I''m trying to grab a CSV file from a user and let them upload it directly to my database, but doing some minor checks on the data before saving. Which is the easier way to implement this? CSV or FasterCSV? I saw that perhaps there were some issues with FasterCSV and csv files created from Mac versions of Excel. Anyone have any experience with this and can recommend a newbie friendly
2006 Aug 16
2
installing fastercsv into vendor directory
I am using fastercsv to process input files. I want to install it into my app/vendor directory as a gem (I guess). I used ''rake rails:freeze:gems'' to get rails into the vender dir. But I cannot find any doc on how to do it for fastercsv or any third-party gem. Any help appreciated. -- Posted via http://www.ruby-forum.com/.
2009 Feb 09
9
fastercsv, freezing into vendor/gems
I''m using fastercsv such that in my rake file I''m doing this. require ''fastercsv'' It works fine on my Mac. I need to freeze this gem into the app though so my rake tasks work on the production machine. ----------- I spent about two hours though this weekend trying to get this Gem "frozen" into the vendor/gems folder. I tried all sorts, I ... -
2008 Jul 18
4
gem question on hosted service
All, This may be a gem question (not rails) but I feel sure someone else on this list has seen this issue go by. I use a hosting service that has ROR available, but I am among the few developers using it. I am developing on a local linux box, and have been very careful to NOT use any extra gems because I might have a problem with my provider. Well ... fastercsv rocks and I wanted to use it. My
2006 Mar 21
8
Loading the contents of a CSV file to a database
Hello Everybody, I picked up on the buzz about RoR and wanted to see what the fuss is about. So far i am very impressed but have hit a bit of a wall with a little play app i am writting. I want to iterate through a CSV file of my bank transactions and see just how much money i spend on beer and pies every month. I have successfully setup a database with a single table called transactions
2007 Jul 25
3
FasterCSV load file to table
Hello Guys, May be it is simply but any way.... fasterCSV 1.2.0 how to load data from file to table :( I have tried this: file has just one line 1,2,3 data = FCSV.read("C:\\temp_file.csv") table = FCSV.parse(data, :headers => true) puts "data overview" puts data puts "table overview" puts table but got very strange error: undefined method
2011 Mar 26
2
upload file, read first 10 lines.
I have a csv file and in my controller: uploaded_file = params[:upload][:csv].read @rows << FasterCSV.parse(uploaded_file) I want to put in @rows only the first 10 lines but the read method reads all the file. How can I do? -- 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
2006 Jul 29
1
Debian - plugins being installed to the wrong place?
Hi, I''ve been moving my app from my development environment (my laptop running OSX) to my test environment (a dedicated Debian box in a datacentre somewhere). All seems to be OK except ruby Plugins don''t seem to work. When I go to a page which uses a plugin I get errors... e.g. uninitialized constant Paypal Same happens with other plugins I''m using e.g. FasterCSV
2009 Jan 14
1
setting header in views?
currently iam using FasterCSV to render csv pages format.csv do csv_string = FasterCSV.generate do |csv| # header row csv << @query_result[0].keys @query_result.each do |x| csv << x.values end end #send it to the browser send_data csv_string, :type => ''text/csv;
2009 Aug 05
1
How do I use fastercsv to just read the header row and not the whole file?
How do I use fastercsv to just read the header row and not the whole file? I need to read the header row first and not the whole csv file initially in the web application so I can map the input csv columns to the db columns. Once the mapping is complete, a rake task will than process the whole file. I don’t want to read the whole file to save processing time. How do I just read the header row
2006 Jul 14
3
compare two tables and find the difference?
I need to compare a column in TableA to a column in TableB and then select 3 columns from TableA for all the records in TableA that don''t exist in TableB. TableA and TableB are different but do have one field in common that i am comparing. The tables are not related in anyway. right now I have a find_by_sql query located in a model that looks like this: def self.absent_charges
2009 Nov 10
4
Model spec for file upload with paperclip and fastercsv
I just started my ImportsController and was this was really the way to go: ////////import.rb///////////////// class Import < ActiveRecord::Base has_attached_file :csv validates_attachment_presence :csv after_save :process_csv private def process_csv FasterCSV.foreach( csv.path) do |row| #TODO end end end /////////import_spec.rb///////////////// require
2005 Dec 07
4
Importing data for excel file or csv file
hey, i have this website (with ajax also) with lot of records of employee, and as an extra feature i want that the customer can import his employeelist (perhaps 100+ records), lot of work to do this manually. i would create a template like this Firstname Lastname Phone xxxx xxxxx xxxxx yyyy yyyyy yyyyy then they upload the excel file or save it as csv file
2007 Jun 15
1
mongrel cluster issues, plain old mongrel OK
I just created a test rails app, and am having very wierd issues with mongrel cluster. Here''s what I''m doing: rails test sudo chown -R mongrel:mongrel test cd test sudo mongrel_rails \ cluster::configure -e production \ -p 8000 -N 3 -a 127.0.0.1 --user mongrel \ --group mongrel It correctly writes the mongrel_cluster.yml file to the config directory. Now,
2010 Dec 20
1
Writing to a CSV with Faster::CSV
Is there a way to write a csv file using a hash instead of an array? Something like this: header_keys = :first_name, :last_name, :email FasterCSV.open("path/to/file.csv", "w") do |csv| User.all.do |user| csv << user end end Thanks... -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To
2009 Jun 13
3
How Can I insert another column data into the CSV file when I use FasterCSV?
Hi, All, Suppose I have a CSV file, there is data in it. * Column 1 Column2 Column 3 Column 4 Row1 a b c Row2 a2 b2 c2* You know, the column 4 is no data Now, I would like to insert data to Column 4, after save, the CSV file will be: * Column 1
2007 May 01
5
duplicate key violates unique constraint
I''ve run into an interesting issue. When setting up a table with data from a file (I''m doing this in a block). I find that I can''t create separate entries manually after the import. It complains about a duplicate primary key. I''ve tried Schedule.id += 1 but id= either isn''t defined or accessible in the class Here is my code:
2011 May 25
1
rake task: uninitialized constant
I have this rake taks: CUSTOM_MONTHS = [nil, "GEN", "FEB", "MAR", "APR", "MAG", "GIU", "LUG", "AGO", "SET", "OTT", "NOV", "DIC"] def parse_date_string(date_string) begin day, month, year = date_string.split("-") Time.mktime(year, CUSTOM_MONTHS.index(month),