General

i have lines and i have polygon my question that i would like to find which line intersects with polygon and which lines crosses with polygonso i have transformed polygon to lines by geometry coercer then i used spatial filter ,predicate crosses and another time i used spatial filter with predicate intersect but i have found that the output in passed port even if i have chosen predicate cross or intersect ,i get this line in output why did this line appear when i choose predicate intersect ,because no intersection point between line and polygon . i would like to have it only when i use predicate cross .i hope someone has idea for me   FME 2020

Hi! Here's an overview of what I'd like to achieve:User selects a folder.FME reads in all the files plus those in sub folders.An attribute filter filters out those files required. The attributes to filter by will have already been set.Selected files are then read into workspace and processing continues.(all files are either .csv, .xls or .xlsx) Having read this post this user is trying to accomplish the same thing. But I am unable to set up the FeatureReader to read the contained data in a file. Please can you let me know how to do this or is there a better method? Thanks.

hi, i am new to fme desktop I have in a csv lines stored in a column like [[x,y],[x,y],[x,y],[x,y]] and i dont know how to transform into fme line geometry Please help

I would like to use the FME server as middleware to accept files of various formats via a post-request and save them elsewhere. The formats would be mainly pdf, jpg and text based formats (xml, json, etc.) and do not necessarily need to be read in and "understood". I have therefore used the datafile reader/writer in my workspace as both reader (without input path) and writer. My first approach would have been to store the file temporarily on the FME server in the resources folder and read it in again in a second step. The storing works, but I don't know how to access the filename. Normally I would have the attribute basename exposed and read out via the FileNamePathExtractorm, what does not work here. My main problems are the following: how do I access filenames in the input if I don't know it in advance? Is there a way to process mulitpart request? And ideally, of course, I would pass the files directly without having to store them on the server. I have already found

Hello everyone! I'm new FME-User and this is my second month of learning FME. I've been fooling around mainly with maps (TIFF,JP2000) and Lidar. I'd like to build a 3D-Model from a part of a forest where I add tree.obj for each tree in a raster. I'm trying to build a tree detector that makes a shapefile of the border of the trees and maybe make a list of the trees in the forest. So far I've tried this, this is probably really painful to watch :D.TestFilter that detects brightest parts of the forest(tree tops), then second brightest spots and third brightest etc..Then I start clipping with buffered detected spots from dark part to the brightest parts and in the end of the clippin' I have really messy tree tops marked on raster..And this doesn't really solve the original problem at all of making a shapefile for an each tree of the forest :D So I figured that better approach might be something like this.Spot the brightest tree tops --> Mark the tree top --&g

Hello FME'ersIt's Wednesday - and a rather quiet week is livened up greatly by today's release of FME2022.1 2022.1 ReleaseFME 2022.1 is now available for download on our website. So, what's new? Databases and UpsertsThe big item on the marketing team's list is UPSERT support in all of the core database formats. I count many formats listed in the changelog file. Here are a few of the most important:[Update] Snowflake Writer: Add UPSERT support (bulk mode only)[Update] MS SQL Server / Azure JDBC Writer: Add Upsert support[Update] MySQL/MySQLDB: Add UPSERT support[Update] Azure: Add UPSERT support[Update] FileGDB Writer: Add UPSERT Feature Operation support[Update] Oracle: Add UPSERT support[Update] MSSQL: Add UPSERT supportFor example, here's the MSSQL writer in 2022 vs 2022.1:  If you're interested in Upsert, then take a look at the ChangeDetector too. It has a new parameter for Mode, which can now be set to Upsert.  Also... I don't use databases that much, so I didn't realize the Attri

Hi. I would like to ask. I have three parts under one ID ( UUID_departure ) where each part has a different ID ( UUID_departureLeg ) and each of these three parts has different values. I need to combine under one UUID_departure these 3 parts of UUID_departureLeg with the data of each individual part. It doesn't work properly for me when using FeatureMerger, when using Aggregator it only writes the first value to me. Could someone help me with this? Thanks a lot

It would be really helpful to have an ETA on some big jobs, an ETA like when transferring files in windows explorer for example.

Hello everyone,I am storing a range of base64 PNG images as blobs in an Oracle Table. As part of a separate process, I want to read these images from Oracle and use them in an HTML report. What I am noticing is the attribute being written to Oracle is different to what is being returned from Oracle.  Attributes when written to OracleAttribute from OracleWhat do I need to do to read / write the image so I can use the Base64 version as an attribute in the HTML writer?  

