FME Form

I am working with MongoDB trying to upsert nested MongoDB documents. The JSON format would be something like:{“name”: “XXX”,“tables” : [ {“name”: “XXXX”,“num_rows” : 3423,“fields”: [         {“name”: “XXX”, “type”: “yyyy”} , ….     ]}, ….] I have no problems when I use a JSON string attribute inserting a new document with Document Source”: Json Attribute” and Insert operation.But, I do need to UPDATE existing features.In this case, the nested dcouments (tables in the json above) are created as plain strings.  Which is a real inconvenience in my use-case.{“name”: “XXX”,“tables” : [ “{“name”: “XXXX”,“num_rows” : 3423,“fields”: [         {“name”: “XXX”, “type”: “yyyy”} , ….     ]} “ , ….]Valid datatypes do not currently include arrays (of objects)  Is there any alternative or workarounds?         

Dear, I want to link all the lightposts to the nearby road segment. I used a buffer around the road segments and then Neigborfinder to do this. Now I am afraid that some lightposts are not linked to the roadsegment but I am not eager to increase the buffer or neigborfinder because maybe lightposts that should not be linked will be included. Is there maybe another way to bypass this? Or some tips you could give me?

When I use the aggregator, the IFMELine becomes an IFMEMultiCurve.I don't want the IFMELine to become a IFMEMultiCurve. How can I prevent this?

I want to use the AzureServiceBusConnector to get the messages from the Queue.But if there are no messages in the queue I want to end the FME Job after 1 minute. Is there a way to terminate the process only if the queue is still waiting.If the AzureServiceBus connector reads the expected amount of messages I don't want to get an error, only if it's waiting for nothing.

Hello please I need help. I converted my Autocad Map 3D files to integrate them into my database using the 'Raw relational' mode because my data has multiple tables and one entity with several attributes. Currently, I would like to convert them back into Autocad Map files while preserving the original file structure. I'm stuck because I can't recreate my different tables (Table A and Table B). What should I do?

Hi,I use FME form through ArcGIS Data interoperability workbench and I work with the national Swedish coordinate system 3006 Sweref 99 tm. I cannot display these features with the standard background maps and get: This does not happen in the regular FME Form and they display without problem there. How can I solve this in ArcGIS DI workbench?Is the standard FME Form able to do some kind of on the fly reprojection to view the features on the standard base/background maps? Best regards,Karl

Hello, we have a bunch of workspaces reading in from an SDE, all is fine in 2022 FME but after the upgrade to 2023 we can no longer read features that sit inside a feature dataset using the SDE reader. Features outside a feature dataset are fine. We have just discovered that a FeatureReader transformer will read them so maybe this is a bug in 2023?

I have an error message: ArcGIS Online Feature Service Writer: Encountered an unexpected error. The error code from the server was '400' and the message was: 'Cannot perform operation. Invalid operation parameters.'. Details: ''deletes' parameter is invalid, Input string was not in a correct format.' ARCGISONLINEFEATURES writer: An error has occurred. Check the logfile above for detailsI have checked the log file but honestly I am not sure what I am looking for. Attached is the logfile and my AGOL service format.Thanks

I am trying to use the FilenameExtractor to get the rootname of the source file to match the new filename in a different source directory with a different format i.e. my pipeline is essentiallyMyFileName.xlsx → MyFileName.jsonCurrently if I use the source filename input paramter the behavior is like:MyFileName.xlsx → MyFileName.xlsx.json , which I don’t want.I tried using the FileNameExtractor where _rootname gets set as a user paramet but then the output is like:MyFileName.xlsx → _rootname.json The value of the user parameter does not actually extract the rootname and save its value as the user parameter dynamically. Can anyone help?edit:Scripted Python (safe.com)I used a scripted parameter at the start of the workspace but still curious as to why the filename extractor did not perform as expected?

Installed 2024 Form. Noticed that the mouse-over over transformers, readers/writers are no longer there. You have to click on the item to see the menu associated with the item. The properties cog is no longer on the transformer title, you have to click on the transformer to get to it. This doubles the amount of clicks to get to things. And the “hover” menu doesnt go away. You have to click off. What in the Windows 98 is going on here??????I would like to hear the focus group that said, please hide functionality and make us do more clicks to get to stuff. I normally wait until xxxx.1 to download but I decided to to try it out early. big mistake. huge. Please bring back mouse-over and put the properties cog back on the transformer banner because I did not save a backup on my workbenches 🤡

In FME Flow 2024.0, when PythonCaller hits an Exception it doesn’t specify where the exception occurred -- we only get Message Type: fme::internal::_v0::py::ExceptionPython Exception <IndexError>: list index out of rangePythonCaller (PythonFactory): Group 28 / 20195: PythonFactory failed to process group properly However, there are numerous instances of indexing lists that could be responsible for this!Am I missing something? Is there anything I can do to fix this, or does Safe Software need to fix this? (How do I ask them to fix this, besides posting here?)

Hi,We have an assignment where we are using FME Form 2024 version to convert a DGN file to a GIS format. For us to do it, the design file (DGN) needs to be reprojected and scaled to Web Mercator coordinates. I am not a designer, but a developer and learning about the DGN files as I go. The designers using Bentley’s Micro station tool.Using MicroStation V8 reader, reads the “Name” associated with the coordinate system, which is a free form field and can contain a name that the project designer puts in manually and is not a standard naming conversion.We are trying to read more information from the properties of the coordinate systems like the “Description”, “Affine parameters”.  The description field contains standardized naming that we could use since it is not editable by the project designer. The Affine parameters define the scale factor that will be used to convert from ground to grid coordinates.Need help in identifying how this can be read through the MicroStation reader or any oth

Hi All, I am trying to write attributes to AutoCAD User Properties (within the panel) instead of exposing them using XDLIST Command.  I know how to do so manually in AutoCAD by using ADEDEFDATA Command and FME seems to be able to read these attributes, amend them or even add new ones and Write an AutoCAD File showing these attributes within the User Properties panel. However, it does not seem possible to write a new AutoCAD File with these properties or use a template with this table added to it.  Is this functionality even possible with FME? Have any of you found any alternatives? Many thanks for the time, Ana

Good morning,I am reading a DEM stored as a raster feature class in a gdb, clipping to an AOI and then writing to JPEG to be used in road design software.I can read and clip properly but having trouble writing to JPEG. I have gathered I need to set up bands differently but I have tried the rasterbandinterpretationcoercer and rasterbandadder and rasterinterpretationcoecer in various configurations/settings and can’t seem to get it to write a JPEG. Usual error is about the number or type of bands depending on how I set the coercers etc.DEM raster feature information Any suggestions would be welcome.Thank you so much,Corey

FME(R) 2023.1.1.0 (20230928 - Build 23631 - WIN64)Hello FMEers,I have a set of Esri feature classes that we are supplying to our clients so they can submit data to us using a standard schema. On submission we want to verify they haven’t modified the data structure using the method described here. The method compares two datasets using the SchemaScanner and works well if there is at least one record in each feature type. It doesn’t work if there are no records in one of the datasets to be compared. This is expected because there are simply no features coming out of the ‘template’ feature class reader to work with.My question: is there any way to achieve the intent of the abovementioned article when one of my inputs has no records, only the table definition? The method works fine if I include a dummy record in the ‘template’ feature class, but I’d rather avoid this kludge.Thanks in advance. 

FIs this a bug on FME(R) 2023.1.1.1? I’m using FME(R) 2023.1.1.1. I’m trying to filter some data using Tester and I used IN with a parameter has 2 items both of which are present in my dataset. But the tester filters just 1 record. Why is that? 

At this moment I received a DWG drawing with both Extended and Object data. To convert this data I first have to read with:Autodesk AutoCAD Civil 3Dthen read withAutodesk AutoCAD Map 3D Object Dataand merge all features on the autocad_entity_handle Am I doing something wrong or is this the only way to get both attributes?Is it possible build a transformer that uses both reading engines because I think that would make the reader faster than current.

Hi all,I am trying to show all tables with contents in a database. I have a database with over 800 tables. Some tables are empty, some are not.  Im using this query in a sql client:SELECT SCHEMA_NAME(t.[schema_id]) AS [table_schema]          ,OBJECT_NAME(p.[object_id]) AS [table_name]          ,SUM(p.[rows]) AS [row_count]    FROM [sys].[partitions] p    INNER JOIN [sys].[tables] t ON p.[object_id] = t.[object_id]    WHERE p.[index_id] < 2    GROUP BY p.[object_id]        ,t.[schema_id]    ORDER BY row_count desc  If i am using a Sql Executor with this sql statement i have a return value of more than 300 tables wich is correct. In the preview of the feature window i see more than 300 lines. But i dont see any attributes like a table name or the number of records. Do you know how i can expose these attributes?

I am writing a geopackage file in FME but when I try to use it in ArcGIS Pro I get this error message. Any idea what could be wrong?“Failed to add data ...main.GNG.anlaggningsomrade. Invalid parameter value passed to function[no such table: main.GDB_Items}”FME Workbench 2022.2.2ArcGIS Pro 3.2

This must be very basic but I discover FME and I couldn’t find how to do yet. I would like to find the value from the next row in the table to use in a transformer later.  For example: I would like to fill in the column C with just the informations from the column B. Can I do that in the TextEditor by saying something like “colB” +1 or “colB” NextValue?  

Hello everyone,I am trying to write data into an SQL Database which contains multiple geometries (This is borehole location data containing the originaly measured location (point), a corrected location (point) an a borehole path (linestring)). After creating the geometries from fields and using a GeometryPropertySetter for each of these geometries I am using an Aggregator followed by a MultipleGeometrySetter-Transformer. This is working more or less as in 3 Geometries are in fact written into the database which then also contains 3 fields with SQL geometries as set by the 3 GeometryPropertySetters. But there seems to be a problem. Between setting the individual geometries and aggregation, all info on the previously set projections seems to be lost. Upon inspecting each individual GeometryPropertySetter all points are where they should be. Inspecting the following aggregator shows all points off bounds somewhere. It is my understanding that the aggregator should simply collect the input

I am starting to work with reading and writing OData.  I can see there is an OData reader but no writer. Writing seems to be possible using the HTTP caller.  Is there a particular reason why there is no OData writer? Are there plans for an OData writer? Just want to make sure we are building the process correctly.

Is it possible to change the timestamp information that is included in the log file to UTC? I have been looking for a setting, but have yet to find one. This would be for the log files created in Form/Workbench, which currently log the time as local computer time.

I would like to create 5 cm buffer around 3 Cube without having rounded corners or edges.  Exactly the same as its original with 5cm buffer ?  thank you in advance  

I want to set up an FME workflow which I can reuse for projects, in which input data differs. For this, I want to load different shape files into FME using a parameter (the shapefilename). These shape files have different attribute names, so I wanted to use the schema mapper to map these different attributes.The problem is that I cannot get a dynamic reader to work properly (I used feature merge). When I load in the first shapefile for the first project, the reader sets the user attributes to the attribute names of the first shapefile . If I restart and load in the second shapefile , it won’t expose the attributes from the second shapefile (the attributes from the first shapefile remain!). How can I set up the reader to be able to handle different input schemes and change the exposed attributes dynamically, based on the input files?