FME Form

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

Dear community,I try to write an ifc-file, converted from a dwg file. Simply extruding a block and using the extrude for IfcWall, IfcOpeningElement and IfcDoor. (I am going to add the attributes later). Now the only thing that I am missing is the ifcrelfillselement and ifcrelvoidselement. I followed the instructions given by the explanation on the FME page "Industry Foundation Class STEP Files (IFC) Feature Representation" and the hints given by @dominik​ concerning this issue. But I am not quite sure, where to add the ifc_opening_id and what values to assign to it. Could someone help me out here?Thanks a lot in advance,Morten

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?  

I have a dwg in CAD, it doesn't have a projection, I need to convert this to a shapefile, how can I add the British National Grid and move the drawing to the correct co-ordinates?

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.  

Hello, I have to update DATE value in XML file and I use XMLUpdater transformer. It works perfect if it is only one date value.I have problems updating date field for coleListValue="publication" in the situation that shows the following example:            <CI_Citation>                <date>                  <CI_Date>                     <date><gco:Date>2006-07-01</gco:Date></date>                     <dateType<CI_DateTypeCode codeList="myCodelists.xml" codeListValue="creation"/></dateType>                  </CI_Date>               </date>                <date>                  <CI_Date>                     <date><gco:Date>2014-07-11</gco:Date></date>                     <dateType><CI_DateTypeCode codeList="myCodelists.xml" codeListValue="revision"/></dateTyp

Our team are trying to create a workbench which will be used to answer user data requests. The workbench should provide a packaged export from our Oracle database, including a schema definition, metadata and various file type(s).  I'm trying to make this as simple as possible by using parameters for the user to input, including table name and spit out folder at the end however I'm stuck when trying to create a parameter for the table name we want to download using the Esri Geodatabase (ArcSDE Geodb) Reader.  I've actually managed to work around this for the metadata by setting a default table, using the merge feature type option and using a wildcard, then setting a parameter from that. However when I try this with features although I get the geometry I get an empty attribute table.  Anyone have any experience of this or potential better solutions?

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 ?

Hi,I'am trying to read a schema from an Oracle table through the FeatureReader. This works well for lets say TEMP.TABLE when the connection user is a different name than TEMP. When I connect using a user TEMP I don't get a schema. But after removing TEMP. the FeatureReader returns a schema. This if no problem when I know in advance which user is connecting, but in my case it's all dynamic. We use connection names and the user behind this connection can be the same as where the tables are stored.Is this a bug? Or does anyone have a solution? Thank you,Arno

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

Forgive me for what is likely a very simple answer to this question, but I'm still rather new to FME. I'm wanting to use a defined User Parameter (Type - Text) which will then inform my AttributeFilter transformer (where the user parameter directly corresponds to a specific field of the dataset being read by the AttributeFilter transformer). However, when I set the transformer parameters as per the screenshot below, I don't then get the expected output, i.e. the dataset filtered for that specific value. Is there something I'm missing? Thankyou for taking the time to read this post. 

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.

Hi everyone, I am trying to get the value of the first table (that only has one row with info about xmin, xmax, ymin etc.) into the 2nd table. The second table has more rows and my wish is to have all the rows in table to get the same value for e.g. xmin from the first table. However in the 2nd table only the first row gets the value of the first table, while I want to have all the rows the same value for that column. Does anyone how that might be achieved? In case my question is not clear, just let me know.

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:

Hi! I am trying to read into FME a series of images (jpeg/tif/png) and then match them to a different datasource and rename them using pieces of information from both sources. All works well. But. I have some files which contain special/accented characters which aren't being read in. For example the filename below  Anadolu Koyu PLAN_IZMIT KÖRFEZI TO ISTANBUL.jpg throws an error 'Anadolu Koyu PLAN_IZMIT KÖRFEZI TO ISTANBUL.jpg' cannot be located. Please ensure the file exists and is accessible' The common denominator in all of the errors is the special/accented characters. My question is whether I am missing something and I can get FME to read the filenames and bring them into the workspace, or whether I need to handle these (hundreds of) files manually? All helps much appreciated!

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,I am translating a DGN file to File GDB using dynamic schema.In DGN reader, i can see so many extra attributes like attribute.color, attribute.length etc. I want to ignore those attributes in file GDB writer.I am using attribute keeper but it is not working in case of Dynamic Schema, Please guide.Thanks in advance.

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!