FME Form

Hi, i failed to convert this format to an CSV with header Has anyone seen this type of structure before?Thanks for all{    "nbResults": "2",    "columnList": [        "THE_LIBELLE",        "THE_ACTIF",        "THE_DT_CREA",        "THE_UTIL_CREA",        "THE_DT_DERN_MAJ",        "THE_UTIL_DERN_MAJ",        "THE_ORDRE"    ],    "keyList": [        "THE_ID"    ],    "rowList": [        {            "columnDataList": [                "Commercial",                "1",                "11/10/2022 18:15",                "Test X",                "11/10/2022 18:15",                "Test Y",                "1"            ],            "keyDataList": [                "1"            ]        },        {            "columnDataList": [                "Culturelle",

Hello,I know this is weird but somehow I cannot find the Google API key that I got but I do have it stored in the workbench file for years now, in the Geocoder transformer. Any idea how/if I could retrieve the API Key somehow? Many thanks

anyone tell me how can i get the data I m using HHTPcaller how can I get the Columns

I have a mix column that contains numbers and letters. in some records the first value or two first values ​​are number and then is a space then comes letter. the space und letter don't appear in all records. if a record contains this space I want to remove the space between number and letter.For example : 2 a -> 2a oder 22 a -> 22a.   

Via "Add or Remove programs" I select FME Desktop 2020.0 and click Uninstall. This message appears: "The feature you are trying to use is on a network resource that is unavailable. Click OK to try again, or enter an alternate path to a folder containing the installation package fme-desktop-2020.0.2-b20232-win-x64.msi in the box below." Unfortunately I can't find the installer anywhere, so I can't uninstall. Does anyone have any suggestions how I can uninstall FME 2020.0?

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

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.