FME Form

Hell FME Community, i am trying to write the data into existing Oracle Spatial Point Cloud table. However, the translation fails with the following error: "ORACLE Writer: writing the point cloud failed because it has 3 extent dimensions, but the table 'AHN_BLCK' column 'BLK_EXTENT' contains data with 0 extent dimensions. The number of dimensions must match for all point clouds in a table."The "BLK_EXTENT" column has the SDO_GEOMETRY data type.Does anyone have any ideas? Best regards

Hi, I have two lines I would line to join together. However they do not intersect with each other so I can't use the line combiner. The lines are 3D and I want to preserve the dimensions so a neighbour finder might not work because that is 2D They are lines along the centre of a rail line but there is a small gap (see picture). I would like to join it so that it forms one line. The direction of the lines is the same. If anyone has any ideas how I could do this I would be very appreciative Thanks

Building a brand new Windows 2019 Server, with FME Server 2022.2.5. If we have workbenchs that write to SQL Server 2017 standard edition which ODBC Drive do we need (if any). My old server uses SQL Server Client, but my DBA says:SQL Server Client was announced as deprecated and isn't recommended to be used. ODBC driver is the one to be used.

Getting repeatedly the geometry object as delta on multiple runs

An example would be a spreadsheet with 2 columns such asNeighborhood activityA RepairB InstallA RepairB Remove Ideally, I could get output grouped by Neighborhood (A and B) and show the Activity values as column headers such as Neighborhood Activity.Total.Count Repair.count Install.count Remove.countA 2 (activities total) 2 (repairs) 0 (installs) 0 (removes)B 2(activities total) 0 (repairs) 1 (installs) 1 (removes) Should I expect to be able to do this with FME Statistics Calculator? If I need to use a parameter, I don't know how.. Any guidance would help.thanksJim

FME Desktop - How to Read Non-Spatial Oracle Update Trigger to Update a Spatial SQL Feature Class

hello everyone I got a 3d shapefile of buildings and I want to convert it to a citygml fine with LoD1 what is the workflow that I should do and here is my shapefile? thank you

I am currently working with about 60 towns (folders) on AGOL which all contain 10+ feature layers. The data is read from all these layer (reader per layer), compared with data in my db, then the data is updated/inserted/deleted in our db.  After this, let's say some work is done on the db data . I then have another workspace which is writing the updates back up to AGOL for the same town. I currently have 2 workspaces per town which take care of all the reading/writing/processing for all the layers. This has resulted in 120 workbenches which, when an update has to be made to the way data is processed, I have to go back and update all of those workspaces. Also more towns are being added every week so the number of workbenches is increasing.  The screenshot below is taken from one layer where data is read from both AGOL and the db, compared and then written out. I have a section like this for every layer where the processing is largely the

I would like to extract things like concrete driveways, road surfaces, any other hard surfaces, to calculate areas. The Rasters I have, are taken several years apart and would like to calculate the change in surface areas.

I'm trying to get the last 8 Job ID workspace details and I'm using an HTTP caller and string searcher. Can anyone tell me where I'm going wrong? Httpcaller Setting String Searcher

Hi All,I have a polygon that I want to split by a line feature. I'm rather surprised to find out that there don't seem to be any tools that do this, or at least, none I've found yet. There are a lot of questions about this, but no consistent answers, or simple way of doing it.Clipper - The Clipper feature needs to be an Area. Mine is a line.LineOnAreaOverlayer - splits the line, not the area. :-/Intersector - output is lines that don't reflect input areas nicely.So, have I missed something? Is there a transformer for doing this? This is GIS 101 level geometry handling, so I'd be surprised if there isn't, but where is it hiding?Thanks

Hi, I have a geodatabase with some feature classes. I would like to convert the attributes of each feature class into excel. How can I do that>

Hello. You don't know which transformer to use. I tried testfilter, but there you can't combine two lines and featuremerger, it's also not quite ideal. I need to filter data in a database with a condition:- all data with the same uuid- a point that has the same value of validfrom and validtovalidto changes to a value of -1 second downThe result should be validfrom 20220908000000 and validto 20221005235959 in the first lineIn the second line validfrom 20221006000000 and validto 99991231235959Thank you very much.

