Transformers

I have changed the project file extension to .zip and extracted the XML documents, but getting nowhere with Esri ArcGIS Layer Reader (safe.com) Have also tried pointing a regular xml reader at them. Any ideas?

Hello,I have a (tough) nut to crack.A TestFilter of a job, run by a WorkspaceRunner, receives data but does not copy them into his output.TestFilter_12_INPUT (TeeFactory): Cloned 2589 input feature(s) into 2589 output feature(s)TestFilter_12 (TestFactory): Tested 2589 input feature(s) -- 51 feature(s) passed and 2538 feature(s) failedTestFilter_12 LR valid Transformer Output Nuker (TeeFactory): Cloned 45 input feature(s) into 0 output feature(s)TestFilter_12 BT valid Transformer Output Nuker (TeeFactory): Cloned 6 input feature(s) into 0 output feature(s) The very same job, when run manually it gives this information : TestFilter_12 (TestFactory): Tested 2589 input feature(s) -- 51 feature(s) passed. I don't understand why the behavior changes according to the way of launching it. Someone has an idea ?  

Hi there, if I have a dynamic filename within a csv or feature writer, e.g. "@Value(LINK_DIRECTION)_@Value(SIMULATION)_@Value(TECHNOLOGY)_@Value(BAND)_@Value(CARRIER)_@Value(TYPE)_@Value(SERVER)-importfile" it takes about 25 seconds to write one million files. If I write simply to test.csv, it takes about 2 seconds.Both variants writes only one file. I tried also to group by within the featurewriter with option "Complete Groups when Group Changes". All records are within the same group.User Attribute Definition is in all cases set to "Automatic".What did I wrong? What's the best way to just write into a csv file, with various attributes in the filename?Thank you for any help!I'm using FME 2022.2

Or is there a certain way the csv needs to be structured in order to take on a new schema? Thank for your time.

Hello everyone! I have dataset with two entities - points with Z coordinates and quite complex multilines. Is there any way how to gain Z values from points to vertices of line? Points have the same XY as vertices of line. Sample below:I have tried the way with SurfaceDraper or with Chopper and PointOnPointOverlayer, but results were not as I expected. Thank You so much!Lubo

I using geometry validator to rectify the geometry errors . Input of the geometry validator is polygon data from PostGIS database and repaired geometry need to update in same table. While executing the FME it shows "Geometry type (Polygon) does not match column type (MultiPolygon)" . Please advise to clear this error.

Hello. Could someone advise? I have an airport runway and for each runway I have a runway threshold coordinate - start and end. I also know the length and width of the runway between these runway thresholds. I would need to graphically create a polygon that will create the correct visualization for me based on these input attributes. The output format will be a shapefile. The dates of each runway are several times, because depending on the direction from which I land, I have the name of the runway. In reality, it is 2 points of each runway (start and end) and their one length and width. Thank you very much 

I need an FME .fmw file that will convert an Esri point shapefile into an AutoCAD DXF files that will take the 'POINT_ID' attribute value from the shapefile and place it as a text entity to the upper right of the converted DXF point

I need to make an inventory of the GIS data my organization has. As a first step, I need to make a list of the names of the Feature Classes in each of our File Geodatabases.  Is there a way to extract a list of the Feature Class names (not the attributes or schema) from a File Geodatabase(s) to Excel using FME?  I know how to do this in python in ArcGIS Pro, but given I am relatively new to FME, I thought I would try it in FME.

I have a file of polygons and need to generate a list of which are adjacent to each other. I tried the spatialrelator tool and selected the 'touch' parameter but that didn't work for me. I then read a few posts on this forum and decided to buffer those polygons (only 10 ft) and then run the AreaOnAreaOverlayer to generate a list of overlapping polygons. I selected the Merge Attributes option and the UID column within the transformer so that the output included the UID of the main polygon and the UID of each polygon that is adjacent/overlaps that polygon.  The tool works with one exception: the formatting of the merged UID column. It keeps adding brackets { } in the column name. I can't find a way to remove those from the default name value within the transformer itself. I can change the column name in my output file to remove them, but then the transformer will not allow me to manually connect the transformer column to the new name column in my output f

Hi, I have 2 sets of data one line and one point set. I have snapped the point set to my lines and aggregated them by their highway name. I need to remove the first and last point that falls on each highway. Unfortunately, this is where I come up short on ideas. I have tried using a Neighbor finder and snapping the last points to their closest neighbor, but as my road data overlaps, this causes an issue of points snapping to points on other roads.   Any recommendations would be appreciated.

Are there any specific coordinate strings or bounding boxes to be created for the ImageFetcher to understand where to fetch from a URL? I.e. I tried to fetch from a XYZ tile server and it works flawless in QGIS. The same URL doesn't work with the ImageFetcher for some reason.

Hello ,Could I create tables (Feature classes ) in Arcmap by using Arcsde writer even if there is no content ( empty content )my problem : I have to export the data required monthly from Fme .sometimes ,no data output .sometimes there are new data .in case no data ,i would like to have always feature class , when I show the table of content in arcmap ,I see it is empty .even if there is output or not ,i would like to have monthly feature class has the same name . How could I achieve it ?fme 2021

Looking for ideas on geocoding from text blocks. Each feature has a block of text (~50 to 100 words) describing an incident. More than one place could be mentioned so results would likely include more than one place. But in any case the goal is to geocode based on places mentioned in the text. An example might look like this: "...Something happed in Streetsville and people were walking toward Placeville." And we would want geocoding results from Streetsville and Placeville.

