Hello,
I am trying to find a way to create views for displaying gantt charts for all projects in one page. and also would like to create gantt charts for invoices based on their request & due dates along with expences...

I came across this
http://drupal.org/project/views_jsgantt

but because this is designed for open atrium I couldn't make it work with storm task dates...

Is anyone else interested in this?
Anyone has any recommendations on how it would be best to work on trying to achieve this?

Thanks in advance!

Comments

juliangb’s picture

Category: feature » support

It should work.

Storm exports all data as views fields, and views_jsgantt is a method of displaying those.

I haven't used views_jsgantt myself though, so you may need to find someone using that module to help you with this.

dkoukoul’s picture

thanx for the reply,
as you said from what I saw yes it should work... the problem is that it doesn't work, at least in my case...

Has anyone tried this?
I think it will be a very useful feature for storm to be able to create jsgantt views of our own.
To be able to view the coses (invoices & expences) in gantt chart and all our cross-project tasks...

juliangb’s picture

Project: Storm » jsGantt View
Component: Storm.module » Code

Moving project as you may get better support for this specific thing here.

You may also get more help if you post a few more details in terms of what you have tried, and the results of those - has something shown up? If so, what?

danepowell’s picture

You may also get more help if you post a few more details in terms of what you have tried, and the results of those - has something shown up? If so, what?

Ding ding ding

I don't use Storm any longer, precisely because it tended to be incompatible with external modules. In this case, I suspect the problem is that it doesn't use CCK Date fields, but some sort of proprietary date field- but that's just a guess, I really don't know much about it.

juliangb’s picture

I would be surprised if the problem relates to the method of storage for the date fields.

The fields have been exported as views date fields, and that should be independent of the logic behind them.

dkoukoul’s picture

I am using the Task Date begin and Task Date End for the jsgantt start date and end fields.
I have tried changing the date format in the views but still can't make it to show me anything... I get a blank page.
Does the jsgantt expect the dates in a specific format? If yes what is that?
Appart from setting the start and end dates and sorting the fields by the start date are there any more requirements in order to make the view work?

Here is one of the many queries I have been trying:
SELECT node.nid AS nid,
stormtask.datebegin AS stormtask_datebegin,
stormtask.dateend AS stormtask_dateend,
stormtask.project_title AS stormtask_project_title,
stormtask.taskstatus AS stormtask_taskstatus,
node.title AS node_title,
stormtask.duration AS stormtask_duration,
DATE_FORMAT((FROM_UNIXTIME(stormtask.datebegin) + INTERVAL 7200 SECOND), '%Y%m%d%H') AS stormtask_datebegin_hour
FROM node node
LEFT JOIN stormtask stormtask ON node.vid = stormtask.vid
WHERE stormtask.taskstatus in ('inserted', 'in progress', 'on hold', 'completed')
ORDER BY stormtask_datebegin_hour DESC

danepowell’s picture

Status: Active » Postponed (maintainer needs more info)

Can you please confirm that you are using the latest version of jsgantt_view (6.x-1.x-dev)? If so, can you please view the HTML source of the page with the Gantt chart and post all of the javascript that appears under

<div style="position:relative" class="gantt" id="GanttChartDIV"></div>
<script language="javascript">

(all of the lines that start with g.AddTaskItem)

danepowell’s picture

Status: Postponed (maintainer needs more info) » Closed (cannot reproduce)

No response, going to assume this is no longer an issue.

PatchRanger’s picture

Status: Closed (cannot reproduce) » Active
StatusFileSize
new28.78 KB

Hi, Dane!
I confirm using the latest DEV-version.
Here you are what I have in the page source.

<div style="position:relative" class="gantt" id="GanttChartDIV"></div> 
<script language="javascript"> 
var g = new JSGantt.GanttChart('g',document.getElementById('GanttChartDIV'), 'day');
g.setShowRes(0); g.setShowDur(0); g.setShowComp(0); g.setCaptionType('Resource'); g.setShowStartDate(0); g.setShowEndDate(0);
g.AddTaskItem(new JSGantt.TaskItem(31, 'Первый_нах', '1/1/1970', '6/19/2011', 'f87217', '/project/%D0%BF%D0%B5%D1%80%D0%B2%D1%8B%D0%B9%D0%BD%D0%B0%D1%85', 0, '<span style="white-space: nowrap;"><a href="/project/%D0%BF%D0%B5%D1%80%D0%B2%D1%8B%D0%B9%D0%BD%D0%B0%D1%85">Первый_нах</a></span>', 0, 0, 0, 1, '0'));
g.Draw();
g.DrawDependencies();
</script> 
</div>

Note: 'Первый_нах' is the name of project. I'm NOT using modules like Storm or Case Tracker, I'm just trying to work with custom fields. Interesting (as you mentioned above) that the date, provided by the module Date is showing correctly, and in the other hand system date from field 'Date of creation' is not working (01/01/1970, as you could see on the screenshot).
Hope it will be useful for troubleshooting.

d34dman’s picture

Yes there is some issue regarding the views_gantt not able to recognize the date fields... may i know what is the date format that its expecting? so maybe after setting up custom format in views display option for that field i might be able to get it working. Displaying snapshots for your reference. The gantt chart shown in the first attachment is the storm modules inbuild test feature. I included that so as to get an idea how the task were laid out.

BrdNLSrg’s picture

I have the same problem

Virt’s picture

bump!
The same problem (drupal 7.19 and 7.20). Can't make view to show date other than 01/01/1970. Tried various date field storage formats (Date, Date ISO format). Please suggest fix/workaround