Best Answers

I have an environment with FME Server 64 bits 2018.1, and ArcGIS Server 10.7.1A workspace contains a SystemCaller transformer that is able to run this:$(PythonEXE) -c "import this".the parameter PythonEXE is "C:\Program Files\ArcGIS\Server\framework\runtime\ArcGIS\bin\Python\envs\arcgispro-py3\python.exe" it works ok.An update to FME Server 2019.2.3 was made, now the execution of the SystemCaller allways fails: Update: Same happens in FME Server 2020.1.2.1 with ArcGIS Server 10.8.1Failed to Execute `""C:\Program Files\ArcGIS\Server\framework\runtime\ArcGIS\bin\Python\envs\arcgispro-py3\python.exe".....with this: `exit_code' has value `-1073740791'if I run the same command from a CMD it runs OKif I run the same command from a Powersehll it runs OKif I run the same command from a CMD with the credentials used by FME Server it runs OKif I run the same command from a Powersehll with the credentials used by FME Server it runs OK Is there any configuration or flag that i should activate in o

Hi, I wanna test if geometries are within an given area, I found the Spatialfilter transformer, but it doesn't work as expected. Geometries that i'd like to test were set as Candidate, the area as Filter and Tests to perform to Within. But it does not test for candidates within the filter, instead it tests if the filter is within the candidate, which is not what i want to achieve. Do you have an idea what I am doing wrong, or what I can change to make it work? I am using FME Desktop 2015 thx & br,mel

Hello,  I would like to download a jpg file from my FME server and save it to my local drive with an API call.  Using FME desktop, I am not sure which transformer/writer to use, and I can't seem to find my REST API call to work. There are a few API documentations in the web, but what I tried was a GET call, but it doesn't seem to download anything.https://<fmeserver.example.com>/fmerest/v3/resources/connections/<MY_SHARED_SOURCE>/filessys/<file_directory/filename.jpg>I am pretty sure my auth and permission is file. Can someone please guide me how to achieve my goal? Kind regards,Tae

I would like to install the transformer AutodeskBIM360DocsConnector o a shared folder instead of an user profiel. That way the transformer can be used by all employees without having to install it in every profile. As we work in Citrix the package is not installed completely and needs to be finished manually for each profile.

I need to run rather extensive workspace to update database tables from an XML file. The update files can generated every day and are avaible for two months to past. When processing the worskpace I download these update XML and write them them. So far no problem.During the execution I need to check the continuity against a table in the database. So I would need to load up to 60 files read the header with date (1) and previous file information pass it to tester, process first file with all writes (2), write a row to database table with a header information about file processed (3) and take the next files to process from failed tester (4) and fetch them again to SQL executor.I'm not sure about the loop part as it seems there can´t be writers inside and I also miss attributes passed from feature reader. Not sure how to correctly arrange it. An idea is to pass it later to FME server and run every day, so no or just one file would be processed. But the workspace needs to be able to proc

Example  Name | Try 1 | Try 2 | Try 3 | Try 4|  Tom| 3  |  6  |  0  |  2 | Bob | 2  |  7  |  1  |  6 | Kat | 1  |  8  |  1  |  3 | Export  Name | Try | Highest Score Tom | Try 2 | 6Bob  | Try 3 | 7Kat  | Try 2 | 8 Much appreciated

We can only do one software upgrade a year because of restrictions from our IT department. Would be good to know if if we can wait for that and benefit from some bug fixes or just have to go with 2022.1

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.

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:  

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.

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 : https://community.safe.com/s/question/0D54Q00008wRTK3SAO/getting-error-like-unable-to-convert-row-to-dimensionfeature-while-reading-a-dimesions-fileIs it also impossible to write dimensions to an esri geodatabase with an ArcGIS Pro geodatabase template ? You’ll find my fmwt in attachment.Any advices is welcome 😊Laurent

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 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?

Hi, I have to zip the output from the featurewriter.The standard writer has the option to zip the output. Is this also possible with transformer "FeatureWriter"? I have not found anything about it. I need FeatureWriter because my process will go on after writing! 

I had a WFS reader with a search envelope that is downloading point features. The search envelope used to work in a previous version of Desktop.I'm now getting the error:Unknown coordinate system '' specified.  Nothing else changed. The data is read in as EPSG:4326 and the search envelope is the same. Any ideas?  

Hello,  for calculations on line segments I divide a line into its individual segments between two vertices (2-point line) using the transformer "Chopper". For a further processing step I need the number of the segment within the total line. This means that if my line consists of 11 vertices, I have 10 line segments. The first line segment should start with the element ID 0. I have tried to do this with a counter, but without success. For this reason, I would like to ask how I can solve this elegantly. Thanks a lot

I am encountering issues when reading text from a DGN where the text is in Microstation native fonts (e.g. igds_font = 0). I am generating PDF files from the DGN's and I need the text to look the same in the PDF as it does in Microstation. Currently, I am seeing variations in text font, as well as special character inconsistencies (e.g. degree symbols are read as ^ ). Is there a way to read Microstation fonts in FME? I have access to the font library .rsc files - can I utilize them somehow within FME?Thank you!Courtney

The GUI (icons, buttons, menus, text, etc.) in FME workbench isn't scaling/rendering correctly on my PC. Some elements are relatively large while others are very small. Is there a way to fix this?

I'm trying to make some pretty histogram reports of some error differences and I'm having trouble getting the chart generator to actually show the trend line. I want to show it because my data should be close to normally distributed.I have tried to use the trend line in the scatterplot option but that does not work also.Does anyone know what I'm doing wrong? I should have enough data to get a trend (60+ data points)

Hi, i Would like to have the road map geometry as input from Google maps or any other app.and use it as input data to FME to define which cable located at this road and so on .FME 2021

Hi. I am asking for advice on final editing. The qus1 file is the current FME output. In the StartpointDesignator column, I need to remove duplicate values and output them to the CSV output in the format see the "vzor" file.Thank you

I'm trying to convert 3D models to GLTF, however, the output models tend to be a little do dark in the application we're using. I'm trying to make them brighter by setting the SpecularColor factor to white. I also want to set the shininess, but only if there is no shininess set. In addition I want to also apply a fallback appearance to the surfaces which have no appearance. The conversion needs to work for all inputs and ideally be nice and fast. I've been playing around with the SharedItem tools and have gotten very close to what I want, however, there are some edge cases where my process doesn't work.It seems like it should be really easy but I just can't get it to work. Has anyone had luck doing this?

Hello,  I have a FME Server Automation with a Manual Trigger. This FME Server Automation is triggered via the FME Server REST API in a HTTP Caller. I would like to know if it is possible to set the Output key values (Manual or otherwise) of the Manual Trigger via the body parameter of the HTTP Caller.And if it is possible, what kind of body should you send?  I did find out you can set these in FME Server when you trigger the Automation in the Web UI(Start Automation -> Trigger) when the Manual Trigger parameter of the automation "Prompt for JSON on Trigger" is checked. Then you can set the values for the (Manual) Output Keys. This however can't be used in my process.  Thanks in advance,

I have Lines (13,000 Street Centerlines) and Points (7,000 Intersections). I want to do a spatial join of the Lines and Points so that the attributes of each point is merged with the 1 to 4 lines that intersect each point.  I just started using FME, after completing the training last month. What Transformer(s) would you recommend I use for this process? My goal is to have the lines each have the CROSS_ST_NAMES field which is in the points layer be joined to each line that intersects a point. In the points layer, the CROSS_ST_NAMES field has no <null> values, when they are merged with the lines there must be no <null> values. Below is a screenshot of what I am working with. Each line is a street centerline, each point is an intersection.