Wiki

Scale Your Enterprise

User Tools

Site Tools

Trace: • Configuring Links • Swagger Page Documentation • Standard Buttons • Forms Home • SSL Certificates • Display Tab Versions 2.4 and Higher • Introduction (Reports Configuration)
bw:bizweaver_tips

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision 		Previous revision
bw:bizweaver_tips [2020/06/04 11:25]
akoehler created 		bw:bizweaver_tips [2020/06/08 09:15] (current)
Line 5: Line 5:
 ===== Dealing with invalid email addresses =====  ===== Dealing with invalid email addresses ===== 
  
-If the Bizweaver email tool is configured to send an email from a data field that contains email addresses and if a invalid email address is passed, the workflow can stop with errors. The following SQL statement examples can help find bad emails in the data on the SAP Contact Persons Table (OCPR). +If the Bizweaver email tool is configured to send an email from a variable that contains email addresses and, if a invalid email address is passed, the workflow can stop with errors. The following SQL statement examples can help find bad emails in the data on the SAP Contact Persons Table (OCPR). 
  
 Below is to check if the email is not properly formatted, this will not return any emails that are incorrect. Below is to check if the email is not properly formatted, this will not return any emails that are incorrect.
Line 26: Line 26:
     and isnull(E_MailL,'')<>''     and isnull(E_MailL,'')<>''
  </code>  </code>
 +
 +===== Adding Multiple Attachments to Emails ===== 
 +
 +Below is a method on how to add multiple attachments to an email by way of a zip file. The program that is being used is **7zip**, this is the only prerequisite needed to make this process work. This is just an example and could change depending on how you are using this functionality.
 +
 +  * Example workflow 
 +{{ :bw:7ziptipworkflow.png?nolink |}}
 +
 +  * 1. Define the proper variables using the Variables tool. 
 +    * Outfile is the zip file that 7zip is creating. 
 +      * This path is in "C:\ProgramData\Bizweaver\tmpFiles\7zipTest.zip" you can place the output file in any desired location.
 +      * If saved in the above folder path you must create the "tmpFiles" folder
 +    * InFiles is the folder with all the files that are being zipped.
 +      * '.' is pulling all files in the folder with a period in the file name. Another way to denote any file in a specified folder with a certain file extension use a wildcard "*.<file extension>".
 +
 +{{ :bw:7zipvariablesstep1.png?nolink |}}
 +
 +  * 2. Using the WF Exec Tool to have 7zip call the input folder to zip and have it output the zip file to the desired location.
 +    * Full Path: This is the location of 7zip.exe
 +    * Add Arguments: This is the command line prompt needed to zip the input file. This also tells the 7zip the name and location of the output file.
 +    * Wait for Execute: This will wait for 7zip to finish the process of zipping the files before continuing the workflow.
 +
 +{{ :bw:7zipexecstep2.png?nolink |}}
 +
 +  * 3. Add the variable for the OutFile in the attachments section of the Email tool to add the zipped file to the email.
 +
 +{{ :bw:7zipemailstep3.png?nolink |}}
 +
 +
  
bw/bizweaver_tips.1591284331.txt.gz · Last modified: 2020/06/04 11:25 by akoehler

Page Tools

Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Noncommercial 4.0 International
CC Attribution-Noncommercial 4.0 International Valid HTML5 Valid CSS Driven by DokuWiki