FME Form

I am doing the completion date subtracted by number amount(200 days) using Subtract Interval or Interval between dates using the completion date - DateTimeNow. the FME rejection code is INVALID_INPUT. Any suggestions is greatly appreciated

Can we migrate the data directly to Esri UN model geodatabase instead of migrating to Asset Package GDB, using FME Desktop?

Hello, I have a dataset that looks similar to the image shown and I need to create the value in the attribute ROUTE shown in red. I need to create a new value for ROUTE whenever Duration>1 or Duration is Null. The data needs to be sorted firstly by Name, then by TimeStamp. Then, whenever the previously mentioned condition of (Duration>1 or Duration is Null) is met, a new value needs to be created for ROUTE. How do I create a new value (with for example a new sequential number) whenever I come across (Duration>1 or Duration is Null) in my sorted data?

Just a minute ago I did discover something I did not know yet: it is possible - to my surprise - that it is possible to retrieve a password stored in a User Parameter using a simple ParameterFetcher! Passwords stored in User Parameters are encrypted (see e.g. this post), but the ParameterFetcher just returns the decrypted password in plain text... :-( So everybody with access to a workspace with passwords and FME Workbench can just use this fetcher to retrieve all passwords. OK - maybe I have been a little naive... :-) But this is surely something to take into consideration.

I have a logfile I need to extract some info from but I'm not sure what to use. Here's an example of what I have. <Msg time="2023-06-05T19:55:23,511" type="INFO" code="9029" source="Rest" process="35236" thread="1" methodName=""

Hi, just wondering if anyone can interpret this log message for me and tell me how to change the workspace encoding under Windows, if that will help. Thx! (am including all the software version details for reference) Starting translation... Current FME version: FME 2022.1.1.0 (20220728 - Build 22623 - WIN64) FME_HOME is 'C:\\Program Files\\FME\\' FME Desktop Smallworld Edition (floating) Permanent License. Machine host name is: FBC-19-0068l OS Locale Name : en_US OS Locale Encoding : windows-1252 Process Encoding : UTF-8 FME API version: '4.0 20220615' FME Configuration: FME_BASE is 'no' FME Configuration: FME_MF_DIR is 'I:\\GISSBX\\ELECTRIC\\FBC_010_CA_Dashboard\\MXD/' FME Configuration: FME_MF_NAME is 'Condition Assessment Dx.fmw' FME Configuration: FME_PRODUCT_NAME is 'FME(R) 2022.1.1.0' Operating System: Microsoft Windows 10 64-bit (Build 19044) ... The workspace was authored with a system encoding of 'windows-1252'. This will be the encoding used for names in this translation. Re-

I have SQL SERVER DATA where ii need to migrate views only to Snowflake is there any way to create the views in FME and migarte data SQL Views to snwflake

I have a polygon (shp or minfo format) assuming it has an area of 5 square miles. Need to reduce the area by 70% resulting to 3.5 square miles now but still keeping somewhat the outline but of a smaller size (like polygon output shrinks) due to the applied percentage. SCALER transformer is closed to what I need but it only applies the percentage to the total perimeter of the polygon and not the area. Any transformer that could do this?

Hi, I need to calculate the least-cost path from a destination point to a source. In ArcGIS I use COST PATH based on the least-cost distance raster (by Cost Distance tool in ArcGIS). is there a way to do something similar in FME? is the Network cost calculator transformer appropiate? Best regards, Felipe Verdú

