Reply to topic  [ 9 posts ] 
Coding Language and/or Software Package for office document 
Author Message
Doesn't have much of a life
User avatar

Joined: Thu Apr 23, 2009 6:28 pm
Posts: 851
Location: EC1 Baby!
Reply with quote
Please bear with me; I may have a hard time trying to explain myself fully...

Essentially, at work we are currently in the process of applying for ISO 9001 accreditation - (which if you don't know, is a stamp of quality assurance that some major architectural projects require of their consultants/consortia) - to achieve this we have had to tweak and refine (principally) our office protocol documents & file management - all of which now needs to be rigorously registered and controlled in manner to allow more efficient auditing.

Presently I am only involved at a level of critique – being one of the outspoken few who likes to pick at proposals made by higher powers, more because I’ll have to use these systems once their in place more than anything else. My main concern with the first proposals are that they rely heavily on archaic, clumsy, manually-driven formats – ie. simple, non-queriable (sp?) Excel spreadsheets for document control and lengthy Word documents who’s only navigation “feature” are a few hyperlinks, etc.

Fortunately though, the whole premise of being an ISO 9001 company is a pledge to continually improve the systems in place – so whilst it’s too late for our first pass at the review body (at the end of this month) I’m thinking of what to propose for the future.

After the long introduction, it’s quite an ambiguous question; what would you do / use?

For starters, I’ve already looked at building an access database to replace the excel document register (to allow us to query, generate reports, print lists, batch edit, manage receipts & sends etc) and have long thought an indexed pdf would be a better alternative for the master document…

But since yesterday I’ve been thinking a web-language-driven system might offer us better control of the innumerable segments of info we have to manage…

For example, is there a language/method where if:

Company name
Company address / contact details
Associates list
Staff list

were to change; one would only need to edit one point source of info, which would then immediately filter down through every document?

What of linked-to supplementary documents (ie. our Terms & Conditions, latest news etc) – could these all be standalone, unformatted .txt files (or fields in somewhere?) that get “pulled” in, formatted and presented as finalised document? I guess that might be easy enough through HTML & CSS… but what of querying abilities (search for project by name/number etc, search for policy #xxx01sa etc) – and direct linking / integration with related documents (such as .xls / .mdb document register above) – or could even something like that be worked into a web-browser frontend with a database of some kind running?

Any pointers or advice would be greatly appreciated.


Thu Jul 16, 2009 9:03 am
Profile
Doesn't have much of a life
User avatar

Joined: Thu Apr 23, 2009 6:28 pm
Posts: 851
Location: EC1 Baby!
Reply with quote
Sharepoint's been suggested on my duplicate thread over on TA; but I've not got Silverlight at work to watch the site demo's to see if it's what we're after... but I've seen it mentioned by some of you lot before... any thoughts?


Thu Jul 16, 2009 12:30 pm
Profile
Site Admin
User avatar

Joined: Thu Apr 23, 2009 5:53 pm
Posts: 8603
Location: location, location
Reply with quote
I was going to recommend Sharepoint for the management but it wouldn't allow bulk changes (e.g. changing the address on all docs at once) on documents.
With the search server installed you can check docs easily.

Also allows check in or check out

_________________
Support X404, use our Amazon link
Get your X404 tat here
jonlumb wrote:
I've only ever done it with a chicken so far, but if required I wouldn't have any problems doing it with other animals at all.


Thu Jul 16, 2009 12:34 pm
Profile WWW
Doesn't have much of a life
User avatar

Joined: Thu Apr 23, 2009 6:28 pm
Posts: 851
Location: EC1 Baby!
Reply with quote
saspro wrote:
I was going to recommend Sharepoint for the management but it wouldn't allow bulk changes (e.g. changing the address on all docs at once) on documents.
That's not good.

The other suggestion so far has been a web-browser frontend to an SQL database.... But I've no idea what that really might mean - despite my efforts to read up on it.


Thu Jul 16, 2009 12:51 pm
Profile
Site Admin
User avatar

Joined: Fri Apr 24, 2009 6:12 am
Posts: 7011
Location: Wiltshire
Reply with quote
The only way I know of doing this, is using an EDRMS such as live link but the costs are mind boggling.

Each "document" is then made up of a series of XML sections or snippets and is only assembled when it is previewed or printed.

You'd also have to spend a significant amount of time setting your taxonomy up to ensure that it all hangs together.

_________________
<input type="pickmeup" name="coffee" value="espresso" />


Thu Jul 16, 2009 12:57 pm
Profile WWW
Site Admin
User avatar

Joined: Fri Apr 24, 2009 6:12 am
Posts: 7011
Location: Wiltshire
Reply with quote
snowyweston wrote:
saspro wrote:
I was going to recommend Sharepoint for the management but it wouldn't allow bulk changes (e.g. changing the address on all docs at once) on documents.
That's not good.

The other suggestion so far has been a web-browser frontend to an SQL database.... But I've no idea what that really might mean - despite my efforts to read up on it.


Well that is basically what sharepoint is :D

_________________
<input type="pickmeup" name="coffee" value="espresso" />


Thu Jul 16, 2009 12:57 pm
Profile WWW
Site Admin
User avatar

Joined: Thu Apr 23, 2009 5:53 pm
Posts: 8603
Location: location, location
Reply with quote
A web front end of sql or mysql would work but it's a lot more development to make.

Don't you need to keep changes for ISO9001?

You could use sharepoint, upload master word templates and use them for new docs.
Or mailmerge out of sharepoint contacts.

_________________
Support X404, use our Amazon link
Get your X404 tat here
jonlumb wrote:
I've only ever done it with a chicken so far, but if required I wouldn't have any problems doing it with other animals at all.


Thu Jul 16, 2009 12:59 pm
Profile WWW
Spends far too much time on here
User avatar

Joined: Thu Apr 23, 2009 9:40 pm
Posts: 4876
Location: Newcastle
Reply with quote
snowyweston wrote:
Sharepoint's been suggested on my duplicate thread over on TA; but I've not got Silverlight at work to watch the site demo's to see if it's what we're after... but I've seen it mentioned by some of you lot before... any thoughts?

Sharepoint is used on the Ferrari site

It sounds like a source with check in/out and some form of macro to update each doc from a set file for addresses etc

_________________
Twitter
Charlie Brooker:
Macs are glorified Fisher-Price activity centres for adults; computers for scaredy cats too nervous to learn how proper computers work; computers for people who earnestly believe in feng shui.


Sat Jul 18, 2009 2:21 am
Profile
What's a life?
User avatar

Joined: Thu Apr 23, 2009 8:25 pm
Posts: 10691
Location: Bramsche
Reply with quote
My first thought was SharePoint, followed by a professional document management system. Those will allow you to scan, store and index printed documents easily as well, but they are a fairly hefty investment for small businesses.

_________________
"Do you know what this is? Hmm? No, I can see you do not. You have that vacant look in your eyes, which says hold my head to your ear, you will hear the sea!" - Londo Molari

Executive Producer No Agenda Show 246


Sat Jul 18, 2009 8:14 am
Profile ICQ
Display posts from previous:  Sort by  
Reply to topic   [ 9 posts ] 

Who is online

Users browsing this forum: No registered users and 21 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
Jump to:  
cron
Powered by phpBB® Forum Software © phpBB Group
Designed by ST Software.