Skip to main content
  • EN

FME Form

A space to discuss FME Form

10000 Posts
V
vral
asked in Transformers
Start and end latitude and longitude to snap onto network dataset and return line geometry

I have a csv with start and end lat longs and other attributes like road name and road number. I want to snap it to the route (road network) polyline dataset based on matching attributes (road name/road number) and then generate the line geometry of that road network from start to end coordinates provided.  Is this possible to accomplish in FME?  

191
featuremichael
Enthusiast
W
walle_tsa
asked in General
Hi, I'm trying to understand the PointCloudSimplifier transformer.

 I have tested it on a small piece of road scanned with mobile mapping. The road surface is very dense. But when I run the Simplifier the points on the road is not even touched. See attached screenshot. The orange points is the removed points.What settings should be used to simplify the road surface?

320
featuremichael
Enthusiast
LizAtSafe
Safer
LizAtSafeSafer
asked in General
[Megathread] FME Desktop 2023.0 Beta - Feedback and Discussions

Hello FME Community. We are trying out something new with a Beta Megathread!  With the release of the FME Desktop 2023.0 Beta, we'd love to get your feedback on any of the new features. Download the Beta and test it out.  Use this thread to provide feedback, report minor bugs, or even start a discussion. If you've submitted another question or a new idea related to FME 2023, add the link(s) to the comments. If you do find a production-impacting bug, please create a support case.  See the Change Log for up-to-date information on what is new, updated, or fixed.  Note that Beta builds can be removed from the downloads page at any time, and new features may be removed in a build without notice. Please do not use a Beta for production. For more information on FME Betas, see the FAQ.  Once the FME Server 2023 beta is available, another Megathread for FME Server will be published and linked here.  Happy testing!

2380
chrisgoodman
Contributor
gogopotter90
Contributor
gogopotter90Contributor
asked in General
How to convert file geodatabase to arcsde ?

Hello ,How to convert file geodatabase to arcsde ? thanks in advance FME 2021

100
hkingsbury
Celebrity
abnan0001
Supporter
abnan0001Supporter
asked in General
Writing issue after Date time convertor

Hi FME Community..Need your guidance , I'm receiving different dates in a particular column called "date_1" total records 401 including null when im using date time convertor to standardise it , Give me all null values to that column..Need expert GuidanceI have attached the templateThanks

82
abnan0001
Supporter
gis.analyst
Contributor
gis.analystContributor
asked in Data
Reprojecting DWG files with Pipe Network features in it

I want to reproject DWG files with Pipe Network features from UTM Zone 17 NAD83 (Original) to MTM 10 NAD83 CSRS  using ON83CSv1.gsb.when I use ArcGIS data interoperability and EsriReprojector, it reproject all feature except Pipe Network features.is there any sollution for it?

362
gis.analyst
Contributor
abysmal-ukulele
Contributor
abysmal-ukuleleContributor
asked in General
How to Parse out Json data -- getting Key Value pairs to into separate attribute fields.

Hello,I have a json response body that I am trying to get into a table. Using the JSONFragmenter I have gotten each record to populate as a different fragment. I have a long string with all the key value pairs. See below, {"ActualFinishDate":"2023-06-01T18:00:00Z","DateSubmitTo":"2022-05-02T13:37:46Z","Description":"FLT - Service Requirement","InitiateDate":"2022-05-02T13:37:46Z","StatusDescription":"Completed","WOCost":0,"WorkOrderId":"3006845","Comments":null,"Instructions":null} Now what I would like to do is create a table that would have each of the value keys as an attribute column and to have that tabled filled out with the corresponding data.  What would my next steps be?     

11305
abysmal-ukulele
Contributor
michael_m
Contributor
michael_mContributor
asked in Transformers
Trying to use AttributeValueMapper to set one column's value based on the value of another column but it is not working. I can use it to map single values but I need to do it with ranges of values.

I am able to use AttributeValueMapper to translate single values (ie if col1 == 1 then col2 = 'A') but I need to get it to map ranges of values, something like if (col1 > 0 AND col1 <= 50) then col2 = 'A' I keep getting 'Invalid Test Expression' errors so it sounds like I'm not writing the conditional tests correctly but I cannot see where I'm going wrong. Here's an example: Can anybody help me fix this, or point me at another way of setting a value in one column based on more than one possible value in another column? Thanks, Mike

132
michael_m
Contributor
arnaud.leidgens
Contributor
arnaud.leidgensContributor
asked in Transformers
Error 500 - ObjectID is marked as "read-only"

