FME Form

What is the equivalent FME Transformer(s) of this ArcGIS Pro Geoprocessing Tool: Join Features (GeoAnalytics)—ArcGIS Pro | Documentation Including JoinFeatures by geometry (intersect).

I am building transformations that send data to Azure Table Storage. When the attribute value is missing there is a blank string inserted into the table. Due to the nature of the feature, there will only be one row of data but different columns may have missing or null values. These values we do not want written to the table. I have tried using Python and NullAttributeMappers, but these still leave the <missing> value which is causing issues. Is there a way to dynamically remove these columns? The reason for wanting to remove the attribute columns before the Azure Table Storage writer is that "Automatic" Attribute definition appears to be required in order to dynamically pass different columns to Azure.

$ curl -X POST --noproxy “*” -k "https://server_name/connect/token" -H "Content-Type: application/x-www-form-urlencoded" -d "username=asdfg" -d "password=ghjkl" -d "client_id=CLIENT_ID" -d "client_secret=CLIENT_SECRET" -d "scopes=openid profile role" -d "grant_type=password"  

Hey All, I am trialing FME currently to see if this software is going to be able to simplify my life, and it is looking good so far! One thing I am hoping to do is a very simple "Download all attachments from AGOL feature layer".I have seen dozens of posts on this site about various processes involving AGOL features and generating reports etc with the attachments, but they are a little advanced for me at the moment. I am hoping someone can provide me with a simple workspace that I provide my AGOL feature layer, then provide an output folder location, and FME will download all attachments for me.I have had a few cracks at this but I cannot work out the attachment part, the attributes are all I can get at this stage.Can someone show me a screenshot or something showing the simplest solution to carry out this task? I got to this point but it doesn't write anything to the output folder:

How does fanout work for dwg files with FeatureWriter in FME Server. Hundreds of postgis tables are read in my workspace with Feature Reader and they should be written as DWG files by object category. The process works as desired on Workbench. Separate dwg-files from each table with the desired filenames ja layer names will come out. But when I publish my workspace on the FME server, in download zip everything comes out in one and the same file with all feature types on its own layers and filename with a generically generated filename. When publishing, you can only specify the folder path. I would want to use FeatureWriters because I don't wanna create a hundred writers with few transformers each.

Hi i need to extract only text inside spanI used this css string for this website http://sac5.halleysac.it/c038007/mc/mc_p_ricerca.php?multiente=c038007&pag=0tbody > tr:nth-child(-n+20) > td.break-all   thxFrancesco

We are on FME Desktop 2021.2.2Currently have a FeatureWriter that can insert new records (Account ID with their correspondence amounts) into SQL table from a source CSV file. See below:For each import, the CSV file could have same Account ID with different amounts. Therefore, we'd need to truncate any existing matching Account IDs rows and replace with new data. Changed Table Handling to 'Truncate Existing' but the amount still doesn't change. Heard you can change Feature Operation to 'upsert' but don't have that optionThanks.

Hello, I am new in the FME community but with a great experience of FME Desktop which I would like to share with you. I don't know and I do not understand how to make and publish the article on the page. Could you help me, please?

I have a table of street names in a single field in this format:George StAdeline WayParker Blvd I want to split this into two fields that include, for example: FIELD1 = GeorgeFIELD 2 = St I think I need to use the SubString Extractor Transformer? any ideas on the best way to go about this?

I have a single band raster (DEM raster) I want to create polygons which represent ranges. For example I have pixels with a range from 100 - 500 and I want to create polygons where values are in the range 100-105, or 105-110. I've tried to contourGenerator and building areas from those but contours aren't close so it's not really an option. RasterToPolygonCoercer I think would work but I need to first get my raster values to be grouped by the interval - this is where I'm having trouble. any ideas?

I am able to convert Autocad dimensions to “Arcmap” dimensions following the response of @Mark Stoakes​  : https://community.safe.com/s/question/0D54Q000080hgppSAA/migrating-dimensions-from-autocad-to-esriHowever if I try to write dimensions to a geodatabase with an ArcGIS Pro geodatabase template, I get this error : |FATAL |GEODATABASE_FILE writer: An unknown exception occurredI read that is not yet supported to read “ArcGIS Pro dimensions” with FME :

I'm working with a date field that needs to be converted from a text string giving the format as described in my title (e.g. October 1, 2022). I've found a lot of documentation on the DateTimeConverter, however none of the formats on the documentation seem to match up with my date format. This seems like a simple solution that I'm missing, any help is appreciated!

