General

Welcome to the first edition of What’s Up Wednesday for 2021. Hopefully, you had a chance to participate or check out the Twelve Days of FME Challenge over the holidays.  Upcoming TrainingOn January 13 & 14, the Integrating your Data with the FME Platform course will be presented online for free. Tune it to work through exercises in a virtual machine and ask questions to the live instructor. Then on February 17th, we will be presenting our

I have 5 postgis db with same schema and having same layer names. I want to merge all these five db into new db in new projection. I am trying to do it with by adding reader into single merge feature and adding reprojector and output to writer postgis new db.​I am getting the error :Fanout feature type public.roads failed to find feature type template public.roads.​How to do this? Any clue. I am using FME 2020.2​​

Hi there, I am trying to find a simple way to append an asset code to a list of facilities. I am running into trouble because there is no standardization of naming for these facilities leading to slightly different names (short forms, etc). I have a master list that I would like to use to compare and append the asset code to when given tabular data that 1) does not include the code and/or 2) does not match the master list naming convention. I can't wrap my head around which transformer to use and would appreciate the help!

having "A" and "B" two files compare and identified in both files unique values

Starting translation...Unable to open log file `C:\\GIS_Data\\Internal data\\Fire_Compliance\\2020_21 workspaces/letter_sent_Dates_20_21.log'Program TerminatingTranslation FAILED. Renamed workspace saved to same folder as originalRunning FME in a Remote Desktop environment.FME desktop 2019.2

Hello!How to handle multipart polygons in Spatialrelator when "Support all predicates" is checked (because they are not supported with this Support mode). For example I have district with islands and I want to check if it belongs only to one higher level district (or it overlaps more then one higher level districts).

Hello FME CommunityWe are using PostGIS as our data repository for users of both QGIS and StatMap. To provide the same data experience in both, data sets are polygon or multipolygon where possible. There have been some differences between the number of features in the two views. The first check was to use the Geometry filter in FME to see if any non-polygon geometry was present. The original dataset contained 3228 features. These all filtered as Area.Following reading some of the questions asked previously, I tried the deaggregator, geometry filter, aggregator, still with an end result of 3228 Area features.Next I tried setting the writer to multi_polygon for PostGIS but this just dropped the 9 Collections that PGAdmin is returning.Just not sure why the Geometry collections aren't being picked up by the Geometry Filter?Thank you in advance and sorry if I have missed anything obvious, this is an issue we've not come across before.

Hello All, Happy Holidays!I am trying to Extract Records only for the Year (SUBMISSION_YR) (format, '2020') the Tool is Run -I have WHERE SUBMISSION_YR = YEAR(CURDATE()) but it doesnt appear to be working correctly. This is in the Feature Type>Parameters>Table Settings> Where clause any ideas? thanks! 

I am attempting to authenticate my Google v4 API, and run into the following: My browsers (including default) have JavaScript running and enabled. What do I need to do to allow FME to use it?  Thanks,Sean

How can I save the contents of fme_text_string to a writer? I created the fme_text_string using Creator, and tried the AttributeExposer, AttributeManager, AttributeCreator, but still my writer is empty...

@Takashi Iijima​ I need to make a connection to an API with FME.This is a 2 step verification process, where I first have to receive an json webtoken through the 1st HTTP caller (see image). With that webtoken, I thought I was able to get all the available reports through the 2nd HTTP caller, to then move on to extracting data from a specific report (3rd HTTP caller). For the time being I just manually added the report hash id to the request url. Apparently, I don't get all the reports through the 2nd caller, and I also don't get all the available data in that specific report after implementing the 3rd caller. I only get a small portion of data after implementing the 3rd caller. (for example only 6 measurements inputted by the same user instead of all available updated measurements) It was suggested to me that I need to apply loops? How does this normally work in FME? I'm stuck, and using APIs is new to me.  

I am new to SOAP API's and need to specify a query to return all records between two dates. I've been googling extensively and can't seem to figure out the correct way to build the request with the AndFilters. If anyone with SOAP and XML knowledge could help me out, I would greatly appreciate it. So the SOAP request with the one filter for returning all records after a date works just fine, but I would like to filter for all records between two dates. Greater than or equal to date AND less than or equal to date. <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ais="http://ext.youraspire.com/AIS" xmlns:arr="http://schemas.mi

 I want to calculate CUT and FILL volume between"Existing DEM raster" and "Planned DEM raster" using Arcpy CUT and Fill geoprocessing tool script in FME Pythoncaller Transformer (FME DESKTOP 2017.1.2.0).But I am getting below error Python Exception <ExecuteError>: Failed to execute. Parameters are not valid.ERROR 000865: Input before raster surface: elevation01 does not exist.ERROR 000865: Input after raster surface: elevation02 does not exist.Failed to execute (CutFill). Error executing string `import fmeimport fmeobjectsimport arcpy def processFeature(feature): dataset = feature.getAttribute('_dataset')arcpy.env.workspace = dataset # Set local variablesinBeforeRaster = "elevation01"inAfterRaster = "elevation02"outRaster = "D:/CutFill"zFactor = 0.5 # Check out

