General

I am trying to utilize the Anchored Snapper to snap the edge of a zoning area to the underlying parcel boundaries. The tool visually works great; however, it is utilizing the vertices of both features resulting in overlaps and slivers that are later detected in our workflow. Is there a means to have the Anchored Snapper only utilize the vertexes of the anchor? Is there a better tool option that will not change the parcel feature?

Hello! I have a workbench in FME Desktop 2021.2 where I need to write out several XLSX files from the same dataset, with exactly 1500 rows in each, and each one named FileName_1.xlsx, FileName_2.xlsx, FileName_3.xlsx, etc. I have managed to do this using a Counter, and ExpressionEvaluator. The ExpressionEvaluator takes the attribute from Counter (_count) and creates a new attribute called "_result" using this expression: @floor(@Value(_count)/1500) + 1 So that gives me the sequential file numbers that I want to append to the file names based on 1500 rows in each one. I can do this if I include the "result" attribute in the Excel writer, and use a FanOut Expression like this: FileName_@Value(result).xlsx This produces the Excel files with the correct file names, with 1500 rows per file. However, my question is, how can I exclude this "result" attribute in the Excel files? I don't want that attribute being written out. If I remove it, there is then no

Hello Friends, I'm new to FME. Here I'm facing a new issue about Arabic Font is not displaying properly after conversion. Converted data from shapefile to dgn with tags. in the dgn attribute field Arabic font is displayed as some special characters, but in the shapefile, it's displayed correctly. I would like to convert vice versa. legends, please help. Ps. sample csv file attached for your reference. Regards, 

I have polygons of two different shape files and would like to have a possibility that FME shows me (either with an attribute or with a flag or geometry) where there are gaps oder overlaps between both...the poylgons should have the same geometry but they haven't the same area.....the second shape is only a part of the first.i have tried some overlayers, intersectors or other transformer but none of them gives me that i want...i think its a combination of some transformers.i don't want to repair the polygons only find these errors!Any helps?Thx Franco

How can I edit a AttributeSplitter feature list to have custom layers names

Right now, I have it set up so that I have a Reader set to read our entire SDE database (set as single merged feature), which takes a really long time to go through, and then from that, a FeatureTypeExctractor to get the feature name. I also have Reader for an excel spreadsheet with all of the feature names that I want the rest of the script to process. I've I've used a FeatureMerger to join the output of the FeatureTypeExtractor (from SDE) and the Excel spreadsheet and to keep only those feature names that are the same (join). That output then goes through the rest of my script.  Is there a better way? The downside of the way I have it set up is it will take a really long time to go through our entire SDE. We will likely add a few new feature classes to our SDE each year and I would love to just update a spreadsheet with those new feature names and hit RUN.  Any ideas are greatly appreciated! Thanks :)

By way of an example, the Google Sheet reader parameters allow for the Specific sheet to be referenced after a lookup of the Workbook's URL given an authenticated web connection.  I'd like to populate a similar list based on an authenticated web connection, also following an API call based on another parameter field – and if that is possible to cascade multiples of these. This doesn't appear to be available in the Manage User Parameters dialog set.

I have created a stored procedure in oracle to refresh oracle materialized views, I turned to stored procedure because I was originally trying to do it in run sql after execution but it kept failing with invalid sql . No I have teh sored procedure and I have placed it in sqlExecutor to test and its still returning errors.. this is the oracle create procedure statement (names changed ) create or replace PROCEDURE "MYProcedure" AS BEGIN DBMS_MVIEW.REFRESH('A,B,C,D', method => 'F', atomic_refresh => FALSE );END; and this is how I try to execute it in sqlCreator  FME_SQL_DELIMITER /beginexec NBPNBICASPER_VIEW end ;/ This fails and the only way I get no error (but nothing runs ) is put : in front of the procedure name )  FME_SQL_DELIMITER /beginexec :NBPNBICASPER_VIEW end ;/  What am I doing wrong .. Have I gone about this incorrectly? any help direction etc. is hugely appreciated. Paul

FME 2022: How to download esri cached map service? I couldn’t figure out if there is a tool on FME that can download esri cached map service https://orthophotos.geomolg.ps/adaptor/rest/serviceshttps://orthophotos.geomolg.ps/adaptor/rest/services/Orthophotos_WB_2021_15cm_tif_PG1923/MapServer      

The file is not in use elsewhere, and is not password protected. Which user is supposed to be set up with write permissions to the file from FME Server? FME Server Error message: "Excel Writer: Failed to save changes to the spreadsheet '\\\\data01\\pathname\\TermUtility\\LOCID_Output.xlsx'. Check that you have write permission to the file, it has no password protection and is not opened by another application. Error message is 'Permission denied.'"

