FME Form

Hello, I'm working with FME2020. I want to import several excel files with the same schema from one folder as different features. With a xlsx-reader (select multiple folders/files) all files are written in one feature. With a path reader I can't define a schema. Is there a way to read all the files with one reader or do I have to use one reader per file? Thanks in advance

Hi Guys, any ideas of how to solve this please (I'm a novice so take it easy please, I have a workbench that has 2 readers and 2 writers, the first part of the process reads and SDE featureclass , manipulates some attributes and writes to another SDE Featureclass - it has a run before and a run after sql for dropping indexes and constraints and recreating indexes and constraints and running a stored procedure. The second part of the process reads the updated featureclass and filters by query like value=1 then writes to a csv file. This all works however the second part does not select the correct number of records - its 6 records short. Its possible due to the before and after sql scripts taking a while to finish and commit. _ I can brake this into 2 workbenches and its all perfect but I'd like to keep them together - is it possible? Thanks Paulg 

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

I want to do some transformation on a schema/datamodel of a GDB and write it into a new GDB (which should be basically the same schema with these adaptions). But i do not get any output if i use Format: schema (any) and feature reader. Does anyone has some ideas for me? I´m a newbee using FME.

I am in the process of developing a custom transformer that can write a coded domain list to a new file geodatabase file, using this article as inspiration: https://community.safe.com/s/article/creating-and-associating-geodatabase-domains-dynam  The hope is to create these domain values either from the existing data or a look-up table within FME. Then upload the file geodatabase with these new domains to ArcGIS Online. I have followed the guidance in the article and believe it should work. The attached transformer edits the schema feature of the relevant attribute to something like this: "attribute{7}.native_data_type (string: UTF-8): coded_domain(FloorType:char(255):2:"2":1:"1":0:"0")". But when trying to write dynamically to gdb from the Schema Feature, the domain doesn't carry through.I compared the syntax of writing a coded domain manually to gdb in FME (by editing the user attributes) and looking at the log, and the format is the same as

Hi, can FME write PDF/a format files? I don't see any options in the Geospatial PDF writer.

I'm using FME 2021 to convert Environment Agency 2m DTM data into either shapefile or mapinfo tab, primarily for consumption in InfoWorks.  I've used the RasterToPolygonCoercer to produce shapefiles but my users cannot import them in Infoworks. They receive the attached error. Not sure if its because I'm using a TIFF reader rather than GeoTIFF? The original files look like this:  Any help appreciated - new to this aspect of FME!

Hi! I'm validating geometry of the CityGML files and I want to find out the errors and the smallest corresponding parts of the same feature for visualization purposes. According to the GeometryValidator documentation, features from the InvalidParts output port should contain attributes explaining what issue the smallest part(s) correspond to. With the help of the ListExplorer transformer I can get the error name (i.e. issue_found), but not the details. So the question is, how can I access the details attributes from the InvalidParts output port? That is very relevant because usually error name does not contain all needed information (e.g. what is the subtype of error).  Of course, I could get the error details easily from IssueLocations output port, but then I get only point features instead of surfaces or solids. Is there any solution for this or am I understanding something wrong? Thank you!

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, 

Can any one provide guidance on how to convert a .TML file to a ESRI shapefile for feature class?  Unfortunately I'm not able to upload the .tml and schema to this forum. They can be accessed here: https://drive.google.com/drive/folders/1pnvv5YCRYUE9h5OOt1dNf3jAChWL686F?usp=sharing

I have a citygml file with detailed solid models and surfaces. I'm looking for a Workspace to convert to 3d SHP in separate layers, can anyone help?

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

Hi, Need to extract each page from a pdf file and to write them to another distinct pdf file. The issue I have is that the content doesn't follow to the new generated pdf file . Secondly, I want to bind some specific pdf pages to one PDF file.  Thanks

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

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 /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      

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: column1ABCABCDABBABBDACCACCD In second table I have stringscolumn1ABCAC I need to compare them and have the result something like this:column1; column2ABC; ABCABCD; ABCABBABBDACC; ACACCD; 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? regardsHerfried

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.