The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
|
|
Changing Attachments Drive
Posted: 20 Mar 08 4:43 AM
|
Hi guys
First of all I know I'm probably asking this in the wrong section, but I'm not sure which section to post this in.
The harddrive that the attachments are being saved to is getting full and what I'd like to do if possible is change the path that attachments save to, to a seperate drive. I'd like that existing attachments stay on the original drive though if possible. Is it possible? 
If anyone could point me to the correct section to ask this in, or an administrator move the thread then that would be great. I've tried to search for the answer to this but havent been able to find anything thus far.
Thanks for any help in advance.
Lee |
|
|
|
Re: Changing Attachments Drive
Posted: 20 Mar 08 7:01 AM
|
Attachments are in a share.. not a "drive".. so all you need to do is:
A - shutdown all access to the main SalesLogix db
B - Find another location for the attachments
C - Create a new share name and allow everyone full control
D - Copy over everything to the new share
E - Change the path using the Admin tool (systems.. Offices)
F - Allow access again..
--
RJLedger - rjlSystems |
|
|
|
Re: Changing Attachments Drive
Posted: 20 Mar 08 8:05 AM
|
Ahhhhh excellent its alot easier than I thought.
In regards to point D, does this mean that all attachments must be contained within the same folder and can't be split between 2 on 2 seperate harddrives?
Thankyou for your quick response. |
|
|
|
Re: Changing Attachments Drive
Posted: 20 Mar 08 12:11 PM
|
Short answer is yes, you can not split the attachments among several drives. They have to reside within 1 share.
Ted |
|
|
|
Re: Changing Attachments Drive
Posted: 21 Mar 08 9:21 AM
|
I've run into this problem more than once and have become frustrated by the single share limitation. I’ve yet to find an elegant solution for this. I've heard that you may be able to configure mutliple drives to appear as one share but I'm unsure of how to accomplish this.
One “solution” is to manage documents outside of SLX but still maintain a link in SLX. You can accomplish this by using some simple Shell commands. To extend this functionality further, you could write a SQL trigger on the Attachments table to copy over attachments coming in through Outlook (SendSLX, etc.) to the windows folder.
By the way, with the below code, you would need to incorporate more error handling than what is present.
...
Sub cmdBrowseClick(Sender)
Dim objShell
Set objShell = CreateObject("Shell.Application")
Dim objFolder
Set objFolder = objShell.BrowseForFolder(0, "Select a folder...", 0)
If Not Objfolder Is Nothing Then
txtSharePath.Text = objFolder.Self.Path
End If
Set objShell = Nothing
End Sub
Sub cmdLaunchFolderClick(Sender)
Dim objShell
Set objShell = CreateObject("WScript.Shell")
objShell.Run("explorer.exe /e, " & txtSharePath.Text) '/e opens windows explorer according to user preferences (e.g. view history is open)
Set objShell = Nothing
End Sub |
|
|
|
Re: Changing Attachments Drive
Posted: 22 Mar 08 8:26 PM
|
Originally posted by Chris Burriss
I've run into this problem more than once and have become frustrated by the single share limitation. I’ve yet to find an elegant solution for this. I've heard that you may be able to configure mutliple drives to appear as one share but I'm unsure of how to accomplish this.....
|
|
It's called "JBOD".. Just a Bunch Of Disks...
Most SATA controllers support this in hardware as a "RAID" option.. and in Windows you can have "dynamic" expandable drives.. but I really don't like that approach...too much stress on the system/os. The drive controller way is the best.
--
RJLedger - rjlSystems |
|
|
|
Re: Changing Attachments Drive
Posted: 22 Mar 08 10:47 PM
|
| Actually there *is* DFS or distributed file system (http://en.wikipedia.org/wiki/Distributed_File_System_(Microsoft)). The summary is it's a way to logically group shares across multiple file servers into a hierarchy. SalesLogix should be able to operate just fine as everything takes place transparently at the OS level. |
|
|
|
Re: Changing Attachments Drive
Posted: 22 Mar 08 11:27 PM
|
...(sorry for hijacking the thread)
Hey Jeremy. Long time no see. Glad to see you're still out there!
-Ryan |
|
|
|
Re: Changing Attachments Drive
Posted: 23 Mar 08 2:05 PM
|
Originally posted by Jeremy Brayton
Actually there *is* DFS or distributed file system (http://en.wikipedia.org/wiki/Distributed_File_System_(Microsoft)). The summary is it's a way to logically group shares across multiple file servers into a hierarchy. SalesLogix should be able to operate just fine as everything takes place transparently at the OS level. |
|
I tried DFS a few years ago.. was impressed.. but I've not seen IT departments get excited over it.. too bad..
--
RJLedger - rjlSystems |
|
|
|