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 ?
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.
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.
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.
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.
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.
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.
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"
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.
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 me), 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.
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.
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.
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.
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
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.