- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form

FME Form

A space to discuss FME Form

27546 Posts

Recently active

Most replies Most views Newest first

gcarmichParticipant

asked in Transformers

Append filename field to .csv bulk import Reader

I have 15 .csv files with different names but the same fields and a total of 1406 records. They are in the same directory. I want to merge all 15 files together and append the source file name to each record. I've tried FilenamePartExtractor, FilePathExtractor, and FeatureReader but haven't been able to to get the desired result. I usually get back more records than I put in. Is there a straight forward method to append file name to each record?

Viewport rotation messes with coordinates

I am working on a workflow that needs to be able to extract plots of land from the local government's database, rotate them to face to the North, and then show the plot of land on a viewport.I found out how to make the viewport, and I found out how to rotate the plot to the North.When I open up the viewports, I notice that the coordinates have shifted with the rotation.I tried setting up the coordinates of the plot in the workflow, but these settings don't seem to be saved.Any help or thoughts would be appreciated! Example images:This is the viewport with the plots of land.What happens after rotation:The intended result:

122

1 year ago

gcarmichParticipant

asked in Transformers

Merge table to create side by side output without having to rename fields

I have a table of data. I want to merge it to itself so that the data is side by side. I tried FeatureJoiner but it lists the data stacked not side by side. I suspect this is because the field names are the same. I added a AttributeManager to one of the table inputs and converted the field names to "original field name"+2 and I get the results I am looking for.. Is it possible to perform a side by side merge on the same table without having to rename all the fields in one table? Is there a transformer that will rename automatically?

102

1 year ago

greyfox

asked in Transformers

Dear Community, i have 3 data bases (PostgreSQL). In one there are LoD2 buildings(PostGIS) and in an other the textures. I´am trying to import the LoD2 buildings Database with 3 different readers (FeatureReader, PostGIS and PostgreSQL).

Everytime I try to import a database there aren´t any informations about buildings. I also tried to look into the db through pgAdmin4, but dont even see the tables. I would like to import the data and get the data exported as CityGML (.gml) format.

Hello, I wanted to calculate RMSE between two DTMs. How can I do that?

102

1 year ago

mary

asked in Transformers

as soon as I write to geodatabase - the coordinate system goes to 'unknown'

Hi, I'm pretty new but this workbench should be straightforward I thought 🙂I have an Excel Sheet with 40 land parcels of interest that I want to display on a map. So I used a feature joiner to get the spatial information (from a spatial dataset) for these 40 land parcels based on a parcel number. All looks good. My output has the 40 polygons with all the attribute data. So then I used the EsriReprojector to project to Web Mercator Auxiliary Sphere. That's the projection used at work in ArcGIS Online. All looking good in the data inspector. Polygons look good, attributes look good, coordinate system is what I want. no errors in FME. However, THEN the problem starts. I can write this to a geodatabase, but the coordinate system disappears and becomes UNKNOWN during this last stage of writing the output. So, suddenly the coordinate system disappears. I just wonder if this could be because of my FME version (2018.0)? Or am I doing something wrong. Because it all seems strai

685

1 year ago

hanshContributor

asked in Data

I'm trying to write a group of rather simple geometries to ifc. No matter what I do the geometries are not read as geometries from the resulting ifc file, even though the structure of features -> aggregates -> traits looks the same.Where am I g

I have followed the tutorials available and also tried following other questions on the forum on this topic. Workspace template with data cache included.

1 year ago

robshawuk

asked in General

Combining and extracting values from multiple netCDF files

I have 12 netCDF files downloaded from https://data.ceda.ac.uk/badc/ukmo-hadobs/data/insitu/MOHC/HadOBS/HadUK-Grid/v1.1.0.0/1km/tasmin/day/v20220310. Each contains 1km-1km grid values of the minimum temperature for each day of a specific month. I would like to create a single combined file that counts the number of days where the temperature was below zero. I've tried RasterExpressionEvaluator but I can't get it to generate anything sensible. Can anyone help please?

376

1 year ago

spidermanContributor

asked in General

I would like to extract the string name of path in attribute

