ATTENTION: You are viewing a page formatted for mobile devices; to view the full web page, click HERE.

Main Area and Open Discussion > General Software Discussion

links of files of a web server

(1/2) > >>


I have links of files in a web server (or local) stored in an excel file

If the files are moved to another subfolder, my links in the excel file won't work, right?

what can be done for this?

I was imagining a way that the excel file will search in the web server (but what if the web server changes domain?) and find the specific file and update the link? but the file could be edited and change its content, so there must be a truly unique file identifier

what is the best approach for this?

I suppose web admins or database admins have much experience on this common issue!



The best approach would be to use a CMS for website maintenance.

Why would you want to store links in a website in an Excel file...

Why would you want to store links in a website in an Excel file...
-Ath (March 19, 2015, 04:13 AM)
--- End quote ---

because these files MUST be stored in a specific website and because these links must be included in an excel file to provide the files as evidence
it would be nice to include them inside the excel file, but it will become huge

Excel is one of the worst tools for this kind of job...and as you asked for advice from professionals, they will tell you that Excel is (one of) the worst tool for this kind of job. A Content Management System (CMS) is more suited for such a job. Most CMS's make use of a database which has no problems storing and showing links (or storing/showing files if you are so inclined).

This kind of solution is usually faster than working with Excel files containing links. And that is not the only advantage such systems have over manually managing files and links in and/or with Excel.

I am sorry if I offend, but n my opinion Excel is perceived to be a hammer by many and these many see all their problems turn into nails. This way of thinking causes unmaintainable files, vague file structures and disastrous workflows come into life.

Although you might think you have saved time/money by "nailing" your problem. It is better to get it clear in your head what you want to achieve and then look for existing solutions on the internet. You will find that in most cases there is already such a solution ready for you to use. Commercial, open source or otherwise.


[0] Message Index

[#] Next page

Go to full version