similar to: Consuming a web service created with Rails, ETL vs Rest?

Hello Guys, does anybody know if there''s anyway to upload a .xlsx file and then convert it to .xls file for later processing? i''d like to use spreadsheet to write a new xls file but it doesn''t support xlsx and the file is only importable with that format sadly. I saw roo but I don''t know if there''s a direct way to do it. -- You received this

I am trying to load conversion data into a postgresql database using activewarehouse-etl. I can create a flat file output from the conversion data without problem. However, when I try to load into the table using the information contained in config/database.yml I see this error: /usr/lib64/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/ base.rb:1959:in `method_missing'':

I''m working on an app that uses info from a government database. For a variety of reasons (not the least of which is that their database is in MS Access), I can''t simply write a wrapper around the legacy database. Instead, we''re looking to have an "import" script in the Rails environment (it''s fine if it''s run from the server and through the

Hello, I''m developing an app that basically, receives a 10MB or less XLSX files with +30000 rows or so, and another XLSX file with about 200rows, I have to read one row of the smallest file, look it up on the largest file and write data from both files to a new one. I just did a test reading a few rows from the largest file using ROO (Spreadsheet doesn''t support XSLX and

ActiveWarehouse 0.1.0 is now available for use. I have posted a tutorial at http://anthonyeden.com/2006/12/20/activewarehouse-example-with-rails-svn-logs which demonstrates how to extract data from the Rails Subversion logs and turn it into a simple drill down report. The ActiveWarehouse web site is http://activewarehouse.rubyforge.org/ ActiveWarehouse is a plugin for Rails which provides

I''m trying to create a folder right after a user registers, so I override the create action on the registration controller (devise) but I don''t know how to access the newly created user in order to create the folder with it''s name to upload files later. So far I''ve got this: class RegistrationsController < Devise::RegistrationsController def new

Hello! I''m fairly new to Ruby and Rails, and currently I don''t have any knowledge on interacting with the server''s shell or a SVN server, but now I have to develop an app where admins allow/restrict access to files and folders from the app and some sort of version control of the files is need so I thought, to install a SVN server also and from the app allow users to

Saludos a todos.Estoy en un proceso de carga de información a un DWH, y estoy validando que los ETLs estén correctos.Tengo datos de los transaccionales (T) y de la nueva base de datos (B).Mi objetivo es validar que los procesos de limpieza de datos y corrección, estén bien.tengo 2 columnas en un data.frame, la una es el nombre del cliente en el transaccional (T) y en la otra columna, el nombre del

Was hoping for a helping hand. Trying to set up Samba on a domain member server. The member server was previously joined to the kerberized domain using realm join and a system keytab file exists in the /etc. Subsequently I added samba along with winbind not being entirely sure if the latter was needed. This is a Redhat 7.4 server. My smb.conf appears as follows. [global] password server = *

Hi All, We have a product that performs ETL on files and finally load the database. We want to give the web based interface displaying graphs (that are generated using R-project forcasting) from this database. But R-Project is stand alone desktop based software and it takes commands at command line to show graphs. Any one has any idea how to integrate R-Project into your existing web based

Hi, I am trying to copy the directory structure only from the remote UNIX box onto the box from which Im executing the rsync. This is what I tried: rsync -av --include '*/' --exclude '*' tashaikh@remotebox:/dw/etl/ home/ prod/log/ /export/home/tashaikh/auto/log The above keeps on executing without returning any result. I have tried to copy directory structure from another

Since our move to github for pull requests and patches, the usefulness of puppet-dev has declined significantly. puppet-dev used to be a great list for development discussion of puppet and the ecosystem around it. With the information and pull request emails from github, unless everybody has finely-tuned their email clients, the puppet-dev list has turned into mostly noise. We have a goal to

Hello, I''m having trouble with transactions with rails 3.0.3 and mysql 5. I''d like to import data etl-batch-style: class Job < ActiveRecord::Base # ... def perform_etl connection.transaction do extract # some connection.execute / job.update_attribute stuff transform # some connection.execute / job.update_attribute stuff end end #... end

I am receiving the following non-fatal error from Rails for a particular action: Error calling Dispatcher.dispatch #<ArgumentError: Anonymous modules have no name to be referenced by> ./script/../config/../vendor/rails/activesupport/lib/active_support/dependencies.rb:313:in `to_constant_name'' ./script/../config/../vendor/rails/activesupport/lib/active_support/dependencies.rb:270:in

Rails SQL Views 0.5.0 is now available from http://rubyforge.org/frs/?group_id=2435&release_id=8685 and shortly as a Gem (gem install rails_sql_views). More information on Rails SQL Views can be found at http://activewarehouse.rubyforge.org/rails_sql_views/ This release finally fixes the SchemaDumper issues, including the necessary select statement for the view. It also introduces PostgreSQL

Hello List I have a strange problem here which i try to analyse, but i'm stuck. Maybe someone has a hint? What happened: A few weeks ago one of the LDAPS Servers which is not maintained by us has crashed. From that moment on, users could still login to check their emails, but they were not able to send any email through postfix (which uses smtpd_sasl_type = dovecot) What i do not

I''m running Redmine on Ruby, and attempting to load a new plugin. When I attempt to run the command: rake db:migrate_plugins RAILS_ENV=production It fails with this error: rake aborted! no such file to load -- initializer /var/www/redmine/config/boot.rb:65:in `require'' /var/www/redmine/config/boot.rb:65:in `load_initializer'' /var/www/redmine/config/boot.rb:43:in

I have two hosts which have their respective keys loaded into each others .ssh/authorized-keys2 file for root. I want to move a directory tree from one host to the other via rsync to maintain a shadow structure of the application provided on the main host. This is the relevant part of the command: rsync -avz --rsh=ssh --delete-after /var/data/pas-redmine root at

Me: not experienced with Rails or Ruby, Problem: Ubuntu 9.04 server in my shop ...couldn''t get Apache2.2 + Passenger + Rails to work for Redmine. (No answer at Redmine list and I don''t think its their problem anyway). Also couldn''t get Apache2.2 and just Rails to work, though some people said it would. Webrick works. Goal: run Redmine on a server that also runs PHP

I have a DB2 schema with many ''views'' and table partitions defined in it. As per our new project requirement we have to support multiple databases (DB2,Oracle and MYSQL to be specific). The frontend application is implemented using Ruby on Rails. I am interested in exploring the possibility of using Rails Migrations to abstract out the schema to a DB independent layer. I could