Transformers

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? 

Hey. Hey. Could anyone advise how to write files to multiple datasets according to the number of sets defined by the number of flight tracks? The output dataset should contain the name of the ler route and some other attributes that are not relevant at the moment, however I need the number of datasets to match the number of flight routes ( ar_name attribute ). Currently I can only create one output dataset see attachment "current_dataset_routes_update_test". The attachment contains four flight paths in one dataset, namely Z410, L132, M725 and L602. The required output I would need is 4 x dataset Z410, L132, M725 and L602 see separate attachments with required_dataset + flight route name. I am also attaching a printscreen to give an idea of how to create the actual output dataset. The number of flight paths and the resulting dataset can of course vary, the process must be automated. Thank you very much. M. 

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've got two identical line/point features, each of them has a list of all attributes created by Aggregator. I want to compare these two list, some elements are same and some are not and number of elements may not be same. Matcher or ChangeDetector can do comparing part but can not out which elements are different. Is there a way to compare two lists and output different elements? Or can I just compare attributes of two features without creating lists?

HelloAs a FME Rookie ive a questionI have three polygons less than 1km square0.4 , 0.5 , 0.2 km² I would like to know if there is a transformer to adapt every polygons to a 1km² box each ? , i only know Bufferer but is it possible to have the same surface in three different geometries ? Thanks in advance !

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 routinely create buffers, and when I do I get thousands of tiny gaps which I need to fill, but only gaps upto a specific size. I can and do this currently very easily in MapInfo. I can quickly identify and then merge or fill these gaps with the rest of the buffer to make it look contiguous. As this is a repeated task on my part I want to do this with FME.I am thinking that I use the AreaGapandOverlapCleaner, however the tolerance to my knowledge is a distance setting, not an area setting, which I find odd as this is an "Area"Gap cleaner. My specific area size is quite small, just 0.005 sqmi.This is what it looks like in MapInfo. The yellow is my buffer and the red areas are the gaps of 0.005 sqmi or smaller that will be filled in. How to is set the tollerance to clean gaps of this specific size and smaller? Thanks in advance 

Here is what we want to do, review our annotation layers (from an ESRI SDE) to see if there are annotations that overlap or touch. When the annotations are brought into Form, they are represented as points. In the Data Inspector the text is displayed the same way as they display in ArcMap. Is there a way to convert the FME text into a polygon? Then we can check if there are polygons that touch (which there are many :D) Thank you for your help :) We are using FME Form 2022.2

After processing the data, I am using the Feature Writer to write the output into a file geodatabase. I have configured the Feature Writer to use the User Parameter name as the output geodatabase, which means that the database name should change every time I input a new name in the User Parameter field. Although I am getting the desired output file geodatabase every time I run the workspace in the FME Form, the same workspace does not change the output geodatabase name when I run it on the FME Flow. Using Version 2022.2.2 for FME Flow and Form. I would greatly appreciate any help to fix this problem.

Excel typically comes in non-standard or not exact database ready format. In my case, I need help on reading Excel file: when "Well Name" is "Shut In", I like to add a new attribute such as WELL_TYPE = 'Shut In' and assign this attribute value for all Excel rows below this until reaching the next value called "DUC" (i.e. total 6 rows, well_type ='Shut In')).  When "Well Name" is "DUC", and assign WELL_TYPE = 'DUC' for all Excel rows below this until the end of the file (total 2 row, well_type = 'DUC'). Your suggestion and help will be greatly appreciated. Thanks. 

I have been working on this challenge of using two HTTPCallers to update the assets' spatial data in the AMS (Asset Management System) via an API in the form of uploading the GeoPackage files into AMS. And here how the two HTTPCallers are set up: The first HTTPCaller uploads the GeoPackage file into AMS and in that process, it has to save a string value in the "_response_body" attribute in the FME Workspace - However, at this stage the upload is not working at all due to lack of the string value in "_response_body". Then the second HTTPCaller takes the string value in "_response_body" as a Job ID to do the validation of the file and after that begin importing of the data. And therefore, if the first HTTPCaller can't return a string value in the "_response_body", neither upload nor import of the GeoPackage happens. When I tested the API in Postman, it works as expected.

