FME Form

Hi,I need to use Upsert to either Update or Insert features into an Oracle database.If I use Insert to add values it works a treat, so the connection to the Oracle tables is good.As the Oracle tables are large, when adding the writer I use Import from Dataset… This picks up the format of the date fields and all sorts. It works well for initially inserting the data.However, when dealing with deltas, which might be Inserts or Updates I want to use Upsert. I can test it on a filegeodatabase and it works perfectly. Taking that knowledge into the Oracle process like this: I use the NODE_ID as this is the unique identifier.However, this fails.So I have followed the guidance to implement fme_db_operation, I have created a new attribute field of that name, and used a FeatureReader, FeatureMerger, and then AttributeCreator to define whether the feature is classed as INSERT or UPDATE. All works well in the workspace, and a manual / visual comparison between Workbench and the Oracle table conclud

Hallo FME enthusiast, I am trying to create a 2D overview map from 3D roofs (OuterEaves).What is the goal?The goal is to create a 2D view map from the top and those areas below should show the area in 2D, which seen are from the top and the highest Areas should stay on top.What attributes do I have for the roof surfaces?-ID of the building-xyz coordinates of the OuterEaves But I fail because of the intersection of the roof surfaces. The 3D data set is not 100% cleanly created and therefore I have up to 10 overlaps of the roof surfaces to each other or even within themselves.My question to you: What is the easiest way to clean up these overlaps in 3D space so that I get my result? King regards,Michael

i was reading on FME Form Advanced module, in Generic writing sectionand it has this part that mentioned : When you use the Generic Writer, it is sometimes helpful to pre-configure parameters specific to individual output formats. For example, you must specify a seed file to write a Bentley MicroStation Design file.To do this, add a writer to a workspace. This step causes Workbench to think that there is more than one output format and forces Workbench to create a Multiwriter for the workspace. The first writer in the multi-writer will be the Generic writer, and this one should have all the output feature types. The second writer will have no feature types but will be used to communicate any format-specific writer settings to the Generic writer when FME users that format for the Generic writer.Suppose you configure the Generic writer to write to a format requiring a filename as a dataset. In that case, the Generic writer will turn the output folder into a filename by appending a file e

We have several FME Server services that runs nightly to update hosted services. This all works well but every month or two the services all fail because they have lost their authentication to AGOL even though there were no account changes. I can re-authenticate the connection and then the services run for a month or two and then they lose their authentication again. Is there a way to set up the authentication so that they do not have to be periodically re-authenticated? Thanks in advance,David

A bit of a subjective question, but what are fast file-based geospatial data formats to read in FME?I have a set of geodatabases (10GB) covering the whole country, and it’s located locally on the C-drive of  the FME Flow server. Users specify a bounding box to extract the data for their area of interest.To make the current setup faster, I have played with indexes and made sure that I’m doing a bounding box intersect on the FeatureReader, etc. But it still takes at least 10-15 minutes to get the output.One other idea that I’m playing with is to use a different format for the source data instead of geodatabase. GeoPackage got a mention somewhere; FlatGeoBuf apparently is fast; and I have heard good stories about GeoParquet. Any other formats I should consider?Has anyone done any comparison on this? Any pitfalls / drawbacks I should be aware of?At the moment I’m looking more at file-based formats, as formats that require additional (database) software would involve IT too much.I will do t

AttributeManager_10 (AttrSetFactory): Bulk features are not supported because of the setting for 'If Input Attribute is Missing'. Changing this to 'Remove Output Attribute' may improve performanceI see no such setting in attributemanager_10. Where is this setting? Form or Flow I get the same message in both.I do have an sqlexxecutor directly in front of the attributemanager but do not see this exact setting in it. 

I have 2  coordinates in Denizli,Turkey . I have lang  and long. Sample 2 coordinates :U1  37.787464°  28.780846°U2  37.751292° 28.864560° I use reprojector transformers convert the data wgs84 to ed50turkey. I use EPSG:4326 and EPSG:23035 .It converted wrong coordinate.  The true coordinate of ED50 Turkey :  U1 656858.976    4183906.006U2 664311.027    4180035.990 Thank you! 

Hi,Some parameters of the coordinate system on the screen are not compatible with Türkiye. I know what the values ​​are and I want to edit this file. Especially, it seems that just changing the delta x y z section in the datum parameters section will be enough. can you help?  

One thing wish FeatureJoiner had was a CROSS JOIN / Cartesian Product mode to create every permutation of Feature Set A vs Feature Set B  (Eg.  When creating To-From Lines between every possible Origin Point and every possible Destination Point).Custom Transfomer FeatureCrossJoiner is not anything really radical in how it gets FeatureJoiner to do this by creating a temporary dummy Cross Join attribute, but perhaps simplifies the process for some users.https://hub.safe.com/publishers/bwn/transformers/featurecrossjoiner 

Hi,I have a fgdb, I want to drop all existing features classes within the fgdb and write in a new one. Is this possible?ThanksB

Out of the blue, I've started getting the below error message with my workspaces running on flow which talk to SharePoint: FME Flow error logI did some of my own digging, and found this community post:where the user had a similar issue. I have uninstalled my sharepoint package (1.1.6) and downgraded a version but it still doesnt work. I also upgraded it to 1.1.7 for good measure and that also didn’t fix the issue.  I am not downloading these packages directly off of hub because my install is on a remote server, so i have to copy the packages across before installing. I know partial installs can occur doing it like this, but error came out of the blue and I’m not sure why. There was an OS upgrade on the remote server prior to this, but if something was inadvertently deleted, I would have thought that reinstalling the package would restore what was missing. FME Server 2022.2.5Build 22795 - win64 Thanks :)    

Hi,I am working with CityGML data and using FME to process and transform buildings from a 3DCityDB into CityGML output. I know I can use the 3DCityDBImporter/Exporter for this but I would like to create a custom FME script for more control.I am trying to transform attributes from the 3DCityDB into a format suitable for CityGML output, specifically list attributes like citygml_function{}, citygml_function{}.codeSpace and citygml_usage{}, citygml_usage{}.codeSpace. These attributes are stored as strings with values separated by --/\--, and the corresponding URLs (codeSpace) are also in a similar delimited format.I attatch one building with these attributes in csv format as an example.The end result should be like this feature (building):Have anyone done something similar as this? Im not very used to working with lists. Would appreciate the help, thanks in advance!

Hi, I am trying to edit the workbench from https://fme.safe.com/blog/2016/05/point-cloud-power/ so it splits the polygon into the number of parts or area I provide. I cannot figure out how to change the PointCloudCoercer to allow me to do so 

Hi there,  I have a shapefile with real estates that enclose several buildings. I want each polygon in the real estate layer to inherit the attribute entries for the buildings that lie inside each real estate polygon. Some of these entries will be the same, but I want all unique entries for buildings within the same polygon to be written to the same entry.  For example. Three buildings lie within one real estate with attribute entries “Residence” “Grocery store” and “Recidence”. I want these attributes entries to be concatenated into a single attribute entry, separated with comma, in the real estate layer, but with duplicate entries removed. So, the final attribute entry should be “Resicence, Grocery store” for the real estate polygon. Is there any way to achieve this in FME?

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 in advance

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.path.exists(temp_dir): os.makedirs(temp_dir) image_name = f"{feature.getAttribute('path_rootname')}_{index + 1}.png"

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 / does not create .prj file I can use.

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)