Transformers

i have read this article and it is useful for me ,what am i looking for but i am not sure ,how could i let feature reader to work . https://community.safe.com/s/question/0D54Q000080hQidSAE/pick-up-latest-file-from-folder-location i have found one latest file that i am looking to from sampler , but how could i open this file to check the data inside and extract attributes .the file format is excel  1. As your source, use a Directory and File Pathnames reader. 2. A Sorter that sorts descending on path_modified_date. 3. A Sampler that only lets the first feature pass. 4. A FeatureReader where Dataset is set to path_windows. this is parameters that i did for feature reader , should i change something ?

Per the TopologyBuilder documentation Generate List From Input Faces Gives the option to create a list on the Node and Edge output ports that relate to information from the input faces.  However when attempting to do so in FME 2021.2, the attributes are show on the canvas, but are not present when the Node output is inspected.Why isn't the _faces{} list propagated onto the node like is to the edge?

Hi, I have some buildings and I will remove internal walls.So for this I use surfaceonsurfaceOverlayer and tester to identify internal walls. That is working in most of the cases. Nevertheless I have a few buildings where the outer wall is removed like this: Maybe someone has similar problems?Is there a way to do a further check if wall lies on the building outline? If this is the case we have to keep this wall!How can I avoid this kind of problem?Thanks in advance 

I have about 2000 line segments that need to be aggregated based on a specific field. First I sort them based on the order they are supposed to be merged in, then I aggregate them if there's more than 1 segment. This results in about 1100 multipart polylines (not all of them are multipart, and some are just made of 1 segment, but others can be made of up to 12 segments).  This works really well for my output data, and the lines are all merged correctly. However, at a closer look, my elevation profiles don't make sense. It appears that even though the segments are in the correct order, some of the segments have a different orientation of their neighboring segment, i.e. one is going North to South, and the next is going South to North. Hopefully the attached diagram can help illustrate this.   I've tried many different transformers to try and fix this without updating the underlying dataset, but I'm not sure if there's a way to fix this in FME? Is my only option to fi

Hi, I have a file with several lines that contain information about a unique record. However only line 01 has the unique information about the property. The remainder of the lines have further information about the property and start with different numbers. The row with the main information always starts with a 01. Subsequent rows have a different number. Can someone please advise how I would add the unique reference in the example below in the second field in line 01 (19633154000) to all the rows below until you get to the next row with line 01. Many thanks. Eg01*19633154000*10870539000*0335**45-47****YORK ROAD02*1*Ground*9002*9*First*1804*12801*17163059000*7648136000*6955*WILKINSON BUSINESS PARK02*1*First*3802*3*First*0.0002*4*First*Kitchen*105*10*0**0*+0

