FME Form

I am receiving a vaige AreObjects error '-2147216072'. That said, it appears to be different than the other questions posted here (such as this, this, and this). The actual error I'm receiving is "An error occurred while flushing the cursor for the table/feature class 'my_table_here'. The error number from ArcObjects is: '-2147216072'. The error message from ArcObjects is: {Underlying DBMS error [[Microsoft][ODBC Driver 13 for SQL Server][SQL Server]The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Parameter 5 ("&quo

I don't know if this is already answered somewhere already but couldn't find it.This is in regards to my previous thread about aligning randomly distributed line geometry as per building footprints. Now, I could find GPS traces as point data to align my line geometry as per the points.In the image below: The black line is the approximate required solutionI tried using NeighbourFinder with 3m distance and then MeasureSetter for putting weights. Ideally, I wanted that points towards the center are weighted more than the outer ones. I have attached some sample data for the same. Could someone help me out with any ideas?Thanks.

When using the Mongo3 reader, I have real slow connection via FME Desktop, while these connections in Python or other Mongo clients are really quick. Some examples cases where it is extremely slow:creating a Mongo connection + viewing all the available collectionspicking a collection + displaying it on the Workbenchrunning the FMW file from Workbench, even with filterAll these step can take up to 6min each, for a simple connection. Is there any way to make it faster, like ignoring all the attributes and just use raw JSON (and nothing else)? Listing all the collections from a Mongo server takes a few milliseconds in Python...I use FME Desktop 2019.2.1.0 (20191202 - Build 19813 - WIN64)Mongo version is 4.0.13

I have groups of points (2D centroids) that I want to declutter by removing points so that there is a minimum distance between the remaining points whilst retaining the overall "shape" of each group.  The PointCloudSimplifier seems to do this, but is there an alternative for 2d objects? If not, is there a way to convert regular ol' points to fancy point clouds? Or is there an another, better, way to achieve the desired result?

How to export "Feature output statistics" table for "Features Written" produced in the translation log? It will be nice to have this exported as an excel format. Thank you in advance!

I used to convert to/from Norwegian standard format SOSI, but since my latest FME update SOSI seems to have disappeared, I'm left with SOSI/GML which (I think) is not the format I need. What has happened here?

Please share the installation guide for FME server 2013 and lmgrd license configuration

I am trying to figure out on how to be able to convert points to lines using a field attribute value from the point feature class. The center would be output to the center of the point and have a length equal to the attribute value on a specifc field, half of the length to the right and the other half to left of the point. Thank you

  Hi everyone,I called wsdl address with httpcaller then I retrieve the response_body that is nested xml. So, I used attrıbutefilewriter(like reader) then I used featureReader and attributeKeeper for catching xml_id. Thus, my problem is xmlFragment I did not catch xml_parent_id for merging. Actually, real aim is "Is there any shortcut using xml_parent_id to establish the relationship between tables in the database after FeatureReader operation?" Thanks.

I am trying to do an insert to CARTO table. It is mandatory to not drop the table because it is necessary anytime a table is created to make a specific SQL statement. This table just has to have the last insert values so a truncate command is required. I have tried with a SQL Executor with two statements. Truncate and Insert. What SQL Executor does is a truncate for every insert. At the end I have a table with only one row, the last value inserted. Any ideas?

I have created a workspace that converts shapefiles (.shp) into Cesium 3D Tiles using the Cesium3DTiles writer. It works pretty well but I'm wondering if I can control how my geometries are broken up into tiles. I've played around with the area and volume calculator to set the cesium_priority property to control when tiles should appear at different zoom levels but I see tiles that span the whole US for instance and I want to sub divide the tile based on a grid or maybe an attribute. Is something like that possible? This picture shows a volume that spans the US that may have some geometries on the west and east coast. Instead I may want a tile for the west coast and another tile for east coast at this zoom level. I can provide my workspace if needed. Thanks! 

Hi,I need help by creating ACAD block in FME. There are more DWG files with buildings, one building per file, filename=BuildingID. I need to merge them into one DWG file, where each building should result into one block with block_name=BuildingID. I can simulate it in ACAD, but I need to do it for hundreds tiles, with hundreds buildings each.Attached are two buildings DWG (5296285, 5356200) and result file with blocks (5300_340000). Thank you very much for any help! 

 For example, I have a CreateNode Field in one table, I have to filter out Null and populate these null values Using the second table that has the same field name. the output is not something It should be. I have attached a screenshot of my workspace. Any help would be greatly appreciated!

