FME Form

Hi, Just was hoping for tips on Converting DWG to GeoJSON - is there any one who can lend an explanation I’m attempting the below and it’d be great if someone could offer a high level understanding / approach.  

I have three lines coming from CAD, I have read them and I would like to use “Create Routes”, instead I have used the measure generator. However, the measurements are wrong, and I suppose because on the way the vertices of the line were drawn (in an illogical order).By using “Create Routes” I could select the coordinate priority (lower left, lower right, upper left, upper right) to tell it to start counting from that point onwards (because the coordinate priority will be different per line). Is there a way that the same can be done in FME? Thanks!

Hi,I am trying to configure a web service to use the Salesforce Connector.  When trying to test the connection, I keep getting error:error=redirect_uri_mismatch&error_description=redirect_uri%20must%20match%20configuration I believe this relates to the callback URI syntax, but I don’t know what it should be.. any ideas?

Hello All,I am using FME Workbench 2022.2 and ESRI UN branch version.  There is an existing branch version that has all the edits to various tables and layers that I want to copy to a new branch version. I have tried to use ChangeDetector but this how cannot detect spatial geometry changes.  Is there a way to copy attributes and geometry changes and as well as other UN related table changes from an existing branch version to another version using FME? ThanksAnthea

Hi,I have a process that begins by going through the AttributeCreator2 transformer, but after some transformers, there is a validation. If the result is true, the features will arrive at the DateTimeConverter as shown in the image below...  I would like the process to restart at the SentinelDownloader transformer after the DateTimeConverter returns, and to consider the features with the AttributeCreator transformer only at the start of the entire process. I guess the process should work like a loop.Thanks

Hi, I would like to create the option to pass a value by attribute. How can I create it in a custom transformer like in the image below?   Thanks  

I'm trying to convert an IFC file to Esri Geodatabase format. Is it possible to convert the properties from IFC group ? If so, how could I do that. The properties set is not visible in the traits or the elements object underneath the group layer. I am not sure if that is possible. But the result is visible from the FSKviewer.  Please offer me help!

Dear all,I have multiple IFC files in my folder and have to publish them as Scene Layers in ArcGIS using FME.Do you have any suggestions on how to proceed, and which is the best way to proceed? Many thanks. 

Decoding the “outer” response body parameter value from the HERE Isoline Routing API I get a list of tupels with xy coordinates in this form:[(y1, x1), (y2, x2), ...].How can I convert this into a polygon? I have tried different approaches including PythonCaller scripts but cannot get the correct result.Alternative approach would be using the GeometryReplacer transformer which also supports the Encoded Polyline but also with previous crs setting to epsg: 4326, the LineCloser and AreaBuilder transformers the polygon geometry has a wrong location, without any recognised epsg in a Desktop GIS and the polygon geometry is also incorrect.Thank you!

I am using a Python Caller to create new features based on counts from a REST Endpoint.  I want to verify the output in Data Inspector, everything acts normally until I click on the record in the table (there is not geometry)When I click on the record, the Data Inspector immediately hangs then crashes and closes.I am using FME(R) 2023.1.0.0 (20230825 - Build 23619 - WIN64)

Hi All,I’m testing a simple workbench to fix the geometry of a SHP thought ArcPy RepairGeometry in FME PythonCaller. Here’s is the simple code to run in FME but for reason fails:FME_MacroValues['SourceDataset_SHAPEFILE']The idea is running the script before writing the data into a GDB,Any idea how to make it to work?Thanks :)

GML2IFC translation/conversion warnings I created a very simple model where I added a GML reader and I want to transform it to IFC.When I run it, numbers appeared on the connectors. These numbers match with the number of features per feature type. I would assume that the transformation was made, although a couple of warnings appeared during the run of the model (see second image) Nevertheless, when I look for the transformed files, there is nothing on the folder. When I try to inspect the resulting data using the eye, a windows pops up asking for information that was set when i first set the "writers/translator" (see third image) and when I look for the data, nothing was done. I checked about these “warnings” among the FME community, and between not-updated information and broken links, there was nothing there that could help me to find out the reason or meaning or ground for this issue.I have also checked in

