FME Form

Hello ,I need a help I successfully updated a point geometry in the ArcSDE writer within a specific version. I encountered an issue.When I select "Update Mode" and set "Row selection - Columns " to ObjectID, I get an error translation  running  . But if I leave "Row seletion - Columns" empty, the translation runs successfully. The "Row selection - Columns " field turns red when left empty, and I’m unable to click "OK." To work around this, I temporarily set "Row Selection - Columns" to ObjectID, click "OK," and then use a Remover transformer before the writer to remove ObjectID—and when I run the workspace ,it  works great and translation is successfully . But ’m unclear on how FME identifies the correct point to modify it ,how to resolve my issue ? Update Spatial columns : Should be yes or no ?FME version: 2021, 64-bit.Thanks

Hi,I would like to setup a FeatureReader to read all the XML files in a onedrive folder.  My OneDrive (graph) connection works and I’m able to view the contents of my folder.  I am able to select individual files to read in the FeatureReader parameters but I want to be able to read all XML files.  How would I go about accomplishing this?  Thanks in advance.

Hi All! Just a hopefully quick question: I want to write data to ArcGIS Online, and i want to do it dynamically, but it isnt really working out, here are my settings: I want to dynamically write data to ArcGIS Online, but i get this error message:  Can someone tell what im doing wrong?  Thanks in advance!

I want to read PDF files as images using OpenAI's Vision API to extract information. I realized that FME's PDF reader tool has issues with PDFs containing text created by digital signatures—it cannot read them either as text or as images. Therefore, I decided to use PythonCaller to create image files from the PDF files to ensure the data is complete. Below is my code: import pdf2imageimport fmeimport fmeobjectsimport osclass FeatureProcessor: def __init__(self): pass def input(self, feature): pdf_path = feature.getAttribute('path_windows') images = pdf2image.convert_from_path(pdf_path, dpi=300) for index, image in enumerate(images): image_feature = fmeobjects.FMEFeature() image_feature.setAttribute("page_number", index + 1) temp_dir = "D:/temp" if not os

I would like to use 2 UserParameter values as attribute names in my workbench. Is this possibe?Current situation:What I would like to have: 

Hello everyone,How can I place my points on a terrain model?I don't have Z values ​​for the points I have, but I have a rester data in Tiff format, how can I place my points on this terrain?

Herkese merhaba3B ağaç verilerim yatay görünüyor, onları nasıl dik konuma getirebilirim? (döndürücü ve 3d döndürücü) Bu iki aracı birçok kez denedim ama işe yaramadı. Bu durumu nasıl çözebilirim?

Hi everyone,I’m working on an FME workbench where I download a full dataset file geodatabase daily. I also have a CSV file that lists daily changes.My goal is to remove files from the main dataset based on the CSV and add updated files from file geodatabase back into the main dataset.I’ve tried using the FeatureMerger and FeatureJoiner transformers to identify changes, but they were not effective due to time constraints. Since this needs to be done daily, time efficiency is crucial.Do you have any suggestions, Python scripts, or SQL queries, or any other ideas to speed up this process?Thank you!

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 / d

Hi, Is there a way to remove build pyramids when converting geotiff images to mbtile? I just need the image to display and improve mbtiles creation time 

Hello, my previous post was not well Described apparently, i need to split .las just like that. please if you suggest any workflow do describe it a little more than just the name of transformer as that is usless for me (i dont really know how to use FME) 

Looking for a workbench that updates  an SDE attachment layer from a sync enabled HFL with attachments on AGO. The SDE layer with attachments is not archive enabled.  

Hello everyoneI have data in shp and obj format. I have a tree model in obj format, I want to assign it to points in shp format, then I want to export it as cesium 3d tiles, can you please help me with this? I tried this method with GeometryInstantiator, but I think I am doing something wrong

Hi All, I’m trying to dissolve thousands of polygons from different feature classes into a single shape in FME. The idea is to obtain a single external boundary after merging/dissolving all the polygons. The current dissolve transformer gives me an error while trying to dissolve the polygons.Parameters in the dissolver are set to default.Is there any ‘hard dissolver’ option to merge the following?  Thanks :)

