- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Search

Recently active posts

498 Posts

Recently active

Most views Most replies

missp29Contributor

asked in Transformers

REST API call from FME HTTPCaller gives an error of "HTTP/2 400" but from Postman it works fine

Hi All, I have FME Form 2023.2.I am trying to make a REST API call using HTTPCaller. I got this error below,{ "code": "data_validation_error", "message": "Invalid request values. Unexpected character ('_' (code 95)): expected a valid value (number, String, array, object, 'true', 'false' or 'null')", "status": 400, "traceId": "240425163408767-2c15ec9a"}However, the same request works just fine on Postman. Not sure what exactly the error means here. Can anyone help me on this?Here is the HTTPCaller screenshot.Here is the request body, Here is the error messages from the Translation log.##########...UpdateRecordCustomTablesHTTPCaller (HTTPFactory): An error occurred while accessing the URL 'https://apis.accela.com/v4/records/PINELLAS-24CAP-00000-0004H/customTables'The below feature caused the translation to be terminatedStoring feature(s) to FME feature store file `C:\FME\Funeral Home\FuneralHomeBillingInterfacefmw_log.ffs'++++++++++++++++++++++++++++++++++++++++++++++++++++++

dustinInfluencer

posted in Authoring

Best practice for SQL geometry edits

Would like to hear the opinions of the collective on best practices for writing features back to a SQL database. Specifically Intergraph SQL in my case, but I guess this could apply to many formats.I have a table with millions of linear features that need to go through a LineCombiner process before being written back to the same database. The big question….what is the best methodology for deleting the old geometry and inserting the new? Two methods I’ve used in the past, each with their own downsides.• SQLExecutor/DatabaseDeleter based on the unique ID. Main concern with this is if the translation fails after the Delete but before the writing of new features, those features are gone.• Let the writer do a DELETE/INSERT (fme_db_operation). To me this is safer, but can take twice as long due to number of transactions.I can’t simply truncate the table because we are sometimes only reading a subset of the features in a specific AOI within the database. Truncating would also delete the

n.dContributor

asked in Transformers

Copy an object on specific points

Hi everyone, I have an object like the one in the screenshot which is read from an IFC file. And I have some 3D points in a GeoJSON file. I want to copy the object on each point coming from my GeoJSON file.And also, I want to rotate them in their place. What can be the optimum solution?Thanks!

helmoetzContributor

Postgis varchar() interpreted by FME as varchar(80)

Hi, I have this dynamic setup where a postgres FeatureReader reads the schema and the results are written to another database using this schema information to create the new tables. However, a table having colums of type unqualified varchar will be regenerated with varchar(80) and if records are loaded having length >80 the workspace will crash, saying: Error was 'ERROR: value too long for type character varying(80)I attached the workspace. Is this a bug in FME or am I doing something unbelieveable silly?😕 I'm using FME(R) 2020.2.3.0 (20210129 - Build 20820 - WIN64) on a postgres 12.9 (Ubuntu 12.9-1.pgdg18.04+1).

yagami9Contributor

asked in Transformers

Creating straight lines from randomely curved lines

I created this line from a set of (X;Y) values of points : I’m trying to turn the lines straight and then buffer them to have a result like this: Is that even possible ? i tried using Bufferer directly then Generalizer , but the result is not good : Any Insight is much appreciated !

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

anteboy65Participant

asked in Transformers

PointOnPointOverlayer stores duplicates in list, how to read from Pythoncaller?

Problem in short:I have a lot of points which some has identical coordinates. PointOnPointOverlayer does this for me and store the “twins” in a list name. Now I want to use a Pythoncaller to loop through the list of each feature and figure out if some or none of the twin attributes has a value that should update the the major feature. The problem is that I cant seem to reach the list variable created in PointOnPointOverlayer from the Pythoncaller. It seems to be exposed when running with feature cache and checking output from PointOnPointOverlayer. What’s the magic for reading the list, looping throug it and check the attribute values? Tried this example code from the PythonCaller just to see if I could reach the list but can’t see anything:

arthyContributor

asked in Authoring

Visibility analysis with DEM

I would like to perform a visbility analysis as I’m used to with the esri’s fonction arcpy.sa.Visibility.I tried to build something and after goglling, I read this excellent post which is not working for me because I’m currently bound with FME 2021.2 and the script of this post uses a newer version.Is there a way to perform a visbility analysis with FME 2021?Currently it looks like the clipper is not able to work on TIN surface.Any ideas?

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