Hi , i have path file name in attribute C:\\*\\*\\*\\filename.dwgi would like to extract only the (filename.dwg) Please , I want to remove C:\\*\\*\\*\\Thanks in advance

Clipper bug in 2022.1 version

Hello FME community, as I work a lot with raster data and File Raster Geodatabase, I noticed in the 2022.1 version of the FME desktop version that I can not clip raster data (aerial photos). Both the transformer "Clipper" and the option in the reader "Use Search Envelope" do not work. Neither as TIFF nor as raster GDB. In the 2021.1 FME desktop version it works without problems. Does anyone know the problem?

1075

1 year ago

ablock2489

asked in Transformers

I have Nonspatial data which is a excel table and I brought in spatial data in another feature class. they have the same site name attributes i want to pair to come up with a geometry. Question is what tranformers should i use.

im thinking the feature merger but my attributes are not merging

171

1 year ago

giuseppecfgeo

asked in Transformers

To read and modify property set data in IFC

Hey community! How can I read and then modify property set data in an IFC?Which transformer should I use? How can I read the IFC in the most correct way for my goal? I cannot read thE "IfcPropertySingleValue".....

Using AttributeManager to update attributes in the Writer from matching records from the Reader. Takes a long time. 6 hours for 86,000 records. Is this normal?

Using AttributeManager to update 86,000 (existing) records using APN for key. Is this process optimized by FME? It takes a long time, and I assume it is N*N time. (Does the Reader iterate through each record, one at a time, then searching through all the records in the Writer to find the matching key?)

512

1 year ago

bigclyde

asked in Transformers

We are about to install Server for the first time on a dedicated virtual machine. Since our subscription now includes floating Desktop licences, does it cause any problems to have the Desktop licence manager installed on the same box? Thank you

1 year ago

jcmichelsen1

asked in Transformers

Autodesk AutoCAD DWG/DXF Reader to OGC/Google KML Writer question

I have an AutoCAD drawing containing points, lines, polygons, and text layers. I want to do the following: have the actual AutoCAD text values in the kml file and set the yellow push pin icon for text features to null or no icon.

151

1 year ago

marta.podsiadSupporter

asked in Transformers

Customise map in HTML Report

Hi,I am struggling to change the color of polygon, line and point as well as popup and labels on map included in HTML Report. It seems like an easy task but I am struggling to find a solution. I assume my questions are:How to change the colour of polygons, lines and points on the map base on the value of the attributes?How to edit labels and popups so they have different values? I have followed the instructions from Add Conditional Coloring to Map section of How to Customize HTML Reports (safe.com). Unfortunately, suggested method is not what I am looking for. I have attached my workbench. Thank you for all suggestions.

i need to find number of time same value in particular list

1 year ago

rylanatsafeSafer

asked in Integration

Are you currently using the FME Server JavaScript API?

Hello to all the members of the FME Community!We would like to know if you have any applications or workflows that are currently using the FME Server JavaScript API. It is no secret that we have not prioritized enhancements or upgrades to the library, and, if at some future date we decide to deprecate support of the FME Server JavaScript API, we want to make sure that we have provided alternatives to keep your apps and workflows running when you upgrade. What are you using the FME Server JavaScript API for that you cannot do with the FME Server REST API?We have started development on V4 of the FME Server REST API, and this would be a great opportunity to add new capabilities so that there is a smooth transition path available. What impact would the deprecation of the FME Server JavaScript API have for you and your organization? If there are any questions or concerns, we can start thinking about them now. Note: Please keep in mind that we do not have a target date to deprecate the FME

Issues passing JSON to a webhook via AJAX HTTP POST request

Hello again everyone, I have a question for anybody who's worked with passing JSON data in the body of a POST request for a webhook. I am working with a developer on a script to call FME server from an outside application and pass the needed JSON data in the body. She is using an AJAX script that looks somewhat like this: $.ajax({ url: <my server url with webhook token>, method: 'POST', data: {"A":"1", "B":"2", "C":"3", }, dataType: "json", success: function (response) { alert(JSON.stringify(response)); }, error: function(data, errorThrown){ alert('request failed :'+errorThrown); //document.getElementById("response").innerHTML="Failed"+errorThrown; } }); Here's the thing: I have a

