FME Form

I’m trying to load a csv that is saved in sharepoint.  I want to convert this to Excel as well as process the data and export to other formats.  I can access the data in a browser.  Nothing is returned by the httpCaller or the SharePointOnlineConnector.

Hi,I have some utility pipes that have been modelled by a sub contractor. When I bring them into FME they are surfaces. This doesn’t surprise me, though they area actually shapes. Can anyone thing of a way to build these surfaces into solids? Say I have a cylinder for a pipe. It comes in as a surface but should topologically be a shape. I wish to convert itI also wish to find the centre line of these solids, and their diameters which I haven’t been able to do eitherAny help would be appreciated. I have the 2023 versionThanks

Good Day everyoneI have some difficulties reading an ifc file. There is an IfcBuildingPartElement that is apparently ‘too’ complex to read. When excluding Geometry from the FeatureReader running it is successful, but as I am trying to analyse the Geometry, it is kind of needed to include it whilst reading. The Error message does not tell me which of the objects it read failed, which makes it hard to figure out how to bypass the geometry. Does anybody have any solutions how to get it to skip/process the complex pieces? I have tried to ‘Continue Translation’ for Rejected Feature Handling, no luck FME Workbench Message:Processing on a solid has failed. The solid may be too complex, not closed, or not orientable. Feature Reader Settings: 

Hello,Currently, I have a process where I am doing a PointOnAreaOverlayer. I then create about 23 List Attributes. As of now, I have 23 List Summers to achieve my requirements. I then port all the List Summers into one Attribute Manager, remove all the non-summed fields, aggregate all the points grouped by the Primary Key, and then I join that back to the area layer so that it holds the summed values and stays an FMEPolygon and not a MultiFMEPolygon.Is there a way to do this “better”? I have to redo this process on another Polygon Feature Type and it’s cumbersome.  Kind Regards,Senad

I have requested a raster file from an API (HERE Map Image API v3), and the response comes in the fashion of (I guess) base64 data.I would like to have a way to transform such data and store it in proper folders.Any idea? Regards.

HiI have 2 transformers (A and B) they have to provide a Sorter with inputs.If there isn’t any output from A, then this workflow C has to stop, but not the entire workspace.  If there is output from both A and B, it has to continue.If there is only output from A and not B, it has to contiunue. Is it possible?   

Note: I already solved this issue by forcing everything in “MGA2020-55_FME”, however the way FME writer handles GDA2020 data seems strange.I am trying to update an “EPSG7855” table from SQL to an “EPSG7855” feature service in ArcGIS Online. After checking the log, FME seems do not think EPSG7855 is GDA2020 Zone 55 and trying to reproject the data. Which cause the GDA2020Zone55 layer not align with GDA2020 Zone 55 basemap.   Log:  2024-06-20 09:27:58| 0.9| 0.1|INFORM|The ESRIWKID number of the FME coordinate system 'MGA2020-55_FME' is '7855'2024-06-20 09:27:58| 0.9| 0.0|INFORM|ArcGIS Online Feature Service Writer: Requesting metadata for Feature Service at 'https://services-ap1.arcgis.com/w6r4Ll*/arcgis/rest/services/Property/FeatureServer'2024-06-20 09:27:58| 0.9| 0.0|INFORM|ArcGIS Online Feature Service Writer: Found layer/table 'property_view' with ID 4 for feature type 'property_view'2024-06-20 09:27:58|

Hi everyone,I give you my work on the transformation of Runway from AIXM 4.5 reader to AIXM 5.1 writer.All seems to be fine with the structure but when i try to add some annotations to keep the <txtRmk> attribute inside an <aixm:annotation>, i didn’t suceed to keep the structure complete.When the branch is disabled, it’s fine. When the branch is enabled, all is going wrong.Could you please have a look and please give me your feedback.For the FME documentation team https://support.safe.com/hc/en-us/profiles/17698677148429-Liz-Sanderson: the workbench given on this page : AIXM 4.5 and 5.1 Reading, Writing and Valida

