Help

alphawolf · September 26th, 2006, 10:20 PM

I have a Spreadsheet that I have posted on my site and I would like to have my conterpart be able to update it and I be able to see the changes and when I update it he be able to see the changes how do I go about doing that.

**pizzicar** · September 26th, 2006, 11:50 PM

I am assuming that you are using a Linux based server and not a windows server. I am not aware of a linux program that will allow version tracking and management of shared spreadsheets (but that does not mean one does not exist).

I am also assuming that you mean an excel file that is residing in a directory on your server and not somehow displayed as part of your web page.

One suggestion is to come up with a versioning naming scheme such as name the file with a date/hour name naming format (such as 9_26_06_09_JP) which shows that I (JP) edited the file on September 26th at 9:00. That way you know when and who updated the file last. If the person has FTP or root access then this should work. You or your counterpart would ftp the file down to your pc to work on it then upload the changed file with the new name. You might also rename the file on the server while working on it so you don't both have the file at the same time (such as JP_working) so you know I have the file.

If you are looking for a program to do this for you, perhaps someone else knows of one.

Good luck and let us know more info if this is not what you are looking for.

alphawolf · September 28th, 2006, 12:16 AM

Well I uploaded the excel spreadsheet to my website so is that my problem. See once you change it and go to close out it ask you where do you want to save a copy of the file. but it does not change it on the website for when you go back to look at it.

**pizzicar** · September 28th, 2006, 2:15 AM

I don't think you can save directly unless you are running a windows based server (I would be happy to be in error

) I think you are going to have to use an FTP program to get the file to modify then ftp the saved file back to the server. Some FTP programs let you create custom commands to automate a lot of file movement and naming. If you use a naming scheme like I mentioned, you won't have the problem of both of you updating the file at the same time.

Perhaps someone else can come up with a better idea.

September 26th, 2006, 10:20 PM	#1 (permalink)
alphawolf Registered User Fresh Surpasser Joined in Feb 2006 7 posts Gave thanks: 0 Thanked 0 times	Help I have a Spreadsheet that I have posted on my site and I would like to have my conterpart be able to update it and I be able to see the changes and when I update it he be able to see the changes how do I go about doing that.

September 26th, 2006, 11:50 PM	#2 (permalink)
pizzicar Surpass Fan On a golden path... Joined in Feb 2006 Lives in Arizona 344 posts Gave thanks: 3 Thanked 16 times	I am assuming that you are using a Linux based server and not a windows server. I am not aware of a linux program that will allow version tracking and management of shared spreadsheets (but that does not mean one does not exist). I am also assuming that you mean an excel file that is residing in a directory on your server and not somehow displayed as part of your web page. One suggestion is to come up with a versioning naming scheme such as name the file with a date/hour name naming format (such as 9_26_06_09_JP) which shows that I (JP) edited the file on September 26th at 9:00. That way you know when and who updated the file last. If the person has FTP or root access then this should work. You or your counterpart would ftp the file down to your pc to work on it then upload the changed file with the new name. You might also rename the file on the server while working on it so you don't both have the file at the same time (such as JP_working) so you know I have the file. If you are looking for a program to do this for you, perhaps someone else knows of one. Good luck and let us know more info if this is not what you are looking for. __________________ "Argue for your limitations, and sure enough, they are yours"

September 28th, 2006, 2:15 AM	#4 (permalink)
pizzicar Surpass Fan On a golden path... Joined in Feb 2006 Lives in Arizona 344 posts Gave thanks: 3 Thanked 16 times	I don't think you can save directly unless you are running a windows based server (I would be happy to be in error ) I think you are going to have to use an FTP program to get the file to modify then ftp the saved file back to the server. Some FTP programs let you create custom commands to automate a lot of file movement and naming. If you use a naming scheme like I mentioned, you won't have the problem of both of you updating the file at the same time. Perhaps someone else can come up with a better idea. __________________ "Argue for your limitations, and sure enough, they are yours"

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Rate This Thread
Rate This Thread:

September 28th, 2006, 12:16 AM	#3 (permalink)
alphawolf Registered User Fresh Surpasser Joined in Feb 2006 7 posts Gave thanks: 0 Thanked 0 times	Well I uploaded the excel spreadsheet to my website so is that my problem. See once you change it and go to close out it ask you where do you want to save a copy of the file. but it does not change it on the website for when you go back to look at it.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)