FME Form

I have tried using the excel reader to get my file in, then httpcaller with the URL as my column of google drive shared hyperlinks. Renaming the output to a column which identifies the name that I want. I'm obviously not getting the settings right in the httpcaller or missing something entirely. New to using this and really no idea what I should be doing. For now I have only focussed on trying to download the Report but ultimately there is also a video avi to be downloaded. My input excel file looks like the following: Newname for the report and then the report google drive hyperlink.

I am reading the polygon and Lines dataset in FME. I need to select lines that are intersecting a polygon and populate the polygon name in Lines. I have used tester after feature to filter one polygon and select intersecting lines using a spatial filter. Is there a way to loop through a polygon feature and select one polygon at a time in FME, Instead of entering the Polygon name in a tester every time.  

I am attempting to offset all lines that intersect each other by increments of 5. Some lines have duplicate/stacked lines on top of them, as well as standard intersections with other lines. My intent is to assign all lines that intersect a differing offset (which is where the increment of 5 comes into play). I have tried creating a list on the Spatial Relator, but I am not getting my desired results. I don't have any trouble with creating the offsets through the Offsetter or 3D Forcer transformers, but I am stumped on trying to assign all intersecting lines a different offset (so they won't intersect in Z space).  I would appreciate any help or ideas that can be passed along, thank you!

We have been working with a user of FME ESRI Edition to repoint the connections to a SQL server Always on listener in a multi subnet environment. The connection string has been configured with the Multi-Subnet Failover check box enabled (see attached) however the connection does not appear to resolve, to the multiple IP addresses registered, in parallel as I would expect for this parameter. As a result, connections are occasionally timing out.  Can you advise if there are any relevant known issues with the FME release currently being used (FME ESRI Edition, 2021.1.3.0 build 21631). Also are there any additional configuration changes required to ensure the multisubnet parameter is set correctly within the connection? Any assistance with the above would be greatly appreciated. 

I'm trying to connect to our SharePoint Online environment to be able to work with lists. In FME Workbench (2021.1) I used the "Microsoft SharePoint Online (template) to create a new web service. When I try to test it I'm getting an error: "Authorization and token retrieval was successful but refreshing the token using 'Refresh Token Parameters' failed. Error: HTTP/1.1 401 Unauthorized".My redirect uri is set to https://localhostMy Auth parameters url is:https://login.microsoftonline.com/{mytenantID}/oauth2/v2.0/authorize?scope=https://{mytenant}.sharepoint.com/.default offline_access&response_type=code&prompt=consent Retrieve Token Parameters url:https://login.microsoftonline.com/{mytenantID}/oauth2/v2.0/token refresh token Parameters url:https://login.microsoftonline.com/{mytenantID}/oauth2/v2.0/tokenrequest format (default carried over from template):client_id=[CLIENT_ID]&refresh_token=[REFRESH_TOKEN]&grant_type=refresh_token In Azure

How to highlight in the workbench canvas in FME desktop the route of a chosen entity? Through which transformers this entity has passed.

Hallo FME community,I have a network consisting of interconnected lines. on the other side I have some points lying on the line. I need to cut out my network based on these points and the line between two points must be aggregated with each other. Also, PointOnAreaOverlayer couldn't help me.I would be grateful if someone can help me how to do this process.  

What limits are there on backwards/forwards compatibility when using FME Objects .NET? I ask because I have a custom .NET application that was built using FMEObjectsDotNet4.dll (build 18567) that fails when used with FME Desktop 2022 (build 22337). This is the exception message: System.IO.FileLoadException: A procedure imported by 'FMEObjectsDotNet4.dll' could not be loaded. There were no issues on install (FME Data Inspector 2022 works as expected), and the Path environment variable appears to be set correctly. The custom .NET application worked properly with FME Desktop 2019.1.1 (build 19617).

Good day, I tried to convert XML file to shapefile using FME and using the same steps in safe website but the data did not show up in the map and the shape was point, and what I was expecting is line.Here is the data source of XML:OneGeology catalogue (brgm.fr). Thank you with kind regards,Majdi

My purpose is to save it as .txt document. Manually I can open it in notepad and save it as .txt. But this has to do through FME.

Hi folks, I'm just wondering if there is any interoperability for SAP Business Objects Web Intelligence - the data is stored in 'universes' and I want to be able to access that data using FME. Many thanks, Aaron

I'm try to translate a multilayer GDB file to GEOJSON file. As a result. I found all layers are merged into one single layer. How can I translate it into multilayer GEOJSON

I'm trying to read a Orthophoto from ArcGis-DB using Reader-Transformer Geodatabase-sde-Raster-Dataset and clip an specific area of the raster using definition of Search Develop. At the End, make a tif export from that.  The Problem is that FME represent the reading raster als grayscale, although the raster has four bands. How should I export a rgb tif from raster dataset? I would appreciate any Help in advance. with regardsSoschianet