Hi!Does it exist an easy way (1 transformer) to compare 2 lists from differents dataset ?For example :dataset 1 - feature 1list{0}.NAME = Alist{1}.NAME = Bdataset 2 - feature 1list{0}.NAME = Blist{1}.NAME = CI would like to have the difference so here :=>on the dataset1, feature1 “A” is missing=>on the dataset2, feature1 “C” is missingthe index of the value doesn’t matter, juste the presence of the value is important.I succed with 2 ListExploder and 1 FeatureMerger, and I imagine It would be working too with  ListExploder, FeatureMerger and ListSearcher, but maybe it exist a transformer to do that more quickly.Thanks!

I'm working on enhancing an FME Workbench to be more interactive.Currently, my focus is on a project aimed at creating study area polygons.Depending on their purpose, these polygons can vary from one another.Is there a way to incorporate a dropdown menu or a list at that junction to select which writer to run and which not to?  

Hello everyone Im playing around with FME FLOW and uploaded my workspace. The workspace is running well with several parameters and writing me an OBJ file into my ressources and finally writing an HTML file (which opens a 3dviewer which opens the OBJ file).When im running the workspace in FME FLOW i choose datastreaming Service, and after success it opens the HTML file in my Browser.When i create a WebApp it is also running well and in the end opening the HTML file and showing the OBJ in the 3DViewer.But since the WebApp is quite limited with layout etc. i created an easy HTML Website on my Server. Here i added a send request with the webhook url of that workspace and the get method.And actually it is running, but after success its giving me a link to download a zip with the HTML and OBJ file.To me it seems because im using the Get method, it is just putting all the results into that zip to download. I tried a bit around and also sear

SpatialFilter gives more intersections than expected, any clue?For a parcel I want to compute the area covered by buildings on that parcel. The start situation, with one parcel and some buildings. My next plan was to use a SpatialRelator to create a list of buildings located at the yellow parcel.I tested this approach using a SpatialFilter first to see whether the intersect function works. I expected to get back only the 2 red buildings within the parcel polygon. However, I got this:A subpolygon of one the buildings is also selected. Did I something wrong?​​​My settings of the SpatialFilter:

Hello everyone,I am a beginner with CityGML and am currently trying to convert a dataset to CityGML 3 with generics extensions using FME Workbench. However, I am encountering a couple of issues:Warning about inheritance relationship: The output gives a warning indicating no inheritance relationship. I have used AttributeMerge to add gml_parent_id, but the system does not seem to recognize it.<GML_2 Writer> - '12482' orphaned features found, XML comments representing these features will be present in the output file: <!-- orphaned feature - parent id:'...', id:'...', type:'...' -->Geometry export issue: It does not export correctly after setting up the geometry. In the Inspector, the data appears as a table without geometry.Additionally, the original dataset exchenged in Cit

Hi. I have created contour lines from DEM rasters and I’m getting outliers (straight lines to random points). What is the best way for me to remove these lines? 

Hi! Sorry for my english. I have a problem with  "collapsed parameter/option" on the “user parameters manager” or “FME options” for exemple. All the options that can be collapsed doesn’t display very well and sometime I don’t see there are a suite. For exemple, if I don’t scroll, I don’t see that “Number configuration” had an option “Numeric precision”. Is it possible to had something like a button  or an other way to open an other windows?Thanks !

Hi i am trying to read lots of excel using the feature reader transformer,  passing in the locations form a directory path reader. all the excel have different tab names but the data always start on row 10. As the dataset is a file path the option for telling it to start on row 10 are blanked out. anyone know how i get around this?Many thanks,Andy  

We recently downloaded the 2021.1 version of FME. All previous scripts run on 2020.1 without problems. Now however, I get a warning message "Excel Writer: Failed to refresh Pivot Tables and recalculate formulas. Note this is only possible on Windows with Excel installed" when exporting to an excel with the use of a template. I write my data in 1 tab, and that tab is used to make a pivot table in another tab. Because of this warning, the excels in my dataflow I have stay open and after 20-ish files the memory in my task manager is full, so the translation fails. We did not change the version of Excel, that should not be the problem. Anyone an idea what could be the problem?  

@We have 2020.1 Desktop/Server and are writing to an ESRI ArcGIS Portal Feature Service. It successfully reads and writes using the configured web connection based on the ArcGIS Portal (Template). Unlike ArcGIS Online, the writer doesn't seem to update@ the token and I have to go into the web connection settings and re-authenticate manually. We are connecting to a 10.7.1 Portal and it happens in both FME Desktop and Server. Our 10.7.1 Portal is currently only operating from 7am to 7pm and restarts nightly (Dev environment). I've noticed in the workbenches connecting to AGOL, that the token in updated automatically. But that doesn't appear to be happening in the Portal writer. Is it something I'm doing? Or is it the nightly restarts of Portal? Thanks 

