Authoring

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) However have there been some changes on the REST API the last 8 years to better handle this?   

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   

How does one pass a user parameter to a pythonCaller that's inside a customTransformerimport fmeimport fmeobjects def processFeature(feature):    p = FME_MacroValues['SomeUserParameter']    print p I read here "If you put your pythonCaller inside a custom transformer, the parameter name changes to {customTransformerName}_SomeUserParameter. "I tried then doing this below but still does not work.import fme import fmeobjects  def processFeature(feature):     p = FME_MacroValues['{customTransformerName}_SomeUserParameter']          print p What am I doing wrong? 

AllI am having trouble automating some workspaces as the data and folders that I receive are containing dates in the format MMMYYYY as shown below...\\\\server\\FMEData\\DataDownloads\\Supplier\\Data\\Data\\Name_Mar2020 The files are supplied as shapefiles and they are also named Name_Mar2020.shp etcHow can I automate the running of these workspaces for when the folder or file name changes to the next month?? I have tried using the * in various places, but to no avail and don't want to have to run these manuallyI know this is something obvious, but just cant figure it out... Regards  

I've created a custom transformer which I think can be of use to other FME enthousiasts. I want to upload it to FME Hub as described here Publishing an Item to the FME Hub (safe.com). It states that it is best practice to upload an test workspace as well, but the information provided on how to do that is minimal. Is there somewhere a template available?

Nel livello in cui devo selezionare i dati, devo applicare l'espressione Area >1

Hi when I run the exercise-workspace-prototyping.fmw I received this error  can you help ? thx  Francesco 

Hello,I'm working with FME Desktop 2015 with a WorkspaceRunner transformer calling several workspaces where i have to use an environment variable in the path of some private variables.For example: %ENVIRONVAR%\\dat\\myfile.txtThe problem is that the called workspaces don't recognize the value of the environment variable defined by the Windows System. I have tried to assign the value to the environment variable inside the workspace but it is not a good solution in this case because every PC could have a different value.Is there some example about to do solve this problem?Many thanks in advance!A.