FME Form

Hi,We have FME server FME Server 2022.2.2 Build 22782 using SSO to login. We have role based acces to functionality using sync with Windows AD. All users can login to FME server using 'Use Windows Credentials 'except one person who has the same role(s) attached to him as other users. Different browsers were tested fmeserver log is attached to this call. Error is at line 295 Kind regards,Gerro Zegeling 

The firs one query is  And the second one is Then I need to do a join with this second query and create a list with the results.I dont know if with the SQL Executor transformer I can replicate this two querys.  Any idea? Thanks

I can't open the following dataset on FME work bench.

I observed some issue by when executing workbench, I used following software and version mentioned below:              ArcPro Version – 2.9.0             Python Version -- 2.9             FME Workbench – 2021.1.3.0    I need some help on this. 

We would like to automate all the steps in deploying and configuring FME FLOW. Most of the steps in the application itself can be done via the API, however there is no option to do this for the proxy settings. We have tried many things already:-Setting the environment variables in windows-Running mcd-scripts to set the proxy for windows and FME itself (https://docs.safe.com/fme/2019.0/html/FME_Server_Documentation/AdminGuide/Using_FME_Server_wit)-Looking all over the v3 & v4 API documentation-Looking in all the FME flow config files-adding the proxy settings in the server.yml file in the tomcat folderAll above didn't work So do you still have a suggestion? We assumed it might have to

Long time listener, first time caller.Newish to FME and was attempting to use a user parameter for the first time to allow the user to input the number of days they need to pull data. I have the parameter and the initial formula working fine. DaysPulled is my user parameter: @DateTimeFormat(@DateTimeAdd(@DateTimeNow(),-P$(DaysPulled)D),%Y%m%d) The problem I'm running into is later on in the flow I need to use that user input and add a number to it, effectively turning the user parameter into DaysPulled +1 and DaysPulled+2. I've been beating my head against the wall trying to modify DatePulled using add, sum, +1, etc and can't find the right format to get what I need. Example of failed attempt.@DateTimeFormat(@DateTimeAdd(@DateTimeNow(),-P@add(1,$(DaysPulled))D),%Y%m%d) Can anyone point me towards a solution?

New to FME. I can't figure out why my writer (a .gdb) isn't writing anymore. I built a step by step PointOnArea inspection on 4.5mil addresses against specific shapefile polygons. I keep all 4.5mil and I just add a column that represents each polygonarea. In AttrMgr I reassign the 1's and 0's to Yes or NO. Everything runs awesome until I try to write the data. It stops immediately. The transformer message is very long but pretty much says something is wrong with every column and row.

Which FME version is compatible with SQL Server 2022

Hello FME community, I am new to working with PDFs in FME and Python. I have two input files as following: 1.   The first file is a PDF named “all_maps.pdf” with around 1000 pages. Each page represents a single map, and the page number serves as the ID for each map. 2.   The second file is a shapefile named “main_map.shp.” It contains mesh squares for the entire area, and each square represents a map in the PDF file with a unique attribute called “ID.” This ID corresponds to the map ID (page number) in the PDF file.  My aim is to combine the outputs of both datasets into a single PDF file, totaling 1001 pages. The primary map in the “main_map shapefile” should be on the first page, followed b

Hi all,I'm new to FME and there is a lot to learn. I have been trying to research into how to generate a heat map (Hot Spot Map) in KML for Google Earth using FME Workbench (2019.2). I can't find an approach or forum that explains how to do it. Could anyone provide some tips on the process of transformers required to generate this? I currently have all my data plotted on Google Earth, I want to transform the plots into heat maps of dense areas.  If anyone has knowledge on this, I would love to discuss this. Thanks in advance!

I am unable to see FME badges on my board. I completed FME basic training and some parts of FME advance and server. Please share the link for that.

I saw a filter area in Visual Preview and wanted to inspect my data to make sure I got the same number of rows as my source data has which was 92,688. I did not. I'm not sure why. I filtered on the column that has 92,688 entries, but what was returned was 93,231 (543 empty rows/records). I have no empty rows in any of my source data either. I'm using FeatureJoiner to bring over a column that was not in my original data. The two source files have a common attribute: LocationID. The Source file has 4,500,626 rows, and my joining source file has 92,688. When I joined the data it came back with the 4,500,626 rows with my added column and data (92,688). So why does my filter show 543 blank rows more?

Hello, I want to rotate my point cloud using 3drotate along the Z Axis. The thing is the rotation is made around the origin 0,0,0. So i extracted the centerpoint of my point cloud to use it as an Origin but I don't know what to put in Direction to still rotate it around Z axis Thank you

Hi,Using FME Desktop 2022.2.1.0 against FME Server 2022.2.2.  Using an HTTPCaller to download a ZIP file (60MB) from a remote host, FME server (Windows 2019) started sending errors from a certain point in time. the workbench in FME Desktop still runs well.  Earlier downloads using this HTTPCaller worked fine with same settings in HTTPCaller.  Attached the error log. Any ideas? Kind Regards,Gerro   

Hi,I'm working with land use data derived from satellite imagery, and I've encountered a persistent issue with gaps and overlaps. I've already use TopologyBuilder and AreaGapAndOverlapCleaner transformer in FME, and while they've resolved some areas effectively, there are still instances where gaps persist, and some areas have been unintentionally cut off.I've experimented with reducing the tolerance values, but the problem persists. Has anyone faced similar challenges, and do you have any suggestions or alternative approaches to address this issue effectively?Your insights and expertise would be greatly appreciated!

How to download and save multiple DTM zip files from CSV with URLs. Need help with settings for extracting individual files

I want to upload a file to sftp location and we have only private key for connecting. I tried using system caller by keeping this command inside that :sftp -i <private_key_path> -b - user@hostname <<< 'put <path_file_to_upload> <path_remotepath_where_to_upload>'and also tried with this command also:sftp -o -i <privatekey_path> user@hostname but none of the commands worked in fme server, it is showing as failed to execute the command, Am I giving the correct commands or could anyone help me out on how to connect to sftp using private key in fme server configured on linux env.

I have a workspace in FME Workbench 2022.2 that reads an ESRI ArcGIS Server Feature Service containing 7 layers. It successfully reads all 7 layers and transforms them to the appropriate feature types.  That same workspace in FME Form 2023.1.1.1 is able to read in the number of features for all 7 layers but only able to successfully read in the features for 3 of the 7 layers. On the 4 layers that fail it appears to be failing after the first batch of 1000 records are requested. As a test I created a new project with only the FeatureServer reader in FME Form 2023.1.1.1, again same problem. As another test I tried using the MapServer endpoint for the service rather than the FeatureServer endpoint that failed on the 4 layers. This successfully read in all 7 layers.ArcGIS Feature Service Reader: Got 4222 results for layer/table ID 0ArcGIS Feature Service Reader: Splitting reading of 4222 features into 5 batches of up to 1000 featuresArcGIS Featur

I created a primary key using SSMS for the new table but I still get the error the layer does not have identity properties.

I sometimes have to read from multiple readers. Is it possible to set the maximum features to read to ALL feature types? Not just all per reader? Related, is it possible to set the Search Envelop for ALL readers?

Hi All, I'm trying to create a workflow that iterates through a folder which contains individual GDBs (e.g. 20 individual GDBs) and then merges the Feature Classes with the same name into a new blank GDB.Any idea how to make that happen?Thanks 🙂 

Hi, I have 2 data sets (shape-files). A point dataset with 3d-points or at least points where the elevation is stored in an attribute field (different data quality) and a polyline dataset with 2d-lines whose vertices are identical to the points from the point dataset. Is there a way to assign the elevations from the point datasets to the line vertices and then create 3d polylines from them? Thanks for your help

I have a very simple workspace that just tests whether a string has a “.” Or a “:’ in it and if it does then these characters are deleted. I am using the Testfilter to test for the characters, and then a stringreplacer to delete them and then I must make sure the string is all caps. Is there a way to do these three operations by using the String Functions in the Testfilter? I haven’t been able to figure out how the string functions work. Also, will using the string functions speed up the translation? I have 47 million records to test and right now it takes 4 hours to run. I am using FME2018. I have included the workspace and source CSV file. Thanks.

In the writers, under user attributes we can see the table with name, type, of data, width., etc. Is there a way to copy/pate or export this table in csv? I am tasked with data type for multiple outputs, and it would be great not to do so manually.

We are attempting to use the Automations > Manage Automations as a built-in user, but when browsing to that page it is blank and there are no automations in the popup list. We've made the user a member of 'fmeadmin' and 'fmesuperuser' but it makes no difference. So far only the 'admin' account is able to Manage Automations.What are the minimum permissions required for users to make this work?