How to use ruby, csv and webservice? Need a direction.
- From: Nick da G <nick.gorbikoff@xxxxxxxxx>
- Date: Wed, 8 Oct 2008 12:07:37 -0500
Hi, All.
I'm just a bit confused and need some direction here.
I have an app that does inventory and I also created a bunch of reports
using great Ruport Library. All of my reports can produce: xls, csv, pdf
& html.
What I'm trying to do is to have a scheduled ruby script on a separate
scheduling machine that will pull one of the reports in CSV format and
place it on HD for processing by our old DBF program.
There are two approaches:
1) I can have a copy of my app running on my scheduling computer that I
will connect to the central DB do it's processing and save the file
locally where it's needed. That's how I'm doing right now.
(+ I don't stress production server with reports)
2) My report urls are of this type:
http://myapp/reports/csv_export/2 - which spits out a csv file back at
you for report #2
So I was thinking that I can just point a ruby script to that url, grab
the file and place it on HD.
(+ This way I don't need to 2 copies of my app. Better maintainability)
I want to go with the second approach - but here is where I'm stuck and
need just a pointer. I'm sure it's obvious but I just don't know what to
do.
How do I call that url from my ruby scrip and how do I process that csv
file when I get it back? Everything I red talks about using xmlrpc or
soap - but I don't want to process that data again on a scheduling
computer - when it's already is being given to me in the proper format?
How do I handle that?
If ruby has something like linux's "wget" - that would be great - I
think that would solve my problem.
( the reason I can't use system wget is my scheduling pc - is a windows
xp box - it has to be for old DBF stuff to work)
--
Posted via http://www.ruby-forum.com/.
.
- Follow-Ups:
- Prev by Date: Suggestions for common/global data in app (cli)
- Next by Date: Re: How to use ruby, csv and webservice? Need a direction.
- Previous by thread: Suggestions for common/global data in app (cli)
- Next by thread: Re: How to use ruby, csv and webservice? Need a direction.
- Index(es):
Relevant Pages
|
