FME Form

I'm looking for some help to use SQL in 'where clauses' for FME Readers.I'm trying to read from an ArcSDE database, using SQL operations like GROUP BY or DISTINCT. But I am under the impression that ArcSDE is not compatible with more complex statements than the simple terms like: equals/is null/not null/ in range / and so on. On the documentation page I read however: "Enter any SQL where clause that constrains the attributes of the layers selected in the layer list."  I have found the SQLCreator and SQLExecutor transformers, however these do not support ArcSDE format. I'm starting to think that the ArcSDE format simply does not suppport 'advanced' SQL querying in FME. Is this correct? So far I have found 1 alternative: a PythonCaller using these ArcSDESQLExecute functions from ArcPy. Could someone tell me if this is indeed the only workaround? Are there other workarounds? I've not found any further documentation on this topic, perhaps someone e

We have two FME server with same version.The .fmw are the same. We translate file from gml.zip to fgdb.zip.But the output of 2 zip files are difference in sizeThe files size in fgdb folder are the same.How can we set the FME server in order to get the zip file with same size 

Although the IMDF writer has a fixed schema, the option to copy attributes from another feature class is still available and will preform the action. However, when I try to copy attributes from any other dataset or feature type in the reader, they will appear as being added, but when running, they do not appear in the GeoJSON. Does there need to be some other process that will tell the IMDF writer to accept these attributes?

I am new to fme, I set up a processing chain to compare two shape files and I would like the output file which will be a renamed shape of the columns.for Example the file checked I have a column called depth_1 I would like the export ca to be depth_upstream.is this possible in fme ? 

Another post: https://community.safe.com/s/question/0D54Q00008is1jiSAA/why-is-the-download-url-not-being-returned-in-an-fme-server-app has already asked this question, but to date there was no definitive answer yet on that forum.  I included the "data download" during publish, so that is not the issue. It's just weird that the download link is not available in the workspace app, but is available when running the workspace from the workspace repository. Does anyone might know what the cause of it is?

I am building a simple regex expression which extracts the letters of the alphabet including the letters with accents. What I am having trouble with is using FME's regex editor vs the online one and the conflicts. The example below I have screenshots of regex101 online and FME regex editor and they both show different results for the expression:[a-zA-Z\\sčćđšž]+ I need help understanding why is this and what to do to get around this issue?Also, how do you apply regex flags?

Hi guys, I am fairly new in FME but have been working in a workflow and got stuck on something that might be simple solution for some of you. I need to be able of calculating the last calendar day of previous month from today's date. So today being 21/02/2023 my result should be 31/01/2023.  Can you please advise how I can do this ? I have been really struggling to do this and have attempted DateTime Calculator transformer.

Hello. I'm thinking about how to solve a filter that is defined on this data:- KASON DJL ?IBABA ?LUKID ?DIPIR ?KELUK ?KOVAR ?PAS PADCA NIFKU BANKO - applies here if the name starts without "?" (KASON) and somewhere in the string a name appears with a "?" (e.g. ?IBABA, ?LUKID.. ) and at the same time the end of the string is a name without "?", so remove "?" throughout the chain. The result is this KASON DJL IBABA LUKID DIPIR KELUK KOVAR PAS PADCA NIFKU BANKOThere will be more such definitions and combinations, does anyone have an idea how to solve it? A regular expression? Or a combination of some transformers?Thank you

Hi, How can I give 3d polygons the height of a base. The ground plane I created with the PointCloudSurfaceBuilder. The 3d Polygons have a z-axis with a value of 0.See the image, the polygons lie above the base and disappear below it.

Hello dear FME community members, I use the HTTPCaller with an output in HTML. From that output I want to get values from the HTML and get them exposed as attributes. Therefore I use the HTMLExtractor to extract the values of the CSS selector and return the output als a List Attribute.The result is that I see one feature with several listattributes. After that I want to explode the list with the ListExploder. The strange thing is that the ListExploder dies not see the List attribute. When I use a AttributeExposer and expose the list (list{}) then the ListExploder sees the list...a strange behavior!?!?  In several examples on the community the AttributeExposer is not mentioned or used to expose the list afther the HTMLExtractor, see an example: https://community.safe.com/s/question/0D54Q00008EcEOlSAN/how-can-i-isolate-html-table-values-td-based-on-attribute-name?t=1676911484807 I expected that the ListExploder sees the output list made in de HTMLExtractor. Is this a wrong assumption on

I have pull and transformed a series of table from a MS SQL Database. I am now trying to using FME to enter them into a specific sheet starting as a specified cell.  I feel like this should incredible simple, but I struggling to get it to do what I need.

Hi There, so our IT Department is now implementing a 'no password' policy with using our organization's (s)ftp sites. WinSCP does provide a method to use the key file generated by OpenSSH (please see attached screengrab)...but I can not see a method for leveraging this file in FME's FTPCaller...is this true? (so no way to do this in FME?). Thanks for any thoughts here.

If I have addresses in an address field formatted for example:1234 Elm St ...and I want to remove all spaces to change the field value to look like this:1234ElmSt What Transformer and Parameter would I use?

