I'm in the process of doing that now, all web based, reading Access and SQL
databases, and hope to have it changing content per office in the not too
distant future.
The data access part is surprisingly easy, IMO. I use PHP, but I've done it
with VBScript, as well. Either work fine. VBScript is kind of neat in that
you can write code in Acad's VBA IDE (Intellisense doing some of the work),
then the port to VBScript is generally painless.
I don't have the office specific stuff ironed out yet, but I have a few
ideas (session variables, etc. with PHP) that should make it fairly easy to
implement.
If you have an SQL server, go that route, now with your data. We have a few
things requiring me to use Access files, which I'm dreading. The updates
will a pain and some folks are going to grumble, because to keep peace in
the entire system, we're going to have to limit who has access to makind
modifications.
Feel free to email directly if you'd care to see samples, etc. I'm a huge
fan of the whole intranet/content from DB scenario. It takes a little
planning and learning the scripting part (not hard), but it's worth the
effort. If possible, maybe find a web 'hobbyist' who actually enjoys it and
wouldn't mind taking on a little extra responsibility if you don't want to
mess with it yourself.
"R.K. McSwain" wrote in message
news:5246662@discussion.autodesk.com...
A company has multiple offices, each with their own CAD standards
manual, arranged using a common outline. Approximately 75% of the
content of this outline is the same for each office. For the other 25%,
each office has their own standards (Please no lectures on how each
office should be the same..... been there, done that....)
Does anyone have any experience with methods to publish this data so that:
A) It's available on a web page (on the company's Intranet)
B) The entire manual (on a per office basis) can be printed if necessary
C) There is no duplication of data. If a change is made to a section
that applies to all offices, that change is done once, in one place.
D) There is an ability to filter differences per office. For example: If
an employee from Cincinnati is temporarily working in Indianapolis, he
can look at ONLY the differences in CAD standards for Indy as compared
to Cincy.
I'm thinking of some sort of application that would keep topics in a
database, then when a particular office's manual needs viewed, a query
is run on the DB, pulling up all the applicable topics.
Any experience with something like this?
TIA
--
R.K. McSwain
http://rkmcswain.blogspot.com