[AccessD] Case management and external files

Jim Dettman jimdettman at verizon.net
Mon Apr 9 19:27:24 CDT 2007


Martin,

  Thanks for that.  I have been starting to explore Share Point as one of
the recommendations I'll be making is for them to purchase SBS 2003 and
Office.  My problem is I can't really find anything in all the fluff that
Microsoft has about what it actually does or how it does it.  I probably
should install it and play with it (I have a MSDN Universal subscription) or
buy a book.

  This setup will have medical records coming in via e-mail and fax.  Most
are .tiff or PDF format. I'd really like a setup where I strip off the
attachment, tag and save them. Some type of notification to the user will
also be required (I was thinking it would be just the e-mail or fax itself
sans the attachments).

 I'm also going to need outbound capability, but I don't think that's going
to be as problematic.

Jim.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Martin Reid
Sent: Monday, April 09, 2007 4:45 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Case management and external files

Jim
 
I just set up a case management system for the University Counselling Office
in the SharePoint.
 
Email and attachments directly to  sharepoint email enabled lists. eg
CounsolListName at qub.ac.uk and you can send docs directly into the sharepoint
list. The user gets an automatic alert via Outlook that the doc is
available.
 
Almost no programming involved. Tight integration with our Active Directory.
May not be suitable for you but worked out well so far for us.
 
We use lists to split the cases up to individual staff,
 
All access is strictly internal only which saved a lot of work.

If they need to take the stuff of line we can always use A 2007 which works
well for us as well. 
 
Its mainly all in test mode at the moment but we will be moving almost
everything to MOSS 2007 over the next year or so.
 
Martin
 
 
 
Martin WP Reid
Training and Assessment Unit
Riddle Hall
Belfast
 
tel: 02890 974477
 

________________________________

From: accessd-bounces at databaseadvisors.com on behalf of Jim Dettman
Sent: Mon 09/04/2007 20:54
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Case management and external files



Greetings All,

  Question: anyone done work with case management and external files (i.e
medical records, faxes, Word Docs, etc)?  I know it's always best to leave
them external, but beyond that:

a. Any best practices you've found for linking them to a given case - i.e.
do you tag them or place them in a per claim specific directory?

b. How do you handle inbound faxes?  Any recommendations on software?

c. What about e-mails with attachments?  Manual operation to cut/save the
attachment or something more automatic?

  Any insights would be helpful.

Thanks,
Jim
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com <http://www.databaseadvisors.com/> 






More information about the AccessD mailing list