Transformers

that should be in separate fields are in the same cell. So, how do I remove peoples job titles that are sharing the name field and place them in a field of their own and is their a standard FME practice that will target duplicate entries into Excel sheets? Any help would be greatly appreciated.

Hi, i need to convert one geotiff to kml/kmz but i´m a absolute begginer in FME workflow. Anyone can help me with a tutorial or similar ? Tnks

Microsoft is disabling SMTP on Microsoft 365, and we have to switch to oAuth 2.0 authentication. We have some Emailer transformers in our workspaces, unfortunatly they only support oAuth2 for Gmail. What is the alternative to use for this transformer ?    

I use a FeatureReader to read multiple shape files from a .zip. The FeatureReader run in FME-Server. A published parameter is used as 'Dataset' (i.e. the FME server path to the .zip file). 'Feature Types to Read' is empty to read <All Feature Types> because I don't know the exact name of the provided shape files per monthly run. The set up works pretty well. the Reader loops over all shapefiles in the zip and the records are provided through the <Generic> port as intended. Now I have the following challenge:One group of shapefiles in the .zip are point classes and the name starts with POINT_****.shp. Another group are lines and the name start with LINE_***.shp.Question: Is there any option to read only one group with my FeatureReader setting? I tried to play with wildcards in the File/Filter field of the 'SelectMultiple...' control but with no success My current mitigation is to use two FeatureReader. The first one is only reading schema and the

