FME Form

I would like to select only tables with certain strings in their table names when running a FeatureReader. So something akin to:WHERE TABLE_NAME LIKE '%searchstring%'Is this doable? And if so, how?

I have a large data set that has been read from multiple autocad drawing files. At the current stage each feature has an attribute "project_num". There are many feautres (usually lines) for each project_num. I would like to get this down to a single "centroid coordinate" (preferably center of gravity) for all of the lines from each project_num.  CentrePointReplacer will generate a single point for every feature.I tried FeatureMerger but am having problems. Both the Supplier and Requestor are set to "project_num". I have set the Feature Merge Type to geometry and checked "process Duplicate Suppliers" (build polygons) but get the same number of merged features as the input. If I use the "group processing" option, I still get the same number of merged features. My current workaround is to use the DuplicateFilter before sending it to CenterPointReplacer. I have also tried creating a point cloud from all the resulting CenterPoints and

Hello, See picture below for example, I wish to remove the green vertex while ensuring that the end point vertexes remain.  I need to remove these as they are treated as being stacked, which is causing major issues with my ESRI Utility Network Model.  These points are within < 0.001m of each other. I have tried using a generalizer, which is not appropriate for this situation, as the lines become much too generalised. I wish to only remove these vertexes that are treated as being stacked upon each other.  I have also tried using the geometryValidator -> issue to detect: remove consecutive points without success.  What other ways can I remove these points? I have thought about creating a custom set of transformers that could do the job, i.e. Find all vertexes -> identify any vertexes that are connected to other Line st/end points or any devices (as I want to keep these) -> find vertexes that are within 0.001m of each other -> single match these -> output. Although with

I am playing around with FME to see if I can use it to convert autocad dwg files that use colour based plot styles to named plot styles (CTB to STB). I have attached a simple workspace that has an autocad reader and then sends it to a writer. No transformations. The writer uses a template file that uses our standard STB file for plotting. The converted file is mostly okay, but for some reason some of the leaders are way out of place. After some investigation, I found out that they are mirrored on the X axis. If I insert the converted drawing over the original with X scale factor set to -1 those leaders end up exactly where they should be. What's going on?

