Document storage

**diami03** · 2006-03-29, 09:36 PM

I have 2 basic questions....
When a document is uploaded...where is the document itself stored? In other words, can uploaded documents be found by browsing Windows Explorer and going to a specific folder that SugarCRM stores uploaded documents?

If uploaded documents are stored in a central location on the server....can the LOCATION of the document storage be changed? i.e. external device or another hard drive partition.

Thank you.

longreach · 2006-03-29, 09:40 PM

Documents are stored in /cache/upload - off the installation root.

**diami03** · 2006-03-29, 09:47 PM

Thanks for the quick reply. I guess the question now is...can CRM be configured to upload documents to another location?

longreach · 2006-03-29, 10:21 PM

Cywolf tells me:

I think the path is in config.php, but that same path also needs to be accessible via the web so people can download the documents.

**diami03** · 2006-03-30, 03:11 PM

Has anyone tried this?

If I change the path in the config file then the web should point to the same path to retrieve documents as well as save them there, no?

**Markku** · 2006-03-30, 07:00 PM

You can change the default upload dir to point new folder by changing config.php upload_dir value (example):

'upload_dir' => 'documents/'

New documents will go to /documents folder. Existing documents should be copied to this new location so that users can still download them.

All the new modules that you might want to install will use the same directory as well (module's zip will be uploaded to /documents folder and extracted into subfolders). This is the case with the default settings as well.

**eupaccrm** · 2009-10-02, 11:10 AM

Hi there,

This reply is very useful to me too!

However, I'm wondering if it's possible to download and open the files directly from /cache/upload outside of SugarCRM???
When I try to open them in Word or PDF, it doesn't work.

It would give us peace of mind, in case the Sugar installation messes up.

**goko** · 2009-10-02, 01:04 PM

Originally Posted by eupaccrm

Hi there,

This reply is very useful to me too!

However, I'm wondering if it's possible to download and open the files directly from /cache/upload outside of SugarCRM???
When I try to open them in Word or PDF, it doesn't work.

It would give us peace of mind, in case the Sugar installation messes up.

Yes, it is possible but since they just have uuid-names without extension (like "1adc07f6-ba02-e169-b461-493d168c3efb"), you cant see from the name of the file what kind of file it is (.pdf, .doc, .jpg etc).
Thus you will not know which program to open it with, but you can try open it with any program, when you open the file with the correct program the document/image or whatever it is will look "normal".

I guess Sugar may store the uuid-name of the file in a table somewhere along with info on what type of document it is.

A handy tool to preview the contents of files can be found in xplorer2 (which is a Windows Explorer replacement). If you turn on View->Quick Viewer in xplorer2 it will show the beginning of the file as plain characters or bytes. If you see "PDF" in the beginning it is a pdf. If you see JFIF it is an image (jpg or bmp i believe)

**bobcat1977** · 2009-10-05, 02:50 PM

Originally Posted by diami03

In other words, can uploaded documents be found by browsing Windows Explorer and going to a specific folder that SugarCRM stores uploaded documents?

hopefully you have found this out by now, but the short answer is "yes", you can do this. LongReach was right... the path is config.php. useful for YOU to browse and see the docs (given you know which ones correspond to the coded folder names), but not so useful for your web users.