Best Answers

I have a workspace that takes a spreadsheet that contains these fields: And I've got that reader feeding into a FeatureReader that grabs the Source Dataset feature classes from a specified .gdb.  I would like to dynamically create a new attribute called "_description" and populate it with the values in the Feature Description column. The values that are referenced in the Feature Description column are not exposed, but I can view the values when I click on a feature in the visual preview. I've tried to use an AttributeCreator with the following parameters:However the output looks like the literal string input values, instead of dynamically grabbing the values from the feature:Is there another way I can achieve this?

Hello - I am retrieving value from "date" field using ArcGIS portal services . It seemed to be in this datetime format ( YYYYMMDDHHMMSS like below screenshot) on UTC time. I would like to change this to local time. Please help on how this can be achieved. Tried using datetime converter, but does not seem to work . Thanks,Naveen

I'm looking at some floating license logs for FME, hoping to build a reporting tool for it. What I've noticed is several cases where one user/machine checks out a number of licences in a short amount of time and check them back in after a while:I assume this is either the user starting multiple instances of one of the FME application on the same machine (or Workbench and Data Inspector) and/or using a WorkspaceRunner. Can anybody confirm that? And more importantly, does every checkout correspond to a checkin? I also assume that as long as there is at least one checkout active for a user/machine that counts as a concurrent license being used, correct?

Pretty simple data export, I have a reader referencing some SDE data and then a writer to a file geodatabase. But reviewing the attributes in the file geodatabase I see that the domain attributes are the codes (1,2.3, etc) not the descriptions (copper, steel, PVC, etc).Is there a way to write the domain descriptions and not codes? The same is true for the subtypes, it is writing the code (1,2,3) and not the description (tap, bend, saddle, etc).

Hi, I have simple workbench where outcome is saved as dynamic schema. Somehow, additional columns are added to attribute table of the feature classes in gdb. Any clue what is going on?

I have a "Directory and File Pathnames" reader that gives me a list of text files in a Windows folder. I want to pass those folder and filenames to a FeatureReader transformer and be able to read the text lines from them as output for further processing, but I can't seem to get anything out of the FeatureReader other than the results of the Directory and File Pathnames that go into it. How do I get the contents of the text files out?

PostgreSQL database login detailsHost: postgis.train.safe.comPort: 5432Dbname: fmedataUser:fmedatapassword: fmedata (not sure if it is that password) (getting ***) 

Hi, We recently upgraded from FME Server to FME flow and I've noticed that a few workbenches that contain only one python caller and a creator, are taking up to 10 times longer. Both environments hosting Flow and FME Server are identical in specs. Here are the workspace statistics from each environment FME Server:Average Elapsed: 12 minutes 44 secondsAverage % CPU: 96%Average CPU time: 12minutes 20 secondsAverage Peak Memory Usage 256mb FME flow statistics:Average Elapsed: 53 minutes 42 secondsAverage % CPU: 19.4Average CPU time: 10 minutes 42 secondsAverage Peak Memory Usage 264mb Does FME flow utilize CPU differently when using python, or is there some setting I can change in the form workbench? I can see from the logs that simple arcpy commands are taking 10x longer and the CPU is being under utilized in FME flow. I've looked into the transformer and can't find any processing settings - Is there a setting in FME flow that I need to configure? I can't figure out why

We have some Annotation points all in one feature class. We are looking to find duplicated annotation text that are close to each other. We used the NeighbourFinder and attached the attributes from the neighbouring annotation to the base annotation. This allows us to see that, for example, record OD=1 is close to OD=2. Then a Test Filter is used to check if the TextString is the same on the base annotation when compared to the neighbour.  From the results of the TestFilter we have a list of annotations that can be reviewed as it looks like they are close to each other and have the same text string (which may not be needed).  So, for an example, say there are 100 annotation points that come out of the TestFilter. For each of these points, one of the other points in that selection of 100 points is the point it is related to/neighbouring. So, we don't actually need a list of all 100 points, just 1 of the points from each relationship, resulting in 50 points.  Currently we are

