General

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.Writer Set Up for mulipolygonOriginal Dataset Re

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.  This is the link to the API documentationhttps://developer.withthe

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.microsoft.com/2003/10/Serialization/Arrays">   <soapenv:Header/>   <soapenv:Body>      <ais:GetWorkTickets>         <!--Optional:-->         <ais:OrFilters>            <!--Zero or more repetitions:-->            <ais:Filter>               <!--Optional:-->               <ais:AndFil

 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 the ArcGIS 3D Analyst extension licensearcpy.CheckOutExtension("3D") # Execute CutFillarcpy.CutFill_3d(inBeforeRaster, inAfterRaster, outRaster, zFactor)&

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//5GbCdeY4p5Jl1dyuznlXPMAAEHLpQD

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!

​I have hundreds of features in the Workspace and no I cannot break up the Workspace as any or even all of the features may need to be translated during the same process. I don't have a problem running the translation from the 2014 version but I would say 90% of the time 2018 exits before the translation is complete. The last time I tried I only had a handful of objects selected in Smallworld but FME2018 still exited before completing. Any suggestions would be appreciated.

Greetings, I have a workbench that reads Portal and returns all item-types, that is filtered to MapServer and FeatureServer. Each Feature may have one or five layers. I can return all the Features, but not the layers associated/under the Feature.  I have not seen any articles or post that show how to do this. Could anyone post any suggestions?? Appreciate any pointers. Thanks,Clive

I extrude a line into a 3D vertical face. Another line coincides with one of the edges of the face, or more precisely, the line is inside the edge. Now I want to split the edge with this line, from an edge into three edges, without changing the face.

I've got a geodatabase from which I am trying to read features based on an initiator intersect within a FeatureReader. The geodatabase contains polygons for a large area, and the initiators are areas I intend to spatially filter geodatabase features to and then write out as individual shapefiles for each area.  This is proving very slow, and i'm hoping someone can point me in the direction of a more efficient way to perform this operation? Thanks

Hello all!I am writing polylines to an existing feature type in a GDB. It shows that 48 polylines are written, however when I open the feature layer in the inspector or in ArcGIS Pro it added 66 polylines. It turnes out the Writer split the polylines at the cross with another polyline and so the data is not duplicated, but divided. Is there a parameter that I missed that does that or is it a normal behaviour?Thank you for your help!Ana

i have a number of .bat files that launch python files. im trying to replace windows scheduler with FME and i am having trouble figuring out how to schedule a new task. i am using FME Workbench 2020.2.