FME Form

Sorry, I'm new to FME and don't know which transformer to use. I am working on an FME project that is currently getting an XML response using an HTTPCaller. The Output of the HTTPCaller has many "attributes" and then the Output is passed to an XML Fragmenter. The XML Fragmenter output is the same but has one new attribute pulled from the XML response. It then is passed to an XMLQueryExtractor which then adds another attribute. I need to get the value of a tag and I'm wondering if I should add an XML Flattener or Fragmenter or perform this in the XML Query Extractor or some other transformer.an example of what I need is the value in <sub3> in the following XML example and save it to a variable for later use. <Root><sub1><sub2><sub3>value</sub3></sub2></sub1></root> Thank you

Hi.I'm exploring the possibility of making request to a secure server using FME.The webservices to be called require that the requests are accompanied by a company or function certificate. It will typically be stored in a certificate repository on the machine.I can make it work manually using HttpCaller with authentication = "Single Sign-On", but this prompts me for a certificate password every time, and the final script needs to run fully autonomously (on an FME Server).Any help is appreciated.Cheers.

Since upgrading to Desktop 2022, my workspace no longer reads my portal feature service writers. I have ArcPro and ArcDesktop on the same computer as my FME Desktop license. Does anyone know what could be causing the connection loss?

Hello  I have 4 different IFC models and wish to merge them into one.  Could you please help me ?  thanks in advance.

I am trying to clip a point cloud using the values of a csv using the reader, but the PointCloudFilter transformer does not accept the @Value() field. I am at a loss now. Any help would be great. 

I'm trying to convert datetime values in ISO format to FME, because PostgreSQL database refuses to write that value as "timestampz". I have tried to both autodect and %Y-%m-%dT%H:%M:%S$The preview show correctly the conversion:But the ouptup stays the same:Any hints? Thanks

On this picture, i have a circle which contain a polygon.I would like to know how i can obtain this circle when i have the coordinates like in this picture.The circle doen't pass by all the points.Any tips and trick ?Thanks

I have an OBJ file that I am converting to a Multipatch in an Esri FileGeodatabase. The process mostly works but the colored mesh in the georeferenced OBJ file appears as a white mesh, with no color, in ArcGIS Pro. How can I preserve the detailed colors?

Hi Safe team, Do we have an idea on which formats support mesh vertex colors? I can't see Information in the quick facts area for formats (e.g., OBJ) about vertex color support. It seems like it's becoming more an more common to see mesh objects with vertex colors instead of a texture. I'm just wondering what formats FME can read and write to where vertex colors are supported. So far form testing I can see OBJ supports reading them? A follow up question, is there anyway to convert these to regular appearances or a texture atlas for formats where the vertex colors aren't supported? Perhaps @daveatsafe​  has an idea? 

I am using Data Interoperability (Build 21302) from Pro 2.8.4 to frequently refresh tables in an ArcGIS Enterprise Geodatabase. The tables are registered and published to Portal. The client is using the data in web maps, apps and dashboards in ArcGIS Enterprise Portal and require specific web layers to have little or preferably no time where it's empty of data.  Instead of using the Truncate and Append to Existing table in the ArcSDE Writer I am using the ChangeDetector to set all new features coming in as both "Inserted" (containing the latest data / timestamp) and "Deleted" (data from 5mins ago) then in the writer match by Unique ID. From testing this enables a "seemless" refresh with minimal time of the table appearing empty in Portal.  Is this method at all stupid or precarious? If so, what is a better solution. Additionally is it risky to read in and write to the same table in the same workspace? Backgr

I am running a workbench to split transactional work orders onto different worksheets in an .xlsx writer using FME 32-bit 2021.1.6 We have hit the 2gb memory ceiling due to the number of rows, as a work around I have installed the 64-bit version, but now i find where before it took a few minutes to write out the .xlsx output in 32bit the 64-bit seems to slowly parse through the feautres as it write them out, its much slower over an hour and I stopped the tranlsation. Is the performance really so different in 64-bit?

I have this workbench in which I combine multiple CSV-files and write out to one Excel-file. the file contains aprox. 190K rows. In the previous FME version (2020.x) I used this workbench it took a few minutes. Now the XLSXW is taking hours to write the output.  Did something change in the way the XLSXW writer functions? I did a test by writing to a CSV file, this took seconds to complete, so clearly the problem lies with the Excel writer. Hopefully someone knows about a fix. Cheers, Jaap

Hi,I am wanting to upload files to an instance of NextCloud as part of a distribution service for an department; this would consist of uploading a zipped folder/files to nextcloud, before emailing a link with the data (with shared permissions) to the requester.I am running FME Desktop 2020.0.3.0, I am able to figure out how to download via the HTTPCaller (GET with specific URLs), but uploading (PUT or POST) does not work.Has anyone figured out how to utilize HTTPCaller with NextCloud fully?Thanks! https://docs.nextcloud.com/server/20/user_manual/en/files/access_webdav.html

What the differences between XML and AIXM?

Hello, can we convert .shp files, to aixm (.xml) ? and how to convert them, thanks

