FME Form

@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 connector Thanks

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 Devs: could FME print out the Python traceback when transformer instal

 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 is the method of choice to inject attributes into a reader.But this time, it fails!Obviously the FeatureReader doesn’t compose the query the right way and sends a bulk request to the service: https://ogc-api.nrw.de/lika/v1/collections/nutzung_flurstueck/items?f=json&offset=80What’s going wrong? Best regardsOliver 

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?

I have a polygon layer with overlapping polygons. These polygons have dates. What I would like to have is no more overlapping polygons.Where two or more polygons overlap, I would like to preserve the youngest polygon. If the size of the overlapping polygons are different, then I would like to cut out the youngest polygon and preserve what is left from the older polygon.

I am trying to read cell A1 from an Excel file but FME Desktop seems to have a problem with that cell for any Excel. Example 1 (fail): Example 2 (success with other cell): What is happening with cell A1? Why can't I read it like the rest of the cells? Any help would be appreciated! Thank you!

I have 64-bit FME installed and want to read ArcFM'ised ArcSDE data. I have ArcGIS Pro v2.8 on the same machine and 64-bit Oracle client as well. I was able to generate the .SDE connection file in Pro. However using the same .SDE file, I am not able to view the feature classes in FME. I am constantly getting the following error message "Could not open Enterprise Geodatabase. The error number from ArcObjects is -2147216072. The error message from ArcObjects is {Underlying DBMS error[Unknown error No extended error.]}" We also have ArcFm ObjectReader for ArcGIS Desktop 10.6.1a installed as well. What could be the possible reason ?

We sporadically get this error from the SDE-DB reader. We are using FME Desktop 2022, ArcGIS Pro 2.9.5, ArcGIS for Desktop 1.8.2 + Background Geoprocessing for 1.8.2.Log says the following:Could not open the Enterprise Geodatabase. The error number from ArcObjects is: '-2147220952'. The error message from ArcObjects is: {The Product License has not been initialized.}Please ensure the connection parameters are correct ([...])It could have failed to open because it contains ArcGIS Pro-only features, for example Arcade expressions. If this is the case, please install ArcGIS Pro or Pro-compatible ArcGIS Server and 64-bit FMEGEODATABASE_SDE reader: A fatal error has occurred. Check the logfile above for detailsFailed to obtain any schemas from reader 'GEODATABASE_SDE' from 1 datasets. This may be due to invalid datasets or format accessibility issues due to licensing, dependencies, or module loading. See logfile for more informationWe tried setting the license compatibility optionWe use the

With the DGNStyler you can set a fill color, but is has to be a value. In Microstation there is an option to set 'No Fill' (see screenshot below).  Is it possbile to set a no fill directly in FME (with the DGNStyler or otherwise)? I tried a few things with 'igds_fill_color' and 'fme_fill_color'; however so far no success.   

I am working on developing a workbench to "warehouse" my organization's data on a weekly basis. The data is spatial in nature and stored in a SQL Server database. It needs to be moved to an Oracle environment on a weekly basis. Reading the data into the workbench has been very slow, especially for one feature class that contains around 9.5 million point records. During some testing, I noticed that when I remove the writer, the read time dramatically decreases (from around 40 mins to 10 mins). Is this expected behavior? Are there any ways that I can increase the performance of reading/writing these larger datasets?

I have parcel boundaries, And i need to create outer boundary for parcels using some attribute name. In my group there are 4 types of attributes will come (attribute value a,b,c, and d) so i need to create 4 outer boundaries.NO OVERLAPS on outer boundaries. and are gaps between parcels and sometimes parcels are far from each other. Pls anyone can help me? i tried hull , but hull overlaps some cases.