The Book-keepers Forum (BKF)

Post Info TOPIC: Web-based file sharing


Senior Member

Status: Offline
Posts: 206
Date:
Web-based file sharing
Permalink Closed


Hi I wonder if I can get some advice from someone who's already doing this ? We use a lot of Excel spreadsheets for one particular client, which we are storing on an external hard drive, so that a) more than one person can access them, b) we won't lose them if our computer dies, and c) they are portable. The only problem is that if I need to work on the files at home, I have to know in advance so that I can remember to bring the drive home with me. We are looking to find a web-based solution so that a couple of us can update the files and they will be accessible to us both from any location, and always in the latest version. I am looking at Dropbox and also Google Docs, but I can't get my head round how either of them would work in practice. Is there anyone reading this who has used this kind of set-up who could talk me through it ?

__________________

Eunice Cubbage



Forum Moderator & Expert

Status: Offline
Posts: 11981
Date:
Permalink Closed

Hi Eunice,

have you tried looking at dropbox? Not used it myself but I know that Sheila (Semsley) has and she has recommended that previously although for a slightly different scenario.

Just a suggestion.

An issue I can see is that there is nothing to stop several people grabbing the same file at the same time and it will only be the last persons updates that get saved.

HTH,

Shaun.

__________________

Shaun

Responses are not meant as a substitute for professional advice. Answers are intended as outline only the advice of a qualified professional with access to all relevant information should be sought before acting on any response given.



Senior Member

Status: Offline
Posts: 206
Date:
Permalink Closed

Hi Shaun

Thanks for the reply. As I said, Dropbox is one of the ones I have been looking at, maybe Sheila will reply and let me know
what she thinks of it.

The file sharing which goes on doesn't usually happen at the same time, in fact usually there's only one of us (me)
actually amending the data, but we both need access, so i don't think there will be a problem in sharing, such as
you describe.

__________________

Eunice Cubbage



Veteran Member

Status: Offline
Posts: 26
Date:
Permalink Closed

Have you looked at SpiderOak? I automatically back up to them at the end of each day and can easily access my data remotely. Not sure how it works if more than one person is updating files though.

Sarah

__________________

Follow me on Twitter: http://twitter.com/sarleighton

or see my website at: http://slbookkeeping.co.uk



Guru

Status: Offline
Posts: 827
Date:
Permalink Closed

Hi Sarah,

One good thing about dropbox is it will notify you when files has been changed, a message pops up and there's also a drop down menu with an option to select "recently changed files". The downside is I think it actually means recently accessed files but at least it gives some info.

It takes a little co-ordination between you and your client, if they're going to change things. I have a text file, "change-log", in each clients shared folder for each of us to note if we've made changes which works ok.

__________________
Tony

Responses are intended as outline only. Formal advice should be sort from your Institutes Technical Department or a suitably qualified Accountant.
.


Senior Member

Status: Offline
Posts: 421
Date:
Permalink Closed

Dropbox is very good. We use it a lot.

But it is worth noting that while it works very well for Office style data (eg spreadsheets and documents) it isn't really designed to work with transactional data such as held in accounting systems or payrolls like 12Pay. For data of that type you can use a dropbox folder to transfer information between users, but you shouldn't open the data directly while it is in the dropbox folder, or you may get unexpected results and the software might hang.

__________________

Life's a reach, then you gybe

 



Guru

Status: Offline
Posts: 1329
Date:
Permalink Closed

I use Dropbox as Shaun has said. What I do with clients is use it as a backup/restore for accounting or payroll programmes. Only two clients actually input anything themselves and for them we always name the backup with the date and time to avoid using incorrect data. I like Tony's idea of a change-log file too. The beauty of Dropbox is it is free.

HTH

Sheila

__________________

Advice from beyond the grave!!!

E&OE

pDm


Senior Member

Status: Offline
Posts: 173
Date:
Permalink Closed

GoogleDocs is excellent for this - not sure how secure you'd feel your data was though. For me personally, it's free, it's portable, it's not platform reliant, it's sharable (many people can edit at the same time & in real time) and there's a similar history of changes widget-thingy.

