FME Form

Hi, With FME I want to read a sde geodatabase. (feature class). For this I use the reader: “Esri Geodatabase (ArcSDE geodb)”. Until recently this worked. With ArcGis Pro an Attribute rule has been created for 1 field and since then the reader no longer works if the workspace is on FME server. If the workspace is run in FME desktop (not FME server) the reader will still work properly. The message I get when the workspace is running on FME server is: An error occurred while attempting to open the table, feature class or relationship class 'My_TABLE'. The error number from ArcObjects is: '-2147211773'. The error message from ArcObjects is: {The item does not have a definition.}  What could be the cause of this. FME server and FME Desktop are the same version. Greatings, Hans

Is it somehow possible to receive a connection from another party using OAuth2?Do I need to add a specific user to the user list? Do I need to create an application?Could it be done using a webhook or an automation? Or should i build a webhook or automation and use that as a trigger to connect to another location using OAuth2? The other party does not want to send data to my FME Server without using OAuth as a security measure.

Hey. I need some advice, or at least direction, on how to solve a complex problem. See attachment: I have a track. The track consists of waypoints, the waypoints are minisegments which consist of a startpoint and an endpoint and these minisegments form one big segment and these big segments form one complete track. The direction of the "flow" of the points is determined by the number of startpoints and endpoints, see below, where we see that the only possible direction is from A to E, since it must connect startpoint to endpoint between the minisegments, which form one segment out of three. The waypoints of one of the segments at the level of the points that make up the minisegments look like this - A, F, C, E: Startpoint: AEndpoint: FStartpoint: FEndpoint: CStartpoint: CEndpoint? EThe problem I'm solving is that some segments have this sequence of startpoint and endpoint reversed in the source data, so that the sequence of points of one

Is there a possibility to schedule the workbench on our local system rather than putting it on the server due to data confidentiality issues?

Hello,I have some data which shows if an event occured per month. Events 202301 202302 202303 202304 202305 202306 a 1 1 0 0 1 1 b 1 1 1 1 0 0 c 0 0 0 1 1 1 d 1 0 1 0 1 0  I want to count the events which occurred 3 or more times consecutively. So I want to get thisEvents More than 3 consecutive events?

Can Imagefetcher download the images from a excel thst have google drive image link

Our goal is to write files on Sharepoint. Therefore, we used the Sharepoint Online Connector transformer, whereat the connection to Sharepoint works fine, but we currently have the following issue: The specific site we want to connect to does not show in the sites list within the transformer. We already checked the rights, but everything looks correct. What are the preconditions that a specific site is listed in the site list and can be used by the Sharepoint Online Connector transformer? 

We have tried to export(write) an obj 3D building file to dae / citygml / slpk file formats, and all three of the conversions were successful.However, only the dae format was successfully visualized in a viewer, and citygml/slpk failed to visualize with the viewer that supports the formats.Could you give some advice for this issue?CASE1 - obj to citygml (failed to visualize)input 

Hi there, If I have been given a TIN and a point cloud, how can I find out which points are above the surface and which are below, without rasterizing the surface to retain maximum surface fidelity.Thanks,Marc

Hello,I am trying to transform a point cloud with ellipsoidal heights into orthomethic heights (DHHN2016) using the CsmapReprojector. The settings can be seen in the image. For the Geoid Height Grid I need a file in .gdc format. My target system is DHHN2016, for which I have the quasigeoid in various file formats (e.g. JPG, TIFF, GEM, TXT, GSF, GFF, GGF) but not in .gdc. Is there a website from which I can download the appropriate format or another way?Thank you very much.Translated with DeepL.com (free version)

Hi,I have a process that writes out a dgn. Some of the levels in it are required to have their global display turned off and others are on, in the initial state. Basically some levels are hidden on opening a file. I used a feature writer to do this with one stream having their global display set to on and another to off. This worked a treat.Until recently when my company upgraded to 2023(.2.1) from 2022. I haven’t changed anything but now everything writes as turned on even though some is set to be hidden. I did not see that this is a bug that was fixed in future versions from the changelogs.Does anyone have any hints for me how to get this working again please? Or have I lost the functionality now?ThanksJames  

Hello, I have an IFC file I wish to import in Postgres(PostGIS extension) to go through spatial analysis. Oriinally, what I did was to convert the IFC to a 3DGIS compatible format (GML) and import it in Postgreswhich was successful. Exploring a little more, I saw that Postgres supports the solid geometry type of FME and I performed the same conversion, without converting the geometries to b-rep. This photo shows the input in Postgres and this photo shows the output when I am reading it from Postgres. The highlighted part is visualised differently. I couldn't help but wonder the reason why.Could you please help me figuring this out?

I’m trying to use the Data Inspector to inspect data in a Pro-generated file geodatabase. I’d get these errors which prevents any dataset from coming in.I’m on ArcGIS Pro 3.1.3. Dialog window:“Failed to open datasetEsri Geodatabase (File Geodb) dataset ########### could not be opened as configured. See log window for details. Remove it from recent dataset list?“Log window:An error occurred while attempting to open the table, feature class or relationship class 'Administrative_Lines'. The error number from ArcObjects is: '-2147211773'. The error message from ArcObjects is: {The item does not have a definition.}It could have failed to open because it contains ArcGIS Pro-only features, for example Arcade expressions. If this is the case, please install ArcGIS Pro or Pro-compatible ArcGIS Server and 64-bit FME. If already installed, set the Esri ArcGIS Compatibility setti

