Question

how to write an attribute that is written into a textfile into an email.

  • 20 January 2022
  • 4 replies
  • 3 views

Badge

imageThis workbench is run on the server and uses the FME Server email generator. We want it to generate a text which includes

  1. the original total records read from 2 separate tables used as input eg 2913 from table 1 and 7429 from table 2
  2. the total number of records in the output file geodatabase.

We have got it to the point that it automatically fills in the total records from input table 2 but not the other 2 numbers. What could we be doing wrong?


4 replies

Userlevel 5
Badge +25

You have two FeatureWriters, which one is writing the database you'd want to have those statistics for?

And how do you have your FMEServerEmailGenerator set up?

Userlevel 5
Badge +29

you need to pass the output of the ServerEmailGenerator into an FMEServerNotifier. In the notifier, you need to specify a topic to post the string to. On your FME Server you need to setup a topic and subscription to send an email

Badge

You have two FeatureWriters, which one is writing the database you'd want to have those statistics for?

And how do you have your FMEServerEmailGenerator set up?

The feature writer on the left is writing to the database, the feature writer on the right is for logging purposes. The FMEServerEmailGenerator parameters contain 2 email addresses and have the file geodatabase from the left hand geodatabase as an attachment. We don't (yet) have a FMEServerNotifier or a topic setup in the FME Server.

 

A further issue is that the output of the lefthand feature writer is writing to an existing filegeodatabase rather than first creating a geodatabase and then writing to it. Is that something that is done within the feature writer or is a separate transformer needed for this?

Userlevel 5
Badge +25

The feature writer on the left is writing to the database, the feature writer on the right is for logging purposes. The FMEServerEmailGenerator parameters contain 2 email addresses and have the file geodatabase from the left hand geodatabase as an attachment. We don't (yet) have a FMEServerNotifier or a topic setup in the FME Server.

 

A further issue is that the output of the lefthand feature writer is writing to an existing filegeodatabase rather than first creating a geodatabase and then writing to it. Is that something that is done within the feature writer or is a separate transformer needed for this?

Ok, I think I got what you mean.

 

It's probably a good idea to use an Emailer instead of the FMEServerEmailGenerator (because it can email directly, rather than creating a topic).

 

You'll need to take the Summary output of FeatureWriter_2 and join it on to the feature going into the Emailer, then you'll have access to its attributes so you can construct the email body.

Reply