__________________

my blog "the bookkeeper's in town - learning the hard way"

thebookkeepersintown.wordpress.com



Guru

Status: Offline
Posts: 827
Date:
Permalink Closed

I thought Google Docs is a subscription service for business use and chargeable per user?

__________________
Tony

Responses are intended as outline only. Formal advice should be sort from your Institutes Technical Department or a suitably qualified Accountant.
.
pDm


Senior Member

Status: Offline
Posts: 173
Date:
Permalink Closed

I really hadn't noticed to be honest. Guess I should look into that...

__________________

my blog "the bookkeeper's in town - learning the hard way"

thebookkeepersintown.wordpress.com

pDm


Senior Member

Status: Offline
Posts: 173
Date:
Permalink Closed

Yes you're right - £3 a month or there abouts. Bargain.

__________________

my blog "the bookkeeper's in town - learning the hard way"

thebookkeepersintown.wordpress.com



Guru

Status: Offline
Posts: 1329
Date:
Permalink Closed

pDm wrote:

Yes you're right - £3 a month or there abouts. Bargain.


 Not as much a bargain as Dropbox which if free.



__________________

Advice from beyond the grave!!!

E&OE



Senior Member

Status: Offline
Posts: 112
Date:
Permalink Closed

I use Livedrive cloud storage as my backup system. Call me paranoid, but I was worried about a break in and someone stealing my PC and external hard-drive!

Livedrive is about £50 or so a year for unlimited storage and as many computers as you need. I have my laptop, PC, my partner's PC, Laptop and netbook all backed up.

I just download the files I need though off the the livedrive backup when I need to use them on another PC, a standard doc only takes a few seconds to download.

It is a great system, instant backup. As soon as you modify a file or document, it automatically scans and uploads it to your online backup facility. I had a hard-drive failure on the 2nd February after all of my SA work was completed, and if I did not have my data backed up it would have been a major disaster. It was a pain having to get a new hard-drive installed, but at least I just had to download my files again to the new one.

It has a briefcase option within it that you could used for transferring files, although this costs extra and I'm not exactly sure what the benefits are, I have never had need for it myself.



__________________


Expert

Status: Offline
Posts: 2256
Date:
Permalink Closed

mushroom wrote:

I use Livedrive cloud storage as my backup system. Call me paranoid, but I was worried about a break in and someone stealing my PC and external hard-drive!


 I use Dropbox for some files

I do like belt and braces though (No fashion sense mesmile), and like you am paranoid there will be a break in, or fire when I am not around, so I invested in a portable 1TB USB external hard drive (WD Passport) at about £70. The built in software does almost live backup (at computer idle times). It backs up all data files, and is handy because it is about the size of a smartphone, so it's very portable. If I am out of my office, I take it with me.

In the event of data loss, it can restore the latest backup (it defaults to 5 versions for each file, so you can ckhoose an earlier version) either to a holding file on the PC, or directly back to it's original location.

Bill



__________________

 

 



Guru

Status: Offline
Posts: 827
Date:
Permalink Closed

Since Bill started the paranoia thing and we're now discussing back-up routines

1. Critical data backup up off-site in dropbox. Updated weekly
2. 1tb "Time Machine" updated at least one a day
3. 1tb monthly clone of HDisk stored off-site at my partners

I wonder how many here actually "test" their back-up data or just "assume" it's ok.

__________________
Tony

Responses are intended as outline only. Formal advice should be sort from your Institutes Technical Department or a suitably qualified Accountant.
.


Forum Moderator & Expert

Status: Offline
Posts: 11981
Date:
Permalink Closed

Hi Tony,

good story on that one.

My first job was working in Payroll. We paid over 350,000 staff per week and there were eight backups taken at the end of each run (plus incremental backups during the processing).

One Wednesday night there was a payroll failure and we needed to rewind to the previous run to go forward... Backup (1) failed. (2) failed, (3) failed.... sensing a pattern here! It actually got all the way back to GDG -8 before we had a backup that worked.

