Date field handling works differently in D7

I took a look on that. And it should be somehow possible to get/load the necessary values through something like this:

$this->view->field[$field['fieldname']]->get_value($row); (for example in TimelineEvent.class.inc, Line 93)

I have to stop on this, for now. Just wanted to tell it.

subscribe

Very interested in this too. I can't get timeline to work at all in d7.

I still get this error with the patch:

Warning: DateTime::__construct() [datetime.--construct]: Failed to parse time string (2) at position 0 (2): Unexpected character in timeline_convert_to_iso() (line 152 of .../sites/all/modules/timeline/timeline.module).
Warning: DateTime::__construct() [datetime.--construct]: Failed to parse time string (2) at position 0 (2): Unexpected character in timeline_convert_to_timestamp() (line 168 of .../sites/all/modules/timeline/timeline.module).

Maybe I didn't install the patch correctly?

Jason

Neither of the patches in this thread worked for me. I first tried the patch in #12 with the fix in #13. The timeline settings form in the view's Format section would not even recognize my date field as an option for the 'start date'. (I tried several different field configurations - date and timestamp.) It did recognize the node dates, such as post date and updated date, but did not show anything in the timeline.

So I tried the patch in #6. That did recognize my date field, but after that produced nothing but error messages.

This is my first time using this module, so I am well aware of the possibility of user error. To be sure I was doing it right, I got it set up in D6 and had no trouble getting the same configuration of fields working.

Hi, I've tried both sets of patches, both in #6 and #12. No luck getting it working for D7. I noticed two things.

1) For both patches, when configuring Timeline Settings in the View UI, I could only select a Start and End date if I was using a "Content: Post Date" type of date field. Although @KarenS says in #12 that she has the patch working with a normal date filed, I couldn't verify that.

2) Ultimately I was unable from seeing the view result with either of the patches. I was getting the following error:

Warning: include(/Applications/MAMP/htdocs/sites/all/modules/timeline/views-view-timeline.tpl.php) [function.include]: failed to open stream: No such file or directory in theme_render_template() (line 1382 of /Applications/MAMP/htdocs/includes/theme.inc).
Warning: include() [function.include]: Failed opening '/Applications/MAMP/htdocs/sites/all/modules/timeline/views-view-timeline.tpl.php' for inclusion (include_path='.:/Applications/MAMP/bin/php/php5.3.6/lib/php') in theme_render_template() (line 1382 of /Applications/MAMP/htdocs/includes/theme.inc).

@KarenS hi - here's a git-formatted patch against 7.x-3.x from #12, with the round() fix to getDefinedDateField() in #13.

When you get a chance, would you check if this matches the code you have on your site? I'm asking because like #14 & #15, I still two issues with this:

1. Date fields aren't selectable in the timeline display settings (only system post date).
2. When I do try to use the system post date, the timeline view contains only empty divs

For the second issue, i enabled debug mode, and pasting the output here in case it's revealing in any way:

array (
  'events' => 
  array (
    'events' => 
    array (
      0 => 
      array (
        'title' => 'Photosynthesis',
        'link' => false,
        'start' => '2012-01-15T00:24:34Z',
        'durationEvent' => false,
        'color' => '#0A3FAC',
        'classname' => 'timeline-set-0',
        'description' => '  
  <div class="views-field views-field-title">        <span class="field-content"><a href="/topic/photosynthesis">Photosynthesis</a></span>  </div>  
  <div class="views-field views-field-field-date">    <span class="views-label views-label-field-date">Date: </span>    <div class="field-content"><span class="date-display-single" property="dc:date" datatype="xsd:dateTime" content="2012-01-21T07:45:00-05:00">01/21/2012 - 07:45</span></div>  </div>  
  <div class="views-field views-field-body">        <div class="field-content"><h2>Resources</h2>
<p><a href="http://www.youtube.com/watch?v=C1_uez5WX1o">http://www.youtube.com/watch?v=C1_uez5WX1o</a><br /><a href="http://www.youtube.com/watch?v=LgYPeeABoUs">http://www.youtube.com/watch?v=LgYPeeABoUs</a><br /><a href="http://www.education.com/worksheet/article/photosynthesis-for-kids-coloring-page/">http://www.education.com/worksheet/article/photosynthesis-for-kids-color...</a><br /><a href="http://www.biology4kids.com/files/plants_photosynthesis.html">http://www.biology4kids.com/files/plants_photosynthesis.html</a><br /><a href="http://www.kidzpark.com/content.asp?c_id=34">http://www.kidzpark.com/content.asp?c_id=34</a></p>
<h2>Objectives</h2>
<ul><li>Explore how plants eat, breathe, and grow.</li>
<li>Recognize that people and animals need oxygen to breath.</li>
<li>Use this a tool to talk about the environment, preservation of natural spaces, earth stewardship, along with practicing handwriting, vocabulary and some math and measuring.</li>
</ul><h2>Project</h2>
<p>Water plant experiment.</p>
<h3>Materials</h3>
<ul><li>Hydrilla plant</li>
<li>Test tube</li>
<li>Funnel</li>
<li>Glass jar</li>
<li>water</li>
</ul><h3>Procedure</h3>
<p>In order to show the production of oxygen during photosynthesis, you can use a water plant. As shown in figure , immerse the plant in a tankard of water, cover the plant with a transparent funnel and put a test tube on the funnel. Make sure at the beginning there are no air bubbles in the tube. Expose the plant to sunlight and after some time you will see bubbles of oxygen gather on the test tube then collect to form a larger bubble.</p>
<p>Photograph the results.</p>
<h2>Vocabulary and Spelling words</h2>
<ul><li>Chlorophyll</li>
<li>Carbon dioxide</li>
<li>water</li>
<li>nutrients</li>
<li>greensunlight</li>
<li>oxygen</li>
</ul></div>  </div>  
  <div class="views-field views-field-created">    <span class="views-label views-label-created">Post date: </span>    <span class="field-content">01/15/2012 - 00:24</span>  </div>',
      ),
    ),
    'dateTimeFormat' => 'iso8601',
  ),
  'id' => 'timeline',
  'orientation' => 0,
  'initial_focus' => 'Jan 21 2012 17:07:06',
  'timezone' => 0,
  'controls' => false,
  'bands' => 
  array (
    0 => 'DAY',
  ),
  'summary' => 'MONTH',
  'band1_unit_width' => '10',
  'band2_unit_width' => '10',
  'theme' => 'LightTheme',
  'bubble_max_height' => '',
  'bubble_width' => '250',
)

