[Activewarehouse-discuss] Newbie needs help!

2007-12-13 Thread Paul Cortens
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 Adapte

Re: [Activewarehouse-discuss] Newbie needs help!

2007-12-13 Thread Paul Cortens
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

[Activewarehouse-discuss] Current User in ctl file?

2007-12-29 Thread Paul Cortens
Hi, I have been trying to use RESTful Authentication with ActiveWarehouse ETL. To put it simply, I want to access the id of the currently logged in user during the ETL. I would like it to populate a user_id column. I have a controller which runs bb = IO.popen("cd db/etl \n etl trans.ctl")

Re: [Activewarehouse-discuss] Current User in ctl file?

2007-12-31 Thread Paul Cortens
Thanks for the reply! I don't think ENV['my_var'] will work in this case. I definitely need to allow different users to submit requests at the same time. Here is what I am doing now: controller: ctl_file = 'db/etl/trans.ctl' usr_ctl_file = "db/etl/trans[#{current_user.id.to_s}].ctl"

[Activewarehouse-discuss] rake warehouse:build_date_dimension problems

2008-01-19 Thread Paul Cortens
Hi, I have been having trouble with rake warehouse:build_date_dimension Some dates have been missing and some have been duplicated. It had to do with daylight savings. Here is how I fixed it: activewarehouse/tasks/active_warehouse_tasks.rake < #start_date = (ENV['START_DATE'] ? Time.parse(EN

[Activewarehouse-discuss] A very long message about the architecture of ActiveWarehouse

2008-02-05 Thread Paul Cortens
Hi, I have recently started a project using ActiveWarehouse and ActiveWarehouse ETL. When I chose these tools I knew they were very early in their implementation; however, I wanted the flexibility that ruby offers so I decided that using a "new" technology was worth it. Now that I have comp

Re: [Activewarehouse-discuss] problems using bulk_import (to mysql on win xp)

2008-02-15 Thread Paul Cortens
are you using the Ruby MySQL gem or the native gem? I had the exact same error when using the Ruby gem. Paul On Feb 15, 2008 3:52 PM, Jesper Rønn-Jensen <[EMAIL PROTECTED]> wrote: > Hi there > I have been trying for days to get bulk import working with > Activewarehouse-ETL > Here is my rule in

Re: [Activewarehouse-discuss] problems using bulk_import (to mysql on win xp)

2008-02-15 Thread Paul Cortens
Check out this: http://rubyforge.org/pipermail/activewarehouse-discuss/2007-December/000224.html On Feb 15, 2008 4:06 PM, Paul Cortens <[EMAIL PROTECTED]> wrote: > are you using the Ruby MySQL gem or the native gem? > > I had the exact same error when using the Ruby gem. > &g

Re: [Activewarehouse-discuss] Fwd: problems using bulk_import (to mysql on win xp)

2008-02-19 Thread Paul Cortens
Hi, I did some hacking around with the tests for the mysql-2.7 gem, and I can get it to do a bulk import without an error. I didn't go through all of the options (like delimited by, etc). However, when I tried running the adapter_extensions tests, I got errors. I even tried overriding the execute

Re: [Activewarehouse-discuss] Fwd: problems using bulk_import (to mysql on win xp)

2008-02-19 Thread Paul Cortens
other active record objects? Cheers, Paul On Feb 19, 2008 7:07 PM, Paul Cortens <[EMAIL PROTECTED]> wrote: > Hi, > > I did some hacking around with the tests for the mysql-2.7 gem, and I can > get it to do a bulk import without an error. I didn't go through all of the > opt

Re: [Activewarehouse-discuss] Fwd: problems using bulk_import (to mysql on win xp)

2008-02-19 Thread Paul Cortens
That should be real_connect() not real_reconnect(). If anyone is wondering where these method names are coming from, take a look here: http://tmtm.org/en/mysql/ruby/ Paul On Feb 19, 2008 11:51 PM, Paul Cortens <[EMAIL PROTECTED]> wrote: > I think I have made some progress. I added on

Re: [Activewarehouse-discuss] Fwd: problems using bulk_import (to mysql on win xp)

2008-02-20 Thread Paul Cortens
strange weird behaviour. The change you suggest, however, makes no difference for me. I still get the same error. I'm including stack trace below signature. /Jesper On Feb 20, 2008 8:51 AM, Paul Cortens wrote: I think I have made some progress. I added one line to mysql_adapter.rb in the ad