I am trying to use a "Where" clause for the reader but it does not identify the field in the existing geodatabase. I have a Esri Geodatabase connection named vg_esri and I wanted to select a table named vg_esri.sde.mm_poly_gh and select a polygon wíth its id polygon_id = 852364, I have used SELECT polygon_id FROM vg_esri.sde.mm_poly_gh WHERE polygon_id = '852364';Could not find the features in the table 'sde.mm_poly_gh'. One possible reason is that a WHERE clause was specified that references a column/field that does not exist in the table. The error number from ArcObjects is: '-2147216081'. The error message from ArcObjects is: {Invalid SQL syntax [ERROR:  syntax error at or near ";"LINE 1: ...FROM dg_esri.sde.mm_poly_gh WHERE polygon_id = '852364';)But I get this above error, What am I doing wrong, I cannot figure it out. Any input will be very help. Thank you... 

Hello, I have configured FME-Server for httpS. following this description https://docs.safe.com/fme/html/FME_Server_Documentation/AdminGuide/configuring_for_https.htm. But now is the file upload no longer working. "There was an error uploading the file"(https://docs.safe.com/fme/html/FME_Server_Documentation/WebUI/Uploading_data_files.htm) Any help is highly appreciated. Thanks.

I'm currently using the 'change detector' transformer to compare incoming data with an existing database, and my challenge is that the comparison always seems to spit out the features as being 'updated', even though I am testing by comparing essentially the same exact datasets, so I expect it should be exiting out as 'unchanged' instead. The inputs are coming from a Portal feature service and a geodatabase When I toggle the 'Check geometry' off, it seems to work correctly and detect the features were 'unchanged', so I'm guessing it's some slight changes to the geometry that may be causing features to be seen as 'updated'.  I'm already using the 'coordinate rounder' to alleviate some slight variations, but are there other approaches I can try to help figure this out? Thanks!

Hi, We have been trying to set up a process where our users can email their files to a shared mailbox and FME can extract the attachment &  process the attachment  from emails in our FME server fault tolerant deployment without success as neither STMP nor IMAP option is possible. Our IT  tech lead wanted to check if we can use EWS with FME server. I have read an old thread that this can be done through XML & httpCaller but I couldn’t find any further details of how to set this up. I also saw there is the Microsoft Graph API option and wonder if it’s recommended. Our IT Tech lead prefers EWS as we have another application that was already using EWS. Would be much appreciated if you could point me to the right direction.Many thanks!

Good morning, I would need to do a spatial join on FME. On QGIS, the tool is called "Join attributes by location". I would like to find an FME transformer that does the same as the QGIS tool. Thank you for your reply

I have a network of (electricity) lines (306 in total) and with Neigbourhoudfinder i determined what line is collest for all 800 proporties in a small village. It gave me and x and y coordinate on the line. Now I want to determine a total value per line (values of all properties that have an x and y coordinate) on the line. How can i achieve this?

Hello I have a file in xml format. Although I selected many xml formats in the addreader section of fme, I could not open my file. Can you help me?

I'm missing the Beta-Download:"There are no betas currently available to download. Please check back again in the future."

Is there anyway to configure the StatisticsCalculator on a dynamic set of attributes?I would like to generate a histogram of attribute values, where the attribute name is determined at runtime. Bonus if I can process multiple attributes at once.

FME Desktop 2022.2.3

Hi, Just after a bit of advise. Within my organisation i am trying to request an app to connect to sharepoint. When this work on FME desktop i have to authorise with my own identity and it works fine. However, as my organisation has a 2 factor authentication policy which requires me to enter a text message password, i need to reauthenticate every 2 weeks. Would this be the same with FME server, requiring me to reauthenticate every 2 weeks (as not useful for a process i want to leave on a schedule)? or when i authenticate the app from FME server, would remove this reauthentication requirement? if not is there anyway around this? I would do trial and error to find out, but its taking me along time to get through internal processes, and want to ensure after the effort it take to get there, its going to work as hoped. Many thanks, Andy

Hello FME'rs,  What I'd like to do is intersect two line feature classes to produce an intersection POINT output feature class.    This is a relatively simple task to perform in the Arc geoprocessor (overlay->intersect).  However, my first few attempts with FME (using lineonline overlay) doesn't quite yield the results I want as it appears the give me the intersection points as well as ALL the start/end points of the intersecting line segments.  Can someone kindly point me in the right direction?  Thank you :) JP

I'm finding that the LineCombiner is causing issues when combined with an AreaBuilder. The non-combined lines in a workspace I have created successfully create areas but, when the lines are combined, they then make up incomplete areas. You can see in the below image that, once one of the line datasets go through the LineCombiner, they do not successfully create the areas. Is this a bug?

Hi,With FME(R) 2022.2.4.0 (20230303 - Build 22792 - WIN64) I am trying to load 1730 DWG files with attributes. The feature reader reads all the files and generates more than 81 million elements. The next step would be to expose the attributes from the DWG files. When I try to Import the attribute list from feature cache I receive the following error:An error occurred. Here is the information that FME was able to find on the errorbad allocationFailed to open the dataset 'C:/Users/csernak/AppData/Local/Temp/wb-cache-readalldwg-cKcBRr/Main_FeatureReader -1 3 fo 1 _lt_OTHER_gt_  0  4cd4d7e49164af1f4967e8da9131f3594634062d.ffs'DATASET INFO:    DATASET: C:/Users/csernak/AppData/Local/Temp/wb-cache-readalldwg-cKcBRr/Main_FeatureReader -1 3 fo 1 _lt_OTHER_gt_  0  4cd4d7e49164af1f4967e8da9131f3594634062d.ffs    NUMBER OF PARAMETERS: 0The files are there, the disk is half empty, the memory usage is just 400 MBs.With a single file it just works fine.Is there anykind of limitation around that?

For a school assignment I am trying to make a functional FME model. As topic I chose the electrical grid. I chose a village were there are 8 transformation stations and about 300 different line segments. For alle 300 lines I determent which transformation station is closest.  I know want to number the line segments that "belong" to the same line. e.g. a1 to a10. Is that possible?

How do I set the coordinate system of a dynamically created empty feature class (polygon) in a file geodatabase? I store dynamic attribute names and data types in a spreadsheet, import those into an AttributeCreator > then create the empty feature class using a FeatureWriter, but the output feature class says coordinate system is 'Unknown' when I open it in Data Inspector. 

When I am reading the files which are of size 192 MBit is working fine but when I am reading the file which is of the size 958 MB , getting an error. I am getting error in fme server while reading the particular file . Is there anyway to solve this error?

This might very simple to tackle but i have not found a solution to it. I have a set of GPS points along a drive route as shown the the diagram, the arrows indicate the route drive direction and i was wondering how to group these two sets of points.if drive route A was from distance 10-1 and drive route B was from distance 1-10. The screenshot below is what i have tried, I only get (distance 1-10) grouped the second set of data get added to the group, i.e, if the value of group 1 was 0, then next dataset will be 1,2,3, etc. Any help will be highly appreciated. Regards,Keller.

hi everybody... I'm doing 3d visibility analysis. I have points data and dem data as in the screen image. I need to do an analysis for each point and I need to save all visible areas as a single shp...can you help me please

I'm interested in using FME to connect to a number of remote hosts to run a few command line commands, and returning the results back to the workflow for further processing. The remote host devices are network elements running an abbreviated version of Linux. Can PythonCaller be used for this purpose? The SSH connection must be completed through an intermediary "jump box". Any ideas will be appreciated.