by cyborgsolution

Workflow Email action with Dynamic PDF Template Attachment

Free 30 day trial
Try it Now

#2116 - Workflow with PDF attachment not working

Closed Bug? created by rahuljain Verified Purchase 4 years ago

Hi Support,

We are using SuiteCRM 7.6.6 with PHP 5.3.29. MS SQL database with IIS 8.5 Web Server.

I've purchased, installed the plugin and validated the license. I've setup a workflow for sending email with PDF Attachment.

When I edit the Accounts record and update the field, which is the criteria for triggering the workflow, I get error 500. After refreshing the page, it loads up the Dashboard/Home screen and in the workflow it shows that workflow was triggered (entry in Process Audit" with Status - Running). However, I do not receive the email with the attachment. Repeating the above process creates another entry in Process Audit" with Status as Running.

Please help resolve the issue.

Thanks, Rahul

  1. rahuljain member avatar

    rahuljain Verified Purchase

    4 years ago

    Hi Team,

    Looking at our logs, its showing an error for

    Query Failed:INSERT INTO config (value, category, name) VALUES (N'very long string',N'SugarOutfitters', N'workflow-emails-with-pdftemplates-attachment')::: [Microsoft][SQL Server Native Client 11.0][SQL Server]String or binary data would be truncated. [Microsoft][SQL Server Native Client 11.0][SQL Server]The statement has been terminated.

    Please let me know if you’d be able to fix the issue with the plugin or shall I proceed with cancelling the purchase and request for refund from the store.

    Thanks, Rahul

  2. rahuljain member avatar

    rahuljain Verified Purchase

    4 years ago

    Hi Team,

    I've fixed this issue myself. The only issue now I'm facing is that when I receive emails from the workflows, the PDF attachments for Accounts are not parsing the variables. Its shows blank where the variables exist.

    Please help.

    Thanks, Rahul

  3. rahuljain member avatar

    rahuljain Verified Purchase

    4 years ago

    Hi Team,

    Please advise if the issue with PDF attachments for Accounts not parsing the variables can be fixed? If not, I'd proceed with requesting refund and repurchase when the issue has been resolved.

    Thanks, Rahul

  4. rahuljain member avatar

    rahuljain Verified Purchase

    4 years ago

    Hi Team,

    As you have sent me a separate email that you would be fixing the issue once you are back to work from 1st September, I'd keep my purchase for now. However, since the purchase is going to be more than 30 days old by the time you return to work, in case the fix can't be fixed, I'll be entitled for a full refund even after the 30 days period expires.

    SuiteCRM Store Team, please take note regarding refund after 30 days period, as communicated to the vendor.

    Thanks, Rahul

    • jason member avatar

      Jason

      4 years ago

      Hi Rahul,

      Why don't we refund the charge for now and once a solution for you is in place you can make a new purchase? Let me know if that works for you and I can get that processed.

      Thanks, Jason Eggers The SuiteCRM Store

  5. rahuljain member avatar

    rahuljain Verified Purchase

    4 years ago

    Hi Jason,

    Thanks for the response.

    If processing the refund now and then repurchasing once the issues are fixed is easier to keep the account books sorted, then please do so.

    Alternatively, I'm happy for the vendor to give it a go at fixing the issues and if that doesn't work, then to have the refund processed please.

    Please let me know.

    Cheers, Rahul

    • jason member avatar

      Jason

      4 years ago

      Thanks Rahul,

      Went the easiest route and refunded the charge. Feel free to purchase again if the issue is fixed for you.

      Cheers, Jason

  6. rahuljain member avatar

    rahuljain Verified Purchase

    4 years ago

    Thanks Jason. Your prompt response and help is much appreciated.

  7. cyborgsolution member avatar

    cyborgsolution Provider

    4 years ago

    Hello Rahul We have sent you an email requesting details of CRM instance. We would be looking into the issue as soon as we have the necessary information.

    Regards

  8. rahuljain member avatar

    rahuljain Verified Purchase

    4 years ago

    Thanks guys for getting in touch. I've sent the necessary details. Please let me know when you are available to go through the issue.

    Cheers, Rahul

  9. cyborgsolution member avatar

    cyborgsolution Provider

    4 years ago

    Please download Version 1.1 of the package and test on your instance. We have verified that the PDF generated through this does translate Account and Contact module Variables.

  10. rahuljain member avatar

    rahuljain Verified Purchase

    4 years ago

    Thanks guys, since the purchase is refunded, I can't download the nersion. Could you please send the plugin files on Skype with temporary license key? Once I've tested that its working fine, please cancel the temporary licenses key and I'll repurchase new license key from the store.

    Cheers, Rahul

  11. rahuljain member avatar

    rahuljain Verified Purchase

    4 years ago

    Sorry typo...I can't download the newer version.

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...