I have two datasets:A calibrated road dataset. Every vertex of the line has the measure value (kilometer point).A table with car accidents with a field that indicates the kilometer point where it happpenedI need to create Point geometries for the accident using both datasets. In other words, I need to create a point event layer.As you can imagine, the accidents don't happen at an exact vertex of the road.Can FME create that point event layer?I've tried using the Snipper transformer, but I'm not getting the results I want.

Hi!Do you know if Counter has a limit on the number that are generated (maximum lentgh)? I suppose there is not but I don't find this information anywhere.Thank you!

Hi!I have on my computer a lot of versions of FME (since 2016). I have installed FME form 2023.1.1.1 and 2023.1.2 and I have a problem with FME workbench with these 2 last versions. On my windows session, when I click on the program, a FME windows appear with messages : "checking licensed" then "loading ressources" then "loading transformers" and then "initializing main window". After this message, nothing appear. I tried with an other windows session and it work very well. Same thing with administrator rights (I'm sorry I don't know the good term in english for that). The old versions work very well. Do you have an idea about where come from the problem?Thank you!

Hi,I am wanting to create a count that increases if a condition has been met. So as an example, if TIME is greater than 100 then the COUNT increases, otherwise it stays the same: TIME - COUNT20 - 170 - 1130 - 2220 - 340 - 380 - 3370 - 4 Been stuck trying to figure this out for a while. With Python this would be easier with the use of variables but I am struggling with FME on this one. I see the Count transformer has 'Group By' capability but I don't think that helps me for this situation.

When creating an automation, I find that the "Next Action" boxes will just clutter the workspace and I end up deleting them anyway. Is there any way that anyone is aware of, that they can be hidden by default? Typically, I setup data downloads to refresh data from various other agencies. So I have a single Trigger, which then executes / queues, multiple workspaces. They can definitely be useful if creating smaller workspaces, so this is where a toggle button would be useful!

Perhaps just of curiosity, I would like to know what all the lines in the safe.lic license file actually mean. Not an answer like "they are needed" but more information why they are needed and what they correspond to. FEATURE FME (this might be the main license)FEATURE FME_GUIFEATURE nationalFEATURE basic_rasterFEATURE segy_readingFEATURE segy_writingFEATURE smallworld (this is the license level)FEATURE fmeobjects_reprojectFEATURE ssis_extensionFEATURE spatialbiz I've heard during my years as a FME expert that some of these lines correspond to "old licensing levels" or similar but now with FME Form, is that really true?

Using Form/Workbench 2022.2, connecting to MSSQL 15 with 10.9 SDE over the top. I'm not an SQL expert, and this statement was a combination of my knowledge, ChatGPT and colleagues knowledgeSELECT    p.*,    -- Calculate the rate of nitrogen (N) application over the entire spread.    -- Convert the area to hectares, then multiply by the rate to get the total weight.    -- Finally, divide by the applied area to obtain the average rate.    SUM(p.Shape.STArea()  / 10000 * p.NutrientN / p.AppliedAreaInHa) OVER () AS  total_n_rate,     -- Calculate the total fertilizer rate over the entire spread.    -- Convert the area to hectares, then multiply by the rate to get the total weight.    -- Finally, divide by the applied area to obtain the average rate.    SUM(p.Shape.STArea()  / 10000 * p.RateKgPerHa / p.AppliedAreaInHa) OVER () AS total_fert_rateFROM    [Agtech].[MASTER].[ProofOfPlacementSwath_evw] pWHERE    p.[SwathMergeID] = '@Value(swathmerge)';This runs fine in SSMS with no errors and re

I am sending JSON data to a Text File Writer. The Text File Writer has its MIME type set to "application/json", yet the response Content-Type remains "text/plain". Is there a way to force this to "application/json"? (Note: Using a JSON writer does set the content type to application/json, but it formats the response as a JSON array, which is not suitable for my calling application.) Second, the application that will be using this Data Streaming service sometimes requires specific HTTP status codes to be returned. Is there a way to force the HTTP status code e.g. to 400?

Hi, fellow FMEers! I a problem that I cannot solve. I want to present 3D data along a line with breakpoints. In my script I want the line to be presented as a straight line (a profile).  It is important that the length of the line parts are correct but it doesn't matter where the resulting parts start.  The data input line is drawn from start to end but can begin and end anywhere (from west to east, north to south and so forth...).  Any hints or suggestions? 

