• EN

FME Form

A space to discuss FME Form

26624 Posts

liamfez
Supporter
liamfezSupporter
asked in Authoring

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

2
txalaparta
Contributor
17 days ago
txalaparta
Contributor
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?         

2
liamfez
Supporter
17 days ago
jkr_wrk
Influencer
jkr_wrkInfluencer
asked in Integration

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.

8
jkr_wrk
Influencer
17 days ago
brinda
Observer
brindaObserver
asked in Integration

autocad map 3d

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?

0
brinda
Observer
17 days ago
karloz9999
Contributor
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

0
karloz9999
Contributor
17 days ago
jackyd
Contributor
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

3
jackyd
Contributor
17 days ago
jeroenpeters
Contributor
jeroenpetersContributor
asked in Authoring

FME 2024.0 Prompt button

A small follow-up question, the prompt button on the toolbar has vanished for me since FME 2024.0. It also disappeared from the Toolbar options. Same goes for the Stop at breakpoint button.Any ideas how to get it back?

6
crystalatsafe
Safer
18 days ago
brandonguo
Contributor
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 

4
brandonguo
Contributor
18 days ago
afod
Contributor
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?

10
rahulsharma
Safer
18 days ago
scottshenberger
Contributor
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

1
kailinatsafe
Safer
18 days ago
mccunee
Participant
mccuneeParticipant
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?

1
hkingsbury
Celebrity
18 days ago
tnarladni
Contributor
tnarladniContributor
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 🤡

3
tnarladni
Contributor
18 days ago
jonah.miller
Contributor
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?)

1
danilo_fme
Evangelist
18 days ago
lsugumar
Contributor
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

2
lsugumar
Contributor
18 days ago
anamanvil
anamanvil
asked in Authoring

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

14
hannahwh05
Contributor
18 days ago
coreyross
Participant
coreyrossParticipant
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

2
coreyross
Participant
18 days ago
joaniegeo99
Contributor
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. 

2
joaniegeo99
Contributor
19 days ago
dpradhan_rvc
Observer
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? 

1
crystalatsafe
Safer
19 days ago
jkr_wrk
Influencer
jkr_wrkInfluencer
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.

1
AliAtSafe
Safer
19 days ago
asablomberg
Contributor
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

3
asablomberg
Contributor
19 days ago
lise
Contributor
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?  

1
nielsgerrits
Celebrity
19 days ago
pkno
Contributor
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

2
pkno
Contributor
19 days ago
liamfez
Supporter
liamfezSupporter
asked in Authoring

LogFile Timestamp Format

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.

2
liamfez
Supporter
20 days ago
vimva679
Supporter
vimva679Supporter
asked in Transformers

BUFFER 3D object without Rounding OFF corners ?

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  

1
hkingsbury
Celebrity
20 days ago
mferwerda3
Contributor
mferwerda3Contributor
asked in Authoring

Clipping raster- skipping cells on Inside port

I am clipping a raster by a polygon, but it sometimes seems to skip parts, I have the clipper set to Candidates on clipper boundary set to Output as Inside.  I know this poly crosses 4 cells, so this is what I was thinking would come out of the clipper Inside port  But instead I get this Any thoughts why it is skipping that one cell?  This is a single band raster and all these cells have data 

1
AliAtSafe
Safer
20 days ago

Badge winners

  • Student (Grey)
    yaxihas earned the badge Student (Grey)
  • English Speaker
    fogaveshas earned the badge English Speaker
  • Teacher (Grey)
    grattophas earned the badge Teacher (Grey)
  • Student (Grey)
    smithgkhas earned the badge Student (Grey)
  • Teacher (Grey)
    smithgkhas earned the badge Teacher (Grey)
Show all badges
28,869
Posts
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.