Transformers

Hello, I have a lot of attributes that need to be input into specfic cells in an excel template. Some of these cells are merged and some are not. How would i write each individual attribute into seperate cells based on the template? Many thanks, @Takashi Iijima​ @Mark Stoakes​ @nielsgerrits​ @ebygomm​ @jkr_da​ @mark2atsafe​ @jdh​

Hello everyone, I'm looking for an easy way to extract domain value from a gdb for validation. I know that you can use ArcGIS Pro to export a XML schema from a GDB, but I want to skip that step. I tried to use Schema Reader, but it doesn't give me the full domain values in the attributs. Anyone have an idea ? Thanks

I've an ArcGIS geodatabase feature class with some attributes. I do some attribute mapping and export data in a new geodatabase feature class. Everything works fine but some of the original attributes are not transferred in the output data. I don't know why...... I've used the Attribute Manager to remove and rename some attributes, then I've used the Attribute Creator and the Attribute Keeper, the last step is with a final Schema Mapper and finally the new feature class: but there are some attributes (not interested by any transformation during the process) that are missing (the fields in yellow). Any idea? Thank you

The obvious transformers (Rasterselector, RasterBandRemover, RasterBandKeeper) do not give the desired output. No errors are generated but all bands of the CSAR raster file are still present after processing. The bands seem to be hidden but I can not find a way to make them available for processing.

I've been trying to work out how the light source definition is actually used within the SurfaceFootprointReplacer (with shadow mode set to perpendicular) transformer without luck. My end goal would be to extract an estimated surface of a 3D shape for a hydraulic radius calculation. If I know the shape's rotation from the horizontal axis, how does this get defined by the vector parameters? Defining a point along the face didn't appear to be the right answer, nor was offsetting a point... A simplified workflow showing a cube rotated 45° is attached to illustrate the issue.

Hi there, Thanks in advance for any help. I have a point cloud that is in XY-MT format. My goal is to figure out where the openings are on a 'flat surface'. I have taken the point cloud and filtered it so only the data I care about is being used (PointCloudFilter). I am now left with a point cloud that clearly shows my openings. I am looking to show the XY coordinates of the 7 openings shown on the attachment. I have tried a few of the transformations, but I am not having much luck. Can someone point me in a direction where I may find the positions of these openings?

