Is Offline Files the best option?

  • Thread starter Thread starter Ed from AZ
  • Start date Start date
E

Ed from AZ

Management has decided we need to keep all our files on the server.
Not a problem - except when the server is "unavailable" and we can't
do anything!

Is "Offline Files" the best option for making Word and Excel files
available for editing when the server goes out so they can be updated
when it comes back? What happens to the stability of the file if more
than one user makes edits to the copy on their machine?

Ed
 
What you need is a Software Configuration Management (SCM)
or a Version Control application to keep your revisions under control
so an older version of your file doesn't slip back into use.
http://www.google.com/search?hl=en&q=Software+Configuration+Management+applications&btnG=Search

CM Crossroads
http://www.cmcrossroads.com/

I've used Serena Dimensions, CVS and others.
Dimensions is a high cost solution and most likely overkill
for your needs. CVS and others may be more to your
liking:

Googled:
http://www.google.com/search?hl=en&q=version+control+software&aq=10&oq=version

JS
http://www.pagestart.com
 
Thanks for the reply, JS. Unfortunately, I must apologize for not
including one important detail: we will not be allowed under any
circumstances to install any new software, even freeware. Do we have
any "best options"?

Ed
 
1) Management has decided we need to keep all our files on the server.
Not a problem - except when the server is "unavailable" and we can't
do anything!

a) How often is the server down?
b) Is it down for maintenance or because a failure?
c) How long is typically down for, minutes, hours, all day?

2) Is "Offline Files" the best option for making Word and Excel files
available for editing when the server goes out so they can be updated
when it comes back? What happens to the stability of the file if more
than one user makes edits to the copy on their machine?

a) Is it common for more than one user to be making changes at the same
time?
b) If it is a common practice to do so, haven't you had problems with
inconsistencies.
c) If more than one use makes changes to the file
(assuming they both started out with the same/identical file when they
started)
then yes you are going to have more than variation of the files and keeping
track of who has what and where any copies of those files where sent to.
d) When the server does come back online someone has to figure how to
"merge" what was added to you have one file that contains all the changes.

As far as the SCM/Version management software I mentioned, this would reside
on the server and it would allow for multiple copies to be worked on and
then "merged" once the server comes back on line.

JS
http://www.pagestart.com



Thanks for the reply, JS. Unfortunately, I must apologize for not
including one important detail: we will not be allowed under any
circumstances to install any new software, even freeware. Do we have
any "best options"?

Ed
 
Hi, JS. I appreciate your help. I answered in-line below.

1) Management has decided we need to keep all our files on the server.
Not a problem - except when the server is "unavailable" and we can't
do anything!

a) How often is the server down?
Honestly, not all that often. But when it goes, it takes almost all
of our working files.
b) Is it down for maintenance or because a failure? Failure.
c) How long is typically down for, minutes, hours, all day? This time was 2 1/2 days.

2) Is "Offline Files" the best option for making Word and Excel files
available for editing when the server goes out so they can be updated
when it comes back?  What happens to the stability of the file if more
than one user makes edits to the copy on their machine?

a) Is it common for more than one user to be making changes at the same
time?
Some of the files are Excel spreadsheets we use to track the progress
of an item. If several people are on the same item, it's not
unthinkable that two people would both want to indicate their progress
on a local copy of an offline file. It seemed like an issue that
needed to be brought up in case there would be problems, or to find
out there would likely be no problems.
b) If it is a common practice to do so, haven't you had problems with
inconsistencies.
No, because it's the same file, and Excel simply says the file is open
by another user and is locked for editing.
c) If more than one use makes changes to the file
(assuming they both started out with the same/identical file when they
started)
then yes you are going to have more than variation of the files and keeping
track of who has what and where any copies of those files where sent to.
And that's what I needed to know to factor into this whole mess.
d) When the server does come back online someone has to figure how to
"merge" what was added to you have one file that contains all the changes..
If three different users, not located in the same building, change the
same file without knowing the other has made any changes, will there
be some sort of message to one or all three that the file has multiple
versions trying to update and synchronize? Would that depend on who
got back onto the server first to synchronize?
As far as the SCM/Version management software I mentioned, this would reside
on the server and it would allow for multiple copies to be worked on and
then "merged" once the server comes back on line.

