FME Form

Hi there,Relatively new to FME and very new to JSON and API’s. I’m working with the Smartsheet API and I’m stuck on how to the get the data set up properly, I’ve gone down many of the JSON Transformer rabbit holes and I can’t find a similar example to how this data is set up. When I use the JSON Fragmenter, I get columns and rows returned as separate arrays:  The columns are set up like this: And the rows/cells:I’ve gotten as far as exposing the attributes for each array separately, but I don’t know how to get cells back to the

My dwg writer is saving as type ‘file’ with no dwg association. How do I write as dwg and can someone explain what causes this?Thanks!

 File "C:\Program Files\FME\python\requests\adapters.py", line 348, in get_connection    raise InvalidProxyURL(requests.exceptions.InvalidProxyURL: Please check proxy URL. It is malformed and could be missing the host.2024-04-02 08:44:16|   0.1|  0.0|ERROR |Error encountered while calling method `input'2024-04-02 08:44:16|   0.1|  0.0|FATAL |SalesforceConnector_CALLER (PythonFactory): PythonFactory failed to process feature2024-04-02 08:44:16|   0.1|  0.0|WARN  |An error has occurred. Check the logfile above for details2024-04-02 08:44:16|   0.1|  0.0|INFORM|Translation FAILED with 4 error(s) and 1 warning(s) (0 feature(s) output)2024-04-02 08:44:16|   0.1|  0.0|INFORM|FME Session Duration: 4.2 seconds. (CPU: 0.0s user, 0.1s system)2024-04-02 08:44:16|   0.1|  0

I’m using a HTTPcaller connect to a swagger API that ONLY receives raw JSON data in the Upload Body or uploading a file (one block of JSON data per file). I can’t pass through any parameters from a attributemanager. When I try to pass through a parameter in the Upload body of the HTTPcaller, I get this error message:Attribute(string: UTF-8)          : `_response_body' has value `{"errors":[{"code":400,"message":"A non-empty request body is required.","title":""},{"code":400,"message":"The dto field is required.","title":"dto"}]}'When I try to pass through {“active”: true, “firstName”: “@Value(firstName)”}, I get this error: Attribute(string: UTF-8)          : `_response_body' has value `{"errors":[{"code":400,"message":"The dto field is required.","title":"dto"},{"code":400,"message":"',' is an invalid start of a value. Path: $.active | LineNumber: 1 | BytePositionInLine: 12.","title":

I have a set of line data that I wish to buffer for a client.The requirements of their GIS system are such that the shapes must not be 2D reentrant, lack donut holes, and be OGC Simple + OGC 1.2 compliant.I buffered the lines to .0003 ground units (coordinate system is in degrees)Input feature qty is 9287.The validator only passes 8175 of them.Every failure reported from the listConcatenator is “Fails OGC Compliant,Fails OGC Simple”.Is there something that I’m doing wrong?

Hi there :), I’ve been using RasterConvolver in FME Form 2023.0.1 to calculate the standard deviation with a round kernel, so some weights were equal to 0. The results were always incorrect, so to understand what’s happening I simplified the problem and used a raster with all values = 1 and one weight in kernel (3x3) = 0.From what I understand, the formulas used in RasterConvolver for calculating the weighted mean and weighted SD are a bit off. Here is what I deducted:The weighted mean is divided by a number of values (kernel cells) instead of by the sum of them. The weighted SD: in the sum equ

I’m using Pro 3.2 and Data Interop extension with a simple workspace to pull point features from a SQL server database and publish them as a layer in AGOL, all within AWS on an ec2 instance. I have this scheduled to run every 15 minutes so users get fresh data. The workspace also uses an HTTP call to make the layer editable just before overwriting it, and then a second one after writing, to disable editing, because the layer is public. Seemingly intermittently, the file geodatabase used to publish the layer will not get deleted. I have the fgdb that was originally used to publish the layer still there in the same folder as the layer, but every so often another fgdb will be created and left in that folder too, so I get duplicates. Some mornings I check and there are 3-5 or more of them. I can manually delete them, but I’m trying to determine why they’re not getting deleted in the first place. I’ve checked the logs and can’t see anything out of the ordinary. I tried addi

I have a non-spatial table with about 5 million records of XY coordinates. I need to update the table with the Lat Long values in the so-named columns.I am facing problems with writing these to the table. When I choose UPDATE/UPSERT/fme_db_operation, the writing takes a seconf for every 10 records. It’s impossibly slow.When I choose, Insert with DROP and CREATE or TRUNCATE EXISTING, the script gets stuck with following last 4 lines in the log: Writer `MSSQL_ADO_2' of type `MSSQL_ADO' using group definition keyword `MSSQL_ADO_2_DEF'Microsoft SQL Server Non-Spatial Writer: Opening `GISReporting' for write operationMicrosoft SQL Server Non-Spatial Writer: Read 1 DEF line(s).  Found 9 attribute(s)Microsoft SQL Server Non-Spatial Writer: Trying to connect using Microsoft OLE DB Driver 19 for SQL Server...MSSQL_ADO writer: Splitting bulk features into individual features  NOTE: I have set BULK Read and Write at

Hi everyone ,I have dynamic doors in my dwg AutoCAD file :If I click on the small arrow the door changes direction , and the big arrow changes the size of the door I want to read on fme the default position and size of the door , just like a normal static door. But here is how the DWG Reader reads it :   Any Insight is much appreciated !-Yagami

I have a DWG file with unknown CS but I know the CS it just needs to be assigned to the DWG. When I set the CS when I read the DWG then it appears in the correct location on the Earth but once I try to write it, it doesnt write the CS info and it appears again in the false location on Earth! I also tried “CoordinateSystemSetter” but with no success. On FME it appears good while transforming but not in the resulting DWG. Any Idea?

I have many workbenchs and some of them are quite complicated. I would like to write a description of all the steps. Are the workspace parameters the best place to write the description and the steps?  Thanks :)  

Hi All,Quick question in regards FME & ArcPy: I have been able to create a Python script that overwrites a ‘tree_ID’ field on AGOL based on the sum count of the three geometries (point, line and polygon). Basically the script does the following calculation and assigns the IDs, example below:Point = 3 featuresLine = 2 featuresPolygon = 2 featuresTOTAL = 7 features ID to update on AGOL 1,2,3,4,5,6 and 7The python works fine as the AGOL feature hosted layers have been updated with the new ‘tree_ID’ but the PythonCaller stops with the following error: ‘PythonFactory failed to load python symbol `FeatureProcessor'. An outdated FME packaged transformer may be in use. Please check Tools > FME Options > FME Packages to confirm that all FME Packages are up to date’ 

I’m using the JSON reader to read in a folder of JSON files. The reader is working how I want it to, however I would like to get the original file path/name as an attribute on each feature.  Is there an easy way to do this? I’m hoping that I am missing something silly.   

I tried the FMEFeature.reproject(coordSys) method but it can do only 2D reprojection. I want to do reprojection using Python only not with any transformer like EsriReprojector or CSmap.

I’m having trouble writing dynamically to a SDE feature dataset using the ‘truncate’ option in FME 2023.1. The features are written, but there is no ‘truncating’ taking place before the writing and instead the data doubles up... It works as expected in FME 2021.2.6 however, maybe due to the different way in which the feature dataset is specified in this version under ‘Table Creation Parameters’. How do I make it truncate also in 2023.1 version? Current set up in writer for FME 2023.1: 

Hi All, I’m working on a workflow to collect tree data in the field using Survey123 & Field Maps. The tree surveyors complain about having to manually change the Tree IDs every time they come back from the field. I was thinking that FME could help with this matter by reading the Feature Hosted layers (point, lines and polygons) and use the counter to re-numbering everything.I have the workflow pretty much ready but I want it to achive the following:Read and Overwrite the same Feature Hosted layers by using Feature Holder? I want to avoid creating a new layer with the new IDs. is that achievable?  I only want to overwrite one field (Tree ID) then the rest of the fields stay the same. I was thinking only exposing the Tree ID attribute in the reader?

Hi all,i know it will maybe an easy one….I’ve tried with substringextractor or with AttributeTrimmer as well but i couldnt reach the right result.i have attribute like these for example:he0_wasser_WSG_TK_20143_AGE_f_r01_231030 orni0_geobasisdaten_gemischte_industrie_gewerbe_flaechen_20256_AGE_f_r01_240118i have to split in this case “he0” and “ni0” and write that in an attribute xi have to split “wasser” and “geobasisdaten” and write that in an attribute yi have to split “AGE” in an attribute…….and so onnow comes the challenge:the text between “wasser” or “geobasidaten” and the 5digit number (20143, 20256) has sometimes 2 words, sometimes 3 or 5 words…..but i have to write the whole text in an attribute z….ho can i do that? i am not so well in regexp…..so i ask here for help Thank youCheersFranco  

Hello AllI need your guidance to correct this issue..I have few polygon layers with limited infomation in the layers. I have an excel master sheet with complete details and common field is species name  so , I have used feature joined after some transformation and got all details connected to layer.. Now , The issue is when i have exported it to gdb , everything is blank without geometry and only attributes are visible for polygon layer.. I want to project it to LL84 I have attached workspace template and error screenshot I shall be thankful for suggestion    

Dear FME community,I have a featureklass of lines. I want to find the start and end point of the lines. I used the Snipper transformers, setup as the screen shot below. '0' is the first vertex, '-1' is the ending vertex but the start and  end points which I created , don not lie along the line. I also used coordintateExtractor,, it gave me the same result. I couldn’t figure out what went wrong.I would appreciate any help to solve this problem.

I would like to split a polygon into it’s segments, so that the result is seperate segment-features (lines). Does anybody has an idea for this?

 I have 3 published parameters where the user inputs values for buffers. All three were created as Numeric parameters, with numeric precision set to Integer. I would like to extract the largest buffer value in a python scripted parameter. This is the code I’m using in FME 2023 (build 23332)buffer_list = [FME_MacroValues['BUFFER1'],FME_MacroValues['BUFFER2'],FME_MacroValues['BUFFER3']]buffer_list.sort(reverse = True)return buffer_list[0]What I’ve discovered is that if the 3 buffers are the same number of digits, the script will return the correct value. If the number of digits is different, it will not. Some examples:10, 40, 50 = 50 (correct)120, 60, 70 = 70 (incorrect)120, 180, 70 = 70 (incorrect)120, 200, 300 = 300 (correct)It doesn’t matter which order the values are input, nor does it matter how the parameters are sorted in the pa

Greetings,I’m writing FME workspace that should be able to scan a list of IP Addresses for modems. The result will have reachable:yes/No attribute to determine the IP address is reachable or not.First thing to think of is using python caller to invoke the ping tool of OS. I did it that way and it’s working. However, the client policy demands workflows that are only built-in. No custom coding, and I want to make sure that there is no built-in transformer that may do the task?Is there a built-in transformer that can check if a networked IP Address is reachable or not. Is there one that can be tweaked to do so ?Thank you-Moataz.

Hello everyone,For one year, I’ve been running different workbenches daily (Windows Scheduler), reading from MSSQL tables to write into various hosted feature layers, used in various dashboards. I noticed an unusual consumption of the storage on our GIS server, coming from the “pgdata” folder of Arcgis Entreprise, so the underlying postgresql database (up to 20go additional Gb per month, while the size of all my hosted features stay constant at around 1gb only in total). After several tehnical sessions with ESRI, there is no doubts that this is caused by my FME workflows. Those workbenches are far to be optimised (as I was only starting to use FME) but they are working fine. It was easy to truncate all features to insert new features, sometimes up to 150 000 features daily, for one layer (see below, simplified version). The inserted features are polygons, from the same source hosted feature layer, daily joined with most recent MSSQL data. NB: Objectid is removed with “

Hi!I want to add an attribute to geometry - is this done with the geometrypropertysetter?For instance, add ‘water  asset’ to a cylinder but not as a layer name rather as an data tag / table.I ultimately want to be able to bulk add them however am starting with a simple test case.Thanks.