I just upgraded to ArcGIS Pro 3.0 and upgraded Data Interoperability (FME(R) 2022.0.0.2 (20220518 - Build 22343 - WIN64) . I have several tools built in the previous version that are now failing. The only error message I get is literally: "Error running translation". That's it. Not very helpful. Has anyone else experienced this with the Pro upgrade to 3.0?

I have two datasets with polygons that I would like to connect with the linebuilder in order to show the distances. One with adresses, the other with corresponding numbered objects. For each object for each adress there should be a line (or a point when these are identical) For this I would like to use a centerpointreplacer for both followed by a linebuilder (and lengthcalculator). However the linebuilder generates polygons when there are multiple objects with one adress that have the same xy as the adresses and one or more objects that have a different xy. I tried using a sorter with both datasets (the adresses on adress, the objects on adress and number). The sorter for the objects has a group by on the adresses. However: Grouping the objects in the linebuilder by adress I get polygons. Grouping in the linebuilder by adress and number generates points only. Any thoughts?

I am reading the polygon and Lines dataset in FME. I need to select lines that are intersecting a polygon and populate the polygon name in Lines. I have used tester after feature to filter one polygon and select intersecting lines using a spatial filter. Is there a way to loop through a polygon feature and select one polygon at a time in FME, Instead of entering the Polygon name in a tester every time.

I'm trying to connect to our SharePoint Online environment to be able to work with lists. In FME Workbench (2021.1) I used the "Microsoft SharePoint Online (template) to create a new web service. When I try to test it I'm getting an error: "Authorization and token retrieval was successful but refreshing the token using 'Refresh Token Parameters' failed. Error: HTTP/1.1 401 Unauthorized". My redirect uri is set to https://localhost My Auth parameters url is: https://login.microsoftonline.com/{mytenantID}/oauth2/v2.0/authorize?scope=https://{mytenant}.sharepoint.com/.default offline_access&response_type=code&prompt=consent Retrieve Token Parameters url: https://login.microsoftonline.com/{mytenantID}/oauth2/v2.0/token refresh token Parameters url: https://login.microsoftonline.com/{mytenantID}/oauth2/v2.0/token request format (default carried over from template): client_id=[CLIENT_ID]&refresh_token=[REFRESH_TOKEN]&grant_type=refresh_token In Azure, my app has Graph permissions added for S

Good day, I tried to convert XML file to shapefile using FME and using the same steps in safe website but the data did not show up in the map and the shape was point, and what I was expecting is line. Here is the data source of XML: OneGeology catalogue (brgm.fr). Thank you with kind regards, Majdi

My purpose is to save it as .txt document. Manually I can open it in notepad and save it as .txt. But this has to do through FME.

I'm try to translate a multilayer GDB file to GEOJSON file. As a result. I found all layers are merged into one single layer. How can I translate it into multilayer GEOJSON

I'm trying to read a Orthophoto from ArcGis-DB using Reader-Transformer Geodatabase-sde-Raster-Dataset and clip an specific area of the raster using definition of Search Develop. At the End, make a tif export from that. The Problem is that FME represent the reading raster als grayscale, although the raster has four bands. How should I export a rgb tif from raster dataset? I would appreciate any Help in advance. with regards Soschianet

Hi! I'm trying to extract parts of a response body from a HTTPCaller. I've read some previous threads on the topic but I just end up more confused. The response body looks something like this: [{"href":"https://download-geotorget.lantmateriet.se/download/99d120aa-9532-43a9-a5a7-6128b333bc88/files/root/militartomrade_kn0125.zip?q=t-CwjGgGH....1Vl4dA==","title":"militartomrade_kn0125.zip","type":"application/octet-stream","length":3792,"displaySize":"3,7 kB"}, {"href":"https://download-geotorget.lantmateriet.se/download/99d120aa-9532-43a9-a5a7-6128b333bc88/files/root/hojd_kn0125.zip?q=t-CwjGgGHQJjXdA1styBEV1B.... ] And so on. It goes on like that, so I shortened it down. The parts I'm trying to 'extract' are several URLs, and I'm looking to create attributes from them, in order to download the zip-files they point to. Does anybody have a solution to this? You might have noticed by now that I'm quite lost in terms of technical lingo and so on, any help is appreciated. Cheers! /Alex

What is the best management practice (bmp) for assigning Unique ID to AutoCAD drawing (dwg) objects? I am preparing to use upsert (haven’t upgraded FME yet) and need to establish a Unique ID for every AutoCAD object that becomes a feature. The current workspace ingests ~300 drawings, transforms to GIS features, then writes to a single feature class in an ESRI geodatabase (gdb) file. Up until now, my focus has been on the ingesting and transformation. The current workflow simply overwrites the entire feature class every run. Now, with upsert coming, I want to refine my process to update and insert only modified features. I understand that AutoCAD object ‘handles’ are unique to each drawings object, but I’m thinking not necessarily unique across multiple drawings. I could concatenate handle with drawing name, which would work for me currently, but could at some point be flawed, as drawings in different directories could have the same name. I have other ideas, but want to hear form the co

Hey there, Trying to figure out of this is possible with the current data I have. I have a road network that looks like this of which I generated points for the mid-points of the segments. The road network does have froms and tos. Essentially we have a camera on a car that needs to traverse this network in the same direction every time to make comparisons going forward. So ideally im looking for the quickest way to travel this route hitting ALL of the roads and have something that can be repeated every month where the driver is going the same direction every time. Is there an article on this I can't find?

I have lab data that is reported in rows, one row for each analyte for each sample. I need to create a single record for each sample, with the analyte values as columns in the record - build a single record of analyte values for each sample. to this:

Hey guys, I have XML Meta data files which I read and aggregate to one table to write them in a ArcSDE. The SDE is an Enterprise Geodatabase and the platform is SQL Server. To Connect to that SDE I need username and password. I use the FME Workbench directly in ArcGIS Pro and my connection to the database is existing. When I use the Writer "ArcSDE Geodb" FME is asking me for "Connection file". How do I get such an file? Or is there another way to publish the output directly in the SDE? Thank you in advance! Take care Cheers, Fabian

Hello! I have a problem while trying to read the data from postgresql (I'm not an expert). Everything seems fine with database connection (test is successful - also I'm able to connect with the same parameters from psql). The reader is created, I can see the attributes of chosen postgresql table. Everything goes well until I hit the RUN button. Then I get two types of errors: Error executing SQL command ('SELECT c.relhasoids AS oids FROM pg_class... Error executing SQL command ('declare "public_xxxxx_crsr" cursor... Does anybody have some experience with this and can share some guidance. Thanks in advance!

I have several IFC files, each one has its own structure. I managed to save some of the data as a polyhedralSurfaceZ in postGIS, but some of the data structure is more complicated, and saves as a geometry collection of several types. I only managed to save it to postGIS when the geom type is the general "GeometryZ" but then I cannot used the indexing power of postGIS and queries take forever, and some don't run at all ( like st_volume) is there a way to transform the geometry collections to a solid that will be saved as polyhedralSurfaceZ? example of such data: GEOMETRYCOLLECTION Z (CURVEPOLYGON Z (COMPOUNDCURVE Z ((.... some also have PolygonZ , some have POLYHEDRALSURFACE Z

Hello everyone, is there any way how to write custom file properties (metadata) to Sharepoint, please? Thanks a lot Lubo

An Oracle table with 16339 features is called in a workflow. After that a tester selects items with conditions: CODE begins with RK or CODE begins with PK. All but 4 items are selected. The workflow works without problems in FME Desktop, but fails on FME Server. As an alternative I put an SQL query in the tabel reader: CODE LIKE 'RK%' OR CODE LIKE 'PK%'. To my surprise it - again - works in FME Desktop but fails on the server. So it seems the problem lies in the Oracle database table. Any thoughts?

In a same dataset I have two columns that I want in a same column. How can I do that ? Thanks