FME Form

I am looking to dump from results of the SQL Executor into a DB table (fields not known). Looking for ways to do it. I see there is Schema and Result port for SQLExecutor. Not sure how to use both in order to insert the data into a table.

I am trying to write a 4 digit year into an existing MySQL database. The field type is year with a length of 4. Therefore, one would think that a 4 digit integer would write into it, but it does not. I get a warning saying "MySQL Writer: Skipped feature due to invalid date/time string". This seems extremely basic, but how do I turn a4 digit integer (e.x. 2012) into a date field that MySQL will recognize as a year?

This is less a question and more of a finding to report. In 2016, File Geodb Open API treats date values "1901-01-01" as "19000101000000", but in 2021.2.5, the reader treats the same value as "000000". The effect is the record gets thrown out, despite the writer saying all features are written.We've had to build in a StringReplacer to find all the "000000" to replace with the original date value.Is this a bug? Update:Affects "1900-01-01" as well.

I have road events from different groups and time lines.. so the geometry doesn't always match but they want me to push them together. is it possible to just use the PathName, Start Measure and End Measure to join many events together?  Example: All Path's have3 events Weight, Height, Width. I want to be able to merge them together like Snipper or LineOnLine so I can join the Start and End Measures where they break.. If needed in Python or Transformer preferably so I can complete this on the fly from two databases to compare.  

Hi, I have loads of vertices that belongs to polygons and want to change the start vertex so that the polygon always start and ends in the lower left corner. The order of the vertices must stay in the same order so its possible to rebuild the polygon. Spatial sorting works to identifiy which vertex that should be the start vertex but messes up the order of the other. Thanks

I have a process where I determine the last ID number used for two id fields using statistics calculator. I then use an aggregator to merge the two ID's. I then bring about 100 records from another table and am wanting to add these ID's to it. But what is happening is that the two ID's are just being added as another record instead. I have tried using variable setter & retriever but those didn't work at all.

Hello, I am trying a simple conversion from KML to csv. I need to write all data from ExtendedData element, it may be SimpleData or Data key/value. All I want is csv file with custom data from kml.  In a workbench I have  Generic reader which reads KML ( GENERIC Reader is requirement)  CSV Writer to write to csv  I have connected reader to writer directly no transformer and I expecting csv file. I yet to put CoordinateExtractor to get coords from file. So I am expexting only data to be written to csv. But when I run the workspace all I get is blank csv.  Here is a sample KML.  <kml xmlns="http://www.opengis.net/kml/2.2"> <Document>   <name>My Golf Course Example</name>   <Placemark>     <name>Club house</name>     <ExtendedData> 

I have a problem when creating a workflow in which additional attributes are linked via an identical ID from Excel (name) and Ifc (ETL_TYPEN.NAME). The problem is that not all attributes from the Excel list are recognized and linked and the geometry is taken over in the updated IFC (Writer).

in FME 2020 the behaviour of Generic Reader changed in a way, that "Guess format from extension" for GPKG now defaults to GEOPACKAGE_RASTER instead of GEOPACKAGE (vector). This broke a workflow in our application. Why was this changed ?

Hi, I have a 3D modell as object file. I will convert this to cesium tiles!I tried this way:Reader -> CoordinateSystemSetter -> Writer (Cesium 3D Tiles) But if I import the tiles inside cesium (e.g. cesium ion) I do not get georeferencing. So the model is not display at the correct location.  Is it possbile to assign a georeference to an obj file?

Hello Sir / Madam, So I would like to subtract both "Top Height" and "Rooflevel" attributes. I use attribute manager to calculate the value@round(@abs(@Value(TopHeight)-@Value(ROOFLEVEL)),1) The result is shown as below.However, I want my result to be <null> if either TopHeight or Rooflevel is <null>. May I ask how to do it? Thank you. Zachary

Hi,I'm trying to read in various Caris CSARPC files and some fail with the following errors: (Had to sanitises paths)I've moved the FME temporary file location to a network share that has plenty of space as I thought it was running out on the C: drive, and it is writing the temp files in the correct location.It also is not consistent, I can run other CSARPC files through reader and it works fine, some a lot big then others, not sure what is going on?? Output"FME Configuration: Source coordinate system for reader CSARPC_1[CSARPC] set to `_FME_0' as read from input dataCoordinate System `_FME_0' parameters: CS_NAME=`_FME_0' DT_NAME=`WGS84' PROJ=`MRCATK' QUAD=`1' SCL_RED=`1.0000000000' UNIT=`METER' Storing feature(s) to FME feature store file `\\\\XXXXX-share4\\XXX_GIS_Warehouse_Scratch\\temp\\wb-cache--zD5304\\Main_CSARPC -1 2 -1 0 7d1dc4d5b02aac6f53ce8974ab35efb9a70c671b.ffsu

