- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form

FME Form

A space to discuss FME Form

27504 Posts

Recently active

Most replies Most views Newest first

pat_uowContributor

asked in Transformers

Create 3D voxel or polygon from rasters

Hi FMErs,I have 3 rasters of equal extents and cell size (clipped to the same 2D polygon)a) representing the floor elevation of a sub-surface stratab) representing the thickness of the same sub-surface stratac) representing the roof elevation of he same sub-surface strataLooking for tips on the best / most efficient way to create a 3D polygon in FME similar to ESRI extrude between, and assuming other strata sections are available in the same raster form , iterate through each strata section to create a 3D subsurface model.Thanks in advance

1428

8 days ago

emerson_stylesContributor

asked in Transformers

ShortestPathFinder processing time

I have a workspace that is calculating the shortest path across a network for a dataset of start and end points (joined as lines). The length of time it is taking to process the data through the ShortestPathFinder transformer is a lot and it sits as follows for hours on end: Is there a way to speed this up at all? I know I’m trying to process a large amount of data which could be the primary reason but I am curious if there are ways to perfect this process to enable it to complete much faster.

563

8 days ago

loicgueninrandeContributor

asked in Data

Geoparquet Reader on FME Form 2024

Hi @Safe !I have a probleme with Geoparquet reader on FME Form 2024. It does’t work with the file in attachment but work fine with Apache parquet on FME Form 2023. The error is :Thanks for your help.Loïc

253

8 days ago

mark2atsafeSafer

asked in General

Question of the Week: Parallel Processing in the ShortestPathFinder

Happy new year, FMEers.Our question-of-the-week was posted just a few hours before I started to review the week. It's about parallel processing and the ShortestPathFinder transformer. Question of the WeekQ) I was hoping to speed up my ShortestPathFinder calculations with "Parallel Processing", but I don't notice any speed improvements. The 2018.1 documentation says "If it is enabled, a process will be launched for each group specified by the Group By parameter." However, the most recent documentation does not mention parallel processing at all. Am I missing something? Asked here by @magnus A) Yes, there are a number of points. The first is what happened to parallel processing in 2019, the second is how to ensure parallel processing works... Parallel Processing in 2019So here's a quick refresher on parallel processing in 2019. Basically it was removed from individual transformers and retained only in custom transformers. I wrote a blog article to explain

482

8 days ago

ebygommContributor

asked in Transformers

ChangeDetector - pass attribute from original features to updated features when not one of the selected attributes

In the change detector is there any way of transferring an attribute value from the original feature to the updated feature when it's not either a Key Attribute or one of the attributes listed in the matching strategye.g.

177

8 days ago

mr_fmeEnthusiast

asked in Transformers

RCaller with problems

