Hi Steve,

Usually, if you have Oracle, then you also have the full suite of Oracle tools, 
report writers, and trained IT folks to assist.

Probably easiest is to show an IT person the XML format used by Timeline. I'm 
sure that Oracle has an XML output option from their report writer.

After you get the XML file, you'll want to add the extra attributes in the 
<data> tag before the events.

Remember the date time issues: depending on the format from Oracle, you'll 
probably want to add in
       date-time-format="iso8601"     to the data tag

You can use any simple text editor (Wordpad or Notepad) to change the XML. 
Don't use Word.

Eg, xml from Oracle will look something like:

<data>
    <event
       start="Sat May 20 1961 00:00:00 GMT-0600"
       title="'Bay of Pigs' Invasion">
    </event>
    <event
       start="Wed May 01 1963 00:00:00 GMT-0600"
       end="Sat Jun 01 1963 00:00:00 GMT-0600"
       isDuration="true"
       title="Oswald moves to New Orleans">
         Oswald moves to New Orleans, and finds employment at the William <!-- 
The event's description -->
         B. Riley Coffee Company. &lt;i&gt;ref. Treachery in Dallas, p 
320&lt;/i&gt;
    </event>
    <event>
      ...
    </event>
</data>

But you want:
<data
  wiki-url="http://simile.mit.edu/shelf/";
  wiki-section="Simile JFK Timeline">
    <event
       start="Sat May 20 1961 00:00:00 GMT-0600"
       title="'Bay of Pigs' Invasion">
    </event>
    <event
       start="Wed May 01 1963 00:00:00 GMT-0600"
       end="Sat Jun 01 1963 00:00:00 GMT-0600"
       isDuration="true"
       title="Oswald moves to New Orleans">
         Oswald moves to New Orleans, and finds employment at the William <!-- 
The event's description -->
         B. Riley Coffee Company. &lt;i&gt;ref. Treachery in Dallas, p 
320&lt;/i&gt;
    </event>
    <event>
      ...
    </event>
</data>


Once you have it figured out, please "pay it forward" by letting us all know 
which Oracle tool you used and any special settings.

Regards,

Larry




________________________________
From: Stephen Martino <[email protected]>
To: [email protected]
Sent: Tuesday, December 30, 2008 3:58:17 PM
Subject: Re: Timeline: Is it possible to set the number of lines and assign 
specific type (or name) of events to these lines

Larry,

I was just wondering if you know of a way to take the ouput of an Oracle query 
and get it into a format that Timeline would handle?

thanks

Steve


On Fri, Dec 26, 2008 at 5:28 PM, Tiago Silva <[email protected]> wrote:

Thank you!



On Fri, Dec 26, 2008 at 10:07 PM, Larry Kluger <[email protected]> wrote:


Hi tiagosilva,

Yes, you can specify which track an event should appear on. If you do this then 
you are responsible that one event does not overlap another on the Timeline.

Current trunk version of Timeline includes support for the event attribute  
trackNum
See http://code.google.com/p/simile-widgets/wiki/Timeline_EventSources

The number of tracks in your band depends on the "width" of your timeline and 
your theme settings for the band.

You can also assign to any number of tracks and use the autoWidth feature to 
automatically expand the timeline the needed amount.
See  autoWidth in the Changes file:
http://simile-widgets.googlecode.com/svn/timeline/trunk/CHANGES.txt

Note that the above feature are currently only in the Trunk version of the 
software. 

Regards,

Larry





________________________________
 From: tiagosilva <[email protected]>
To: LarryK ...
Sent: Friday, December 26, 2008 4:34:07 PM
Subject: Re: Timeline: Is it possible to set the number of lines and assign  
specific type (or name) of events to these lines

Could someone who did this paste the code for our convinience?

On Oct 16, 5:54 pm, LarryK <[email protected]> wrote:
> Hi Hunt,
>
> Glad it's working for you. I do plan to add it relatively soon but if
> you want to add it to the source in the meantime, you can get access
> rights in the meantime. If you don't want to take on the issues of
> testing, etc, as an alternative you could supply the diffs for the
> files that you modified.
>
> Regards,
>
> Larry
>
> On Oct 16, 12:14 pm, culver <[email protected]> wrote:
>
> > Great solution, Larry!
>
> > I did something virtually equivalent to, and before I found, your
> > suggestion and it works great!
>
> > How likely is it that this feature will be incorporated in the code
> > trunk?
>
> > Later,
> > Hunt
>
> > On Sep 23, 5:08 pm, LarryK <[email protected]> wrote:
>
> > > Hi Fred,
>
> > > The software does not currently include the functionality that you
> > > suggest, but you could add it.
> > > You could have an event attribute of 'track_number' -- Timeline
> > > nomenclature is that each duration event has a "tape" on a particular
> > > "track"
>
> > > Non-duration events have an icon on atrack.
>
> > > In file original-painter.js, each of the functions
> > > Timeline.OriginalEventPainter.prototype.paintPreciseInstantEvent
> > > Timeline.OriginalEventPainter.prototype.paintImpreciseInstantEvent
> > > Timeline.OriginalEventPainter.prototype.paintPreciseDurationEvent
> > > Timeline.OriginalEventPainter.prototype.paintImpreciseDurationEvent
>
> > > has a line
> > >     vartrack= this._findFreeTrack(rightEdge);
> > > You'd change those lines to
> > >   vartrack= (evt.getTrackNumber() != null) ? evt.getTrackNumber() :
> > > this._findFreeTrack(rightEdge);
>
> > > You'd also change sources.js to support the new attribute.
>
> > > Regards,
>
> > > Larry
>
> > > On Sep 23, 11:29 am, Fred <[email protected]> wrote:
>
> > > > Hi all,
>
> > > > I'm wondering if it is possible to do something like this: (specify on
> > > > which line the event should appear and not let the timeline do it):
>
> > > > say the timeline is made of 5 lines, each line assigned to an event
> > > > type,
>
> > > > * Event1 (type 1)                    * Event2 (type1)
> > > >         * Event3 (type 2)    * Event6 (type 2)
> > > >    * Event 4 (type 3)
> > > >                   * Event 7 (type 4)
> > > >          * Event 5 (type 5)
>
> > > > typical example: 1 line for a project X, 1 line for project Y, ...
>
> > > > --Fred- Hide quoted text -
>
> > > - Show quoted text -








--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"SIMILE Widgets" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to 
[email protected]
For more options, visit this group at 
http://groups.google.com/group/simile-widgets?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to