NUKnightLab / NUKnightLab/TimelineJS3

Excel - Json - Joomla

Open
#793 9 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Dominant language
JavaScript
Stars
3.2k
Forks
645
PR merge metrics
No merged PRs in 30d

Description

A contribution to TimelineJS3

3 years ago I developed an Excel Based (VBA driven) routine to convert an Excel Worksheet to a JSON file which can be used instead of GoogleSheets; The results can be viewed at : https://oathlawtannadice.org.uk/hidden/tannadice-church-1500-1900-ad#event-things-are-about-to-change- (TimelineJS3 Version 3.8.21) (The site is developed using Joomla, TimelineJS3 called from Joomla Article)

Currently looking to move the site to Joomla V 4 (now moved) and checking out TimelineJS3.
Installed Locally (WAMPSERVER/Locahost) the Timelines display using latest version of TimeLineJ3 (3.8.21) with minor issues as noted:

a. TimelineJS3 options parameter 'Ease' causes error - Commenting out resolves
b. Re-write of Javascript prevents coloured markers - may be resolved in future (Now resolved - see #798)
c. Re-write of Javascript uses SANATIZE for html - needed slight change to HTML on one slide - move 'Style' to CSS

In Summary the EXCEL to JSON routine is valid for lastest version of TimelineJS3
The EXCEL routine also has a function to create a Slide Entry in a vertical format and insert into the standard format
Anyone interested in the above can request the EXCEL Sheets / Joomla details

Personal Note: Algol 60 at School / Various at Uni / Coral66 first employment
Not too well conversant with Javascript, Node.JS etc.
Not a member of Tannadice Church - Project was favour for friend

Attached are JSON file for TimeLine : Tannadice Church (1500 - 1900 AD) (rename OTProject01.txt to OTProject01.json
Also Some Screen Shots

OT-Project01.txt
Sample Web Page
Page from Timeline 1838 -1841
Various Screen Shots of Excel
Excel Sheet (left)
Excel Sheet (Middle)
Excel Sheet (Right-75%)
Excel Slide Create Vertical

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

The report mentions TimelineJS3 3.8.21, the Ease option error, and the attached OTProject01.txt JSON; begin by reproducing the issue with the local Joomla/WAMP setup. A specific change and reproducible test are still needed before “done” can be defined.

Written by the indexing model from the issue text.

Assessment

Tech stack
javascript
Domain
frontend
Issue type
Bug
Difficulty
5/5
Estimated time
Over a week
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.