FME Form

I'm sure this will be something really simple I am overlooking (as usual!)I have some excel data of personal information, including age.I need to:1.       group ages, 0-17, 18-25, 26-35, 36-45 and so on.2.       count how many each category / group has.3.       Display data in ExcelFor point 1, I have used the Attribute Range FilterThis gives these resultsSo far so good! For point 2, I use the statistics calculator to do the total count of each group:Then into Attribute manager to rename the column

Since FME lives (thrives!) in the lands-between-realms I'm thinking this is the best place to ask this question and hook knowledgeable reponses. There are more eyeballs in the Esri and Stack Exchange community forums but they're less likely to have the broad horizon to horizon perspective combined with life in the tunnels found here. What are the trade-offs to consider when deciding between native DB spatial type or Esri Enterprise Geodatabase (or both)? Where 'native' means PostGIS for Postgres, SQL Server Spatial, OGC in Mysql, etc., etc. Assume equal proficiency of staff and resources is or will be made available. Licensing et al is consequential but not determining. Content is a mix of spatial and non-spatial. It's hard to say which is more. By volume in terms of storage it's spatial - a lot of wildlife telemetry, survey and observational data. However by number of tables the non-spatial will probably outnu

Hi I'd like to convert footprint and 3D buildings from Esri Arcpro to CityGML.However, I couldn't import the shapefile in 3D.Do you have any idea about this?Thank you for your help. I'm new to FME so I'm struggling lol 

Hello!I have Esri 3d Mulitpatch data as a shapefile, and I tried to see the 3d data on Graphics, but I can see nothing. Also I tried to extrude 3d objects from 2d multipatch, and I insert correct height value, but nothing has changed. Could you tell me how can I solve this issue? I tried to change the coordinate system and I've done several times, but only coordinate system is changed and still cannot see the 3d.

I have a SQL Server table that holds log information. It contains a date field. If I query it in SQL no problem I get: In FME I have a FeatureWriter. I have it set to Update and Use Existing and I've chosen Where Clause as my row selection method. I thought it would be easy to select all rows having todays date, but I'm 3 hours in and having zero luck. I've tried all sorts of iterations like these and many, many more and every time I get "date is incompatible with some data type" or it finishes successfully and I get zero matches. Any suggestion would we GREATLY appreciated. Kim

Hi,  I have a user parameter where we are entering raw text in the format of:\\gis\scripts\FME_Projects\Production\Staging Folder\bulk_geopackage.gpkg  The first time this parameter is used is in a featurewriter transformer:Then when I look at the path it is passing through the output, you will notice one of the slashes has been reversed...Any thoughts as to why this is happening at this point?

Wonder if there is a way to read  Microsoft Planner (Microsoft Task) with FME ? Yarko

Hi all, I've created a series of FME scripts that translate geometries in a source DWG file into ESRI consumable SHPs. However, now that I want to change the Writer source to write to the FGDB I created, the scripts won't run properly and say this.Is it a matter of adjusting the attributes viewable in the end FC in the FGDB? I was able to set it to manual/automatic with the SHP writer, and everything translated through with no errors. In my initial transformation from DWG to SHP, the SHP writer geometry enabled the shapefile_first_feature option and dimension from first feature.In the FGDB writer opti

This is a silly question, but I can't seem to use the File Copy writer to copy a DWG file to another folder properly. The transformation seems to run with no issues, but when I check the output folder I specified, the DWG file is not there.In the Reader, I chose to merge it as a single merged type, as the DWG has about 30+ individual layers in it. Is there a method to ensure I just copy over the whole DWG file into another folder? I don't want to move the original file, simply make a copy of it to another folder.Thanks everyone

I am new in FME and I have a project to convert 3D models in .rvt format to be poblished in scene 3D views in ArcGIS enterprise. I was trying to find articles or similar projects that was done before but I couldn't. Can someone help me please tnx!

When I run my spatial filter with the entire dataset the filter fails but if I run using partial data the dataset it works. Does anyone know why this would happen?Note: Spatial Realtor works but not the spatial filter.

I am slowly loosing track of all my inpector windows. How can I stop fme creating a new instance every time a tool is run?

