Transformers

Hi all. I'm reading five feature types from Oracle using a Feature Reader and I want to suffix each of the attributes in each feature type with a text string.  The reason for this is that I'm running some line on line and line on area transformers and the attributes from each feature type have identical names. The end goal is to generate a dynamic schema (with renamed attributes) on the output tables based on merged feature types from the transformers mentioned above. Is the bulk attribute remover the correct transformer to be using here? Thanks,Michael What have I missed?

Hi, I need to validade if the sum of the numbers is pair or odd. How to make this?

Hi FME Community,I would like to reproject my file into another coordinate system. I am looking for correct coordinate system. ArcMap gives me a correct result. FME gives me wrong coordinate after the reprojector.the pictures show which coordinate systems I used in FME and ArcMap. In addition, my file belongs to Germany. Thanks a lot in advance   

I wonder if aynone has expericence with using asyncio in python FME?I've been trying to decorate with some asyncio.coroutine and do some async def, but I cannot grasp the whole picture on how to combine a syncronized FME project with an async library like asyncio.Anyone who would share their knowledge on this topic would be Awsome!Paal

Table1:table1_id:id-element-1.2.1.1.3(xml_id)id-element-1.2.1.1.4(xml_id)id-element-1.2.1.1.5(xml_id) Table2table2_id:id-element2-1.2.1.1.3.1(xml_id)id-element2-1.2.1.1.3.2(xml_id)id-element2-1.2.1.1.4.1(xml_id)id-element2-1.2.1.1.5.1(xml_id) I want this result:Table3:table1_id table2_id ..3 ..3.1 ..3 ..3.2 ..4 ..4.1 ..5 ..5.1 Thanks   

Hi I have a polyline dataset with X,Y values but the Z field is empty. I'd like to generate the accumulating distance of each polyline vertex as the Z field. Essentially I'd like to just add distance as the Z value.

I am new to the i3s ESRI format and am wondering if there is a workflow or transformer or set of steps you need to take to convert OBJ to i3s?

similar post which describes better but there is no actual answer where /how to choose where data is saved on server. I dont mean the zip that works already I mean control where the files that user uploads will be saved.  Is it possible to control where the Server App download service will download files? (safe.com) Using FME Data Streaming, the user selects one or multiple files to upload, processes those files and it works so the resulting report is downloaded through a zip. My problem is now what if there are multiple runs at the same time? I managed to use the FME_JOB_ID to create subfolders with my logs. for examplein my fme_server_data_reposatory however all files are always uploaded in some weird temporary guid folder.If I use "upload" files in my app, how can I choose where those "temporary files" should be saved? I then want my job submitter to use those folders to look for the data. This is to separate so the result logs for different runs doesnt read the

I don't know if this is already answered somewhere already but couldn't find it.This is in regards to my previous thread about aligning randomly distributed line geometry as per building footprints. Now, I could find GPS traces as point data to align my line geometry as per the points.In the image below: The black line is the approximate required solutionI tried using NeighbourFinder with 3m distance and then MeasureSetter for putting weights. Ideally, I wanted that points towards the center are weighted more than the outer ones. I have attached some sample data for the same. Could someone help me out with any ideas?Thanks.

I have groups of points (2D centroids) that I want to declutter by removing points so that there is a minimum distance between the remaining points whilst retaining the overall "shape" of each group.  The PointCloudSimplifier seems to do this, but is there an alternative for 2d objects? If not, is there a way to convert regular ol' points to fancy point clouds? Or is there an another, better, way to achieve the desired result?

I am trying to do an insert to CARTO table. It is mandatory to not drop the table because it is necessary anytime a table is created to make a specific SQL statement. This table just has to have the last insert values so a truncate command is required. I have tried with a SQL Executor with two statements. Truncate and Insert. What SQL Executor does is a truncate for every insert. At the end I have a table with only one row, the last value inserted. Any ideas?

The error I am receiving just says: Error running translation. Thoughts?

perhaps the easiest way ahead is to explain the bigger picture of what I am trying to achieve. I want to produce individual location maps and block plans for about 30,000 properties. Each plan would be centered its dedicated property but show some detail of neighboring houses and roads etc. I am trying to use the clipper (using buffered property land parcels as the clipper) to clip a base map. Obviously the clippers overlap. The way the clipper works, each clipper takes a bite through the base map, and outputs the result. This means that some properties have many bite chunks removed from their data and their output is incomplete. Ive used FME for over 20 years, but I me not a techy programmer. Ideally the Clipper transformer would have tick box option that says 'retain input clippees for multiple processing' or something....... All suggestions welcome. Regards Dave     

Hi everyone,  Every time I load a reader into Workbench I get an error similar to this "Workspace generation failed. Parameter file was /private/var/folders/tr/rfmmyq590j17jq9ndl8my5lh0000gn/T/FME_1635634267372_8830."  Not sure what the issue is any help would be very much appreciated.  

