I have connected to an AGOL feature service that includes attachments (pictures). I want to write each feature to its own excel document and include only the attachments for the respective feature.

@vhruska13​ As a starting point, have a look at the article Writing Images to Microsoft Excel Spreadsheets

Hey, so I have already had a bit of success with writing images to excel.

I should specify that my main question here is how to:

• Separate attachments by feature (8 total in this case)
• Write each feature to a separate excel document (8 total) with their respective attachments

I'm guessing this has something to do with a fanout setting, but I'm a bit confused on how this would be set up per feature.

If anyone could assist that would be great.

Thank You!

@vhruska13​ Great. You're on the right track with fanout, but I think you're probably looking for the Dataset Fanout (as opposed to Feature Type fanout which gives you separate sheets). This is on the Excel writer (in the workbench Navigator). You can build up the Excel directory and file name form attributes in the workspace.

So I got the dataset fanout working like I want it to (kind of) - It writes an excel file for each feature in the dataset.

However, I now need to add the pictures into the specific excel sheet.

I'm pretty confused about where to configure the fanout settings after the list exploder and how to get the correct images into the sheet. Any tips?

@vhruska13​ You need the feature type to connect to the Featurewriter. But you probably don't really need the featureWriter and the AttributeFileWriter, You might just be able to replace that with the RasterReplacer, and replace the point geometry with the raster geometry.

One point to remember with the fanouts (both dataset and feature type ) Is that the attributes that you use for the fanout must be set on ALL the features you write to the output.

I've attached an example where I'm using a File Geodb + Attachments to write to Excel. In this case I have to use FeatureJoiner to ensure all the fanout attributes are on the image features. (i'm using feature type fanout instead of dataset fanout but th principal is the same.

Example workspace FME 2020.2

Mark - you're the man! Thank You. This works great. Although... I'm a little confused by how it works.

I've altered the workspace a bit to suit my dataset. Still a little confused on the images being carried over to excel. In the attached picture, are those fields the ONLY fields that are required to carry images over to excel? Can you elaborate?

Thanks for the patience - this is slowly starting to make sense.

@vhruska13​ Yes. pretty well only for the placement of the images. Excel is surprisingly complex!