General

Normally the MSWordStyler works in sequential order. But in my case the transformer works in a different order and I have a table that doesn't seem to take the style that is defined in the MSWordStyler .

HiBeen struggling with this for the last hours now and I cant get it to work with gpkg, with shp it works fine. But this file i need to download is gpkg. The data is open road data and the zip is around 2.7Gb big. This is the error I getOGCGEOPACKAGE reader: Dataset 'C:\\FME_TEMP\\wbrun_1694624249590_18024\\fmetmp_0\\1694627133694_13812_d\\tor050\\http_download_1694627134354_13812.zip.gpkg' requires file extension '.gpkg'. Using dataset 'C:\\FME_TEMP\\wbrun_1694624249590_18024\\fmetmp_0\\1694627133694_13812_d\\tor050\\http_download_1694627134354_13812.zip.gpkg.gpkg'OGCGEOPACKAGE reader: C:\\FME_TEMP\\wbrun_1694624249590_18024\\fmetmp_0\\1694627133694_13812_d\\tor050\\http_download_1694627134354_13812.zip.gpkg: No such file or directoryOGCGEOPACKAGE reader: Failed to open the dataset 'C:\\FME_TEMP\\wbrun_1694624249590_18024\\fmetmp_0\\1694627133694_13812_d\\tor050\\http_download_1694627134354_13812.zip.gpkg'. Please ensure source data is valid and correct

Hi,New to FME and creating a workbench converting CAD to GIS. I am trying to get the structure fields to match and eventually join them after more clean up. Id like the structures field to be abbreviated. I was thinking Attribute manager could do this. but when I use conditional formatting I loose the "-#". another thought would be to add an alias? but again I am not too sure of a solution. Thanks!

I'd like to calculate the total sum of points associated with different asset IDs that fall within a specific polygon. My desired output should resemble the table provided below.

I have two separate files, one containing GIS pipe data, and the other with pipes exported from a model. Both of these files have lines, and I want to identify the GIS lines that overlap spatially with the modelled links. I've attempted to convert the GIS lines into polygons and then check if the modelled pipes fall within these buffered polygons. However, I've tried transformers like LineOnAreaOverlay, SpatialRelator, and more, but none of them seem to be working for me. Can anyone assist me with this issue? I eventually need to compare the diameters between both files and it would also be good if can merge attributes from both files

I want to upload several pdf maps to AGOL, which I am downloading from Sharepoint. How can I upload over 20 pdfs on AGOL using ArcGISOnline Connector transformer?

I have two GDB Feature Classes: street centerlines (polylines), and cross streets (points). The values in the cross streets field are, for example, in this format "A St/Elm St/Fern Ave". These are all the cross streets at each intersection. ​I am using the PointOnLineOverlayer to join the points at each end of the line. There is one point at each end of each line. I have unchecked Merge Attributes. I have checked Generate List On Output Line.  I checked and all points are snapped to each end of the line.  I have increased the Point Tolerance in the PointOnLineOverlayer in increments up to 50 and there is no change to the output. ​I created 2 Lists, PT(0)_CROSS_ST_NAMES and PT(1)_CROSS_ST_NAMES. PT(0) captures the cross streets (a single point) at one end of the line, PT(1) captures the cross streets (a single point) at the other end of the line. ​When I run the transformer in some situations it duplicates the line and places the cross streets that should be in PT(1)_CROSS_ST_

When using the "Select file from Web > Browse Amazon S3" option as the source for a reader, is there anyway to pass parameters in to the dialog?I have some FME Flow/Server workspaces that are called with the bucket name and path as parameters, I'd like to be able to use those parameters instead of hard-coding the bucket and path. Currently we use the S3Connector with parameters to download the files to local temp and then a FeatureReader to read them, but it would be nice to read them directly. Thanks,Andy

Has anyone run into CTRL+V not working in 2022.1? Seems to be okay within transformers but I can't use a shortcut to copy and paste a transformer itself. What's weird is if I use CTRL+C, the paste icon above correctly pastes the transformer. Just can't use the CTRL+V shortcut. Worked without issue in 2021.

Hello, does someone please knows how i can do if I want to detect the point with min Z value in a PoinCloud and calculate the distance ( along the Z Axis ) to the closest point ? Thank you

Hello Forum, I’ve read in a points dataset (properties) and a estates dataset (polygons). I need to do two things: 1)add an area calculation in a new field to the estates polys. This has been achieved with an AreaCalculator. 2) add a count of the amount of properties (points) falling within each estate polygon using an PointOnAreaOverlayer.  See workspace image attached. I’m finding that the output is counting some estates (polys) two or three times. However when looking at the source data these features are there only once, which is correct. See Inspectors image attached. I’ve played around with GroupProcessing and some other settings, but couldn’t get it right. Can you advise, please. Thanks,Stuart  

