Transformers

Facing an issue while trying to connect Oracle 19c instance using FME 2020.2.3 with oracle client 11 and 10 and jdbc driver 5,6,11. We tried adding below lines in sqlnet.ora file but getting error like" no authentication protocol".

Hi folksI am working on a database that has multiple fields that could contain a part of an address, I want to merge these fields and then split them into the specified fields eg House number, Street name & type, Country, Suburb, State and Postcode.  Some records may only have 2 of the fields populated whilst others may have all populated. I've managed to do this using a very convoluted sql script in the past but was hoping that there might be an easier way to do it in FME See attached for before and after   

I have a Autocad Dwg file which needs to be converted to imdf file format. I have an active Autodesk Autocad account to work with Dwg files. Please guide me on how I would proceed with FME on converting the cad file to imdf file.

Hey community!Question: How can I intersect 3D building multipatch features with 3D lines? tnkx a lot!

I am using FME 2021.2 with a PostGIS reader and an XML Templater and XML Formatter to write an XML output file. This works fine, but the coordinate X/Y output appears in scientific notation as below: <Vertex>  <X>2.010340655257836E6</X>  <Y>6.7378739141772166E6</Y> </Vertex>I have tried all kinds of different things, however I can't get FME to format the output they way I want it like below:    <Vertex>      <X>2010340.655257836</X>      <Y>6737873.914177217</Y>    </Vertex>This code fragment in the XML Templater works:<Vertex> <X>{geom:get-x-coord()}</X> <Y>{geom:get-y-coord()}</Y></Vertex>This does not:<Vertex> { let $l := geom:get-x-coord() let $r := @Format(%.2f,$l) return $r }</Vertex>I can't figure out how to pass the X value above into the format function, or find another workaround.

I have a centerline for a river (2d) and some nearby measurement (3d-points). I want to single create a 3d line that takes the z-values from point within a distance of 100m. So far I tried chopping up the line using the pointOnLine-overlayer, but I can't transfer the z-values nor relevant attributes. I tried several approaches, like deconstructing the line into points, but I feel I am missing something crucial. Does anyone have a solution or some advice?

Which transformer to use to combine column in ArcMap? For instance I want to associate Transformer with High Voltage Fuse?

I'd like to run this quarterly using parameters for the date specific strings.Thanks!

How do I convert tif file to Arc/Info binary grid?

How to compare schema difference between to gdb and get a status report matching/nonmatching

Name attribute will come in columns and value come in rows  Is there any way to that Output come like this 

Let's say I have two Line L1 and L2 that intersect on point A.Line A has node on point A but Line B does not.

What R Packages and Python Libraries are available on FMECloud?

I get this Error: ArcGIS Online Feature Service Writer: The geometry type of feature type '[LAYER]' is 'arcgisonline_point', but the geometry type of the corresponding layer/table on the Feature Service is 'arcgisonline_multipoint' I previously used ArcGISOnlineConnector to upload -> Publish a ziped shape-file to a feature layer. But when i later want to update the feature layer with the same shape i get this error.  Anyone know how to fix this?

I've been searching everywhere and coming up empty. I'm loading data from a SQL Server database that users can use to store images as well. The image is stored in a field called "photo" and it is stored in base64.  You can see an example of the base64 data that's being stored in the field (attached). Using online tools and copy pasting the contents of this base64 data does render a png image, however, I cannot get FME to convert it into something that I can export to a folder or even store as a regular raster in the table. Wondering if anyone can provide some clarification. Every base64 image starts with the following: data:image/png;base64,I tried trimming that bit and taking just the encoding and running it through a text decoder. In the "character encoding for binary data" I chose "Binary (fme-binary)". Then i used an attributefilewriter to write the data into a folder. However, the resulting images cannot be opened using any image viewer.Any help on this matter would be appreciated

maybe if you have the correct schema for xml validation, can you share it with me ?. Because I don't understand how to validate the xml citygml schema in fme Best Regards

I don't really want the user to have to download a text file containing the information, then have to open it to find out the answer. I'm hoping to be able to present this to them via the apps webpage but I can't find out how to do this. Is it possible? Do I need to do something with the HTML writers? Thanks,Dave

Hello,I have a 3D line, the z value is varying along the line.I want to create a solid which is 0.1m above the line and has a height of 8.Its length shall be 9m and its width shall be the same as the line.I also have point cloud dataset. The goal is to keep only the points which are inside the solid.The image shall give you a better idea.Btw the coordinate system is in meters.Thanks for your help.

Hello, I am using FME 2022.0 Build22337 (Oracle Edition). Every time I try to update the Oracle Feature Type Writer (Update Feature Types), FME now crashes without warning. Am I the only one who noticed this behavior?

A workspace runner have 100 or more files. Some files have errors. How to save files with errors separately into another folder from workspace runner?

Hello there how could we change the bounding box size as shown bellow keeping the reduced size in the same place Thans  

I would like to remove duplicate features based on geometry. It's a dynamic workbench where i query out all tables which intersect with a polygon.  The problem is that our database contains some duplicated features. For example 1 layer for the whole country, and 1 where it's only a small part of it. So i just want one of these.  I have tried to use this guide. But the problem is that the geometry is not 100% alike. So the CRCCalculator gives different values. The coordinates are more exact in one of them.Any tip on how i could fix this? Here is an example of how the difference is for the same point:  

I would like to extract exterior box of my ifc file and remove all interior element and i didn't find the right transformers to do this.

Hi, I have successfully used APIs for simple HTTP GET requests. However, at the moment I am trying to download a table (or the whole site) from https://st.hwmonline.com/DG/Secure/SitesList.aspx where monitor sensor information (name, id, address) is stored. The problem is that when I call that URL (together with authentication headers) only the first 50 sites are shown. There are however thousands which I need access to. Entering the site via browser, there is a button 'show all sites' below the table which I need to somehow pass into my HTTP caller.  This is an excerpt of the source code that refers to said button. When trying to put "dropMessagesNumber=0" into the header nothing happens: <select name="ctl00$ContentPlaceHolder1$siteListInfo$dropMessagesNumber" onchange="javascript:setTimeout('__doPostBack(\\'ctl00$ContentPlaceHolder1$siteListInfo$dropMessagesNumber\\',\\'\\')', 0)" id="dropMessagesNumber" style

Hi,  Very new to using FME but I've been following the tutorials on How to make Minecraft worlds. I'm using the same workspace as the Moai statues with my own data subbed in, but when I convert my elevation model I get an error saying there are negative z values. When I check the DEM itself there are no negatives so I don't understand where the issue is coming from. It is roughly 4sqkm with a max height of 30m as well so it should be well within the appropriate size. Thanks