FME Form

I have a case where I need to determine which wells (polylines) belong to which unit (polygons) based on spatial relationships. I need to be able to know the percentage of those relationship (wells and units) and some key data associated with the unit. I need to determine percent of overlap and produce two outputs.  One to show only the relationships (between wells and units) with the highest percent of overlaps (including their percent overlap value) and an another containing all relationships (between wells and units) and their percent of intersect. Thanks!

I am going through a list of CAD files, how to keep running the workspace even if it hits an error?

Using FME workbench and fme.exe file. Both was working earlier. Suddenly both are not able to open any .fmw file. Only if run as Administrator it is working. What could be issue.FME version : 2016Server : Window 2008

Dear Sir/ Madam, I have two indoor map data. One is the indoor network for the entire floor. Another one is the POI (My interested points A & B). I would like to use ShortestPathFinder to see if the network is routable.  However, I am not sure why I am not able to use the "ShortestPathFinder".  My ultimate goal is to check all my POI points are routable. Could someone please give me a hand? Since I cannot upload the zip file in this forum. I have upload my data on Google drive. https://drive.google.com/file/d/1nYZaHHyXM6DhMzfH_abuBgPPtc55Jpkk/view?usp=sharing Thank you and I am really appreciate your help.  

The distance between the road and the plots are not fixed, so we can't use a buffer

Hello,is it possible to write an Excel file to a SharePoint site? I don't believe I wish to create a SharePoint list or a lookup but simply overwrite an existing file in a folder sat in SharePoint.I can read a file from SharePoint in just fine using a Reader and just need the equivalent to 'write' I have tried the SharePointOnlineConnector but it's not outputting a file like I would expect.Thanks.

I was surprised using FME 2021 in BATCH mode to find, that DataInspectors (which were active by mistake) wrote all their data to FME_TEMP, and to make it worse the data was NOT removed afterwards. This way my FME_TEMP got filled up with 250 GB of trash and broke my workflow due to lack of disc space. Is this supposed to be normal behaviour lately, or is it a BUG ?Remark: I use Windows 10

Wondering how the schemaMapper can replace the field name for 165 Census fields within the Attribute Manager environment? Seems the examples require remapping the entire list? Is this kind of like a tabular Join in GIS?

File error! Couldn't open file. any idea what will be reason ?

I'm trying to load a vector tiles from the URL below but keep getting workspace generation errors. Can anyone tell me if this is possible please? I'd like to load at z=14 for the area of England and then merge the tiles into a single file to save locally.https:\\t1.mapstack.org\tilesets\trees-lidar-2022-ds\tiles\{z}\{x}\{y}.pbfMany thanksRob

I have an excel file with lat/long coordinates and I'm trying to create points based on them in a file geodatabase. The geometry is being created but I keep getting an error when trying to view the attribute table: "A column was specified that does not exist." I've checked that all the columns are green in the file gdb writer.​If I replace the file geodatabase writer with a shapefile writer everything works fine. Can anybody tell me how to figure out what is going on? Using FME Workbench (Form now?) 2020.1 Thanks, Mike

For a studie assignment I was free to choose a topic and I chose this. At the moment I have (shp) files with:Property data (e.g. how much solar panels per property with how much WP)Electrical Grid (for the area of interest I have all grid lines - like a road network. Not included are the lines to the properties themselves, but the lines that run under the sidewalk in a neighbourhoud).Transformation Stations (on the gridlines there are a number of transformation stations that are connected). For each property I want to determine a point on the grid lines where the would be connected. And If I have that point I want to determine which transformation station is closest. I thought about LRS and Network Service Area, but after a few night looking for clues on the Internet and trying I have been able to figure out how to start.  Is there someone who can give me tips on how to start en proceed? I have only had a basic leasson in FME and I am having a hard time finding my way. Any help is app

Hello. I have a question about one solution. I have duplicate points with the same name, but with at least different geometry. I need to filter these duplicate points relative to this one coordinate. Passed will be the point with the same name that is closer to this coordinate. I am attaching the fmwt. Thank you very much.

Is there any way to extract only the exterior wall boundary along with its door, window, and other related elements? Please share some ideas I really appreciate your kind support.

Hi there! I have a point cloud representing a dense forest. I am trying to get the 3D convex hull of the point cloud (as a mesh). I have already tried PointCloudToPointCoercer (individual points) into HullAccumulator but the results are unexpected and do not contain the whole point cloud:  Using the Minimum Bounding Volume tool in ArcGIS Pro does the trick, but since the rest of my workflow is in FME, I would like to avoid this option. Is there an FME alternative to this tool? Here is the result produced by Minimum Bounding Volume in ArcGIS Pro:  Hope someone with knowledge of 3D models in FME can help. Thank you!

