- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form

FME Form

A space to discuss FME Form

27555 Posts

Recently active

Most replies Most views Newest first

ctmitchParticipant

asked in Integration

Reading/Executing Microsoft Access Queries

Hello! I'm working with one of our legacy systems built in Microsoft Access, and I need to extract data from a query. So far, the only method I’ve found involves using the system caller and command prompt. Are there any alternative ways to achieve this?I've tried using the system caller, but I’m encountering security issues with the runtime version. It appears that I need to set the location as trusted, but I can't do that with the runtime alone. We're aiming to avoid installing the full version of Access, so we're limited to using just the runtime.

211

8 days ago

od10Contributor

asked in Transformers

Creating an ArcGIS Pro Layer File in FME

Hello, Has anyone ever created an ArcGIS Pro layer file *.lyrx inside FME for use in ArcGIS Pro? For example, converting a *.dwg file into *.gdb, aswell as creating a layer file which holds the symbology from the *.dwg. Thanks, @Takashi Iijima @danilo_fme @Hans van der Maarel

1072

8 days ago

sharvikhawteContributor

asked in Data

Uploading raster (tif) in Arcgis online using FME

I am trying to upload a tif stored in my PC locally to the contents in arcgis online. I can upload the shapefiles efficiently but not tifs. Can someone advise? Thanks!

494

8 days ago

reservoirdogSupporter

asked in Transformers

Output Line vertices coordinates to XML (concatenated)

I have lines and their vertices should be written to XML (using XSD-driven XML-Writer).I extract the vertices coordinates into lists using the “coordinate extractor” .Now I need to find a way to output those coordinate pairs to xml, so that the output looks like this:Is there a way using the “list concatenator”?

413

8 days ago

kattContributor

asked in Transformers

use parameter display value as attribute

Good day,I have a featurewriter and I want to give the dataset the same name as the display value (and not the value itself) of a parameter for which I used a choice configuration. How can I do it ?

171

8 days ago

leif

asked in Transformers

Drone image footprint calculation

Hi, We would like to be able to calculate the real world footprint of drone images to result as a trapezoid polygon. This should be possible with only the exifdata that we get from the custom transformer "exifReader" as far as I can tell. I found a python version here, but it requires additional installation of vector3d from the python script. Anyone got a solution to calculate drone image footprints?https://gist.github.com/luipir/dc33864b53cf6634f9cdd2bce712d3d9 The custom transformer FootprintCreator promises something similar but requires a CSV-file from the camera. Anyone got a suggestion/solution? It would be a neat transformer that I think a lot of people would benefit from. We have a couple of different DJI drones.

65711

8 days ago

pmcphersonContributor

asked in Data

Warning reading Snowflake Spatial Data