^ This is homeschooling site for our preschooler btw :)

The patch would help ;) Here it is

Patch in #18 works for me, thanks!

> Date fields aren't selectable in the timeline display settings (only system post date).

I found that if you change 'field_type' => 'date', to 'field_type' => 'datetime', in plugins/date_sources/date_field.inc, then "regular" Date fields are selectable and usable. I don't really know why that is, though...

I reviewed the code, committed it to the module and made a D7 development release.
Thank you all!

For what it's worth, on D7 after downloading the latest 7.x version I still had to change "date" to "datetime" to get it to allow me to use CCK date fields.

I'm still however not getting a timeline to display at all. Debug timeline output is showing that content is being selected for it. I'm getting two script errors:

"JQuery is undefined" at line 72 timeline
and
"JQuery is undefined" at line 382 drupal.js?lzpzkg

I saw what (maybe?) is a similar issue in the 6 branch, but quite frankly I was befuddled by the code and thought I'd give you a heads up here. Great module by the way, hope the problem is easily fixed!

Thanks for reporting, jgarbe. I reopened this.

The jQuery error I have seen when using newest Simile Timeline libs from their SVN repo. Please use the ones from the github repo. We need somehow a better solution on how to handle versions of time Simile Libs for our module...

I had similar jQuery errors from both the github and svn sources listed in the install.txt. On a whim, I tried the 2.x branch on github and the timeline is at least rendering now.

I'm kinda lost. All patches rejected.
Please tell me if there's a solution for a date field with "collect end date" enabled.
I've changed 'field_type' => 'datetime' and still I can't select my custom date field (with end date enabled) in Timeline settings.

Also I get "There is no data available to show on the timeline" but if I swith to "unformatted list" there's a node.

The same problem!
Furthermore: Date fields not showing up as options for the timeline
:-((

Hello, I installed the patch to take into account the date in datetime format, and then it seemed to me that the end date of a period is taken into account with this correction. But this is not the case with me, even if in the configuration I chose an end date, the display is always the current date is taken into account. On the frieze, all my periods ending at the current date. Do you have any idea to correct?

-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Reply:
in fact the fix works, it must be a typo in this method:

diff --git a/includes/TimelineEvent.class.inc b/includes/TimelineEvent.class.inc
index 697bebb..c784068 100644
--- a/includes/TimelineEvent.class.inc
+++ b/includes/TimelineEvent.class.inc
@@ -90,9 +90,25 @@ class TimelineEvent {
$field = $this->getDefinedFieldUsage($event_field);
if (isset($row->{$field['alias']})) {
// Loading plugin to handle date format
+ $value = $this->view->field[$field['fieldname']]->get_value($row);
+ // If this is a date field, get_value() returns an array of values.
+ if (is_array($value)) {
+ // @TODO Need to confirm if this will retrieve the right value for multiple value fields.
+ $value = array_shift($value);
+ switch ($event_field) {
+ case 'start':
+ case 'earliestStart':
+ $value = $value['value'];
+ break;
+ case 'end':
+ case 'latestEnd':
+ $value = $value['value']; // AND not : $value = $value['value2'];
+ break;
+ }
+ }
if ($conversion_callback = timeline_plugins_get_callback($field['handler'], 'date_sources')) {
- $event[$event_field]['formated'] = call_user_func($conversion_callback, $row->{$field['alias']}, 'iso8601', array('field' => $field));
- $event[$event_field]['timestamp'] = call_user_func($conversion_callback, $row->{$field['alias']}, 'timestamp', array('field' => $field));
+ $event[$event_field]['formated'] = call_user_func($conversion_callback, $value, 'iso8601', array('field' => $field));
+ $event[$event_field]['timestamp'] = call_user_func($conversion_callback, $value, 'timestamp', array('field' => $field));
}
}
}

Thank you very much for your excellent work.

Hi,
just a note: the "['value2']" is correct for Drupal 7 date fields with the option "Collect an end date" activated. This means one field stores two date values.

The database table of such a date field has two columns for these values.
For example a field named "timeline earliest latest" has these (value) columns then:
- field_timeline_earliest_latest_value ... stores the "earliest" date
- field_timeline_earliest_latest_value2 ... stores the "latest" date
The Timeline module retrieves the "earliest" date from column "field_timeline_earliest_latest_value" and the "latest" date from column "field_timeline_earliest_latest_value2". So this is the reason for the "['value2']".

Using such a date field it is possible to have all four ("earliest", "start", "end", "latest") Timeline dates in just two Drupal 7 View fields (i.e. two database tables instead of four).