Hi
using the ETL gem I have chosen to place the files according to this
schema in my rails application etlTest:
etlTest/etl/data/product.txt
etlTest/etl/product.ctl
-----------------------
infile = '/data/products.txt'
outfile = '/data/product_dimension.txt'
source :in, {
:file => infile,
:parser => :delimited,
:skip_lines => 1
},
[
:id,
:description,
:suggested_retail_price
]
destination :out, {
:file => outfile,
:separator => "\t"
},
{
:order => [:id, :description, :suggested_retail_price]
}
post_process :bulk_import, {
:file => '../data/product_dimension.txt',
:truncate => true,
:columns => [:id,:description,:suggested_retail_price],
:field_separator => "\t",
:target => :development,
:table => 'product_dimension'
}
-----------------------
etlTest/config/database.yml
------------------
defaults: &defaults
adapter: mysql
encoding: utf8
username:
password:
socket: /var/run/mysqld/mysqld.sock
development:
database: etlTest_development
<<: *defaults
test:
database: etlTest_test
<<: *defaults
production:
database: etlTest_production
<<: *defaults
etl_execution:
database: etl_execution
<<: *defaults
----------------------
all works, but if I try to run
etltest/etl> etl product_dimension.ctl
I get:
Using AdapterExtensions
Starting ETL process
initializing ETL engine
/usr/lib/ruby/gems/1.8/gems/activewarehouse-etl-0.9.1/bin/../lib/etl/engine.rb:33:in
`read': No such file or directory - config/database.yml
(Errno::ENOENT)
from
/usr/lib/ruby/gems/1.8/gems/activewarehouse-etl-0.9.1/bin/../lib/etl/engine.rb:33:in
`init'
from
/usr/lib/ruby/gems/1.8/gems/activewarehouse-etl-0.9.1/bin/../lib/etl/commands/etl.rb:79:in
`execute'
from
/usr/lib/ruby/gems/1.8/gems/activewarehouse-etl-0.9.1/bin/../lib/etl/commands/etl.rb:89
from /usr/local/lib/site_ruby/1.8/rubygems/custom_require.rb:31:in
`gem_original_require'
from /usr/local/lib/site_ruby/1.8/rubygems/custom_require.rb:31:in
`require'
from
/usr/lib/ruby/gems/1.8/gems/activesupport-2.2.2/lib/active_support/dependencies.rb:153:in
`require'
from
/usr/lib/ruby/gems/1.8/gems/activesupport-2.2.2/lib/active_support/dependencies.rb:521:in
`new_constants_in'
from
/usr/lib/ruby/gems/1.8/gems/activesupport-2.2.2/lib/active_support/dependencies.rb:153:in
`require'
from /usr/lib/ruby/gems/1.8/gems/activewarehouse-etl-0.9.1/bin/etl:28
from /usr/bin/etl:19:in `load'
from /usr/bin/etl:19
how and where do I insert a reference to the config directory because
it functions?
thanks for any help and sorry if the question is too simple
Giovanni
_______________________________________________
Activewarehouse-discuss mailing list
Activewarehouse-discuss@rubyforge.org
http://rubyforge.org/mailman/listinfo/activewarehouse-discuss