Hey community? How can I have an FME t-shirt? 😁

Question, I'm presently using FME desktop 20161,2,1. I tried FME2018, but some custom workbenches I use wouldn't function. I understand 2016 may being sunsetted in 2021. Would it be possible to confirm this?

Is there a way to filter a subset of rows within a Google Sheets Reader? As an example, a google sheet may have 50K records, but I only want to read 1k with a particular attribute value.

Hı;I save my model that I drew with Sketchup as an IFC. then I want to convert my Ifc model to cesium 3d tile with fme. I am getting coordinate errors and having trouble with the 3d tile process.I'm not sure where the problem is coming from. I am adding my sample skethup and ifc files. Thank you for your help.

I have emailers embedded in many workspaces. Within each I have 1 parameter for the email password which applies to all emailers within each workspace but I am wondering if it's possible for multiple workspaces to reference the 1 email password parameter so I only have to change this in 1 place every 3 months as my password changes?

My script is becoming more and more articulate and complex, and I have to pay too much attention to moving.

I have this XML entity from an exported record from Esri Miner and Miner ArcFM. not sure how I can retrieve (decode) the geometry out of it. 😫 <NODE_DATA GOT_GRAPHICS="True"><GRAPHICS><![CDATA[MMAAHQABAAgFAAAEAAEAAADTNEAg6vbQEYOtCAAJuZbMAAAAAAgABgACAAAAAAAKAAAAVABlAHgAdAAAAAAA//8AAAAAAAAAAAYAAAA8AAAANwAzADIAOQAgACAAcgBlAG0AbwB2AGUAZAAgACAAZgByAG8AbQAgAGIAYQBjAGsAIABkAHIAbwBwAAAAAQAAAHQ+WraTKdERmkMAgMfsXJYBAAAABACWxOl+I9HQEYODCAAJuZbMAgAAAAEAAQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQD/////AwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA0AAAAAAAAAlsTpfiPR0BGDgwgACbmWzAMAAAABAAEAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABZQAAAAAAAAFlAAQAAAAAAAAAAAAAAAAAAAAAAAAAAAXY+WraTKdERmkMAgMfsXJYAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAADwAAAA3ADMAMgA5ACAAIAByAGUAbQBvAHYAZQBkACAAIABmAHIAbwBtACAAYgBhAGMAawAgAGQAcgBvAHAAAAAAAAAAAAAkQAAAAAAAAAAAAAAAQAAAAAAAAAAAAAAAAAAAAAADUuMLkY/OEZ3jAKoAS7hRBAAAAAEAAACQAaCGAQAFQXJpYWz//5GbCdeY4p5Jl1

I'm having some difficulty finding a good way to copy multiple files between two different folders. I would like to copy the contents of the AOI, BAOI and From client folders to their matching folders in a different location. See photos below: Source folders:Destination folders:Ideally I would like to get this done using two user parameters one for the source parent folder (D:\\aerial_mbu\\Aerial_2020\\Quotes\\Q19999_FME_Test folder) and one for the destination parent folder (D:\\aerial_mbu\\Aerial_2020\\Jobs\\19999_FME_Test folder)But I'm having troubles using the file copy transformer. Any suggestions are much appreciated. 

Actually I have some polygons and poles(asset) and I want those polygon which contains these poles. Please ​help me regarding this .I tried spatialfilter for this but it gives assets which are in polygon but mainly I want polygons which contains poles.Hoping to get some help from you guys!!Thanks in advance:)​

I have 1000 users who I have created user accounts and have their details in a excel sheet.The excel sheet contains their username and password along with email.I am trying to figure out what is the easiest way to send each user their username and password without individually doing the task. I am struggling to understand where to get started with this apart from using the emailer option.  This is a possible example https://www.extendoffice.com/documents/excel/3560-excel-send-personalized-email.htmlThank You

Hi all... I am new to the FME server. Can anyone help me in pulling data from WFS and put it in Azure spatial database ??

I'm using FME Desktop 2020.2. I have added a CAT reader and set the boundaries and attribute names. I needed to change the attribute names so I used Update Feature Types - this was correctly reflected in the reader on the workspace, all of the new attribute values are displayed. However, if I go back to the Update Feature Types to make any other changes I'm shown the original attribute names and attribute types from when the CAT reader was added. It did not save the changes correctly. I noticed an earlier post about this which was resolved in 2016, so not sure if this is similar or if there is something else I'm missing. Thanks for the help!