FME Form

Hello!I'm trying to use the following to find the position of a character/string in one of my attributes:@FindString(@Value(ColumnName),TEXT,1,caseSensitive=TRUE)When I replace TEXT with the text I am searching for, this works as expected, except for when the text to be found is a parenthesis, i.e. ( or ). In that case, the function interprets the parenthesis as the start or end of the function's arguments. I tried to escape the parenthesis using a forward slash (as suggested by the FindString() documentation to escape a quotation mark) as well as by surrounding it with quotation marks (as suggested by the FindString() documentation to escape a comma), but neither of these work.How can I properly escape ( and ) inside the function arguments?Thank you!

I have a single fixed license that I use for development work and a floating license that I use for production work. How can I easily switch between the two? Right now I have both added, and when I'm off network, it takes FOREVER for FME to presumably timeout with the floating license and try the fixed license.

FME Desktop 2020.0.0.0: What is the best practice to fix issues identified by “geometry validator” tool? For example, in the screenshot below, I got 1 failed, 4 invalid, 5 locations. What could be the best practice to fix them? The data is attached      

The question is about , the process of transferring FME Desktop licenses from one department to an other in the same organization with two different license servers. Do we need to give the license that are being transferred back to Safe again and ask a new licenses on the same account? Are there differences between a floating an single fixed in this operation? Are there other things to take into account in this operation? Thanks in advance.

using neighborhood find we need the workspace when the candidate find the base we don't want this base to be used again in the process even if it fit the transformer setting Ex: I have 4 polygons and 5 Points we need to find a point within a distance of 1 m to polygon, 2 of those points are within the distance, our goal is the process when we found the first match the second one should not be considered the parameter( number of neighbors to find ) is not working since each point will find 1 neighborhood, if one point find polygon, that polygon shouldn't not be used by another point Thanks 

I try to make a setup of a script workbench and a runner workbench. The script consists of a postgis feature reader and a gdb writer. The schema of the postgis feature reader is defined as a user parameter, and so is the destination of the gdb writer. The runner consists of a Postgis reader that reads a table containing schemas and paths for the gdb, and a workspace runner that runs the script and defines the user parameter mentioned above using the schemas and paths from the PG table.  However i just this error when trying to read the table of the schema: "021-12-21 12:53:57|  0.1| 0.0|ERROR |Error executing SQL command ('select * from "FME_PostGIS_SCHEMA"."DF_Mast" where false limit 0'): 'ERROR: relation "FME_PostGIS_SCHEMA.DF_Mast" does not exist" So it just inserts the name of the user parameter rather than the actual schema it was support to insert.  I hope you can help.  Regards Rasmus

I have a workspace with a single 3D model (a tree) and a point dataset of several thousand points. Is it possible to replicate the 3D model and geo-reference it for every point?

Data:

I'm trying to schedule a flow based on an end user's chosen start time (which they'd pick and submit via an FME Server app). To do this, I've built two flows: one that takes all the parameters (including a scheduled start time) and has a server app built in front of it; and a second one that actually does the heavy lifting and is either called via a webhook or is scheduled by FME Server. I've tried to be clever and set a HTTPCaller at the end of the first flow to initiate a new once-off schedule in FME Server, but it's always failing with this error message: "message": "Unauthorized request by user admin due to lack of proper permissions or the object does not exist."Any ideas? Or even thoughts on better ways to do this? 

FME Desktop 2020.0.0.0: What does “untouched” indicate for in the “geometry coercer” tool? For example, in the screenshot below, I got 3 features as “untouched”. What does this indicate for? The data is attached      

I am importing landxml file that has alignment(s) with stationing. I'd like to view the alignment(s) with stationing labels including tick marks in the Graphics window. Is this possible?

Hello. I am trying to run a bunch of online and zipped INSPIRE GML's through a Feature Reader with the dataset parameter set to a URL defined in an attribute.  All is good and stuff is happening for most of the data except the URL's that have a space in them, for example: 'http://www.catastro.minhap.es/INSPIRE/CadastralParcels/02/02024-CASAS IBAÑEZ/A.ES.SDGC.CP.02024.zip' And those get sent to the reject port with the error message: XML Parser error: ''Error in input dataset: 'URL' line: 1 column: 50 message: whitespace expected'' I did check out this one here:How do I remove a non breaking space from an attribute? (safe.com)But no luck , so any ideas?

Hi,I'm looking for the best way to combine raster-DEM data with construction point cloud data (exists only at some places, not covering the whole DEM ) to output a new modified raster DEM. The point cloud data contains vertexes from the construction (which means it also has ground points - but I'm only interested in the surface, where it overlays the DEM). The point cloud has no info saying what type of point it contains. Can this be modeled in a way that only uses the surfaces from the two datasets or do I need more steps than one in this analysis? Any suggestions?

