FME Form

Hi all. I ran multiple spatial filters to identify intersects between two layers, and now have around 70 attributes (custom named to the name of the layer, rather than the default name), that contain either INTERSECTS or Null. I want to now replace all INTERSECTS with the name of the attribute, using String Replacer or the like. What is the best way to do this? I have attached an example screenshot below of what I have vs. what I want to do. Thanks!

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 / begin exec 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 / begin exec :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/services https://orthophotos.geomolg.ps/adaptor/rest/services/Orthophotos_WB_2021_15cm_tif_PG1923/MapServer

Hi, I want to extrude my cad data using point cloud. (airborne LiDAR) When you look adding pictures there is 2 shapes. I drawed that in Microstation programme. I want to do: 1) The light blue one will extrude from the ground. I mean ground class (orange that) of airborne lidar. 2) The dark blue one will extrude to up .Minumum elevation of the building (red dots) class in airborne lidar. The note that my light and dark blue shapes are the same elevation. My last product should be pic "3Dd1".

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.'"

Hello, I need to compare strings from two sets of data and to find strings which contains the strings from other set. For example, in first table I have strings: column1 ABC ABCD ABB ABBD ACC ACCD In second table I have strings column1 ABC AC I need to compare them and have the result something like this: column1; column2 ABC; ABC ABCD; ABC ABB ABBD ACC; AC ACCD; AC Rows without data in second column may also be omitted. What would be the best approach?

Hi. Our main production FME server only has two engines, and its primary function reserves one engine for its function. This leaves a single engine for all other jobs. But the primary function only runs from 06-18 (6AM-6PM), so it's basically idle for 12 hours, in the period where a lot of maintenance jobs are run. Is it possible to set time limitations on queues, so some jobs may be run on the reserved engine from 18-06, i.e. during the night ? I'm running 2020.2.5, and here it's not an apparent option. Cheers

Hi, The KAFKAConnector works fine und provides me features with a filename "key"and the file itself "value". In my case "value" holds a zip-file with Shape-Layers. How can I access the features in the zip-Files? The content of "value" starts e.g.:"504B0304140008080800117242540000000000000000000000000C00000036313231396E67722E646266A4BD49AEB5C9921C5622454D04021A68016F2EBC83E89B2121160942608352092047DA8776A389D629B3F81AF76391F578322A1F2A2BF2FEFFBDD74F34DE9A9BFFCBFFE75FFC8B7FF53FFEDDDFFDBFFFC3FFF777DB3FFFCBDFFDDDBFF987BFFF37F77FFD3BFEEB7FFD57DF7FE5BFFCFD3FFC87FFF8F7FFF8F7FFF04FFCF9BFFF87FFEB3FFDDBFF7B2DFF13FFF53.... I think, I have to write this somehow to the filesystem. Maybe using the FeatureWriter Format: DATAFILE And then use the FeatureReader. Any Ideas? regards Herfried

Can ProjectWiseWSGConnector connect to a local server, and if how ? What should I put into the Bentley ProjectWise Connection Parameters ? It seems like the URL i use in ProjectWise doesn't function in FME.

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 details Is it possible for FME Desktop to not see my 10.8.1 install so it can't reference the co

Hello guys is 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 value the final result should get P20201_WXL2EAO3AKAU/P20201_WXW2ECO1CVI6/[al/WX62D212NFU2 Thanks

Hello there the data we have looked like this as a sample as you can see each end value of the r-name is the start of the next feature the goal is to group them based on this relationship end result should look Thanks

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.

I was using"https://github.com/tum-gis/ifc-to-citygml3" to write GML3.0. the w.pace is designed to write BldgConstructiveElement so I changed it into wall /floor surface. I can see the converted wall on visual preview but it is not writing it. any idea?

Hi Community! I'm trying to access and read/upload/download data from a S3 compatible cloud storage. Since the cloud storage isn't an S3Amazon i cannot get the S3Connector to work. The S3 compatible cloud storage is equivalent to S3Amazon storage and should be compatible Does anyone else know how to do this?

Hi, I have a non-spatial SQL dataset containing a unique identifier along with 2 sets of coordinates (start x and y, end x and y). I am using 2 vertex creators to spatially enable the data and then want to draw lines between the coordinates, separated by each unique identifier. However, using the LineBuilder the output is only coming out of the Point port and nothing is coming out of the Line output port. The workspace worked previously using Desktop 2018, the only difference now is I am using 2020 with updated SQL data, though the data type is unchanged.

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?

Hello all. Last year, I delivered a number of Shape files to a customer, which they had no problems in using. Now I've adapted another of our systems to create Shape files as a supplement to an email message. These latter Shape files cannot be read by their ArcGIS Pro. The error message is "Failed to add data: ... A user-supplied component or subscriber raised an exception (Exception from HRESULT: 0x80040208)". I've also tried to apply Geopackages, but they err the same way. Both output routines uses FME. The former used straight up fixed writers, and the latter uses FeatureWriter, but that shouldn't matter, right ? I cannot see any difference between the two Shape files, and QGIS reads them both without any qualms. Apparently they can read the offending Shape into QGIS, and have it save it as another Shape, that works in their ArcGIS Pro. I cannot see any difference between the two flavors (in QGIS), except that one fails when input to ArcGIS Pro. Does anyone have any insights as to w

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 all This 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 so Using 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 everyone I 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?

How to get ArcGIS Explorer .markup files to shapefile/feature class format?