So I have a job that usually runs on my server but trying to troubleshoot it locally is giving a error that makes no sense as  all the scenarios are invalid. The Login is validated in ArcCatalog 10.8.1, There is no ArcGIS Pro elements mentioned as this is a basic Geodatabase, and the log-file only shows these 4 lines.Could not open the Enterprise Geodatabase. The error number from ArcObjects is: '-2147216118'. The error message from ArcObjects is: {Bad login user}Please ensure the connection parameters are correct (server=`mySQLServer', instance=`sde:sqlserver:mySQLServer', user=`GIS', password=`***', database=`GCSS', version=`dbo.DEFAULT')It could have failed to open because it contains ArcGIS Pro-only features, for example Arcade expressions. If this is the case, please install ArcGIS Pro or Pro-compatible ArcGIS Server and 64-bit FMEA fatal error has occurred. Check the logfile above for detailsIs it possible for FME Desktop to not see my 10.8.1 install so it can't reference the cor

Hello guysis there a way we could remove the waring in the text file that looks like this and get it only in one line with "/"between each line valuethe final result should getP20201_WXL2EAO3AKAU/P20201_WXW2ECO1CVI6/[al/WX62D212NFU2Thanks

Hi,I have 1 raster containing 3 bands. All bands contain water depths, but for separate areas. Since they are for separate areas, I would like to merge this information into one band. The final product would be 1 raster with 1 band containing the water depths for the different areas. Thanks.

Suppose I have a data containing 10 million records but I want to read every 1 million features and run my processing parallel in 10 batches. Can someone please suggest any method?

When I add a custom domain for Salesforce in FME, FME is not adding or permitting the ?locale=au suffix. The formatted string should be https://p-2576944.my.salesforce.com/?locale=au but FME looks like it is using https://p-2576944.my.salesforce.com.

Hi allThis should be a simple solution and I'm obviously looking in the wrong places so would appreciate your assistance. I'm creating some new records in a database.I need to create a GUID (esri sde) and an exact string copy of the GUID Using the UUID Generator i can create a uuid like soUsing an AttributeManger to convert to UpperCase it writes the UUID like so - which is the esri way  Using the same AttributeManager i should be able to rename UUID to GUID and copy the value of GUID to a GUIDString attibute The FME output looks correct and the 2 attributes match each other However, when writing to the sde and inspecting in arc they differ Thanking in advance for any pointers on what I'm missing.lj7 

Hello everyoneI am using the isochrone transformer in the fme hub for an analysis. I have a network to a single road and multiple source points. I'm trying to get each source point to be analyzed separately and to create polygons as a result of isochrone. All my attempts, including changing the transformer, were unsuccessful. Can you help me with this.I want an output like the screenshot below.a polygon for each source point

In the past I asked this question. Things have developed and now I want to use a HTML table, which is the outcome of a FME workbench, in a workspace app. Something like this: Within my HTML table I included sorting and search functionality. These were included in the FME app before. You entered a search string as a User Parameter - Hit Enter - Browser with found HTML content was shown. To improve my app I removed the FME search function and put everything directly in the HTML table. Is this possible in a workspace app?

Hi, I have 1 DGN file. This file has regional limits. I want to see the drawings within the boundaries of this region in Excel, but not all of them, I am giving an example. Additional base number in Region_1 55 Additional base number in Region_2 25 I want to see the figure separately in Excel, how can I do this?

FME Desktop 2020: How to get the number of features located in front of the tools arrows, Currently, the number of features is located at the middle of the line that’s connected between two tools. As per the screenshot below, in particular arrangement for the tools, it gets hidden if the fields are expanded, for example. Is there a way to get these number located in front of the tools arrow?         

FME 2020: How to pass the Blocks number to their Parcels? In the screenshot below, there are two layers: parcels and blocks. I wanted to pass the blocks number to all parcels contained in it to end up with a new layer that has two fields: parcel number and block number What might be the best practice to perform this? The data is attached 

FME Desktop 2020: FME appears to mistranslate the content of AutoCAD dwg file, In the screenshot below, I couldn’t figure out how the FME creates the marked square while it’s not physically existing in the AutoCAD drawing file. What could be the issue here? The CAD file is attached            

I am currently just working on some of the modules as I am trying to learn FME, but when I manually set the final line for some of my expressions as just ")" it automatically sets an "=" for my Operator and then changes my logic to ") AND". For some of my conditions I've been able to simply put the final parenthesis and be okay, however, the attached image is where I am running into issues. Line 7 just keeps switching itself to ") AND".  How can I use the ")" logic without it auto resetting to ") AND"?  

I am reading a table in from a Microsoft SQL database with a MSSQL_ADO Reader. The table has longitude and latitude attributes, read in as float data type. I would like to write this table into a geojson format, where the geometry of each feature is defined by the longitude and latitude coordinates. I have tried using a VertexCreator Transformer, but when I then write the table to a geojson, the geometry feature is null in the whole file. What do I need to do so the geojson writer writes non-null geometries?