FME Form

Good evening at everyone.I have a shapefile of buildings in the reference system Gauss Boaga Italy Monte Mario 1 (EPSG:3003) [1]If I reproject these data in ETRS89 UTM 32N (EPSG:25832) using the proj4 library (with QGIS or PostGIS) and I obtain a very valid result [2], which overlaps with the orthophotos in coming from the WMS. [3]I tried to configure a custom SRID [4] by entering the 7 reprojection parameters used by the proj4 library contained in QGIS or PostGIS [5]I tried to reproject with FME using my custom srid, but the result is very different [6]. Is something wrong with the custom configuration [4] or fme  transformer [7]?Thank you!In the zipfile: [1] original.shp[2] reprojected_with_qgis.shp[4] MyCoordSysDefs.fme[6] reprojected_with_fme.shpother references:[3] http://pubblicazioni.provincia.fi.it/geoserver/wms?request=GetCapabilitieslayer=orto2016[5]"+proj=tmerc +lat_0=0 +lon_0=9 +k=0.9996 +x_0=1500000 +y_0=0 +ellps=intl +towgs84=-104.1,-49.1,-9.9,0.971,-2.917,0.714,-11.68 +u

Hey,  I have FME Server running great, my workbenches are running fine on schedules etc.  I have several that are 'job submitters', and I am now trying to use the mobile app to trigger them manually, each time I connect to my server, navigate to my Repository and open the workbench, I click "Run Workspace" and I am immediately thrown an error: Failed to submit job. Error: 404 I am not finding any help articles etc, has anyone seen this issue before?

Hi, I have one Form workspace that writes to a hosted feature service on AGOL fine. It is set at insert and Truncate. It writes a little more than 9,000 features and I run it every week without issue. However, I now have a different hosted feature service on AGOL that has +23,000 features. When I try the same process to update it, it drops all the data and only ends up writing out 15,000 records at most. The number of records diffs as well. I have tried adjusting the timeout and features per request, but have not been successful in achieving the full write out. Any suggestions would be appreciated.  

Hi, I'm looking for a list of special characters used in a text editor. Is there a description of their function? Are there any others available that are not listed in the window? For example, I use the MSWordStyler transformerThanksFilip

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 of the segments would look like this: E, C, F, A

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? count  b yes 4 c yes 3  Not sure how I should do this in FME. Can someone help me?Thank you!

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 1784_OBJ.zip output  1784_CityGML.zip output import view capture (KITModelViewer) No geometry information, only attribute information can be verified    CASE2 -  obj to slpk (failed to visualize)input 1784_OBJ.zip output  1784_slpk.zip FME Capture   output import view capture (ArcGIS Pro)  

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?Thank you, George 

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 setting for this workspace to 'Esri ArcGIS Pro' under Navigator -> Workspace Parameters -> Translation From FME Form, I

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 significant differences as you can see above, were from my point of view: Esri-Map is correct. Since I want to use my FME model, more often, is there a way to solve this problem? Or something I as a start-FME-user forgot to add in my model? Current model: The used Conditional Values:  Thanks in advanced for the responses!    

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 many recursive macro substitutions -- line currently is: `$(FMEShare)'How can I tailor this method to get it to work? Thanks!

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, I am very interested about it. It would help me in the long run as I may have a wrong approach to transposing data with FME.Many thanks to all the contributors. Best regards, Thomas

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