I'm trying to find and replace a string from a text file where the first part is constant, then the second part of it could be anything, then the last part is a constant. I want to change some of the 'last part' text, keeping the first part + the second part (which could be anything) remain the same. I hope the highly simplified example below illustrates what I mean: Input text: This is constant Line 1 *This is anything Line 2* This is constant again and will change, Line 3Output result: This is constant Line 1 This is anything Line 2 This Line 3 has now changed Does anyone know how this could be accomplished? The files being fed in have hundreds of occurrences of the last part so the first part + second part (though this could be anything, a wildcard perhaps?) + last part search should ensure only one result. I hope this makes sense and thanks in advance!

Hi everyone,  I'm making a workbench where I try to write to a file GDB. To be able to use a fileGBD FME needs to be able to detect a ArcGIS license.  We do have arcmap and arcgis pro, but not on the virtual machine that runs FME. Do I need to install arcmap or arcgis pro on this machine to be able to write to file GDB's ?  thanks in advance

I am trying to connect to an Esri vector Basemap through the REST Endpoint but am having difficulty setting up my workspace. Has anyone had any success with this as of yet? I was able to do this with a JSON filter on the older raster basemaps, but cannot do the same for the vectors basemaps. I am ultimately trying to pull imagery from a specified extent.  Here is the URL of the endpoint in question:https://basemaps.arcgis.com/arcgis/rest/services/OpenStreetMap_v2/VectorTileServer?f=json Any assistance with this would be greatly appreciated!

In the JSONTemplater is there a way to cast an array of strings into an array of intergers? https://community.safe.com/s/question/0D54Q000080hA0SSAU/how-to-coerce-attribute-type-for-jsontemplater?t=1636407693748  answers the question for regular attributes   but this does not work with fme:get-list-attribute. {"ids": [(fme:get-list-attribute("_list{}.id"))] }returns {"ids": ["1","2","3"]}    I would like{"ids": [1,2,3]}  

Hi every oneI have a lot of CityGML files and want to edit the roof type for some of them. After that I want to write it again as it was at first:1-Some normal Buildings and some Buildings containing Building parts2-Each address attached to a building3- roof, wall, and ground surfaces attached to each building But this part of connecting child and parent doesn't work. I attached my Fme file. Can somebody help me? It is really frustrating.

Can anyone explain what I need to do in FME to connect to an ArcGIS Pro Layout to create the PDF Map of the Layout. Do I need the FME Data Interop Extension in ArcGIS Pro to do this via Python? Does anyone have examples of this code?

As stated, I am trying to add both geodb_polygon & geodb_attributes readers, and polygon gets added twice. Everything under General is grayed out and I am unable to change 'Allowed Geometries' on one of them to geodb_attribute. Geodb's were created using Arc 10.8.1

I am trying to write data to a xml data format. The problem is that I get an extra tag or element as shown in the following screenshot, so my first question is how can I get rid of the element which ends with -tabel? My second question is: In the element name I add some extra information like id and parent id. I add this in the xml writer Feature Type Name. This addition comes in the head of the element as well as in the tail as shown in the following screenshot. Is there a way to show it only in the head of the element? I want to have something like the following screenshot: I hope that someone have an idea and will have the time to help me here 🙂  Kind regards,,,

Good Afternoon, I would like to remove the south and Est limit from bounding polygons. Indeed, I have a matrix composed of multiple bounding polygons, their limits are topologic. I need to make geometric operations on points intersecting these polygons. A point can belong to one unique polygon. Unfortunately, some points are located on limits from 2 polygons. The solution I would like to do is to create a new matrix where the limits south and est of each polygon are removed : Consequently, the polygons won't be topological anymore : In this case, a point cannot belong to 2 polygons unsing intersection method.I tried polygoncutter (using the polygon and the limits as Input), but it seems not to work : Any idea?Thank you  

I am transforming a shapefile of roughly 25,000 Los Angeles County parcel polygons into cityGML for upload to Cesium Ion. The translation is successful in FME Workbench, but when it uploads to Cesium Ion, it makes the following error in the Cesium Ion assets browser:  We were unable to process your data due to the following issue:Error: Input does not contain any eligible features for tiling.Read about what data formats are supported on Cesium ion. which is not very helpful. When I view the resulting cityGML file in FME Data Inspector, I see that all of the separate parcel polygons have become one joined polygon (and the extent probably should be trimmed). I see from the tables that I have created one CityModel and roughly 25,000 GenericCityObjects with missing column data. I've attached screenshots that show the values I am getting. What might I be doing wrong? For the 3DForcer height I used 3.0 without units. I'm wondering how to specify units, whether that is necessary (beca

Hi, I have the following table: What I want is to get the column names into a new table as values: Everyday there will be a new name for Column3,4,5,6. The new name should just be added to table without deleting the old values. How do i get the column names into the table?