Question

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

  • 8 May 2023
  • 1 reply
  • 0 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

Userlevel 6
Badge +32

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.

Reply