FME Form

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.

I am able to write to a local MySQL database, but I would like to write to a remote MySQL database through an ssh connection. I don't see that the Add Database Connection interface allows this. Is there a way to do this?

I need to connect to SQL Server database hosted on Azure cloud. It is currently blocked within LAN network and we are looking at option to connect to database over SSH or HTTPS. Is it possible to connect to SQL Server database over SSH using FME?

I have hunted through docs but am struggling with dates. I can't do date comparisons in the InlineQuerier (see q linked below) so need to change dates to integers to compare using SQL, but can't figure out how to do that. I also want to be able to convert dates to months for comparison e.g. testing 15 September 2022 vs 30 September 2022 should return TRUE. Still new on the FME journey and any help much appreciated - or a pointer to docs. Thanks, Philip Q. on dates in InlineQuerier using SQLLitehttps://community.safe.com/s/question/0D54Q000080hMJ7SAM/testing-for-between-dates-supplied-by-external-file

HI All, Any workaround to convert a date string (YYYY-MM-DD format) to DD/MM/YYYY ? The field type needs to stay as date string see below:  I've tried a few transformers (StringReplacer + ListExploder+ String Concatenator) but couldn't get it to work and show 21/04/2023 Thanks

At first, it successfully connected to the database, but later on, it started encountering errors that were resolved after some time. However, for the past four days, it has completely stopped functioning, rendering me unable to continue with the tutorial.

I have a script that was written for us by a consultant and it’s very intensive. The FeatureReaders are pointing to a connection file to read our SDE, as well as some file geodatabases that are stored locally on the server. The script uses a WorkspaceRunner to access a child script to then do some calculations. However, when I run this from FME desktop on our server, it never completes. It doesn’t throw an error, but it just gets hung up at the WorkspaceRunner. If I try again, the same thing will happen. There’s no common point in the script where this happens. It’s very random.I’ve also attempted to run this script from my desktop, and it works. It’s very very slow, but it does work. However, we need to be able to run this from our server, not my desktop.Any ideas on what I should be looking for in our Server environment? Our server has much more resources than my desktop, so I’m surprised it’s not working – so I must be missing something. Any leads on this would be greatly appreciate

Hi, at the FME UC last year there was discussion about a the potential to create a Custom Transformer and in the process consume a swagger/OpenAPI definition. I've been looking at the FME Transformer Designer in the FME 2023 beta and so far I can't see anything which would indicate that this is doable.  Am I missing something? anyone else know anything more about this?