Transformers

I am wanting to read and write features to a POSTGIS connection however I can't even connect as I am unsure what to do for the schema field. Can someone provide examples of what to add in the schema for table field.

Imagine having a raster with transparent gaps (null) and wanting to fill these gaps with another dataset (presumably of lower resolution). If this second source is placed under the first the secondary data would "shine through" the gaps. This is how one would solve it in Photoshop, and I'm trying to figure out if the same solution is possible in FME. Is it posible to set the layering/stacking order of incoming datasources before running the RasterMosaicer?  (This is a follow up question to: https://community.safe.com/s/feed/0D5Dm000007hjgQKAQ)

Hello, I have a raster dataset. I need to intersect vector lines with it and then get the average values of the raster cells (pixels) that intersect with the vector line. I have a working solution to do this but I have to convert the raster to polygons with a RasterToPolygonCoercer. Some rasters are larger (8.2M cells) so this takes forever and is very memory intensive. Is there a better way to do this without converting raster to vector polygons? I'm not super experienced with rasters so please explain well.  Thanks in advance!  

I have read all the SchemaMapper tutorials and implemented what I thought should work for a SchemaMapper and input mapping table, but the feature type in question here is not being mapped at all. I am hopelessly confused, hence the following explanation and question: I have a feature type Safety/Fire (i.e. fme_feature_type = feature_dataset/feature_class) that I want to split into three different feature types based on the value of the Type attribute. The values are FDC, Fire Alarm, and Fire Extinguisher. I also want to put the three new feature types into a different feature dataset, namely Life_Safety. Here is a screenshot of part of the mapping table I am using:  In the SchemaMapper I have set first a Filter Features action with SRC_FIELD = SRC_FIELD_VALUE indicated and with Ignore Blank Attribute Values set. Then I have a Map Feature Types action with SourceFeatureType --> TargetFeatureType indicated. Finally, I have a Map Attributes action with SRC_FIELD --> TargetAttr indic

I want to connect the pipelines to each other in Z coordinates at the place where there is a mutual vertex intersection.

Hi. I would like to know how to apply a custom icon for kml styler. At this moment, I could convert from Csv file into Kmz file with icon that I can select at KML Styler with condition Statement (like value 1 = C1). However, I would like to change these icon into my custom icon (png files). How Can I set? Please kindly give some advise to me.

There are some postings on this but it does not work for me yet:I am trying to contact an external API via HTTP POST to get a token back.It already works with python. But we wanna integrate the workflow in fme server and Iam sure it will work with fme. Python script:# Parameter_____base_url = 'https://apieco.eco-counter-tools.com'api_key = 'XXX'  # Base64 encoded secrets  # Tokenabrufdef get_token(url, api_key):    header = {        'Content-Type':'application/x-www-form-urlencoded',        'Authorization': 'Basic ' + api_key              }    r = requests.post(url + "/token", headers= header, data={'grant_type': 'client_credentials'})     answer = json.loads(r.text)    token  = answer['access_token']    return tokenHTTPCaller: Erorr Message: HTTP/1.1 415 Unsupported Media Type  Which mime type should I use for the grant_type: client_credentials?

I have a raster DTM with some erroneous transparent areas. I would like to fill these using average vales of the surrounding pixels, to keep everything nice and smooth. GRASS has the 'fill nulls' function that does this, does FME have anything similar?

I have multiple shapefiles in a folder with subfolders. Example Folder "01" has 10 shapefiles, Folder "02" has 15 shapefiles, etc. I was able to create a gdb and load all the features into the gdb but the whole thing is too large. Is it possible to have FME create a new gdb for each subfolder name? What I would want is a new gdb named 01, for the data that was in 01. Another new gdb named 02 for the data that was in 02, etc.thanks!

Hi FME ninjas,I'm working on a data source that contains school names. The names in the source are too long and need to be shortened.Left is what I have, right is what I want: I know the StringReplacer can be used to correct single strings - but I fear I will need to create at least 40 of these to correct all possible strings.Is there a transformer that can replace multiple strings? Or can this be done by Regexing some transformer? If so, how?Thanks,Ed 

I'm finding that when you write a raster image to Excel while using the ExcelStyler to stretch the row height (e.g. 100), the raster will be stretched in the y-direction by a factor of about 7. This only occurs for the first column (xlsx_col_id = 0), and writes fine to other columns. Is someone able to confirm if this occurs on their version too?  It's possible to force a fix by adjusting the xlsx_raster_height to be about 7x less than xlsx_raster_width, or write to a different column. Version: Data interop FME(R) 2021.0.0.0 (20210305 - Build 21302 - WIN64). Thanks!

The TIFF has only angle unit and does not have linear unit and the shp file only has been defined Geographic coordinate system. What can I do?, Does the TIFF file have to have Linear unit before?

Hey everybody,​I would like to define the hierarchy from the first administrative level into the second administrative level, and I would like to do that with the spatial reference. So for example I have a shapefile of the first administrative level which is called "Central". The second shapefile are the districts, so the second administrative level, which are all in the Central state. Lets say we have 4 districts (south, east, west and north). The name of the Central state, so "Central" should get automatically get written in the attribute field "hierarchy" of the 4 districts. I would like to use the spatial reference as transformer. But it was not working. Has anybody an idea how to solve that problem?Thank you in advance.Cheers,Fabian 

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