Hello,  I have a difference in my results and I was wondering if this is a ‘known issue’ and how to resolve it. Goal: Give all the line-objects a “No” when there outside the polygon and a “Yes” when there inside a polygon.  FME: I used a SpatialRelator (with the Spatial test: Requestor is Within Supplier option) followed by an Attribute creator which defines the Yes & No. ArcGIS: To check the result I did the same within ArcMap using: Select by location with Within as the selection method.  Result ArcMap: Result FME:  I do understand that we are comparing apples with oranges, but I got some s

Geometry type "CompoundCurve"Because of the given schemas the postgis writer has problems with the geometry "CompoundCurve". I want to convert this in the process into a normal line element, which can be read in the osm_line table with the geometry "linestring". Today my process in the Workbench crashes with an element with the geometry "CompoundCurve". Geometry type "Curvepolygon"The second problem is the geometry type "Curvepolygon". This is written correctly into the postgis table osm_polygon. But then I have to delete these objects manually in pg_admin, so that the generated data can be read by the application software. Is there a possibility in FME to convert the elements with the geometry type "Curvepolygon" into a normal polygon? With best thanks for your support! Erido

I have 4 files I need to rename. To rename them I need to add the values of an attribute in a table to each of their names; please refer to the screenshot for this example:SS000001.PNGwould be renamed 18085SS000001.PNG by adding the value from the STCLID Attribute in the table in the screenshot to the filename.  Seems as a first step would be “move” the values in the STCLID attribute to the <missing> rows? What is the best way to go about this? 

The PDF-reader seems to have disappeared from FME Form 2024 for Mac (silicon). It worked fine in the 2023 version. I took a look at the writer, and there is no dot under Read there either. Has this reader been removed for some reason? Or is this a bugg?  

Hi there, I have a mapinfo table and I would like to split the table into multiple tables - one for each object.  Also one for particular attribute related to the object - eg libary and community centre.  And then write these out and save as multiple tables.  I would be grateful for some advice. Many thanks

We're using FME Flow 2023.1.2.We have got a Windows Share registered as a custom resource at FME Flow, which is locally accessible as a UNC path. I'm looking for a way to reference the custom resource in such a way that it locally uses the UNC path and at FME Flow automatically uses the resource. I believe I can use Deployment Parameters for that.When I create a Deployment Parameter and use it as part of the path in a FeatureReader, it doesn't recognize the file I'm trying to reach, though I did fill in the local value of the Deployment Parameter.Deployment Parameter Value: $(FMEShare) Deployment Parameter Local Value: \\computername\shared_folder\ Reader Path: $(FMEShare)Subfolder\file.xlsxI tried to create an attribute _pathExcel that is set to the path I tried to fill in in the FeatureReader. Locally that worked, but at FME Flow I got this error message:Too man

Hello Community,I have a question and looked for answers but didn’t find it yet.It must be simple for someone but I have not yet figured it out. I tried attribute transposer, aggregator etcI have a table with a feature which has an ID here shown as Feature 1,2,3 and multiple columns with values for each month of the year.It is like so: What I yould like to get is the following:In the end I need a row for each column corresponding to the feature it is refering to.I found some sort of a possibility but it it very “manual” an inelegant in FME as I have to create each month manually and associate a date etc. If someone has a better idea,

Hi there,I have a small project where I've performed a join between two tables (Table1 and Table2) using the CityName field as a common identifier.However, I've noticed some minor inconsistencies in the city names between the two tables, resulting in 10 unjoined features.Is there a transformer or method available to manually specify that the X row from Table1 should be joined with the Y row from Table2?Regards   

 Dear FME community,I hoop you will help met with the problem I am try to solve . I am reading WFS data which has more than 200,000 records. I just want to replace one of the fields from my own Excel file. I used to Attributevaluemapper to replace the value of fieldname owner with the value name owner from my exce list. I am not succeeding Do you have any idee how to tackle this?Any help is apricated and thanx in advance!! 

Hi all,I’m using: FME(R) 2024.0.1.0 (20240328 - Build 24202 - WIN64)I do want to know if there is the possibility to use the HttpCaller to launch chunk of requests. My DELETE request: https://xyz.api.here.com/hub/spaces/@Value(space)/features/@Value(xyz_id)each request sends to that Hub the action to delete each Feature by its ID (xyz_id).I need to delete around 4M records, and running the workbench feature by feature, takes days.Is that possible to get it faster? Thanks for you help,Juanma

My customer want me to automate a report how many times diffrent map services has been reqested.It’s on a unfederated arcgis server with arcgis server manger.In arcgisserver manager i can export this information one by one to a csv file and get how many times a service has been requested in a set time period.I need to find a way to automate this process. Is it possible to retrieve this statistics using FME and then print it to an Excel file? Then on FME-server I need to get a report every month how many times diffrenbt map services has been used. 

Hi All I have a point distance data set in a parquet file with x y coordinates and a geom column with geometry encoded in hex binary and i have line data for coastline I want to calculate distance between these points and the coast polyline .In my workflow am using geometryreplacer to get the geometry then projecting both layers using csmapProjector then using neighborfinder but am getting unexpected results ...is there a better approach