Hi, FME community I hope everyone is doing great, I am creating 3d tileset for cesium js and it is getting created successfully, but when I am using 3d tile validator tool(cesium team has implemented a validator tool here https://github.com/CesiumGS/3d-tiles-validator) then I am getting my tileset is invalid because of some errors, I do not know how to overcome of these errors using FME, please anyone if knows how to fix these errors, please let me know. please find the errors below:- "type": "CONTENT_VALIDATION_ERROR", "path": "data/data7.b3dm", "message": "data/data7.b3dm caused validation errors", "severity": "ERROR", "causes": [ { "type": "BINARY_INVALID_ALIGNMENT", "path": "data/data7.b3dm", "message": "The byte length must be aligned to 8 bytes", "severity": "ERROR" } ] }, { "type": "CONTENT_VALIDATION_ERROR", "path": "data/data6.b3dm", "message": "data/data6.b3dm caused validation errors", "severity": "ERROR", "causes": [ { "type": "BINARY_INVALID_ALIGNMENT", "path": "data/data6

What would be the most convenient technique for querying data stored on Azure Data Explorer (ADX) from FME Workbench? Should this be done via a HTTPCaller?

But I cannot find the proper way to do it here. I am sure it shouldn't be complicated but I am new to FME with thousands of questions. This is just one of them 😅

HI. I would like to ask FME team about how to see the contents of storage inside of FME flow, and how to manage/delete the storage (temporal storage or primary disk) of FME flows. I would like to reduce unnecessary payment/charges, so please kindly let me know. Thank you.

I am working with two datasets and I am trying to use Spatial fuzzy matcher to find if there is a similar name nearby within the mentioned distance in this transformer but wherever the fuzzy ratio is 1 it is not there. EG : here I am tryimg to find if there is 'Heavy inlet' in another dataset or similar string, it has mentioned its fuzzy ratio as 1 but there is nothing similar to this near or in the entire dataset. :

I have some floor plan DWG drawing with gaps (walls) between the rooms. The desired result is to make it simplified floor plan, i.e. keep just one line between the rooms. There are hatches that forms the basic shape of polygons to begin with. So far I could get rid of gaps by buffering twice (positive and negative), dividing overlaps and dissolving small artefact sliver polygons to bigger ones. Later snapping the segments. The result is more or less satisfying, I just wonder if there's more elegant solution. For example the snapper (segment) doesn't maintain the orthogonality and makes "crooked" lines... Thanks for any suggestions.

Is there a way to easily pull all of the SQL statements out of all of the SQLExecutors in a workspace? I have several automations that I need to do this for and some of them have hundreds of SQLExecutors in them.

I am trying to update a feature class containing statistics. Basically i am using the following fields fme_basename fme_featuretype and each value from the fme_db_operation (insert, upsert, update, delete etc) is the number of each my problem is, that if there are no deletes i get no features coming through as expected, but how can i still send through the fme_basename, fme_featuretype, and for example the value of zero for the delete attribute. I want to be able to add the total records, but obviously can not do that if there is no value, hence setting as zero. From what i have, if there are changes then they go through the workflow as expected. Regards Andy

Hi FME, I have a dataset with date/time stamps where I need to retain only the first occurrence in each hour, on a given day. For example: 1/1/2000 12:05 --> Keep 1/1/2000 12:10 --> Discard 1/2/2000 12:05 --> Keep 1/2/2000 12:15 --> Discard 1/2/2000 12:59 --> Discard 1/3/2000 12:00 --> Keep 1/3/2000 12:12 --> Discard Thanks for taking a look!

Hi! I have an issue that I just don't understand. Using a FeatureMerger that outputs the correct attributes från the supplier, but it's values are all wrong. First off, I have a TestFilter with output ports depending on if the attribute "Version" is 0, 1 or 2. In this case the output for Version 2 contains 4 points with relevant attributes according to the image below. They are all "Version" 2 and have missing values for "Avslut-datum". Next, I want to use a FeatureMerger to merge this with a bigger database with hundreds of points, to assign the attributes of Version 2 to those said points, if they match. I want to merge the points from the bigger database [requestor] to the output from my "Version 2" [supplier]. See the FeatureMerger parameters in the image below. However, the merged data does not contain the attributes from "Version 2". For example the attribute "Avslut-datum" should be <missing> and the "Version" attribute should be "2". Note that the attributes "Version" and "Avsl

Hi there. I'm preparing our GIS data to adjust to align with new cadastre boundaries when our state mapbase is updated as part of the Digital Cadastre Modernisation. So far with testing it all looks good, but I see one polygon on one the layers has disappeared in the shifted version. On investigating it looks like the adjusted parcel this features sits on looses a few vertices in one corner and the shift vectors being used possibly cause a self intersection. I've attached the example. On the left, the grey is the current parcel boundary and the purple is the shifted, with the shift vector joining. On the right is the particular layer that aligns with the boundary that is disappearing post shift. You can see the shape of the parcel changes and it looks like the shift vectors would cause a self intersection. Just wondering if there are any ways to avoid this? I can see a record in the output data but no geometry, or an invalid geometry. Thanks in advance. Josh

Hello, I'm using a customized projection system that is exported to other official projection (Lambert 93, Lambert zone 2...) and I would like to run these transformation within FME. For ex, here are the steps going from 2154 to my custo projection: Prime Meridian Paris to Greenwich then: {LambertConformalConic: a=6378249.2 f=293.4660212936269 lat0=46.799999999999955 lon0=2.337229169999998 k=0.99987742 (inv)} {GridShiftTransform(NTv2:rgf93_ntf.gsb (Inv))} {LambertConformalConic: a=6378137 f=298.257222101 lat0=46.49999999999996 lon0=2.999999999999997 k=1 } {AffineTransform2D(ScaleXY(1,1) Rotate(0) Translate(700000,6600000))} How to define this in FME?

I am trying to use the Geodatabase_SDE writer to publish some content on Workbench to our Enterprise Geodatabase environment. However, when i add the writer to my workbench and browse the list, i find that the Geodatabase_SDE writer is greyed out and there is a popup that indicates i do not have sufficient licensing. For reference i have an ArcGIS Advance License that i use on the daily, and both FME and ArcGIS are using the same License Server. The message doesn't specify if i am missing the ArcGIS or FME licensing to use this writer. Any help is appreciated so that i can move in the direction of progress. *I am not our ESRI software Admin, but want to make sure that when i reach out i don't slap myself on the forehead because it was something i missed.

Hello , i have geodatabase data as input ,it includes different points ,lines ,annotations . I would like to read this data in FME workbench and filter specific data from them for city then write the output again into new geodatabase writer . my problem : when I use spatial filter and use the specific city as filter and the geodatabase data as candidate . so the passed port include all data together and for sure not each input has the same attribute names as other . How could I write the output for my data (passed port ) into geodatabase format and each writer includes only his own data without any problem .

Is there a way using a regular expression to split a string of text such as an address by a number of words/spaces? Or even more functional, split a line at the first space after a certain number of characters?