Network Automation Software We are currently migrating this forum
over to our HelpSystems domain. Please
post all new threads in our new
HelpSystems Community Portal.
Post to the HelpSystems Forum
You are not currently logged on. You must be logged on in order to post. Log on
Or Create a new account
AutoMate Discussion
Decrease font size
Increase font size
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
Search Topic Search Topic
Topic Tools Topic Tools
View similar topics View similar topics
View topic in raw text format. Print this topic.
Answer This question was answered by Valentineo McGowan, on Monday, October 20, 2014 5:03 PM

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.
 10/09/2014 04:07 PM
User is offline View Users Profile Print this message

Author Icon
PhillipWilkie
Apprentice (20-49)

Posts: 29
Joined: 10/09/2014

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



 Category Survey
AutoMate 7 version: 7.1.2
Windows version: Windows 2003



Task Steps: (Right click, Select All, Copy to copy to the clipboard. Steps can then be pasted into the AutoMate Task Builder)
 10/10/2014 09:34 AM
User is offline View Users Profile Print this message

Author Icon
Ricardo Castaneda
HelpSystems

Posts: 3424
Joined: 01/11/2008

Hi Phillip,

Can you please copy the steps from Task Builder and post them for further investigation?

 Category Survey


-------------------------

Ricardo Castaneda | Principal Support Analyst
AutoMate | Division of HelpSystems
HelpSystems, LLC | T: +1.213.738.1700
 10/12/2014 12:31 PM
User is offline View Users Profile Print this message

Author Icon
PhillipWilkie
Apprentice (20-49)

Posts: 29
Joined: 10/09/2014

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



 Category Survey
AutoMate 7 version: 7.1.2
Windows version: Windows 2003



 10/14/2014 04:43 PM
User is offline View Users Profile Print this message

Author Icon
Valentineo McGowan
HelpSystems

Posts: 766
Joined: 09/03/2013

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.

 Category Survey
AutoMate 7 version:
Windows version:


-------------------------

Valentineo McGowan | Technical Consultant
AutoMate | Division of HelpSystems
HelpSystems, LLC | T: +1 213.738.6966 | F: +1.213.738.7665
 10/15/2014 11:21 AM
User is offline View Users Profile Print this message

Author Icon
PhillipWilkie
Apprentice (20-49)

Posts: 29
Joined: 10/09/2014

I have attached the screen cap of the PDF Variable and it looks like the dataset object is converting the binary to a string.



 Category Survey
AutoMate 7 version: 7.1.2
Windows version: Windows 2003


Click for full image
Click for larger image

 10/17/2014 10:52 AM
User is offline View Users Profile Print this message

Author Icon
Valentineo McGowan
HelpSystems

Posts: 766
Joined: 09/03/2013

Answer 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.


 Category Survey
AutoMate 7 version:
Windows version:


-------------------------

Valentineo McGowan | Technical Consultant
AutoMate | Division of HelpSystems
HelpSystems, LLC | T: +1 213.738.6966 | F: +1.213.738.7665
Statistics
18258 users are registered to the AutoMate Discussion forum.
There are currently 0 users logged in.
The most users ever online was 5551 on 01/08/2018 at 11:11 AM.
There are currently 1611 guests browsing this forum, which makes a total of 1611 users using this forum.

FuseTalk Enterprise Edition v4.0 - © 1999-2020 FuseTalk Inc. All rights reserved.

Sitemap Network Automation Software Blog