I was trying to build a custom Areabuilder sort of Transformer using a PythonCaller and started digging into the documentation.I was trying to instantiate an FMEArea/Solid/MultiArea but I keep encountering the issue where the classes are abstarct and cant be instantiated manually.How should we go about creating let's say FMEAreas? I have my coordinates but dont seem to find any Factory/anything that could generate these objects.I managed to create Lines from 3D coordinates but dont understand how that could result in Areas/any other geometiries.

For others to know: FME 2021.1When the default interpreter is set to the Python in the Arcgis Pro folder adding the BIM360 Transformer results in a failing BIM360 Transformer. We can solve this by removing the Autodesk BIM360 Docs Package, selecting the FME Python 3.7+ Interpreter and re-installing the BIM360 Transformer.  

The error I am receiving just says: Error running translation. Thoughts?

Hello!I have some weird problem.I have lots of user parameters in my workbench, and their order is critical to the success of the workbench.When I set my parameters in manage user parameters, and hit OK, the order got mix to the old order.Has anyone encountered this problem?Thanks,Dor.

perhaps the easiest way ahead is to explain the bigger picture of what I am trying to achieve. I want to produce individual location maps and block plans for about 30,000 properties. Each plan would be centered its dedicated property but show some detail of neighboring houses and roads etc. I am trying to use the clipper (using buffered property land parcels as the clipper) to clip a base map. Obviously the clippers overlap. The way the clipper works, each clipper takes a bite through the base map, and outputs the result. This means that some properties have many bite chunks removed from their data and their output is incomplete. Ive used FME for over 20 years, but I me not a techy programmer. Ideally the Clipper transformer would have tick box option that says 'retain input clippees for multiple processing' or something....... All suggestions welcome. Regards 

Hi everyone,  Every time I load a reader into Workbench I get an error similar to this "Workspace generation failed. Parameter file was /private/var/folders/tr/rfmmyq590j17jq9ndl8my5lh0000gn/T/FME_1635634267372_8830."  Not sure what the issue is any help would be very much appreciated.  

I'm trying to find and replace a string from a text file where the first part is constant, then the second part of it could be anything, then the last part is a constant. I want to change some of the 'last part' text, keeping the first part + the second part (which could be anything) remain the same. I hope the highly simplified example below illustrates what I mean: Input text: This is constant Line 1 *This is anything Line 2* This is constant again and will change, Line 3Output result: This is constant Line 1 This is anything Line 2 This Line 3 has now changed Does anyone know how this could be accomplished? The files being fed in have hundreds of occurrences of the last part so the first part + second part (though this could be anything, a wildcard perhaps?) + last part search should ensure only one result. I hope this makes sense and thanks in advance!

i would like to put symbol instead of point in pdf but i have used pdf styler and it has no symbols . do we have transformer that include symbols to define some points in pdf output fme 2018 .thanks in advance

From html-text "<a alt="Molen (molenromp) information" href="/monument/53454/molen-molenromp/plaats/">" I want to grep the "/monument/53454/molen-molenromp/plaats/"-part. Therefore I use @SubstringRegularExpression("<a alt="Molen (molenromp) information" href="/monument/53454/molen-molenromp/plaats/","\\/([a-z0-9/-])*",0,0,1,caseSensitive=TRUE) but this only returns "/53454/molen-molenromp/plaats/" (so looses the first part /monument).According the very usefull site https://regexr.com/ the reg. expr. "([a-z0-9/-])*" on "<a alt="Molen (molenromp) information" href="/monument/53454/molen-molenromp/plaats/">" though results in "/monument/53454/molen-molenromp/plaats/". What do I do wrong? Attached a workbench with the conv

Hi everyone,  I'm making a workbench where I try to write to a file GDB. To be able to use a fileGBD FME needs to be able to detect a ArcGIS license.  We do have arcmap and arcgis pro, but not on the virtual machine that runs FME. Do I need to install arcmap or arcgis pro on this machine to be able to write to file GDB's ?  thanks in advance

  How could i access to topological map by feature reader format WMS ,i am not sure ,where could i find WMS URL https://danord.gdi-sh.de/viewer/resources/apps/Anonym/index.html?lang=de#/ and another point also i would like to know:After reading the topological map .could i have acess to color ,if some lines or specific color in topological map that i do not want to show,what should i do ? i would like to read the four choice at this site.FME 2018 ,thanks in advance

I am trying to connect to an Esri vector Basemap through the REST Endpoint but am having difficulty setting up my workspace. Has anyone had any success with this as of yet? I was able to do this with a JSON filter on the older raster basemaps, but cannot do the same for the vectors basemaps. I am ultimately trying to pull imagery from a specified extent.  Here is the URL of the endpoint in question:https://basemaps.arcgis.com/arcgis/rest/services/OpenStreetMap_v2/VectorTileServer?f=json Any assistance with this would be greatly appreciated!