SID-00410: Link spreadsheet to an updating Wiki Schedule

Status:	Answered	TWiki version:	4.3.1	Perl version:	perl 5 (dont know teleworking)
Category:	CategoryAutomation	Server OS:	RedHat 5	Last update:	16 years ago

I looked pretty hard, and could not find the answer to this question. We want to have a some sort of schedule that is generated from a spreadsheet. The spreadsheet should ideally be a xls, but can be a csv or any other sort of document that can be saved from Excel, such as rich text etc. (Our company has only approved Excel as a spreadsheet program). This schedule can be in any format, table, calendar, or even a text box. The difficult part is that we want to be able to save this spreadsheet to a network drive, and have the wiki update the schedule from this file on the common drive. We do not want to have to attach the file to wiki each time we update it. This would be a separate set of actions that someone might forget to do. The idea is that we only want this document in one place on our network drive, and one version of it. Is there any combination of plugins, wiki code or any other tools that could make this happen using Twiki software?

-- DanielBeaulieu - 2009-07-10

Discussion and Answer

Enable {AutoAttachPubFiles} in configure script. Create a topic to publish your excel file. Attach something to it to make the folders to be created. Then copying the excel file to folder ...twiki/pub/YourWeb/YourTopic. It should be shown as attached on YourTopic topic in YourWeb web. That copy can be automated so nobody has to do it manually.

-- EnriqueCadalso - 2009-07-10

Look also into UpdateAttachmentsPlugin, RemoteFileAttachPlugin, UploadToTWikiAddOn, ExcelImportExportPlugin.

-- PeterThoeny - 2009-07-10

Thank you very much for your help. This is exactly what I was looking for.

-- DanielBeaulieu - 2009-07-13

-- DanielBeaulieu - 2009-07-13

If you answer a question - or someone answered one of your questions - please remember to edit the page and set the status to answered. The status selector is below the edit box.