NUKnightLab / NUKnightLab/TimelineJS3
Excel - Json - Joomla
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

Various Screen Shots of Excel




Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- 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