HelloI took CityGML LOD2 RoofSurfaces (~1700) and textured them with an Orthofoto. If I write this to a 3D PDF or glTF it takes 1min and produces output of 50Mb in PDF and 15Mb in glTFIf I write the same data to an ESRI File GeoDB it takes 5h+ and produces a File GeoDB with ~6Gb size .What is going on here ? Do I need to specially treat the surfaces before writing them to the File GeoDB ?

Hello everyone,I'd like to outline the main concept of my work. I am working with two point clouds, one representing a road and the other obstacles. Initially, my goal is to determine the minimum distance between these two point clouds. To achieve this, I rasterize both point clouds and calculate the difference (A-B). I then identify the point with the minimum height (Xh, Yh) and its corresponding difference height (H). After that, I rotate the two point clouds, merge them, and rasterize the combined set. The result is like represented in the first picture. However, I aim to enhance this representation by adding an arrow to signify the distance H, as shown in the second picture.  My idea (maybe not the best) is identifying the neighboring pair in the two point clouds close to the extracted point with the minimum height (Xh, Yh). I intend to draw a line connecting this pair, label it with H, and either rasterize it with the point cloud or incorporate it in the end somehow. For now i

All our processes that were inserting NVARCHAR(MAX) values into SQL Server databases have stopped working correctly (FME inserts NULL values into NVARCHAR(MAX))after the latest FME upgrade (2022).  We have found a temporary solution using the Microsoft SQL Server Non-Spatial (JDBC) format instead of Microsoft SQL Server Non-Spatial but it requires to modify a lot of workspaces manually. Does anyone know if this is a bug and if it will be fixed? Thank you! 

I have created a process that simulates the horizontal wellbore creation processes for a client. However, I am stumped on, what seems to be a rather "newbie" process of flipping 180 degrees a select set of features. Let me illustrate further:  In the example below the user selects a township to create the horizontal wellbores. The workbench tiles the township into 6 sections by default. They next pick a direction (ie East/West or North/South.) Next they choose a starting location for the Surface Hole (N, S, E, or W.) Lastly they choose how many wells to place in each section.  The result is this of a North/South orientation with the surface hole in the south and 6 horizontal wellbores placed in the sections. So far, no issues this is version 1 where they all go in the same direction.    However, the client also wants the option of creating a "pad well" style drilling progam. In this case alternating rows would be flipped or reversed. Normally I am able to figure thi

I have a workbench I'm updating from 2021.2 to 2022.1. It reads in features and then following the general flow from this article (https://community.safe.com/s/article/how-do-i-write-updates-to-an-existing-arcgis-onlin) does the change detection and then updates the portal service. In 2022.1 I'm running into an error though where when it starts writing the updates I get" ArcGIS Portal Feature Service Writer: Could not find a layer/table matching feature type 'ParcelTest_DBO_DelTest'". I've used the GUI to select the item from the portal, the only difference I can see is the '_' instead of the '.' in the service name. I can't change this though. In 2021.2 the writer has the '.' in the name. I can click on the url of the ArcGIS Portal Feature Service Writer: Requesting metadata for Feature Service at 'https://xxx.xxx.xxx/server/rest/services/ParcelTest_DBO_DelTest/FeatureServer' message and it opens the rest endpoint  

If anyone is using Asana, please help me. I have the portfolio, projects, and users table in my FME workspace. I am trying to figure out a way to be able to use the project GID to be able to get their tasks but there's a problem with the tasks table. The task api has an endpoint to ONE projects. I am envisioning where I can pick different projects and be able to look at their tasks.  Does anyone have any idea? I was thinking about looping but I'm having a hard time understanding how I would loop if the task's api can only GET one project.

 I have a unique requirement that I'm racking my brain trying to find a solution. I have a set of irregular shaped polygons, and I would like to draw a line between all unique pair of vertices. In the crude example below, the black line represents the input polygon and the yellow represents the desired result. Ultimately, after building the lines, I want to query out the longest line for additional processing.