Hi,I have polygon data of different lots of land from a city. The goal is to figure out if any two polygons together are bigger than a predefined value. That means I need to merge two adjacent polygons together, test their size and repeat that process with all other adjacent polygons. (Let's say a lot has 6 neighbours, that means I need to check 6 different combinations) This need to be repeated over the whole dataset (around 5000 polygons).The problem is I don't know how to merge the polygons individually. I tried different methods with NeighborFinder, SpatialFilter, etc. but none of them yielded the results I needed.Thanks for any input!F

In old version we just put the scripts in C:\\apps\\FME\\Python if we need to get them in Python Caller.How do we do it in the new versionsThanks

When I export a 3D solid to dwg I get a Polyface mesh instead of a 3Dsolid.How do I get 3Dsolids? 

Is it possible to filter out a single attribute value from data. I am trying to map pit data and although I have streamlined relevant pits using buffer and clipper I still have useless pits which have the same attribute value ie. 2 pits, B pits, and C pit

FME folks, We have been using FME Server's new event driven automation with great success. Our FME server workspace creates a nice HTML report page when executed and is attached to a notification email upon successful completion of the task. We were just wondering if it is possible without much modifications to simply use the HTML report in the email body instead of using plain text? While I have read and seen some FME workbenches that uses html in creating the email body, our intention is to present the HTML report created to simply appear as the email body when sent out. Any inputs regarding this topic will be greatly appreciated. If not possible now, may be it will be a good 'new idea' for future. Best wishes,Deep Bhari 

Do Cached Values not work in the Tester in Workbench 2019.1? I have 'enable feature caching' on and I see the values for inspection with each step, but when I add a Tester with an attribute I don't see the option 'Cached Values' or 'Select value'.

I have some obj files of building and I want to add different locations to each obj file .please help me to get the way to do it.

I have 50+ tables i want to setup a migration jobb for between MSSQL and PG.Fastest way to set this up is using the "Generate workspace" functionalities. However using this, the table qualifier is set to dbo, default schema for MSSQL . In PG i am not using the same table qualifier name though, so I want to set to use X table qualifier for all the table to be written to PG, but it does not look like that is possible? Do i need to set it for each table manually?Same goes for table name. I want to make it lowercase and remove any special characters automatically if possible.

I have a cylinder that I created using a 3D Bufferer around a 3D Line. How can I convert this cylinder into a cuboid ? Thx. The image helps to understand what I mean.

The same geotiff is placed differently in QGIS (3.22) and FME (2022). QGIS is placing it correctly, or at least as intended by the publisher, and shows a cellsize of 2x2m. FME is setting the cellspacing at 0.1x0.1m. Can somebody explain the difference in interpretation? And possibly how to fix it in FME - in general, not via georeferencer?The original file can be accessed here: https://drive.google.com/file/d/1b9Euqly7DPwwYzEvLNqWj1JgxAGbTBqI/view?usp=sharing/Mathias

I have a huge dataset and I want to make writers based on type. Some types have only 1 samples, some have 100, and I would need to remove all empty sample-columns from all writers. There are over 100 types, so manual work is out of question. I have tried to use NullAttributeMapper and set all values to missing, but how to drop them before writer?

I have noticed this crop up in a few different workbenches since upgrading to a new patched version of data interop 2021.1.2.0 (20210903 - Build 21627 - WIN64). The only solution so far is to run/cache the workbench in sections. Have tried re-installing. Plenty of storage available in the temp directory. The fatal error occurs after saving the cache to the temp directory (but not every time): "Saving spatial index into file...""Finished saving spatial index into file...""2022-02-15 20:43:31| 56.5| 0.1|ERROR |A fatal error has occurred. Check the logfile above for details" It should say "Stored ### features(s) to FME feature store file...." instead of the error message. Anyone else encountering this?

This topic has neen discussed before, but im at a loss. I cant understand why, if an attribute exists in a shapefile, its not added to the list of attributes. I can though, see them in the preview, under the list of available columns.The issue comes, when I am trying to validate the attribute, it dosent exist!, I use the attribute exposer, but all the attributes are blank.Please any help appreciated PS: I have found a work around, If I load individual bulk loads for each dataset type (30) I can load all the ATtributes correctly. This is not ideal, as I now have 30 readers instead of one..

I have an an attribute in my table that is type 'string', and I am trying to work out how to associate a code to each of these different attribute types so this code can be used in the next transformer. See screenshot, for example I have added red text, so for POTHOLES, I need to feed the integer 70 into my HTTP caller, for SEAL OVERLAY I need to use the code 105 in my HTTP caller and so on... I am unsure how to set these codes for each of my unique values. I was about to create a new HTTP caller for each of my different attributes and hard code the variable, but I know that would be a terrible idea as I should be able to code this better.  Have I explained this well enough to understand? I'm having a hard time describing it! 

I'm new to FME and I've found a couple different coordinate systems that will produce different results. Primarily I will use Reprojection to US48-DUKE before any of these tools but I'm not sure what the community would say and maybe have a better answer? Thanks!

I am trying to ETL an LRS-enabled routes layer currently stored in a Geomedia database into a ESRI format that is consistent with typical LRS operations like dynamic segmentation.  The issue is that the fundamental data models that handle measure values within a calibrated route network are different in the two software packages.  In Geomedia, routes are segmented into a series of features (or rows), all of which share a common routeID, and all of which have (as exposed attributes) begin_measure and end_measure. Unlike in the ESRI world, the measure values are not stored in the vertices but in the attributes.  Question is... how do I use FME to efficiently move measure values from attributes of lines in Geomedia data into m values within vertices of lines in ArcGIS data?  Thanks in advance... Adam

Hello, How can I utilize a User Parameter in the SQL To Run After Write? I have a User Parameter (Text Value) with a default value of parcels@DateTimeFormat(@DateTimeNow(),%Y%m%d)  The parameter works when setting the table name for the new table in the DB and the table is properly created: But when the user parameter is used in the SQL To Run After Write, it causes an error. Is that because the value of the User Parameter contains formatters? This line in the SQL:UPDATE '$(ImportTableName)'(I've tried with and without the quotes surrounding the parameter, btw) evaluates to this in the console (and the SQL):UPDATE 'parcels@DateTimeFormat(@DateTimeNow(),%Y%m%d%H%M)'How can I use this parameter in the SQL? Alternatively, how can I utilize a name that is generated at workspace runtime for the table name and subsequently reference it in the SQL?

Hi, I have a ground geometry like this:So this is an aggregate feature, based on faces! Now I will resolve this into a polygon like this: it is not working with Aggregation based on building_id of the buildings! Than I have an aggregate feature like in the first picture  Is this kind of transformation possible? 

Dear Community, I want to read few CCTV inspection reports for pipe inspection which contains details about City, asset number, Inspection info from CCTV report, pipe information from CCTV inspection, defect information etc. in different line. I want to read this pdf in FME and convert those details in the table format. May I have a detail tutorial to understand ...how we can do this process in FME? 

I'm parameterizing the first portion of a dataset path name inside a feature writer dataset parameter to allow easier transition from our development environment to production. I've created the following published parameter.The published parameter's Configuration parameter is set to display name = 'dev', value = ""//myhost.org/Scheduled on FME Server/DEV/dev_start_stop_report_data/"" When the dataset parameter in the feature writer transformer is set as shown below, the writer is unable to find the directory. The error below is returned$(report_data_path)sa_output\start_stop_report.xlsxERROR |Excel Writer: Failed to save changes to the spreadsheet '""\myhost.org\Scheduled on FME\Server\dev_start_stop_report_data\""sa_output\start_stop_report_.xlsx'. Check that you have write permission to the file, it has no password protection and is not opened by another application. Error message is 'No such file or directory.'There may be a better way to go about it, but I'm attempting to use a str