Transformers

I am not that familiar with the Emailer, but I experimented a bit with it and I find it a bit worrisome that I can send a mail from one mail adress (not necessarily mine) to another mail adress. I tested using my colleague's mail adress to send a mail to my own mail adress and I don't need to authenticate that I am the colleague.You can choose yourself to have the sender's authentication on, but I would prefer that it's always required so you will be sure that the person who sents the mail is indeed the sender and not someone else.

hi everyone,My colleague tried out the Emailer transformer and it's cool that you can sent a mail from one mail adress to another mail adress in an automated way. However the mail sent via the Emailer are not stored in the sender's sent items folder in outlook for example. Does anyone know a way in which it's possible to send a mail and the mail is stored in the "sent items" folder?I heard it's because the application server is allowed to sent mails from another mail adress to another mail address, so it's not yourself.However I would still like to know whether it's possible and maybe possibly via another method if the Emailer transformer is not suited for that.

Hi, I've a workspace where I process a series of point feature classes within a single geodatabase (see pic). I'm manually adding/removing connectors to process each feature class on it's own, however, I'd like to simply run the process once and it loops through ALL of the features.I've experimented with the Directory and File Pathnames Reader, however from what I can tell it only processes multiple files within a directory NOT a a geodatabase and the features within. Any thoughts would be appreciated.

If you use the feet to meters conversion of 1 foot = 0.305m instead of the 1 foot = 0.3048m conversion, will there be a significant difference in the elevation information, and therefore, in your analysis?

I am trying to combine symbols consisting of donuts and polygons into a DWG block. The problem is that the areas are displayed incorrectly in the DWG. With the option "Prefer writing donuts as hatches" set in the DWG Writer ( even in the RealDWG Writer) the symbols are displayed as follows. The donut polygons are displayed correctly, the simple polygons only as a line. If I deactivate the option, all polygons are displayed as a line. The creation of the block is controlled by the attribute autocad_block_name.  Can someone help me? Thanks a lot Edit: I also tried to generate the DWG from an Aggregrate

A quick question on “LineonAreaOverlayer” Transformer in FME. I am using this transformer to connect WW pipe data from a council (in line format) with some environmental data (in area format in GIS layer) to analyse integrated data. However, when I am connecting this two layers in FME…I have originally 14, 000 WW pipesBut, when I am connecting this pipe layer with the environmental data layer using above transformer in FME… the number of pipes get almost 50% more say about 21,000 pipe recordsThis makes sense to me as per the description of this transformer which says: “The LineOnAreaOverlayer compares lines and polygons, splitting the lines where they intersect with a polygon boundary. Each resulting piece receives the attributes of the area(s) it is contained in, and each containing area receives the attributes of the line(s) that either fall within or intersect it (a spatial join). Features also receive a count of the number of overlaps encountered”But still wanted to double check wi

Hello , i have around 10 GB DGN files and it takes time to load in FME and and it seems slowly to work with them .i would like to know , if there is best method to work with DGN files ? Or should I convert them to other format ,if it will be besser then I work with them in new format ?FME 2021 Thanks in Advance

I have a time series with ambiguous dates due to the daylight savings time change that I would like to convert to unique datetimes with time zone information: 2021-10-31 02:00 > 2021-10-31 02:00:00+02:002021-10-31 02:15 > 2021-10-31 02:15:00+02:002021-10-31 02:30 > 2021-10-31 02:30:00+02:002021-10-31 02:45 > 2021-10-31 02:45:00+02:002021-10-31 02:00 > 2021-10-31 02:00:00+01:002021-10-31 02:15 > 2021-10-31 02:15:00+01:002021-10-31 02:30 > 2021-10-31 02:30:00+01:002021-10-31 02:45 > 2021-10-31 02:45:00+01:00I tried to do this in FME with the "TimeZoneSet"-function as described in https://community.safe.com/s/article/converting-time-and-date-fields-to-local-timezones. This works for all datetimes except the ambigous ones above (I get null values). In Python this can easily be done by using pandas and the option "ambigous='infer'":import pandas as pddf = pd.read_csv(file, sep=';', parse_dates=['dt'])df['dt'] = df['dt'].dt.tz_localize('CET', ambiguous='infer')For thi

I am trying to automate some quality tests & I need to calculate the distance between the points in a consecutive manner. So, each point needs to be  '50-100 feet' apart from its previous point. I am unsure which transformer(s) would be the most efficient & haven't had much luck looking online. Thanks!

I have 3 datasets that are fme_time schema type and I want to use the AttributeManager Conditional Value to set if/else statements depending on which time values are missing. When I do this, the resulting attribute type is fme_varchar and not fme_time. If I create a new attribute and point to just any one of these attributes, the new resulting attribute is still fme_time. So it appears the conditional value setting is changing it and I can't figure out how to change it back to a time. I have tried parsing, formatting, casting and nothing changes the varchar back to time. Are there any ideas to fix this?    

I'm creating a dynamic workspace which reads Excel sheet as a configuration and extracts data from a Feature Service. Configuration file looks like this:FME workspace looks like this:Feature reader reads every row in configuration file and extracts data for the listed Feature services. It outputs everything through the generic port.  In the configuration file I have field mapping information where attribute fields in a feature services are mapped with the output fields I need: FME evaluates and extracts attributes using such logic: It works well and I'm getting what I need: But I have a question what to do when I have some more specific logic. For example, I have cases when I need to concatenate the fields into one field. How to pass this to FME to evaluate such expression?    

