FME Form

I will soon have two sets of (hopefully) identical data to check against each other, sat in FGDB's. There are quite a lot of records (thousands, if not tens of) and I'm looking for differences in any attribute between the two versions of the same record.  I can see this taking a long time, and note there are different options within FME, including Matcher, CRCcalculator, etc. What is likely to be the most efficient method?

I am getting the following error (out of the blue, I might add. One run, everything humming along fine until "bam", next run, license/Python compatibility error):ERROR : FME initialized 'ArcGISDesktop', but the workspace Python compatibility setting is 'Esri ArcGIS Python 3.7+'. Please check the Python compatibility setting in the workspaceI have both ArcGIS Desktop (10.8.1) and ArcGIS Pro (2.9.1) installed, and I am using 64-bit FME Desktop Professional 2022.2. My dropdown list for the Python Compatibility parameter, however, does not include separate listings for ArcGIS Desktop vs. ArcGIS Pro, only for "Esri ArcGIS Python maj.min" . (1) Does "Esri ArcGIS" mean ArcGIS Desktop?; and (2) if so, what do I need to do to get ArcGIS Pro choices listed in the dropdown and to get FME to recognize and use my ArcGIS Pro license instead of my Desktop license?

Dear FME friends,Welcome to What's Up Wednesday. For reasons of space, this is an extract from the full version of this newsletter, which you can find here on LinkedIn. The Peak of Data Integration, 2023!Even though the last user conference ended not long ago (or perhaps because it ended not long ago), I'm really excited that we already have online details of next year's conference!  As previously announced, next year's conference is taking place in Bonn, Germany, in September 2023, hosted jointly with con terra. Yes, we're coming to Europe! So save the date for sure, but also start thinking about what story you would like to share, because the call for presentations is already open. Hexagons in FMEIn case you didn't know, there is an ongoing event called the #30DayMapChallenge. That's when you're encouraged to create a new map every day in November, each on a set topic. A recent topic was "Hexagons," and so I thought I'd use the H3Hexagona

I have two separated polygons. both of them have unique identifier which is written inside polygons. also, both of them have area_official, but it is written on the bigger polygon. s, I want to associate the area and smaller polygon together. What I do to make it work?

This is opened question to FME Community. FME workspaces are very individual. But I believe there is a way quite universal way to test it (FME Testing Framework, rTest, DatasetValidator, Test Custom Transformer). This topic is about data quality. It is crucial!. How do you test your data in FME?

How can I assign a unique identifier to all areas that intesect each other?

I have a workspace that uses ESRI ArcGIS Python 3.9+ and works as intended on FME Desktop. When uploading to FME Server, I receive this error: A Python interpreter could not be loaded. Please ensure the workspace `Python Compatibility` is set to an available Python version. Based on this link, Using Python with FME Server (safe.com), I believe I need to upload the correct python module to the FME Server Resources directory (presumably a python module that was distributed with the install of ArcGIS Pro 3.0). Both the ESRI software and FME Server are installed on the same machine. I'm having trouble locating the correct files to upload to the Resources. Which files need to be uploaded, and where would I find them?

I'm trying to run an old project in Desktop 2020 and keep running up against the error "The Geodatabase ... is newer than the ArcGIS installed on this machine. As a result the Geodatabase cannot be opened"Log file shows it checks out a license from ArcGIS 10.6.1 but I have ArcGIS 10.8 installed, although there is a Desktop10.6 folder in ArcGIS/Program files as well.Can I 'force' FME to select a 10.8 ArcGIS license or is there another work around?

that should be in separate fields are in the same cell. So, how do I remove peoples job titles that are sharing the name field and place them in a field of their own and is their a standard FME practice that will target duplicate entries into Excel sheets? Any help would be greatly appreciated.

Hi, i need to convert one geotiff to kml/kmz but i´m a absolute begginer in FME workflow. Anyone can help me with a tutorial or similar ? Tnks

I successfully can read/write Esri Arc SDE (Geodatabase) with FME 2021.2.6 64-Bit and ArcGIS 10.8.2 + Esri BG Geoprocessing installed. So far so good. If however ArcGIS Server 10.9.1 is also installed in the same enviroment, problems arise and an error message appears, that "BG Geoprocessing is missing" and needs to be installed. What is the issue here ? How can it be solved ?It seems only uninstalling ArcGIS Server 10.9.1 solves the problem, but I need ArcGIS Server for other reasons/applications. B.T.W.: ArcGIS Server 10.9.1 is the corresponding version to ArcGIS 10.8.2, in case you wonder about the version mix ;-) Thanks for any clue about this Michael  

Microsoft is disabling SMTP on Microsoft 365, and we have to switch to oAuth 2.0 authentication. We have some Emailer transformers in our workspaces, unfortunatly they only support oAuth2 for Gmail. What is the alternative to use for this transformer ?    