For some reason in one of our processes it was decided that an XML is needed that contains partly json data (I know how this sounds :( ).I'm struggling to get the json data correctly parsed (or the XML correctly formatted). The json data is generated via json templater and looks like this:{    "editOptions": {        "cascadeEditOptions": {            "cascadeStrategy": {                "type": "NoCascadeStrategy",                "enabledTypes": []            }        },        "userProvidedIds": true    }}The XML structure should be like this:<data> <metadata> <projectName>SomeProject</projectName> </metadata> <action> <Modification operationId="test_operation_id_1" Id="1" requestBody=' {    "editOptions": {        "cascadeEditOptions": {            "cascadeStrategy": {                "type": "NoCascadeStrategy",                "enabledTypes": []            }        },        "userProvidedIds": true    }}  '/> </action></data>Th

In this workspace, the results of AreaOnAreaOverlayer (using the default tolerance) and SpatialRelator (using a custom DE-9IM matrix) are different. I suspect it's a precision issue with the AreaOnAreaOverlayer transformer but it's curious that the transformer that doesn't allow changing the tolerance (SpatialRelator) is the one that works fine.  

Wondering what parameter to change so that when I use PointOnLineOverlayer it does not split the lines? is this possible?

Hi,I have array with geometry type and coordinates. How can I easily make geometry out of it? I could make a wkt text with string replace but I suspect it could be easier. The string with geometry type and coordinates is (shortened):{"type":"MultiPolygon","coordinates":[[[[155469.406,463438.624],[155469.253,463444.217],[155467.196,463444.174],[155467.077,463444.172],[155462.4]4,408. [ 155469.406,463438.624]]]]}  

Which transformer can be used in the place of MRF2DCleaner transformer?

Hello, I have an Excel-file where one of the attributes contains large numbers such as 3.0230003003349996e+19. I want these numbers to be in a format without the e-notation such as 30230003003349996. What's the fastest way to do this?

I have a 2d polygon and I wanna fill it with as many parallel lines as possible given the distance between the lines and the angle. I have some problems to create the lines I need.  In the image ignore the points.Input:+ the angle (i.e. 80°) Result (ignore points)

Hi All, I have a string that ends with a couple of characters that cause PostGreSQL to fatally terminate the process when it receives them. Unfortunately I'm not certain that the string /always/ ends with these characters or I'd use the substringExtractor.   I get this error: invalid byte sequence for encoding "UTF8": 0xc0 0x80  So what I'd like to do is trim them. The problem is - How to do that without resorting to Python?  I can't just copy/paste them into an attributeTrimmer because FME represents these with the special "replacement character" ? - https://en.wikipedia.org/wiki/Specials_%28Unicode_block%29#Replacement_character - meaning what the trimmer is searching and looking to replace is that special unicode character (?), not the actual ones that I want to remove.  If I go into the source database and select the character in it's original encoding and paste that, it just pastes a space.  There's nothing in the AttributeTrimmer docs a

I have added the following items as a list on a user parametersRiceSoft wheatSunflowerCorn after the user selects the first three options, the output value is displayed on this formatRice "Soft wheat" Sunflower where as I would want to convert the above output onto the following format["Rice", "Soft wheat", "Sunflower"] Kindly suggest on how I could achieve the above output. Thank you. 

Hi, i would like to ask, i need to type that "not equal" to Where clause, and the attribute value is stringI tried to type != and <> or not in and others and non of them worked. Maybe you know the answerThanks in advance

I'm clipping a Raster with a number of polygons.As I'm using another software to then visualise the raster-file in 3d, I would like the oultine of the raster to be "smooth" and not "pixelated", is there a way to accomplish this?

I was told the data  "44821.76657" is the elapsed days and time since "1 Jan 1900"

I'm attempting to use relative dates, however I want to exclude data that was modified "Last Friday" where today is "Monday", however I can't see any documentation at what acceptable relative dates there are and what they actually mean (i.e. if today is Monday, does "Last Monday" return as today or the week before? Or does "next Monday" return as today?)?

Hi,i read a postgis table with the feature reader. As a WHERE clause i want to filter on a certain criteria, say: name_community IN ('Comm1','Comm2','Comm3') I would like to allow multiple selection. Therfore I have choosen the type of parameter "choice" and a list with multiple selection. The name of the parameter is "_community". Now , I thought: name_community IN (%(_community)) However, this does not work. Any support would be appreciated.

I have a workspace where I gather the data from the web and upload on data base whenever data available my script run and load the data on the database with truncate.  now the issue is on the source table remove the data until new data is not availableso when I run the script the feature reader shows me nothing. so how can I truncate as well until new data is not available?   as you can see Advisory Wind don't have records from source so if there is record i need to truncate my table  

I'm struggling with a date that I want to extrapolate based on a frequency. The maximum latest date is the end of the year.My columns are:routefrequency_daysdate_startHow can i realize this in the right way?

I am able to use a python scripted parameter to get the list of field names/attributes and they do populate with the scripted parameter as expected, however, when the scripted parameter is plugged into a FeatureReader to expose attributes, it fails. Example:Scripted Parameter Name: $(scriptedParameter)Returns the value of:OBJECTID COMPONENT SITE_NAME JOINT_BASE STATE_TERR COUNTRY OPER_STAT IS_FIRRMA SE_ANNO_CAD_DATA SHAPE_LENG Shape_Length Shape_Area However, when using the same scripted parameter in the FeatureReader Transformer - Generic Port - Attributes to Expose, the result is missing values in an attribute called $(scriptedParamter) (the same name as the parameter). If I hardcode the value of the parameter to my list of attributes, things work fine. Is this a bug with the FeatureReader transformer, or do scripted parameters not work in the FeatureReader Transformer - Generic Port - Attributes to Expose?

I have thousands of JSON files, containing metadata. Although these all metadata are not relevant, hence tried to filter out only relevant data using test conditions. The problem is that the JSON file structure is a bit inconsistent.For example- I want to extract "Roll" data from JSONs and when exposing the attribute through the "Attribute Exploder" transformer, it shows data varies widely from one JSON to another (see the below example)metadata{20}.metadata.rollmetadata{43}.metadata.rollmetadata{45}.metadata.rollmetadata{52}.metadata.rollmetadata{106}.metadata.rollmetadata{844}.metadata.roll etc. etc. Now I am trying to find the "Roll" data using test condition within the "Tester" transformer (see below example) I know, this is challenging to find the desired value if the JSON structure changes from one to another. I am trying to find out an easy way to use the test condition. Not sure which expression can show a range of the values within cur

Hi forum Looking for a bit of help with the using the HTTPCaller to query a polygon area on an Image Service. PointsI’ve got the DTM image service from the Environment agency, which I’ve been using to extract the DTM height value for certain points. I’ve been using the “identify” function through the HTTPCaller in FME, and then some JSON extraction to get out the height value. All great and working. PolygonsI’ve now got some polygons, and I want to find the lowest height within the polygon footprint (added bonus, maybe also the lowest point on the perimeter too. Not essential).Looking at the ESRI documentation you can do Identity with a point or a polygon, but I’m getting a bit stuck on the polygon.For the points data I tested in service identify window, and then copied and pasted the query from the URL into my HTTPCaller and then amended it to take XY attributes etc in FME.I tried to test for a polygon by inputting a list of coordinates in here and swapped the type to polygon, but I g

I need to remove duplicates from varying sized datasets. Would it be more efficient to use a sorter with a sampler or a statistical calculator with a tester?

Looking at this article writing using the XSD XML Writer: https://community.safe.com/s/article/XSD-Driven-XML It seems that it is not possible to nest features together using xml_id and xml_parentid and having multiple features to write. For that example I want to be able to have two featurewriters as shown below, the cap:alert and the cap:info. The way they are grouped together is that the cap:info has an xml_id and xml_parent_id which links it to the correct cap:info. I thought that woudl work, but no.... Is there no way to write complex nested xml-features other than "merging them in the workspace"?