Hello everyone, I've a quite simple workflow but I'm stuck with error '500'. I'm trying to link polygons from hosted feature layer A (ArcGIS Portal) with attributes from a CSV file and write them into another hosted feature layer B (empty, with same schema than CSV file). The writer is configured to truncate and insert all polygons & attributes. I guess that this error is coming from the lack of unique ID for the new inserted polygons, since this field cannot be modified (see below) : ArcGIS Portal Feature Service Writer: Attribute 'objectid' on feature type 'Master_nutrition' is marked as read-only in the corresponding layer/table. Attribute values will be ignored. NB: same for "globalid, shape_length, shape_area" Similarly, I've a more complex workspace involving a "many-to-many" FeatureJoiner, with the same error. The solution is probably similar.  I'm not sure how I should handle ObjectID or GlobalID for it to wor

2230
arnaud.leidgens
Contributor
J
jasonschroeder
asked in General
Getting duplicate features when writing to ArcGIS Online

When writing to a hosted feature layer in ArcGIS Online we are getting duplicate features on occasion. In the latest run where this happened, there were 15,304 features in the dataset which were reported as written to ArcGIS Online, although the feature layer actually had 16,304 features written to it. Features with OBJECTID 9001 through 10000 were exactly duplicated making it seem like a batch of 1,000 features were written exactly twice during the process. OBJECTID 10001 was an exact duplicate of 9001, 10002 was a dupe of 9002 and so on.... After this batch of duplicates, subsequent features were not duplicated (features before OBJECTID 9001 were also not duplicated).

30240
mattmatsafe
Safer
C
cchiquec
asked in Transformers
What is a good tool to conduct a point to point spatial join and transfer attributes?

This is very simple.  I have two different point feature classes and I just simply to want identify which points overlay each other (several should be an exact spatial match) and transfer attributes when there is a positive spatial match.  I first considered using PointOnPointOverlayer as I thought it was the most logical transformer but that doesn't seem to carry out a "spatial join" but rather 'aggregates' points based on proximity. I found that NeighbourhoodFinder with tolerance set to 0.01 was the closest tool to a typical GIS spatial join. Other options may include using FeatureMerger.  Any suggestions on which transformer will work best here? This should be straightforward enough! Thanks.   

340
nielsgerrits
VIP
sameer
Contributor
sameerContributor
asked in Transformers
Urgent: Excel Writer issue using v2023.0.0.3

