Authoring

After installing FME on my computer, all of my files have defaulted to open in FME. For example an xlsx will now open in FME unless I specify that it should be opened with excel. Any suggestions on how to resolve this issue?

Find the points on a polygon that are perpendicular to a line as in the screenshot.Existing features are the polygon(s) and line A. Pts a and b are required.Thanks very much for any help and ideas.

Upgraded to FME 2023. When writing to SQL server database, Bulk Insert = 'Yes' results in features dropping and not writing to DB (even though the correct amount of features are listed in the Total Features Written message). If I set Bulk Insert = 'No', the correct number of records write to the DB but one of the nvarchar attributes is empty in the database. Everything looks correct in the final inspector prior to writing. This is using workbenches originally created on 2022.1.2.0, Build 22627. New version of FME is 2023.0.0.3, Build 23319. I reran workbenches on 2022 and it's working correctly

Hi I need to download data for difernt municipalities but when I have a name with single quote (like Catsell'Arquato) the tester In failed   So how can escape single quote ThxFrancesco

HiI would like to filter/resample (I don't know the FME terminology) a point cloud based on spatial distance.In short I would like to obtain a new point cloud where I have 1 point every 2 cmWhich is the best transformer ? thx Francesco

Hello. We have floating licenses in our office so they keep rotating time by time.I have created a batch file for running a workbench with multiple workspace runners in it. Now, when I run the batch file and if by chance, no licenses are available that time, what will happen? Will my workspace go in an infinite loop till a specific timeout or will it try to trigger for acquiring the license every 1 minute or so and then start running the workbench?This actually matters more because there is an AWS machine which turns on on a scheduled time and triggers the batch file on startup. The workbench starts running by itself. Any suggestions/ideas on this? If this is not possible, any alternatives other than FME server since it is the last approach that we will go for as of now. Thanks,Shivam

Hello everyone, I am trying to use a SQLExecutor with embedded connection parameters provided by some published user parameters. Here's an exemple:After saving the SQLExecutor parameters and reopening it, it seems that the last parameter (password param, i.e DB_PASSWORD) is not being persisted:At first i thought that it would not affect the connection parameters (i.e. maybe an small UI bug), but that's not the case since the SQLExecutor did not use the provided $(DB_PASSWORD): This is a local test, but i have similar results when targeting prod servers.Interestingly, this happens on

I get status 502 when trying to publish a workspace to FME-server. The script works perfectly fine when running it locally on my computer. Have tried searching but can't seem to find any helpful information. What could be the problem?

I'm working with some large DTM datasets and am killing my machine with the clients requested settings. I wanted to see if this "Surface Model" file could somehow help me process the data in batch. The documentation looks promising, however, I've not really had much luck when testing it and there are no examples anywhere I can find of how to actually use it properly.

Hi, this question has been asked previously in the old forum but I couldn't find any answer.  I have a workspace that writes an Excel file. The destination dataset uses the value of a published parameter to set the output filename. e.g. DEST_DATASET = $(PROSPECT).xls  When running the workspace on the desktop the replacement works as expected. e.g. the output filename becomes "my_prospect.xls".  When the workspace is published up to FME Server (2013 sp2) as a data download service the workspace runs but the XLS file returned inside the .zip file is called "$(PROSPECT).xls". ie. no parameter substitution is occuring.  Does anyone know how to do this?  thanks, Nic

i have two input tables and i am trying to find all matches that start with attribute 'partial' from the first inputin the attribute 'TAG_ID' from the second inputso i converted all 'TAG_ID' to a list 'tag_list{}.TAG_ID' but when i tried to iterate to do so the error'NoneType' object is not iterableappear to mehere's my code        s = str(feature.getAttribute('partial'))        d =feature.getAttribute('tag_list{}.TAG_ID')        matches = [i for i in d if s in i]  

I am using FME 2022. When I tried to publish data to ArcGIS Porta, I had the error message as below: ArcGIS Portal Feature Service Writer: Encountered an unexpected error. The error code from the server was '409' and the message was: 'Item 'tmps4rtbkh5.zip' already exists.'. Details: '' Translation Failed.I checked my portal site and found FGDB named 'tmps4rtbkh5.zip' has been published but the feature service hasn't been created, but I can download 'tmps4rtbkh5.zip' file to my local drive. Seems FME already publish the data into portal but failed to generate the feature service from the data. Does anyone have any ideas about this?I used FME2019 to publish data to ArcGIS Portal, never had this problem before.Thanks 

Looking at the regular Sample\\austinDownload.fmw.When running this through the GUI with an actual email in Email result to field. The workspace will run, create a datadownload url and notify the topics DATADOWNLOAD_ASYNC_JOB_FAILURE or DATADOWNLOAD_ASYNC_JOB_SUCCESS and send e-mail. That is nice When I DONT write an e-mail. It will NOT notify the topics and it will not send an e-mail.  So far so good. However how to replicate this through the REST-API of FME Server? I found the 8 year old thread regarding this: Using REST API submit, how to send email (safe.com)

I would like to be able to read other tab in ACC. Right now the AutodeskBIM360DocsConnector transformer returns only the list of files within a project which correspond to the first tab. I can't read the other tabs such as reviews or Issues   @david_r​ , @andreaatsafe​ , @Takashi Iijima​  and others , any ideas?

When I update the writer and uncheck "Lower Case Attribute Names" under Table Creation it automatically rechecks it after I close the window. I just want to retain the same field name format from the table I'm reading from.

To create a web service for CKAN connecting to the Open Canada server, I have tried various permutations around https://open.canada.ca/data/en but no luck. Thanks!

Hi there,I have a process in which separate gdb are written and indices are created on specific attributes. The next step of the process merges these separate gdb into one using dynamic writingWhat I want to know is do these settings (creating the indices) are carried over when writing dynamically and if not is it possible to index the specific attributes after the writing? (some python voodoo magic….) Thanks,Itay

I need to connect to SQL Server database hosted on Azure cloud. It is currently blocked within LAN network and we are looking at option to connect to database over SSH or HTTPS. Is it possible to connect to SQL Server database over SSH using FME?

I'm using a schema mapper to update a number of attributes that have string values to a corresponding code. I'd like to catch features where one or more of the attributes to be mapped have a value that isn't in the schema mapping table.  There doesn't appear to be an easy way to do this, since some of the attributes on the feature are mapped, the feature exits the mapped port. Has anyone come up with a good solution for this?

I was following to do a tutorial on "Extracting Data within a Clipping Polygon using FeatureReader" but I do not know how to create published parameters from the Navigator. I am knwe to FME. Can you please help.Regards 

I have been tasked with sorting out 100s of workbenches. In the majority of them the names of the transformers have been customised and should be in annotations rather than the actual transformer name, for easier readability. E.g. SQLExecutor is actually named Table_xxx or FeatureWriter is Named xxx_Output. I'd like to know if there is an easy way to just revert the names back to the original transformers names. I can't find a way myself, other than manually going through each one and changing it myself. EDIT: This is on FME Desktop 2022.1 Thanks!

Hi there,Slightly off the wall here, but has anyone created a workspace that can create Bingo cards? Ideally a 5x3 grid of random numbers between 1-90, but no repeating numbers...?Obviously, RandomNumberGenerator can give us a way to actually play the game...but I'm thinking whether FME can create the cards for users to play with..?Thanks!

Hallo! I have a general question about the dll's on fmeserver. There seem to be a lot of people having problem with this, but I cannot really find a good solution for it. In my company we have many scripts running on the server (2017.1.2.1 build 1775.) In my case I have made sure to use the same version when I develop in fme workbench.Often we have .dll's that can be found but not loaded, and the script doesn't do its job. This causes frustration for our customers. (An interesting perspective is that we didn't have any problems in our test-server, but they started right away on the production-server). We have tried to analyse if there is any systematics in this (specific scripts running just before, changes in python-version, engine-specific etc., but with no good results).Is there a way to get by with this problem? /Anne

Any thoughts on the below error, trying to load data into a Hive table that has columns defined as decimal 11,2Value is 6500, I have also tried stringformatter to 11.2f, and hard coding value to 6500.00, and a few other things like setting the value to double(@Value(my_amount), etc.   Database Error Message: [Cloudera][ImpalaODBC] (370) Query analysis error occurred during query execution: [HY000] : AnalysisException: Possible loss of precision for target table 'xxx.xxxx'. Expression 'CAST(65000 AS DOUBLE)' (type: DOUBLE) would need to be cast to DECIMAL(11,2) for column 'my_amount'

I am writing a WS which is reading an Excel sheet for two Writers which are supposed to write in two different environments (DEV and TEST) As you can see since the source data is same I am using only one stream workflow instead of duplicating the transformers for each writer (DEV and TEST) I have created a User Parameter like this  Now, can someone please let me know where and how should I assign this into the workflow to select the endpoint (Which Writer to be used)?  Thanks