General

I am trying to clip many different data layers based on a county boundaries for quarterly updates. I need each layer to end up writing to its own feature class. I am trying to not have to use a lot of different clippers or have to update the writer feature class name every Quarter. That is why I am trying to use a string concatenator that will add the correct quarter to a new attribute to use as the name each quarter. I figured out that I can use the feature type filter after the clipper to get everything to the correct writer feature class but the attribute that I created does not get passed through the filter. The field is under the drop down for blank and unfiltered but not on any of the other ports. 

Hello, I would like to know if this architecture is available with FMEServer : 2 Servers are independent, each have their own FME Interface / ConfigurationNevertheless, these servers share the ENgine.In this configuration , we can imagine for example that these servers share 2 static licences and 7000 hours of dynamic licences.I think it is possible using 3-tier architecture , but I'm not sure 100%. FME is getting more and more popular in my job and maybe, if technically possible, this architecture would be a solution to ease the administration.Thank you  

Hello FME community,I have two feature classes with line type. I would like to find the lines in Feature Class 1 that are parallel to other lines in Feature Class 2 at a certain distance. I calculate the angles of lines and with NeighborFinder I create a list of lines that are near but I don't know how to find the lines that have the same angles to feature class 1 (with about 10 degrees difference). 

Vendor provide me the API, for example: https://www.gocanvas.com/apiv2/submissions.xml?password=xxxxxx&username=xxxx@companyname.com&form_id=3971479&page=4; this way i just able to pull 100 xml pages. In order to pull "30 pages"(page4 is 100 pages of xml)i have to set 30 readers from page 1 to page 30.would you tell me how read all at once. thanks in advance note: page=4 mean i just able to pull 300th to 400th pages of data. i need to pull 1st to 3000th pages of data-> maybe we need to create parameter or loop to pull ?. thanks  

We are working with an Esri SDE SQL database and bringing some annotation layers into FME to review attributes and confirm the appropriate values have been applied based on our business rules. When looking at the Annotation layer within MS SQL Server Management Studio, the attribute of "ELEMENT" shows up. When in FME and after exposing all the attributes on the Annotation layer, no "Element" field is seen. What can be done to expose this attribute in FME?Thanks in advance for your time.

I have tested 7 different ways to download all WFS points within a geometry and all give an error using FME 2023.0 Tried the "Initiator OGC-Intersects Result", "Bounding Box OGC-Intersects",Tried settings a Filter<Filter><Within><PropertyName>Geometry</PropertyName> ... GML Polygon Data ... </Within><Filter> Filter Overlaps etc.Filter BBOX with and without namespace declarationsFilter Envelope Nothing seems to be the right settings. I remember having the right parameters when using FME2019 but that doesn't seem to work anymore. Maybe my service is not responding according to specs?https://geodata.nationaalgeoregister.nl/inspire/ad/wfs?request=GetCapabilities&service=wfs  

How I can convert milliseconds (for example: 1663767945000) to %Y-%m-%d %H:%M:%S ? I tried with a DataTimeConverter transformer but it doesn't detect the input format. Any ideas? Thank you.

When working with a File Geodatabase Writer, FME gives us an option(FME Parameter) to "Overwrite Existing Geodatabase" or not! Can someone Please let me know if there is such a option when dealing with a SDE Geodatabase?So how we can prevent duplicating (appending data again into existing dataset) when we want to load data into? Thanks    

Hello, new FME user here. I am modifying an existing script to download a CSV from an FTP site. I want this to trigger at the beginning of the process as shown in the diagram below. I want the newly downloaded CSV to feed into the CSV reader. How can I trigger the FTPCaller at the beginning of the script and how can I feed the new CSV file into the CSV reader? Any assistance would be appreciated. Thank you! 

In a SQLCreator, I want to return the records from a specific table, if a certain choice is made in a parameter. I have a published parameter "check_choice", that is a Choice Multiple Parameter.  In this example, I want to return table records from BUILT_UP_AREA_S if 'BUA_Road_RTY' is selected in the parameter. The database type is Microsoft SQL Server Non-Spatial (JDBC) in my SQLCreator. The statement below results in an error Incorrect syntax near ','.  What am I doing incorrectly in this statement?IF($(check_choice) LIKE "%BUA Road RTY%",SELECT * FROM dbo.[BUILT_UP_AREA_S]) 

Hi, the following problem: I want to update attributes of a shape file. To do this, I first read them in using a reader (regardless of whether it is a "shapefile reader" or a FeatureReader transformer), update them and then overwrite them using a writer. When I execute the Workbench step by step, everything works. If I run all steps at once, I get the error message SHAPEFILE writer: Shapefile writer: Failed to write to file '<pathToFile>\\Grid.dbf'. Please ensure that the file is not open by FME or another process, you have sufficient privileges to write this file, and that sufficient disk space is available. It looks like the reader is blocking the .dbf file. Does anyone have any advice on how to proceed?

Hello everyone, I have an issue on writer section, the data process completed but doesn't export output data into folder FME version 2022.1.3 Please Find Attachment Any help and advice would be welcome.

The information in the pdf file has the same columns as the attached excel file

We have remove the object from Categories à "Scope Boxes" OR "Levels" OR "Grids" from (Categories).Need to search for the Hiding Temporary Items>> Search for: "temp" from Attributes: Workset, Comments, Mark.please let us know how can we remove the above feature , thanks for your support .

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?

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.

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

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 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?

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

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 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 ?