mariasContributor

asked in Transformers

Does ISO format in TimeStamper is in UTC format?

Hi,In case I select ISO format in TimeStamper, does it assume that it is UTC or not nesessarily?How to set it to UTC?

sunsilk11Contributor

asked in Automation

Error running JobHistoryStatisticsGathering

Hi I am getting error message below when running JobHistoryStatisticsGathering in FME Flow. I am using FME Flow 2021If I download the workspace and run it in FME Form, it works OK.Any ideas? 2024-4-26 15:55:20 | JobHistoryReader_TestFilter (TestFactory): Feature specification `TEST_GROUP' in mapping file row `FACTORY_DEF {*} TestFactory FACTORY_NAME { JobHistoryReader_TestFilter } INPUT FEATURE_TYPE JobHistoryReader_TestFilter_INPUTLINE TEST_GROUP TEST { @EvaluateExpression(FDIV,STRING_ENCODED,<at>Value<openparen>timeFinished<closeparen>,JobHistoryReader_TestFilter) CONTAINS_REGEX <backslash>d-<backslash>d<backslash>d:<backslash>d<backslash>d ENCODED } TEST { @EvaluateExpression(FDIV,STRING_ENCODED,<at>Value<openparen>timeFinished<closeparen>,JobHistoryReader_TestFilter) CONTAINS_REGEX <backslash>d<backslash>+<backslash>d<backslash>d:<backslash>d<backslash>d ENCODED } BOOLEAN_OPERATOR

benichollsParticipant

Parse JSON from Bentley OpenGround

I would like to be able to parse a response from the Bentley OpenGround REST API, and am getting somewhere but not far enough!I can use a mixture of attribute exposer and JSONFragmenter to get some information out, but it never quite looks like the table i want. i will be doing multiple queries over the coming months into this api, and will have a different number of columns each time, so cant parse through each data record based on the number of columns i want in that particular query! I can get to the point where i have a feature for every feature in the database, and then i have a _response_body which i need to parse further. i can keep parsing it through jsonfragmenter, and i end up with a jumbled mess where columns are names wrong and the colunn information i want is in the wrong part of the table. it is a simple structure, such as “DataFields” “heade” for column name and “value” for data itself. i will add some screenshots to aid in query. any help would be greatly appreciated!Th

pknoParticipant

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

redgeographicsInfluencer

asked in Authoring

Importing database connections in FME on Linux, no gui

One of my clients is using FME on Linux with only the command line interface and is having some trouble importing database connections. Specifically: they don’t know how to do it on the command line.I can’t find much in the way of documentation for this. I suspect that if it is at all possible it may be through the APPLY_SETTINGS command, but other than that I can see that that exists, I can’t find any indication anywhere on what those settings may be and how to set them.Any clues? Anybody with an old manual somewhere? I do have old installation cd’s and dvd’s going back to FME 2005, but I don’t think I have a computer with a cd or dvd drive anymore 😅 Hoping one of the other long-time users has something stashed away...

stuarmitagehomeContributor

asked in Authoring

How do I write to csv file, naming the file using the value of the first row?

How do I write a csv file and name it using the value in the top / first row?I want just one file to be created, (not multiple files like fanout creates) named after the entry in the first row.For example in the table here I have 9 rows and 2 columns. I want to create a csv of all of this data but named “20231207.csv” As a secondary question, you will see the first attribute column is sorted into date order. If this wasn’t sorted into order, what is the quickest way of identifying the closest date to the current date, and then using that identified value to name the csv file?Hopefully this is something really simple!Thanks in advance.Stu

hlynurContributor

asked in Authoring

WKB not becoming a Geometry

Hello yet again 😅I’m GET-calling a an online database through HTTPCaller which responds with giving me a feature in WKB code (in _response_body), then I run the respective code through GeometryReplacer and tried different WKB Encodings in attempts to get a geometry out of it (this should be a polygon), but no luck.The following encodings give me this:Hex Encoded FME Binary: Rejected (INVALID_PARAMETER_GEOMETRY_SOURCE) OGC Well Known Binary: Rejected (INVALID_PARAMETER_GEOMETRY_SOURCE) Hex Encoded OGC Well Known Binary: Ends up in Output and thus not in the rejected port but it does not create any geometry feature that can be inspected.The code is following, so if anyone has seen this before or is enthusiastic to figure this out with me then feel free to investigate:0010300002084080000010000000E000000931E86C64699244192E9D0891B741D41DBF97EF242992441C3F0110102741D41F4A963551A99244180F3E2341E741D41F4531C970F9924415EBBB401E0731D41AED4B380CF982441BF9A03840B741D41001E5119CB982441BB0A294FED73