I have several Revit files for design review of a construction project and I want to make them available to our organization through ArcGIS Enterprise using a 3d web scene showing the Revit data as a "building layer." I've set up the Revit readers but that is as far as I have gotten in FME. I tried creating Esri file geodatabase writers from the readers but resulting the feature class schema is different than what the results from the BIM File to Geodatabase geoprocessing tool in ArcGIS Pro produces. For context, in ArcGIS Pro my steps would be:BIM File to Geodatabase (geoprocessing tool)Make Building Layer (geoprocessing tool)Share as Web Scene

Is there a way to check the status of a FME job through a powershell script?

I need to generate a list of polygons from Dataset Y that overlap with Dataset Z and the percentages each polygon overlaps the polygons in the other dataset.I’ve currently used a spatial relator > list concatenator to find overlapping polygons but it then requires a lot of additional work in excel to get it into a usable table so I am not getting results in the format I need.The data essentially looks like the follow example and I need something similar to the Ideal Resulting Dataset or in a format that is easy to follow or easy to turn into that dataset.Example Dataset Y1234 Dataset ZABCD Spatially Datasets Y and Z:Ideal Resulting Dataset:

Using the TINGenerator with 3D points as input, I get edges, triangles, surface and points. This looks fine in the inspector, and I can write the results out as e. g. Multipatch. I would like to write the result(s) (just the surface really) out to be readable by ArcGIS Pro as a TIN, like the result of the "Create TIN" GP tool. How do I do that? "Esri ASCII Grid" fails no matter the input and the adf writer (the TIN files in the Pro-created TIN folder end with *.adf, mostly) wants to write e00 files. 

Hi,  I am wondering how it is possible to write generics attribute in CityGML?  Any help appreciated :)  Regards,  Asher

I am trying to get version difference via ArcGIS Portal service and I am getting this error message : ERROR |Python Exception <KeyError>: 'rings' I am encountering this error message for only layer (pointing to polygon featureclass) on the service and the rest looks OK . In case I use other layers from the same service, its working fine and giving me version difference results without any issues.  If I do some edits from ArcGIS Pro and perform version changes, that seems to be fine for the same layer.  Thanks,Naveen

Hello FME Community, I get the following error message when creating features in FME using PythonCreator. Does anyone know what the problem is?

Hi guys,im using a CSV file + feature reader to manage SDE feature classes get read into my workbench. In this csvI also have a list of filter and attribute to keep/rename for each of these layers, im wondering what's the best practice to do this - is there an easy way i can apply my csv file rather than repeating tester / attribute renamer for each layer? thanks guys as always!

Hello! Not sure where to put this. I'm sure others must have tried this and figured it out before.  We have a spreadsheet with 10 tabs. 3 of those tabs we'll have automated via an FME workspace.  Question 1 - Is it better (or easier) to purely overwrite or append? We have an excel template set up as the formatting (font size/ auto height) need to be followed. The scenario here is we are keeping track of communications and creating a new row each time there's a new communication. Is anyone able to share a screenshot of what the parameters should look like? I am getting confused by truncate/insert/update, templates and named range and how they all work in this situation. Is it possible to only overwrite the three tabs or if I select overwrite does that imply the whole spreadsheet. I notice there are two sections to control parameters  I'm a little bit unsure of setting up a named range since the list of communications will cont

My question concerns when a resource is read when using a dynamic writer. Is it read at the start of the process or immediately before needing when dynamically writing? I am modifying the xml schema in my workspace and overwriting the file. However from what I can see the resource has already been read and applied as the schema. Should the resource be read just before the writer needs it or at some earlier point? Could I use an attributefilereader to read in the xml as an attribute and use this as a schema attribute just before the writing bypass this issue? Thanks,Ian

in in FME Json Reader following,{"yourDateOfBirth":"15/08/1987"}become column yourDateOfBirth with a value of 15/08/1987, I need to convert to value 08/15/1987? Thanks

Hi All,  I'm working on a workflow to identify if line is perpendicular and shows the same X at both vertex . Below a screenshot that shows a line pointing to the north but the X (top vertex) is different to X (bottom vertex). The aim of the is fail the lines which are not perpendicular and show different Xs, I was thinking about TopoBuilder but can't get it to work, Any ideas? Thanks :)     

Hi All, How can I force FME to write a single excel file with an unique DateTime value for all the Excel sheets included in a FeatureWriter? see the details below: Atm FeatureWriter writes a 'datetime' per excel sheet therefore export multiple xlsx instead of one single excel file. Any ideas? 🙂