OpenlyOne / openly-rails

"GitHub" for Google Drive [inactive]
https://www.open.ly/
GNU General Public License v3.0
21 stars 1 forks source link

Add (side-by-side) diffs for Google slides #271

Open FinnWoelm opened 5 years ago

FinnWoelm commented 5 years ago

Babila suggested that implementing diffing for Google slides would be a valuable feature to add:

Being able to compare the versions of my thoughts in a presentation on split screen helps me. I was looking to see if I could see the diff on the presentation the way I can on documents but doesn’t look like I am able to.

Diffing Google slides (and other presentation formats, such as .pptx) is not an easy task — depending on the implementation. As a first, proof-of-concept implementation, we might be able to use Apache Tika to extract the presentation's text and then show changes in text for each slide side-by-side.

A more full-featured implementation should be able to render and diff not just text, but also images and graphics. It will require an advance in our diffing (from just text to text+styles+images) as well as some sort of HTML-based rendering of .pptx files.

FinnWoelm commented 5 years ago

After implementation of #269, we should create a few proposals for what this could look like and then touch base with Babila and ask for his feedback.

FinnWoelm commented 5 years ago

We can extract plain text from .pptx files (which Google Slides converts to when downloaded):

file = File.new(Rails.root.join('tmp', 'pres.pptx'))
html = Henkei::Server.extract_html(file)
parsed = Nokogiri::HTML.parse(html)
value.css('.slide-content').each_with_index { |x, i| puts "---Slide #{i}---" + x.text }

Output:

---Slide 0---

Open Source Beyond Code
‹#›

---Slide 1---

Status Quo of Online Doc Collab                 
‹#›

?????

“This is a huge problem. We are working with 30+ consistent contributors on our Google Drive and it's an absolute mess. Everyone (us & clients) just dumps files wherever they want, no one can find what they're looking for. We need something like GitHub but for docs. “

- Dave, CEO of a 100+ people software dev/consulting company
---Slide 2---

Problem
‹#›

Doc Collaboration
Project Management

People have to compromise and choose between the two
Doesn’t work for binary files like Google docs, ppt, xls
Projects become a mess when large teams collaborate 

---Slide 3---

Openly       is a project management platform 
that brings the best of GitHub
Including commits, diffs, issue tracking, and pull requests 
to document collaboration on Google Drive.

Unlike GitHub, Openly optimizes for diffing and merging documents and requires absolutely zero use of the command line.
‹#›

---Slide 4---

Solution
‹#›
Repositories, commits, diffs, pull requests, and issue tracking — we’ve replicated the best of GitHub.

The Best of GitHub

Diffing and merging optimized for Google file formats — from docs to sheets to slides.

Optimized for Documents

All Git functionality layered right on top of Drive in your browser — bye, bye command line.

Built for GDrive

---Slide 5---

Target Audience
‹#›
Remote-working teams that use GitHub & GDrive to collaborate internally and with tech & non-tech clients.

---Slide 6---

No Solution Addresses the Problem
‹#›

Git flow

Adapts to GDrive 

---Slide 7---

Market

>3M paying G Suite companies

‹#›

>100k US software service teams

>31M GitHub users       $300M revenue

---Slide 8---

Business Model 
‹#›
Private projects: $8/month/seat
Open projects:  free

---Slide 9---

Traction
‹#›

250+ customer validation conversations

Built & testing functional prototype 

Accepted into Antler, an accelerator investing $100k for 10% equity

---Slide 10---

Team 
‹#›

Finn
Full stack Rails
10+ years coding/building

Jessy
Business Dev

---Slide 11---

jessy@openly.one
‹#›

?

Not just a project management tool - we’re bringing open source beyond code to impactful projects ❤️ 
FinnWoelm commented 5 years ago

This is what the diff could look like side-by-side.

screenshot_2019-02-04 openly 2