I have too many points A and too many points B and I have many small polygons . every small polygons contain point A but some of them include point B . i would like to to find each point B that close to point A but it should be at the same small polygon if point A does not find point B ,at same small polygon so it will be better if i can mark it .that no point B close to point A .FME 2021Thanks in advance

I have a 3D meshes of buildings in a Rhino file that can be exported as a .obj or .fbx and want to use the fanout expression to put each building into an individual file/folder. The exported file (both .obj and .fbx) dont have any attributes and is read as one cohesive mesh so I am unable to assign any attributes to them to split up. How would I go about this workflow?

In the attributemanager, I declare the igds_model_name which is an atttribute for the model name and is determined by feature_type. Therefore in theory every feature should be written to their respective model. I also declared the model names in the seed file of the dgn, but for some reason the specific features are not written to their respective model. I was wondering whether it's possible to write features to different models in a dgn file and how one is able to do that. 

Hi,No data area of geotiff generated from 'HillShader' can't be shown as transparent in ArcGIS. If it's shown as RGB it contains ALPHA band, but if I choose 'stretched' in symbology, Alpha band is missing, nodata has been shown as black?Anybody knows how to show nodata as transparent in ArcGIS if the hillshade output generated by FME?

I have a simple workspace to generate some web tiles.   I first used WebMapTileClipper to break the data into vector tiles.   I next ran each vtile through MapnikRaster and grouped by _tile_column & _tile_row. I next sent each raster to WebMapTiler. See my attached workspace image. It seems that WebMapTileClipper and WebMapTiler do not agree on column and row. WebMapTiler generates an extra tile for many of the same tile coordinates. In my attached example you can see that MapnikRaster generated 1 image for _tile_column: 978 and _tile_row: 1655 however WebMapTiler generated 2 tiles. Any advice would be greatly appreciated. Richard Carmel 

I have some date with id-blocks, meaning there is a column where one and the same object is represented of several features, with different attribute values, but always with the same id for these features.How many features there are per object varies.I was thinking to build some 'decision-tree' in an AttributeManager to find the correct features of such an id-block to process further. Unfortunately, the AttributeManager is not a group-by transformer and I was wondering how can I group my data by id, and process the resulting group, before the next group is created and processed.

Has anyone else experienced this? I'm using FME 2022.2. If I pick an attribute from the arrow drop down menu, it inserts it in the DateTime Attributes field as @Value(CREATETIMESTAMP). When the transformer runs, it doesn't convert the value. But if I select the attribute from the 3 dots menu, it's fineIn the 3 dots menu chooser, there are sort of two sets of the attributes....

I'm having an error I have not been able to fix when attempting to read/write an annotation feature class from one SDE geodatabase to another. When writing the annotation feature class using INSERT and TRUNCATE in the writer, I get the following error: Invalid geometry type received for an annotation feature. Please split multi-part annotations using the SPLIT_MULTI_PART_ANNOS keyword on the reader to 'yes', or switch to classic geometry mode before attempting to write them to a GeodatabaseBoth annotation feature classes have been updated to an ArcGIS Pro 3.0 version, and they have matching schemas. I've made sure to "clean" the geometry in ArcGIS Pro (no geometry issues were found) but no luck. I'm using FME 2022.0.0.2 (Build 22343 - WIN64). I also followed the suggestion and changed the SPLIT_MULTI_PART_ANNOS keyword to 'yes'. Not sure what "switch to classic geometry mode" means... I'm able to read/write older versions (i.e. ArcGIS Desktop) of annotation feature classes w/o issue wi

I have a lot of ZGF files to convert to shapefile format.  I tryed to use FME to do it, but it seems that some mistake is happen while the imput file is been reading, that cause the lost of Coordinate System. It seems thta the software used the plot coordinate instead of original file coordinate. The ZGF units was identified as 0.

I have tried all the ways I could think of to do this but cannot find anything on how to change a text field to an integer field like in ArcGIS Pro. Please help! This is what I have tried: @int(USER_Price)@int(@replace(@replace(USER_Price, "$", ""), ",", "")) I have also tried @Trim which produced a 3 digit result.

Hello.i have simple workflow to update Access MDB content.it starts with SQL creator to define the queries and end up with SQL Executor to write down all the attribute manipulations and the end.Works fine in workbench as it updates existing MDB file and therefore there is no Writer placed at the end. Im seeking an advice how to update this to be able to publish it to FME cloud so the Cloud returns the updated MDB file.as this MDB file is uploaded at the beginning, it still exists and being updated somewhere in the temp folder of the FME Cloud so it should be easy just to request it with some transformer at the end and provide it as a result. can you advice me what transformer can do it for me?

I am trying to simply export results with a Writer into a .shp. If I do not use a GeometryValidator most of the features are present in the final attribute table, but not shown in a ArcGIS map. If I use the GeometryValidator and then use both the good and the repaired features as inputs for the Writer, some results are missing from the final attribute table, but all the result in said table are also displayed in an ArcGIS map. The log gives following warning "Dropping heterogeneous aggregate feature for the SHAPEFILE Writer, due to feature type allowed geometries restriction". How do I solve this? Thank you!

Hello,in the past it was possible to set the options to no and still choose a template. Is there a workaround here? Why is that no longer possible? I would like to use a template and every time the workflow writes that this is done to the same file and not all spreadsheets are removed. 

Hi guys,  I tried using IDENTITY_INSERT on several tables of single SQL Server Non-Spatial writer. There is a error I'm getting that says I cann't do that. I now for the rule that SET IDENTITY INSERT can only be used on a single table per connectio, but I wonder if there is some way to make my 4 tables use this feature with a single writer? These tables aren't beeing populated at same time, so can I do something with SQLExecutor for example or no?