what I trying to do is write the values in the Database and then read from there as a readerbut the problem is when I run my workspace its runs same timewhat I m want is 1st load the data and then reader-run   

We get the error when translationfme Unexpected Input Remover Nuker (TeeFactory): Cloned 0 input feature(s) into 0 output feature(s)What's that means

If so, what parameter settings would accomplish something like the attached example?

Hi, I have a workspace to apply for a cutting permit that takes 3 cutblocks and aggregates them into one feature based on cutting permit and then output that directly to the HarvestApplicationWithCP output. This looks ok when the writer is redirected to the inspector, but the XML is incomplete, it only has one of the cutblocks in the HarvestApplicationWithCP portion of the XML.

I need to insert current date (month_year) in column name all time that run my workspace Look Bellow: Thank´s 

I would like to modifiy the last vertex of each line feature, if the lines intersect, to copy the depth so that also the connection is made in Z-coordinates. Based on an attribute field there should be determined if the Z-value should be copied or overwritten of it's connecting neighbour. 

I'm working on a script that I downloaded from the server and want to run this on the desktop version.It requires a couple parameter changes to make that working, but it's quite a hassle to do that properly whenever switching between desktop and server.For instances changing the featureReader file path from $(FME_SHAREDRESOURCE_TEMP)/$(FME_MF_NAME)/foo.json to ~/documents/FME/foo.jsonI noticed that I can set FME server parameters on the desktop, which are currently all empty.Can I for example set $(FME_SHAREDRESOURCE_TEMP) = ~/documents and $(FME_MF_NAME) = FME so it works on the desktop and server without the need to change these parameters whenever I switch between server and desktop?

Hi. Today's second question, I'm glad that this forum exists :) I'm sending the "example" file in the attachment. I would need advice on a transformer where I could implement a sequence of individual segments. I have an idea, but I don't know how to implement it in WS. StartPoint and EndPOint is one segment. I need to determine the correct order of the segments. To get the correct order, I need to determine the first and last point - the value of the first point must meet the condition of occurrence in "startpoint" and at the same time it must occur only once ( A1 ). If I manage to determine the first segment, I need to further apply that the endpoint value of the first segment ( A2 ) is the starting value ( startpoint ) of the following segment. This way the correct sequence will be connected. Some ideas? 

Hello,I have a workbench that checks several files for some data mergers. Problem is, this one source I have (30+ excel files with thousand of rows each) is useful only when there is a certain value in one of the columns. I was wondering if there is a way to open these files only if a condition is met beforehand (like a user parameter prompt). I wouldn't want to read all files every time knowing that if the condition is not met, they won't bring any value to the end result. For example, If I chose at the start of the workbench "Toronto" - it should trigger this reader; if I chose some other city, it shouldn't. Any advice is appreciated. Thanks!

Hi, This is probably a stupid question but I dont get why the following expression is in error in the PointCloudExpressionEvaluator with FME 2020 @round((@Component(x)*2))/2ERROR |PointCloudExpressionEvaluator (PointCloudEvaluationFactory): Failed to parse the EXPRESSION_LIST clause. The provided value was '@round((@Component(x)*2))/2;@round((@Component(y)*2))/2'. Please ensure that your syntax is correct Curiously, the @round function is not available in the Math functions list in the transformer: 

Hello Forum. I'm trying to help a colleague to setup an Oauth2 service (Tools->WebConnections->+->Oauth2Service) but we're struggling. We have the parameters from the data-owner, and the "Preview" window in the setup dialog presents an acceptable URL (see attached image), but when the connection is made to the server, the URL is malformed. The problem is that the URL received on the server is terminated (prior to the parameters) with ampersand thus: /realms/fdir-dev/protocol/openid-connect/auth&redirect_uri=https://localhost/&client_id=yggdrasil-sa  instead of question-mark as reported in the setup-dialog Preview (see image) The question-mark is required by the server and html convention. Has anyone had success with the OAuth2 server connector, who might be able to guide us, or is this simply a bug?

Is there some special reader for Bentley AXSYS drawings format that would parse nested objects in XML and joined with the drawing?

Hi I have a lot of tif tiles that together form an orthophoto of a municipality. There has been a problem and the colors of the different tiles don't match that wel. Is there a way to color match the different tiles so that they match better? Here you see what it looks like now: