Skip to main content
  • EN

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?

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


Community Stats

30,122
Posts
114,328
Replies
37,750
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.