Hi, I have a sample R script. While the output is correct, FME is logging incorrect information. The Code: library(sf)shp_path <- Output$shapefile_pathif (is.null(shp_path) || shp_path == "") { stop("location empty or no exists.")}shp_path <- normalizePath(shp_path, winslash = "/")if (!file.exists(shp_path)) { stop("location not found: ", shp_path)}print(paste("read shapefile:", shp_path))shape_data <- st_read(shp_path)if (is.null(shape_data)) { stop("Error in shapefile:", shp_path)}shape_data$ano <- 2025output_path <- shp_pathprint(paste("Writing:", output_path))st_write(shape_data, output_path, delete_layer = TRUE)print("Success.") Log below: Error in utils::read.table(value, sep = sep, header = header, skip = skip, : no lines available in inputCalls: dbWriteTable -> dbWriteTable -> .local -> <Anonymous>In addition: Warning message:In file(file, "rt") : file("") only supports open = "w+" and open = "w+b": using the formerExecution haltedFailed to

675

8 days ago

petergoedbloedContributor

asked in Data

Flow can't access template files

Hi All,I have been building workspaces that get data from an api and write that data to Excel, using Template files. FME Flow can’t access the location of the template file, so what I did was: Make them a published parameter and publish. Then once one Flow, I change the parameters to the Flow resources path where I uploaded the template file as well. I do this in the Workspace properties. However, this doesn’t work, when running the workspace, the log says it can’t open the Template File and still pointing to the old/local location of the template file.What would be the right workflow here?

163

8 days ago

mstContributor

asked in Transformers

How to write scientific e notation number as a decimal real number to .CSV

I’m using an FME FeatureWriter to read a content of an Excel file containing various values, including decimal numbers, some of them small with more then 5 decimal zeroes.The FME, apparently, handles these small numbers using scientific e notation.After processing the data, I write it into a CSV file using a FeatureWriter. The problem is, that the small numbers are written in their scientific notation form, and not as real decimal numbers. This is causing an issue further down the line.I tried various things to force the FME to write the numbers as decimals:forcing datatype of the affected attributes in the FeatureWriter to Decimal or Real using AttributeManager to change the datatype of the affected attributes to Real, Decimal and even String forcing the datatype of the affected attributes in the FeatureWriter to String changing the datatype of the affected cells in the Excel file to TextNothing helped.I tried to find a String or Math function that would achieve that, but I’m not sure

693

8 days ago

aaronp_osniContributor

asked in Data

Using lists efficiently

Hi folks,I’m hoping this is relatively straightforward and I’m making this more difficult than it seems. I’m collecting images in the field and trying to store the images as blobs in a database. There can be up to 6 images for each property. In the below example only 3 images were collected. I’ve got to the point in my workspace where I’ve joined the images (as blobs) to the survey data, but I’ve got 3 features instead of one. I have a unique survey id. How do merge the data so that I have one feature, with up to 6 images stored as blobs? I’m trying and failing to use lists in the most efficient way possible; via the Aggregator then List Element Filter, then somehow bring the data back together, but this is the point I’m stuck on. Any help is greatly appreciated. Many thanks,Aaron

252

8 days ago

vxn43Supporter

asked in Transformers

Update spreadsheet using FeatureWriter?

Hello,I am attempting to use the FeatureWriter to update a spreadsheet. From the screenshot you can see I have Addresses Input into which is pushed 3 updates and 95,393 from the original spreadsheet. The Output port, Addresses adds the 3 records to the original spreadsheet making for 95,396 records. Is there a way to get FeatureWriter to update the spreadsheet so the output is 95,393 with the 3 records in 95,393 updated not added to the output? The FeatureWriter is writing to the same spreadsheet in the Addresses Reader.

281

8 days ago

thierryContributor

asked in Transformers

autocad_color in autocad_OD writer

Hello,Do you know why autocad_color parameter is allowed from 0 to 256 for Autodesk Autocad DWG/DWF writer but is strictely limited to 1-255 for Autodesk Autocad Map 3D Object Data writer ?It prevents to write entities with ByLayer (256) or ByBlock (0) Color parameter in addition with OD tables

342

8 days ago

jacintasomersContributor

asked in Transformers

FME 2024.1 SharePoint Reader

I have a workspace created in 2023.2 that reads an Excel workbook from a SharePoint library. It is working perfectly.I have upgraded to 2024.1 and the reader no longer works as expected. If I use the 2024 Data Inspector I can connect to the workbook and see the data. The FeatureReader obtains the schema and the number of records in each sheet and gives a “Translation was SUCCESSFUL” in the log. The issue happens after that - I get some sort of (possibly) Python related error. Log file of messages after the successful log entry is attached.I have tried changing the Python version but it didn’t make any difference. Has anyone had the same issue or any ideas what I could try to get it working again.

687

9 days ago

syedh2993Contributor

asked in Integration

Error Handling in FME - Retry running workspace

Hi Team,I am new to FME and would appreciate if you could help me by giving some tips on Error handling in FME, Below is my scenario,My FME application reads the data from Database and writes to arcGIS Feature layer. Application overwrites the data to feature layer everytime it runs.If application fails for some reason, is there any transformer (or any other method) to retry running the workspace again or add some kind of Try/Catch mechanism?Below could be possible error scenarios in my application, 1) Error connecting to Database 2) Error occurred during transformation 3) Error occured writing to arcGIS Online Thank you in advance,Regards,Syed

372

