Sign in to follow this  
Grumelo

Gantt Chart Categories Generation

Recommended Posts

Is there a method, a tool a script any kind of solution to generate the <categories> dynamically ?

I know the first date and the last date of my tasks.

I need a <category> per month for this period that can cover many years.

 

Any helpers to do that ?

Any solution to dynamically generate this example:

 

<category start="2011/10/01" end="2011/10/31" label="September 2011"/>

<category start="2011/11/01" end="2011/11/30" label="November 2011"/>

<category start="2011/12/01" end="2011/12/31" label="December 2011"/>

<category start="2012/01/01" end="2012/01/31" label="January 2012"/>

<category start="2012/02/01" end="2012/02/29" label="February 2012"/>

<category start="2012/03/01" end="2012/03/31" label="March 2012"/>

Share this post


Link to post
Share on other sites
Guest Angshu

Hi,

 

Thanks for your post.

 

You would need to create/write your own code in order to suffice your requirement.

In case you want to generate dynamic data from database, please follow the steps below:

1.Initiate database connection in your server side script.

2. Retrieve the data from database that you wish to show on the chart.

3. Generate chart data (XML or JSON) by iterating through each record. This can be either done using simple String concatenation or, using XML. if your server-side scripts support the same. For ASP and PHP, we've APIs that help you convert arrays and recordsets into FusionCharts XML format.

4. Provide the chart data to the chart as string/URL. No need to save/store them on server as physical files; you can virtually relay them.

Hope this helps.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this