Creating and organizing workspaces. How to use Workbench.
Recently active
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
I want to style vector by “Mapbosxtyler” and write to .mvt (Mapbox vector tile).I try to make style for line, point no problem. But with the polygon file, Mapboxstyler , I use checked fill style and stroke style to make it, But they can’t. Could you tell me why? Thank you
Hi I have a very simple question but it seems i can’t do it . I just want to make a point from an excel list with x y coordinates, but not by writing it to a writer because I have to do a lot of other operations with it. I have already tried different things, I first used a coordinateSystemSetter and then a vertexCreator. But during further edits I always get rejected and my model crashes. It can't be that difficult :-)
Good evening at everyone.I have a shapefile of buildings in the reference system Gauss Boaga Italy Monte Mario 1 (EPSG:3003) [1]If I reproject these data in ETRS89 UTM 32N (EPSG:25832) using the proj4 library (with QGIS or PostGIS) and I obtain a very valid result [2], which overlaps with the orthophotos in coming from the WMS. [3]I tried to configure a custom SRID [4] by entering the 7 reprojection parameters used by the proj4 library contained in QGIS or PostGIS [5]I tried to reproject with FME using my custom srid, but the result is very different [6]. Is something wrong with the custom configuration [4] or fme transformer [7]?Thank you!In the zipfile: [1] original.shp[2] reprojected_with_qgis.shp[4] MyCoordSysDefs.fme[6] reprojected_with_fme.shpother references:[3] http://pubblicazioni.provincia.fi.it/geoserver/wms?request=GetCapabilitieslayer=orto2016[5]"+proj=tmerc +lat_0=0 +lon_0=9 +k=0.9996 +x_0=1500000 +y_0=0 +ellps=intl +towgs84=-104.1,-49.1,-9.9,0.971,-2.917,0.714,-11.68 +u
Hi,I have a process that writes out a dgn. Some of the levels in it are required to have their global display turned off and others are on, in the initial state. Basically some levels are hidden on opening a file. I used a feature writer to do this with one stream having their global display set to on and another to off. This worked a treat.Until recently when my company upgraded to 2023(.2.1) from 2022. I haven’t changed anything but now everything writes as turned on even though some is set to be hidden. I did not see that this is a bug that was fixed in future versions from the changelogs.Does anyone have any hints for me how to get this working again please? Or have I lost the functionality now?ThanksJames
Hello, I have a difference in my results and I was wondering if this is a ‘known issue’ and how to resolve it. Goal: Give all the line-objects a “No” when there outside the polygon and a “Yes” when there inside a polygon. FME: I used a SpatialRelator (with the Spatial test: Requestor is Within Supplier option) followed by an Attribute creator which defines the Yes & No. ArcGIS: To check the result I did the same within ArcMap using: Select by location with Within as the selection method. Result ArcMap: Result FME: I do understand that we are comparing apples with oranges, but I got some significant differences as you can see above, were from my point of view: Esri-Map is correct. Since I want to use my FME model, more often, is there a way to solve this problem? Or something I as a start-FME-user forgot to add in my model? Current model: The used Conditional Values: Thanks in advanced for the responses!