FME Form

I'm trying to format a human readable date time and I want to include the seconds but nano seconds are a bit much.  As far as I can tell there is no date time flag which is just seconds without the fractional seconds so it seems like you need to remove them with a non-datetime tool. Am I missing something? Date times were created using the DateTimeNow function.

The same geotiff is placed differently in QGIS (3.22) and FME (2022). QGIS is placing it correctly, or at least as intended by the publisher, and shows a cellsize of 2x2m. FME is setting the cellspacing at 0.1x0.1m. Can somebody explain the difference in interpretation? And possibly how to fix it in FME - in general, not via georeferencer?The original file can be accessed here: https://drive.google.com/file/d/1b9Euqly7DPwwYzEvLNqWj1JgxAGbTBqI/view?usp=sharing/Mathias

Hi, I have 3 polygons. (Print screen; purple) Project A, Project B and Project C. The polygons overlap. In addition, I have another layer consisting of polygons. These are roads. (Print screen, gray). Now I want to assign the project name to each road object. So if a road belongs to 3 projects I want to get 3 road objects, each with a different project name. How do I do that?With a spatial relator, the road section that falls within 3 objects gets the same project name 3 times instead of 3 different project names. Clipper does not clip on al the 3 object bounderies.    

I have a huge dataset and I want to make writers based on type. Some types have only 1 samples, some have 100, and I would need to remove all empty sample-columns from all writers. There are over 100 types, so manual work is out of question. I have tried to use NullAttributeMapper and set all values to missing, but how to drop them before writer?

I have noticed this crop up in a few different workbenches since upgrading to a new patched version of data interop 2021.1.2.0 (20210903 - Build 21627 - WIN64). The only solution so far is to run/cache the workbench in sections. Have tried re-installing. Plenty of storage available in the temp directory. The fatal error occurs after saving the cache to the temp directory (but not every time): "Saving spatial index into file...""Finished saving spatial index into file...""2022-02-15 20:43:31| 56.5| 0.1|ERROR |A fatal error has occurred. Check the logfile above for details" It should say "Stored ### features(s) to FME feature store file...." instead of the error message. Anyone else encountering this?

This topic has neen discussed before, but im at a loss. I cant understand why, if an attribute exists in a shapefile, its not added to the list of attributes. I can though, see them in the preview, under the list of available columns.The issue comes, when I am trying to validate the attribute, it dosent exist!, I use the attribute exposer, but all the attributes are blank.Please any help appreciated PS: I have found a work around, If I load individual bulk loads for each dataset type (30) I can load all the ATtributes correctly. This is not ideal, as I now have 30 readers instead of one..

I have a file like the example in my hand. There are photo midpoints in the file. I make useful models for stereo drawing by using them. How can I create these areas automatically?Attached is a sample file and picture.model-1 and model-2 created by manuel for example.

I have three polygon shapefiles, they all contain a column called GUID, this column is unique, the shapefiles often overlap.  I also have a point shapefile, these points will generally fall within 1 or Many polygons.  I am trying to end up with a table similar to the one shown in my sketch. Each point feature should have one or more GUID in it... I am sure there is a simple process to do this in FME, currently I have an overly complex looking scenario that isn't working, I am really over thinking this one.  

I have an an attribute in my table that is type 'string', and I am trying to work out how to associate a code to each of these different attribute types so this code can be used in the next transformer. See screenshot, for example I have added red text, so for POTHOLES, I need to feed the integer 70 into my HTTP caller, for SEAL OVERLAY I need to use the code 105 in my HTTP caller and so on... I am unsure how to set these codes for each of my unique values. I was about to create a new HTTP caller for each of my different attributes and hard code the variable, but I know that would be a terrible idea as I should be able to code this better.  Have I explained this well enough to understand? I'm having a hard time describing it! 

The FME is upgraded to Build 22311: How to align points converted from texts  as per their (texts) alignment in AutoCAD table? In the screenshot below, texts contained in an AutoCAD table are “middle right” aligned. How to keep this alignment as they are converted to points so that they are kept vertically aligned? The dwg file is attached           

I'm new to FME and I've found a couple different coordinate systems that will produce different results. Primarily I will use Reprojection to US48-DUKE before any of these tools but I'm not sure what the community would say and maybe have a better answer? Thanks!

I am running a workspace with SDE readers and writers. It has designed to run on one market. I need to run the same workspace on other markets with a new database connection and I was wondering if I could set user parameters to input SDE connections and it will change data in feature readers accordingly. I tried to create a user parameter that allows users to create a database connection, but it did not change the connections in Feature Reader. I still see my old connection. 

When I convert a GeoTIFF to ECW, the bright colors of the GeoTIFF are not preserved in the ECW output. Is that possible anyway, to convert it and preserve 100% of the right colors? Searching the knowledgebase, I have found some directions to a solution: How to preserve exact colors in raster conversion .ecw to .tiff? (safe.com) But in the end, how could it be done? Does someone has experience with it? Find examples below of the original GeoTIFF and the ECW output.the faded example is the ECW filethe bright colored example is the GeoTIFF file

I have created a 32 bit DSN ODBC connection using the progress/openedge 11.7 driver which connects successfully. I am trying to then connect via FME 2020.2 and choosing the ODBC option to connect but I am getting a message returned as follows?The specified DSN contains an architecture mismatch between the Driver and Application 