9 days ago

louiseboyceParticipant

asked in Integration

Python FMEObjects Missing DLL files

Hi - I am hoping someone can help.Apologies in advance for the long message.I am using FME Workbench 2022.2.8.I am trying to set up a workspace that has three readers (using a SQL database that retrieves data from three separate tables) connected to a PythonCaller and then a feature writer (connected to the Python caller) that writes the data back into a SQL database.I need all the readers to have finished before the PythonCaller is executed as it uses all of them in the script.I initially tried to run this using the built in Translator Python3.9+ but every time I did It said no module named pandas.I attempted to configure my own python.exe that I have as part of anaconda navigator (2024.10.1).I created an environment called fme_env and set the Python version to 3.9.I was able to successfully set up all this, but I encountered the no module called FMEObjects error.I went into my FME installation path and there was a folder called fmeobjects and inside that there were several version bu

312

9 days ago

scootercat_nlContributor

asked in Transformers

How to change data in GEOMETRY column

I have a SPATIAL table with the following columns: X_coord, Y_coord and a SPATIAL column GEOMETRYThe X and Y coordinates are adjusted. With which attribute can I adjust the GEOMETRY columns?It has data_type SDO_GEOMETRY (Oracle). Contents of a record:MDSYS.SDO_GEOMETRY(2001, 28992, MDSYS.SDO_POINT_TYPE(201234.5678, 47123.4567, NULL), NULL, NULL)

342

9 days ago

mralex007

asked in Transformers

How to close open volumes after a clipping transformation in Workbench 2022?

I used Workbench 2022 to clip buildings (composite surfaces) onto an area with the clipper transformer. The buildings at the clipper boundary however are open geometries (refer to screenshot). How can I insert closure surfaces to each boundary building to create closed volumes?I tried to coerce the composite surfaces to a solid and coerce them back to surfaces after the clipping, but the method is not reliable, because most of the solids become faulty. Is there another solution? Best regardsAlex

234

9 days ago

marta.podsiadSupporter

asked in Data

Save polygon as gpx

Hi,I’m trying to save a polygon as a GPX track and am running into an issue. Here’s what I’ve done so far:Converted the polygon to a line using GeometryCoercer Reprojected to EPSG:4326 Created track_id, source, and name attributesThe translation completes successfully, but when I try to open it, I only see the attributes and no geometry. Any idea what I might be doing wrong? 2024-10-29 11_22_11-Window.png

836

9 days ago

ecxContributor

asked in Transformers

JSONFragmenter "Prefix New Attribute" not working. Bug or my fault?

Title says it all, Basically I have a workflow:Adding a prefix to the new attribute results in the new attribute not to have any values.Running with prefix:Running without prefix: Also if I add a prefix, for example _, and have a new field I wish to extract, i.e. “ID” which should result in a new column “_ID” with values, it instead replaces the original id field with the new values, totally ignoring the requested “_” prefix. Workaround is to rename the original values with a prefix before extracting second set of values from nested json.

242

9 days ago

mandyvanrossContributor

asked in Transformers

Calculate Geometry and export an image

I have a workbench where I am reading data from a SDE looking for rows updated in the last 7 days then exporting to an excel file. That is working well. I’m also using mapnikrasteriser to create a map and export a tiff image however the new records have no geometry defined so won't show up on my map. What would be the best option to calculate geometry for those new records?

8811

9 days ago

martinkochSupporter

asked in Integration

How to work around an ssl-verification error when using the ESRI Portal reader

Hello all,At a client I often fail to connect to their ESRI Portal, due to failing to verify SSL (see loggin below) on both FME Server and desktop.Proxy settings in FME don't change the behaviour (always uses proxy). The Chrome browser thinks the certificate is o.k. I can't disable ssl-verification in the Portal Reader, as suggested in the log, like it is possible to do in the HTTPCaller.. (see my idea for that). Inspired by this reported problem I exported the certificate from Chrome, and imported it in $FME_HOME\jre\lib\security\cacerts on desktop.. (analogue to these instructions for server, section .pfx certificate, as the problematic server has a .pfx certificate).This did not resolve the problem...Does anyone have any suggestions??? Kind regards,MartinArcGIS Portal Feature Service Reader: Using proxy http://proxy.####.intern:8080/ArcGIS Portal Feature Service Reader: Using authentication type 'NTLM'ArcGIS Portal Feature Service Reader: Logging into 'https://geoportaal.####.intern

