by eggsurplus

Control what your users can access and save time, money, and frustrations. Lock down sensitive data in SugarCRM or SuiteCRM to specific groups or teams. Supports unlimited assigned users, unlimited group assignments to records, custom layouts for each group, login/sudo capabilities and much more.

Free 30 day trial
Try it Now

#79 - email attachments does not show

Open Bug? created by Noam 6 years ago

Thank you for this great addon module.

I installed the module on sugar version 6.5.9 and seems like it works as expected except from one issue.
We use the inbound mail to open cases in the system (support helpdesk) and when an email contains an attachment (PDF, Image, Office Doc etc) , only admin user can view that attachment, regular users cannot see it at all although they can view the case and the mail.

Can you please check and see if this is a bug or just a missed configuration directive on our installation?

Thank you!

Noam

(Upgrading to newer Sugar version is not an option at the moment)

  1. eggsurplus member avatar

    eggsurplus Provider Affiliate

    6 years ago

    Very interesting. I will try to recreate the issue. However, I don't recall attachments having separate permissions applied to them.

  2. Noam member avatar

    Noam

    6 years ago

    Hi,

    Thanks for the reply. Any good news about this issue? I tried various solutions but nothing worked for me.

    Noam

    • eggsurplus member avatar

      eggsurplus Provider Affiliate

      6 years ago

      Curious, what are the permissions set to for the Emails module for the non-admin users that are having issues?

  3. eggsurplus member avatar

    eggsurplus Provider Affiliate

    6 years ago

    So the group is inheriting to the email that gets created, but not to the note that gets created and associated to the email. It looks like the note is where the attachment is being stored. I'm not sure on the best long term solution yet. Do you happen to be able to code? If so, temporarily I'd suggest creating an after_relationship_add hook that checks for when a note gets added to an email. When it does then add all groups from the email to the note.

  4. Noam member avatar

    Noam

    6 years ago

    Hi

    Thank you once again for checking this issue. I do php coding for many years but am not so familiar with the SugarCRM system so solving it as you suggested is not a straight forward for me.
    However, i tried to deal with it on the MySQL level (tried to add the permissions directly via the DB) but could not find how to do that since i can't find what values i need to modify in which tables.

    Do you think that such solution is possible? Can you guide me please and point me to the tables and fields that need to be modified? I can then run it through cron and make the changes once a new case is opened.

    Noam

    • eggsurplus member avatar

      eggsurplus Provider Affiliate

      6 years ago

      Here is the key table for linking a record to a group. For linking a note to a group replace the variables:
      insert into securitygroups_records(id,securitygroup_id,record_id,module,date_modified,deleted)
      select uuid(),securitygroups.id,notes.id,'Notes',now(),0
      from securitygroups, notes
      where securityroups.id = '{SECURITYGROUP_ID}' and notes.id = '{NOTE_ID}';

      Time is really tight the next 3 weeks. After SugarCon is over I'll work on a full solution for this.

  5. suhas member avatar

    suhas

    5 years ago

    Hi,I'm using sugarCE 6.5 I am having issue in email module, When I compose mail and try to attach some document from local system its uploading on server, but not showing in attachment. Its working fine on my local system. I think sugar is not creting record in notes. If problem is beacuse of permissions I have also given all read right permissons .

    • eggsurplus member avatar

      eggsurplus Provider Affiliate

      5 years ago

      That sounds like a completely different issue than what this support case is for. However, if it is working locally and not in production then it is almost always due to file permissions. For more general SugarCRM issues your best bet for help is to check out the community forums at: https://community.sugarcrm.com/sugarcrm

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
Rating
Rating
  • "I can say that it has been one of the best modules within our SugarCRM CE instance!"

    Read More Reviews

Keep up to date on the latest additions

We'll send you an email every month with handpicked add-ons, reviews, tricks and tips. Don't worry, we hate spam as much as you do.