I use a FeatureReader to read multiple shape files from a .zip. The FeatureReader run in FME-Server. A published parameter is used as 'Dataset' (i.e. the FME server path to the .zip file). 'Feature Types to Read' is empty to read <All Feature Types> because I don't know the exact name of the provided shape files per monthly run. The set up works pretty well. the Reader loops over all shapefiles in the zip and the records are provided through the <Generic> port as intended. Now I have the following challenge:One group of shapefiles in the .zip are point classes and the name starts with POINT_****.shp. Another group are lines and the name start with LINE_***.shp.Question: Is there any option to read only one group with my FeatureReader setting? I tried to play with wildcards in the File/Filter field of the 'SelectMultiple...' control but with no success My current mitigation is to use two FeatureReader. The first one is only reading schema and the

For some reason in one of our processes it was decided that an XML is needed that contains partly json data (I know how this sounds :( ).I'm struggling to get the json data correctly parsed (or the XML correctly formatted). The json data is generated via json templater and looks like this:{    "editOptions": {        "cascadeEditOptions": {            "cascadeStrategy": {                "type": "NoCascadeStrategy",                "enabledTypes": []            }        },        "userProvidedIds": true    }}The XML structure should be like this:<data> <metadata> <projectName>SomeProject</projectName> </metadata> <action> <Modification operationId="test_operation_id_1" Id="1" requestBody=' {    "editOptions": {        "cascadeEditOptions": {            "cascadeStrategy": {                "type": "NoCascadeStrategy",                "enabledTypes": []            }        },        "userProvidedIds": true    }}  '/> </action></data>Th

In this workspace, the results of AreaOnAreaOverlayer (using the default tolerance) and SpatialRelator (using a custom DE-9IM matrix) are different. I suspect it's a precision issue with the AreaOnAreaOverlayer transformer but it's curious that the transformer that doesn't allow changing the tolerance (SpatialRelator) is the one that works fine.  

Wondering what parameter to change so that when I use PointOnLineOverlayer it does not split the lines? is this possible?

Hi,I have array with geometry type and coordinates. How can I easily make geometry out of it? I could make a wkt text with string replace but I suspect it could be easier. The string with geometry type and coordinates is (shortened):{"type":"MultiPolygon","coordinates":[[[[155469.406,463438.624],[155469.253,463444.217],[155467.196,463444.174],[155467.077,463444.172],[155462.4]4,408. [ 155469.406,463438.624]]]]}  

Which transformer can be used in the place of MRF2DCleaner transformer?

Also When I am trying to use Civil 3D and CAD Entities. I am getting reader error "BADNEWS: BADNEWS: No geometry mapping entry found for 'autocad_wipeout' in metafile 'C:\\Program Files\\FME_2022_1\\metafile\\CIVIL3D.fmf'. Please visit http://www.safe.com/support"

Hi! Im having a struggle to merge the "objec data" to the "block" or the actuall autocad_ellipse. When i zoom to line 1 it contains no geomtery, how can i add the object data to the ellipse (line3)?   

Hello, I have an Excel-file where one of the attributes contains large numbers such as 3.0230003003349996e+19. I want these numbers to be in a format without the e-notation such as 30230003003349996. What's the fastest way to do this?

I have a 2d polygon and I wanna fill it with as many parallel lines as possible given the distance between the lines and the angle. I have some problems to create the lines I need.  In the image ignore the points.Input:+ the angle (i.e. 80°) Result (ignore points)

Hi All, I have a string that ends with a couple of characters that cause PostGreSQL to fatally terminate the process when it receives them. Unfortunately I'm not certain that the string /always/ ends with these characters or I'd use the substringExtractor.   I get this error: invalid byte sequence for encoding "UTF8": 0xc0 0x80  So what I'd like to do is trim them. The problem is - How to do that without resorting to Python?  I can't just copy/paste them into an attributeTrimmer because FME represents these with the special "replacement character" ? - https://en.wikipedia.org/wiki/Specials_%28Unicode_block%29#Replacement_character - meaning what the trimmer is searching and looking to replace is that special unicode character (?), not the actual ones that I want to remove.  If I go into the source database and select the character in it's original encoding and paste that, it just pastes a space.  There's nothing in the AttributeTrimmer docs a

I want to convert the features from ArcSDE to a pdf. I have an autocad file that contains some blocks to assign to points that can use as a template. I also have an Excel file that contains the color and width of each Lines that can to be assigned to specific features. I would like to know how I can assign the Autocad file to my feature. In addition when I try to determine the values ​​of pdf_fill_color using Atribute Format, the color doesn't change at all. do you know where i can find color code? (DWG Styler doesn't help me because I have color of features as code in an excel file and I just need to link color to feature. 

Hi Experts, Which tool to use to mark green (ish) pixels in my tiffs? Is there anything available to help me to hunt pixels with the specific color range and mark it.Thank youj