![]() |
![]() |
We are currently migrating this forum over to our HelpSystems domain. Please post all new threads in our new HelpSystems Community Portal. |
![]() |
|
![]() |
AutoMate Discussion | ![]() |
help :
faq :
home
|
||
Latest News:
|
latest topics : statistics |
Topic Title: Using a dataset field for an email attachment Topic Summary: Get binary file from a database and attach to email. Created On: 10/09/2014 04:07 PM Status: Read Only |
Linear : Threading : Single : Branch |
![]() |
![]()
|
![]() Answer: Hello Phillip, AutoMate only handles strings and cannot output directly to binary. You may have to research using a converter that allows you to decode Base64. | ||||||||||||||
![]() |
||||||||||||||
Hi there, I am extracting data from a SQL Server database. It is populating a dataset. Once of the fields is a varbinary(max). I want to use this field as an attachment to an email. The data is being extracted ok. I can see it in the variables window. When it gets to the email step I just get a Syntax Error message and nothing else. Any Thoughts
Task Steps: (Right click, Select All, Copy to copy to the clipboard. Steps can then be pasted into the AutoMate Task Builder) |
||||||||||||||
|
||||||||||||||
![]() |
||||||||||||||
Hi Phillip,
Can you please copy the steps from Task Builder and post them for further investigation?
------------------------- ![]() Ricardo Castaneda | Principal Support Analyst AutoMate | Division of HelpSystems HelpSystems, LLC | T: +1.213.738.1700 |
||||||||||||||
|
||||||||||||||
![]() |
||||||||||||||
I have included the steps in the original post however please find attached teh Task file and a sample of the document that I am trying to send.
Cheers Phillip
|
||||||||||||||
|
||||||||||||||
![]() |
||||||||||||||
Hello Phillip,
While in Task Builder v7, use a Pause Break on Step 19 and make sure the Variables tab is displayed at the bottom. I would like to see the value of what is contained in the 'TaxInvoiceData.InvoicePdf' local variable which is created from the 'TaxInvoiceData' dataset.
------------------------- ![]() Valentineo McGowan | Technical Consultant AutoMate | Division of HelpSystems HelpSystems, LLC | T: +1 213.738.6966 | F: +1.213.738.7665 |
||||||||||||||
|
||||||||||||||
![]() |
||||||||||||||
|
||||||||||||||
![]() |
||||||||||||||
Hello Phillip,
AutoMate only handles strings and cannot output directly to binary. You may have to research using a converter that allows you to decode Base64.
------------------------- ![]() Valentineo McGowan | Technical Consultant AutoMate | Division of HelpSystems HelpSystems, LLC | T: +1 213.738.6966 | F: +1.213.738.7665 |
||||||||||||||
|
AutoMate Discussion
» AUTOMATE » AutoMate 7
»
Using a dataset field for an email attachment
|
![]() |
FuseTalk Enterprise Edition v4.0 - © 1999-2021 FuseTalk Inc. All rights reserved.