When using a FeatureReader transformer to read Snowflake spatial data, the following warning is posted into the log.Snowflake Spatial Reader: Skipping data in column '.GEOG' due to error (JDBC Type = VARCHAR, Vendor Type Name = GEOGRAPHY, Error: class java.lang.String cannot be cast to class [B (java.lang.String and [B are in module java.base of loader 'bootstrap'))The process does complete normally, but the geometry is not read automatically. Has anyone else encountered a problem like this? I’m using FME Form 2024.0.1.0, Build 24202.

150

8 days ago

pknoContributor

asked in Transformers

replace substrings based on a lookup table

I am trying to find a functionality within FME that allows me to replace substrings based on a lookup table. Since I have several hundred mappings, chaining string replacers together isn’t really an option.Basically something like an AttributeValueMapper that looks at substrings instead of the whole value only or a string replacer that accepts multiple string/replacement inputs.Is there such a transformer or any workaround to do this?Thank you!

403

8 days ago

nanchuangyeyuContributor

asked in Data

How to create a Esri Personal Geodatabase whose structure is specified in an Excel table? ?

Hi everyone, I want to create a Esri Personal Geodatabase whose structure is specified in an Excel table. Is that possible? How can I achieve that?

604

8 days ago

paetzold_sContributor

asked in Transformers

Different NetCDF raster with FME than with QGIS or ArcGIS-Pro

Hello,i’ve recently worked with a raster from a NetCDF file and noticed, that loading the raster in FME gives a different raster than loading it in QGIS or ArcGIS-Pro (see Screenshots).Data can be found here: https://opendata.dwd.de/climate_environment/CDC/grids_germany/daily/hyras_de/precipitation/ My question is why? Has anyone experienced this behavior before?

294

8 days ago

marronmContributor

asked in Integration

Unable to connect to Enterprise Portal: unable to retrieve access tokens

FME Desktop version: FME 2021.2I was trying to follow this article on How to Create an ArcGIS Enterprise Portal Web Connection (OAuth 2.0) (https://support.safe.com/hc/en-us/articles/25407772142733-How-to-Create-an-ArcGIS-Enterprise-Portal-Web-Connection-OAuth-2-0)It was going well until I tried to 'test' before moving on to Step 3 and I got the following error (see also attached):Unable to Retrieve access tokenRequest to update access token failed. HTTP Error HTTP/1.1 401 Unauthorized Does anyone know what this error in referring to?

382

9 days ago

mccuneeContributor

asked in Integration

FME does not know about coordinate system `EPSG:102003'

Full error;PROJ: proj_create_from_database: crs not foundMicrosoft SQL Server Spatial Reader: Failed to read coordinate system from SQL Server because FME does not know about coordinate system `EPSG:102003'I can use 102003 in the ProjReprojector tool, but, rather than assign _FME_0 as the CRS for this table, it leaves it as unknown, which means the reprojector tool fails, and 102003 doesn’t exist for me to use in the CRSSetter transformers. How do I set the CRS in feature reader when my desired CRS is not in the catalog (note to FME: this is also a request) I tried defining a custom projection here; demos-safe-software.fmecloud.com/fmedatastreaming/Coordsys/Start.fmw?&token=01655ff804fe3b23f29a7b65568c51e81cd09691but this workbench failed in translation / does not create .prj file I can use.

161

9 days ago

kristian.aContributor

asked in General

Workspace runner skipping entries in the output

Hello people. I am having an issue that i cannot resolve. I am using the FME for 2 months now. Basically i have a workspace that performs pointOnRaster value extraction, does some calculations based on the result and writes to table/excel file/csv or whatever. Because i want to run this process over 10 000 files i created a workspace runner that loops trough a folder of *.nc files and compares them to one single shapefile containing the points. Regardless of the output format or the different approaches i've tried i am not getting the whole batch of results written in the output. For example i ran the workflow over the first 326 files and the WorkspaceRunner gives me 326 successfully processed entries. But the output file contains only 87 entries. If i run that workspace again it gives me between 67 to 90 entries but nothing close to 326. The log file doesn't indicate any kind of a problem. I've tried to do that with vector files as well, but still i am having the same issu

472

9 days ago

kattContributor

asked in Transformers

Create new attribute using parameter name

Good day,I have the following parameters in my script:AVE_AVENUEBLVD_BOULEVARDCTR_CENTREPL_PLACERD_ROADEach parameter is set up as a choice, when running the script you have the option to chose YES or NO for each parameter.Later in the script I want to retrieve the parameters for which YES has been chosen. I want to create a new attribute whose value is a list of the parameter names (keep only the letters before the underscore). Let’s say AVE_AVENUE, BLVD_BOULEVARD and CTR_CENTRE are set to YES ; PL_PLACE and RD_ROAD are set to NO. A new attribute called “address” is created and its value should be: ‘AVE’, ‘BLVD’, ‘CTR’. How can I do so ? Thanks for your help.

322

9 days ago

eric_armitageContributor

asked in Transformers

Problem using FeatureReader with ArcGIS Portal Feature Service

I’m trying to use the FeatureReader to read 3 features from an ArcGIS portal feature service layer by reading in a spreadsheet and using a WHERE clause with an attribute in the spreadsheet. The FeatureReader will connect to the service and I can select the correct table in the “Feature Types to Read” parameter. But when I try to add the WHERE clause FME crashes before I can start creating the WHERE clause. The second image below indicated the point when it crashes.I can read the full table with no problem using the ArcGIS Portal Feature Service reader. How can I get the FeatureReader to run and read the required features?

152

9 days ago

rbrownContributor

asked in Transformers

Parse Text File data into columns

I’m fairly new to FME and need help to get started on a workbench. I have a text file i need to convert into a readable format. Each line has information about a specific device and should be parsed into separate columns. The blank spaces also need to be removed. What transformer should I use? Any help is appreciated!

625

9 days ago

styx_a38Contributor

posted in Transformers

Revit BIM models to Esri Geodatabase

Hello,so far we are transforming IFC models to geodatabase feature class, which works fine so far. Unfortunately this IFC export step seems one step to many in the overall workflow and I was asked to change the workflow, so that revit project files can be used directly. As fme does have a revit reader I thought it would be possible, but unfortunately despite trying every imaginable parameter setting for the reader it was not possible to read more than one feature that did not contain some kind of meta data...but the “survey point” instead. The fme documentation also only focuses on how to export from revit to ifc and after wards use it in FME.Is it therefore impossible to transform from .rvt files to a multipatch geometry feature class in Esri geodatabases? Or am I missing something?

251

10 days ago

nickblakenburgContributor

asked in General

HTTP/FTP transfer error: 'SSL connect error'

Hello, I want to access an api (not open to public but from one of our suppliers) using the HttpCaller .Connecting to the API with postman works fine. Connecting from the same server with FME gives the error: HTTPCaller (HTTPFactory): HTTP/FTP transfer error: 'SSL connect error'HTTPCaller (HTTPFactory): Please ensure that your network connection is properly set upHTTPCaller (HTTPFactory): No proxy settings have been entered. If you require a proxy to access external URLs, please ensure the appropriate information has been entered Connecting with FME from another environment works fine. We dont use a proxy.I have changed the option: Verify SSL certificates to NO Any ideas on what could be the problem?

39114

10 days ago

pgammieContributor

asked in Transformers

Schema Scanner Date/Time Detection

I am using the Schema Scanner with a dynamic writer in my workspace and it is awesome except that it often incorrectly identifies some of my integer fields as date/time fields. If I turn off the date/time detection then my actual date/time fields get written as strings or integers. Right now I am running it with date/time detection on and then I put an attribute manager on the schema and find the ones it has incorrectly identified and manually adjust them but I feel this kind of takes away from the dynamic nature of the schema scanner. Is there a better way to do this? I wish I could tell it to ignore certain fields or specify the fields that it should look for date/time in but again that is taking away from the dynamic nature of the bench.

261

10 days ago

carmijoContributor

asked in Data

Reading ArcGIS Online Feature Service shared with the organization - not owned by the user or shared with a group.

Using an Esri ArcGIS Online connection and the Esri ArcGIS Online (AGOL) Feature Service reader, I'm unable to read a feature service that has been shared to our organization.When looking at the select form, i’m only provided my user folder and a groups folder. The feature service i’d like to read isn’t owned by me or shared with a group. Is this as-designed or is there another way to read it? Thank you

452

10 days ago

casselgardContributor

asked in Transformers

ProjectWiseWSGConnector and flat sets

HiI am able download files with the ProjectWiseWSGConnector.Now, I want to download files in a flat set, but this does not work for me.If I treat the flat set as a file and try to download it. The translation is successful, but nothing is download.And I can't list the content, because in list mode the flat set isn' visible, since it is treated as a file by the transformer.Any help would be appreciated.

172

11 days ago

aronContributor

asked in Transformers

ERROR |Cannot have multiple factories with the same name?

Ran into an error that I don't know how to approach. The full report line is: ERROR |Cannot have multiple factories with the same name. Multiple factories were assigned the name 'blablabla Output Collector' What does this mean and where should I start looking to solve this? I might ad that this error showed up suddenly. I tried to remove the most recent changes but it persists.

741

12 days ago

aronContributor

asked in Transformers

Dynamically identify features where all attributes are missing?

Is there a transformer that dynamically identifies features where all attribute columns are empty? This could be done with a Tester, but that requires the attributes to be known, and a new setup for each dataset. I was curious if it can be done “on the fly”.

563

13 days ago

marjan_nikoukarContributor

asked in Data

How to update a dataset using a change table in FME

Hi everyone,I have a feature class in a File Geodatabase that I need to update. I have two sources for these updates: a CSV file with codes of the changed features, which I should use to remove those features from the main dataset, and separate shapefiles for each changed feature that needs to be added back to the main dataset. (I shouldn’t delete and update the whole dataset, I should update the changed features only.)What is the best way to approach this in FME?Thank u in advance for your time.

735

13 days ago

fmeContributor

asked in Authoring

Generate measures on polylines with no measures attached in either coordinates or attribute table.

I tried generating measures on street segments but the measuregenerator is not calculating it right. It starts every segment from 0 instead of calculating from the end log. Any ideas how to resolve or calculate measures on segments with no measures? Thanks in advance!

574

13 days ago

1
2
3
4
5
6
7
...
1103

Page 4 / 1103

Badge winners

charisphhas earned the badge Welcome Back
hsnhas earned the badge Webinar Watcher (Grey)
hsnhas earned the badge Welcome Back
vojtechmyskahas earned the badge Welcome Back
delaneytoursihas earned the badge Student (Grey)

Show all badges

30,142: 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.

A product of

Company Products Giving Back Careers Contact Privacy Feedback

Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.