Hi There, So I am using the: safe.microsoft-sharepoint.SharePointOnlineConnector to download and create .xlsx files in my organization's SharePoint site-- and this transformer is awesome save for one fatal problem...the problem is that the connector only appears to be able to Download or Upload/Overwrite files--but it can not Update existing documents at SharePoint. And the problem is that if a user has the .xlsx document open (in a browser session) the Upload will terminate / fail until all users have closed out of their browser sessions viewing the document. My question: is there a way to Update documents at SharePoint that are being viewed, or is Overwriting the only option. And if the latter is the case, is there a way to terminate all open user sessions of the document at Sharepoint so that the new version can overwrite the old version...Otherwise this transformer, great as it is, is somewhat useless. Any thoughts on this issue, or is it just another "Curse you Bill&q

 how can I separate the data into separate columns? E.gDate                         Information           result 2023-02-20 07:24:00         inform             Current FME version: FME 2022.2.0.0 (2022110) 

I am trying to automate creation of highway markers along a highway line feature class. I have been able to create the points along the highways at the correct interval (Using the DistanceMarker transformer) but I can't figure out how to apply the correct distance along that line (in Kms) to the newly created points. Ie. 2km, 4km, 6km, etc. in an attribute for the new point features.

Hello,i would like to transform a .csv list which contains adresses with a given latitude and longitude to dxf/dwg file into my local coordinate system (AUT-GK31-5). The exported dxf/dwg should contain a point with the transformed coordinates. thank you for your help - i am working on FME workbench 2019.0 input: (wish) .csv or excel lat: xxxlong: xxx(text: xxx) output:dxf/dwgpoint: (correct transformed coordinates - AUT-GK31-5)(point-text:xxx)  Christoph

I have one feature, which has two geometry points with text location. I only need one of them. Is there a possibility in FME to delete every geometry, except one?

Hello,As the question group suggest I am new to FME. ATM am doing some test with a .LAZ dataset (825 tiles about 60km X 60km)1-What I want to do is read in the folder were the LAZ files are and read in a shape file (the 60x60km box). 2-clipper, to only use the LAZ tiles that are within my polygon.3-RasterDemGenerator to create the raster in this case a DSM because there is no filter).4-write to .TIFThe main problem here is processing time. I am new but I feel I need to do something about the processing time so I looked up what I can do about it.1 Tiling. If I understand correctly, I can create 7 workers from a main project. So, in my case dividing this project in 2x2 or 4x4 (3x3 would already take 2 runs so logically 4x4 would be my next choice).2 parallel processing. I tested https://community.safe.com/s/article/parallel-processing this but even on extreme I only see 2 FME Object Worker EXE in my task manager.I have a Esri data interoperability license (2x). A)     What I like to know

Dear Altruists, I am trying to convert NetCDF evaporation data to further processing, e.g. aggregate by month or calculating average value etc. However, I am struggling in the basic steps to unfold the multidimensional variables. When I am reading the data in NetCDF reader, it returned some attributes where I cannot see the lat/long or date file. But after using AttributeExposer to get the netcdf_subdataset_name; there I see lat, long and evaporation (apet) name but not sure how to get the values of these variables. I am given a python code in which the developer wrote a function to process the .nc data. Can anyone kindly tell me what FME transformers I need to use the replicate the python process as below: def funt_1(fileName, points, var):  nc_fid = netCDF4.Dataset(fileName, 'r')  prbc = nc_fid.variables[var]  lats, lons = nc_fid.variables['lat'], nc_fid.variables['lon']  time = nc_fid.variables['time'][:]  # Convert time to Julian  Y = int(nc_fid.var

Writing to an Esri Geodatabase (File Geodb Open API) fails with this error: ‘Geodatabase Error (-2147219115): The row contains a bad value. There's an empty table created instead of a point layer.The error suggests that something's wrong with the schema, but I can't find the cause. The issue stays even with only one feature and limited number of attributes.Writing the result to a shapefile or to SQL works fine. FME version is 2022.1  Anybody had similar issues with the Esri Geodatabase (File Geodb Open API) writer and knows how to solve this? Thanks, Ruth  

Hi all, I have an "issue" that is frustrating me to no end (probably because the answer is more simple than I'm making it), so I thought I'd run it by the community. I have a workbench where I am taking AGOL features and converting them to a dwg. The AGOL geometry that is giving me issues are the AGOL polygons after they are sent through a CLIPPER:  I understand why the 'RESULT' is passed through the CLIPPER and spit out as polygons still. And I have them also going through a GEOMETRY COERCER (to fme_line) and even a LINE ON LINE OVERLAYER -- all good to this point.  What I cannot figure out is how to remove the unwanted lines to obtain the "DESIRED RESULT", which would just be lines once they get into AutoCAD. There doesn't seem to be an attribute that I can use to differentiate whether the line came from the original polygon or if it is a result of the CLIPPER 'changing' the geometry (all geometry has the attribute "_clipped"

When publishing a workbench to FME Server under my username and configuring it as an automation or schedule, what is the best practice as every time my username requires a password change the automations/schedules fail. Then one has to go in and modify the connections to update them so it will accept the new password. We are using AzureAD.

I have a StatisticsCalculator that determines the min and max time values in a data set. If I feed the time.min and time.max into a TestFilter to filter out values from another table which are outside of the time.min and time.max range, the filter doesn't filter properly but if I use the actual time value is does. What do I need to do to get the TestFilter to work with the FeatureAttribute?