What about file a being called directly? I'm guessing you're using fusebox or something like it, but I would think you'd need to compare your file list of stuff you're planning to delete against web logs for the site for the past few months to ensure that the file isn't being called directly. I don't know of any tools either, but figured I'd toss that suggestion in there in case you try to write your own thing.
John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer -----Original Message----- From: Anthony Prato [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 31, 2005 4:10 PM To: CF-Talk Subject: Re: [SOT] Finding which files in a site aren't used anymore ooo.. very good point on the href="#approot#/path/to/file.cfm" but there are some good (relative to this issue) circumstances. Everything here is pretty simplistic in terms of server side processing. There aren't any urls in the database, (just tons of business logic) and I haven't seen any places where dynamic URLs are constructed. There are however many iFrames and frames where javacript functions load content into new windows or iframes. There are also a lot of ASP include files. Heck at this point I'd even settle for something that does all the greping for me. On 8/31/05, S. Isaac Dealey <[EMAIL PROTECTED]> wrote: > > I'm back to a problem that I run into a lot. I started working at a > > place that does not do a good job of cleaning up files in a websites > > directory. (as well as tons of unused stored procedures and views) > > I've found plenty of tools to track down database objects, even some > > that check your files for calls to the DB objects; I just can't find > > anything for cleaning up the files. I know I can get a list of all > > the files in all sub directories and grep for each, but I'm hoping > > someone can recommend me a nicer GUI utility instead. Another nice > > feature would be smarter than grep and if file A calls file B but > > nothing calls file A then they are both obsolete. Does anyone know > > of a utility like this. In the past I've used grep or similar but in > > this case there are just too many files. > > You also need to consider the possibility of template names being > stored in the database -- in "url" columns if not columns indicating > include template paths... Unfortunately I don't have any > recommendations -- I use regular expression searches in dreamweaver if > I want to check for more than one file name, but that obviously > doesn't handle the semantic user-interface you're talking about where > you want the IDE to know when it's looking for file a that file b > should be removed if only file a references it. I would think also > that for the tool to be really effective, it mind need to have some > comprehension of the syntax of the language... though even then it may > be questionable if there are variables used in paths, i.e. > href="#approot#/path/to/file.cfm". An IDE that isn't tied _directly_ > to CF and/or knows the web-root and uses an http engine to figure out > how those url's resolve won't be able to know what file is being > referenced. Which ultimately may be a good part of the reason why you > haven't found any good tools to perform this task. > > Sorry I couldn't be more helpful... > > I would recommend checking the db(s) for any columns with the terms > "URL" or "HREF" or "link" in the column name... > > s. isaac dealey 954.522.6080 > new epoch : isn't it time for a change? > > add features without fixtures with > the onTap open source framework > > http://www.fusiontap.com > http://coldfusion.sys-con.com/author/4806Dealey.htm > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217054 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

