- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form

FME Form

A space to discuss FME Form

27668 Posts

liamfezInfluencer

Writing Geometries to an Attribute in MongoDB3

I have a complicated collection of features stored in mongo db, where a given feature may have multiple unique geometries stored as individual arrays. I would like to use the “Put” Operation in the writer to replace specific features. However when I write to mongo I get two different results (see screenshots of dummy feature with just one example geometry).location.coordinates{} attribute type set to stringlocation.coordinates{} attribute type set to doubleThe desired outcome would look like this:Referencing other community posts on related matters:After reviewing those other community posts I think I am going to need an alternative method to what I had started to develop. But I wanted to see if anyone had any ideas or experience with mongo writers to say otherwise.Thanks

362

7 months ago

txalapartaContributor

asked in Data

MongoDB writer with nested documents

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?

362

7 months ago

olivier2Contributor

asked in Authoring

How to connect all the right points while not including the

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?

1065

7 months ago

sshafiqParticipant

asked in Transformers

How to keep only one line when using aggregator

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?

End Stream Transformer after 1 minute

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.

brindaObserver

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?

280

7 months ago

karloz9999Contributor

asked in Transformers

Features do not display EPSG:3006

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

190

7 months ago

jackydContributor

asked in Integration

Connecting to SAP Odata API via SAP Integration Suite

Hi Everyone,We are working on an integration between ArcGIS Utility Network and SAp using FME to connect with SAP via their Odata services and Integration Suite.We have successfully used Get calls from FME desktop to fetch a token and get information about an asset.When we switch using a POST call to create a new asset we get a response error of “HTTP/1.1 403 Forbidden” and response body “CSRF token validation failed”The calls we are using have been successful from postman through integration suite.I have attached the workbench containing the current settings and the latest log file.Any insight i why this would work for GET calls and not for POST calls

2453

7 months ago

brandonguoContributor

asked in Integration

Strange error code

Version: 2024.0.1.0 I am trying to write a new dataset to ArcGIS online, keeps getting this error code: Message Type: fme::internal::_v0::py::ExceptionPython Exception <AttributeError>: 'NoneType' object has no attribute 'get'ARCGISONLINEFEATURES writer: An error has occurred. Check the logfile above for details

3334

7 months ago

afodContributor

asked in Data

Cant access SDE features that are in a 'FeatureDataset' after upgrade to 2023 FME

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?

53010

7 months ago

scottshenbergerContributor

asked in Data

Format error when using ArcGisOnline

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

451

7 months ago

mccuneeContributor

asked in Transformers

FilenameExtractor does not use value

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?

281

7 months ago

tnarladniEnthusiast

asked in Authoring

Hover menu gone and properties button hidden from transformers

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 🤡

393

7 months ago

jonah.millerContributor

asked in Transformers

PythonCaller exception doesn't print line number in 2024.0

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?)

661

7 months ago

lsugumarContributor

asked in Integration

Reading coordinate system properties from a DGN file

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

Writing attributes to AutoCAD User Properties

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

36414

7 months ago

coreyrossContributor

asked in Transformers

DEM Raster Feature class to JPEG

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

532

7 months ago

joaniegeo99Contributor

asked in Transformers

How to use a SchemaScanner on an empty feature type?

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.

492

7 months ago

dpradhan_rvcObserver

asked in Transformers

FIs this a bug on FME(R) 2023.1.1.1?

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?

451

7 months ago

jkr_wrk

asked in Transformers

Reading DWG with 2 transformers

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.

551

7 months ago

smartman63Contributor

asked in Transformers

Show all tables with contents in a db

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?

1543

7 months ago

asablombergContributor

asked in Data

GeoPackage, Failed to add data - no such table main.GDB_Items

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

2543

7 months ago

liseContributor

asked in Data

Finding the value of the next line in the TextEditor

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?

581

7 months ago

pknoContributor

asked in Transformers

Aggregator removing projections?

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

642

7 months ago

eric_armitageContributor

asked in Data

OData writing

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.

421

7 months ago

1
...
55
56
57
58
59
60
61
...
1107

Page 58 / 1107

Badge winners

ryanwillshearhas earned the badge FME Form Basic Training
barkushas earned the badge Welcome Back
anteboy65has earned the badge Welcome Back
tamadurhas earned the badge Welcome Back
buraskyhas earned the badge Integrate Spatial Data

Show all badges

30,366: Posts

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

An FME Account is required to contribute

Login to the community

An FME Account is required to contribute

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

A product of

Company Products Giving Back Careers Contact Privacy Feedback

Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.