FME Form

 

I'm trying to add a esri sde geodatabase reader to a workbench without an sde connection file. I have an example workbench I got from someone else, (but who left the company) with a geodatabase reader where I can just fill in the user credentials and server instance, and then it will read the database.  So in te example above a new connection file is not needed. However, if I try to add a new reader I can only add one when I provide it with a sde connection file. Can someone tell me how to get parameters like in the picture with an esri sde geodatabase reader?

Hi all,  Does anyone know the expected release date of FME Desktop and Server 2022.1?  We are planning our next upgrade from 2021.1 and I want to assign the upgrade to a quarter in our Life Cycle Management planning.  I don't want to risk that the software is not available.  Thanks, Annette

Example. I have 1 linestring going into the object and 1 linestring coming out from the object. Use case 1: I should simply shorten both linestrings so that there will be a buffer around object. So I should shorten linestring 1 from the end and linestring 2 from the start Use case 2: I should cut both linestrings using area and then shorten all 4 a bit next to the area. But how do I know which way the linestrings are and how to shorten specifically from the end or from the start?

We translated a GML file to GDB, Then we get two problem:FeatureColleation layer induced, how to remove itlayer name with geometry, how to remove itThanks

Can I use polyline (.shp file) and convert them to 3d display them with AR(FMEAR) ?

Is there an easy way to remove accents from characters that are contained in an attribute?

Hello all, I am trying to replace a macro in Access that makes a series of SQL queries to update a table used in more processing afterwards. I am pretty new to creating work benches and wanted to get some input as far as how I might construct a workbench to do this and the transformers I would use. I am getting lost in whether I can create a more linear process with transformers in sequential order, or if it will take a different way of thinking to build it that incorporates different pieces at different times. I am more used to ArcGIS Modelbuilder and this is just different enough get me second guessing all ideas.Here are all of the SQL queries the macro executes, in order with a couple of notes I added for clarification: NOTE: I know this part can be done with the truncate option in the writer: DELETE StagingTable.*FROM StagingTable;________ INSERT INTO StagingTable (PIN, MailingTo, FullAddress, CityState, ZipCode)SELECT SourceTable1.PIN, "" AS MailingTo, SourceTable1.StreetAddress A

I have created 3d tileset combining many tilesets. I can see the parent geometry error, but for child tilesets geometry error is missing. How can I add geometry error for child tilesets? Please help me if someone have resolved this kind of issue.

I have a WMTS that works fine in QGIS, but which I can not get to work in FME Desktop (2021.2 and 2022.1). I start the WMTS-reader, use the following address: https://tiles1.geoserve.eu/Mosaics/tieserver/20220531_20220416_SV_RD_8bit_RGBMosaic_50cm_Nederland/wmts and than I get this error: .tmp' exists but could not be opened. File contents may be invalid, or the file format may not be supportedWorker 1780 > Failed to obtain any schemas from reader 'WMTS' from 1 datasets. This may be due to invalid datasets or format accessibility issues due to licensing, dependencies, or module loading. See logfile for more information  Parameter settings are chosen from the layer itself:format: Image/pngTilematrix: GooflemapscompatibleTile resolution: 18 I did try other resolutions. Again: It works fine in Qgis

Getting an error when running a translation from LAS to LAZ format. Could not load module 'C:\\Program Files\\FME\\plugins/LIDAR_FME.dll' : 'The specified module could not be found' Don't think it affects the output. Just wondering if it needs to be fixed? FME(R) 2022.0.0.1 (20220505 - Build 22339 - WIN64

I have a dataset containing 10ish attributes. Most of the fields are empty (if an item has a value in attr1, it has no value in attr2, attr3, attrN, etc), and I want to have a single attribute containing the value of all the others.

Post upgrade of desktop --- should we replace all the reader and writers or are these upgraded to latest version automatically?