Hello "Safers" Migrated from latest 2022 build to 2023 2 days ago.Noticed that some of my scheduled Automations failed and the issue is linked to the Excel Writer (The Writer itself or FeatureWriter) These workspaces have, obviously, worked prior to the upgrade for some time now.The Server log outputs the following for one of the workspace (Same error for the other workspace):-----------------------------------------------------------------------------------------------59 2023-6-19 10:01:01 | Emptying factory pipeline60 2023-6-19 10:01:02 | OneDriveConnector: Downloading file "MO-Emails.json" to specified folder "E:\\FME Workbench\\Planning Support\\LetterOfRepresentations\\JSON-Input"61 2023-6-19 10:01:02 | Creating reader for format: JSON (JavaScript Object Notation)62 2023-6-19 10:01:02 | Trying to find a DYNAMIC plugin for reader named `JSON'63 2023-6-19 10:01:02 | Loaded module 'JSON' from file 'E:\\FMEFlow\\Server\\fme\\plugins/JSON.d

1214
kailinatsafe
Safer
vimva679
Supporter
vimva679Supporter
asked in Transformers
How to EXTRACT XYZ of this geometry ?

Hello All, Am not sure if this have reached to FME support and experts to step in as i am struggling to extract CORRECT XYZ coordinates of this object ( i call this PLAT).  What i am after is  4 vertices XYZ coordinates ( corner of PLAT FACE)1 centre point XYZ coordinates ( PLAT FACE)1 gravity point of this CUBE ( full object including the studs)  I have worked on it for quite long but the results using the various transformer turns out to be incorrect when i compare it with the output from python output and actual survey of the object using total station results . It no where close or accurate. So please this have now become challenge to obtain correct coordinates using FME. Am attaching my FME workbench from what i know and have learnt things so far and sample data that i have am aware but am sure there is better and efficient way that you FME help desk and expert might be aware of .  Thank you so much for all your help and support.

140
vimva679
Supporter
joy
Enthusiast
joyEnthusiast
asked in Transformers
Error translation when reading in ecw file with search envelope for level 0-2

hi Everyone,This is a very specific error and I wondering whether it's a bug. Initially I tried using the FeatureReader with Spatial Filter, however then the whole ecw file needs to be read (14 gB) which takes a long time. I then tried using the normal ecw reader with the search envelope which doesn't need to read the whole ecw file before conducting a spatial operation. This works superfast for when I choose a number for Advanced > Pyramid level to Read from 3 to 10. I get the following output for level 3, however the picture is quite coarse as you can see. I would like to have the most sharp picture, thus ideally I would like to choose level 0, however when I choose a number from 0-2 then I get an error translation with no explaination about the cause of the error. I was wondering whether this a bug.  

130
kailinatsafe
Safer
john_otoole
Contributor
john_otooleContributor
asked in Integration
FME Server 2022.2.4 - uploaded files not being overwritten if >10kb

We're getting some strange behaviour with FME Server 2022.2.4 running on Windows Server, wondering if anybody else has come across this or has any ideas of how to resolve.  We have a workspace which accepts an input text file and then does some processing on it. When running the workspace through the REST API, or through the FME Server interface, the file is first uploaded and then the workspace processes it. We are finding that the uploaded file does not get overwritten. i.e. First we upload file A - all works fine the first time. Then we rerun the workspace, uploading file B. File A does not get overwritten and the workspaces processes file A instead of file B. In this log file: C:\ProgramData\Safe Software\FME Server\resources\logs\tomcat\<machinename>\catalina.2023-06-19.logWe see the error below:19-Jun-2023 11:28:21.685 WARNING [http-nio-0.0.0.0-80-exec-8] COM.safe.web.upload.StoreManager$FileDesc.<init> null    org.apache.commons.io.FileExistsException: File element i

790
mattmatsafe
Safer
s.jager
Influencer
s.jagerInfluencer
asked in General
SQLCreator 2022 Exposing attributes from query does not expose any attributes, without any error message

Hi, I have a bunch of fairly complicated SQL queries, which I frequently use in an SQL Creator. This saves me a tremendous amount of featuremergers and such, because the sql basically re-creates the business object from the normalized database tables. Up to version 2020 this worked just fine: insert an SQLCreator, select DB Connection (SQL Server 2016 SP3), copy-and-paste SQL from my code snippets, click on the ellipsis to Expose attributes, click on Populate from SQL Query, and I'd be done. Now that we've upgraded to 2022, that does not work anymore. The Attributes to Expose dialog stays empty, and no error messages or warnings appear in the log. It is rather annoying because I have to do this all the time, and now I have to copy the attribute names manually from my sql statement. It's causing me quite a bit of extra work. Am I missing something? I am currently using FME(R) 2022.2.6.0 (20230523 - Build 22800 - WIN64) , and up to now this method has always worked just fin

1820
s.jager
Influencer
virtualcitymatt
Celebrity
virtualcitymattCelebrity
asked in Transformers
FME 2022.2.5 - Data Inspector 2D window loading/freeze issue?

Has anyone experience the Data Inspector having issues when viewing 3D objects in 2D?  Sometimes I get the Inspector into a state where the application partially freezes. It seems to happen when I switch from 3D to 2D. I'm unable to change what I see on the screen, however, I can see that the buttons at the top are responsive and the context menues.  I switch back to 3D and it'S fine. It's only 2D which isn't working.  Restarting the machine seemed to fix the issue but eventually it come back. Just looking to see if I have a faulty machine/config or if it's FME. Steps to reproduce: Open 3D Dataset (3D view opens by default) switch to 2D.

130
virtualcitymatt
Celebrity
M
megannes
asked in Transformers
How to make sure ImageRasterizer runs even with no input data

Context:The overarching goal is to extract certain categories of areas from GeoPackage files and then write the output as images with the R, G and B channels containing specific grouped categories.I've gotten this all to work nicely as long as the geographical area that we collect the data from contains all of the categories that is written to each of the channels. The issue now being that when one of these categories doesn't exist in the selected area - then the connections for that color channel wont be ran and I end up with a broken output. So what would be the best way of making sure the ImageRasterizer leading into the RGB channel creation is ran regardless of input data or not?Or would I be better off doing something completely different? I am currently working with a RasterNumericCreator to try and generate blank data to be supplied when other data is missing but all I've gotten is a mess trying to get the coordinates accepted by the nodes down the line.Using this me

92
M
zdansky
Participant
zdanskyParticipant
asked in Transformers
POSTGIS dynamic writer forces generic geometry columns instead of specific ones (point / line / polygon).

Hello, I am trying to generate dynamic POSGIS tables from spatialite data, however I cannot seem to force FME to create POSTGIS tables with Point / Line / Polygon geometric columns, they get forced to Geometry every time.As you can see, I have geometry set from schema definition, I have disabled creation of generic geometry columns. My features look like this:However when I look into the database, the table created looks like this:SRID is generated correctly, but geom geometry(Geometry,5514) should be geom geometry(Polygon,5514)...I have found similar question, from 7 years ago, is it possible that this has not been fixed? They are using feature writer, I am using normal writer. https://community.safe.com/s/question/0D54Q000080hcErSAI/featurewriter-postgis-writes-generic-geometry-column PostgreSQL 13.10 on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 7.5.0-3ubuntu1~18.04) 7.5.0, 64-bitFME: FME(R) 2022.0.0.2 (20220518 - Build 22343 - WIN64) 

640
nielsgerrits
VIP
C
chrisnovak
asked in Transformers
How to query out certain fields (columns) from a feature class using a query

I have a feature class within a FGDB that contains 2631 fields that are named F1 to F2631 and looking to query certain fields from this main feature class to write out to a new feature class. For example the first i'm trying to write out as a new feature class I want to write out fields F1 to F40. Attribute Manager appears to struggle to remove fields F41 to F2631 when i try to use this transformer and crashes FME on me. I've been trying to figure out a way to query the fields i plan to remove within Bulk Attribute Remover but cant figure out how to complete the query? Any suggestions ?

2294
ebygomm
Influencer
M
miledihamdi
asked in Transformers
How to use python caller and use neighborhood finder in python caller

I have 100 neighborhood finder, in each neighborhood finder the two input are matched and umatched from the first transformation and the two output are used as inputs in the next transformation, i want to used python caller for solve this problem

210
david_r
Celebrity
davidlee
Supporter
davidleeSupporter
asked in Transformers
AutoCAD Block Attributes to Point in FME

I have 2 DWG files are working with FME. How to FME transform automatically Block attributes to point (Block attributes in DWG file and tags in Microstation)File 1: FME transform automatically block to point with attributesorginal file 1: File 2: its not, FME is not transform block to point automaticallyOriginal file 2:How do i get the point with the attributes of block attributes like file 1 ?By the way with these 2 files i don't use "Preserve insert points" in FME

2655
featuremichael
Enthusiast
chadprop
Participant
chadpropParticipant
asked in General
Safe Emailer works great with Generic and Gmail, how does one get the Microsoft Email Service to show up in the Service dropdown?

I've gone into Manage Web Services and managed to configure the Microsoft Mail (safe.emailer) web service and it tests and authenticates without issues. However, when I add the Emailer transformer from Hub and go to select the Email Service from the Service section I only see Generic SMTP and Gmail. Is there something special I need to enable or refresh for the transformer to see my new web service? edit - have tried this in both versions of 'Form' I have installed (2022.0, 2022.1) thanks

450
chadprop
Participant
chadprop
Participant
chadpropParticipant
asked in Transformers
I'm struggling getting filters to work in a simple automation. I'm using a webhook as a trigger, logging the message response from it then trying to pass a filter based on containing a certain value.

The webhook is coming from a hosted FS on AGOL set to respond to updates and creates. There are 10 'pieces' (layerids) to the feature service and I'm only interested in triggering a workbench when the layerID=0. I've imported the JSON keys and made them available to the filter action.I've tried many different formatting methods in the 'Contains' setting but no matter what I put in there the filter always fails and logs another message that it has failed. I've got a fairly simple workbench I'm trying to trigger with the automation but since the filter fails the workbench does not run.

90
chadprop
Participant
franco69
Contributor
franco69Contributor
asked in Transformers
Create kml file with jpgs

Hi guysi want to create a kml file with jpgs inside (they are inside a local folder) and when i click on the location jpeg pops up......i have set up my workbench like thisEmbedImages-in-KML.fmwtbut the locations and the information about the jpgs FME is writing the right way ...but what i have to do when i want the jpg to pop up?write the path in a hyperlink or a special kml writer format attribute? Greetz and thxFranco 

1230
kailinatsafe
Safer

Badge Winners

Show all badges

Community Stats

31,853
Posts
120,983
Replies
39,485
Members

Latest FME

Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.