FME Form

Is it better practice to use  import fmeparam = fme.macroValues[‘parameterName’]orimport fmeobjectsparam = FME_MacroValues[‘parameterName’]in Python scripted parameters and why?

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  

what can cause a process to run on the desktop and then restart on the server? have you had similar problems?

I have two table that I am trying to keep in sync. I want a target table to match a source table. But I am trying to avoid deleting all rows from the target and reloading it. The source table is in our CIS (customer information system) Oracle database and the target is in our GIS Esri Oracle database. I am using a CRC calculator to find rows that are identical. Then I have a writer to delete rows from the target that have been updated in the source and to delete rows that no longer exist in the source. Then I have a second writer to insert rows that exist in the source but do not exist in the target or have been updated in the source. The delete writer is based on a single key column.Okay, so it is important that the delete writer commits before the the insert writer. I have tested it and the delete writer does appears to commit first. The tables are synced properly and the FME logs show the delete writer committed first. So, my question is this: Can i count on the the delete writers a

Is there a way to obtain a list of unchanged values then explode the list afterwards similar to how change detector can have an output list for changed values. Below is the sample workflow I’m trying to do but for unchanged values  

Hi,I currently work with the Cesium 3DTiles writer and stumpled upon some requests asking for support for the DRACO compression.I tried to do apply the compression afterwards using ‘3d-tiles-tools’ with no luck. So I took a deeper look on the b3dm Files using ‘3d-tiles-tools analyze’ and it looks to me like it’s already DRACO compressed. ‘3d-tiles-tools analyze’ gives me:{ "asset": { "generator": "FME 2022.2.5.0", "version": "2.0" }, [...]"meshes": [ { "primitives": [ { "attributes": { "_BATCHID": 4, "NORMAL": 2, "POSITION": 1, "COLOR_0": 3 }, "indices": 0, "material": 0, "mode": 4, "extensions": { "KHR_draco_mesh_compression": { "bufferView": 0, "attributes": { "_BATCHID": 3, "POSITION": 0, "NORMAL": 1, "COLOR_0": 2 } } } } ]

Hello to all,I have a problem with an IFC file where some IfcProperty are referenced by a propertySet but not defined. Then, I have a message like this : IFC: Could not find instance #245009 in the IFC file.So, my question is to know if it is possible to say to FME to continue to read the file ?Thank in advanceBest regardsBruno

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 https://support.safe.com/hc/en-us/articles/25407793929229-GML-Writing  and he

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:...and here another screenshot of the settings of the problematic transformer:I have also run it with the quick translator an

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