I have a 2016 workspace that I'm upgrading to 2021.2.5. The basic workflow is SQLExecutor -> GeometryReplacer -> Clipper with an AOI -> FileGDB.What comes out of the DB is the geodb_type which helps to determine features get routed either the polyline or annotation feature class. GeometryReplacer is used to convert from WKT so that features can be clipped with the AOI. From SQLExecutor, geodb_type has values (geodb_polyline, geodb_arc, geodb_annotation), but when it comes out of GeometryReplacer, geodb_type values are all missing. So after clipping, everything gets routed to the polyline fc, which will produce this error: "Cannot write a non-linear feature to a polyline feature class." [geometryreplacer_geodb_type.png] My workaround is to use GeometryFilter to route the features + a new AttributeCreator to hard-code geodb_type values to ensure the right features are created in FileGDB, rather than rely on geodb_type va

I can see the imagery on the inspector but don't see anything in the GDB package that would hold the imagery. The GDB package has ATX, GDBINDEXES, GDBTABLE, GDBTABLX and SPX files.

I am reading a record from a SDE geodatabase and using that record to create a new record. What is happening though is that it is just overwriting the old record. I need to have two records at the end. I select it based on an id and essentially need to make a copy of the record and then overwrite some of the values. Any idea of how I can do that?

I'm trying to connect to and access an MS Access database that has a password and I am getting the following error.   592021-12-20 15:02:42 | COM.safe.fme.jdbc.TableProbablyDoesntExistException: net.ucanaccess.jdbc.UcanaccessSQLException: UCAExc:::5.0.0 user lacks privilege or object not found: VIP I can connect and access another MS Access database that is not password protected without any issues. For what it's worth, I can connect and access data in the password protected database from FME Workbench on my local PC, just not from FME Server.  Thanks in advance for any suggestions.

I have an issue with my workspace using an Interlis Writer (ili2fme).It is running fine on my local machine, but not on a server where FME Server and ArcGIS Server is installed. Following error is listed in the logs: Writer `ch.ehi.fme.Main_1_FANOUT' of type `MULTI_WRITER' using group definition keyword `MULTI_WRITER_DEF'Creating writer for format: Swiss INTERLIS (ili2fme)Trying to find a JAVA plugin for writer named `ch.ehi.fme.Main'The class 'COM/safe/fmeobjects/FMEObjects" could not be located. Check your classpath and later in the logs: Translation FAILED.## A fatal error has been detected by the Java Runtime Environment:## EXCEPTION_ACCESS_VIOLATION(0xc0000005)at pc=0x00007ffd43921c11, pid=29404, tid=16240## JRE version: OpenJDK Runtime Environment (11.0.6+10) (build 11.0.6+10)# Java VM: OpenJDK

Hi, does anyone know how to fix the "Geom" field and turn it into appropriate coordinates? I downloaded the CSV file from the city of Vancouver open portal and ran it in the FEM workspace without changing any parameters, but I couldn't see any point features after. I was wondering if I should fix the attributes as the coordinates are within the same field? Thank you!

I have a list of codes (over 100) in a CSV and want to use a test for each code in a TestFilter. Is there a way to load them all at the same time rather than cutting and pasting individually?

Hi everyone I'm trying to make a web app that will be situated on our company VPS which is off course on remote server. We are running FME Server 2019 on local machine inside our company local network and is accessed through IP address. For the web app, I'm using some REST API code (I'm not an expert I must say) found in your "data-distribution-with-web-maps" demo where you set fmeserver url and token. Off course, setting those two is not a problem. I have also enabled CORS on FME Server. When opening webpage, web app triggers workbench but nothing happens and web developer error appears : Cross-Origin Request Blocked: The Same Origin Policy disallows reading the remote resource at https: ...As I have defined in JS file in web app, fmeserver url should start with http and by no means https protocol. I don't know if I'm doing something wrong. Has anyone tried anything similar and made it work?When using this app

Hi Folks - I am looking to use the API to get a list of all the Web Connections on the FME server. Has anyone done this before? Thanks

I know that the SharePoint List reader and the SharePointOnline connector are quite different from each other. Using a registered app on Azure worked fine for the SharePointOnline connector and its attached web service - but for the list reader, the web connection only required us to exchange the [TENANT] with our sharepoint tenant without changing anything else. This was working fine on our testing SharePoint platform using a non-personal user account to logon with. However, on our actual SharePoint platform, this trick does not work when using my own user credentials (it notifies me that the app needs admin rights) - and I am asking myself why. Does the user need to have certain rights in order to use the web connection? Then, as a second attempt, I followed the workflow here

I am trying to create an individual HTML file for each 'grouped by' polygon. I have the Fanout Expression set as per below with the attribute that is used in the 'group by' but I just get a single HTML file.  The attribute seems to be available to select but does not appear to be used during output. Is there something different I should be doing to get individual HTML files?

Well, it's time for all the latest FME news for the week. The FME World TourThere are many World Tour events still to come, as well as completed. The 1Spatial UK Tour visited London and tomorrow (perhaps today by the time you read this) is in Cardiff. They have upcoming events in Leeds and Glasgow too. Everyone was happy to be back in person again and

I would like to see if a value from a specified column/attribute can be counted into another column based on how many times it appears across multiple columns. I hope to do this for every feature/row of a dataset. Example of the data below : In this case, I would like specify the value in the DominantValue field, and I would like to see how many times this value appears in fields: AreaCount1, AreaCount2, AreaCount3, AreaCount4, Areacount5, and AreaCount6. The number of times it appears would be stored in a field called dvcounter. For example the desired output would look something like the below table: