FME Form

I have a highway line feature class and a highway distance markers point feature class with points created at 2km intervals along each highway line. I am being requested to create a rotation value to apply to each point on the line that is equal to the perpendicular angle on that line at each point. This angle value will then be used to apply label rotations to ensure each label comes out perpendicular to the line feature it is on.

Hi, has anyone had an issue with updating a non-spatial Oracle (19) table. The table has been registered in SDE, hence has OBJECTID also.There is no failure, but the record is not updated. If I use an SDE writer with update operation, it works fine, but takes over an hour for 300K records. I am using FME Desktop 2022.1Any ideas ?

https://firebirdsql.org/

I´m using a Chart Generator to create pie and bar charts, and I need to insert them into an email created with Emailer inside the proper HTML syntaxis.   I tried to write the charts into a png writer but I cannot link it to a parameter so it can be there.I also tried to set the image into a sharepoint (corporate) and use the url to link the image but it still do not work. Any thoughts?

How does one pass a user parameter to a pythonCaller that's inside a customTransformerimport fmeimport fmeobjects def processFeature(feature):    p = FME_MacroValues['SomeUserParameter']    print p I read here "If you put your pythonCaller inside a custom transformer, the parameter name changes to {customTransformerName}_SomeUserParameter. "I tried then doing this below but still does not work.import fme import fmeobjects  def processFeature(feature):     p = FME_MacroValues['{customTransformerName}_SomeUserParameter']          print p What am I doing wrong? 

Hello,I have pip installed a python package to FME Desktop using the advice on the site:https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_Desktop/Workbench/Installing-Python-Packages.htmThe package shows in the correct folder:However when I try to import the package into the PythonCreator FME tells me it doesn't exist:Can anyone please tell me what I am doing wrong?Thank you

I've got walls. dgn file. In the source dgn file, there are numerous lines that are utilized to form walls.I wanted to combine all these different lines into a straightforward wall. so I joined manually the outermost wall line to create a walls shape/polygon.In the attached sample file , source features and One straightforward wall feature is created in "merged wall" level/layer number 2(blue color) for ref. I just drew one simple polygon feature how the expected feature looks like. . Please, if someone can assist me.

@Andrew.griffin@gmail.com

Hello Guys need your support with this case we are getting car position from streaming data 30 thousand points every 30 seconds, we use time windower to get the position of each car every 5 min, then we use a filter to check if this car entered the delivery zone,what we are looking for is to store the event when the car gets in and when it gets out and we have to store only one record for each event this event will be stored in the database as follow Crad_id start_time End_time StatusTK256 14:20 14:35 within when we store the event in the database the first time there will be no end time since the car is still within the delivery zone as soon as it gets out we will update the end time Any Suggestions we want to achieve something similar to this

How can I publish images to arcgis server image using FME? I'm newbie on arcgis server image. Thanks

Hi FME Community,Has anyone run into this odd issue? FME Workbench 2022.2.1 (FME Python 3.10+).I did have issues installing transformers from FME Hub within FME Workbench, though it now seems to have resolved itself. (Note: removed sensitive but otherwise inconsequential information)Initially FME would throw an error similar to: An error occurred while installing Python package with 'pip install --force-reinstall --no-deps --no-index --find-links C:\Users\<user>\AppData\Roaming\Safe Software\FME\Packages\22776-win64\PackageFiles\safe.emailer\python --target C:\Users\<user>\AppData\Roaming\Safe Software\FME\Packages\22776-win64\python\safe.emailer --upgrade --no-compile fme-emailer' : Process crashed. An error occurred while installing package 'C:\Users\<user>\AppData\Roaming\Safe Software\FME\Packages\22776-win64\PackageFiles\safe.emailer'Sadly FME isn't more descriptive than this. Feedback for FME D

 Hi,I am a beginner on FME and I have some difficulties.I would like to extract from my LiDAR point cloud, the local maximum elevation with the x and y coordinates of each building footprint.I have as input :- a LiDAR point cloud- the footprint of each building in format shp.As output, I would like to have a .txt file with the maximum z of each point as well as the x and y coordinates of the maximum, all in the same .txt file.I was able to extract the LiDAR points for each building footprint using the Clipper tool.Then I used the PointCloudStatisticsCalculator tool.I get my zmax for each building as a table. But I can't get them together in one .txt file with x and y coordinates.Would you have an idea to solve my problem?Thanks in advance.

I can group separate features together for labelling purposes and this is what the attribute looks like as an autocad_mtext_string However, I can only assign one colour by using this approach.How can I assign separate colours to lines of text within a grouped mtext string so it looks like this? 

Hello,I am using the chart generator with some small numbers to make a scatterplot. I can't figure out how to display the axis values in scientific notation. See the example chart generator output image below using some made up values. The Y axis values range from 1.0e-3 to 1.0e-9. I would like to change the axis values to scientific from decimal.   Thanks for the help   

Hi,I am having an issue where I want to remove duplicate values from the results of the change detector and merge them all in to a single row to remove duplicate entries. I have provided an example below.If you need more information just ask. Thanks.

Hello,I'm trying to create geometry from Sql Server geometry Blob to shapefile. I'm trying geometryextractor but it is not working.(I can not create geometry in Sql server; I can only read data).Thanks for help

Hello fme team, I have a line of length 100M, When i load to fme the defualt measure is 0-100, the real measure position of the line is start = 15.0 and end = 16.0, the line has attribute columns start and end in the attribute table.  Any idea how i can assign the start and end as measure values instead of the default measure 0-100? regards,Keller.

FME 2021.2.3.0 (20220131 - Build 21812 - WIN64) I want to query an OGC API feature service by an attribute, to be precise, by a list of attributes.In my case, I‘m trying to query the cadastral parcel service of North Rhine-Westphalia by cadastral parcel numbers: https://ogc-api.nrw.de/lika OGC API - Features (WFS 3.0) Reader:Defining the parcel number as static parameter value works fine.Injecting the parcel number as published parameter works as well.But the 2 ways above are static. I have a list of cadastral parcel numbers to be processed.Normally the FeatureReader transformer

I am experimenting with a new workbench that has python startup and shutdown scripts. Everything seems to be running successfully. I'm using FME 2021 as I need 32-bit capabilities for ESRI. After the workbench is done, I'm calling a python script that runs a series of SQL queries. The script finishes and FME says "Translation was SUCCESSFUL". However, the workbench is still running and I have to manually click the Stop button. Any thoughts?

Hi all, In the attribute of my data, there is sometimes newlines and I want to trim them. I am using the AttributeTrimmer however it is not working. The data looks like this: {33}SCHOOL, BUS ONLY 8-10AM 12-4PM EXC SAT-SUN-HOL SEPT  THRU JUNE,I want to trim it like this: {33}SCHOOL, BUS ONLY 8-10AM 12-4PM EXC SAT-SUN-HOL SEPT THRU JUNE, Is my setting not correct? Best

I want to translate a dataset from shp to gpkgThere is a id field in attribute table in shp file. I added the transformer "attributeRenamer" to rename "id" to "shp_id"It is success on 2022.0.2 versionWe can't see shp_id field in gpkg and the value in id field is keptBut in 2022.2.3 vesrionIt throw the error as 627 2023-2-28 13:03:03 | OGCGEOPACKAGE writer: OGCGEOPACKAGE writer: For feature type 'd_y_n40', primary key attribute 'id' has unsupported type 'mediumint'. Primary key must have type 'int,PrimaryKey' Is any way can I fix it?Thanks

Hi y'all,I don't get it: I have a raster file with 3 bands: RED8, GREEN8, BLUE8, ALPHA8. The alpha band is either 0 or 255. There is no gradient. I need to hava a RGB24 raster with NoData, where Alpha is/was 0. The RasterInterpretationCoercer with "Apply the alpha band" will return these areas white. 🤷🏼‍♀️I already tried other solutions, but couldn't get what I wand.Can anybody help?

AllI am having trouble automating some workspaces as the data and folders that I receive are containing dates in the format MMMYYYY as shown below...\\\\server\\FMEData\\DataDownloads\\Supplier\\Data\\Data\\Name_Mar2020 The files are supplied as shapefiles and they are also named Name_Mar2020.shp etcHow can I automate the running of these workspaces for when the folder or file name changes to the next month?? I have tried using the * in various places, but to no avail and don't want to have to run these manuallyI know this is something obvious, but just cant figure it out... Regards  

Greetings,I am getting thousands of warnings, and would like to understand more about them. Let's take these two for example and go from there. Can someone help explain what these warnings are and how to correct them?Also, are these warning slowing the run time down? The run is quite slow, and it's unclear to me exactly why.Thank you,TylerFME Workbench 2022.1 

I've read the documentation on how to connect to Google Maps with an origin and a destination parameter; https://developers.google.com/maps/documentation/urls/get-started Now, let's assume that I have an Excel sheet with columns for origins and destinations, for maybe 100 posts. Is it possible to use FME to send these to Google Maps and then get each of the calculated travel times back, to create a "travel time" column for the excel sheet?