FME Form

Hey There,I hope another set of eyes on this might help. I am having trouble with Python scripts and the Python Caller. I generate the error 000816, which I have tracked down to a possible conflict between 32 and 64 bit versions of Python conflicting with ESRI geoprocessing tools. I have attached a screen cap of the log. I have highlighted where I think FME is using 64 bit but I have set the Preferred Interpreter to the 32 bit in the Tools. Any thoughts? Many thanks and all the best!c.

I have a date being read in from a SDE geodatabase. It is in M/D/YYYY. I have the user input a year. I want to test it against the year in the table and only select the years that match. Is it possible to parse out the year in the tester or do I have to add in a DateTimeConverter Transformer to change the format?

We have an fme server installation running on linux with dynamic docker engines set up. We are using FMEServerJobSumitter but missing the control limit offered on the WorkSpaceRunner by the maximum concurrent processes or similar. I have gone over a few documentation and knowledge base articles to find how to limit the amount of dynamic engines processing on a certain queue to avoid exhausting all licensed engines available globally on FME Server . How safe recommends this ?  Regards,Jorge Vidinha

HI !i'm starting using FME 2018 and i would like to do something very special i don't know if i can do it ? So,i want to match two table with one attribute but sometimes this attribute is not the same in both.exemple :Table 1 : "restaurant le Bistrot" Table 2 :"auberge le bistrot" the special key word are not always at the same place. my first idea was to separate every word from one of these table in list with attributesplitter and using a "tester" searching at least 2 word from lists for making a match with my first Table but that doesn work. even with "matcher" do you know if my request is possible ? thanks !! Charles.

Hello Experts,I have a file in which I have 2 columns id and distance. The distance corresponds to the ids. The issue is that some ids are duplicates and the distance is different. I want to identify the ID which has closet distance associated. See the image attached. Any help would be appreciated.

Hi,I would like retrieve the date of a Excel file (in the reader). The date write in the Windows explorator.I would like write this date in a field 'version' of my new file (in the writer)Thanks a lot, 

Hello,I am trying to execute below plsql statement using SQLExecuter.But the declared variable (mId) is not populating select statement "mId" value. DECLARE mId number;BEGIN  select MAX (id) INTO maxId from @Value(table);  insert into @Value(table) (ID,@Value(columnsStr)) VALUES (mId, @Value(ValueStr));END; /FME_SQL_DELIMITER / Expected output during execution: insert into table1 (ID,name) VALUES (10, 'test'); FME Output during execution: insert into table1 (ID,name) VALUES (mId, 'test');  Thanks,G 

I tried to use WorkspaceRunner to perform a batch processing, but I didn't get the result I wanted.For example, I run 4 fme.exe at the same time in child workbrench and set the output result to same location. No matter the output location is Esri Geodatabase with 4 different names or with 1 same name, sometimes one or more fme.exe fail to write the correct result, some features will be missing.But when I set 4 different Esri Geodatabases as output locations, I can get the correct result. And this happens only when I use File Geodb Open API Writer, File Geodb didn't work either.I'am thinking maybe FME can't write to the same GDB at same time? Is there any solution to situation? Otherwise I have to do an additional Fanout processing.Thank you.

Trying this workspace, I get an error saying 'owner' feature type does not exist. The FeatureWriter output format is SpatiaLite and a template.sqlite database is used. For both feature types "Use existing" table handling is selected. Parcel geometry type is wkb_polygon and owner is wkb_none. The 'owner' table exists in the template. Could it be a FeatureWriter error managing SpatiaLite?  

Hi, Running a script to truncate an existing feature class in a sde that has attribute rules attached thru ArcPro. The warnings state the below items - table must exist - it is there, can see it via Catalog and SSMS. User has DBO. Running 2021.x FME, 2.9.2 ArcPro. Any ideas as to what I may be missing? Did set the compatibility to ArcPro, used sde connection created by ArcPro.Thanks,Lorinda2022-04-06 12:41:23|  1.2| 0.0|INFORM|Transactions are being used by the Esri Geodatabase Writer2022-04-06 12:41:25|  2.9| 1.7|ERROR |Esri Geodatabase Writer: Feature Class or Table 'IDF_Stormwater' must exist when Table Handling is set to 'Truncate Existing'2022-04-06 12:41:25|  2.9| 0.0|ERROR |GEODATABASE_SDE writer: A fatal error has occurred. Check the logfile above for details2022-04-06 12:41:25|  2.9| 0.0|STATS |GeodatabaseRelationshipFeaturesPipeline::GeodatabaseRelationshipFeatures (SortFactory): Finished sorting a total

I have set up job routing rules and I want to test that the routing rule is working fine. I have added CPU%, Memory Peak Usage, and Queue in Display Column on the grid, but there seems to be a lack of functionality on the grid or I am missing something basic.  Usecase: I want to see all the jobs which finish within 2 mins, use < 20% CPU, use <2GB memory. and want to make sure they all were assigned Micro queue. -> I am trying to filter by queue but filtering by queue is not an option.-> Grid is configurable to hide and show columns, but I can't sort by columns or add any kind of calculated field in the grid.  Is there any easy way to export this data to excel? I tried dashboards but they don't have the fields I am looking for, maybe if someone who understands the database schema of the FME server can guide us I can get help from our FME Author to adjust the workspace/dashboard to include these extra fields & fi

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 f

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.   

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

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

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'.