using FME Desktop, i have a workspace that looks at two databases and generates a csv with information from one database that is not found within the other database. i need to then send that csv file to someone via an email, however, the csv file contains 11k rows and the emailer is trying to send 11k emails. how do i send one email with the csv as an attachment?
Use a FeatureWriter to write the CSV (11k records in, 1 record out) , connect the the Emailer downstream and add the file you just wrote as an attachment.
If you want to do it neat you can use a TempPathnameCreator to write the file to the temp so you don't have to clean up afterwards, but make it work without the TempPathnameCreator first, this is easier to build.
Use a FeatureWriter to write the CSV (11k records in, 1 record out) , connect the the Emailer downstream and add the file you just wrote as an attachment.
If you want to do it neat you can use a TempPathnameCreator to write the file to the temp so you don't have to clean up afterwards, but make it work without the TempPathnameCreator first, this is easier to build.
Very nice. Good Job!
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.