Creating and organizing workspaces. How to use Workbench.
Recently active
Hello forum, I am working on a new API integration. I’ll be using HTTPCaller. The provider has said that their authentication method is ‘bearer token’ However the options in HTTPCaller are Basic, Digest, NTLM, Web Connection, Single Sign-On. Is one of the those options equivalent to bearer token? Thanks,Stuart
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 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
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?
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 🤡
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
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.
Hello Forum. I’ve just run a workspace. It was successful and produced data as expected. No problems there. However it produced two errors never seen before… Is this anything to worry about? They didn’t seem to affect the workspace or outputs. Thanks,Stuart
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
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?
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
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
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.
Hi all,I am working on a script to replicate a set of feature classes from one enterprise geodatabase that we use for transactional editing purposes to another enterprise geodatabase that we use for publication purposes for the organization. This replication script would be scheduled in FME Server to run on a nightly basis.The issue is that the feature classes I plan on replicating have several domains and subtypes applied to them that don’t translate correctly.I’ve been advised to use the ‘Resolve Domains’ functionality and change the configuration from ‘coded domain’ type to ‘char’.My test workflow involves the below:Copying the feature class via the ‘Import Feature Class’ tool in ArcGIS Pro into the target Enterprise Geodatabase to have the feature class available in both geodatabases With FME:Selecting the ‘Resolve Domains’ checkbox in the Writer at the outset, and using the ‘Insert’ and ‘Truncate Existing’In the Writer configuration, changing the ‘coded domain’ type to ‘char’ and
Hello FME community,I would like to write the values of a list into a column. I would separate them with a minus. It may be that the list of a data set has 1 or 2 or three values.If a list of a data record has no value, no minus was written to separate it. I am attaching 2 pictures to understand it better.
Hello Forum, I have an externally supplied dataset which includes a street name. Some of the street name entries are all in lower case (e.g.: royal road) where it should be Royal Road. However some entries are fine.This is part of a larger regular data process, so I’d like to build in a process that fixes street names to proper upper/lower case (e.g.: royal road would become Royal Road). Is this possible in FME Form? Thanks,Stuart
Hi Community, I am facing a similar issues as outlined in the following link : However, I am unable to extract the data from the database. I guess am missing something in the JSON query parameter of the JSON Fragmenter transformer. Attached are the screenshots Am very new to FME so it’s possible that I might be missing something basic. Any suggestions on how to overcome this would be helpful.
I want to allow selection of multiple records from database in user parameters.For example, I have records a,b,c etc in a list and I want to select records a and b to be used in FME workflow. How can I allow user to choose records a and b?
Hello AllI am currently modifying a workbench to chop pavement polygons based on the street id and then dissolve them back together, again based on the street id.I have used a neighbour finder to get the nearest street and merged those attribute together with the chopped pavement line. This all looks good as can be seen below, where each road (from a feature color setter) for visualisation is correct.Output from Neighbour FinderHowever, when i try and put these lines through the line on area overlayer to chop the pavement polygons up, different street id’s are being added to each polygon, hence i can not then disolve them back again.Output from Line on Area OverlayerPArt of the workbench below - not tidied up yet ..sorryWorkbenchParameter setting for line on area overlayer belowLine on Area Overlayer ParametersAny help on what is wrong would be appreciated.Thanks in advance.
Hello,I recently updated from FME 21 to FME 23. In the old version the relative link worked fine. In the newer version it creates now an extra folde.Example:C:/temp would be replaced with the macroIn 21: c:/temp/thefileiwanttocreateIn 23: c:/temp/temp/thefileiwanttocreateHow can I prevent FME from creating this extra folder?Thx
Hello,Why attribute types in AttributeManager transformer and in FeatureWriter are different?For instance, integer in AttributeManager has int16,int32, int63, while in FeatureManager int2, int4 and int8?In general, those lists are different. Could you please explain? Thanks!
From the FME Documentation about the INSPIRE GML Reader/Writer I read that "FME supports themes up to and including v4.0.". I tried to validate my FME INSPIRE GML output (for theme PS) with the INPIRE Reference Validator, but the test fails. On the support platform it is noted that the test that fails, "Validation against INSPIRE official schema", tests against the new version 5 of the schema. They recommend generating the GML according to the new version 5 of the GML. Can FME already do that, or do I have to wait for a new version of the INSPIRE GML writer?
Hello,Could you advice, please, what transformers to use for my task? This might be easy task, but I am stuck. :( What I have: generic reader with the dataset in any of these formats SHP, TAB, KML or CSV.I need to define: if there is no geometry, WKT or SRID then set corresponding attributes to NULL If there is binary geometry then put the geometry to the attribute YY If there is WKT then add WKT value to the attribute UU if there is also a SRID in the file put that in ...How to check if my data has "no geometry", binary geometry, WKT and SRID and set conditions?Appreciate your help. Thank you in advance.
I created a few polygons with topologybuilder and now i need to explode them in order to test some line on line with another feature.ive tried chopper which works greate except the fact that converts the arc in polygons to line and ruins everything. so how do i split these close polygons back to lines and arcs?ivre tried GeometryPartExtractor to filder out arc but the results are arcs and rest of the polygon insted of being a polyline without that part it convert it in cloed polygon
I have encountered a strange issue with FME web connections via OAuth2 which does not seem to be resolved yet.On one of our company’s networks physical Windows 10 PC, there are three versions of FME Desktop / FME Flow installed in parallel (we need these to cater to our different customer’s needs). When I routinely tried to check and update an FME workspace, I ran into the problem that authentication with an OAuth 2 Web connection (via Microsoft 365 account) did not work anymore. At first, the web connection window took more than 40 (!) seconds to appear with the logos sometimes not even fully appearing. When I entered my credentials, it takes another 20 seconds and then gives me an error not to have found it. The credentials are tested and correct. There are no proxy connections.Resetting FME Options has not worked, and neither has setting up the web connection completely from anew.Tests on a different machine within the same network (but on my Windows user) could not replicate the pr