2385

1 year ago

jbradforContributor

asked in Data

Limitations with The Google BigQuery Writer (FME Desktop Package)

Unable to get the Web Service to Authenticate (redirect url)BTW, we are no longer allowed to use our personal accounts for Auth, therefore we have Service Account files we use. Therefore, unable to create a Web conn either. Only way I can create a writer is to select Service Account file and define the table myself. Then I preface the writer with a PythonCaller to get the creds.When defining a NUMERIC in the writer, does not allow me to specify width/precision. Any updates to this writer planned soon?

130

1 year ago

clairecoContributor

asked in Transformers

Quelle est la syntaxe pour exclure des entités dans un reader ?

BonjourJe souhaite à la lecture de ma couche commune, exclure les communes d'une dizaine de département identifiée par leur nom ?Merci

How to use Environment Variables in User Parameters ?

Hello,I'm working with FME Desktop 2015 with a WorkspaceRunner transformer calling several workspaces where i have to use an environment variable in the path of some private variables.For example: %ENVIRONVAR%\\dat\\myfile.txtThe problem is that the called workspaces don't recognize the value of the environment variable defined by the Windows System. I have tried to assign the value to the environment variable inside the workspace but it is not a good solution in this case because every PC could have a different value.Is there some example about to do solve this problem?Many thanks in advance!A.

37115

1 year ago

franco69Contributor

asked in General

Multiple PDF Fanout and pdf_name

I have pdfs with multiple pagesi have to split them up by a certain textstring (e.g. SS 66,16)This textstring is always nearly on the same coordinate on the page, so i can isolate them and write the text in a new attribute but how can i fanout them that i have all content right from one page (e.g. pdf_page_number 2) and the pdf is named after that textstring (SS 66,16.pdf) Greetz and cheers Franco

185

1 year ago

rzrncParticipant

asked in Transformers

Write varbinary type to SQL server non spatial writer in FME Workbench 2022

In the workspace I have a geometry extractor transformer, which outputs OGC Well Known Binary format.After geometry extractor, SQL server non spatial writer follows. In the writer, the WKB field is defined as the varbinary (width 8000) type.In an SQL server database, this field is defined as a varbinary (MAX) data type.All translations went smoothly in the latest FME Workbench 2021 version.However, in version 2022, it does not work. I tried different data type combinations for sql server writer and for database, however without success. 1. casewriter data type: database data type:varbinary (8000) varbinary(MAX) Microsoft SQL Server Non-Spatial Writer: Attribute 'abc' of feature type 'xyz' has specified type 'varbinary(8000)', but existing database table field has type 'varbinary_max'. Information may be lost during conversion.Microsoft SQL Server Non-Spatial Writer: Attribute data '\\x01\\x03\\x00\\x00\\x0\\x95\\xAC!AR\\xB8\\x1EU\\ ... ' too la

577

1 year ago

pehrsContributor

asked in General

How can multipoints read from FME in the writer plugin

We have an IFMEFeature from type FME_GEOM_AGGREGATE.The window "Feature Information" in FME Desktop displays the IFMEMultipoint property with 299 parts of IFMEPoint.How can we get these multipoints in the writer plugin? If we call feature->numCoordinates() we got 598 but if we call numParts () or numVertices() we got the correct number of 299.And if we call feature->getAllCoordinates() we got a list of 598 coordinates, but only 299 of these are correct and the other ones consists of a point with coordinates (1, 1, 0). Where does this point (1,1,0) come from?The list of coordinates starts with1,1,0valid point1,1,0valid Point1,1,0....

122

1 year ago

1
...
177
178
179
180
181
182
183
...
1102

Page 180 / 1102

Badge winners

verohhas earned the badge Teacher (Grey)
verohhas earned the badge Welcome Back
aaronhas earned the badge English Speaker
aaronhas earned the badge Welcome Back
spalroberthas earned the badge Student (Grey)

Show all badges

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