Transformers

Hi all,I want to read out an Rest API. I examined the contents of the api using Swagger. I first have to authorize myself to use the api. After that I have to login on the API. With Swagger this works all well. How can I do this in Workbench? I started with a creator. Connected to that I use a HTTPCaller to authorize myself. That's working well. Than I use a HTTPCaller again to read out some data with the credentials of the login window. Than I get an error of accessing the url.  What is the best way to work with this kind of "double" authentications?

want to ask about my research, which is about converting IFC data to CityGML and CityJSON formats for 3D Cadastre. I'm having problem converting citygml model to cityjson using fme . The citygml model I got from converting the ifc model on the fzk viewer. The ifc elements I convert to citygml are ifc space . But when I convert it to a cityjson model, the space (room) element doesn't appear in the ninja cityjson viewer (https://ninja.cityjson.org/#). Can you explain why this can happen? does cityjson not support space elements represented in lod4solid model?

Hi all! This is a follow up from this post - super quick recap is that I have lots of Excel files, and I need to read their column headers into their own sheet.  I was able to get the FeatureReader running (thanks to excellent support agent Trent!) with a single Excel file. However, I'm running into an issue now when I try to run multiple Excel files at once, I get the following errors:The schema did not contain information for sheet 'test_data'Excel Reader: The schema did not contain information for sheet 'test_data'Excel Reader: The schema did not contain information for sheet 'test_data'Failed to obtain any schemas from reader 'XLSXR' from 3 datasets. This may be due to invalid datasets or format accessibility issues due to licensing, dependencies, or module loading. See logfile for more informationFailed to obtain any schemas from reader 'XLSXR' from 3 datasets. This may be due to invalid datasets or format accessibility issues due to licensing, dependencies, or module loading. See

I'm using a FeatureWriter set to Esri ArcGIS Online Feature Service to publish a Feature Layer having a polyline layer to AGOL. How can I reference the polyline layer URL in FME right after it gets published?

I have converted a DWG layer to shapefile and am in the process of trying to georeference it. I have used the AffineWarper to get the data to the correct location but the scale is too big and I need to reduce it. When using the Scaler it changes the location. I then used the Offsetter but it does not place the features where I need them either!Any help would be much appreciated 🙂Screenshot shows process after AffineWarper with features in right location but with wrong scale.

I would like to switch fields names and their values in Excel . Because for now, fields names are in columns and their values are in rows. Thanks for helping.

I'm trying to separate several years of data based on an install date which is input as a string field.  The data is manually input as a simple string (ie. "2019" no day or month information) and in an effort to keep from having to manually update the entire process at year's end I'm using a test filter with date/time functions that will pull out "Current Year", "Last Year", etc. for several years of data but I'm having trouble getting the string converted to a format that the date/time functions will recognize. I've tried using the string formatter to get the string into a number which I thought would register as a date automatically with FME but that doesn't seem to work either.  Any thoughts? This seems like such a simple issue I can't find a solution for.

Hello! FME newbie here 👋 I have 100+ Excel workbooks, each of which has 2-4 worksheets in them. To prep to do some schema mapping, I'd like to read out all of the attribute names to a new spreadsheet (Excel or CSV, doesn't matter). Could anyone give me some guidance on how to do this? I've played around with the following transformers, but haven't had much luck figuring out how to use them to do what I'm hoping to do:Sampler (with no header on Excel reader)AttributeTransposerFeatureReaderAttributeExposerAny help, guidance, or links that might point me in the right direction would be much appreciated!

I have numerous shapefiles in numerous folders. While I can parse through all of these and convert directly into a GDB I will have 203 separate classes. I would like to use the parent folder name as my feature class name. Each folder has a varying number of SHPs in it but they all belong to their parent folder.

I have to read and process features in several File GeoDatabases and was going to use the FeatureReader to do so. I expect not more then a single feature class in each gdb, and you can see the parameters dialog in the following. It does not matter if I change the output ports from 'Single Output Port' to 'One per Feature Type', all the features in the feature class are read, but their attribute table only returns a single column, labeled <no schema>, while the Schema output port of the FeatureReader contains the structure of the initiator, and an attached ListExploder shows the correct schema. Yet, I do not get any attributes of the objects, due to <no schema>. How do I get the proper schema of the GDBs returned, so that I have the correct attribute values to work further?

Firstly, I have 10 .gml files and want to convert these files to cesium 3d tiles, then want to show this model with cesiumjs. However, in result of my workflow, I got several errors and warnings.1- I want to show my workflow in FME :2- I want to share errors which I get :Finally, This workflow has been completed, and then b3dm file and tileset.json have created. However, tileset.json file has created erroneously. For example, bounding volume is not created correctly.3- I got screenshot in order to examine:I want to complete these steps efficiently.Which transformators should I use in this workflow in order to complete and visualize buildings? How to solve this problem? I would be appreciative.

I'm inserting data into an Oracla Spatial with FME Desktop. I see that the data is written correctly when used or when I see SQL Developer, when showing that a resource is not designed by ArcGIS, but it shows that a resource is not designed correctly and does not open in ArcGIS, what will be done?   Thank´s

I have a set of lines and I would like to find the lines that intersect but where the end node do not touch. For instance, I have two lines L1 and L2, L1 touche L2 at the midpoint of L2. In this case, I would like to extract L1. Any ideas?@Takashi Iijima​ @jdh​  and others

I'm looking for the FME transformator equivalent to QGIS Minimum Bounding Geometry in order to extract the orientation (azimuth) of the feature shape. This topic is not relevant as it refers only to hull because the concern is about the angle of bounding rectangle, i.e. main direction of the geometry (polygon).

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