How can I efficiently integrate the results from a previous transformer into a tester, especially when the results may vary with each analysis, without the need for manual updates every time?

We are seeing an intermittent issues with connecting to database from FME workbenches ( That runs on FME server ) though the database is healthy FME Server 2021.2.6Build 21821 - win64 The error message is "Could not open the Enterprise Geodatabase. The error number from ArcObjects is: '-2147216072'. The error message from ArcObjects is: {Underlying DBMS error[HY109:[Microsoft][ODBC Driver 17 for SQL Server]Invalid cursor position No extended error.]}" Any ideas on how to investigate this further ?? Thanks

SystemCaller command 'query user' works perfectly well on Windows CMD command prompt but throw an error on workbench:SystemCaller: Failed to Execute `query user'There is something wrong with my syntax or this is just a bug?I am running FME 2022.1 by the way.

I’ve got an interesting problem with a land (polygon) and matching coastline (polyline) data. For cartographic styling reasons (using offsets), it’s important that the coastline is always traversing with the land on a consistent side (say, on the right). Where it’s not, I’d like to reverse the polyline coordinates. Fortunately, the polylines are simple with only one segment, i.e. not multipolyline. Logically, I could buffer each section of coastline on one side (or offset the polyline) and detect a material overlap with the land. If no overlap, reverse the polyline. Has anyone done anything like this before or have any suggestions on the best way to implement it in Form? Many thanks. /Warren

Hello ,i Would like to create a connection between FME and Microsoft azure storage .i am looking for a method without using account name and key .I would like to use only token Generation rest api and avoid using account name and key .but I did not find a good documentation to create the connection .could someone explain the method ,if it is possible ?FME 2021

I wonder if it is possible to fill in the properties of an image when uploading this with the SharePointOnlineConnector.I tried setting up an AttributeCreator setting "Inspection Title" etc. but it didn't do anything with the created attributes.

I'm using FME Desktop (2022.1.3.0) to run an AreaonAreaOverlayer on two very large Geopackage files. It's been running for 4 days and currently on "Preparing spatial indices for intersection phase# 2... 11.91% done". My PC has 128Gb of RAM and 40% of that is free, yet FME is only using 7Gb and thrashing my pagefile.sys. Does anyone know how I can force FME to use more physical RAM please? ThanksRob 

I am unable to connect to my organizations enterprise portal.  I have a web service connection that works for other members of my organization, but whenever I attempt to connect I get the error: "Type: 4, Number: 1, Message: Failed to get authorization query string." I have tried everything that I, my boss, and my IT department can think of, but still no luck.  Any advice would be appreciated, Cheers.

I have multiple SQL stored procedures that provide both subtotal and summary information. Goal is have all the stored procedure result sets writing to the same Excel worksheet in specified locations. The nearest I've gotten is correct locations but SEPARATE worksheets of the same Excel spreadsheet. Close, but that means I have the same problem I started with, having to copy/paste data to get the correctly formatted results. Is this possible? 

Hello , i am using two feature reader one for oracle non-spatial and other feature reader for an Arcsde geodatabase I would like to write the output in geodatabase including Feature dataset ,to use it later as input for ArcGis pro .how could I achieve it ?Fme 2021 thanks in advance

If a column contains the string "Insert," I want to change all the values in that column to "Insert." If the column does not contain "Insert," we want to leave the values in that column unchanged. Is there a method or approach available that would allow me to accomplish this objective?

Hello, I have a rather simple request for which I am not finding a solution. I have a Geopackage (multi-polygon geometry with table) already populated with data, let's call it "version 1". This Geopackage is copied and a manual update of some values contained in only 3 columns (out of the total 20) is performed, at attribute level only, let's call it "version 2". My request with FME is to copy the table values that have only been updated in the 3 columns from the 'version 2' geopackage to the original 'version 1' geopackage.  Thanks to "ChangeDetector" we were able to compare and isolate these cases, but we cannot "write the update" in the "version 1" geopackage. But, an additional condition to be introduced would be that to "write" the value to the "version 1" table, the field there before the change must be "null" Thank you

I am new to FMe, and I am struggling with the Test filter. Here is what I'm trying to achieve:If 'No_Feature' has both 'Insert' and 'Un' values, then it should pass.If it only has 'Insert,' then it should pass.If it only has 'Unchanged,' then it should fail.I have tried everything, but I haven't been successful. Is there anyone here who can help me out?I am attaching the workspace for your reference.

How can we handle Symbology (or preserve Symbology) in FME while reading data from ArcGIS online feature layer?