General

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

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)?

Currently, we have FME Desktop 2012 installed in our system. I would like to know, that if I install FME desktop 2020.2 in the same system, will the activation key remain same or will it differ? Please suggest.

Hi friends, I would like to filter roads (Name) that passes through more than 2 suburbs (Suburb). I do not see a straight solution in Tester. Can anyone please give me a clue to about this issue? best regards,FS

I m trying to get the data from KMZ and push it to the ArcGIS portal everything is fine but getting errors in the writer<class 'FMEobjects.FMEAggregate'> cannot be converted to esriGeometryPolygonanyone knows where I'm wrong

We have a FME server installation which has been active for a couple of years now without issues. Today I got a message from our sysadmin that the machine where FME server is installed is running out of disk space.It turns out that in the Postgress database that is installed with FME server large files were created. I can't find any logging that would explain how and why these files were created. Everything appears to be running smoothly. Does anyone know a possible cause for this and how to remove these files in a responsible manner? Edit: So, I have been able to connect to the Postgress database using PgAdmin4, installed with fmeserver. It appears that since some time every second a couple of error messages are written in the table fme_sysevent_history. That table is now 11 Gb. So that mystery is solved 🙂 (appare

I have a series of PDF documents that contain a map that came from the ArcGIS Map Series tools (over 2000 in all). I am reading each of the PDF's in and converting to BMP and saving the images to a local drive so I can use the images in a HTML report.  Rather than store the images locally, I was wondering if there was a way to convert the images to base64 and save the base64 as an attribute and then just use that attribute in the HTML document? Is this possible? Any suggestions would be very much appreciated.