- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form

FME Form

A space to discuss FME Form

27718 Posts

Most replies

Most views

Newest first

epro_adminContributor

asked in Transformers

Convert character field to date/time in csv

Hi FME community,I am still fairly new to FME. I'm getting stuck with date/time fields in csvs and excel documents. I've attached the field I'm trying to convert into DD/MM/YYYY HH:MM (%d/%m/%Y %h:%m ?), but it writes out empty if I try the DateConverter or AttributeManager> Text editor > DateTimeFormat. It's likely I'm using the transformers incorrectly. Is anyone able to point me in the right direction?

1080

1 year ago

checcosisaniContributor

asked in Authoring

Error run woprkbench FME academy Workspace Prototyping

Hi when I run the exercise-workspace-prototyping.fmw I received this error can you help ? thx Francesco

Hello, we have a SDE-Reader with an integrated "whereclause". The data themselve has string-values with mutated vowel (ä, ü, ö), which could be a value for the whereclausee. In that case, the reader execute no result. Any idea?

100

1 year ago

spidermanContributor

asked in Transformers

How to Combine multiple lines together that connecting to eachother and has only increment with 1 from other id

Hello ,I have multiple lines connecting to each other in shape file and each multiple lines has different id with increment 1 ,as example : multiple lines include id ‘s : 250 ,251 ,252,253 ,….and different multiple lines include id ‘s : 4090,4091,4092,4093,….I would like to combine the lines together that connecting to eachother and increment with one from others id my target : to convert each multiple lines that looks like square to polygon and also the street lines to be together as seperate another polygon . i am not sure how to achieve that,so i have thought that may be i combine id with increment 1 , i hope if someone has idea ,let me know please FME 2021Thanks for help

620

1 year ago

jelleContributor

asked in General

Put zip file on FME Server with REST CALL

I want to put a ZIP file on FME_SHAREDRESOURCE_DATA using the FME Server API: The file gets copied, but the ZIP file becomes smaller and corrupted. Even a ZIP file of 1KB. Any ideas why this happens? I've tried on two different FME Servers, since I thought it would be the server configuration. If I do the same with an XML file or a TXT file, regardless the size, it works well.

How do I create some kind of loop to retrieve all the data I need from an API?

The request URL looks like this:https://reportapi.application.com/dashboard?from=YYYY-MM-DD&to=YYYY-MM-DD&state=XXXXXX&api-version=1.0 How can I create some kind of setup (or loop) where I can easily retrieve the data from an entire year per month per state? The data itself doesn't have some kind of timestamp, so I'll have to retrieve each month separately. So for example:2022-01-01 till 2022-01-31 for Ohio2022-01-01 till 2022-01-31 for Florida2022-02-01 till 2022-02-31 for Ohio2022-02-01 till 2022-02-31 for Floridaetc...

1 year ago

vladimirb777

asked in Transformers

Convert Date of Birth attribute to an Age attribute