I have a pretty basic workbench with a HTTP Caller which processes the downloaded data to insert. When I open the Workbench it works perfectly. I preset all the input parameters so I do not need to pass them into the model. However when I try and run the workspace from command line, specifically in Jenkins, I use the following command:"C:\\Program Files\\FME\\fme.exe" "\\\\xxx\\xxxx\\MY_MODEL.fmw"  I get the following error: HTTPCaller_4_<Rejected>: Termination Message: 'HTTPCaller_4 output a <Rejected> feature. To continue translation when features are rejected, change 'Workspace Parameters' > Translation > 'Rejected Feature Handling' to 'Continue Translation''Program Terminating Any idea what would cause the http caller to fail only when run from command line?  Any help would be greatly appreciated!

The workbench below is incomplete. It aims at checking schema of a requested GeoJON before writting data to GDB.I would like the writer to proceed only if 'Updated', 'Inserted' and 'Deteled' ports of ChangeDetector does not output anything. In other words, I would like the workbench to terminate before writing if those ports are not empty.How could I achieve that please ?

Is there a possibilty to directly read the "styling" properties of a DWG layer in FME? By styling properties I mean e.g. the color, linetype, and lineweight. I know that with the FeatureReader transformer, I can read the so-called "Schema Features". These Schema Features correspond to the layers in the DWG file (also see accepted solution at https://community.safe.com/s/question/0D5Dm000006a48rKAA/read-all-layer-names-from-dwg-files). Unfortunately, at least with standard reader options, these Schema Features do not have any styling properties associated with them: As a workaround, I could read the Data Features of the DWG file with e.g. a standard Rea

Hi;I have FME Desktop 2023.0 BETA (FME(R) 2023.0.0.0 (20230130 - Build 23226 - WIN64))The FME workbench consists of Sql reader, Geometry Replacer, and Dwg Writer.Sql reader reads a simple view from the database. Among others, the field 'autocad_entity' with the value 'autocad_insert' and the field 'autocad_block_name' with the value 'kc'. (I use those fields or fme attributes to create blocks through dwg writer). Reader reads everything correctly. After the reader comes the Geometry Replacer, which works correctly. However, after the Geometry Replacer, the 'autocad_entity' attribute has the value 'missing'. All other attributes are ok. Attributes are read from the database as varchar datatype.Thanks;

 I got the mean and standard deviation of all dataset ( mean: 0.12, sd: 2.84). And also, I got mean and standard deviation of ten sample (mean: 0.10, sd: 0.10)

Is going to be a FME Desktop 2023 version for Ubuntu 22.04? Thanks

I am trying to install the FME Desktop on my Ubuntu 20.04.1 laptop, but it doesn't work. Could you please help me to solve this problem? Thanks!

Hi,I have hourly rainfall data (observed and forecast) and i'd like to calculate a 7 day preceding rainfall total for EACH HOUR. My first thought is to use AttributeManager and adjacent features to sum the preceding 166 features (hourly rainfall totals), but it only allows up to 100 adjacent features. Any help would be greatly appreciated!Thanks.

Hi i would like to cut the data (polygone) outside the perimeter that could be line ot polygone, and keeping those inside.

Hi,  Doing an overlaps removal on polygons but I have multiple polygons that are identical shapes layered on top of each other. does anyone have any solutions for this as I cant seem to find a way to select and remove all but one of the stack, over the whole layer. unfortunately the polygons don't have any data to match them on so its all spatial. Thanks in advance.

Surface Model could not find 3 non NAN seed points I am trying to convert a .Tiff DEM to Minecraft format. Once it reaches the Surface Draper transformers the translation fails and I get the above error message.

Hello. Does anyone know how to use a transformer to change the time? I originally solved it by parsing the data via a string searcher, creating attributes and then compiling. This solution worked. It does not work for this date 20221201000000 (year, month, day, time 2022/12/01/000000 ), where I set the desired -1 second. I get 20221200999999 (2022/12/00/999999) in the output, but it should be 20221130235959 (2022/11/30/235959 ). I need a transformer that doesn't stupidly subtract -1 unit, but works with data like time. Thank you