problem with generated attachment to auto-sent email

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • arturkulik
    Member
    • Apr 2025
    • 60

    #1

    problem with generated attachment to auto-sent email

    Hi guys,
    has anyone met problem with lacking data in attachments when auto-send email from report is generated?

    i have a report, with columns containing data from relation Account to Account . accountParent Many to One,

    when i generate report to xls all data is completed
    when i generate email all data is presented in html table in email body, but in attachment column is empty

    this same situaltion is when you generate 'all columns' xls from report, onlu entity data is stored and no relation data

    Tested on Espo 9.1.8 and 9.2.5
  • yuri
    EspoCRM product developer
    • Mar 2014
    • 9564

    #2
    I could not to reproduce the problem with email attachment.

    With 'all columns' I believe it's not supposed to export link columns, but only the entity fields.
    If you find EspoCRM good, we would greatly appreciate if you could give the project a star on GitHub. We believe our work truly deserves more recognition. Thanks.

    Comment

    • arturkulik
      Member
      • Apr 2025
      • 60

      #3
      Hi,
      i have a report:
      Click image for larger version

Name:	image.png
Views:	0
Size:	44.3 KB
ID:	123936


      that gives me results ( not all Account . Account Parent are filled - it's OK - no data)

      Click image for larger version

Name:	image.png
Views:	0
Size:	60.7 KB
ID:	123937


      when excel is generated ile:


      Comment

      • arturkulik
        Member
        • Apr 2025
        • 60

        #4
        it puts:

        all columns have data

        but when i generate email ( report send via email)


        i get email draft with body and attachment,
        email body has values:



        but attachment

        has empty columns: Account . Account Parent ( values =should be like in mail body)
        ​​

        this same happens when i send scheduled email from report​

        Comment

        • yuri
          EspoCRM product developer
          • Mar 2014
          • 9564

          #5
          Now I understand that it's a foreign link field. Will be fixed in the future version.
          If you find EspoCRM good, we would greatly appreciate if you could give the project a star on GitHub. We believe our work truly deserves more recognition. Thanks.

          Comment

          • arturkulik
            Member
            • Apr 2025
            • 60

            #6
            Originally posted by yuri
            Now I understand that it's a foreign link field. Will be fixed in the future version.
            Thanks for quick answer,

            Will it be fixed in Espo 9.3?

            Comment

            Working...