2163

9 days ago

alambertContributor

asked in Transformers

Some attributes refuse to be exposed in JSONFragmenter

I’ve successfully exposed a dozen attributes (see green check marks). Then something changes in the source JSON not allowing me to pull “records.number” and others below “records”. What’s different? Thank you!!

485

9 days ago

jokerfmeContributor

asked in Data

Writing Data into an Arcsde Geodatabase ?

Hello , this is my first post , and I hope to receive an answer I have in FME an ESRI license that allows me to read from and write to an Arcsde geodatabase . I'm interested in knowing if anyone has successfully edited specific feature classes , made modifications in a workspace (such as adding data , deleting data or moving points to new positions), and then writed the output back to the the same feature classes after editing by ArcSDE geodatabase writer.After editing and modifying the data, I understand that in ArcMap, data typically undergoes compression, tracking which data is added and which is deleted.Is it possible to write the output directly to these compression tables ? Is this step necessary to do by FME ?Second question : about writing into Relationship classes I read an article https://support.safe.com/hc/en-us/articles/25407490028813-Writing-Geodatabase-Relationship-Classesthat uses an XML workspace as a template for writing to relationship classes, but I didn’t f

FME server workspace not sending emails as failing to find attachment

Keeping getting the following error message - Overdue_Emailer: The file 'C:\\ProgramData\\Safe Software\\FME Server\\repositories\\GIS\\Test send Email/Overdue.xlsx' could not be found. It is required to form the content of the attachment Overdue.xlsx Works space created in workbench and published to server. Works fine if a run from workbench and I can see the .xlsx files that are the attachment in fme server repository but still getting an error

695

10 days ago

rzel24Contributor

asked in Authoring

FTPCaller in FME Flow

Hello,We are using FTPCaller to connect to our SFTP Server via OpenSSH Agent as per the instructions in this article:https://support.safe.com/hc/en-us/articles/25407554321805-Using-a-Private-SSH-key-with-FTPCaller-to-Authenticate-an-SFTP-Connection-for-FME-Form-and-FME-Flow-on-Windows-Systems The authentication is not a problem and we are able to log into the SFTP server, but we are having problems downloading files with spaces in their names, we are trying to download a file named:LB Daily Course Raitings_202409130404.csv the URL set up in the FTPCaller is:sftp://sftpip:2222/Test_Folder/LB Daily Course Raitings_202409130404.csvWe keep getting the error that the file does not exists, we know the issue is dealing with the spaces, and have tried downloading a files without spaces and it works fine. We’ve also tried all sorts of scape options to cancel the spaces in the URL but we get the same error indicating the file does not exists.We’ve also tried to use LB*.csv as the name but same e

10 days ago

jacklonsdaleContributor

asked in Data

Excel Reader showing formula values as missing

Hi all,As part of a development of some routines, I have created a many tab excel file where i inserted Formulae using the AttributeManager and the Cell.Formula naming convention. Due to the nature of the VLOOKUPS i used (dynamically i suppose), i could not do this calculation in FME's Arithmetic Editor.Opening the excel sheet shows the values i do want, given by the formula in the cells. However, when i now come to read this sheet in my next routine, the values are all shown as <missing>. Has anyone encountered this before or have any ideas?Thanks all, kind regards,Jack

8513

10 days ago

1
2
3
4
5
6
7
...
1101

Page 4 / 1101

Badge winners

kylerogershas earned the badge FME Form Basic Training
hirooimakihas earned the badge Welcome Back
lucarasohas earned the badge Welcome Back
kelwishahyhas earned the badge Welcome Back
rbrownhas earned the badge Student (Grey)

Show all badges

30,061: Posts

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

An FME Account is required to contribute

Login to the community

An FME Account is required to contribute

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.