FME Desktop 2022 Build 22311: The AutoCAD “island detection style” property appears not to be available in FME, I wanted to filter based on “island detection style” type (normal, outer, and ignor) but appears that this property is not available in FME     The dwg file is attached

I have a basic workbench where I have points stored in an ESRI ArcGIS Online Point Feature Layer, and I have an ESRI Enterprise SDE Polygon Feature Class. 99% of my AGOL points fall within a SDE polygon.  I have created a simple workbench with two readers (AGOL and SDE as previously described), as my screenshot shows, the points fall within the polygon areas, but the tool is not returning a single overlap whereby a point sits on a polygon, yet the screenshot clearly shows the point within the polygon. See '_overlaps' column in screenshot are all 0 Is there something basic I am missing? I just want each point to have an attribute outlining the polygon it is within.  

Is there a way to read and write the .ovf file format of orbithttps://kb.orbitgt.com/209/technology/supported_formats/vector/ovfThanks

I am trying to do something that seems completely benign, which is to aggregate CAD file features by their filename. Instead, it gives a generic error after processing the 6 dwgs selected. Please see the attached log file, which was created with debug on. Any ideas? Is this something you should not do in general? Using just a REAL DWG Reader and the Aggregator. Any insight is appreciated.

I am trying to ETL an LRS-enabled routes layer currently stored in a Geomedia database into a ESRI format that is consistent with typical LRS operations like dynamic segmentation.  The issue is that the fundamental data models that handle measure values within a calibrated route network are different in the two software packages.  In Geomedia, routes are segmented into a series of features (or rows), all of which share a common routeID, and all of which have (as exposed attributes) begin_measure and end_measure. Unlike in the ESRI world, the measure values are not stored in the vertices but in the attributes.  Question is... how do I use FME to efficiently move measure values from attributes of lines in Geomedia data into m values within vertices of lines in ArcGIS data?  Thanks in advance... Adam

Hello, How can I utilize a User Parameter in the SQL To Run After Write? I have a User Parameter (Text Value) with a default value of parcels@DateTimeFormat(@DateTimeNow(),%Y%m%d)  The parameter works when setting the table name for the new table in the DB and the table is properly created: But when the user parameter is used in the SQL To Run After Write, it causes an error. Is that because the value of the User Parameter contains formatters? This line in the SQL:UPDATE '$(ImportTableName)'(I've tried with and without the quotes surrounding the parameter, btw) evaluates to this in the console (and the SQL):UPDATE 'parcels@DateTimeFormat(@DateTimeNow(),%Y%m%d%H%M)'How can I use this parameter in the SQL? Alternatively, how can I utilize a name that is generated at workspace runtime for the table name and subsequently reference it in the SQL?

Hello there we looking to calculate the distance between 2 opposite buildings across a street, if we use a neighborhood finder it will not work Any idea Thanks 

Hi, I have a ground geometry like this:So this is an aggregate feature, based on faces! Now I will resolve this into a polygon like this: it is not working with Aggregation based on building_id of the buildings! Than I have an aggregate feature like in the first picture  Is this kind of transformation possible? 

 Hi, I am using a pythoncaller in FME to convert the KML color from the linestyle (a string, hex ABGR) to a C# Color (ARGB 32 bits integer) (see workbench)  KML doc Colorstyle (https://developers.google.com/kml/documentation/kmlreference#colorstyle): For example, if you want to apply a blue color with 50 percent opacity to an overlay, you would specify the following: <color>7fff0000</color>, where alpha=0x7f, blue=0xff, green=0x00, and red=0x00. (ABGR !)   With FME Desktop under Windows (2021.2.4), this works well. => 2022-03-29 18:00:28|  0.6| 0.0|INFORM|Attribute(32 bit integer)     : `line_color' has value `-16733441'    Running this workbench on the Linux FME server (docker install!) gives different results. => 2022-03-29 16:01:14|  0.2| 0.0|INFORM|Attribute(64 bit integer)     : `line_color' has value `4278233855' I have some questions here: 1) Why does this happen?2) How do I solve this?3) Is there a more elegant and consistent way to accomplish

Hi all,Is there any way to extract the area and length attribute from the cad file.I tried AttributeExposer but i couldn't extract area and length..

hello, I am deploying a script which uses InlineQuerier Transformer which executes SQL queries against xlsx files "coming" from another system. Everything works ok when FME Server is installed on Windows env, also works ok in FME Desktop on my Windows laptop, but when I deploy the script (and execute it) on FME Sever (from Linux environment) I receive following errors:   2022-3-30 15:51:09 | Remove_tasks_already_assigned (InlineQueryFactory): Error preparing database query: near ",": syntax error Unable to execute statement2532022-3-30 15:51:09 | Remove_tasks_already_assigned (InlineQueryFactory): Database was unable to prepare query 'SELECT2542022-3-30 15:51:09 | *2552022-3-30 15:51:09 | FROM2562022-3-30 15:51:09 | "Failed"2572022-3-30 15:51:09 | WHERE2582022-3-30 15:51:09 | ("CALL__T","ACTION_NO","CREW","EVENT__T") not in (select "CALL__T","ACTION_NO","CREW","EVENT__T" fr