FME Form

Hi @mark2atsafe​, I've read your interesting post (dated 2023-11-15) on LinkedIn about surface model in FME. Could you please share the workspace in this post? Thank you! 

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 

Hi,I wonder if it's possible to download all the tiles from a WMS web server. I would like to cache them as a Geopackage Tiles for exemple or XYZ Tile layers.  Do you know if this is possible ? Thanks,Arnaud

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

 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.

When I migrating a workspace from FME 2019 to FME 2023, the FMEServerJobSubmitter in FME 2019 version returns _status feature attribute which helps me debug if the job is suceeded or failed. However, when I opened it in FME 2023, there is NO _status attribute returned after the workspace runs. FME 2019: FME 2023:How can I get the _status attribute back in FME 2023? or is there any other way to get an attribute value similar to _status to info the user if the run is succeeded or failed? Thanks for the help!

Hello everyone..I have Laz data and I want to bring the base completely to Z = 0 without disturbing the 3D position.How can I do that?

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.

I have a workbench that's converting 3D CAD files to 2D shapefiles, and some attribution changes. After reading in the CAD data, there's a test filter that separates the data into 4 separate paths, in which each path has a separate Shapefile it writes to.My goal is to have 1 path run, and successfully write before beginning the next path. This functionality would need to happen after the test filter separates the data out. Is there anything way to configure this? I could split this into 4 separate workbenches and automate on Flow, but wasn't sure if there's a fancy transformer that has this sort of functionality before spawning a gaggle of separate workbenches.Thank you!

Hi, I have a pdf from which I can split into vector data (points, lines, polygons) and raster (pdf_rasterized_pages). I know the paper size of the pdf (A1) and scale (1:500). I would like to save the vector data in gdb and preserve lenght, area and position of the shapes. In general, once the shapes are opened in ArcPro they should have the same geomety and dimentions as on the printed on A1 paper. I have tried scaler but the outcome did not match printed pdf. 

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 iss

Hello,I have lines (linestring) that intersect forming Multilinestring. I would like to know if it possible to "force" them to keep the Linestring format? Example: here is a network with a loop (in red)On FME, I tried a deagregator which gives me 3 polylines , 3 linestring. Ok it's good! But I want juste one line and impossible for me to find how to merge these 3 lines without convert all in Multilinestring. I tried the LineCombiner but nothing happens, I still had my 3 lines.Any help would be appreciated :)Thanks you

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. 

Not sure which forum to post this in, feel free to move it if not relevant here. I'm revisiting the 12 Days of FME 2022 challenges, which were great fun last year and i wanted to challenge myself again this year. (https://community-fme-server-support.fmecloud.com/fmeserver/apps/FMEUCCommunityCafe/12Days-Details/streaming/fmedatastreaming/12Days2022/ContestDetails.fmw)  It seems that the datasets aren't available anymore though. Does anybody have the input datasets for each of the challenges that they could share please?

I am working on an AutoCAD to AutoCAD conversion where I am changing the text of text and Mtext objects and writing out the changes. The AutoCAD writer uses the input file as a template as the only parts I want to change are the text elements (whether text/mtext/attributes in a block). I am having a problem where Text entities (autocad_entity = autocad_text) are being written as MText entities in the output which is effecting the positioning of the text. This is happening for all text entities (autocad_text), where I have and haven't made changes Is there any reason why text entities would be written as Mtext, when they are clearly defined as text entities in FME? I have posted some images of before and after below for reference:Text Settings in FME just before writingA

Hi everyone, I have encountered the following issue: when writing to a Spatialite database a polygon with more than one hole, only one hole is created and the others get lost (see attached workspace). By the way, everything goes fine if I write, for example, to shape or geopackage. I'm using FME 2022.2.5.0 (20230329 - Build 22795 - WIN64). Could it be a bug? Thanks

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, is there a way to test an integer's length within the TestFilter transformer? I have an integer column that can be freely populated with values, but I need to flag rows that are not 6 characters long. Is there some operation in the Test Clauses window that I can use to test for this?

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 (