Exporting Attachments

[cs3gallery]

I happen to have a need to export all the documents that have been uploaded to sugar to a file server for reasons specific to my company.

Anyways.. we found out that sugar keeps attachments in /cache/uploads and all the files have unique id's. When adding the proper extension to the end of them such as .pdf and we open it it gives errors etc.

However we can still download it in sugar and read it just fine. So does sugar do something to the file or something?

Does anyone have a good idea on exporting the files? Thanks.

Josh

[sts]

Sugar only renames the files to the id under which it is saved (document_revisions.id). In database table 'document_revisions' you'll find the mapping between old and new filename.