Workflow Email action with Dynamic PDF Template Attachment
#2116 - Workflow with PDF attachment not working
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
qwerty
5 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
5 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
5 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
5 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
5 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 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
5 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
5 years ago
Thanks Jason. Your prompt response and help is much appreciated.
5 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
5 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
5 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.
5 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
5 years ago
Sorry typo...I can't download the newer version.