I followed the steps in Example 2 here to switch my table columns to rows: https://community.safe.com/s/article/transpose-a-table-using-fmeIs there a way to keep the original column order as the new row order after the table is transposed?Using the counter/sorter, as outlined in the example does not give me the desired order of rows.  

Hello, I want to select building polygons that are completely contained by an agglomeration boundary polygon - I have been trying this with SpatialRelator and SpatialFilter, however whatever setting I try the transformers always seems to split the buildings that cross over the agglomeration boundary, separating them into two features. Really, what I am attempting to do is just filter through those building polygons that are completely contained within the agglomeration boundary, and disregard those that are partially within and partially outside of it.  Appreciate any advice on how to facilitate this.

Hello community, I have a street dataset with 2139 records, with each one being a line (for those in UK LAs, note that it is the LSG). It includes a field called ‘street or numbered street’.  For 2040 of the records the value in the ‘street or numbered street’ field is a named street (e.g.: Acacia Avenue). For 28 of the records the value in the ‘street or numbered street’ field is an A road (e.g.: A312). For 14 of the records the value in the ‘street or numbered street’ field is an B road (e.g.: B204). For 57 of the records the value in the ‘street or numbered street field is an C road (e.g.: C5840044).  I want to filter out the three separate road types: A roads, B roads and C roads. I want to ignore the 2040 named street records.  What’s the best way to do this? A filter? Query via the Text Editor within the Writer? What would the code be?

I have a series of 2D polygons with attributes for slope and aspect. I want to rotate them about a horizontal plane (using a 3DRotator) so that they become 3D shapes with these properties of slope and aspect. However, I want the spatial extent of the shape to stay the same, i.e. if I were to force it to 2D them again, they would look identical to how they did before. Effectively, this means that all of the vertices need to be elevated/dropped in the vertical plane. This is not so much a rotation as a stretch. As an example, if the polygon has a slope attribute of 80 degrees, by the time the shape has been made into a 3D sloping polygon, the planar extent of the shape would be much smaller and, if it were forced to 2D again, it would be also much smaller. The higher the "slope" value, the more the shape would shrink in its planar extent. Does anyone have any suggestions for how to achieve this? I effectively want the reverse of a 2D forcer.

Hi, The GoogleBigQueryConnector return the error of Python Exception. I'm not too sure what should I do to resolve this exception. I'm using the new version of FME 2022.1. Previously this transformer is working well in the FME 2020.Message error detail:Python Exception <ImportError>: cannot import name 'decodeWWJDString' from 'fmegeneral.fmeutil' (/Library/FME/2022.1/python/python39/fmegeneral/fmeutil.pyc)PythonFactory failed to load python symbol `fmepy_google_bigquery.connector.GoogleBigQueryConnector'Factory proxy not initializedGoogleBigQueryConnector_CALLER (PythonFactory): PythonFactory failed to process feature Can someone help me on this please. Thanks

Is it possible to move files to an error directory when a FeatureWriter fails? Unfortunately, I have not found a way so far. Is there any other way than to use an FMEServer Automation that triggers another FME Workbench in case of an error, which only moves files to a directory? Is it possible to achieve this with only one FME Workbench?

I am using the RasterDEMGenerator transformer to create a digital elevation model. The resulting raster cells cover the entire bounding box of my point cloud. So far so good.  What I want to achieve is, that such raster cells, that do not cover any point of the point cloud will have a "NoData" value. I have tried all of the available interpolation methods, but non eof them seemed to work in this respect.  Any ideas? Thank you

Anyone know why FME when trying to run a workbench it just hangs? Sometimes I can stop and start the workbench and it runs but it just says it is starting translation and stays like this and doesn't run anything. It was working this morning but now it doesn't want to play ball.

Hi,FME seems to display a single point from Oracle at the wrong location. I have a simple workspace with a SQLCreator with the following statement:select SDO_GEOMETRY('POINT(163170.864 501575.234)',28992) from dual I would like see the location in the visual preview so I have a background map which is a WMS in the same coordinate system: http://www.openbasiskaart.nl/mapcache/?  with the layers {Openbasiskaart}|{osm}. The point is shown at the wrong location somewhere in the middle of the sea. When I add a bufferer with 200 meters it is shown at the correct location. Is this a bug? I have attached my workspace (FME 2021.1.3)

I have read in data from an ArcSDE database and I would like to update data layers on ArcGIS Enterprise with this data. I am coming across two issues: 1 - My workbench FAILS with the following error: ArcGIS Portal Feature Service Writer: 'addResults' error for a feature in 'LAYER NAME'. The error code from the server was '10500' and the message was: 'Database error has occurred.'ArcGIS Portal Feature Service Writer: 0 features successfully written to 'LAYER NAME', but the server rejected the 100 features in the last request due to errors. See warnings above. Aborting translation2 - My workflow successfully completes BUT data is only truncated and no data is written onto the ArcGIS Portal data layer, so the layer is empty. The translation log says 'Total Features Written: 0' with no errors or warnings.  I am using 'Writer Mode: INSERT' (also tested with UPDATE but sti