jkr_wrkEnthusiast

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.

palhermansContributor

FME2024.0 "Esri ArcGIS Layer" Reader failes when LYRX from ArcGIS Pro includes Group Layers

Hi. reading LYRX (“layer files”) from ArcGIS Pro failes when the layer file include Grouped Layers. It works just fine if the LYRX file does not include Group Layers.Thea Layer File/LYRX is made with ArcGIS Pro 3.2.2 where the LYRX file is in JSON format.

antoineContributor

FME Data Express : Add more sensors ( compass, accelerometer...)New

Add more sensors ( compass, accelerometer...)

pauldContributor

Looping through string to remove known text

Hi.I have another string replacer question.I have a file of text strings (appellation) similar to LOT 1/2 DP 17528 LOT 1/2 DP 13552 RS 16932 18812 19986/7 PT 18813 20862 BLK IV KAPUNATIKI SDI have split the LOT 1/2 DP 17528 & LOT 1/2 DP 13552 into 4 separate rowsTemp, _result, appellationLOT 1/2 DP 17528, LOT 1 DP 17528, appellationLOT 1/2 DP 17528, LOT 2 DP 17528, appellationLOT 1/2 DP 13552, LOT 1 DP 13552, appellationLOT 1/2 DP 13552, LOT 2 DP 13552, appellation What I want to be able to do is remove the temp part from appellation The resultant appellation in this example would be: RS 16932 18812 19986/7 PT 18813 20862 BLK IV KAPUNATIKI SDI have tried doing this but only ended up removing one part from each instead of both Temp parts. I would be very grateful for any help with this.Regards, Paul

hawaiialexContributor

asked in Integration

Translating attributes from a system of record into feature class in geodatabase

Hi folks,I had a question regarding creating an FME script that takes attributes from a system of record dataset into an existing record created in a feature class within an Enterprise Geodatabase.Workflow consists of the following:Two layers with the same information and attributes in different systems of record – one in an asset management system and feature class in an Enterprise Geodatabase.No integration exists between the two systems yet as there is a new replacement system being developed in a project, but in the intermediary, it has been decided that the business will be updating the asset in the asset management system, then updating the feature class attribute table in the Enterprise Geodatabase. Therefore, they will be maintaining two datasets in tandem until the pilot project for the replacement system is complete.The difference is that the layer in the asset management system only stores XY/Lat/Long values whereas the true layer in the feature class in the Enterprise Geoda

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

rustyContributor

asked in Authoring

FME Form 2023 start page

Wondering if anyone can tell me how to clean up the recent files list on the fme form start page,Any clues appreciated, I have a long list of old files I was sorting out, now would like to clean up the recent files list on the start page.

lancecContributor

asked in Automation

FME Server Error Submitting the Job "Could not acquire valid job queue"

Pretty much just as the error says:“There was an error submitting the job. COM.safe.fmeserver.api.FMEServerException: Job submission failed. Could not acquire valid job queue.”This displays immediately after pressing run in the workspace runner on FME Server 2021.2.5.I’m not sure where to start investigating and thought maybe someone could point me in the general direction.

asked in Transformers

Where are the dashboard workspaces? statusMessage File Dashboards/JobHistoryStatisticsGathering/JobHistoryStatisticsGathering.fmw could not be opened

When I try and run the dashboard workspaces they fail with statusMessage File Dashboards/JobHistoryStatisticsGathering/JobHistoryStatisticsGathering.fmw could not be openedWhen I look around the FME Server files I cant find any of the dashboard workspaces. Where did they go? Where can I get them?

1
2
3
4
...
20

Page 1 / 20

Badge winners

nordpilhas earned the badge Enchanted by Attributes
nordpilhas earned the badge I Treasure Lists
tvahas earned the badge Teacher (Bronze)
tvahas earned the badge Teacher (Grey)
anteboy65has earned the badge Student (Grey)

Show all badges

28,731: Posts

Powered by Gainsight

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

An FME Account is required to contribute

Login

Login to the community

An FME Account is required to contribute

Login

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

Username or e-mail

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.

OK

This file cannot be downloaded

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

OK

A product of

Company Products Giving Back Careers Contact 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.