FME Form

I’m trying to use FME to split out any “Complex” or “Multi-Part” annotations that exist in the dataset and have the “Complex” or “Multi-Part” deleted and insert the split records as new annotations.On my FeatureReader, I have both "Split Complex Annotations" and "Split Multi-Part Annotations" enabled and I am able to delete the old records and insert the new records. However, I’m running into an issue with the geometry of the newly inserted records.From another post it looks like FME splits complex annotations tries to preserve the location of the text but loses other text placement characteristics like the original complex text geometry (lines) and converts them to a point for each split text item.'Split Complex Annotations' when reading ArcGIS geodatabase annotationsIs there a way to create or preserve the complex text geometry for these split records? The converted points seem to be causing an issue in a downstream program with the following error:Error from downstream program: “Err

I need to extract TAB or Shape file from S3 and read data from it including schema.I have discovered in this articlehttps://community.safe.com/data-7/how-to-extract-the-actual-shapefile-from-featurereader-geometry-and-attributes-14548?tid=14548&fid=7that FeatureReader apparently can’t read all attributes that are in the file, until I expose them. But what is I don’t know the list of all attributes? I don’t know what exactly will be uploaded by other people to S3 bucket, I just need to read the file.  Could you help, please, to identify the correct settings of FeatureReader or another way to extract data?

Hi, I am trying to make a simple WS (with only one transformer) to change the schema! Translation runs successfully but I dont see the final gdb . The error on the Inspector is showing that "failed to specify the feature index as constraints on the reader". What should I add and where? Both my reader and writer are File Geodb Open API.

In the JSON transformer documentation, there is a sub-section on JSON Query, which states: JSON Property ExpressionsA property expression is a structure expression as described above, followed by a . (dot) operator and a property name. Currently, the only supported properties are type and size. The type property returns the type of the JSON value referred to by the JSON structure expression. For example, if the outermost JSON element is an array, and the first element of the array is a string, then the expression json[0].type would have a value of string. The size property, which can only be applied to an array, returns the number of elements in the array. For the life of me, I cannot find any other documentation on this and am unable to get it working. I tried a similar example to the one described above ("columns" is an array) but I get the following error: The JSON query 'json["columns"].size' cannot be used to produce features. String expressions and pro

We have not been successful in setting up a web connection for our GCP environment.  Therefore, we use JSON key files.Has worked just fine via a PythonCaller to read the file and fill in GOOGLE_APPLICATION_CREDENTIALS.  If we had a need to write to a different GCP project we would change the project_id in the JSON file.However, we were contacted by billing recently saying that since we use the project in our JSON file that another area was getting billed instead of our ETL project.We tried to fully qualify using the project id and then the schema in the writer, but that did not work.  It always assumes that you are writing to the project in the JSON file.Is there a way around this issue?

I’m attempting to access an AWS marketplace free resource, NOAA’s bathymetry, but with Anonymous access if I enter us-east-1 as the region I cannot manually specify noaa-bathymetry-pds as the bucket and I cannot get a picker, or not that I can see.  Is there a trick?  Thanks.

Hi there,I have an Ascii grid file.The FME can read the file I have also added a Raster Cell Coercer transformer to create a shafile this simple workbench works fine. Issue - How the raster values can be displayed in the shapefile. The shapefile has no attribute data (cell values).I need to display the raster values in the shapefile. Any hints will be greatly appreciated.Thank you very much,Sebastian Algardi-CamusWorkbench Raster image 

Hi, as a newbie in FME, I am using a FME ISO8211 reader to expose some of the attributes for further transformers. However, if all records have to be read, a message “Message #706501 is not present in the message file: Parameters are >< and FME HOME is >C:\Program Files\FME\<” was prompted and the whole process was halted. The FME version I am using is FME2018. Thank you for the kind response!

I have an asbuilt with a table that has all the locations/names of  the structures.   The table layer name  is “text” and when i bring in  the drawing, the text layer is empty. Im sure its how i have my parameters set up so a little guidance on how to read this would be great. 

I am trying to upload ifc data through PostGIS Writer and while doing so, I want to generate and store the time of upload as well. However, it gives the following error: “Value of attribute 'begin_lifespan_version' could not be converted to type 'timestamptz'. Feature will be logged and skipped.” can someone help? I am a beginner in FME as well.  

Hi all, Since upgrading to FME 2021, I have found previous workspaces that were working in 2020 are now not working. This appears to be when multiple datasets are referenced in a WorkspaceRunner and through a user parameter. It concatenates the filepaths together and loses the double quotes and separation, causing the reader to fail. Any help would be appreciated. Kind regards,Jack  

Morning, I am trying to transpose some data from a survey, I want to sort of Pair up the Postcode and the Question Number, then have columns of Responses with counts. Ive attached images  and a fme workbench of the original data and the output I want. I have 36 questions, so want to know if there is a way to do this using a list? So I dont have to repeat this 36 times, I am not understanding how to do lists!I want to output the postcode as a column, then have a question number column. So each postcode will be repeated depending on the number of questions e.g.Question No    PostcodeQuestion 1      M19 4NYQuestion 2     M19 4NYQuestion 1      M4 7ATQuestion 2     M4 7AT Then I want the next columns to be counts of the answersQuestion No    Postcode  Strongly Agree      Agree      Neither    Disagree     Strongly DisagreeQuestion 1      M19 4NY             2                         3               1               0                      2Question 2     M19 4NY             5               

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

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

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

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 🤡