FME Form

 We're moving a database into Azure but all of the FME Azure writers assume it's an MS SQL database, and the MariaDB writer doesn't have any SSL settings.

I Have a building with itiff textured polygons. I want to convert that file in to citygml lod 2 format. Anyone please guide me. I am new to this FME.

Getting back to my little project started here after a brief hiatus... I am having trouble making a file uploaded to the 'Resources' folder using the Javascript API the input for a workbench. Using ...FMEServer.dataUpload( repository, workspace, fileObject, session, callback);I can get the file to be uploaded to here:$(FME_SHAREDRESOURCE_TEMP)/upload/MyFolder/MyWorkspace.fmw/Now, I want to use:FMEServer.runWorkspaceWithData( repository, workspace, params, callback)to process the uploaded file but all attempt to feed in the correct 'params' is failing. The workspace is still going back to the default parameters that it was published with. Currently, I'm trying this:var params = {          { "publishedParameters" : [{ "name" : 'SourceDataset_CSV2', "value" : <resourceFolderPath+inputFileName >},{ "name" : 'DestDataset_JSON', "value" : < ?????>}],  "service" : "fmedatastreaming" };Not sure  what to put for the destination value that I'm trying to capture. Javascript API docume

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 (""): The supplied value is not a valid instance of data type float. Check the source data for invalid values. An example of an invalid value is data of numeric type with scale greater than precision.]}"The workflow does write some data, up to 32,000 records into an SDE table using the ArcSDE Geodb writer (there should be 33,001). It will also run without error if I remove a portion of

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 Dave     

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 conversion.