Sorry - no new software allowed here, either on the servers or the
local machines. Coroporate rules, and local people can not get around
them even for good ideas!

Ed
 
So for 2 1/2 days some of your office work ground to a halt.
I hope this was not time critical information as time is money in the
business world.
You should at least have a fall back server (second server).

Version management (VM) software would take care of identifying each update
to a file
when it is sent back (checked in) to the server.

Each VM software has it's own capabilities, some have the ability to send
email, other VM products will show the current status (who's using the
file), some VM packages have that and a lot more.

Don't know what it is about your IT department, they seem to be unresponsive
to your needs, could be a funding ($$$) issue or could be a poor attitude on
their part.

Now is that time of the year when planning for capital expenditures for the
next year are identified (wish list) and funds are either approved or
denied. Make your need known to management, identify the loss in
productivity in $$$ and any side effects as management thinks in term of
money coming into the business and money flowing out the door. In short you
need to come up with a good plan, identify to management their ROI (Return
On Investment) and the repercussions you and they face every time the server
goes down.

JS
http://www.pagestart.com



Hi, JS. I appreciate your help. I answered in-line below.

1) Management has decided we need to keep all our files on the server.
Not a problem - except when the server is "unavailable" and we can't
do anything!

a) How often is the server down?
Honestly, not all that often. But when it goes, it takes almost all
of our working files.
b) Is it down for maintenance or because a failure? Failure.
c) How long is typically down for, minutes, hours, all day? This time was 2 1/2 days.

2) Is "Offline Files" the best option for making Word and Excel files
available for editing when the server goes out so they can be updated
when it comes back? What happens to the stability of the file if more
than one user makes edits to the copy on their machine?

a) Is it common for more than one user to be making changes at the same
time?
Some of the files are Excel spreadsheets we use to track the progress
of an item. If several people are on the same item, it's not
unthinkable that two people would both want to indicate their progress
on a local copy of an offline file. It seemed like an issue that
needed to be brought up in case there would be problems, or to find
out there would likely be no problems.
b) If it is a common practice to do so, haven't you had problems with
inconsistencies.
No, because it's the same file, and Excel simply says the file is open
by another user and is locked for editing.
c) If more than one use makes changes to the file
(assuming they both started out with the same/identical file when they
started)
then yes you are going to have more than variation of the files and
keeping
track of who has what and where any copies of those files where sent to.
And that's what I needed to know to factor into this whole mess.
d) When the server does come back online someone has to figure how to
"merge" what was added to you have one file that contains all the changes.
If three different users, not located in the same building, change the
same file without knowing the other has made any changes, will there
be some sort of message to one or all three that the file has multiple
versions trying to update and synchronize? Would that depend on who
got back onto the server first to synchronize?
As far as the SCM/Version management software I mentioned, this would
reside
on the server and it would allow for multiple copies to be worked on and
then "merged" once the server comes back on line.

Sorry - no new software allowed here, either on the servers or the
local machines. Coroporate rules, and local people can not get around
them even for good ideas!

Ed
 
Thanks again, JS. It looks like maybe Offline Files is all we can do
for now, and work through any potential conflicts. It's possible I
may be able to run this up the chain far enough to get someone with
more power that I to push it. Then again, we may just be stuck. It's
not IT - it's people far above and pretty detached from everything
down here making decisions that we and IT have to work around. And
these people may not be able to be reached by even the biggest voice I
can find here locally.

Oh, well . . . on with the show!!

Cheers!
Ed
 
Here is some info worth looking at:

When you use the Compare and Merge feature to
compare any two documents, Microsoft Word shows the
differences between.
See: http://office.microsoft.com/en-us/word/HP030822041033.aspx

How to compare and merge Microsoft Word documents:
http://support.microsoft.com/kb/306484

How to use Microsoft Query to merge two Microsoft Excel 2000 files:
http://support.microsoft.com/kb/211802

JS
http://www.pagestart.com


Thanks again, JS. It looks like maybe Offline Files is all we can do
for now, and work through any potential conflicts. It's possible I
may be able to run this up the chain far enough to get someone with
more power that I to push it. Then again, we may just be stuck. It's
not IT - it's people far above and pretty detached from everything
down here making decisions that we and IT have to work around. And
these people may not be able to be reached by even the biggest voice I
can find here locally.

Oh, well . . . on with the show!!

Cheers!
Ed
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top