I have two geodatabase.I used "AreaOnAreaOverLayer" to have the intersections of features for the one of the geodatabase and then, for the second geodatabase. It creates for both, a field named “Overlaps”.It works correctly. After that, I wanted to join the two geodatabases The two geodatabase overlap but they haven’t the same name so I can’t use « feature joiner » because I haven’t a common field.With the transformer “clipper” I haven’t all fields  (It misses the field “overlaps” of one of the geodatabase)With “AreaOnAreaOverLayer”, “SpatialRelator”, “SpatialFilter” and NeighboorPair” one of the field "overlap" is null That’s why I want a transformer to make a spatial join and not a attribute join with all fields of two geodatabase. Thank you !  

I'm reading and writing dynamically some spatial data and this works as intended, however there is a usecase where if a certain attribute has value 'X' something else needs to be done (different kind of projection). The caveat is that the input isn't consistent on the name. it can be AtributeName, Atribute_Name,attribute_name,... Is it possible that when the user specifies the input data location, the user can also specify which attribute from it's data that contains the correct information? I've tried with a AttributeName parameter in the UI, but this is always linked with the attributes that are present in the initial reader and doesn't refresh to a new gdb if I provide one

Hi. By default we use Property Extractor geometries, but how can this be used if both geometries (part0, part1) have the same name? Thank you

I would like to incrementally download features including attachments (jpg images) using the ArcGIS Portal feature Service Reader. I want to do this by filtering the feature creation date using a tester. This works fine but when I check the option to download the attachments, it takes an enormous amount of time. It's a large datset and I only want to download some of the most recently added data. Is there any way to perform the tester operation first before downloading the attachments?

Instead of logging in and looking at the credits usage on ArcGIS.com daily/weekly, I would like to have a script running finally in the FME server that runs daily or weekly and informs me via a mail that the credits has reached a certain amount. This informs me that additional credits need to be bought.  Does anyone know what would be achievable in FME desktop? How can I retrieve credits information within FME deskstop?

 X1/Y1 is the left bottom corner and X2/Y2 is the right top corder. Cannot find how to do it...? Vertex creator with Add point and LineBuilder just draws a line

Hello My 2 recent posts were related to issues experienced with FME 2022.I was hoping this one would disappear however it still persists using the latest build. It did stop (previous build) some of my critical workflows from functioning properly although the translations were successful. Basically Attribute Manager will highlight some of my values in Red.But the transformer's cog itself isn't red. It seems to affect Arithmetic values or use of functions.  Here's the workflow - Nothing unusualLet's check the Attribute ManagerValues highlighted in Red for no apparent reasons I click on the Attribute Values and they return to "normal" however when you close / re-open the Transformer sane thing happens. Not sure what is going on here.Translation is successful though. ThanksSameer

Writing data to the DGNV8 writer I use a Seed file where the geographic coordinate system is well defined.In addition to the Seed file I defined the coordinate system also in the writer itself, and all data handled in the workbench are going through a reprojecter transformer. The outcome shows the data in the right projection, but it is not reflected in the DGN files properties. What is the right way to get the coordinate system written into the output DGN file?

I'm trying to use the ArcGIS Portal writer to 'update/overwrite records' in a layer. I'm using truncate and insert to remove the records before replacing them. I'm getting this error 'ArcGIS Portal Feature Service Writer: 'addResults' error for a feature in 'BranchTest.DBO.Hospitals_in_NJ'. The error code from the server was '-1' and the message was: '''. When viewing the portal item in Pro after running there are 'records' but all attributes are Null other than the Object ID. If I view the source referenced SDE layer there are no records. Any ideas?

I am working with rasters and want to fill some No Data Value cells with new data using a Raster Convolver (square matrix, with 0 in corners). To do an extent.When I use this, it still creates cells with value 0.0 in the corners where I would still want no data in this corner ; so I could repeat the process if needed (and fill a new gap instead of using a 0 value that will have an effect of values for next iterations).I am asking if there is a way to have this in FME, or to use any self-made matrices to be applied on rasters.ThanksSG

I have Geotiff file and I need to convert in shape file with data I am new in this so I don't know how to Extract fields and attributes from Geotiff + this is the file https://www.nhc.noaa.gov/gis/inundation/inundation.zip

Is there a way to automate map creation in FME for Esri? I've looked through the documentation and can't seem to find anything.