Hi there,Not sure where to post this so putting it here.Can someone please keep up to date the "Known Issues" button on the support homepage (https://community.safe.com/s/support) so it links to an article for the latest version of FME, not 2020 (https://community.safe.com/s/article/workarounds-to-known-issues-in-fme-2020x) ? Thanks,Marc

How to download multiple zip files from linux server in local starting with same prefix name (e.g. ARESFF01.341,ARESFF01.342, etc) with sftp in fme?Can we use FTPCaller?If so, how? If we can do it other way also kindly suggest.

I'm making an ETL to convert some features from an geodatabase SDE to Autocad DWG-files. It is working well, but i'm getting an error.AutoCAD Writer: Shape file 'ltypeshp.shx' or 'ltypeshp.shx' not found when trying to resolve shape ''It has no consequences for the output, but it is bottering me. Any idea what the problem could be. Am i missing some parameter?

I have an Oracle database with about 500,000 entries. I want to read in 1 feature for each unique value of 'DEVICE_TYPE'. Is there a select or where clause I can use to do this?

Hi! I'm trying to extract parts of a response body from a HTTPCaller. I've read some previous threads on the topic but I just end up more confused. The response body looks something like this:  [{"href":"https://download-geotorget.lantmateriet.se/download/99d120aa-9532-43a9-a5a7-6128b333bc88/files/root/militartomrade_kn0125.zip?q=t-CwjGgGH....1Vl4dA==","title":"militartomrade_kn0125.zip","type":"application/octet-stream","length":3792,"displaySize":"3,7 kB"}, {"href":"https://download-geotorget.lantmateriet.se/download/99d120aa-9532-43a9-a5a7-6128b333bc88/files/root/hojd_kn0125.zip?q=t-CwjGgGHQJjXdA1styBEV1B.... ] And so on. It goes on like that, so I shortened it down. The parts I'm trying to 'extract' are several URLs, and I'm looking to create attributes from them, in order to download the zip-files they point to. Does anybody have a solution to this?  You

If i have an esri fgdb that has no features in it. To be used for a template.I want to validate data coming from the field against these coded domains values in the template. But i can't see how to get the domain values. I have the "resolve domain" checked on. I can see that probably having the single merged feature as features will not work as you get literally NOTHING.i have also tried individual feature types as both features, and metadata.As features I get no features (of course), as metadata I get 1 feature for each featuretype (and have enabled ALL format attributes for each featuretype). But, there is no "ATTRIB_resolved" attribute. So using the FME Hub "Read_ESRI_GDB_Domain_Data" custom transformer doesn't even work. It seems the only interface that will allow this is through the esri "KLUNK KLUNK" domains/subtypes "clickamilliontimes" interface with no output.anybody else experience this?

What is the best management practice (bmp) for assigning Unique ID to AutoCAD drawing (dwg) objects? I am preparing to use upsert (haven’t upgraded FME yet) and need to establish a Unique ID for every AutoCAD object that becomes a feature. The current workspace ingests ~300 drawings, transforms to GIS features, then writes to a single feature class in an ESRI geodatabase (gdb) file. Up until now, my focus has been on the ingesting and transformation. The current workflow simply overwrites the entire feature class every run. Now, with upsert coming, I want to refine my process to update and insert only modified features.I understand that AutoCAD object ‘handles’ are unique to each drawings object, but I’m thinking not necessarily unique across multiple drawings. I could concatenate handle with drawing name, which would work for me currently, but could at some point be flawed, as drawings in different directories could have the same name. I have other ideas, but want to hear form the com

How about ArcGIS 10.8.2 Support ? It is around since 2021 and nothing is mentioned on the FME Esri compatibility page.

Hey there, Trying to figure out of this is possible with the current data I have. I have a road network that looks like this of which I generated points for the mid-points of the segments. The road network does have froms and tos.Essentially we have a camera on a car that needs to traverse this network in the same direction every time to make comparisons going forward. So ideally im looking for the quickest way to travel this route hitting ALL of the roads and have something that can be repeated every month where the driver is going the same direction every time. Is there an article on this I can't find?

I am trying to build an API POST call using HTTPCaller for situations where there will be a dynamic number of parameters using the same name based on an aggregated list. In this instance, I have an attribute value called "fee id" which could have anywhere from 1-20+ items in the list (built using Aggregator) depending on how many charges were processed in a specific transaction. Each item on the list needs to be its own parameter (the values cannot be comma-separated), which is where I'm running into trouble. I can configure HTTPCaller manually to handle this, but that is only in my tests where I know ahead of time how many items will need to be processed.  I have been unable to find a way for FME/HTTPCaller to accommodate dynamically generating a query string parameter for each item in the list. Is this possible?  Even though it is not the most elegant solution, I also tried playing around with using a conditional statement for the name column (i.e., if a value in &q

I would like to use the hosted (cloud) solution, but my database is behind VPC, so there is no direct access from FME to my DB.how can I save the data in the EWKT or EWKB format, so I could save it by myself to the DB , using a text file? (or a stream in websocket?) I tried using GML & GeoJson - but they both loose the geometry types and just save as multilineString

I have lab data that is reported in rows, one row for each analyte for each sample. I need to create a single record for each sample, with the analyte values as columns in the record - build a single record of analyte values for each sample.to this: