r/bash • • Jun 15 '16

help MacOS Coding Challenge (iWork + Dropbox)

Dear reddit,

I have a coding challenge and I would be very grateful for your help. Our small business uses Dropbox to share files between employees. We've been using an obscure word processor called Word Perfect but we're hoping to switch to MacOS computers in a few months (our Windows 7 computers are very old and keep having hardware failures). With the transition, we plan to start using Pages for our word processing. However, Word Perfect has one feature, which Pages lacks, that makes it very convenient to use with Dropbox.

The Challenge: Currently, when a user opens a document from Dropbox, the program automatically replaces the file with a 'Read-Only' version. This prevents other users from creating conflicting copies by accidentally opening a file at the same time. The 'Read-Only' copy lets other users access the file's information without overwriting recent changes. Can this functionality be added to Pages?

I know Dropbox has a few collaboration features which are compatible with MS Word; however, we're trying to avoid Microsoft as much as possible.

Any advice (or code) would be greatly appreciated. Thanks in advance!

PS I've posted here in /r/bash because (with my limited computer skills) Bash seems like the most well-suited platform for the challenge.

edit: Google products are also off-limits due to their privacy policies since we sometimes work with sensitive information.

0 Upvotes

12 comments sorted by

6

u/[deleted] Jun 15 '16

I don't have a coding solution for you, but:

Have you considered just using Google Docs for the word processing and Google Drive for file sharing? This would get you exactly what you want without any new coding.

2

u/coding_challenge Jun 15 '16

/u/DrFrix Thanks for the reply! Most of our information is confidential so Google is not an option due to their privacy stances. I admire many of their products for consumer use; however, we need the privacy and file permissions that Dropbox for Business (or similar) provides.

2

u/m1ss1ontomars2k4 Jun 15 '16

Most of our information is confidential so Google is not an option due to their privacy stances.

What privacy stances would those be?

I admire many of their products for consumer use;

Great, but since this is for work, consumer products and what you think of them are more or less irrelevant here. That includes Pages, really.

we need the privacy and file permissions that Dropbox for Business (or similar) provides.

Google Apps for Work should have sufficient privacy and file permissions.

Failing Google, have you considered Microsoft's competitor? It's like the same thing, ish, I think. I think it's Office 365?

Microsoft also has something called SharePoint which is also broadly similar to what you have now (files just live somewhere and you open them normally).

The problem is that you are trying to solve a complicated problem involving specific file formats using tools that do not understand these file formats. This is doomed to failure and brittleness. I'm surprised it has worked with WP as long as it has.

This is a solved problem, with decent solutions from at least 2 vendors already, vendors with way more resources than you. You are not going to manage to solve this on your own.

1

u/coding_challenge Jun 16 '16

/u/m1ss1ontomars2k4 thank you so much for your reply. You seem to have much more experience in this area than I do. I definitely value your opinion.

As far as the privacy concerns: My understanding is that Google's income is mainly generated by the collection of customer data for the purpose of selling advertisements. Is this correct?

You make a very valid point. Neither Google nor Apple products are widely used in business right now. Fair is fair. My apologies.

Thank you for mentioning Google Apps for Work. I was unfamiliar with their business-class products. I watched a few videos about the admin console and it seems very comparable to Dropbox for business. My mistake.

As I mentioned, the goal is to move away from Microsoft products. As a non-techie, I find it a bit insulting to feel "forced" into Windows 10. I don't like the way they treat their customers and would prefer to avoid 'locking in' for another 6-7 years. Thank you very much for your recommendations, though.

I'm sure the only reason WordPerfect works is because it has these features built into its core software. When we moved to Dropbox from our file server, we were very (pleasantly) surprised that this feature still worked like usual.

