Hello, I am redesigning a web application previously written in PHP. To do development I need to fill a number of my models'' tables with static data. I have written a conversion script (in Ruby) to extract the data from the old database and convert it a bit. For now, I wrote a script in db/fixtures/convert.rb which takes a number of CSV files in db/fixtures/static/*csv containing the old data, and produces converted tables in db/fixtures/$TABLE_NAME.csv. (BTW: Is this the "right way" of doing this? In the end, I''d like to write a rake task that calls my convert script to import all data from the current PHP production DB, converts it, imports it into the Rails app, and then I can switch production environments with minimal downtime.) Now I want to import these resulting CSV files with "rake db:fixtures:load". One table e.g. looks like this: $ cat db/fixtures/cities.csv id,name,district,country_id,longitude,latitude,importance,area,inhabitants 1,Aachen,NRW,276,6088538,50775620,3,0,26000 2,Achim bei Bremen,NDS,276,9025491,53012831,3,0,25000 3,Ahaus,NRW,276,7003480,52079246,3,0,25000 But when I try to import this data I get: $ rake --trace db:fixtures:load ** Invoke db:fixtures:load (first_time) ** Invoke environment (first_time) ** Execute environment ** Execute db:fixtures:load rake aborted! SQLite3::SQLException: SQL logic error or missing database: INSERT INTO cities ("id") VALUES (2) I don''t get this: - Why is it trying to insert only the ID? I''m quite sure it fails because my DB schema specifies ":null => false" for some of the other colums, such as "name", but why doesn''t it take the other columns too? - Why is it not starting with inserting the first object (ID=1)? - How do I get this working? :) My development and test databases exist and the structures are correct: create_table "cities", :force => true do |t| t.column "name", :string, :null => false t.column "district", :string t.column "country_id", :integer, :null => false t.column "longitude", :integer t.column "latitude", :integer t.column "importance", :integer t.column "area", :integer t.column "inhabitants", :integer end I read the load_fixtures.rb file from ActiveRecord (where the error is triggered) but I don''t quite know how to debug this further, and I don''t want to muck about in the AR code. Any help would be appreciated! Jens --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---