FME Form

Full error;PROJ: proj_create_from_database: crs not foundMicrosoft SQL Server Spatial Reader: Failed to read coordinate system from SQL Server because FME does not know about coordinate system `EPSG:102003'I can use 102003 in the ProjReprojector tool, but, rather than assign _FME_0 as the CRS for this table, it leaves it as unknown, which means the reprojector tool fails, and 102003 doesn’t exist for me to use in the CRSSetter transformers. How do I set the CRS in feature reader when my desired CRS is not in the catalog (note to FME: this is also a request) I tried defining a custom projection here; demos-safe-software.fmecloud.com/fmedatastreaming/Coordsys/Start.fmw?&token=01655ff804fe3b23f29a7b65568c51e81cd09691but this workbench failed in translation / does not create .prj file I can use.

Hi, Is there a way to remove build pyramids when converting geotiff images to mbtile? I just need the image to display and improve mbtiles creation time 

Hello, my previous post was not well Described apparently, i need to split .las just like that. please if you suggest any workflow do describe it a little more than just the name of transformer as that is usless for me (i dont really know how to use FME) 

Looking for a workbench that updates  an SDE attachment layer from a sync enabled HFL with attachments on AGO. The SDE layer with attachments is not archive enabled.  

Hello everyoneI have data in shp and obj format. I have a tree model in obj format, I want to assign it to points in shp format, then I want to export it as cesium 3d tiles, can you please help me with this? I tried this method with GeometryInstantiator, but I think I am doing something wrong

Hi All, I’m trying to dissolve thousands of polygons from different feature classes into a single shape in FME. The idea is to obtain a single external boundary after merging/dissolving all the polygons. The current dissolve transformer gives me an error while trying to dissolve the polygons.Parameters in the dissolver are set to default.Is there any ‘hard dissolver’ option to merge the following?  Thanks :)

Hello,Is there any way to assign Index “Primary key” to the field and Type “serial” somehow in another way rather than in Feature writer - User attributes? These options are not present in AttributeManager transformer, unfortunately. That would help me to reduce number of manual adjustments and use “Automatic” attribute definition. Because I have many FeatureWriter transformers in my workspace and I need to replicate it to read another data.   

Snowflake recently released their new "geometry" data type. Not to be confused with the existing "geography" data type. The geometry data type can contain geometries in other coordinate systems, not just WGS84. Whereas geography is specifically WGS84. See Geography vs Geometry data types documentation hereGeospatial Data Types — Snowflake Documentation When will FME support writing of the new snowflake geometry data types? Is there a way to do this right now, or will it be a future release of the Snowflake Spatial writer?

Hello to all,I need to add a missing property into an existing Pset. I tried the workbench shown by Liz in the post “Updating IFC example” but it doesn’t work in my case. Before testing with an Excel sheet contaning GUID and properties to add, I just test to add manually a single property:First, I created 2 attributes:Then I used the GeometryPropertySetter:With the XQuery:I find my previous properties in the “Proprietes” Pset, but I don’t have the new one “TypeVitrage”. Did I forget something or do I have to use “IfcPropertySetDefinitionCreator” ? Thank in advanceBest regardsBruno

I want to pull Google BigQuery data in FME and write as shapefile. Can somebody help me on how to do that?

Hello community!I am working on an analysis to calculate the percentage of incline or decline from railway level crossings. This means the incline or decline along the road that crosses the railway.The desired result is six percentage values. Three for each side of the track (viewed in increasing kilometer (M-value)). The three intervals are 0-4.5 meter, 4.5-8 meter and 8-18 meter, measured from the outer edge of the railway track.It is desirable that the length is measured along the road.Decline from the level crossing should be shown as a negative percentage value, and incline as a positive percentage value. Based on the client's wishes, I have divided the analysis into smaller tasks:Add a property that shows whether the road lines are on the right or left side of the railway, viewed in increasing kilometer (M-value). I have tested the LeftRightSpatialCalculator, but for some unknown reason it always gives me the same side on both sides. I see that TopologyBuilder is mentioned in the

One feature has 40 vertices and the other 41, but ChangeDetector using “Lenient Geometry Matching” option says they are the same. It's right?  

Hi folks, I’m trying to execute a python script using Python Creator. The flow is running as expected also with expected outcome, but its giving this error - I have checked the updates is FME package but still not working.Not getting why this error is occuring. If anyone has any idea about it, kindly help. Thanks in advance.     

Hi,I have a shape with polynones. I want to select 30% of the polygons at random. Is that possible?    

Basically here is the need: right now workbenches run (Using FME Desktop 2020.2 and Task Scheduler) and the email addresses are typed out within the Emailer Addressing "To" parameter.We would like things to be more easily updated. For example, if someone is no longer on the team, or if someone is new on the team, we would like to simply update a text file and ALL of our jobs will be updated. I tried reading the text file in, aggregating the addresses into one long string separated with a comma, but I wasn't sure how to assign the value to a User Parameter.(I tried a couple things and failed) Thanks in advance for your help.@danminneyatsaf​ 

In the above image, I read a text file that contains lines of data where specific lines that start with an ID relate to different features.In the #1 category it contains the projection information but I want to be able to set the projection of the other output ports based in the information in that line.How do I hold and set the projection of the Lines, Points, etc?I was thinking that I may just need to read the text file twice, once to get the projection from Port #1 and then have a feature reader that can then set the projection before processing the other output ports.Is there a more efficient way of doing it? 

Hello.I have a JSON file the looks roughly like this, containing a list of un-named values:{ [ { “UniqueID”:123446,      “Dealership”:”Dan’s Dodge”,      “Owner”:”Dan”,      “BestSelling”:        [ “blue”,          “red”,          “blue”,          ...          “red”        ]      ...       “Telephone”:”411”    },    ...  ]}My first JSONFragmenter feeds two workflows: the first workflow captures the named values (including “UniqueID”), and the second workflow immediately discards everything but “UniqueID” and the JSON from the first JSONFragmenter and then uses a JSONFragmenter to turn the JSON list into Features.  Finally, a FeatureJoiner that adds to each newly-minted Feature an Attribute containing the appropriate name for its unnamed value.  Now it’s time to FeatureMerge the new Attributes back into the first workflow by matching on “UniqueID”.Alas, the newly-assigned names are stored in the same Attribute of each JSON-list Feature.  So, after FeatureMerger merges the first Feature,

FME Desktop version: FME 2021.2I was trying to follow this article on How to Create an ArcGIS Enterprise Portal Web Connection (OAuth 2.0) (https://support.safe.com/hc/en-us/articles/25407772142733-How-to-Create-an-ArcGIS-Enterprise-Portal-Web-Connection-OAuth-2-0)It was going well until I tried to 'test' before moving on to Step 3 and I got the following error (see also attached):Unable to Retrieve access tokenRequest to update access token failed. HTTP Error HTTP/1.1 401 Unauthorized Does anyone know what this error in referring to? 

Hi community! I've been trying to formulate an efficient workspace that would:Extract feature service URLs from an excel sheet (many have the item ID number at the end)Download the GIS data from each feature serviceTransform the idea with typical cleaning upWrite out to a file GDB on a local server drive For steps 1 and 2, I've been experimenting with HTTPCaller and FeatureReader but haven't yielded a successful extraction yet. I think 3 and 4 will be straightforward, but if there any any suggestions (specifically with getting from 1 to 2) welcomed, and appreciate any feedback in advance!

I want to Run FME process through task schedeuler. The fme workspace is reading data through postgresql. I am able to run it through any specified user. I want to run this through LOCAL SERVICE in Task scheduler.But it is showing error. My 0objective is the process become independent of user  Error connecting to PostgreSQL database(host='', port='', dbname='abc', user='', password='***'): 'fe_sendauth: no password supplied Thanks

Trying to free up some space on our existing FME Flow server and noticed that there is a folder on the root C: named “FME” that have various FME installations folders. In each of those folders, there is .cab and other installation (.msi, .exe, .log) files. The total file size of these folders is ~50GB on the server!I cannot find any documentation that states that is okay to remove these files.  Does anyone have any information about these?Thanks for any help!-Cameron

I am reading dynamic data and sometimes there is text fields that contain newline characters and I would like to replace them with just a space. How would I go about this?   

I want to loop through the list ‘attribute’ in a PythonCaller and change some values, but I get an error. Line 34 is the for-loop.   File "<string>", line 34, in inputPython Exception <TypeError>: 'NoneType' object is not iterable Can you see the error?  def input(self, feature: fmeobjects.FMEFeature): feat = feature.getAttribute("attribute{}.attribute") for obj in feat: if "fme_varchar" in obj.fme_data_type:  

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. Streaming to a DatabaseThis week I saw a question about writing an incoming stream of data to a database: "I have a workspace that runs continually in streaming mode (receives from a connector). I want to write to a Spatialite DB while the workspace is still running. I've tried a FeatureWriter, but nothing is written out while the workspace is running. Is this normal behaviour for Workbench?" So there is a great article on the knowledge base about how to write to a database during a streaming mode. Writing is a little tricky because, generally, writers don't do anything until they have all the incoming data available, yet that's not going to work in a continuous stream. The article explains that you have to set Bulk Insert parameters, including the Features Per Transaction:  Here, the writer wa

Hi all,I see some strange behaviour when converting a simple 2D box from PostGIS to Geopackage in a dynamic mode (using schema). I have attached a simple workspace which demonstrates the strange behaviour. A simple box is created in 2D and writen to PostGIS as a postgis_polygon. I ckecked the table in the database and is has the correct definition for  the geometry (geometry(Polygon, 28992)). After the creation the table is read wit a FeatureReader of type PostGIS with the same connection parameters. It is set to read the schema and the features. The result is directly written to a geopackage with a FeatureWriter. Geometry is from schema definition. When i open the result in the Data Inspector i see the geometry type has become geopackage_multisurface where i would expect it to be of type geopackage_polygon. At the moment we are upgrading our FME environment (Form and Flow) from FME 2021.2.6 to 2023.1.2 and ran into this problem. In FME 2021.2.6 i did not see this behaviour. This parti