Currently I am working on writing to an IFC-file. One of the classes I would like to write is IfcZone. However, when I try to do that, I get the warning: IFC: Unable to write objects of type 'IfcZone'Now I am wondering whether I did something wrong and I am missing some settings or whether FME does not (yet) support writing to IfcZone?@DaveAtSafe

I am trying to write PDF file using PDF writer, when I add @Value(Scan_Location) in fanout dataset it creates 2 different files as output. And that is not what i want . I just want this name ….20240621 NI2-HK-L03 As-built_PDMS Comparison Report F1.pdf and just one file     

Good morning everyone.I am working with a text type file that I take as an example for cadastral constructions.This text file has a specific structure but a variable number of lines depending on the number of heights of the buildings and the number of premises in each height.I use the file to:Know the name of the floor, for example “Basement”, “Floor 00”, “Floor 1”, etc. Know the number of heights it represents, that is, I do not have to draw floor 02 if it is the same as floor 01.This plant name and the number of heights it represents are related to a DXF file that I am not using at the moment.The first line that I need to read in any file is 27 where the number of heights of the building is expressed, this line number is fixed; and for each of the plants I find the following structure. “23” (Number of total heights of the building” (line 27 of the file)“01” (Number of heights that the drawing represents) (line 28 of the file)“SOTANO -2” (Floor name) (line 29 of the file)“95” (Nu

Hi all,I am trying to read a json file, that contains a collection of objects. It is NOT an array, and the objects have no name, they have just a number. It’s that number I am interested in, but I can’t seem to find a way to get it exposed. My Json looks like this:{ "1": { "name": "msg_status", "data": { <snip> }, "port": 4, "timestamp": 1717497996, "timestamp_parsed": "2024-06-04 12:46:36" }, "2": { "name": "msg_ublox_location", "data": { <snip> }, "port": 2, "timestamp": 1717498735, "timestamp_parsed": "2024-06-04 12:58:55" }, "3": { "name": "msg_ublox_location_short", "data": { <snip> }, "port": 13, "timestamp": 1717498741, "timestamp_parsed": "2024-06-04 12:59:01" }, "4": {

So I have a workspace that reads a DWG, and writes another one after setting viewport attributes according to this article: https://support.safe.com/hc/en-us/articles/25407658483341-Working-with-AutoCAD-LayoutsHowever, even though I’ve set autocad_viewport_view_center_x, autocad_viewport_view_center_y, autocad_viewport_center_point_x and autocad_viewport_center_point_y to display the view at the center of the page, I keep getting the viewport centered at 0, 0 in paper space, so my viewport content is centered close to the lower left corner of the page on output.  I have quintuple-checked that all the required viewport attributes are set correctly.  It seems like the writer is simply ignoring my viewport center settings.I’ve been banging on this for

I have an SDE file I created in ArcPro that works in ArcPro, but whenever I try to add it as a reader in FME (Data Interoperability, ArcPro version 3.2.1) I get a simple error of “MULTI_READER reader: GEODATABASE_SDE reader: An unknown expectation occurred.I tested other SDE connections and they work fine in FME and ArcPro. I have tried generating a new SDE file and connecting with an embedded connection and an database connection in FME. Any other ideas on how to get this connection working? Also, it was working until this past weekend. This is a new issue we have not had before. 

I’m unable to establish a connection to SDE after recently receiving a permanent license file from Safe.  I’ve tried connecting using several methods: connection files stored in 'C:\Users\AppData\Roaming\Esri\Desktop10.8\ArcCatalog\’, connection file stored on a network directory; and typing in the database credentials. I was able to successfully use the same connection files while using the temporary license file provided and am not aware of any other changes in our IT environment.  I’ve also tried (unsuccessfully) to connect to other SQL databases in our Data Warehouse (outside the GIS environment) that contain tabular data and receive the same error message (shown in red below) which appears after selecting the ‘...’ under “Tables” in the Esri Geodatabase (ArcSDE Geodb) Parameters dialog box that normally opens the list of feature classes/tables that can be added to the workspace.‘Failed to retrieve feature types. An error occurred while