Authoring

I'm using a web connection to an FME Server instance to call an FMEServerJobSubmitter. I would like to trigger a topic to notify an external application that the job was submitted and I would like to include the FME Server hostname in my notification. The FME Server instance that the job was submitted to is not necessarily the same as the instance that the calling job is running on, so I can't rely on the built-in FME Server Parameters.Is there any way that the hostname can be somehow extracted from an FME web connection? Happy to resort to Python or other methods if necessary. I'd like this to be a dynamic solution rather than manually defining the hostname somewhere in my workspace.

I'm used to setting my table qualifier parameter through a published parameter. This worked very well in 2016, but in 2017 it breaks as the table qualifier is automatically populated in the table name field. What can I do?

I just upgraded form Oracle 2017.1 to Oracle 2018 and now I'm having issues with Oracle database connections.I get this 'ORA-12638: Credential retrieval failed' error which is solved by changing SQLNET.AUTHENTICATION_SERVICES= (NTS) to SQLNET.AUTHENTICATION_SERVICES= (NONE) in /oracle home/network/admin/sqlnet.ora.The thing is that after applying that solution when I execute my workspace there's this Warning line in the log:Unable to determine version of Oracle database. (serverType=`ORACLE8I', serverName=`myServerName', userName=`myUserNAme', password=`***', dbname=`').It's confusing because warnings are important in our workflow.Is there anything I can do to make FME know our database version?

I have a text list of Rasters which have to be processed. How do I iterate through each row in the list and use that value as the input for my transformer?

Hi,I was wondering what happens when you upload a workspace into FME Server, is the caching disabled automatically? or is it being cached on the FME Server machine?Thanks,Itay

I am having an issue getting attributes from a custom transformer output exposed in the main workspace.The output in question was added after the custom transformer was created, but appears to me to be all in order. The Population_Base output exposes it's attributes correctly while the Meshblock_Base output doesn't. Here is an image of the Meshblock_Base properties.And finally what it looks like on the Main workspace.I can't figure out why these 2 attributes are not being exposed.Am I missing something obvious, or is there something fishy going on?I am using FME 2018.0 32 bit.

Hi - I am having an issue with FME.exe. I have two FME workbench files - one uses a workbench runner to access the other one. I have run the models successfully in the past, however, this time, the translation log hangs when the model is running. When I check the log file for workbench 1 (that is accessed by the Workbench runner - it confirms that the model is running), however the translation log is different to previous successful translations. When I delete both FME workbenches, the model still continues running using FME.exe. Does anyone have any tips on how to shut FME.exe down to stop it running? I can't access it through Task Manager.Should, in the Workspace Runner, the field 'Wait for Job to Complete' be No or Yes and does that affect FME.exe? Additionally, this model behaves differently on the computer I'm using compared to the computer a colleague uses. It works how it is supposed to on my colleague's computer, vs, the computer I am using. Does anyone have

I am trying to read in the SchemaMapper from a Microsoft SQL Server Non-Spatial table based on a where clause. The value in the where clause depends on the value from another table. So I first read that other table and create an attribute with that value. In the SchemaMapper the configuration is as follows:You can already notice that there are no options to assign an attribute value or open a text editor for the WHERE Clause field.When I run the workspace I get the following error:Microsoft SQL Server Non-Spatial Reader: Query failed, possibly due to a malformed statement. Query Text `SELECT * FROM DataOwner.[RAC_SCHEMA_DEFINITION] WHERE MAPPING_ID = '@Value(MAPPING_ID)''. Provider error `(-2147217900) Conversion failed when converting from a character string to uniqueidentifier.' A fatal error has occurred. Check the logfile above for details SchemaMapper_Mapper(SchemaMappingFactory): Could not read feature: A fatal error has occurred. Check the logfile above for deta

So I have replaced my FileGDB reader with 2 FeatureReaders (one for spatial, one for non-spatial data)What I miss now is the "Feature Read Summary" I was used to get from the "real" reader.Any way to get this summary ?

I want to "deliver" an executable form of a workspace. but not the workspace itself to a third party

I am inserting entries in two Oracle tables. I want to relate the two tables based on primary key (ID). This ID is generated as a sequence in the writer. Is there a way I can get the expected "netxval" ID, so I can set the relation ID-attribute before insertion? Or can I do this in another way?

Has anyone successfully executed an insert\\delete SQL statement to a SQL database via Python in the Shutdown Script?

Hello There we are looking to sync MSSQL DB with PostGIS DB , we used the dynamic workflow in this article https://knowledge.safe.com/articles/1050/dynamic-workflow-tutorial-introduction.html?smartspace=dynamic-workspaceshttps://knowledge.safe.com/questions/55645/dynamic-output-to-sql-server-no-table-qualifierdat.html?%CF%87ldToView=71254#answer-71254we want to do is each time we run this workspace it will update the existing table and create a new table if needed, we configure the writer as shown, the problem how we should know match column parameter in order to execute the update,

Hi there,  I've developed a FME-workspace with user-parameters. One of the Parameters is a defined "Choice-Parameter". On Desktop it works fine, the same on FME-Server.  I'm also using the Url for the workspace to submit the request in a Browser. Now it's possible to alter the Choice-Parameter with some fantastic values (Example: Choice-Parameter: "Numbers: 1|2| 3"; in URL written Value: "Numbers: 4"). The result I receive is empty, as expected. But the Workflow "completed successfully" too.  My question: Is there a possibility to force the FME-Server in a "Failed", when the defined Parameter got a wrong value?  Thanks for your help,  Greetings,  André

Hi,I'm investigating the impact that the move to remove https support for TLS1.1 and below may have on my processes running in fme desktop and server.Does anyone know what http clients the httpcaller uses?I assumed it was the client installed on the OS, but i'm running fmeserver/desktop on a windows2008R2 server with IE8 installed. If i look at a TLS1.2 only site using IE8 on this server it complains like mad because i'm trying to use TLS1.0, but if i use the httpcaller from inside fmedesktop and server it connects just fine using TLS1.2. Leading me to deduce FME installs and uses it's own client. I would like to know what it is. (libcurl_fme.dll probably has something to do with it? i also noticed an ssl certificate in the install dir.)It must pick up internet proxy details from the default browser though right?regards,Nick(specifically i'm currently running FME 2015.0, but i'm looking to upgrade to 2018.1)

Hello There we are looking to update a table with the new attribute called layer the value will be populated by searching a keyword into the attribute ( Type ) that should contain the keyword in the lookup table there is w way to do it by using the conditional value on the attribute value and writing all the key word there, but this will be a long task and not simple to maintain. since data is so bigwe are looking to use the existing excel to maintain the lockup and then search only the keyword into the value of the attribute Any suggestions?Table Dig_lcn Type Status 125 Electric network open 126 New Phone line open 127 sewer conduite intalation closed 128 Mv electric ntework closed 129 sewer renwell conduct openif the attribute value containe the keyword in the lockup table Lockup ID layer 1 Electric 2 Phone 3 sewerthen we get this Final result Dig_lcn Type Status ID L

i am having trouble "reading" the grb2 files from the workspace runner. i can run the FME script that reads and processes the grb2 files with no issue, but when i try to call that FME script from the workspace runner FME script, nothing happens. any assistance would be helpful!i can zip up and provide the workspaces and underlying data if needed.thank you

Hey guys,I have a dynamic feature reader that reads and SDE database, one of the fields is a date time field called UFI_CREATEDWhen i use a standard SDE reader this works fine on the dynamic writer. But when I use the feature reader, it appears that its sending the full attribute into UFI_CREATED.full and date attribute called UFI_CREATED. When I try and write this I get an error saying thatA feature, of feature type 'PROPERTY', had an invalid time component for its time/datetime attribute 'UFI_CREATED'.This is because its expecting the .full attribute but dynamically its getting the shortened one.I could change all the attributes that I think might be affected manually back to non full, but this defeats the purpose.Why is it mapping it like this? And is there any way I can prevent this from happening.Regards,James

Hi,I'm doing a bit of testing with OneDriveConnector and Emailer. My workspace writes an Excel file out using FeatureWriter and then uploads that file to OneDrive. I want to insert the '_sharable_link' attribute, created in the OneDriveConnector, into the body text of the Emailer. However, the Emailer appears to get rid of the value in the '_sharable_link' attribute, therefore the hyperlink <a href="@Value(_sharable_link)">Output</a> doesn't work in the resulting email.Has anyone come across this before? Or in the more likely scenario, am I missing something obvious?Thanks!

I have what seems like a simple thing I need to do. I have a webpage with a java button on it. The result of pressing that button downloads an xls file that is the data I need. I'd like FME to be able to go to that URL and press that button, but I can't figure out how to get the HTTPCaller to hand the java code and then capture any response. Maybe it's not the HTTPCaller I need?I'm pretty new to FME. The URL is inside a fire wall, but it's a basic https URL. Inspecting the button shows this code.<button title="Excel" onclick="cfExportData('xls', 146014343, 'WorkItemEvents:146014343', 'WorkItem,EventName,EventStartDate,Notes', '')">XLS</button>What do I need to do to hand FME a static URL and get it to run this cfExportData command from above and then capture the resulting file download?Any tips/help would be great. Thanks

Good afternoon,How would I poll a REST Service, check the value of a attribute (e.g. status), sleep if the attribute is not yet "completed" and then retry? (Ideally I'd implement a short-circuit if the time is exceeded, e.g. expose a attribute in Python and add a Tester). In this diagram, it seems FME explicitly prevents the possibility of a looping structure? Do I need to either:Place the last REST API call into Python and do the looping within there ... ORInvestigate this article: "Looping with a Blocking Transformer" ?http://docs.safe.com/fme/2017.1/html/FME_Desktop_Documentation/FME_Workbench/Workbench/looping_with_blocking_transformer.htm Cheers.

Hi,I am new in using FME and it seems that there are something that I am missing, I found the "CoordinateConcatenator" transformer that I think can do what I need. I open my shape file as a reader ,I choose the CoordinateConcatenator transformer and then I choose a new shapefile file as writer (output).It runs with no error but no new attributes containng the coordinated of the vertices in the output file.I tried to add attribuet creator, attribute writer ,nothing works ,what am I missing?Thanks for your help!

Hi, I have an oracle db I would like to connect to from FME Cloud. I can reach it on desktop but I have the client installed locally. Can anyone point me to a link on how to connect, I have had a look but couldnt find anything.Thank you

I have a scenario where I need to dynamically read in some data (FeatureReader), do a bit of filtering and write it out dynamically with the FeatureWriter and then continue processing.  Since there's no reader to point to in the Dynamic Schema Definition Schema Sources, I'm using "Schema From Schema Feature". This creates the correct output file with the correct number of features. However, the Summary port feature is including the schema feature in the _total_features_written attribute, so is one more than the number of features recorded in the log, and also outputs it through the Feature Output Port. Is this the desired behaviour?  

Hi,I'm trying to make a script that will replace/erase some of words from table of strings.I want to create list of key words in a Published Parameter (multiple choice) that will be piked by user. When I pick one KeyWord script works fine but with more doesn't work at all. How can I make it to loop through all picked words?str1 is with Published Parameter andstr2 is with list of words, but there should be more of them so it will look horrible ;)EDIT: words are single. Additional problem I have now is how to make them be whole words only eg. Landhotel shouldn't be erased HOTEL, only Land Hotel -> Land.And additional question is there a way to replace RegEx matching with sth shorter? I'm new in scripting so my code is vary basic :)I have such a script in PythonCaller:import fmeimport fmeobjectsimport redef KeyWord_replacer (feature):    str1 = feature.getAttribute('Name')    str2 = feature.getAttribute('Name2')    keyW = FME_MacroValues['KEY_WORDS']    str1 = str1.lower()    str2 = st