FME Form

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 (

It seems ok when adding smaller data layers but couldn't add bigger layers. I was getting memory not enough error message but my memory is only used one third.

I ve got some problems with expandig of an Zipfile. With HTTPCaller i download the (free available) file "https://service.geo.llv.li/download//gwr/gwr_li.zip". after then i try it to expand with ZipExtractor. As a result it rejects it always with the error_message: "Unexpected error: File name in directory 'gwrli_Spaltenerklärung.pdf' and header b'gwrli_Spaltenerkl\\xe4rung.pdf' differ." How can i resolve this?

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) 

Very disconcerting that Chat and Phone Support options have been removed from Safe's website. I guess now that you’re all full of Flow and Form you don’t need to handle people anymore. Note to self: should I ever run a business, find the demarcation line where things grow too big to provide decent customer support and ensure it never goes past that bound.

Hallo, I am looking for a way to access Sharpoint list attachments in FME.I have tried using FME Reader Microsoft SharePoint List or Transformer SharePoint Online Connector, but the attachments are not retrievable.Are there any plans for FME to add support for attachments?Can anyone suggest another way to download attachments in FME? I would be very grateful for any help with this task.