# Import\_export errors in importing users **URL:** \ **Category:** Radiant CMS\ **Created:** [September 5, 2007, 6:10pm UTC](https://www.ruby-forum.com/t/import-export-errors-in-importing-users/113863 "2007-09-05T18:10:24Z")\ **Posts on this page:** 1\ **Page:** 1
**Author:** ![Ramie\_Blatt](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/b38774/32.png) [@Ramie\_Blatt](https://www.ruby-forum.com/u/Ramie_Blatt)\ **Post date:** [September 5, 2007, 6:10pm UTC](https://www.ruby-forum.com/t/import-export-errors-in-importing-users/113863/1 "2007-09-05T18:10:24Z")
Hi there, I’m trying to use import\_export (a really useful extension if I could get it to work)and have seen that a number of people have experienced an error similar to this one, regarding importing users: Creating Users…FAILED rake aborted! User expected, got Fixnum I’ve read Luca Erzegovesi’s post on the subject: [http://lists.radiantcms.org/pipermail/radiant/2007-June/005083.html](http://lists.radiantcms.org/pipermail/radiant/2007-June/005083.html) but his workaround doesn’t work for me. Is there any plan to fix this bug or should we look for alternatives to the import\_export extension? Thanks Ramie Here’s the full trace after successfuly exporting the data, using the command: $ rake --trace production db:import TEMPLATE=export.tml # \*\* Invoke production (first\_time) \*\* Execute production \*\* Invoke environment (first\_time) \*\* Execute environment \*\* Invoke db:import (first\_time) \*\* Invoke db:remigrate (first\_time) \*\* Invoke environment \*\* Execute db:remigrate This task will destroy any data in the database. Are you sure you want to continue? [yn] y == AddOptimisticLocking: reverting # – remove\_column(:pages, :lock\_version) → 0.0029s – remove\_column(:layouts, :lock\_version) → 0.0023s – remove\_column(:snippets, :lock\_version) → 0.0020s – remove\_column(:users, :lock\_version) → 0.0018s == AddOptimisticLocking: reverted (0.0094s) # == RenameConfigDefaultPartsKey: reverting # == RenameConfigDefaultPartsKey: reverted (0.0081s) # == AddNotesFieldToUser: reverting # – remove\_column(“users”, “notes”) → 0.0016s == AddNotesFieldToUser: reverted (0.0018s) # == CreateExtensionMeta: reverting # – drop\_table(“extension\_meta”) → 0.0046s == CreateExtensionMeta: reverted (0.0048s) # == RenameTypeColumnOnPageToClassName: reverting # – rename\_column(“pages”, “class\_name”, “type”) → 0.0014s == RenameTypeColumnOnPageToClassName: reverted (0.0016s) # == MergeBehaviorsAndPages: reverting # – rename\_column(:pages, :type, :behavior\_id) → 0.0013s == MergeBehaviorsAndPages: converting class names back to behavior names # == MergeBehaviorsAndPages: reverted (0.0042s) # == AddContentTypeFieldToLayout: reverting # – remove\_column(“layouts”, “content\_type”) → 0.0016s == AddContentTypeFieldToLayout: reverted (0.0020s) # == AddVirtualColumnToPageAgain: reverting # – remove\_column(“pages”, “virtual”) → 0.0019s == AddVirtualColumnToPageAgain: reverted (0.0021s) # == RemoveVirtualColumnFromPage: reverting # – add\_column(“pages”, “virtual”, :boolean, {:default=\>false, :null=\>false}) → 0.0058s == RemoveVirtualColumnFromPage: reverted (0.0060s) # == IntegerColumnsToBoolean: reverting # == IntegerColumnsToBoolean: saving User data # – remove\_column(“users”, “admin”) → 0.0023s – add\_column(“users”, “admin”, :integer, {:default=\>0, :null=\>false, :limit=\>1}) → 0.0062s == IntegerColumnsToBoolean: restoring User data # == IntegerColumnsToBoolean: saving User data # – remove\_column(“users”, “developer”) → 0.0025s – add\_column(“users”, “developer”, :integer, {:default=\>0, :null=\>false, :limit=\>1}) → 0.0059s == IntegerColumnsToBoolean: restoring User data # == IntegerColumnsToBoolean: reverted (0.0608s) # == AddVirtualColumnToPage: reverting # – remove\_column(“pages”, “virtual”) → 0.0019s == AddVirtualColumnToPage: reverted (0.0020s) # == RenameFilterColumn: reverting # – rename\_column(:page\_parts, :filter\_id, :filter) → 0.0013s – rename\_column(:snippets, :filter\_id, :filter) → 0.0014s == RenameFilterColumn: reverted (0.0031s) # == RenameBehaviorColumn: reverting # – rename\_column(:pages, :behavior\_id, :behavior) → 0.0013s == RenameBehaviorColumn: reverted (0.0014s) # == InsertInitialData: reverting # == InsertInitialData: reverted (0.0000s) # == CreateRadiantTables: reverting # – drop\_table(“pages”) → 0.0041s – drop\_table(“page\_parts”) → 0.0047s – drop\_table(“snippets”) → 0.0059s – drop\_table(“layouts”) → 0.0050s – drop\_table(“users”) → 0.0071s – drop\_table(“config”) → 0.0047s == CreateRadiantTables: reverted (0.0326s) # \*\* Invoke db:migrate (first\_time) \*\* Invoke environment \*\* Execute db:migrate \*\* Invoke db:schema:dump (first\_time) \*\* Invoke environment \*\* Execute db:schema:dump == CreateRadiantTables: migrating # – create\_table(“config”, {:force=\>true}) → 0.0071s – add\_index(“config”, [“key”], {:unique=\>true, :name=\>“key”}) → 0.0036s – create\_table(“pages”, {:force=\>true}) → 0.0097s – create\_table(“page\_parts”, {:force=\>true}) → 0.0122s – create\_table(“snippets”, {:force=\>true}) → 0.0120s – add\_index(“snippets”, [“name”], {:unique=\>true, :name=\>“name”}) → 0.0039s – create\_table(“layouts”, {:force=\>true}) → 0.0098s – create\_table(“users”, {:force=\>true}) → 0.0079s – add\_index(“users”, [“login”], {:unique=\>true, :name=\>“login”}) → 0.0029s == CreateRadiantTables: migrated (0.0715s) # == InsertInitialData: migrating # == InsertInitialData: migrated (0.0000s) # == RenameBehaviorColumn: migrating # – rename\_column(:pages, :behavior, :behavior\_id) → 0.0013s == RenameBehaviorColumn: migrated (0.0015s) # == RenameFilterColumn: migrating # – rename\_column(:page\_parts, :filter, :filter\_id) → 0.0013s – rename\_column(:snippets, :filter, :filter\_id) → 0.0015s == RenameFilterColumn: migrated (0.0031s) # == AddVirtualColumnToPage: migrating # – add\_column(“pages”, “virtual”, :boolean, {:default=\>false, :null=\>false}) → 0.0060s == AddVirtualColumnToPage: migrated (0.0061s) # == IntegerColumnsToBoolean: migrating # == IntegerColumnsToBoolean: saving User data # – remove\_column(“users”, “admin”) → 0.0019s – add\_column(“users”, “admin”, :boolean, {:default=\>false, :null=\>false}) → 0.0057s == IntegerColumnsToBoolean: restoring User data # == IntegerColumnsToBoolean: saving User data # – remove\_column(“users”, “developer”) → 0.0019s – add\_column(“users”, “developer”, :boolean, {:default=\>false, :null=\>false}) → 0.0051s == IntegerColumnsToBoolean: restoring User data # == IntegerColumnsToBoolean: migrated (0.0199s) # == RemoveVirtualColumnFromPage: migrating # – remove\_column(“pages”, “virtual”) → 0.0023s == RemoveVirtualColumnFromPage: migrated (0.0024s) # == AddVirtualColumnToPageAgain: migrating # – add\_column(“pages”, “virtual”, :boolean, {:default=\>false, :null=\>false}) → 0.0053s == AddVirtualColumnToPageAgain: migrated (0.0055s) # == AddContentTypeFieldToLayout: migrating # – add\_column(“layouts”, “content\_type”, :string, {:limit=\>40}) → 0.0016s == AddContentTypeFieldToLayout: migrated (0.0017s) # == MergeBehaviorsAndPages: migrating # == MergeBehaviorsAndPages: converting behavior names to class names # – rename\_column(:pages, :behavior\_id, :type) → 0.0013s == MergeBehaviorsAndPages: migrated (0.0034s) # == RenameTypeColumnOnPageToClassName: migrating # – rename\_column(“pages”, “type”, “class\_name”) → 0.0015s == RenameTypeColumnOnPageToClassName: migrated (0.0017s) # == CreateExtensionMeta: migrating # – create\_table(“extension\_meta”, {:force=\>true}) → 0.0384s == CreateExtensionMeta: migrated (0.0386s) # == AddNotesFieldToUser: migrating # – add\_column(“users”, “notes”, :text) → 0.0045s == AddNotesFieldToUser: migrated (0.0047s) # == RenameConfigDefaultPartsKey: migrating # == RenameConfigDefaultPartsKey: migrated (0.0020s) # == AddOptimisticLocking: migrating # – add\_column(:pages, :lock\_version, :integer, {:default=\>0}) → 0.0036s – add\_column(:layouts, :lock\_version, :integer, {:default=\>0}) → 0.0043s – add\_column(:snippets, :lock\_version, :integer, {:default=\>0}) → 0.0032s – add\_column(:users, :lock\_version, :integer, {:default=\>0}) → 0.0036s == AddOptimisticLocking: migrated (0.0156s) \*\* Invoke db:schema:dump \*\* Invoke db:schema:dump \*\* Execute db:import Creating Users…FAILED rake aborted! User expected, got Fixnum /usr/local/lib/ruby/gems/1.8/gems/radiant-0.6.2/vendor/rails/activerecord/li b/active\_record/associations/association\_proxy.rb:148:in `raise_on_type_mismatch' /usr/local/lib/ruby/gems/1.8/gems/radiant-0.6.2/vendor/rails/activerecord/li b/active_record/associations/belongs_to_association.rb:22:in `replace’ /usr/local/lib/ruby/gems/1.8/gems/radiant-0.6.2/vendor/rails/activerecord/li b/active\_record/associations.rb:908:in `created_by=' /usr/local/lib/ruby/gems/1.8/gems/radiant-0.6.2/vendor/rails/activerecord/li b/active_record/base.rb:1672:in `send’ /usr/local/lib/ruby/gems/1.8/gems/radiant-0.6.2/vendor/rails/activerecord/li b/active\_record/base.rb:1672:in `attributes=' /usr/local/lib/ruby/gems/1.8/gems/radiant-0.6.2/vendor/rails/activerecord/li b/active_record/base.rb:1671:in `each’ /usr/local/lib/ruby/gems/1.8/gems/radiant-0.6.2/vendor/rails/activerecord/li b/active\_record/base.rb:1671:in `attributes=' /usr/local/lib/ruby/gems/1.8/gems/radiant-0.6.2/vendor/rails/activerecord/li b/active_record/base.rb:1505:in `initialize\_without\_callbacks’ /usr/local/lib/ruby/gems/1.8/gems/radiant-0.6.2/vendor/rails/activerecord/li b/active\_record/callbacks.rb:225:in `initialize' /usr/local/lib/ruby/gems/1.8/gems/radiant-0.6.2/lib/radiant/setup.rb:144:in `new’ /usr/local/lib/ruby/gems/1.8/gems/radiant-0.6.2/lib/radiant/setup.rb:144:in `create_records' /usr/local/lib/ruby/gems/1.8/gems/radiant-0.6.2/lib/radiant/setup.rb:143:in `each’ /usr/local/lib/ruby/gems/1.8/gems/radiant-0.6.2/lib/radiant/setup.rb:143:in `create_records' /usr/local/lib/ruby/gems/1.8/gems/radiant-0.6.2/lib/radiant/setup.rb:204:in `step’ /usr/local/lib/ruby/gems/1.8/gems/radiant-0.6.2/lib/radiant/setup.rb:142:in `create_records' /usr/local/lib/ruby/gems/1.8/gems/radiant-0.6.2/lib/radiant/setup.rb:191:in `feedback’ /usr/local/lib/ruby/gems/1.8/gems/radiant-0.6.2/lib/radiant/setup.rb:138:in `create_records' /usr/local/lib/ruby/gems/1.8/gems/radiant-0.6.2/lib/radiant/setup.rb:137:in `each’ /usr/local/lib/ruby/gems/1.8/gems/radiant-0.6.2/lib/radiant/setup.rb:137:in `create_records' /Users/ramie/Documents/work/SVNProjectsRoot/abg-cms/config/../vendor/extensi ons/import_export/lib/tasks/import_export_extension_tasks.rake:23:in `send’ /Users/ramie/Documents/work/SVNProjectsRoot/abg-cms/config/…/vendor/extensi ons/import\_export/lib/tasks/import\_export\_extension\_tasks.rake:23 /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:392:in `call' /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:392:in `execute’ /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:392:in `each' /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:392:in `execute’ /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:362:in `invoke' /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:355:in `synchronize’ /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:355:in `invoke' /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1739:in `top\_level’ /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1739:in `each' /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1739:in `top\_level’ /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1761:in `standard_exception_handling' /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1733:in `top\_level’ /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1711:in `run' /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1761:in `standard\_exception\_handling’ /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1708:in `run' /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/bin/rake:7 /usr/local/bin/rake:16:in `load’ /usr/local/bin/rake:16