In the attribute manager, I would like to create a new field called ('Age') and calculate the attribute value from another field called 'Date of Birth'. This is within an automated process that will be run multiple times a month, so I need it to take the time that the process is run and use that for the age calculation. How can I do this? This is my attempt at this : (GETDATE() - @Value(Date of Birth)) / 365 (although there is no GETDATE function as far as i'm aware of.) Thanks in advance!

810

1 year ago

stuarmitagehomeContributor

asked in Transformers

Snipper Transformer - why won't it always snip from both ends of a polyline?

Hi,I have a rail network, featuring multiple polylines. I need to snip 50m from the ends of each line.Using the Snipper transformer, I use the Distance (Value) mode. The Starting location is 50, the Ending Location is the length of the line -100 (accounting for the 50 already removed at the Starting Location... maybe?!).The results are mixed: A dead straight line has 50m removed from each end, this is what I want.Any other shape of line only removes the starting 50m, but NOT the end, as shown by the red "X" below. The blue lines indicate the Remnants.What am I doing wrong? Can anyone help please?

684

1 year ago

aronContributor

asked in Transformers

Reposition overlaping labels

I have an existing dataset with labels where I want to increase the font sizes of all features. This of course results in overlaps in places, and I am trying to figure out if parts of the repositioning could be automated with FME. What I have is the original placement and sizes of the labels. I would like to use these placements as starting points, increase the font sizes and then move anything that starts to "entangle".I have read up on the MapTextLabeler, as best I could. It should do what I need. But it comes at a price, I don't know how steep, and I only need parts of what it offers.Has anyone had any success building a workspace that spaces stuff out? My thoughts are:1. Create bounding boxes from the label, sized in ground units.2. Check if any of these are "to" close3. Move those in need further apart.4. Check to see that no new overlaps have occurred. No 3 above would be the trickiest one me thinks. The repositioning distance would need to be calculated

1170

1 year ago

pratapContributor

asked in Transformers

Merging Raster and Vector with Transparency

Hi All, I have kml and image as input files. The requirement is to generate another image by merging both. I have merged both and able get the raster, but I'm not getting transparency in the area within the polygon.I have attached pdf file of requirements and workbench for better understanding... Thank youPratap

430

1 year ago

aronContributor

asked in Transformers

Set RasterCellValue from attribute?

I have a raster that gets cut up to smaller sections in a clipper. Within these sections the cell values need to be identical. I have used a RasterStatisticsCalculator to get a mean value for each section. But how do I write these to the cells? My guess is that there is a step missing in my workspace below where the attribute need to be "written down" to cell level? Unfortunately I can't find a transformer that does this. I might ad that I have tried a different aproach where I wrote the mean values as a new band, and then removed the old one. This got half the job done, unfortunately, it also overwrites null values. Which means I end up with bounding boxes around everything, and corresponding stray values.

100

1 year ago

albnas

asked in Transformers

Conversion from KMZ to CityGML

I was wondering if it is possible to convert KMZ-files to CityGML? The KMZ-files contain a doc.kml file and a folder (models) which contains model.dae, model_textures.txt and a texture folder containing a .png. I´ve been searching for a valid solution but I can´t seem to find one. I have looked at the common data workflows (https://www.safe.com/convert/). Does anyone have any ideas how to solve this problem. To note: each KMZ file is representing a building, which we want to convert to CityGML so we can use 3DCityDB. Thanks

540

1 year ago

gazzaContributor

asked in General

Ideas wanted on how to create a funnel type 3D object

Does anyone have any ideas on how to efficiently create a 3D feature similar to this image?(the cut away is just to help show the geometry, it will be completely circular)I can make a cylinder by buffering a circle and then extruding it vertically but the only idea I've had so far for this geometry is to layer a whole lot of circles on top of each other and dissolve them, which is taking a long time.

730

1 year ago

pknoContributor

asked in Transformers

Aggregate into different Columns

Hello everyone,I have been scouring these forums for a solution and found a few posts with similar problems but no solution seemed to work for me. Granted that might also be due to my limited experience with FME so here I am. I am trying to rework a table from this:to this: I have been trying out transformers such as AttributePivoter, Aggregator, AttributeExploder and a few more and also tried to create colums using AttributeCreator and AttributeManager (but I couldnt get it to automatically create colums based on the unique Methodology-Codes, there is too many in the original dataset to do this by hand) I would be thankful if anyone could push me into the right direction, as I cant seem to make progress on my own here. Thank you.

560

1 year ago

arthyContributor

asked in Data

How to dynamically read excel files with different worksheet name?

I want to read sevaral excel file that are inside a zip file.An excel file has the worksheest Data 1, Dat2, ... Data n and the number of worksheet varies from one file to another.For a given zipfile, I first read the schema feature using a featureReader to get the list of sheetname.Then, using a second featureReader, I read the attribute with the worksheet The problem that I'm facing now is that when I enter manuall the values filename and filepath used within the first FeatureReader, I'm able to get the reseults that I wanted. However, when I tried to read all the zip file with a python caller, the program stop and the only error that I have is ERROR RUNNING TRANSLATION.Storing feature(s) to FME feature store file `C:\Users\...\inspector.ffs'Storing feature(s) to FME feature store file `C:\Users\...\inspector.fsc'Error running translation.Creating reader for format: Microsoft ExcelTrying to find a DYNAMIC plugin for reader named `XLSXR'FME API version of module 'XLSXR' matches cur

Converting multiple files at once using FME workbench

Hello FME community, I created a conversion process(FME workbench) that converts my collada file to citygml. Now I want to be able to convert all my collada files (as many as 8000) at once but I don't know how to achieve that.Could you please let me know how to proceed ? many thanks.

1290

1 year ago

negar

asked in Transformers

Hello everyone, I have a question about the resolution of Raster I want to know, why we can not convert a raster with larger pixel size to smaller?

1 year ago

jonathanhui

asked in General

Is FME the right tool to cluster objects on a cad plan and output the clusters to files?

The attached plan is a sample of a longer street segment that was divided up so it would fit on a single sheet. Is it possible to identify and output the individual segments and output each to it's own file (like jpg). In this sample the output would be 3 image files, each containing the 3 different street segments.

1 year ago

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:

140

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?

100

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?

110

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

740

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

1
...
184
185
186
187
188
189
190
...
1109

Page 187 / 1109

Badge winners

thogerb_cmpashas earned the badge Integrate Data with the FME Platform Training
rspears90has earned the badge Integrate Spatial Data
lukasbutzmannhas earned the badge Welcome Back
lukasbutzmannhas earned the badge FME Form Advanced Training
cliffordgraves1has earned the badge Webinar Watcher (Grey)

Show all badges

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