The thought of 350k angry unpaid employee's is a mighty big motivator when you're sweating over a computer terminal at 3 in the morning.

Following that we wrote an emergency routine to check the validity of backups at the end of a run before closing off the nights processing.

And yes, when I take backups now I always check that they load. But, if I hadn't had that experience early in my career I would probably have ended up a lot more complacent about it.

On a not linked note, but for the same company we had an emergency backup generator. Whoever the bright spark was that bought that should have been given the long walk as the generator needed to be started from the mains and of course by definition if there was a mains supply there the backup generator wasn't actually needed!

Funny old world init.

Shaun.

__________________

Shaun

Responses are not meant as a substitute for professional advice. Answers are intended as outline only the advice of a qualified professional with access to all relevant information should be sought before acting on any response given.



Guru

Status: Offline
Posts: 827
Date:
Permalink Closed

Hi Shaun

Ouch!! My bottle would've gone by about number 3. Completely agree with you, Shaun, that often we only learn the hard way... I know I did.


__________________
Tony

Responses are intended as outline only. Formal advice should be sort from your Institutes Technical Department or a suitably qualified Accountant.
.


Guru

Status: Offline
Posts: 518
Date:
Permalink Closed

Googledocs and Dropbox are two different things

I am pretty sure you can use a free version of Googledocs to do what you want to do. The main thing with GD is that it is on the web live, so two people can have real time access to the same document.

Dropbox does not work this way and you can occasionally end up corrupting files if two people are on the same spreadsheet as the source document is on each local machine.

I use both very effectively and in fact have the paid for version of dropbox.

__________________

Phil Hendy, The Accountancy Mentor

Are you thinking of setting up your own practice or have you set up and need some help?

If so a mentor may be the way forward - feel free to get in touch and see how I can assist you. 

 



Guru

Status: Offline
Posts: 513
Date:
Permalink Closed

Does any one use microsoft skydrive with windows live mesh? I find it really good, i dont have to take back ups, it does that for me. I can access them from the internet and my phone. You can even link two or more computers together, the only problem is it doesnt work with windows xp.


__________________

Nick 

Nick Craggs FMAAT ACA  AAT Distance Learning Manager

@nickcraggs 

BKN Tutor of the Year 2013 & 2015


footer_logo.png



Expert

Status: Offline
Posts: 2085
Date:
Permalink Closed

I have started using SugarSync. It's pretty much the same idea. It comes with it's own wee program that uploads files when they change, and can sync files between two or more computers. FREE for a few GB's too.

What I have done is create a client container on my computer using TrueCrypt, then upload the container. That was even if someone were to access my files, all they'd get is an encrypted container.

Kris

__________________

BKN Most Innovative Accountancy Firm 2012

Director and Co-Founder of The Bookkeepers Alliance

 

Page 1 of 1  sorted by
Quick Reply

Please log in to post quick replies.

Tweet this page Post to Digg Post to Del.icio.us
Members Login
Username 
 
Password 
    Remember Me  
©2007-2024 The Book-keepers Forum (BKF). All Rights Reserved. The Book-keepers Forum (BKF) is a trading division of Bookcert Ltd. Registered in England Company Number 05782923. 2 Laurel House, 1 Station Rd, Worle, Weston-super-Mare, North Somerset, BS22 6AR, United Kingdom. The Book-keepers Forum and BKF are trademarks of Bookcert Ltd. This forum is a discussion forum only. There will usually be more than one opinion to any question and any posting should not be viewed as a definitive solution. No responsibility for loss occasioned to any person acting or refraining from action as a result of any posting on this site is accepted by the contributors or The Book-keepers Forum. In all cases, appropriate professional advice should be sought before making a decision. We reserve the right to remove any postings which are offensive, libellous, self-promoting or engaged in covert marketing. We will not notify users of removals. The views expressed in the forum posts are those of the individual and do not necessary reflect or agree with those of The Book-keepers Forum. Any offensive or unsuitable posts will be removed by the moderators. Any reader of this forum can request for a post to be looked into by sending an email to: bookcertltd@gmail.com.

Privacy & Cookie Policy  About