It was all working properly just few days back , today clipper is just crazy.  I have IFC 3D Model and Excel file with XYZ coordinates, all i trying to do is clip all those coordinates are  inside / touching the boundary of 3D Model.    

We have several FME based solutions - At the moment they are mixture of workspaces, CustomTransformers and formats. I guess my question is are people thinking about a package as a single tool (like a API connector) or can it also makes sense to include a number of transformers and formats in a similar way to an FME Server Project?

Hi,I’m attempting to create attributes from an unstructured html table.Looks like this… The table is originally a Word .doc, that I saved as a .html file so I could read it in FME. For example, I’d like to create an attribute (AttributeCreator) that selects based on row number … eg “Survey Authority” = Col1 row4or“End Date” = Col2 row8This there a way I can do this ?thanks  

Hi All,I have created a workbench that includes a few AreaOnAreaOverlayer transformers. For some reason one of the AreaOnAreaOverlayer takes hours and hours to union cadastral data (1,200,000 records) with some protected areas PHI (100,000 records). I have checked the log file and the AreaOnAreaOverlayer transformer always accomplishes the following 4 steps: Performing low-level intersection at phase #1 Performing low-level intersection at phase #2 Searching for topologically significant nodes Breaking curves at topologically significant nodesI have attached the log file as .TXT for reference. For some reason the AreaOnAreaOverlayer_3 slows the process at Breaking curves at topologically significant nodes. This transformer is at the middle of the workflow which means is being fed with data that comes from other transformers. here is an screenshot of the log file:

We have several memory intensive workspaces that normally return log file entries like:INFORM|ResourceManager: Optimizing Memory Usage. Please wait…Recently our IT department was sourced to a MSP, and it seems many security settings have changed. Now when FME tries to ‘optimize memory usage’, we receive Windows warnings similar to the screen shot below for ArcGISIndexingServer.exe and FNPLicensingService.exe. There does not seem to be any adverse effects in FME otherwise.Should we be concerned with these warnings? Will the memory available to FME be lower since access is being blocked? What can I ask the MSP to fix if it is an issue? 

I have an .fmw that reads a series of SQL Server views then writes the returned values to a templated Excel spreadsheet and it worked while using our DEV SQL server (A). When I replace the existing database connection to verify it works on our Production SQL Server(B) the value in one cell is missing in the Excel spreadsheet. I get 0 errors, 0 warnings using (A) or (B) connection. All the remaining view results are there and correct. Verified that the SQL VIEWS exist on both servers and refreshed both just in case-same results. I can select the views via SSMS and get the correct data on (A) and (B). I tried deleting the one failed writer and re-adding it: same results.I tried deleting the reader supplying the view information and re-adding it: same results.Thoughts? Using FME Form Desktop Version 2023.1

Hello,I have an ortho image from a drone flight and looking into filling in the square in the middle of the pond (underestimated the correlation between the area of the pond and flight altitude). Photoshop is the last resort. I looked into using aerial images from the past as a background but the pond change dramatically so it's a no go.Cheers,   

How can I use FME parameters to fill gaps or holes in a raster image? Please explain best methods.  

My current FME job is showing a Completed Successfully message when I get the below error. How do I get it to FAIL the job?  Error retrieving next row from result set: 'Query execution was interrupted, maximum statement execution time exceeded'

Hi, I have a process that im unable to get working and wold like advice on the processesI have a dataset containing a number of records, each with a user and their email address. There are multiple records for each user,The requirement is to identify each unique user in the data and send them an email detailing all the records relating to them. The users could change each time the process is run so i havent set any filters with their names.My thoughts were to create a loop to go through a list of users, filtering their records out and sending the email before moving onto the next name on the list.This would keep going round until there are no names left in the list.I have used the statistic calculator to identify the users and have used the HTML report generator and emailer for the the end of the process but would like some help explaining how the loop should be set up (if this is the best way to do it) and how i can move to the next

I have a starting easting and northing and from that I would like to build lines from a number decimal degrees and distances

1st file example:   2nd file example:dog                      dogcat                       birdbird                      cowhorse cowCompare and write what’s missing from file 2 to a 3rd file.  

Hi, I need help I have this table ID Année Logements 20 2024 120 20 2025 210 20 2026 340  I would like to obtain th