I've 6 SQL statements in SQL executor. I'm trying to execute these 6 statements only when name_<1-6> value exists. If any of this value is NULL or missing, then that corresponding SQL statement needs to be skipped to avoid error. insert into demo.lu_test values (@Value(id), '@Value(name_1)', 1);insert into demo.lu_test values (@Value(id), '@Value(name_2)', 2);insert into demo.lu_test values (@Value(id), '@Value(name_3)', 3);insert into demo.lu_test values (@Value(id), '@Value(name_4)', 4);insert into demo.lu_test values (@Value(id), '@Value(name_5)', 5);insert into demo.lu_test values (@Value(id), '@Value(name_6)', 6);  @david_r​ Please suggest. Thanks!

I'm using the feature caching Run option.I'm reading a postgresql table (no geometry) not a postGIS table. Unfortunately it is rather lengthy. For each record, I'm getting Adding to Spatial Index (paraphrasing) and after the last record a rather long pause before the processing progresses.This might be fine for small record sizes but it is crippling for larger ones.The bottom line is shouldn't there be no spatial index created as long as the reader has no geometry in any case - feature caching or not?Here are my details:Edition: FME Database Edition (node locked-crc) Version: FME(R) 2019.1.0.0 (20190704 - Build 19604 - WIN64) Locale: en_US Codepage: 1252 (ANSI - Latin I) Registration Key: 1-542-353-546 Customer Number:  Home Folder: C:\\Program Files\\FME\\Beta\\ Operating System: Microsoft Windows 10 64-bit (Build 17763) Thanks for any assistance or bug fixing.

I wanna be able to define a global python function (perhaps in the startup scirpt?) like this:def dosomething(number)new_number = number + ... doing something with itreturn new_number then, en would like to reuse this global function many times at different moment in my workspace on many different attributes that has to go through the same treatment. During the workflow of data_a, I'd call a pythoncaller this way:newNumber = dosomething(feature.getAttribute('num_1'))feature.setAttribute('num_1',newNumber)newNumber = dosomething(feature.getAttribute('num_2'))feature.setAttribute('num_2',newNumber) During the workflow of data_b, I'd call a pythoncaller this way too:newNumber = dosomething(feature.getAttribute('num_a'))feature.setAttrivute('num_a',newNumber)newNumber = dosomething(feature.getAttribut

HI all, does someone have (or has someone had experience with this):JPEG reader: `C:\\Users\\USER1\\AppData\\Local\\Temp\\wbrun_1699971545629_16788\\fmetmp_4\\ImageFetcher1699971789428_20972' exists but could not be opened. File contents may be invalid, or the file format may not be supportedJPEG reader: Failed to open the dataset 'C:\\Users\\USER1\\AppData\\Local\\Temp\\wbrun_1699971545629_16788\\fmetmp_4\\ImageFetcher1699971789428_20972'. Please ensure source data is valid and correct reader is selected.The funny thing is I never had an issue with that and it was working perfectly.Any ideas?

Hi, I have a CAD file with 1000 polygon, 500 out 1000 are shifted 0.2m. I want to keep only 500 regardless of the shifting. please advice. thanks

The workbench I am putting together contains a feature reader to a dynamic write in several locations.  The workbench itself detects shape files in a folder location, validates projection, geometry and AssetID attributes. Then writes out any identified errors to a shape file for upload in another step.The dynamic write of the "errors" shape file works however the dynamic write of the upload file encounters a warning where the below appears in the log: Cannot define schema for '@Value(ENCODED,fme_feature_type)' as the feature does not contain schema information. While we have the schema mismatch the remainder arrive correctly.The features arrive with the new layer name that I want to use. Testing my workbench I have found that the dynamic writer performs as expected (and outputs the shape file) for every stage up to exposing the fme_feature_type, mapping the new layer name and

Hello, I am trying to create a folder with a prefix of Run_ and have the current datetime as the folder name. I am very new to FME and I am not sure what I am doing wrong with the setup that nothings gets created in the path I have as destination (screenshot below). I appreciate any help.

I have a work bench that transforms data from multiple sources and then inserts only the new records from the combined data into a table using a merge transformer and Feature Writer. For auditing purposes I need to log how many records were written to a table in the same Database as well as pass that info back to FME Server to include in a email via automations. I am able to do this currently with the summary output of the Feature writer, however I would also like to pass the count of the existing records and also set the total written to 0 rather than the undefined that gets returned when there is no new records to add. I've tried using counters but either I'm using them incorrectly or I'm missing some steps as the flow doesn't continue down the path when there are no new records.  

HelloI want to create a point in the middle of each line in my file. Each of these lines is made up of only 2 vertices. Can you guide me to achieve this. Thanks in advance

Here i have some Lines extracted from DWG and thought i set them to the correct projection. all seem right except for one file that is way off "Asbuilt - Sewer Existing" I noticed that the autocad_origion x,y are the correct extents but the geometry have different xy coordinates. any ideas on how to set this correctly would be appreciated. Many Thanks! 

I'm looking for some advice to get me started on creating a workflow. I'm an intermediate FME user but this problem has got me stumped! I'm dealing with roughly 100 areas that require tree planting. Each planting area will be a different size depending on the environment. Once each area is planted, we need to monitor 20% of the area to determine the success rate. The monitoring plots are 10 x 10 metres, so area of 100 sqm. The plots need to be placed at random and I need to find out how many monitoring plots can be fit wholly within a planting area where the total area of the plots is at least 20% of the total planting area. For example, if the planting area is 3000sqm, I would need to assign 6 x plots.20% of 3000 is 600. 600sqm would be 6 x plots. Any help or advice would be appreciated.