Hey just wondering if theres an update on when the next patch will be released supporting 3.0. Several of our scripts don't work which follows through to our automated scripts running on FME Server.  Thanks

I have a flow as pictured below. I have only three collumns in my StatisticsCalculator. I have year, month, amount. What I want is to create a sum(amount) per year, month. When I run this flow it generates way to mcuh data. I was expecting 12 rows pre year but there is way more and the data is duplicate, giving 28 rows per month. What am I doing wrong?

I created a georeferenced png over a large are 20x20km (ortophoto and vector-layers) using MapnikRasterizer, needless to say the png is extremly big over 170 MB using option rgb24 in mapnik. Is there a way to make the file smaller without using png optimization in the png writer? I tried clipping the raster where the vector lines overlay it to just focus on the area of interest. But the png is still big. Seems like the cells with no data still takes up alot of storage.  

My workspace is Geotiff reader to raster mosaicker to reprojector to clipper which clips it to a grid then geotiff writer.  How can I speed this workspace up ?

When writing strings to a SQL-Server database, leading blanks are removed. Is there a way to change this behaviour?

Does anyone know how to obtain the “2.7 or 3.4+” python compatibility - dll file for transformers to function? After upgrading from 2021 to 2022.1 the Python 2.7 compatibility has been lost. Thank you.

Hi My code is working fine with FME Desktop 2014 but having error while compiling it with FME Desktop 2020 with below error error C2259: 'CtFunction': cannot instantiate abstract class as the IFMEFunction::execute is deprecated and need to upgrade it.

I am attempting to pull in some USGS groundwater data from a large number of sites over a number of years. The USGS has a website that can publish a JSON service that I am attempting to consume in FME Workbench.  Here is a LINK to the website. Every time I attempt to grab one site or 100 it fails in workbench using the JSON reader. The error is consistent at least. The feature reader in the log just says that the file doesn't exist. I'm not sure what I am doing wrong on the setup to bomb that quick in the process. Any guidance or info would be greatly appreciated.

I have to manually define VARCHAR(n) instead of TEXT <null> in the writer. This is very frustrating as I have hundreds of tables already defined. Using a reader resource ignores the DDL stored in the table. So is there a workaround? Here is and example DDL from the source SQLITE table:CREATE TABLE "System_Code" (   "OID" INTEGER NOT NULL,    scg_code VARCHAR(4),    code VARCHAR(4),    desc_ VARCHAR(2048),    status VARCHAR(4),    date_value VARCHAR(25),    char_value VARCHAR(2048),    num_value FLOAT,    start_date VARCHAR(25),    end_date VARCHAR(25),    et_created VARCHAR(25),    et_edited VARCHAR(25),    PRIMARY KEY ("OID")Which ends up half complete:

I have a large set of raster images (they are aerial imagery) and they were taken under various different light conditions. I would like to use histogram equalisation to correct for this. Does anyone know if this is possible in FME please?

Hi, One of our team members left the team but has still FME Desktop on his machine + the connection to the license server. How can I revoke his rights in order to use one license of our floating license server? Thanks!

I'm attempting to run a workspace on FME server that writes a gdb which uses an xml template file. If i upload the workspace and choose upload files, this works fine. If I try and use a parameter to set the location of the xml file and upload the file to the appropriate resource folder the process fails with an errorThe error message from ArcObjects is: {unable to open primary document entityI know the file is in the correct location as a file not found error is generated if the file isn't there. Any ideas?

I have a polygon and two lines inside.The Lines z is true elevation and lines snapped to area in 2d.I want it to generate points at intersection points and snap 3d to lines like in the figure.The sample data (dgn) is attached.    

I have an existing workspace that writes files using a fanout by a selected attribute. The workspace has been promoted to FME Server and runs on a monthly schedule. I noticed recently that the resulting number of output files was incorrect and after some troubleshooting I realized that the workspace will not work as expected unless the features are sorted by the attribute prior to being sent to the FeatureWriter with the dataset fanout by attribute. Should it be necessary to sort first? Is this something new?

I know StringSearch can look at that one selected column but I'm looking for a transformer that will search any column for a value? (similar way Visual Preview can find ??? in "any column")

Is it possible to add a pdf as an underlay in a dwg file with FME? I am setting up an automated process for creating dwg-files. Im adding vectordata from a database but i would also like to include a pdf created with arcpy in my dwg. I can see from the format docs that there are attributes for xref:s but i can't figure out how to do it. I have the necessary coordinate information to place my pdf correctly, just not a way of adding it. If it's not possible to create xref:s with FME, is it possible to simply update the xref information in a template dwg-file (including position)?