I have polygons on wich I want to calculate some edges infos. However, I want to do the calculation on generalized edges and after bring it back to all orignal edges. For instance:Polygon -> edge -> generalized edge -> chopped to 2 vertices lines -> calculate attributes on lines -> merge attributes to original edges Is there a way at the end I could merge attributes from the generalized line segments to the original line segments? 

Hi,We have just upgraded from Desktop 2019.1 to 2021.1 and I can no longer view the cached data when the FME_TEMP local variable is pointing to one of our network shares, I have changed the local variable to a few of our shares with the same result. If I change the local variable back to the local C:\\temp area, 2021.1 version works fine and can view cached data again. I have tried this with 3 users on the network and all are getting the same result. Version 2019.1 is still working fine, caching the data to the network shares?? Any help would be greatly appreciated. Thanks Brendan

FME Desktop 2020.0.0.0: The “clipper” tool fails to proceed and gets stuck, I couldn’t figure out why the “clipper” tool fails to proceed and gets stuck, What could be the issue here? The workbench and data are attached            

It seems as though the SchemaMapper is setup for only If-Then statements. I'm wondering if there is perhaps a way to use the SchemaMapper by way of a Contains statement.  For example, if Attr1 contains 'xyz', make Attr2='123'. I don't believe this is possible, but was curious if anyone found a work-around to make it work.

I have a URL that allows me to anonymously download from Dropbox that is successful in browser but I cannot figure out how to use a non-authenticated connection to Dropbox in my DropboxConnector in my workspace. The files are not in my Dropbox account, but in another account and I only have an open URL to download them. Any ideas how to connect to Dropbox anonymously or without a authenticated web connection?

Hi. I have a xlsx file with a field containt Path to a PDF. I want to validate if the PDF of the path exist. Can you help me. Thank you.

Hi everyone. I have a XLSX files with field for the name of a PDF. I have also a folder with the PDF. I want to compare if all the name in the XSLX file have a PDF on thr folder (with the PDF). Thank for help :) 

Hi Team,While synchronising the data between 2 enterprise GDB (2 separate SQL Server virtual Nodes) getting following error and terminated the FME process. Error info:2021-12-10 10:13:48| 281.5|197.2|ERROR |Error while updating feature in the table/feature class 'DBO.DESIGN'. The error number from ArcObjects is: '-2147207419'. The error message from ArcObjects is: {} Note: There are not indexes, constraint rules on Both DBs. Kindly assist us. RegardsVIPLAW

Hi,  After converting the tif to ecw, ecw always comes with a background. I don't see the background in FME inspector or ArcMap, but there is always a background in Smallworld. Is it a way to remove the background colour of the ecw?

Hello, I am attempting to test if an input date exists between a date range - I'm struggling to find the correct syntax or transformers to do this (after 40 minutes of trying). Can anyone help? Currently my input is to AttributeCreator the time for now - @DateTimeFormat(@DateTimeNow(),%T)Then so far I have used a Tester to see if it was greater or less than two times e,g, >= @DateTimeFormat(09:00:00, %T) OR <= @DateTimeFormat(09:05:00, %T)But predictably this doesn't work as it will always be greater or less than one or the other. I would like to use BETWEEN (if I was using SQL).Is there an efficient way to do this in FME? Other than converting the time to a number (which would mean regex-ing the leading '0' up to midday) and then comparing numerical values in a (presumably) AttributeRangeFilter?Apologies if I am missing something basic! Help very much appreciated 🙇‍♂️ 🇬🇧

I have an AIXM 5.1 file which clearly states at the beginning that the encoding of the file it is in UTF-8. However, when I use the AIXM 5.1 Reader suddenly all my attributes are in UTF-16LE which is not what I want. I could use the AttributeEncoder to change everything back to UTF-8, but that seems like a waste of time as my data was good to start with. Also is my geometry converted into XML and reading that will give errors as declaration inside the attribute is then UTF-16LE while I converted the attribute to UTF-8.