Skip to main content
Question

How to set up a creation of pdf/shp for each DB-row sent with emailer

  • May 8, 2023
  • 1 reply
  • 6 views

I have an MSSQL database, where new rows will be added on and off. I have setup a workspace that will be run nightly, that checks the database for rows with null in the field "email_sent_with_data" and sends it in a beautifully formatted email and it works wonderfully.

 

However, I would like to send along a map, either a pdf or a shapefile or similar containing the three geometry columns in the row. Any ideas for solutions to this problem?

1 reply

nielsgerrits
VIP
Forum|alt.badge.img+54

Use a FeatureWriter to write a shape zip, then use the outputport of the FeatureWriter to initiate the Emailer.

 

If you don't want to keep the zip you can use a TempPathnameCreator to write the zip to a temp folder, but I advise to add that part after you have it working as debugging temp files is harder.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings