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)
<AMTASK> <AMTASKHEAD> <TASKINFO TASKVERSION="7120" /> </AMTASKHEAD> <STEPS> <AMVARIABLE NAME="BatchNo"></AMVARIABLE> <AMVARIABLE NAME="DocumentsToSend">0</AMVARIABLE> <AMVARIABLE NAME="DocumentsSent">0</AMVARIABLE> <AMSQLSTOREDPROC PREDEFINEDCONNECTION="EzidebitUAT" PROCEDURE="sp_GetKey" NAMES="@RETURN_VALUE,@keyname,@fieldlength,@keystring,@b_Success,@n_err,@c_errmsg,@b_resultset,@n_batch" VARIABLES="&quot;&quot;,&quot;&quot;,&quot;&quot;,BatchNo,&quot;&quot;,&quot;&quot;,&quot;&quot;,&quot;&quot;,&quot;&quot;" TYPES="Integer,String,Integer,String,Integer,Integer,String,Integer,Integer" DIRECTIONS="ReturnValue,Input,Input,InputOutput,Output,Output,Output,Input,Input" VALUES="&quot;&quot;,FTPBatch,10,123456,0,0,&quot;&quot;,0,0" PRECISIONS="10,0,10,0,10,10,0,10,10" NUMSCALES="0,0,0,0,0,0,0,0,0" SIZES="0,18,0,10,0,0,250,0,0" ATTRIBUTES="&quot;&quot;,&quot;&quot;,&quot;&quot;,&quot;&quot;,Null,Null,&quot;&quot;,&quot;&quot;,&quot;&quot;" AM_DESCRIPTION="Get a batch number for the processing" /> <AMSQLQUERY PREDEFINEDCONNECTION="EzidebitUAT" RESULTDATASET="PendingFTP" AM_DESCRIPTION="Get Documents to send">SELECT ClientRef , DocumentId , DocumentType from vwFTPPendingSend where DocumentType = '%TaxInvoiceDocumentType%'</AMSQLQUERY> <AMIF EXPRESSION="%PendingFTP.totalrows% &gt; 0"> <AMSET VARIABLENAME="DocumentsToSend">%PendingFTP.totalrows%</AMSET> <AMLOOP TYPE="DATASET" DATASET="PendingFTP" AM_DESCRIPTION="Loop through Invoices"> <AMSQLQUERY PREDEFINEDCONNECTION="EzidebitStorageUAT" RESULTDATASET="TaxInvoiceData" AM_DESCRIPTION="Get Data For Sending">SELECT InvoiceNo , ClientRef , InvoiceDate , InvoiceXml , InvoiceFileName , CONVERT(VARBINARY(MAX), InvoicePdf) AS InvoicePdf , SummaryFileName , CONVERT(varbinary(MAX), SummaryPdf) AS SummaryPdf , TransactionListFileName , CONVERT(varbinary(MAX), TransactionListPdf) AS TransactionListPdf , CsvFileName , CsvData FROM dbo.InvoiceData WHERE clientRef = %PendingFTP.ClientRef% AND InvoiceNo = %PendingFTP.DocumentId%</AMSQLQUERY> <AMVARIABLE NAME="InvalidData">%TaxInvoiceData.InvoicePdf%</AMVARIABLE> <AMSENDEMAIL TO="phillip.wilkie@ezidebit.com.au" SUBJECT="Tax Invoice" FROM="automate@ezidebit.com.au" REPLYTO="noreply@ezidebit.com.au" ATTACH="%TaxInvoiceData.InvoicePdf%"></AMSENDEMAIL> <!-- <AMFILEWRITE FILE="F:\%TaxInvoiceData.InvoiceFileName%">%InvalidData%</AMFILEWRITE> --> </AMLOOP> <AMELSE /> </AMIF> </STEPS> </AMTASK>

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

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

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

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

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