I have the same problem with MacOS, but I think it's 'cause teh aw-etl is using ar-2.0.1, but it worked with 1.15.6
How can I force it to use ar-1.15.6 ? On Dec 13, 2007 11:18 PM, Paul Cortens <[EMAIL PROTECTED]> wrote: > That was it. I was using the ruby version. Once I installed the win32 > version it works. > > THANK YOU!!!! > > Paul > > -----Original Message----- > From: Chris Williams [mailto:[EMAIL PROTECTED] > Sent: Thursday, December 13, 2007 6:01 PM > To: Paul Cortens > Subject: Re: [Activewarehouse-discuss] Newbie needs help! > > Which MySQL gem are you using? I think you want to make sure you are > using the win32 version, not the ruby version. > > On Dec 13, 2007 8:05 PM, Paul Cortens <[EMAIL PROTECTED]> wrote: > > Thanks. If I add "LINES TERMINATED BY '\r\n'" to the MySQL query, then > I > > don't have the line break problem. But I am still stuck as to why > > ActiveWarehouse chokes, but I can manually run the exact same SQL code > > through MySQL manually. > > > > Cheers, > > Paul > > > > > > -----Original Message----- > > From: Chris Williams [mailto:[EMAIL PROTECTED] > > Sent: Thursday, December 13, 2007 3:46 PM > > To: Paul Cortens > > Subject: Re: [Activewarehouse-discuss] Newbie needs help! > > > > Hi Paul. I ran in to some of the same problems when running on > > Windows. I went through some of my old posts to the list but can't > > find exactly what I did. I know I made some code changes to AW in > > order to get rid of the \n in the last field in the CSV file. I will > > keep searching and see if I can help out at all. > > > > Chris > > > > On Dec 13, 2007 6:29 PM, Paul Cortens <[EMAIL PROTECTED]> wrote: > > > > > > > > > > > > > > > Hi, > > > > > > I have been trying to work through the tutorial posted > > here, > > > and I haven't been having much luck. > > > > > > > > > > > > > > > > > > When I try to run author_dimension.ctl I get the following error. > > > > > > > > > > > > ****************** > > > > > > > > > > > > F:\ruby_testing\DW\rails_warehouse\db\etl>etl author_dimension.ctl > > > > > > Using AdapterExtensions > > > > > > Starting ETL process > > > > > > initializing ETL engine > > > > > > Processing author_dimension.ctl > > > > > > > > > > > > Executing screens > > > > > > Screens passed > > > > > > > > > > > > Executing post processes > > > > > > > > > c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.0.1 > /lib/active_record/connecti > > on_a > > > > > > dapters/abstract_adapter.rb:150:in `log': Mysql::Error: #42000The used > > > command i > > > > > > s not allowed with this MySQL version: LOAD DATA LOCAL INFILE > > > './author_dimensio > > > > > > n.txt' INTO TABLE author_dimension FIELDS TERMINATED BY ',' (name) > > > (ActiveRecord > > > > > > ::StatementInvalid) > > > > > > from > > > c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.0.1/lib/active_record > > > > > > /connection_adapters/mysql_adapter.rb:281:in `execute' > > > > > > from > > > c:/ruby/lib/ruby/gems/1.8/gems/adapter_extensions-0.4.0/lib/adapter > > > > > > _extensions/connection_adapters/mysql_adapter.rb:46:in `do_bulk_load' > > > > > > from > > > c:/ruby/lib/ruby/gems/1.8/gems/adapter_extensions-0.4.0/lib/adapter > > > > > > _extensions/connection_adapters/abstract_adapter.rb:18:in `bulk_load' > > > > > > from > > > c:/ruby/lib/ruby/gems/1.8/gems/activewarehouse-etl-0.9.0/bin/../lib > > > > > > /etl/processor/bulk_import_processor.rb:68:in `process' > > > > > > from > > > c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.0.1/lib/active_record > > > > > > /connection_adapters/abstract/database_statements.rb:66:in > `transaction' > > > > > > from > > > c:/ruby/lib/ruby/gems/1.8/gems/activewarehouse-etl-0.9.0/bin/../lib > > > > > > /etl/processor/bulk_import_processor.rb:58:in `process' > > > > > > from > > > c:/ruby/lib/ruby/gems/1.8/gems/activewarehouse-etl-0.9.0/bin/../lib > > > > > > /etl/engine.rb:485:in `post_process' > > > > > > from > > > c:/ruby/lib/ruby/gems/1.8/gems/activewarehouse-etl-0.9.0/bin/../lib > > > > > > /etl/engine.rb:484:in `each' > > > > > > ... 13 levels... > > > > > > from > > > c:/ruby/lib/ruby/gems/1.8/gems/activesupport-2.0.1/lib/active_suppo > > > > > > rt/dependencies.rb:496:in `require' > > > > > > from > > > c:/ruby/lib/ruby/gems/1.8/gems/activewarehouse-etl-0.9.0/bin/etl:28 > > > > > > > > > > > > from c:/ruby/bin/etl:16:in `load' > > > > > > from c:/ruby/bin/etl:16 > > > > > > > > > > > > > > > > > > ****************** > > > > > > > > > > > > > > > > > > This is my environment: > > > > > > Windows XP Pro SP2. > > > > > > rails -v => 2.0.1 > > > > > > ruby -v => ruby 1.8.6 (2007-03-13 patchlevel 0) [i386-mswin32] > > > > > > gem -v => 0.9.4 > > > > > > MySQL 'select @@version;' => 5.0.27-community-nt > > > > > > > > > > > > > > > > > > If I run the command "LOAD DATA LOCAL INFILE './author_dimension.txt' > INTO > > > TABLE author_dimension FIELDS TERMINATED BY ',' (name);" directly in > > MySQL, > > > then the data imports just fine. (Actually it is not completely fine, > it > I > > > get line breaks at the end of some of the strings.) > > > > > > > > > > > > Any ideas? > > > > > > > > > > > > Thanks, > > > > > > Paul > > > > > > > > > _______________________________________________ > > > Activewarehouse-discuss mailing list > > > Activewarehouse-discuss@rubyforge.org > > > http://rubyforge.org/mailman/listinfo/activewarehouse-discuss > > > > > > > > > > > > _______________________________________________ > Activewarehouse-discuss mailing list > Activewarehouse-discuss@rubyforge.org > http://rubyforge.org/mailman/listinfo/activewarehouse-discuss > -- Enderson Maia
_______________________________________________ Activewarehouse-discuss mailing list Activewarehouse-discuss@rubyforge.org http://rubyforge.org/mailman/listinfo/activewarehouse-discuss