Hello,Is there any way to assign Index “Primary key” to the field and Type “serial” somehow in another way rather than in Feature writer - User attributes? These options are not present in AttributeManager transformer, unfortunately. That would help me to reduce number of manual adjustments and use “Automatic” attribute definition. Because I have many FeatureWriter transformers in my workspace and I need to replicate it to read another data.   

Snowflake recently released their new "geometry" data type. Not to be confused with the existing "geography" data type. The geometry data type can contain geometries in other coordinate systems, not just WGS84. Whereas geography is specifically WGS84. See Geography vs Geometry data types documentation hereGeospatial Data Types — Snowflake Documentation When will FME support writing of the new snowflake geometry data types? Is there a way to do this right now, or will it be a future release of the Snowflake Spatial writer?

Hello to all,I need to add a missing property into an existing Pset. I tried the workbench shown by Liz in the post “Updating IFC example” but it doesn’t work in my case. Before testing with an Excel sheet contaning GUID and properties to add, I just test to add manually a single property:First, I created 2 attributes:Then I used the GeometryPropertySetter:With the XQuery:I find my previ

I want to pull Google BigQuery data in FME and write as shapefile. Can somebody help me on how to do that?

Hello community!I am working on an analysis to calculate the percentage of incline or decline from railway level crossings. This means the incline or decline along the road that crosses the railway.The desired result is six percentage values. Three for each side of the track (viewed in increasing kilometer (M-value)). The three intervals are 0-4.5 meter, 4.5-8 meter and 8-18 meter, measured from the outer edge of the railway track.It is desirable that the length is measured along the road.Decline from the level crossing should be shown as a negative percentage value, and incline as a positive percentage value. Based on the client's wishes, I have divided the analysis into smaller tasks:Add a property that shows whether the road lines are on the right or left side of the railway, viewed in increasing kilometer (M-value). I have tested the LeftRightSpatialCalculator, but for some unknown reason it always gives me the sa

One feature has 40 vertices and the other 41, but ChangeDetector using “Lenient Geometry Matching” option says they are the same. It's right?  

Hi folks, I’m trying to execute a python script using Python Creator. The flow is running as expected also with expected outcome, but its giving this error - I have checked the updates is FME package but still not working.Not getting why this error is occuring. If anyone has any idea about it, kindly help. Thanks in advance.     

Hi,I have a shape with polynones. I want to select 30% of the polygons at random. Is that possible?    

Basically here is the need: right now workbenches run (Using FME Desktop 2020.2 and Task Scheduler) and the email addresses are typed out within the Emailer Addressing "To" parameter.We would like things to be more easily updated. For example, if someone is no longer on the team, or if someone is new on the team, we would like to simply update a text file and ALL of our jobs will be updated. I tried reading the text file in, aggregating the addresses into one long string separated with a comma, but I wasn't sure how to assign the value to a User Parameter.(I tried a couple things and failed) Thanks in advance for your help.@danminneyatsaf​ 

In the above image, I read a text file that contains lines of data where specific lines that start with an ID relate to different features.In the #1 category it contains the projection information but I want to be able to set the projection of the other output ports based in the information in that line.How do I hold and set the projection of the Lines, Points, etc?I was thinking that I may just need to read the text file twice, once to get the projection from Port #1 and then have a feature reader that can then set the projection before processing the other output ports.Is there a more efficient way of doing it? 

Hello.I have a JSON file the looks roughly like this, containing a list of un-named values:{ [ { “UniqueID”:123446,      “Dealership”:”Dan’s Dodge”,      “Owner”:”Dan”,      “BestSelling”:        [ “blue”,          “red”,          “blue”,          ...          “red”        ]      ...       “Telephone”:”411”    },    ...  ]}My first JSONFragmenter feeds two workflows: the first workflow captures the named values (including “UniqueID”), and the second