Hello, I am using FME Server 2021.2.3 deployed on couple of machines in a fault tolerant configurationWe have an Oracle database 19c. I have tried to connect to the database in FME Server, but getting the error message below (see attached also). I can connect to the database from SQLDeveloper on the same server.A similar issue was reported in https://community.safe.com/s/question/0D54Q000080heRDSAY/not-able-to-create-a-new-database-connection-on-fme-serverHowever the solution needed a reinstall of FME Server.Does anyone have other suggestions ? 929028:SQL Query SELECT NCID FROM fme_nc_namedconnections WHERE connectionname = ? AND username IS NULL failed. Error: Unsupported feature

Hi guys,i have different excel files which i have to split in separate excel files (fanout with row C), name them as Row C input (PA9-BK.....) and keep the formatting...first two columns (the grey ones should stay in all files) and the rest (green colours and so on) should also keep in the new files. how is the plan for that? i have searched some articles but not found the right one.....sry cheers, thx and greetz FRanco

I have an issue trying to get a DGN file into Revit for placing rebar and steel detailing. I've tried the following:Import an IFC from designer - model breaks and has strange behavior.Convert DGN to a DWG file via FME and import to Revit - broken model no resembling original. Has anyone developed a workflow or know a good way to achieve a stable DGN to Revit workflow maintaining most of the original integrity without bugs etc.? Thank you!

Hi all!I would like to write my data to a format called .geo which is used in Sweden but is not supported by FME.I attach some sample how the format looks like:FileHeader "SBG Object Text v2.01","Coordinate Document","UTF-8"begin   FileInfo "Application","Geo Professional"    FileInfo "SerialNo","123456789"   FileInfo "Author","Abcdefghijklmnopqrstuvwxyz"   FileInfo "Company","Abcdefghijklmnopqrstuvwxyz"   FileInfo "Description",    FileInfo "Coordinate System","Sweref 99 18 00 / RH2000"endPointListbegin   Point "123456",6580210.000,155715.000,,,,"rör i mark med däcksel"   Point .....   Point....endLineListAttributeList I have a list with points and want to fill in the list in the "pointlist" section.Would this be possible with FME right now?Any ideas or help is appreciated. 

Hi, guys, i'm new here. When i make a hatch in Autodesk CAD, and then translate it into GDB via FME, then i use FME exporting to .dwg file, when i zoom in to a very large scale, the new geometry's boundary line doesn't fit the original one, the area of the hatch also changed a little, but the line or arc don't change when i do the same. Can anybody tell me how to make it right? THANKS!!

I am using InlineQuerier to lookup a value and add it as an attribute to my base table (Cities). For audit purposes I want to lookup multiple values and add multiple attributes before performing calculations. Currently I am using a separate InlineQuerier for each additional attribute. Can it be done in one? or using other tools? As an example say the base table is Cities, and I want to look up several different price indexes in a CityIndex table based on specific dates, and add these to the base table. See pictures. To add one attribute I can use an InlineQuerier function:Select Cities.*, CityIndex.IndexValue as Index_at_20210630from Cities Join CityIndex on CityIndex.City = Cities.Name where IndexDate = "20210630" But how can I add multiple attributes - see desired state screenshot attached? Many thanksPhilip (6 month FME user)    

How to connect fme server to the network drive?

Hi everyone,I am trying to split a large table into multiple files and was playing around with the dataset fanout feature. My table has multiple header rows that contain explanations of each attribute that I wish to keep in each file created by the fanout but I cant seem to make it work.  An alternative that I can also see working is to add a static Sheet to each fanout-file which then contains these explanations. I wasnt able to make that work either though. Any help would be much appreciated.

Hi, we have some PoylgonZ geometries with multipe polygons per building. For each polygon we have different heights. Now we are creating building models in citygml with citygml_lod_name = lod1Solid. This is working already with this workflow:But now we have for each solid one building element. Then I thought on the transformer aggregate to aggregate the solids for each building (by gmlid).But then I have MultiSolids which I can´t write to CityGML (lod1Solid). How can I create only one Solid for each building?Or do I have to use lod1MultiSurface?

Hi, I am using the Email(Send) action within an Automation but am unable to get it to work. I am using: smtp.office365.com on port 587 and StartTLS encryption.The office365 email account has MFA enabled and so I am using an App password.I am able to use the same configuration within the FME Desktop Emailer transformer just fine - but the same parameters do not work within the FME Cloud automation.Error message is:"com.microsoft.aad.msal4j.MsalInteractionRequiredException: AADSTS50126: Error validating credentials due to invalid username or password"My FME Cloud instance is running "FME Server 2022.2.1 Build 22776 - linux-x64"I have also supplied an App Client ID by registering an App within am Azure AD as described in this article but it does not resolve this issue:https://community.safe.com/s/article/How-to-use-Microsoft-Modern-Authentication-with-FME#ForServerAny Ideas?Thanks