General

I have a workbench that is chocked full of transformers trying to fix, set, extract, validate and write the coordinate system. I can see the CS in the feature details and have a tester to get from an attribute that has just been updated with the CS. however trying to route any features to a sampler and then an xlsx list always ends up empty. however when i get the output and go to look at the cs output in the _coordsys there are features that are empty or contain spaces. even on a support call with safe they could not see any problem with the method i am using to get this. yet still the data is empty.reading from dwg files and using the realdwg reader. I have the custom Fix_Coord_System transformer built by Safe.I then proceed to set the coordinate system, extract it back out to an attribute, and test that attribute (BTW I have also tried to test t

I have the requirement to grab some data from a SQL Server Database and row by row (so granular error logging can be performed) use a stored procedure to insert that data into another table. However, when calling the stored procedure to perform the insert I need to escape the single quote character (') by replacing it with 2 x single quotes. I have tried using the StringReplacer transformer but when it comes to using the re-formatted string as the input for the stored procedure it does not seem to pull through at all, the SQLExecutor Transformer loops through all the records correctly but when calling:  EXECUTE [dbo].[InsertData] @Value(contact_number), '@Value(title)', '@Value(first_name)', '@Value(middle_names)', '@Value(surname)', '@Value(address_1)', '@Value(address_2)', '@Value(address_3)', '@Value(address_4)', '@Value(town)', '@Value(county)', '@Value(postcode)&#

Totally new to FME but at a previous company I worked at I heard that you can annotate models with text. We are working on a project which requires profiles to be annotated with specific names at given coordinates. Would it be possible to create a workflow to add text annotations to the profiles / how would I go about it?

Hi all!I want to transform a .laz file (attached) to raster, specifically the buildings and soil entities so prior to the RasterDEMGenerator I use the point cloud splitter and the attribute filter to get the ones that have 6 and 2 values.  The problem is that the output raster has a one-cell-wide frame with incorrect values all around.      Zoom:   Regarding RasterDEMGenerator, I have tried differen

ChartGenerator doesn't seem to honour the 'fill' line colour. Anyone else have this problem?Build: 2020.1.2.1 (20200909 - Build 20624 - WIN64) 

Hi,I'm performing some tests with the SharePointOnlineConnector. It works well uploading files. I'm not able to write some fields in the document library. Do you think it is possible? If yes, how to do it?ThanksRoberto

Bonjour à tous, j'aimerai projeter les attributs d'une couche linéaire sur une autre couche linéaire, est il possible de le faire en passant par un transformer si oui lequel ou dois je d’abord transformer mes ligne en point et ensuite les projeter ?

Hello!I´m running a workspace that uses a HTTPCaller but this error is shown "HTTP/FTP transfer error: 'Failure when receiving data from the peer'" and translation fails....do you know how to solve this error? Thanks in advanced. The data is from an external website.

I'm trying to build an expression in Generalizer's'tolerance' setting that address this in every scenario (I have a Tester for node count beforehand, so this will only have to deal with polys with 2000+ nodes). I assume it's related to the perimeter but I'm not getting very far. Any suggestions gratefully received Thanks Paul  

For some background on what I'm doing, I am trying to create a workspace to export some data from an Oracle database and write to a shapefile. As I don't know the attributes/geometry types ahead of time I'm making use of the SchemaSetter and dynamic options in a FeatureWriter.  This is mostly working fine, but I'm having issues when it comes to MultiPoint features. I've created and attached a very simple workspace that demonstrates the problem I'm having.  I'm using six creators to create two features of each geometry type, then aggregating these together to create a MultiPolygon, MultiLine and MultiPoint. I'm then running these three features through a SchemaSetter and writing to a shapefile, with a Geometry type of 'First Feature Defines Geometry Type'. The MultiPolygon and MultiLine features get written to the file and look as I'd expect in a GIS program.  The MultiPoint doesn't however, as the log states that:2020-10-02 15

Hello, I have a line that I would like to cut by points (no issue with that so far with the pointonlineoverlayer).Then, I would like to order the new lines so that the end vertex of the 1st line is the start vertex of the 2ne line, the end vertex of the 2nd line is the start vertex of the third line etc.On the picture, on the left is the regular result, no order. On the right is the result I would like. Does anybody have hints about that ? I found similard subjects but I did not find one which really applies to my issue. Many thanks in advance,Ann

Hi! I have been running FME Server 2019 for a year now without any problems. Upgraded both server and Workbench to 2020.1 two weeks ago and initially everything seemed fine. However, I discovered that new workspaces that I upload to Server will not run. The jobs imidiately goes into queue and then fails shortly after. No log file is created. All the old excisting workspaces are running as normal.

I have around 20 models with variable geometry traits (variable in number of traits and their names). I want GeometryPropertyExtractor extracts all of models traits without I have to determine traits' names in the GeometryPropertyExtractor individually for each model.Transformer guide advices to leave traits name blank and it can extract all of traits, I tried but did not work for me yet.

I have two tables - the first lists a series of attributes and values against equipmentAnd the second lists the expected attributes that should be listed against each equipment typeI need a way of telling which are present, but more importantly which are not. So in this exampleEquipment 5 is completeEquipment 10 is missing SumEquipment 15 is missing Count Ultimately I need to get a scoreSample 100% existsSum 0% existsCount 50% exists The bit i'm really struggling with is the absence of things since the equipment table is huge and the requirements differ for each equipmenttype Thanks for your help

I have a workflow where I am truncating an existing gdb table and a single attribute value is not being constantly output. The target attribute is a text field with a length of 50. The values that are supposed to be output to that field are all less than that length. About half of the time I run the workspace, it correctly outputs the values as expected. The other half of the time many but not all of the values come across as an empty string. It seems to switch back and forth between outputting correctly and encountering the issue. Regardless of if the issue occurs or not, the feature cache at the final transformer of the process always shows the field fully populated as it should be. The issue happens while the data is being truncated to the gdb table. When the output is viewed in ArcGIS Catalog, the field has an asterisk next to it, and is the only field in the dataset that has it. From what I've seen while researching th

Is there any possibility on using writer feature that has been generated into reader feature so I can avoid from running the workbench twice?

Welcome to the last What’s Up Wednesday of September! Google SheetsV3 of Google Sheets was scheduled to shut down today, but has been extended to January 26, 2021. Even with this extension, it is still a good idea to update your workflows to V4. For more information see this article. If you are creating a workspace with 2020.1 or newer, the Google Sheets reader/writer will automatically use V4.  Gartner Peer Review SurveyDo you love FME and love earning shiney badges on the community? For a limited time we’d to offer you a special community badge for sharing your experience with our products on Gartner Peer Insights. Get started by visiting http://fme.l

The first writer feature was done by connecting the list of wanted attributes to the attributes template I have done. So I run it and wanted to proceed to a new translation which involved transformers. Is there any possibility I can just connect the writer to feature so I don't have to run it twice?

Hi, I am currently trying to create a new attribute based upon a number of sub-string matches. Currently this is using the attribute creator and a condition statement (lots of else if's). This is currently works, however, I need to extend this to provide all the matches rather than just the first match. Some of the original values may meet one or more of the conditions for the new classification. I know I could do this in a series of subsequent attribute creators, but there would need to be over a hundred individual ones. Does anyone have any advice on how I could do this more streamlined! Thanks!

Please help me regarding issue in float the license in another machine.My floating license is up in one machine and static IP assign to it. When we assign floating license in another machine we are getting error regarding port. I ask network team ,all port open for server.

Hello everyone! I'm trying to get to know if it's possible to cluster (combine with the same e.g. cluster_id field) points that are lying within some distance to each other and additionally have the same, selected attributes.For example I have PostGIS data containing buildings as points. Some of them have the same elevation and are very close to each other, due to the fact that someone entered them like this. I need to make my data smaller by grouping them, but only if they are close to each other AND have the same elevation (to be sure that I've grouped points standing for the same building.Here's example which I've been able to achieve for now using PostGIS only:select geom, point_id, height_ft, elevation_ft, obstacle_type, clst_idinto output_table_namefrom(SELECT geom, point_id, height_ft, elevation_ft, obstacle_type,       ST_ClusterDBSCAN(geom, eps := 0.0003, minpoints := 1) OVER() AS clst_idF

I want to know how FmeServer sets the relevant parameters of ESRI Reprojector

ESRI Reprojector failed in FME Server

I have features that I'd like to create one row per Precinct and the create an attribute for each Contest values assigning the Votes value to each of those new attributes. I have looked at the Attribute Exploder, the Aggregator, the List Exploder, etc. I'm a bit stumped. Any suggestion on how to accomplish this?  Something like this: Thanks for any help!

Hi everyone! Is FME 2013 compatible with Win Server 2016 or 2019 ? Thanks in advance.