FME Form

Hi!I have a problem with JSONUpdater and the function "Delete From Array". My case : I have this JSON fileI want to delete the value 79240 in "structure_ids". In JSONUpdate, I can't write the value, it doesn't work.I do write the position of this value. How can I do this dynamically? Is there an IndexOf function on FME?And when I write a position, here 4, in JSONUpdater, it removes 2 values ​​instead of one (79240,79389). Thank you for your help 

Hello,I need to do a simple operation in any GIS software, like QGIS, but I can't replay it in FME, and then load this data on ArcGIS Server. For example, I have two polygons with the same code (two rown in a data base) and I need to fusion them into a single one, using a common attribute, the code. The result would be two geometries and only one row into database.  If I use Aggregator transformer, checking group by this attribute, apparently the result is ok, but output a geometry collection don't load to ArcGIS Server. I tried to use GeometryCoercer, after the output port of Aggregator transformer, but it didn't work.  So, can someone help me? Thanks!

Using FME 2021.2. I keep having to go into workspaces writing to SDE and change Table Handling to Truncate Existing. I know I have done this repeatedly on some workspaces and then come back to find set to Create If Needed. Anyone else have this happen?

I realize the fanout option is probably the best option. I have not used FME in quite a while and am looking for someone to spoon feed this to me. I need to read in a single GDB and export to another GDB based on the "LAYER" field.  

Hey community!How can i export CSV output without attribute name? I am transforming a CSV file with East North coordinates but in output the first data is the name of the "_result" attribute that I would like to delete (attached image). Thank you!

Does one get any certification or acknowledgment letter, after finishing the FME training?

Hello,I have several thousand records, each with a date and demographic information. I have set up a workflow using the statistics calculator to get a cumulative sum of each demographic column. Where I am hung up though is grouping these records into weeks, and then doing my cumulative statistics for each week.Any help would be greatly appreciated!

The drawing has the title block "fugi tb info". When it's run, it says that autocad_block_name has no value.Help would be appreciated.

I am trying to create a simple dynamic workflow. But i struggle to understand how to add or remove feature types to the reader.For illustration i have created a database with 3 tables which are. I am reading them into my workbench using the "Single Merge Feature Type" option. The 3 tables can be seen under "Feature Types to Read"Immediately below it only the table1 listed under feature types. I am confused to why not all 3 tables are listed there?If i go to update the reader only table 1 is shown But if i run the workbench the dialog for Translation Parameter Values show all 3 tables I fail to see the logic behind this? How do I add or remove one feature type? Imagine I have 35 tables and I want to add or remove 1 of them from the reader. How do I do that?

Can we use FME Desktop for data migration from ArcFM Fiber to ArcFM enabled UNM?  Are there any workbenches similar to Electric/GAS/WATER available for Fiber Telecom ?

We currently have an Excel macro to copy cell data from an Excel source sheet and paste to another destination sheet. Once pasted, we will position those data in particular columns and apply some lookups.What would be the best approach to mimic such process in FME? Is it feasible to execute all those detailed steps by using FME transformer(s)?

I have a multi-workspace and I want the HTML file with this informationProductIDWorkSpace NameAreaTimeStamp with DateStatus (Fail, Pass)  

We have digitized some roofs with dormers.Now during the creation process the dormers were digitized into the main roof to avoid gaps. Unfortnatley there were no snapping used.For example:Is there a way in fme to cut these roof polygons from dormers which are inside the main roof (blue line)?

Just found that a workspace I thought was working perfectly is not writing out BLOB attributes. The workspace creates schema attributes and writes out to a geodatabase. Unfortunately, the schema features for BLOB attributes--currently set with native_data_type = blob--are not writing out. So:Can FME even write out Blob attributes in schema features to a geodatabase?If so, what is the native_data_type to use for a BLOB attribute?Is the native_data_type value in the case of a BLOB (or in any case for that matter) case-sensitive?I have not been able to get FME to read BLOB fields from and existing geodatabase, so I don't have a native_data_type value to inspect. My BLOB attributes in the schema features currently have a native_data_type value of "blob" and an fme_data_type of fme_binarybuffer. Any insights? Thanks in advance for your help.

I am not able to connect to a SFTP server with FME Server. I have used the following description Using a private SSH key with FTPCaller to authenticate an SFTP Connection on FME Server and FME Desktop (safe.com) to create the workspace. The Workspace runs fine but after I uploaded to FME server and run it with FME Server, I get a "login denied" error.Version 2022.1

Hi, When using the S3Connector transformer with System credentials, if those credentials are invalid, performing an upload operation still produces an output with a URL as if there were no issues. It doesn't upload the file, it just posts a warning to the log. This is tricky to catch. Performing a List or Download opertaion with invalid credentials causes the transformer to output through the <Rejected> port with an error, letting us neatly terminate the workspace. Is there anyway to get the Upload operation to also reject when the credentials are invalid?

Hello friends. Help solve the problem of replacing the textures of a 3d object. I have an object to convert to gltf, textures of different formats are applied to the object and they need to be brought to the webp format (I understood how to do this part). But I don't understand how to use the Appearance Setter correctly. Any help is welcome.

Hey there,I need to transform a CSV-formatted file containing Geometry assignments into LandXML. Therefor geometry describing/containing clothoids need to be clothoids in the LandXML. They can be at the start, in the middle or at the end of a (line) geometry. I know how to create linear geometry (VertexCreator) and arc geometry (2DArcReplacer). But clothoids? 🤷‍♀️

I have a specific use case wher i need to read many dwg files. an dget several feature types from a specific layout (paperspace). 1 of the featuretypes i need to extract is autocad_insert. If i explode blocks on the reader I lose ALL layout information. specifically i need a closed polyline that is within the block. The insert point of the block is what i am going to have to use to place that polygon. so i will have to calculate the center of the polygon and use that to place it at the insert point of the block. I would be suprised if fme is not capable of deconstructing the block into it's components. i just hope it is a a logicial model. The block I am trying to gain access to is very simple. Just a polyline. nothing else.

I have a workbench that has around 7000 features and I want to run a system caller on each to produce an image (png) output, convert that image to a blob, store the blob in the database and delete the file. At present the System Caller is processing all features before it moves on. Is it possible to have the system caller run for an individual feature and continue on with the process?

After an effort, a building was converted from IFC format to citygml format And then converting from citygml to shapefileIt is now necessary to adjust the construction site on the map so that it descends to its correct locationThe correct location for construction is attached to the picture

I have a FME server web app based on a workbench. The results are contained in a simple table and written to both an Excel file and Oracle/ArcSDE. Any suggestion on display results directly after the job is completed on the same web interface. At this point, my option is for user to download the zipped Excel file and view results: only two rows in the Excel file: header row and data row. Thanks.

I am attempting to snap points or lines to multi-face surface features. I realize the 3D AnchoredSnapper does not snap to surfaces. Any thoughts on how to perform this. I would be ok with converting the surface features into lines since that is my ultimate goal. Any thoughts on techniques or transformers?

Hello, I know everything is possible with FME 😊 so is it possible to get faces from a single mesh? For example, I would like to extract walls, floors and roofs from this mesh:  But I did not found the adequate transformer yet. Thanks!