Since it almost exactly matches what I’m trying to do, I started with the workspace posted by @trantatsafe here https://community.safe.com/s/question/0D54Q000080hPh1SAE/agol-attachments-what-are-you-doing-with-the-attachments-after-youve-read-them Problem 1)There are 3693 attachments in the dataset.  When attempting to put them through this workspace, only a suspiciously even 2000 come out of the ListExploder. The others fail with the message MISSING_PARAMETER_LIST. Since they exist (visible from Esri), they must have attributes, don't they? Or am I missing something here? I hate to muddy the waters but there is also second issue: Problem 2)The 2000 records that do pass through do not link back to the points. I initially thought this was due to the reader bug https://community.safe.com/s/question/0D54Q00009PK7llSAD/read-arcgis-online-attachments-and-maintain-globalids-for-both-features-and-attachments?t=1703270433321 but I applied the GUID Generator solution without any success.

I have a DGN with linked word/excel/pdf documents and I am wanting to extract the filenames and connect to the relevant geometry within GIS. When I open the DGN in MicroStation I can see the linked documents but when I open in FME Inspector, they disappear. See attached image of links in MicroStation. I thought they may be pulled through into a 'linkage' field but they don't look to be.

I have a workspace that reads other workspaces, to do an inventory. I have looked for the Startup Python Script but I can't find it, does the FeatureReader not read that information?

I just started using FME and my first goal is to compare values from DWG attributes and Excel rows. Each Excel row corresponds to a DWG file, I use AttributeKeeper to filter out the same number of columns in each transformer and would like to test each column in the DWG file to the Excel file to see if they match. If they don't I want to add that row, where one of the columns is filename, to a new Excel file and output it.  I've searched this forum extensively but can't find a topic that matches my specific question. Some help on how to continue would be appreciated.  This is an example of my input from both Excel and DWG. I want to know if "Value1" in File1 of the Excel file is the same as "Value1" in "File1" of the DWG file, and so on. The filenames are always the same but the column names differs. 

FME Desktop 2021.3 Python Interpreter ESRI ArcGIS Python 3.7Hi I am trying to pass a user parameter that includes the ampersandi.e. username@domain, which I then use within a python caller to login to ArcGIS PortalWhen I look at the value of the parameter, I get username<at>domain hence I am unable to connect to my portal.I have tried to format using string functions str() and strip(). But it doesn't work Any suggestions ?? 

Hello,  We recently upgraded from FME version 2022.0.0.0 (20220428 - Build 22337 - WIN64) to 2023.1.1.1 (20231011 - Build 23636 - WIN64).After the upgrade one of my tools gives the following error: GEODATABASE_SDE writer: The encoded string is not a valid US-ASCII string: ''AsfaltverhardingPlaatsori\\xC3\\xABntatie'' This happens at a GEODATABASE_SDE writer. The writer uses the following settings:Feature operation: fme_db_operationTable handling: Use ExistingUpdate Spatial Column(s): YesActions preceding the writer determine what kind of db operation is needed Problem: It tries to process a 'ë' but fails to do so After some debugging and looking at other similar questions on the forum, I think it has to do with the locale/character set. In FME 2022 the process encoding was set to UTF-8. When I look at the locale/encoding used in our ArcGIS Pro enviroment (3.1.3) via Python I get 'Dutch_Netherlands, 1252'. This mismatches with encoding used by FME in the

I am creating a flow that runs a number of tests on an Excel spreadsheet and spits out the results into another Excel spreadsheet. The incoming spreadsheets will almost always be in different folders (same parent directory, but each project has its own folder within that), and I would like the outgoing spreadsheets to go to the same folder as input, and have the same filename but with the suffix of 'FME Test Results'. I am currently managing this manually, and wondered if there is a way to do it using FME.I have found several answers that seem to get partway to my goal, but don't seem to fully get there.Thanks,

I want to create a workbench that accumulates the flowrate through a drainage wastewater pipe network which has some flow monitors in between pipes and some at branches. I want to accumulate the flowrate such that: The flowrate of a pipe leaving a branch (with no flowmonitor) is the sum of the flowrates of the two pipes entering the branch (leftmost diagram)The flowrate of a pipe leaving a flowmonitor is the flowrate recorded by that flowmonitor (middle diagram)The flowrate of a pipe leaving a branch that has a flowmonitor is the flowrate recorded by that flowmonitor as shown in (rightmost diagram) 

In SharePoint you have the ability to add file attachments to records in a List object, can FME access these at all? I've tried the FME List Reader, which just gives a Yes/No field on if an attachment is present, and the SharePointOnlineConnector, but I can't seem to get it to view List objects at all.

It looks like it displays the correct value but for some reason when you click on it or look in the "Feature Information" it looks like it's the truncated version of my string. When I try to preform other operations it'll use that truncated version too which sucks.

Hi, I have a polygon feature class, and want to process each polygon one by one, sending it to a fme flow job submitter. I tried writing out each polygon as a shape, and process then as a path file *.shp, but there must be a better way. Rudy