Comments on: Using a database to populate an Open Flash Chart graph

By: Constance

Constance — Sun, 23 Sep 2012 14:06:10 +0000

Learnnig a ton from these neat articles.

By: xue

xue — Thu, 13 Jan 2011 14:55:24 +0000

Hi,
how are you setting the tooltip like that (with the xlabel and value)? Is it automatic? I’m just making a simple bar chart and #x_label# is not working, so I was wondering if there is a workaround. Thanks

By: Ting

Ting — Sun, 06 Dec 2009 02:24:36 +0000

Thanks for asking charlie!

The problem is solved in 2 steps :-
> gem install taps
> heroku db:push (As advised by heroku staff)

http://strongsummer.heroku.com/test_it is working fine now 🙂

By: charlie

charlie — Sun, 06 Dec 2009 01:04:53 +0000

What’s the error in the log?

By: Ting

Ting — Sun, 06 Dec 2009 00:55:36 +0000

These changes have the same result.

development:
adapter: sqlite3
database: db/allresults.db
pool: 5
timeout: 5000

production:
adapter: postgresql
database: db/allresults.db
pool: 5
timeout: 5000

By: Ting

Ting — Sun, 06 Dec 2009 00:35:01 +0000

Works locally, but failed on http://strongsummer.heroku.com/test_it
===================================

This app looks good!

I implemented 3 graphs ( first graph, pie chart and test result) on 1 page.

Runs fine locally on rails. But test result gave an error deployed on heroku (The other 2 graph looks fine.) here :- http://strongsummer.heroku.com/test_it

Error message :
Open Flash Chart
IO ERROR
Loading test data
Error #2032
This is the URL that I tried to open:/test_it/graph_three

I’d suspect this may be a flash link to or database error. I changed a few parameters in database.yml but to no avail. (Now i am just sticking to what i know is the best working config here from previous.) :-

development:
adapter: sqlite3
database: db/development.sqlite3
pool: 5
timeout: 5000

test:
adapter: sqlite3
database: db/test.sqlite3
pool: 5
timeout: 5000

production:
adapter: postgresql
database: db/development.sqlite3
pool: 5
timeout: 5000

Basically, i did a
> rake db:setup
> rake db:migrate
> rake db:seed

and the git and heroku commands.

Any advice would be good!

Thanks!

By: Nithin Bekal

Nithin Bekal — Tue, 22 Sep 2009 10:13:14 +0000

Hi. I wan wondering how I could send some parameters to the graph_code method. For example, if I wanted to send a parameter called ‘year’, I could send it this way:

@graph = open_flash_chart_object(600, 300,”/test_it/graph_code?year=2008″)

But is there a better way to do this?

By: Cecci

Cecci — Fri, 25 Jul 2008 16:55:00 +0000

Hello, the first example worked. But in this example with database, I don’t know where it goes or where I create the first part: result.create(…) The others, know: view and controller, but this I don’t know

By: charlie

charlie — Fri, 25 Jul 2008 16:55:00 +0000

@Cecci – good question 🙂 When I did it, I opened up script/console and ran each line one at a time. You could also place it in a migration if you wish.

By: Cecci

Cecci — Fri, 25 Jul 2008 16:55:00 +0000

Hi, It worked! Thank you… Now I am trying to do the graph of pie, but I do not know that receives |open_flash_chart_object()| I do not know where from are those folders. Might you make clear to me that it receives?

Sorry, but I don’t speak english very well