Home | Forums | Contact | Search | Syndication  
 
 [login] [create account]   Tuesday, November 26, 2024 
 
slxdeveloper.com Community Forums  
   
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!
 Architect Forums - SalesLogix Scripting & Customization
Forum to discuss writing script in Architect plugins for SalesLogix & general SalesLogix customization topics (for Windows client only). View the code of conduct for posting guidelines.
Forums RSS Feed


 Back to Forum List | Back to SalesLogix Scripting & Customization | New ThreadView:  Search:  
 Author  Thread: Error while opening an existing Attachment
Raju
Posts: 18
 
Error while opening an existing AttachmentYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 01 Aug 06 6:46 PM
fiogf49gjkf0d
Hi

Can anyone please tell what are the rules that need to be followed for Attachments. I am not able to open an attachment stored in the server in C:\Documents folder, from the Tickets Attachment tab. Getting an error message "Windows cannot find document". I tried sharing the folder that has the attachment and still get the error.

Thanks
Raju.R
[Reply][Quote]
mahaveer
Posts: 3
 
Re: Error while opening an existing AttachmentYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 02 Aug 06 2:28 AM
fiogf49gjkf0d
Hi,
Raju just give the path like \\server name\sharedfolder
not c:\... because it finds the local path.

it will work.

[Reply][Quote]
John Gundrum
Posts: 632
Top 10 forum poster: 632 posts
 
Re: Error while opening an existing AttachmentYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 02 Aug 06 9:07 AM
fiogf49gjkf0d
Attachments are normally stored in the Documents folder of the SyncLogs directory. When you add an attachment to a contact, account, opportunity or ticket, that attachment is copied to the SyncLogs\Documents directory.

If you had the Attachment Path setup as C:\Documents in the Administrator, all of the attachments users have been attaching will be stored on their local drive - not on the server. This is because the local computer is using the path 'C:\Documents' as defined in Administrator. So the local computer only knows to go to its local C: drive to look for the Documents directory. The SLX client is smart in one sense. If it cannot find the directory to store the attachment, it will store it locally in a predefined path that the client software setup.

This would explain why you are getting a 'cannot find document' message when attempting to open a Ticket attachment from a computer other than the computer that created the attachment.

If this is truely the issue, to fix it will take a little time and effort and documentation. First you will need to change the C:\Documents setting in Administrator to be the UNC path (\\servername\sharedname\path). Next, compile a list of ALL the computers where the SLX client is installed. Just a user list will not work because the client could be installed on more PCs than users.

Once that is done you will need to move all of the attachments that were being saved to local computers to the Documents directory on the server. If I am remembering correctly, the location of the attachments on the local computer is going to be

C:\Documents and Settings\All Users\Application Data\SalesLogix\Sync\Documents

Basically what you want to do is move everything from the local computer Documents directory to the Documents directory on the server. This will have to be done for each and every SLX client PC. If this has been like this for a while there is a possibility attachments will be lost if a computer was reformatted or disposed of.

Also make sure the SyncLogs directory on the server is shared to everyone with Read/Write/Delete rights.

John G.
[Reply][Quote]
Raju
Posts: 18
 
Re: Error while opening an existing AttachmentYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 02 Aug 06 12:12 PM
fiogf49gjkf0d
Mahaveer & John

Thanks to both of you for the information. Modified the attachment path and got the issue resolved. Appreciate your help.

Raju.R
[Reply][Quote]
John Gundrum
Posts: 632
Top 10 forum poster: 632 posts
 
Re: Error while opening an existing AttachmentYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 02 Aug 06 12:26 PM
fiogf49gjkf0d
Oh, once you have the pathing fixed you might want to run the Intergrity Checker in Administrator found under Tools. You will only want to run the 'Attachment file validation. (Delete)' test. This will check for the existence of each file listed in the attachments table.

Run only the 'List Number' test initially. This will tell you how many files are in the database where the file is missing. This will tell you that there are still clients out there that have attachments stored locally. These will need to be moved to the server via my previous post. You'll know when you are done when this number returns 0 or you know you've moved all files from all PCs. You can run the test using the 'List Actual' which will tell you the exact filename you are missing. This might give you a clue as to where the attachment is located. If there are only a few attachments missing and you just don't know where they are or are sure they no longer exist, you can run the test using the 'Fix' button. This will DELETE the references to the attachments it can't find from the database table.

Good luck!
John G.
[Reply][Quote]
 Page 1 of 1 
  You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

   Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
 

 
 slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation.
 This site, and all contents herein, are Copyright © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.

code of conduct | Subscribe to the slxdeveloper.com Latest Article RSS feed
   
 
page cache (param): 11/26/2024 8:35:52 AM