FME Form

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?

 In my workbench I have a WKT that I send (using HTTPCaller POST) to an API. The API then runs a background model and I need to use a HTTPCaller GET to retrieve the json results via the same API. The model can take anywhere from 5 seconds to 3 minutes to run. When the model is still processing it returns a '202' status code and when it completes successfully with a '200' code. Right now, I have various decelerators, however, this slows down the entire workspace, I would like have the HTTPCaller wait or check for a 200 response and continue the rest of the workbench immediately.

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

The BIM360 connector is updated 17-3-2022. This update changed the RedirectURI from the "safe.autodesk-bim360docs.Autodesk BIM360 Document Management" connection settings to "https://www.FMEBIM360DocsConnector/oauth" (red box in image)Because our own BIM360 client only accepts "https://localhost/" our connection fails. Maybe we shouldn't have changed it to localhost but set FME url to the client settings on forge but we don't know. FME Warns it's users to make their own Client and not depend on the Client from FME (orange box in image) You can't make your own name for the connection settings, because the BIM360 connector from FME Hub will only look at connection settings with the original name. (yellow box in image) Also the AutodeskBIM360DocsConnector updated it's settings without asking the user. We have the changed the clientID, clientSecret on multiple devices and none of the users accepted any change. I think there are 2 issues tha

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 

Hello,I wonder if anyone has experience in both FME and Pentaho. I have several years experience in FME, but know nothing about Pentaho.Currently our team of Pentaho users considers the switch to FME. I have shown the possibilities and when it comes to functionality, FME seems very promising! However, Pentaho seems to be 6 times faster than FME... This might be a showstopper and we want to know whats is causing this. Does anyone have experience to get better performance writing to (or reading from) Oracle datasets? I never had the experience that FME is slow in reading/writing to Oracle, but when I see the speed of Pentaho, I was surprised of its speed.We did a test of a ETL-script that reads about 912.000 records from an Oracle Database and writes the result directly to another Oracle table. In short: SQLCreator (type Oracle) --> FeatureWriter (type Oracle). Duration in FME: 5 - 6 minutes; duration in Pentaho is about 45 seconds. We were reading and writing to the very same databas

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 would like some advice on setting up a workbench that could retrieve the number of interior angles in a polygon that are classed as concave (i.e. >180 degrees). So far I have the following:run my polygon featureclass through the 'convexity filter' to obtain only concave polygons. I then use the 'Orientor' to assign the right hand rule before passing it through the 'VertexAngleCalculator'. I then use a tester to filter those angle that are negative (i.e. concave).Use 'statistics calculator grouped by original polygon UID to get the total count of features.merge these attributes with the original feature class. This works fine as long as the first/last vertex in the polygon is not a concave angle. This is because the 'VertexAngleCalculator' returns a value of '0' for the start/end vertex - and therefore cannot be classified.  Unless there is a simpler way to obtain all interior angles for each polygon, my thoughts would be to re-run the pr

Hi all,I have three layers district, plans and plots.When I cut the yellow polygon (plans) based on the red one (district) the plan will be 4 parts.My question is how can I make the cutting conditional if there is a plots cut the plan based on district (the right corner in the image bellow), otherwise don’t cut and according to this condition the plan will be just 2 parts.

I made a simple workflow to compare two datasets using the Change Detector and make the changes to one of those datasets using a writer. The process works fine, but it takes roughly a second per records updated. Is that a normal speed? It's alright for small numbers of changes, but this dataset can have thousands of changes from day to day, which would make the workflow run for over an hour, and that's only one dataset when we need to update dozens of them every night. I've looked at the performance tuning article and it either doesn't seem applicable or I don't know enough about the software to know how to check it. My data isn't versioned so I'm using a Transactions writer; I saw another question that had this problem but the answer was to not using the versioning writer. The writer is set to fme_db_operation (so that the updated, inserted, and deleted ports of the Change Detector will work) with Use Existing as the table handling. If there's other inf

I have a scenario where I have a HTML report generator, it saved the report on a local disk. Once this HTML report is saved I then wish to send an email with the HTML report as an attachment, but as the Writer doesn't have an output port, I cannot trigger the emailer this way. How do I tell the emailer to run once the Writer has finished? 

Is it possible to color code coordinates based on range values ie. 4 colour coded levels low 0-500, Medium 501-1000, High 1001-1500 Very High 1500+. I am trying to color code rainfall data against above. I have attached a sample

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.

Hi all!I have a workflow when I read and download image attachments from ArcGIS Online. I have used the AttributeFileWriter to download the image to a unique filename and it has always worked smoothley.  Now I am trying to do the same with image attachments from our ArcGISPortal and it works fine to read and download the files, but when I try to open the files it says that “It looks like we don’t support this file format.” If I go to ArcGISPortal and manually downloads the image file, it works fine. Does anyone recognize this phenomenon? Best regardsJohan 

Hello,We have been using FME Desktop for a number of years and have just recently started wit FME Server and I am not sure I fully understand how all of the pieces go together. I was working my way through the Invasive Species tutorial and got to where you pass the 'webhook.feature' from FME Server to an FME Workspace to complete the workflow. My issue is we are using FME Desktop 2021 and with the new User Parameters I cannot create a User Parameter with a '.' in it. As far as I understand the 'webhook.feature' is what I am trying to pass into the workflow but FME Server automatically created the 'webhook.' syntax while FME Desktop no longer allows for the '.' Please excuse my very basic question about user parameters but am I not trying to create a user parameter called 'webhook.feature' to grab what's coming in from FME Server or am I totally out to lunch as to how things are passed back and forth with FME Server and Desktop? Any