General

Welcome to What's Up Wednesday. 2022 Sneak PeeksThe series of FME 2022 sneak peeks continued yesterday as Olivia from the geometry team demonstrated the new SolidDissolver transformer and updates to the Tiler:  Next up on the schedule is a demo of the SchemaScanner transformer. With me will be Mark Stoakes, one of our FME Application Experts.  2022 World TourSo registrations for the World Tour are open with both Safe and our partners. I've been clicking through to the virtual partner events and signing up for any events where I think I can overcome any language barrier! I'll be sure to tune in and report everything here. Hub DigestThe FME Hub monthly digest is a great way to keep up-to-date with both Safe and user-submitted content. This month there are four new transformers and a template.  To cover how you use these, for transformers, you just need to type the name into Quick Add in FME Workbench:  DatasetValidator looks to be potentially very useful and is another exampl

After upgrading FME Workbench to 2021.2.1 our arcgis pro 2.9 environment doesn’t cooperate well anymore with Python 3.7+ scripting.  For example, for some of our FME services we’ve installed Geopandas, which worked fine with ArcGIS Pro<2.6 and FME <= 2021.0, but not anymore with FME Python 3.7 and ArcGIS Pro 2.9. To fix this we’ve tried several things with a dummy script (attachment):FME ESRI ArcGIS Python 3.7 (Python compatibility ESRI ArcGIS Python 3.7) succeedsClone ArcGIS Pro 2.9 with Scripting compatibility FME ESRI ArcGIS Python 3.7 succeedsClone ArcGIS Pro 2.9 with geopandas>0.8 and Scripting compatibility Python 3.7 executed in FME Workbench failsClone ArcGIS Pro 2.9 with geopandas>0.8 and Conda forge Numpy 1.20.3 executed in a Conda python prompt succeedsHow can we have a ArcGIS Pro 2.9 environment with Geopandas working smoothly together with FME Python 3.7 in FME Workbench?

Hello, FMEers.Here's the weekly What's Up Wednesday post. SchemaScanner 2022This transformer was quietly released as part of 2021.2, but since then it received a lot of updates and looks fantastic for 2022. How do I know? Because it was the subject of our FME 2022 Sneak Peek yesterday.  If you work with dynamic schemas in any way - or even if you don't - I suggest checking out this recording (click the link above). It's very insightful. I think the key difference to how you might expect it to work is that the schema is stored on a separate feature to the data. You just have to make sure that it arrives at the writer first in order to set the schema for the data that follows. An attribute key joins data to schema allowing multiple schemas for a single writer feature type.  Anyway, to return to a previous sneak peek - the one on encoding and UTF-8 - there is now an excellent article on the changes that were made and how they affect you when upgrading to 2022.  I think tha

we want to import data formats into our application and also export data from this application. that means, there is i.e. DGN file that we need to import into our data format and for this action we are looking for a lib or dll or similar.currently i have seen, there is only a desktop (standalone application) available, but this is not what we are looking for, as we need to integrate a "data converter" into our application. is there any version avaliable as a lib or DLL? thanks a lot.

I have a dataset of two lines and I want to calculate the average distance between them. I can use the NeighborFinder to get the closest distance between these two lines. (As you can see on the image the closest distance could only be an outlier.)But I want to know how far they are from each other in average as these two lines are almost parallel. Is this possible to calculate ?

I'm using SmartGlobe (Proprietary tool in Microstation) to convert Geographic Points to Grid. I'm trying to replicate what happens in the background of this tool but I can't seem to find a reprojector/projector to perform this task? Source file will be an .xml and output will be a .DGN with all the points projected in there corresponding Grid location. The Tool looks like this

Is it possible to export floor plan data from Smallworld in CAD format using FME ?

Hi, I have roof data in shp format. I generated from airborne lidar. But they not come to one polygon as I added in pic. I want to make them 1 polygon. How can I merge all of them ? But some of them have gaps inside. I want to see them like the name of "source".

Hi. I am joining lots of sql tables together in FME and there are a few that contain the same field names. So both fields are preserved and I know which one I am looking at I want to prefix all attribute manes with the table name (similarly to how joins show in ESRI) I have used the BulkAttributeRenamer to manually type the table name in, but am after something a bit more automated. I have also tried exposing the fme_feature_type and using this as a prefix in the BulkAttributeRenamer but all fields then come back as missing. What is the best way of acieiving what I am after? Thanks

Hi ! I wanted to know if there was a way to save the attributes definition (Name, type and width) in to a CSV.Thanks for the help !

When I try to convert DGN to SHP I get this error.“DESIGN READER: Found duplicate tag name 'numero' on element. Renaming tag to 'numero04' to avoid conflicts”Do you have any suggestions to skip this duplicate tag name please or the way to change the tag name because I did not find where these duplicates. 

I am having a problem getting a HTTPCALLER do a GET from a custom API. I can successfully connect to the same API url in a web browser but get the error below from the HTTPCALLER. I am using the HTTPCALLER with similar APIs without issue. The url for this API is a little different than previous urls I have used so maybe that is an issue?Previous urls were like https://.../name/2A159Problem url is like https://.../name/2A159/Family?rtuFamily=C where the GET has to match both 2A159 and rtuFamily=C HTTPCaller_4 (HTTPFactory): HTTP/FTP transfer error: 'SSL connect error'HTTPCaller_4 (HTTPFactory): Please ensure that your network connection is properly set upHTTPCaller_4 (HTTPFactory): No proxy settings have been entered. If you require a proxy to access external URLs, please ensure the appropriate information has been entered

Hi,I have some polylines that I buffered with Bufferer in order to make some checks.Once the checks are performed, I'd like to get the original polylines back. I was wondering if I can copy the lines geometry into another geometry attribute and read them after, or maybe some other technique. Thanks in advance!  

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