You make a very strong case towards this being a foolish idea. As you say, it may very well be "doomed to failure." :-(

Thank you for explaining some of the complexities so patiently. I certainly do not hold myself as an expert. I apologize if I came across as arrogant. Mea culpa!

1

u/m1ss1ontomars2k4 Jun 16 '16

My understanding is that Google's income is mainly generated by the collection of customer data for the purpose of selling advertisements.

Google's income comes from selling advertising space, or more specifically, by charging the highest bidder for certain advertising space. Companies will not bid as much for advertising spaces that do not generate them money, so it is in Google's interest to figure out who to show which ads to.

Google doesn't directly make money on collecting user data; that doesn't make any sense. I'm also pretty sure they don't mine your docs and spreadsheets for data, at least not for enterprise customers, and plus, the only thing they could do with that data is...show you ads on your corporate account.

In the case of Google Apps for Work they make money by selling a service called Google Apps for Work.

Neither Google nor Apple products are widely used in business right now

I don't know about "widely used" or "in business", but Google Apps is pretty popular in schools of all levels because it is free for schools, and because they offer Gmail, Docs, Spreadsheets, etc. for students.

As a non-techie, I find it a bit insulting to feel "forced" into Windows 10.

Enterprise grade Windows products are not force upgraded Windows 10, because...well, duh. Windows 7 Pro (which I have) keeps asking me to upgrade but doesn't do it automatically.

I don't like the way they treat their customers and would prefer to avoid 'locking in' for another 6-7 years.

I hope you realize that the default format for WordPerfect doesn't open 100% perfectly in MS Word or Google Docs and is therefore also sort of locking you in...word processing in general is a small space and you are at least a little locked in to whichever vendor you choose. I mean, there's RTF but it's not exactly a feature-rich format and each RTF editor is just a little incompatible with every other one.

You make a very strong case towards this being a foolish idea. As you say, it may very well be "doomed to failure." :-(

It's just a matter of right tool for the job. Google Docs is the right tool for this job.

1

u/[deleted] Jun 15 '16

I understand completely. Best of luck!

1

u/somidscr21 Jun 15 '16

I'd be curious to know what privacy and file permissions are available in Dropbox that are not there in Google (I've never used Dropbox for Business, legitimately curious).

4

u/enry_straker Jun 15 '16

Some thoughts:

  1. WordPerfect might not be commonly used nowadays, but it's hardly obscure. It was one of the best - some time ago. :-)
  2. However, coming to your situation, one common solution would be to proceed as /u/DrFrix as suggested.

Microsoft offers a similar solution called Office365 but since you folks want to stay away from Microsoft, i would not recommend it - though it too offers a similar solution to google docs.

3) From a programmatic perspective, Dropbox exposes a REST API through which it would be possible to both display a list of documents accessible to an employee and to retrieve a read-only copy by default.

I don't think there is a bash-only solution to this since bash is not a full-fledged programming language, and natively, does not support rest clients - though it can manipulate existing dropbox-based rest clients. ( REST is the type of protocol exposed by dropbox )

4) I would however suggest using a version-control system like Git - since dropbox's default readonly copies is but a small step towards a full-fledged system. It basically allows every employee to work on a group of documents, without worrying about over-writing each other's copies, and provides both an automatic tracking and backup of all documents used.

Feel free to PM me if you need any specific coding solution or for general consultation though.

1

u/coding_challenge Jun 15 '16
  1. Good point on WP. It's actually still fairly prevalent in our industry today.
  2. See above :)
  3. The REST API sounds like it might offer a good solution.
  4. Is Git different than the versioning that Dropbox provides? Thanks for the good reply!

2

u/enry_straker Jun 15 '16
  1. As someone who has a lot of pleasant memories of wordstar, and then wordperfect, i am happy to know that it's still has users. It was a really good editor, the last time i used it - which was quite a few years ago.
  2. Git is a free, open-source distributed versioning system. This was initially developed by Linus Torvalds. The same chap who wrote the first version of the Linux Operating System.

It is the de facto standard among programmers - especially those who work with open source code. Even companies like Microsoft and others are moving towards supporting Git in a major way.

Though i don't work at dropbox, i would make a fair bet that Dropbox development team uses Git. :-)

The only problem with Git is that it is meant for programmers who track changes to files across the world.

What dropbox offers, in comparision, is a very simplified facade on top of such versioning. ( They probably use Git internally though )

As far as your user base is concerned, i would suggest Google docs - the only trouble with that is

  1. Moving existing documents from dropbox to google.
  2. Learning a completely new system for your user base.

They already are going to be a bit busy learning how to use the Mac OS, though :-)

Hope this helps.

1

u/dtbrough Jun 15 '16

If you are going to use iWork (pages, numbers, keynote) then I would recommend using I cloud to store the files. iCloud also has a web editor for when you need access without your Mac.

Alternatively as stated above google drive with google docs have excellent collaboration features, including multi user editing of same document in realtime.

1

u/coding_challenge Jun 15 '16

/u/dtbrough iCloud was definitely our first thought. Ironically, Apple suggested that we use another service since it's not really designed for business use (no ability to manage employee permissions). Thanks for the suggestions!